[gundelpfanne]

Hello

I have fixed the sql code.
It works for me.
I have no sound in the game , but I do not know why.
Open the " product-battleships (deutsche Master).xml or the english version"
Delete the old code from:

$db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `battleshippermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");


to the last:
) TYPE=MyISAM;");

And paste the new code from me .

$db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `battleshippermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
				$db->query("ALTER TABLE `" . TABLE_PREFIX . "administrator` ADD `custombattleshippermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
				
				CREATE TABLE IF NOT EXISTS `battleships_game` (
				  `gameid` int(11) NOT NULL default '0',
				  `player1` int(11) NOT NULL default '0',
				  `player2` int(11) NOT NULL default '0',
				  `maxpl` int(11) NOT NULL default '0',
				  `turn` int(3) NOT NULL default '1',
				  `steps` int(11) NOT NULL default '0',
				  `stime` int(11) NOT NULL default '0',
				  `showend` int(3) NOT NULL default '0',
				  `aishoot` text NOT NULL,
				  `aiboat1` int(3) NOT NULL default '0',
				  `aiboat2` int(3) NOT NULL default '0',
			  	`aiboat3` int(3) NOT NULL default '0',
				  `aiboat4` int(3) NOT NULL default '0',
				  `aiboat5` int(3) NOT NULL default '0',
				  `pl1matrix` text NOT NULL,
		  		`pl2matrix` text NOT NULL,
				  `pl1matrix2` text NOT NULL,
				  `pl2matrix2` text NOT NULL,
				  `player12` int(11) NOT NULL default '0',
			  	`player13` int(11) NOT NULL default '0',
				  `player14` int(11) NOT NULL default '0',
				  `player15` int(11) NOT NULL default '0',
				  `player22` int(11) NOT NULL default '0',
		  		`player23` int(11) NOT NULL default '0',
				  `player24` int(11) NOT NULL default '0',
				  `player25` int(11) NOT NULL default '0',
				  `scorepl1` int(11) NOT NULL default '0',
		  		`scorepl2` int(11) NOT NULL default '0',
				  `playhit` int(3) NOT NULL default '0',
				  `booom` int(3) NOT NULL default '0',
				  `booompos` int(3) NOT NULL default '0',
			  	`gameover` int(3) NOT NULL default '0'
				) ENGINE=MyISAM;

				CREATE TABLE IF NOT EXISTS `battleships_highscore` (
				  `place` int(11) NOT NULL default '0',
				  `userid` int(11) NOT NULL default '0',
				  `username` varchar(50) NOT NULL default '',
				  `score` int(11) NOT NULL default '0',
				  `rankpoint` int(3) NOT NULL default '0',
				  `rank` varchar(50) NOT NULL default '',
				  `bstart` int(11) NOT NULL default '0',
				  messi text NOT NULL             
				 )ENGINE=MyISAM;

				CREATE TABLE IF NOT EXISTS `battleships_message` (
                `mesid` int(11) NOT NULL default'0',
               `userid` int (11) NOT NULL default '0',
                messi text NOT NULL
  
                ) ENGINE=MyISAM;

				CREATE TABLE IF NOT EXISTS `battleships_user` (
				  `gameid` int(11) NOT NULL default '0',
				  `userid` int(11) NOT NULL default '0',
				  `username` varchar(50) NOT NULL default '',
				  `player` int(11) NOT NULL default '0',
				  `setok` int(3) NOT NULL default '0',
				  `gonow` int(3) NOT NULL default '0',
				  `watershoot` int(5) NOT NULL default '0',
				  `boomshoot` int(5) NOT NULL default '0',
				  `checkit` int(3) NOT NULL default '0'
				) ENGINE=MyISAM;