i need to convert the mysql database so i can use the games on my site gamerfreak.net.
Code:
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',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
FULLTEXT KEY `title` (`title`,`description`)
) TYPE=MyISAM;");
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);");
-----------------
GameScript Format
-----------------
CREATE TABLE `games` (
`gId` bigint(20) NOT NULL auto_increment,
`gInCategory` mediumint(9) NOT NULL default '0',
`gSwfFile` varchar(200) NOT NULL default '',
`gName` varchar(100) NOT NULL default '',
`gOrder` bigint(20) NOT NULL default '0',
`gVisible` tinyint(1) NOT NULL default '1',
`gThumb` varchar(200) NOT NULL default '',
`gWidth` varchar(8) NOT NULL default '',
`gHeight` varchar(8) NOT NULL default '',
`gDescription` varchar(100) NOT NULL default '',
`gplays` mediumint(45) NOT NULL default '0',
`description2` text NOT NULL,
UNIQUE KEY `gId` (`gId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1060 ;
--
-- Dumping data for table `games`
--
INSERT INTO `games` VALUES (1, 5, 'game_224.swf', 'Classic Blackjack', 0, 1, 'icon_224.gif', '550', '400', ' A nice, classic game of blackjack. Need I say more?', 13, '');
INSERT INTO `games` VALUES (2, 5, 'game_535.swf', 'Build-A-Robot', 0, 1, 'icon_535.gif', '700', '470', 'Build your own robot in this excellent dress-up game. Instead of those ''doll-dress'' games, we have a', 19, '');
INSERT INTO `games` VALUES (3, 5, 'game_520.swf', 'Bullet Dodge', 0, 1, 'icon_520.gif', '550', '400', 'You''re on top of a building and completely at the mercy of 3 terrorists with guns. Dodge them in eve', 135, '');