| JakeS |
03-14-2006 01:54 AM |
Quote:
Originally Posted by Red Blaze
I followed the stupid upgrade instructions and everything on the games got removed once I reached step 3. I had a stressful day, and this damned upgrade made it worse. Although it upgraded successfully, step 3 is NOT necessary to do. Damn bastard.
Got that error when I tried to "import" my "old" games and scores.
|
whats your table prefix?
If you dont have a table prefix you just need to go into phpmyadmin -> select your database, then click sql at the top and run this query.
Quote:
--
-- Table structure for table `arcade_games`
--
CREATE TABLE `arcade_games` (
`gameid` int(10) unsigned NOT NULL auto_increment,
`shortname` varchar(100) NOT NULL default '',
`title` varchar(100) NOT NULL default '',
`description` mediumtext NOT NULL,
`file` varchar(100) NOT NULL default '',
`width` smallint(4) unsigned NOT NULL default '550',
`height` smallint(4) unsigned NOT NULL default '400',
`miniimage` varchar(100) NOT NULL default '',
`stdimage` varchar(100) NOT NULL default '',
`gamepermissions` int(10) unsigned NOT NULL default '7',
`highscorerid` int(10) unsigned NOT NULL default '0',
`highscore` float(15,3) NOT NULL default '0.000',
`gamehash` varchar(50) NOT NULL default '',
`categoryid` int(10) unsigned NOT NULL default '1',
`timesplayed` int(10) unsigned NOT NULL default '0',
`dateadded` int(10) unsigned NOT NULL default '0',
`system` tinyint(1) unsigned NOT NULL default '0',
`votepoints` int(3) unsigned NOT NULL default '0',
`votecount` int(6) unsigned NOT NULL default '0',
`sessioncount` int(10) unsigned NOT NULL default '0',
`minpoststotal` int(10) unsigned NOT NULL default '0',
`minpostsperday` int(10) unsigned NOT NULL default '0',
`minpoststhisday` int(10) unsigned NOT NULL default '0',
`minreglength` int(10) unsigned NOT NULL default '0',
`minrep` int(10) NOT NULL default '0',
`isreverse` tinyint(1) unsigned NOT NULL default '0',
`cost` decimal(30,5) unsigned NOT NULL default '0.00000',
PRIMARY KEY (`gameid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;
--
-- Dumping data for table `arcade_games`
--
INSERT INTO `arcade_games` VALUES (96, 'tetris', 'Tetris', 'A classic puzzle game that will keep you entertained for hours.', 'tetris.swf', 382, 380, 'tetris2.gif', 'tetris1.gif', 7, 0, 0.000, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00000);
INSERT INTO `arcade_games` VALUES (98, 'spaceinvaders', 'Space Invaders', 'Space Invaders is that game that started it all. Battle against aliens in a desperate attempt to save earth from total destruction.', 'spaceinvaders.swf', 550, 400, 'spaceinvaders2.gif', 'spaceinvaders1.gif', 7, 0, 0.000, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00000);
INSERT INTO `arcade_games` VALUES (99, 'snake', 'Snake', 'The mobile phone classic, "Snake" can now be played on your PC! Save your phone battery and play to get a high score on the leaderboard', 'snake.swf', 360, 300, 'snake2.gif', 'snake1.gif', 7, 0, 0.000, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00000);
INSERT INTO `arcade_games` VALUES (100, 'asteroids', 'Asteroids', 'The arcade classic returns! Blast your way through asteroids and the occasional flying saucer to hit the top of the leaderboard.', 'asteroids.swf', 500, 375, 'asteroids2.gif', 'asteroids1.gif', 7, 0, 0.000, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00000);
INSERT INTO `arcade_games` VALUES (101, 'chopper', 'Chopper Challenge', 'Flying a helicopter through an obstacle course... Sounds dull? It''s harder than it looks!', 'chopper.swf', 400, 300, 'chopper2.gif', 'chopper1.gif', 7, 0, 0.000, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00000);
|
if you have one then tell me an i'll update that to your table prefix. |
More Information