230_rc_1.php

CMS系统

<?php

$DB->query("CREATE TABLE " . TABLE_PREFIX . "vvc (
  vvcid                                 INT(10)      UNSIGNED NOT NULL             AUTO_INCREMENT,
  verifycode                    VARCHAR(100)          NOT NULL DEFAULT '',
  PRIMARY KEY (vvcid)
  ) " );

$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings VALUES ('0', 'checkforupdates', 'Subdreamer Settings',   'yesno', 'Check For Updates', 'Allow Subdreamer to automatically check for updates to the CMS and plugins?<br /><br />Subdreamer can check with Subdreamer.com whether you are running the latest version of the CMS and plugins. The results will be shown on the admin panel homepage with links to download the updated versions', '1')");
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings VALUES ('0', 'gzipcompress',    'Site Settings',         'yesno', 'GZip Compression', 'If your server is running off of apache, then you can turn this setting on to compress your pages potentially making your site much quicker:', '0')");

// Add the target column to category table
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories ADD `target` VARCHAR(10) NOT NULL DEFAULT '' AFTER `link`");

// Add the banned column to users table
$DB->query("ALTER TABLE " . TABLE_PREFIX . "users ADD `banned` TINYINT(1) NOT NULL DEFAULT '0' AFTER `email`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "users ADD `activated` TINYINT(1) NOT NULL DEFAULT '0' AFTER `banned`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "users ADD `validationkey` VARCHAR(50) DEFAULT '' AFTER `activated`");

$DB->query("UPDATE " . TABLE_PREFIX . "users SET activated = 1");

// Add comments phrases
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'hide_comments',            'Hide Comments', '', '', '', '', '', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'ip_banned',                'Your IP address has been banned', '', '', '', '', 1, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'not_yet_activated',        'Your haven\'t yet activated your account. Check your email for the activation instructions', '', '', '', '', 1, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'incorrect_vvc_code',               'Incorrect confirmation code',                                            '', '', '', '', 1, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'enter_verify_code',         'Enter the code you see in the image above (case sensitive)', '', '', '', '', 1, 0, 0)");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 2, 'Options',                         'Auto Approve News', 'Automatically approve user submitted news items?', 'yesno', '0', 2) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 2, 'Options',                         'Enable Email Articles', 'Allow users to email articles to a friend?', 'yesno', '1', 3) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 2, 'Options',                         'Require VVC Code', 'Require users to enter a Visual Verify Code to email to a friend?', 'yesno', '0', 4) ");

$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'notify_email_from',                 'Article Plugin', '', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'notify_email_subject',                 'New article submitted to your website!', '', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'notify_email_message',                 'A new article has been submitted to your website.', '', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'notify_email_author',              'Author', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'notify_email_title',               'Title', '', '', '', '', 0, 0, 0)");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 6, 'Options',                         'Require VVC Code', 'Require users to enter a Visual Verify Code to submit form?', 'yesno', '0', 4) ");

$DB->query("ALTER TABLE " . TABLE_PREFIX . "p7_chatterbox ADD `datecreated` INT(10) NOT NULL DEFAULT '0' AFTER `comment`");
$DB->query("UPDATE " . TABLE_PREFIX . "p7_chatterbox SET datecreated = " . time());

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 7,  'Options',          'Maximum History Length', 'Enter the maxium number of days of messages to display in the message history of your chatterbox. (Enter 0 for unlimited)', 'text', '0', 9) ");

$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'private_messages',        'Private Messages:', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'unread_total',            ' Unread, Total ', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'new_priv_msg',            'You have a new private message.', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'title',                   'Title:', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'sender',                  'Sender:', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'click_ok',                'Click OK to view it, or cancel to hide this prompt.', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'open_msg',                'Open Message in New Window?', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'new_priv_msg_title',      'New Private Message', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 10, 'admin_panel',             'Admin Panel', '', '', '', '', 0, 0, 0)");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 10, 'Login Panel Options', 'Show PMs',                             'Enable Private Message Notifications:', 'yesno', '1', 2) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 10, 'Login Panel Options', 'Show Popups',                          'Shows a Javascript popup window if the user has a new pm (VBulletin Users can override this locally):', 'yesno', '1', 3) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 10, 'Login Panel Options', 'Display Admin Link',                   'Display a link to the admin panel in the login panel for those with admin access?', 'yesno', '1', 4) ");

$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'email_banned',             'Your Email address has been banned', '', '', '', '', 1, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'activation_required',            'Thankyou for registering. An email has been sent to your email address with instructions on how to activate your new account',                         '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'email_subject_activation', 'Thanks for registering',                         '', '', '', '', 0, 0, 0)");