115.php

CMS系统

<?php

// ########################### FIX/INSERT LANGUAGES ############################

// fix image gallery language bug
$DB->query("UPDATE " . TABLE_PREFIX . "phrases SET varname       = 'submitted_by',
                                                   defaultphrase = 'Submitted by:'
                                             WHERE pluginid = '17' AND varname = 'Submitted by:'");

// email attachment phrase
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 6, 'attachment',  'Attachment:', '', '', '', '', '1', '0', '0') ");

// chatterbox history
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 7, 'view_history', 'View Message History', '', '', '', '', '0', '0', '0') ");

// News Print and Email
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'print', 'Print', '', '', '', '', '0', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'email', 'Email', '', '', '', '', '0', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'enter_recipient_email', 'Send this article to:',                              '', '', '', '', '1', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'separate_with_commas',  'Separate multiple addresses with commas.',           '', '', '', '', '0', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'enter_your_email',      'Enter your email address:',                          '', '', '', '', '1', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'enter_comment',         'Enter an optional comment:',                         '', '', '', '', '1', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'send_email',            'Send Email',                                         '', '', '', '', '0', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'invalid_email',         'Please enter a valid email address.',                '', '', '', '', '1', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'email_sent',            'The following article has been sent:',               '', '', '', '', '1', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'go_back',               'Click here to go back to the article.',              '', '', '', '', '0', '0', '0') ");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 2, 'email_not_sent',        'A system error occured. Your message was not sent.', '', '', '', '', '1', '0', '0') ");


