220.php

CMS系统

<?php

// update link directory plugin settings, 210 install came with 17, it should be 19
$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET settings = 19 WHERE pluginid = 16");

// change the column size to add new smilies
$DB->query("ALTER TABLE " . TABLE_PREFIX . "smilies CHANGE `text` `text` VARCHAR( 32 ) NOT NULL");

// add the new smilies
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Angry',        'smilies_angry',       'angry.gif')        ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Blush',        'smilies_blush',       'blush.gif')        ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Cheeky',       'smilies_cheeky',      'cheeky.gif')       ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Darn',         'smilies_darn',        'darn.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Dead',         'smilies_dead',        'dead.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Eeek',         'smilies_eek',         'eeek.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Embarrassed',  'smilies_embarrassed', 'embarrassed.gif')  ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Help',         'smilies_help',        'help.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Luv',          'smilies_luv',         'luv.gif')          ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Ok',           'smilies_ok',          'ok.gif')           ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Wink',         'smilies_wink',        'wink.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Yawn',         'smilies_yawn',        'yawn.gif')         ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "smilies VALUES ('0', 'Yum',          'smilies_yum',         'yum.gif')          ");

// remove 'Locale Time' sense date is now manually converted
$DB->query("DELETE FROM " . TABLE_PREFIX . "mainsettings WHERE varname = 'localetime'");

// add date phrases
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Sunday', 'Sunday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Monday', 'Monday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Tuesday', 'Tuesday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Wednesday', 'Wednesday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Thursday', 'Thursday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Friday', 'Friday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Saturday', 'Saturday', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Sun', 'Sun', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Mon', 'Mon', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Tue', 'Tue', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Wed', 'Wed', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Thu', 'Thu', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Fri', 'Fri', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Sat', 'Sat', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'January', 'January', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'February', 'February', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'March', 'March', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'April', 'April', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'May', 'May', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'June', 'June', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'July', 'July', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'August', 'August', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'September', 'September', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'October', 'October', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'November', 'November', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'December', 'December', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Jan', 'Jan', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Feb', 'Feb', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Mar', 'Mar', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Apr', 'Apr', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'May', 'May', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Jun', 'Jun', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Jul', 'Jul', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Aug', 'Aug', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Sep', 'Sep', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Oct', 'Oct', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Nov', 'Nov', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'Dec', 'Dec', '', '', '', '', '', '0', '0') ");

// update website url group name
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET groupname = 'Subdreamer Settings' WHERE groupname = 'Website URL'");

// insert new subdreamer settings
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings VALUES ('0', 'enablewysiwyg', 'Subdreamer Settings', 'yesno', 'WYSIWYG Editor', 'Enable the WYSIWYG editor in the admin panel?<br /><br />Subdreamer comes installed with a powerful editor that is used in several areas including the news plugin and logo creator. The editor will allow you to view changes you make on your content such as altering a font\'s size and color. While the editor is great for simple changes, you might want to disable it if you\'re dealing with more complex code such as JavaScript.', '1') ");
?>