Mysql Expert - Convert GameScript db to ShockScript db

Discussion in 'Services' started by creepah, Jan 15, 2006.

  1. #1
    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 :)

    
    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, '');
    
    Code (markup):
     
    creepah, Jan 15, 2006 IP
  2. PinoyIto

    PinoyIto Notable Member

    Messages:
    5,863
    Likes Received:
    170
    Best Answers:
    0
    Trophy Points:
    260
    As Seller:
    100% - 0
    As Buyer:
    85.7% - 6
    #2
    how much your budget for it.... I can do it for a day
     
    PinoyIto, Jan 15, 2006 IP
  3. creepah

    creepah Peon

    Messages:
    313
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    send me a quote please via pm.
     
    creepah, Jan 15, 2006 IP
  4. japindian

    japindian Peon

    Messages:
    666
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    Hey if this was translated ill buy the services again...please pm me a quote
     
    japindian, Feb 1, 2007 IP