104.php

CMS系统

<?php

// Delete old settings
$DB->query("DELETE FROM " . TABLE_PREFIX . "pluginsettings WHERE pluginid = '2'");

// Alter table
$DB->query("ALTER TABLE p2_news CHANGE article article MEDIUMTEXT NOT NULL");
$DB->query("ALTER TABLE p2_news ADD allowsmilies TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER activated");
$DB->query("ALTER TABLE p2_news ADD showauthor   TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER allowsmilies");
$DB->query("ALTER TABLE p2_news ADD showdate     TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER showauthor");
$DB->query("ALTER TABLE p2_news ADD date         INT( 10 )    DEFAULT '0' NOT NULL AFTER showdate");

// Update the date for all articles
$DB->query("UPDATE " . TABLE_PREFIX . "p2_news SET date = '" . time() . "'");

// Create new table
$DB->query("CREATE TABLE p2_settings (
categoryid     int(10)     NOT NULL default '0',
maxarticles    int(10)     NOT NULL default '10',
sorting        varchar(32) NOT NULL default 'Newest First',
multiplepages  tinyint(1)  NOT NULL default '0',
KEY categoryid (categoryid)
) ");

$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET version = '1.2' WHERE pluginid = '2'");

?>