103.php

CMS系统

<?php

// delete sdplugin column, there is no need for this column
// it was added in the install of 1.0.2 but not the upgrade for 1.0.2...so:
// (it was not supposed to be added)
@MYSQL_QUERY("ALTER TABLE plugins DROP sdplugin");

// no need to enter the authorlinks over and over, we just need the userid
// at the time of this upgrade there are only 3 users with skins, and 1 with plugins
$DB->query("UPDATE " . TABLE_PREFIX . "skins SET authorlink = 1  WHERE authorname = 'subduck'");
$DB->query("UPDATE " . TABLE_PREFIX . "skins SET authorlink = 5  WHERE authorname = 'Samurai'");
$DB->query("UPDATE " . TABLE_PREFIX . "skins SET authorlink = 48 WHERE authorname = 'Shallowfaith'");
$DB->query("ALTER TABLE skins CHANGE authorlink authorlink SMALLINT( 5 ) NOT NULL");

$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET authorlink = 1 WHERE authorname = 'subduck'");
$DB->query("ALTER TABLE plugins CHANGE authorlink authorlink SMALLINT( 5 ) NOT NULL");

?>