prefix('multimenu05')." ( "; $sql .= "id int(5) unsigned NOT NULL auto_increment,"; $sql .= "title varchar(150) NOT NULL default '',"; $sql .= "hide tinyint(1) unsigned NOT NULL default '0',"; $sql .= "link varchar(255) default NULL,"; $sql .= "weight tinyint(4) unsigned NOT NULL default '0',"; $sql .= "target varchar(10) default NULL,"; $sql .= "groups varchar(255) default NULL,"; $sql .= "PRIMARY KEY (id)"; $sql .= ") TYPE=MyISAM;"; print $sql."..."; if ( $xoopsDB->query ( $sql ) ) { print "
Created Table 'multimenu05' ok
"; } else { print "
'multimenu05'...It failed. Please make this SQL reference and work manually.
"; } $sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu06')." ( "; $sql .= "id int(5) unsigned NOT NULL auto_increment,"; $sql .= "title varchar(150) NOT NULL default '',"; $sql .= "hide tinyint(1) unsigned NOT NULL default '0',"; $sql .= "link varchar(255) default NULL,"; $sql .= "weight tinyint(4) unsigned NOT NULL default '0',"; $sql .= "target varchar(10) default NULL,"; $sql .= "groups varchar(255) default NULL,"; $sql .= "PRIMARY KEY (id)"; $sql .= ") TYPE=MyISAM;"; print $sql."..."; if ( $xoopsDB->query ( $sql ) ) { print "
Created Table 'multimenu06' ok
"; } else { print "
'multimenu06'...It failed. Please make this SQL reference and work manually.
"; } $sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu07')." ( "; $sql .= "id int(5) unsigned NOT NULL auto_increment,"; $sql .= "title varchar(150) NOT NULL default '',"; $sql .= "hide tinyint(1) unsigned NOT NULL default '0',"; $sql .= "link varchar(255) default NULL,"; $sql .= "weight tinyint(4) unsigned NOT NULL default '0',"; $sql .= "target varchar(10) default NULL,"; $sql .= "groups varchar(255) default NULL,"; $sql .= "PRIMARY KEY (id)"; $sql .= ") TYPE=MyISAM;"; print $sql."..."; if ( $xoopsDB->query ( $sql ) ) { print "
Created Table 'multimenu07' ok
"; } else { print "
'multimenu07'...It failed. Please make this SQL reference and work manually.
"; } $sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu08')." ( "; $sql .= "id int(5) unsigned NOT NULL auto_increment,"; $sql .= "title varchar(150) NOT NULL default '',"; $sql .= "hide tinyint(1) unsigned NOT NULL default '0',"; $sql .= "link varchar(255) default NULL,"; $sql .= "weight tinyint(4) unsigned NOT NULL default '0',"; $sql .= "target varchar(10) default NULL,"; $sql .= "groups varchar(255) default NULL,"; $sql .= "PRIMARY KEY (id)"; $sql .= ") TYPE=MyISAM;"; print $sql."..."; if ( $xoopsDB->query ( $sql ) ) { print "
Created Table 'multimenu08' ok
"; } else { print "
'multimenu08'...It failed. Please make this SQL reference and work manually.
"; } xoops_cp_footer(); exit; } } ?>
The user who updates from version 1.13 series to version 1.14 series needs this processing.