I just finished a 700+ game fix mate smile.gif

Using Windows LOL

"I have a strong feeling you will find an instant solution to my problem on which i spent almost 2 hours but what the hell... let me throw it :

I had 1648 games installed into MySQL and extracted into /arcade/ folder.

The plain SWF files go to /arcade

Game images go to /arcade/images

Supplemental data goes to /arcade/gamedata

TARs go to /arcade/tar

A TAR is named game_gamename.tar and it always extracts at least those files:

gamename.php
gamename1.gif ( small image )
gamename2.gif ( small image )
gamename.swf ( small image )

Once u install a TAR, it self extracts and opens the PHP file which in turn will inject data to MySQL and moves images to appropriate folder and swf too. Additional data as well.

The game id in MySQL is unique and it is in any case gamename 9 what follows the game_ prefix )

Missing the Arcade contents i looked for backups.

Found a rather old one which to my luck had 900 games in it. Still missing 700. I thought of removing incorrect files ( there is an option in the script to remove all games missing parts like SWF or GIF files ) but i did not like to delete anything from the database.

So i should open all game_1.tar , game_2.tar etc and put all files in the appropriate folders... but i would need to have the MISSING only game names and then pick those from a collection of 6000+ files.

By hand...

My course is crazy but i am proud of it nonetheless:

1. Copy all 6000+ files at a backup location

2. Rename all files, trimming game_ ( first five chars ) using Magic File Renamer, http://www.finebytes.com/mfr/

3. I am missing all files from 866 to 1505 with that number being the game number according to installation time...

each game is linked like http://www.yourforum.gr/InvisionBoard/inde...gameid={number}

so we miss from http://www.yourforum.gr/InvisionBoard/inde...&gameid=866 to http://www.yourforum.gr/InvisionBoard/inde...amp;gameid=1505

4 OpenedhpMyAdmin, then extract the table which contains the game data from the database... the table exported fine to Excel and it had the autonumber feature showing the installation order, so i dumped 866 to 1505 to a worksheet.

5. I installed a fine utility named SearchWin, http://searchwin.software-by-dalesplace.qarchive.org/ which allows BOOLEAN searches using OR so i could commit multi term search in a folder with XP instead of Vista

6. I opened the EXCEL data, copypasted the entire column with the gamename data to a new worksheet and then i used CONCATENATE command to create sentences of the games separated by spaces... then i pasted the result of 600 concatenated lines as simple values to SearchWin.

7. Moved all missing games i found in the utility to a new folder

8. Extracted all TARs in that folder. Then deleted all PHPs since i am not installing. Then created a folder named images and put all GIFs in.

9. Then started uploading images , gamedata folders and all SWFs into /arcade...

10. Need sleep !"


View the full article