101.php

CMS系统

<?php

// regpath and cppath are now supplied in the usersystem files
$DB->query("ALTER TABLE usersystems DROP regpath");
$DB->query("ALTER TABLE usersystems DROP cppath");

// folder path used to be part of regpath and cppath, thus:
$DB->query("ALTER TABLE usersystems ADD folderpath VARCHAR( 64 ) NOT NULL");

// add table prefixes for usersystems
$DB->query("ALTER TABLE usersystems ADD tblprefix  VARCHAR( 32 ) NOT NULL");

// vBulletin 3 integration! -w00t
$DB->query("INSERT INTO " . TABLE_PREFIX . "usersystems (name, queryfile) VALUES ('vBulletin 3', 'vbulletin3.php') ");

// delete these options because they are now done automatically
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '8' AND title = 'Forum Name'");
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '8' AND title = 'Forum Path'");
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '8' AND title = 'Forum Database Name'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET displayorder = '1' WHERE pluginid = '8' AND title = 'Number of Post to Display'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET displayorder = '2' WHERE pluginid = '8' AND title = 'Word Wrap'");
$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET version = '1.1' WHERE pluginid = '8'");

// delete these options because they are now done automatically
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '9' AND title = 'Forum Name'");
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '9' AND title = 'Forum Path'");
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '9' AND title = 'Forum Database Name'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET displayorder = '1' WHERE pluginid = '9' AND title = 'Number of Top Posters to Display'");
$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET version = '1.1' WHERE pluginid = '9'");

?>