230_rc_1.php

CMS系统

$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'email_message_activation', 'Thanks for registering with us. Please click the following link to activate your account.',                         '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'validation_key_not_found', 'Your account was not found. Please ensure you copied the link correctly.',                         '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'already_validated',                 'Your account has already been activated. You may login using your username and password',                         '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 12, 'validation_success',                 'Thankyou for activating your account. You may now login using your username and password',                         '', '', '', '', 0, 0, 0)");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 12, 'Registration Options','Banned Email Addresses',               'Enter a list of banned email addresses (separated by spaces):<br />To ban a specific address enter \"[e-mail]\", to ban an entire domain enter \"@domain.com\"', 'textarea', '', 4) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 12, 'Registration Options','Banned IP Addresses',                  'Enter a list of banned ip addresses (separated by spaces)<br/>You can ban entire subnets (0-255) by using wildcard characters (192.168.0.*, 192.168.*.*) or enter a full ip address', 'textarea', '', 5) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 12, 'Registration Options','Require Email Activation',             'Require new registrants to validate their email address when registering:', 'yesno', '0', 6) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 12, 'Registration Options','Require VVC Code', 					  'Require users to enter a Visual Verify Code to register?', 'yesno', '0', 7) ");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', '16', 'Options',                           'Auto Approve Links',                                   'Automatically approve user submitted links?', 'yesno', '0', 7) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_from',                          'Link Directory Plugin', '', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_subject',                   'New link submitted to your website!','', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_message',                   'A new link has been submitted to your link directory.',  '', '', '', '', 0, 0, 0) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_author',             'Author', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_website',            'Website Name', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_url',                    'Website URL', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', '16', 'notify_email_description',   'Description', '', '', '', '', 0, 0, 0)");

// Image gallery changes
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_images ADD `viewcount` INT(10) NOT NULL DEFAULT '0' AFTER `description`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_images ADD `datecreated` INT(10) NOT NULL DEFAULT '0' AFTER `viewcount`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_sections ADD `imageid` INT(10) NULL AFTER `sorting`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_sections ADD `datecreated`   INT(10)      UNSIGNED NOT NULL DEFAULT '0' AFTER `imageid`");


$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET displayorder = 3 WHERE pluginid = 17 AND title = 'Images Per Page'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET displayorder = 4 WHERE pluginid = 17 AND title = 'Image Notification'");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Options',              'Auto Approve Images',                  'Automatically approve user submitted images?', 'yesno', '0', 5) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Options',              'Show View Counts',                     'Show the number of times the image has been viewed?', 'yesno', '1', 6) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Options',              'Show Comment Counts',                  'Show the number of comments for each image?', 'yesno', '1', 7) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Options',              'Display Jump Menu',                    'Display the Jump Menu navigation?', 'yesno', '1', 8) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Options',              'Section Sort Order',                   'Sort sections by',                      '<select name=\\\\\"settings[\$setting[settingid]]\\\\\">\r\n
  <option value=\\\\\"0\\\\\" \".iif(\$setting[value]==\"0\", \"selected\", \"\").\">Newest First</option>\r\n
  <option value=\\\\\"1\\\\\" \".iif(\$setting[value]==\"1\", \"selected\", \"\").\">Oldest First</option>\r\n
  <option value=\\\\\"1\\\\\" \".iif(\$setting[value]==\"2\", \"selected\", \"\").\">Alphabetically A-Z</option>\r\n
  <option value=\\\\\"1\\\\\" \".iif(\$setting[value]==\"3\", \"selected\", \"\").\">Alphabetically Z-A</option>\r\n
  </select>', '2', '9') ");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET groupname = 'Thumbnail Options', description = 'Automatically Resize images to thumbnails?:', input = 'yesno', displayorder = 1 WHERE pluginid = 17 AND title = 'Image Resizing'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET groupname = 'Thumbnail Options', description = 'Enter the max width that a thumbnail should be resized to:', displayorder = 2 WHERE pluginid = 17 AND title = 'Max Thumbnail Width'");
$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET groupname = 'Thumbnail Options', description = 'Enter the max height that a thumbnail should be resized to:', displayorder = 3 WHERE pluginid = 17 AND title = 'Max Thumbnail Height'");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Thumbnail Options',    'Square Off Thumbnails',                'When automatically creating thumbnails, should the image be cropped so that it is square?', 'yesno', '0', 4) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'Thumbnail Options',    'Drop Shadow Thumbnails',               'Show a drop-shadow effect around thumbnails?', 'yesno', '1', 5) ");

$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Create MidSize Images',                'Automatically create midsize images?<br />This allows you to show a larger image before the full size image is shown:', 'yesno', '0', 1) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Keep FullSize Images',                 'When an image is uploaded should we keep the fullsize image?<br />If this is set to no and \'Create MidSize Images\' is set to yes, this gives you ability to restrict the maximum size of the image. In this case the original image will be deleted leaving you with the fixed size MideSize image. Only active when \'Create MidSize Images\' is enabled:', 'yesno', '1', 2) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Max MidSize Width',                    'Enter the max width that the midsize image should be resized to:', 'text', '400', 3) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Max MidSize Height',                   'Enter the max height that the midsize image should be resized to:', 'text', '400', 4) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Square Off MidSize',                   'When automatically creating midsize images, should the image be cropped so that it is square?', 'yesno', '0', 5) ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 17, 'MidSize Options',      'Drop Shadow MidSize',                  'Show a drop-shadow effect around midsize images?', 'yesno', '1', 6) ");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'Automatically Resize images to thumbnails?:', input = 'yesno', value = '1' WHERE pluginid=17 AND title = 'Image Resizing'");

$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 17, 'invalid_image_type',      'Invalid image type.', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 17, 'views',                   'Views', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 17, 'jump_to',                 'Jump To...', '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 17, 'comments',                'Comments', '', '', '', '', 0, 0, 0)");

// Give existing images a date in the past but use the imageid to make sure the order is retained
$DB->query("UPDATE " . TABLE_PREFIX . "p17_images SET datecreated = " . (time() - 1000) . " + imageid");
?>