This databse contains inforamtion about cheats.
Platforms: 16
Games: 9 265
Structure:
Code:
CREATE TABLE `cheats` (
`id` int(6) NOT NULL auto_increment,
`hits` bigint(21) NOT NULL default '1',
`votes` bigint(21) NOT NULL default '1',
`rating` decimal(2,1) NOT NULL default '5.0',
`title` varchar(250) NOT NULL default '',
`cheats` text NOT NULL,
`console` varchar(50) NOT NULL default '',
`letter` char(1) NOT NULL default '',
PRIMARY KEY (`id`),
FULLTEXT KEY `cheats` (`cheats`),
FULLTEXT KEY `title` (`title`,`cheats`)
) TYPE=MyISAM ;
Example record:
Code:
INSERT INTO `cheats` (`id`, `hits`, `votes`, `rating`, `title`, `cheats`, `console`, `letter`) VALUES (19101, 1, 1, 5.0, 'Super Puzzle Bobble All-Stars', '<p><h4>Another World</h4>Press Y, Left, Right, Y at the "Push Start button" screen. A message will appear in the top right corner of the screen to confirm correct code entry. Select puzzle mode and then arcade mode to access additional levels.</p><p><h4>Secret characters</h4>Press Y, Right, Left, Y at the "Push Start button" screen. A message will appear in the top left corner of the screen to confirm correct code entry.</p>', 'GameCube', 'S');
Price: 15$
