Convert DB To be Compatible with Shockscript


I have a SQL DB w/ thumbnail images + .swf files of 500 games.

I need you to convert the DB to work with shockscript. The DB is made for

You need to install all 500 games. It doesn't really matter how you do it, as long as it's completely working and it's not hacked and chopped up. You can modify the PHP code if needed.

Here is the DB structure for both:

ShockScript Format


mysql_query("DROP TABLE IF EXISTS `games`;");

mysql_query("CREATE TABLE `games` (

`id` int(4) NOT NULL auto_increment,

`title` varchar(150) NOT NULL default '',

`url` varchar(150) NOT NULL default '',

`category` int(3) NOT NULL default '0',

`description` varchar(250) NOT NULL default '',

`plays` bigint(20) NOT NULL default '0',

`date` int(10) NOT NULL default '0',

`today_plays` bigint(20) NOT NULL default '0',


UNIQUE KEY `url` (`url`),

FULLTEXT KEY `title` (`title`,`description`)


mysql_query("INSERT INTO `games` VALUES (1, '3 Foot Ninja', '3-foot-ninja', 1, 'Cool online fighting game, great fun is to be had by all', 48, 1115486906, 0);");

mysql_query("INSERT INTO `games` VALUES (10, 'Mars Mission', 'mars-mission', 1, 'Cool alien invaders game, great fun!', 43, 1115486908, 0);");

mysql_query("INSERT INTO `games` VALUES (100, 'Golden Arrow', 'golden-arrow', 2, 'Score as many points as you can.', 73, 1115486910, 0);");

Gamesitescript DB ( This is the DB that I will give you )


INSERT INTO `games` ( `id` , `nameid` , `name` , `desc` , `time` , `width` , `height` , `cat` , `type` , `authorsite` , `authorname` , `gameurl` , `code` , `playcount` , `flags` , `instructions` , `keywords` , `disphtml` , `disphtmlcode` ) VALUES ( '', 'game_adventures-of-a-space-cowboy', 'Space Cowboy', 'Take on the role of Space Cowboy as you navigate a distant planet.', '%time%', '550', '400', 'Shooting', 'SWF', '[url removed, login to view]', 'Online Games', '', '', '0', '', '', '', 'Config', '' );

Please note, you may have to rename .swf/.png thumbnails to work, I don't know. You could edit the PHP to work if needed. You tell me.


Skills: PHP

See more: swf convert, the w games, the golden 1, sql ninja, primary games com, primary games, int i, golden 1, fun with, fun points, 3-1 table games, shockscript install, convert shockscript, gamesitescript 3000 games null, t-sql with, create, cat, arrow up, cool games, shooting, s+db, rename, primary, plays, planet

About the Employer:
( 0 reviews ) New York, United States

Project ID: #45283