there are no query to create tables guthaben and guthaben_shop_preise
Code:
<installcode><![CDATA[
$db->hide_errors();
$db->query("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `sudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
$db->query("ALTER TABLE `" . TABLE_PREFIX . "administrator` ADD `customsudokupermissions` INT(10) UNSIGNED NOT NULL DEFAULT '0'");
$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku` INT(11) NOT NULL DEFAULT '0'");
$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_pay` INT(11) NOT NULL DEFAULT '0'");
$db->query("ALTER TABLE `" . TABLE_PREFIX . "guthaben` ADD `sudoku_get` INT(11) NOT NULL DEFAULT '0'");
$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_pay','\$guthaben[sudoku_pay]','\$guthaben[sudoku]')");
$db->query("INSERT INTO `" . TABLE_PREFIX . "guthaben_shop_preise` (`name`,`pvar1`,`pvar2`) VALUES ('guthaben_shop_sudoku_get','\$guthaben[sudoku_get]','\$guthaben[sudoku]')");
$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_config;");
$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_config (
subsend int(11) NOT NULL default '100',
plevel1 int(11) NOT NULL default '2000',
plevel2 int(11) NOT NULL default '3500',
plevel3 int(11) NOT NULL default '5000',
plevel4 int(11) NOT NULL default '8000',
postings int(4) NOT NULL default '0',
guthaben int(11) NOT NULL default '0',
month int(11) NOT NULL default '30',
pay int(4) NOT NULL default '0',
betrag int(4) NOT NULL default '0'
) TYPE=MyISAM;");
$db->query("INSERT INTO " . TABLE_PREFIX . "sudoku_config (betrag) VALUES (0)");
$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_user;");
$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_user (
userid int(11) NOT NULL default '0',
ingame int(2) NOT NULL default '0',
level int(2) NOT NULL default '0',
pgame text NOT NULL,
ogame text NOT NULL,
score int(11) NOT NULL default '0',
time int(11) NOT NULL default '0',
endtime int(11) NOT NULL default '0',
mistakes int(4) NOT NULL default '0'
) TYPE=MyISAM;");
$db->query("DROP TABLE IF EXISTS " . TABLE_PREFIX . "sudoku_highscore;");
$db->query("CREATE TABLE " . TABLE_PREFIX . "sudoku_highscore (
userid int(11) NOT NULL default '0',
level int(2) NOT NULL default '0',
score int(11) NOT NULL default '0',
playtime int(11) NOT NULL default '0',
mistakes int(4) NOT NULL default '0'
) TYPE=MyISAM;");
$db->show_errors();
]]></installcode>