Mysql Expert - Convert GameScript db to ShockScript db - Webmaster Forum

01-16-2006, 12:10 AM

creepah

Status: Member
Join date: Dec 2005
Location:
Expertise:
Software:

Posts: 109

iTrader: 0 / 0%

creepah is on a distinguished road

Mysql Expert - Convert GameScript db to ShockScript db

Basicly i have brought the 1050 game pack from gamescript.net

i need to convert the mysql database so i can use the games on my site gamerfreak.net.

GamerFreak is powered by the famous ShockScript.

If you can do this pm me a timeline and quote please

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, '');