Have about 2000 games uploaded but want a new arcade script which will work with this SQL structure
EG
50np$ to the person who can suggest a script which it will work with.
Tom
CREATE TABLE `games` (
`id` int(10) NOT NULL auto_increment,
`nameid` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
`time` int(10) NOT NULL default '0',
`width` int(10) NOT NULL default '0',
`height` int(10) NOT NULL default '0',
`cat` varchar(255) NOT NULL default '',
`rating` decimal(3,2) NOT NULL default '0.00',
`type` enum('SWF','extlink','DCR','CustomCode') NOT NULL default 'SWF',
`authorsite` varchar(255) NOT NULL default '',
`authorname` varchar(255) NOT NULL default '',
`gameurl` varchar(255) NOT NULL default '',
`code` text NOT NULL,
`playcount` int(10) NOT NULL default '0',
`weeklyplays` int(10) NOT NULL default '0',
`flags` varchar(255) NOT NULL default '',
`instructions` text NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`disphtml` enum('Config','No','Yes') NOT NULL default 'Config',
`disphtmlcode` text NOT NULL,
`order` int(10) NOT NULL default '0',
`active` enum('Yes','No') NOT NULL default 'Yes',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1698 ;
EG
INSERT INTO `games` VALUES (10, 'RT3Game', 'Railroad Tycoon 3', 'Get your choo-choo train across the screen in the time given by using drag and drop pieces to complete your train track.', 1169236825, 680, 430, 'Other', 0.00, 'SWF', '', '', '', '', 2, 2, '', 'Drag and drop pieces from the left hand side of the screen onto the map to complete a train track that goes from the start to the station. You have 3 bombs to take care of tracks that do not align with the rest of the track.', '', 'Config', '', 10, 'Yes');
50np$ to the person who can suggest a script which it will work with.
Tom





