68 Comments
- ramreezy, on 10/12/2007, -2/+5I digg the everloving sh!t out of this article. Dood in my office used it and we're up and running.
- Stopher, on 10/12/2007, -0/+2Dios mio!
- DisembarkedOne, on 10/12/2007, -0/+2I agree with BadMan. I've modified the code alittle to fix some of the annoyances. Will probably release it when I make enough changes.
- jesusphreak, on 10/12/2007, -0/+2>>> WTF! Why would anyone want to do this? >>>
Lol...I love comments like this. Its like they killed a 5 year old or something. Believe it or not, some people would love the functionality of Digg minus the community.
>>> Anyway, the value of the site isn't really in the script, but the community. >>>
If you say so. - ZmasteR, on 10/12/2007, -0/+1i speak fluent spanish if u want me to do a real translation...email me and ill hook u up!
email iz ZmasteR.AES[note the dot between the words][AT]gmail.com - funkytaco, on 10/12/2007, -0/+1can you change the utf_spanish_ci to utf_english_ci ?
- skxy, on 10/12/2007, -0/+1I don't understand how so many people keep calling this a "ripoff". Sure the code here is probably going to never see the light of day, and sure we have a lot of users - but it isn't like the site is patented or anything.
There are a million and one slashdot-clones, they aren't ripoffs are they? They are just clones.
The real value of Digg is the large userbase who actively seeks out and submits news. If I were to install this code upon my site I'd most likely never receive a single visitor, or get a sufficiently critical mass that it was worthwhile. (Thankfully my time is already taken up running a slashdot-clone, which I don't consider a ripoff; different code, and a different target audience.) - Midget, on 10/12/2007, -0/+1EXACTLY the help i needed to fully utilize this proplerly!
- ignazio, on 10/12/2007, -0/+1http://meneame.net/story.php?id=672
Meneando digg & Digging meneame. - amandaworld, on 01/14/2008, -0/+1crapola for sure...don't bother
- skxy, on 10/12/2007, -0/+1Sure that gets the database up and running, but then what? (Note I'd just replaced CURRENT_TIMESTAMP with 'NOW()' to insert the current date + time).
After creating your user you'll be able to submit entries and see them in the queue. (The links table will have link_status='queued' for new submissions). To promote them to the front-page you must rename 'libs/promote-example.php.txt' to 'promote.php' - load that in a browser and it will take care of setting up the front page and changing the stories to 'published' which deserve them.
The other example file I see is 'karma-example.php.txt', not 100% sure what that is for.
If the new stories are complaining they are invalid make sure the title is longer than 10 characters, and the description is longer than 30 characters - see the tail of submit.php for the checks. - BadMan, on 10/12/2007, -0/+1Another thing of note is that the code isn't very well written... No abstraction layer, no language file... I guess it would work O.K. but not very well designed. It would be nice if they did a better job of seperating the code from the display.
- TheTraveller, on 10/12/2007, -0/+1This "howto" is pretty much useless. It forgets to mention that you need MySQL 4.1.x or higher to use the provided sql commands. If you wanna try it on a 4.0.x installation, open the sql file and make the following changes:
delete all instances of ' collate utf8_spanish_ci'
delete all instances of ' DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci'
delete all instances of ' default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'
delete all instances of ' default CURRENT_TIMESTAMP'
Then open your phpMyAdmin or whatever you use and enter the create table commands one by one. You should get no more SQL errors then. There are more elegant ways than just deleting this stuff, but this worked fine for me.
What's left is a little understanding of PHP as you will have to code in the timestamp handling for modified links, comments etc. in the actual PHP files, as 'default CURRENT_TIMESTAMP' does not work in MySQL 4.0.x - inactive, on 10/12/2007, -0/+1disembarkedone, why don't you help people, instead of just posting useless crap like you did in your last comment?
- exoendo, on 10/12/2007, -0/+1did enough people report this or did the site get removed from the homepage by digg itself?
Funny how kevinrose loved talking about open source on tv but when the shoes on the other foot.... - quietk, on 10/12/2007, -1/+2haha the spanish slashdot http://barrapunto.com/
- dogas, on 10/12/2007, -0/+1robrff - this is mysql 5.0 code.. make sure you're not using mysql 4.x. If you are, replace "ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0;" with "TYPE=MyISAM;"
- tekkster, on 10/12/2007, -1/+1Hey WHo came first DIGG or Meneame????
- BadMan, on 10/12/2007, -0/+0One thing that is intersting is that although all the errors and actual text is written in spanish, the code was actually done in english (variable names, table names, etc). I wonder if this code was "borrowed" from digg somehow and then modified to the spanish language...
- dogas, on 10/12/2007, -0/+0I agree with disembark.. not only is this a really easy schema, it should be a no-brainer to import it into mysql.
robrff - select all the sql you see there, stuff it into a file (digg.sql), log into mysql and run 'source digg.sql', and presto, there's your schema. - veeno, on 10/12/2007, -0/+0This links to the actual code (which was front page this morning as wonky said):
http://digg.com/programming/Spanish_Digg_Code_Released - inactive, on 10/12/2007, -0/+0I get an SQL error when trying to dump the database! What is the problem others are having??
- dumbkiwi, on 10/12/2007, -1/+1Wow code written in Spanish. If only they'd used php, people might have understood it better.
- DisembarkedOne, on 10/12/2007, -0/+0on a serious note.. remove the whole line..
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0;
so it should be
);
and that should work. - dangarion, on 10/12/2007, -0/+0I've got it installed but unfortunately ever time I try to submit a story it says it's invalid.
- scot, on 10/12/2007, -0/+0SQL installs fine ... PHP code looks nasty get lots of fatal errors call to undefined function _
- beatniak, on 10/12/2007, -0/+0Agree, but still very nice
- francois, on 10/12/2007, -2/+2The askeet tutorial on www.symfony-project.com is much easier to read and provides details to build a digg-like application in PHP. Plus, it's in english.
- DisembarkedOne, on 10/12/2007, -0/+0dogas, need help? rtf mysql manual
- d1337, on 10/12/2007, -1/+1I've been waiting what seems like my entire life for something like this. Thanks for posting!
- inactive, on 10/12/2007, -0/+0Still not working, maybe I am just too dumb for this :D
- MLyzz, on 02/04/2008, -1/+1Edina Apartments Steals Money
http://the1gripe.blogspot.com - carguy84, on 10/12/2007, -0/+0Can you copyright a web page design?
- jesusphreak, on 10/12/2007, -0/+0Man, this story is going ballistic. Back and forth on the frontpage.
- ZmasteR, on 10/12/2007, -0/+0good job i speak spanish :-P hahaha been waiting ages for some digg style code
- smhill, on 10/12/2007, -0/+0People actually needed instructions? If you need instructions on how to do that you probably shouldn't be messing with it in the first place. Download, unzip, import db, change settings.
Though nice spam with the huge freaking ad on the initial post's site. - a1programmer, on 10/12/2007, -0/+0Why did anyone digg this in the first place. This shold have never made the first page. If anyone knows anything about phpmyadmin, it's not this.
- exoendo, on 10/12/2007, -0/+0i've been programming in php and using mysql for 2 years and I'm getting errors as well.. somethings up . .
- jesusphreak, on 10/12/2007, -0/+0"WTF! Why would anyone want to do this?"
Ha...you act like they killed a 5 year old or something. Believe it or not, some people want the functionality of Digg without the community.
"Anyway, the value of the site isn't really in the script, but the community."
If you say so. - exoendo, on 10/12/2007, -0/+0I've been using php and mysql for two years and I'm getting errors too... somethings up...
- swight, on 10/12/2007, -0/+0What we REALLY need is instructions for replacing all the spanish with english!
Someone fluent in both can do that and release it. I would if I could!
But when spanish translations through babelfish come out as "to wag the news", I get a little lost. - jesusphreak, on 10/12/2007, -0/+0Why does this story continue to go on and off the frontpage?
- curt, on 10/12/2007, -0/+0Thanks for posting this.
- Rice, on 10/12/2007, -0/+0jesusphreak, usually that happens while a new feature is being added to digg. You'll see most stories going through this cycle right now.
- Visceral, on 10/12/2007, -0/+0Interesting. I'm running mysql 5.0 and get the same errors some of the others appear to get when importing the file.
- a.wulf, on 10/12/2007, -0/+0Anglophones....
- artur.ventura, on 10/12/2007, -1/+0does any one could make it work?
- spybreak, on 10/12/2007, -1/+0bschroeter: yeah: mannl at gmx dot com
- mushoo, on 10/12/2007, -1/+0^^^^you can keep him.
- KicktheDonkey, on 10/12/2007, -1/+0Yeah... Its so weak, that it DOESN'T WORK!
No digg -
Show 51 - 63 of 63 discussions



What is Digg?
Digg is coming to a city (and computer) near you! Check out all the details on our