how to check for double(more then one same game in the data base)

someone100 · 10-01-2008, 05:45 PM

if i add few data base together ?

gameserpent · 10-01-2008, 06:40 PM

man that would be almost impossible if they have different names. If they have the exact same names (file name or game name) then it would be a simple mysql query

flashtrackz · 10-02-2008, 03:43 AM

Quote:

Originally Posted by gameserpent

man that would be almost impossible if they have different names. If they have the exact same names (file name or game name) then it would be a simple mysql query

It turns out to be relatively straightforward... I just referenced how to do it here:

HUGE Game Pack - 7000+ Records - $29.95 - Support for GSS, phpAS, GS.net, FGS, AV

gameserpent · 10-02-2008, 07:15 AM

That's not exactly straight forward.

While it is easy to md5sum a file your explanation is lacking a bit. The OP still needs a way to automate this to check all his files in a scripted fashion which would also need to include a way to list the files that needed to be deleted.

Unless you give him some example code to do that.....it is not a straight forward affair for most people to whip up that kind of script.

Edit:
To the OP:

Don't know how proficient you are on the command line but maybe this link will get you started down the track Flashtrackz is pointing you down.

http://www.brunolinux.com/02-The_Ter...nd_Md5sum.html

flashtrackz · 10-02-2008, 10:39 AM

Quote:

Originally Posted by gameserpent

That's not exactly straight forward.

While it is easy to md5sum a file your explanation is lacking a bit. The OP still needs a way to automate this to check all his files in a scripted fashion which would also need to include a way to list the files that needed to be deleted.

Unless you give him some example code to do that.....it is not a straight forward affair for most people to whip up that kind of script.

Edit:
To the OP:

Don't know how proficient you are on the command line but maybe this link will get you started down the track Flashtrackz is pointing you down.

http://www.brunolinux.com/02-The_Ter...nd_Md5sum.html

Yes, there is definitely some scripting involved... On the import side, all I do is avoid importing each game I already have. So when he's joining databases, first institute a check to see if game B's md5 value already exists in database 1's game table. If it does, poof, move on. If it doesn't go ahead and add it like you normally would. This requires 2 sqls call per game insert - one select for the check, one 'insert' for the import.

The script to backfill hashes is really not that bad though. You hash the file, connect to the database, and insert the hash value for your game into the game's new md5 column.

I actually use sha1 (same diff) and besides the sha1 routine which you'll find pre-canned out there, all it took was literally what I said above - 2 SQL calls and very few lines of code to do it all. Your mileage may vary!

Depending on what your tables look like, the first sql might be something like:

select gameid,gamefile from games where gamemd5 IS NULL;

iterate through the responses, generating a hash per file, and insert the data into the corresponding gameid's gamemd5 column.

10-01-2008, 05:45 PM	#1 (permalink)
someone100 Contributing Member Join Date: Sep 2008 Posts: 30 iTrader: (0)	how to check for double(more then one same game in the data base) if i add few data base together ?

10-01-2008, 06:40 PM	#2 (permalink)
gameserpent Senior Member Join Date: Apr 2007 Posts: 340 iTrader: (0)	man that would be almost impossible if they have different names. If they have the exact same names (file name or game name) then it would be a simple mysql query __________________ ~

10-02-2008, 07:15 AM	#4 (permalink)
gameserpent Senior Member Join Date: Apr 2007 Posts: 340 iTrader: (0)	That's not exactly straight forward. While it is easy to md5sum a file your explanation is lacking a bit. The OP still needs a way to automate this to check all his files in a scripted fashion which would also need to include a way to list the files that needed to be deleted. Unless you give him some example code to do that.....it is not a straight forward affair for most people to whip up that kind of script. Edit: To the OP: Don't know how proficient you are on the command line but maybe this link will get you started down the track Flashtrackz is pointing you down. http://www.brunolinux.com/02-The_Ter...nd_Md5sum.html __________________ ~

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Arcade Script Reviews	arcadillo	Scripts & Software	6	08-08-2008 02:35 AM
PR5 Arcade Site 5,000 UV	Doug	Link Exchanges	9	04-10-2008 02:51 PM
ArcadeScript.com - where Social Networking meets High Score Flash Games	Varchar	Scripts & Software	9	12-01-2007 05:45 AM
Places to submit games	webbom	Marketing	1	07-25-2007 06:16 AM
Have an Arcade? Need Games? 2229 Games Inside!!!	admin	Game Packs	3	09-15-2006 10:30 AM