200_rc_2.php

CMS系统

<?php

// upgrade capacity of two usergroup columns
$DB->query("ALTER TABLE " . TABLE_PREFIX . "usergroups CHANGE `categoryviewids` `categoryviewids` TEXT NOT NULL,
                                                       CHANGE `categorymenuids` `categorymenuids` TEXT NOT NULL");

// erase default value "Newest First" and add more space
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p2_settings CHANGE `sorting` `sorting` VARCHAR( 64 ) NOT NULL");

// change newest first, oldest first from articleid to date
$DB->query("UPDATE " . TABLE_PREFIX . "p2_settings SET sorting = 'datecreated ASC' WHERE sorting = 'articleid ASC'");
$DB->query("UPDATE " . TABLE_PREFIX . "p2_settings SET sorting = 'IF ( dateupdated = 0, datecreated, dateupdated ) DESC' WHERE sorting = 'articleid DESC'");

// install the subcategory plugin
if(!$installed = $DB->query_first("SELECT pluginid FROM " . TABLE_PREFIX . "plugins WHERE pluginid = 31"))
{
  $DB->query("INSERT INTO " . TABLE_PREFIX . "plugins (pluginid, name, displayname, version, pluginpath, settingspath, authorname, authorlink, settings)
              VALUES (31, 'Subcategory Menu', 'Subcategory Menu', '1.0', 'p31_subcategory_menu/p31_subcategory_menu.php', 'p31_subcategory_menu/p31_settings.php', 'subdreamer', 1, 17)");

  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Subcategory Separator', 'How would you like your subcategories to be separated?', 'text', '<br />', 1) ");
  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Custom Link Styles',    'If set to yes, then the subcategories will use the CSS styles defined in this page instead of the styles from your current Subdreamer skin:' , 'yesno', '0', 2) ");
  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Default Link Style',    'CSS style of the default subcategory link:\r\n<br />Example: <i>font: 11px verdana; color: #6E8195;</i>', 'text', 'font: 11px verdana; color: #6E8195;', 3) ");
  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Active Link Style',     'CSS style of the active subcategory link:', 'text', 'font: 11px verdana; color: #6E8195;', 4) ");
  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Visited Link Style',    'CSS style of the visited subcategory link:', 'text', 'font: 11px verdana; color: #6E8195;', 5) ");
  $DB->query("INSERT INTO " . TABLE_PREFIX . "pluginsettings VALUES ('0', 31, 'Subcategory Options', 'Hover Link Style',      'CSS style of the hover subcategory link:', 'text', 'font: 11px verdana; color: #6E8195;', 6) ");

  // install default usergroup settings
  $usergroups = $DB->query("SELECT usergroupid, pluginviewids, pluginadminids FROM " . TABLE_PREFIX . "usergroups");

  $pluginsettings = 17;
  $pluginbitfield = array('canview' => 1, 'canadmin' => 16);

  while($usergroup = $DB->fetch_array($usergroups))
  {
    if($usergroup['usergroupid'] == 1)
    {
      // ADMINISTRATOR USERS
      $pluginviewids     = (!$pluginsettings & $pluginbitfield['canview'])  ? $usergroup['pluginviewids']  : (strlen($usergroup['pluginviewids'])  ? $usergroup['pluginviewids']  . ',31' : '31');
      $pluginadminids    = (!$pluginsettings & $pluginbitfield['canadmin']) ? $usergroup['pluginadminids'] : (strlen($usergroup['pluginadminids']) ? $usergroup['pluginadminids'] . ',31' : '31');
    }
    else
    {
      // MODERATORS AND REGISTERED USERS (no admin access)
      $pluginviewids     = (!$pluginsettings & $pluginbitfield['canview'])  ? $usergroup['pluginviewids']  : (strlen($usergroup['pluginviewids'])  ? $usergroup['pluginviewids']  . ',31' : '31');
      $pluginadminids    = $usergroup['pluginadminids'];
    }

    // update usergroup row
    $DB->query("UPDATE " . TABLE_PREFIX . "usergroups SET pluginviewids  = '$pluginviewids',
                                                          pluginadminids = '$pluginadminids'
                                                    WHERE usergroupid    = '" . $usergroup['usergroupid'] . "'");
  }
}
else
{
  // change this to a main subdreamer plugin
  $DB->query("UPDATE " . TABLE_PREFIX . "plugins SET authorname = 'subdreamer' WHERE pluginid = 31");
}


// fix a guestbook bug
$DB->query("UPDATE " . TABLE_PREFIX . "plugins SET settingspath = 'p4_guestbook/p4_settings.php' WHERE pluginid = 4");


// add friendly category name
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories ADD `urlname` VARCHAR( 64 ) NOT NULL AFTER `name`");

// now fill up those new friendly names
$getcategories = $DB->query("SELECT categoryid, name FROM " . TABLE_PREFIX . "categories");

while($category = $DB->fetch_array($getcategories))
{
  $urlname = str_replace('"', "",  $category['name']);
  $urlname = str_replace("'", "",  $urlname);
  $urlname = str_replace(" ", "_", $urlname);

  $DB->query("UPDATE " . TABLE_PREFIX . "categories SET urlname = '$urlname' WHERE categoryid = " . $category['categoryid']);
}

// add new phrases
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'url_not_found',        'URL Not Found!',                          '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'page_not_found',       'Page Not Found!',                         '', '', '', '', 0, 0, 0)");
$DB->query("INSERT INTO " . TABLE_PREFIX . "phrases VALUES ('0', 1, 'redirect_to_homepage', 'Click here to redirect to the homepage.', '', '', '', '', 0, 0, 0)");

// add menu width column for categories
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories ADD `menuwidth` SMALLINT UNSIGNED NOT NULL AFTER `hoverimage`");
?>