| gundelpfanne |
12-30-2015 06:37 PM |
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 .
Code:
$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;
|
More Information