$DB->query("UPDATE ". TABLE_PREFIX . "mainsettings SET description = 'Any errors or problems will be mailed to this address:<br />\r\nLeave blank if you do not wish to receive technical emails.<br />\r\nSeparate multiple addresses with commas.'
                                                 WHERE title       = 'Technical Email'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'Enter the email address where the submitted contact forms should be sent to:<br />\r\nSeparate multiple addresses with commas.'
                                                    WHERE title       = 'Email' AND pluginid = '6'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'This email address will receive an email message when a new image is submitted:<br />\r\nSeparate multiple addresses with commas.'
                                                    WHERE title       = 'Image Notification' AND pluginid = '17'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'This email address will receive an email message when a new link is submitted:<br />\r\nSeparate multiple addresses with commas.'
                                                    WHERE title       = 'Link Notification' AND pluginid = '16'");

$DB->query("UPDATE " . TABLE_PREFIX . "pluginsettings SET description = 'This email address will receive an email message when a new article is submitted from a user/guest: <br /> Leave this blank if you prefer not to receive an email.<br />\r\nSeparate multiple addresses with commas.'
                                                    WHERE title = 'Article Notification' AND pluginid = '3'");


$DB->query("UPDATE " . TABLE_PREFIX . "phrases SET pluginid = '2' WHERE varname = 'discuss_article_in_forum'");


// ################## ADD MAIN SETTINGS + DATE AND TIME SETTINGS ###############

// LANGUAGE setting
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings (groupname, title, value)
            VALUES ('NA', 'Language', 'English.php|1.0|iso-8859-1')");


// format date option
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings (settingid, groupname, input, title, description, value)
VALUES ('0', 'Date and Time Options', 'text', 'Format For Date', 'Format in which the date is presented:<br /><br />See: <a href=\'http://us4.php.net/manual/en/function.strftime.php\' target=\'_blank\'>http://us4.php.net/manual/en/function.strftime.php</a><br /><br />Examples:<br />US Format (e.g., 07-28-04): %m-%d-%y<br />Expanded US Format (e.g., July 28, 2004): %B %d, %Y<br />European Format (e.g., 28-07-04): %d-%m-%y<br />Expanded European Format (e.g., 28 July 2004): %d %B %Y', '%B %d, %Y') ");

// time zone option
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings (settingid, groupname, input, title, description, value)
VALUES ('0', 'Date and Time Options',
   '<select name=\\\\\"settings[\$setting[settingid]]\\\\\">\r\n
    <option value=\\\\\"-12\\\\\"  \".iif(\$setting[value]==\"-12\",  \"selected\", \"\").\">(GMT -12:00) Eniwetok, Kwajalein</option>\r\n
    <option value=\\\\\"-11\\\\\"  \".iif(\$setting[value]==\"-11\",  \"selected\", \"\").\">(GMT -11:00) Midway Island, Samoa</option>\r\n
    <option value=\\\\\"-10\\\\\"  \".iif(\$setting[value]==\"-10\",  \"selected\", \"\").\">(GMT -10:00) Hawaii</option>\r\n
    <option value=\\\\\"-9\\\\\"   \".iif(\$setting[value]==\"-9\",   \"selected\", \"\").\">(GMT -9:00) Alaska</option>\r\n
    <option value=\\\\\"-8\\\\\"   \".iif(\$setting[value]==\"-8\",   \"selected\", \"\").\">(GMT -8:00) Pacific Time (US & Canada)</option>\r\n
    <option value=\\\\\"-7\\\\\"   \".iif(\$setting[value]==\"-7\",   \"selected\", \"\").\">(GMT -7:00) Mountain Time (US & Canada)</option>\r\n
    <option value=\\\\\"-6\\\\\"   \".iif(\$setting[value]==\"-6\",   \"selected\", \"\").\">(GMT -6:00) Central Time (US & Canada), Mexico City</option>\r\n
    <option value=\\\\\"-5\\\\\"   \".iif(\$setting[value]==\"-5\",   \"selected\", \"\").\">(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima</option>\r\n
    <option value=\\\\\"-4\\\\\"   \".iif(\$setting[value]==\"-4\",   \"selected\", \"\").\">(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz</option>\r\n
    <option value=\\\\\"-3.5\\\\\" \".iif(\$setting[value]==\"-3.5\", \"selected\", \"\").\">(GMT -3:30) Newfoundland</option>\r\n
    <option value=\\\\\"-3\\\\\"   \".iif(\$setting[value]==\"-3\",   \"selected\", \"\").\">(GMT -3:00) Brazil, Buenos Aires, Georgetown</option>\r\n
    <option value=\\\\\"-2\\\\\"   \".iif(\$setting[value]==\"-2\",   \"selected\", \"\").\">(GMT -2:00) Mid-Atlantic</option>\r\n
    <option value=\\\\\"-1\\\\\"   \".iif(\$setting[value]==\"-1\",   \"selected\", \"\").\">(GMT -1:00 hour) Azores, Cape Verde Islands</option>\r\n
    <option value=\\\\\"0\\\\\"    \".iif(\$setting[value]==\"0\",    \"selected\", \"\").\">(GMT) Western Europe Time, London, Lisbon, Casablanca</option>\r\n
    <option value=\\\\\"1\\\\\"    \".iif(\$setting[value]==\"1\",    \"selected\", \"\").\">(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris</option>\r\n
    <option value=\\\\\"2\\\\\"    \".iif(\$setting[value]==\"2\",    \"selected\", \"\").\">(GMT +2:00) Kaliningrad, South Africa</option>\r\n
    <option value=\\\\\"3\\\\\"    \".iif(\$setting[value]==\"3\",    \"selected\", \"\").\">(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg</option>\r\n
    <option value=\\\\\"3.5\\\\\"  \".iif(\$setting[value]==\"3.5\",  \"selected\", \"\").\">(GMT +3:30) Tehran</option>\r\n
    <option value=\\\\\"4\\\\\"    \".iif(\$setting[value]==\"4\",    \"selected\", \"\").\">(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi</option>\r\n
    <option value=\\\\\"4.5\\\\\"  \".iif(\$setting[value]==\"4.5\",  \"selected\", \"\").\">(GMT +4:30) Kabul</option>\r\n
    <option value=\\\\\"5\\\\\"    \".iif(\$setting[value]==\"5\",    \"selected\", \"\").\">(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent</option>\r\n
    <option value=\\\\\"5.5\\\\\"  \".iif(\$setting[value]==\"5.5\",  \"selected\", \"\").\">(GMT +5:30) Bombay, Calcutta, Madras, New Delhi</option>\r\n
    <option value=\\\\\"6\\\\\"    \".iif(\$setting[value]==\"6\",    \"selected\", \"\").\">(GMT +6:00) Almaty, Dhaka, Colombo</option>\r\n
    <option value=\\\\\"7\\\\\"    \".iif(\$setting[value]==\"7\",    \"selected\", \"\").\">(GMT +7:00) Bangkok, Hanoi, Jakarta</option>\r\n
    <option value=\\\\\"8\\\\\"    \".iif(\$setting[value]==\"8\",    \"selected\", \"\").\">(GMT +8:00) Beijing, Perth, Singapore, Hong Kong</option>\r\n
    <option value=\\\\\"9\\\\\"    \".iif(\$setting[value]==\"9\",    \"selected\", \"\").\">(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk</option>\r\n
    <option value=\\\\\"9.5\\\\\"  \".iif(\$setting[value]==\"9.5\",  \"selected\", \"\").\">(GMT +9:30) Adelaide, Darwin</option>\r\n
    <option value=\\\\\"10\\\\\"   \".iif(\$setting[value]==\"10\",   \"selected\", \"\").\">(GMT +10:00) Eastern Australia, Guam, Vladivostok</option>\r\n
    <option value=\\\\\"11\\\\\"   \".iif(\$setting[value]==\"11\",   \"selected\", \"\").\">(GMT +11:00) Magadan, Solomon Islands, New Caledonia</option>\r\n
    <option value=\\\\\"12\\\\\"   \".iif(\$setting[value]==\"12\",   \"selected\", \"\").\">(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka</option>\r\n
    </select>'
   , 'Default Time Zone Offset', 'Time zone offset for guests and new users. Do not take DST into consideration, rather use the next option to enable/disable DST.', '-8') ");

// daylight savings time
$DB->query("INSERT INTO " . TABLE_PREFIX . "mainsettings (settingid, groupname, input, title, description, value)
VALUES ('0', 'Date and Time Options', 'yesno', 'Enable Daylight Savings', 'If Daylight Savings Time is currently in effect for the above time zone, enable this option so that guests will see the correct times', '0') ");