115.php

CMS系统

// add info link for locale setting and change the group name
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET groupname   = 'Date and Time Options',
                                                        description = 'Convert the dates and times to a different language by entering your locale time format:<br /><a href=\'http://lcweb.loc.gov/standards/iso639-2/englangn.html\' target=\'_blank\'>Click here for more information.</a>'
                                                  WHERE title       = 'Locale Time'");


// ########################### UPDATE MAIN SETTINGS ############################

$DB->query("ALTER TABLE " . TABLE_PREFIX . "mainsettings ADD varname VARCHAR( 64 ) NOT NULL AFTER settingid");

$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'websitetitle'    WHERE title = 'Website Title'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'technicalemail'  WHERE title = 'Technical Email'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'metakeywords'    WHERE title = 'Meta Keywords'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'metadescription' WHERE title = 'Meta Description'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'logotype'        WHERE title = 'Logo Type'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'logoimage'       WHERE title = 'Image Name:'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'logotext'        WHERE title = 'Use text instead of image'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'fontface'        WHERE title = 'Font Face'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'fontsize'        WHERE title = 'Font Size'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'fontcolor'       WHERE title = 'Font Color'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'fonthex'         WHERE title = 'Font Hex Color'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'sdversion'       WHERE title = 'version'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'siteactivation'  WHERE title = 'Turn Site On/Off'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'offmessage'      WHERE title = 'Off Reason'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'currentlogo'     WHERE title = 'Current Logo'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'logopreview'     WHERE title = 'Logo Preview'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'categorytitle'   WHERE title = 'Combing Title Tag with Category Name'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'copyrighttext'   WHERE title = 'Copyright'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'allowcomments'   WHERE title = 'Allow Comments From Guests'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'bfo'             WHERE title = 'bfo'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'localetime'      WHERE title = 'Locale Time'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'logolink'        WHERE title = 'Logo Link'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'daylightsavings' WHERE title = 'Enable Daylight Savings'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'dateformat'      WHERE title = 'Format For Date'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'timezoneoffset'  WHERE title = 'Default Time Zone Offset'");
$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET varname = 'language'        WHERE title = 'Language'");






// ################### MOVE LOGO LINK TO LOGO SETTINGS GROUP ###################

$DB->query("UPDATE " . TABLE_PREFIX . "mainsettings SET groupname = 'Logo Settings' WHERE title = 'Logo Link'");

// ################ AVATAR SETTING FOR MEMBER INTERFACE PLUGIN #################

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 10, 'Login Panel Options', 'Display Avatar', 'Display the user\'s avatar in the login panel?', 'yesno', '1', 1) ");

// ######################### UPDATE SETTING GROUP NAME #########################

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET groupname = 'Registration Options' WHERE pluginid = '12'");

// ######################### NEW CONTACT PLUGIN SETTING ########################

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 6, 'Options', 'Allow Attachments', 'Allow users to send you attachments?', 'yesno', '0', '2') ");

// ############################# FIX MISSPELLINGS  #############################

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'With Javascripting Checking set to yes, the registration page will only be submitted once all input boxes have been filled out correctly. Upon an error, such as a submitted empty form, a javascript message box describing the mistake will be displayed.'
            WHERE pluginid = '12' AND title = 'Enable Javascript Checking'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'Enter the maximum password length:'
            WHERE pluginid = '12' AND title = 'Maximum Password Length'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'Enter the max height that a thumbnail should be resized to:'
            WHERE pluginid = '17' AND title = 'Max Thumbnail Height'");


// ################## ADD CATEGORY PARENT ID FOR SUBCATEGORIES #################

$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories ADD parentid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER categoryid");

// ############################## HOVER IMAGE ##################################

$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories ADD hoverimage VARCHAR( 128 ) NOT NULL AFTER image");

// ################ CHATTERBOX CATEGORY TARGETING AND HISTORY ##################

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 7, 'Options', 'Category Targeting', 'Only display messages which were posted in the category where the Chatterbox resides.', 'yesno', '1', 7) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 7, 'Options', 'Chatterbox History', 'Display a link to a popup window that displays the message history of your chatterbox.', 'yesno', '1', 8) ");

// ########################### EXTRA NEWS SETTINGS #############################

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 3, 'Options', 'Display Print Article Option', 'Display the print article option for your readers.', 'yesno', '1', '6') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 3, 'Options', 'Display Email Article Option', 'Display the email article option for your readers.', 'yesno', '1', '7') ");

// plugin access ids
$DB->query("ALTER TABLE " . TABLE_PREFIX . "userprivileges ADD pluginaccess VARCHAR( 255 ) NOT NULL AFTER privilegetype");

// update superadmin to Administrator
$DB->query("UPDATE " . TABLE_PREFIX . "userprivileges SET privilegetype = 'Administrator',
                                                          pluginaccess  = 'Full Access'
                                                    WHERE privilegetype = 'superadmin'");



?>