function reAllCache() { global $arrSideModule; categories_recount(); categories_recache(); calendar_recache(); statistics_recache(); hottags_recache(); archives_recache(); links_recache(); filters_recache(); keywords_recache(); recentLogs_recache(); recentComments_recache(); recentGbooks_recache(); logsTitle_recache(); modulesSetting_recache(); download_recache(); attachments_recache(); members_recache(); skinlist_recache(); online_recache(); logs_sidebar_recache($arrSideModule); }
function update_data($echo, $DMC) { global $DBPrefix, $update_time, $update_logs; $delete_setting = true; //更新附件的文件类别 2009-05-12 $modify_sql[] = "ALTER TABLE `{$DBPrefix}attachments` ADD INDEX `name` (`name`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}guestbook` ADD COLUMN `HTTP_REFERER` text NULL DEFAULT NULL AFTER `parent`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` ADD INDEX `isApp` (`isApp`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD COLUMN `isTopNews` tinyint(1) NOT NULL DEFAULT 0 AFTER `isTop`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD INDEX `postTime` (`postTime`,`saveType`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD INDEX `isComment` (`isComment`,`isTrackback`,`isTop`,`isTopNews`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}members` ADD INDEX `password` (`password`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}members` ADD INDEX `role` (`role`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}setting` ADD INDEX `settName` (`settName`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}trackbacks` ADD INDEX `isApp` (`isApp`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD `autoSplit` int(8) NOT NULL default '0'"; // 強化驗證 $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '=http')"; $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '[url=')"; $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '[href=')"; //运行SQL语句 foreach ($modify_sql as $key => $value) { $DMC->query($value, "T"); if ($echo) { if ($DMC->error()) { echo $value . " ... <font color=red>" . $DMC->error() . "</font><br />"; } else { echo $value . " ... <font color=blue>OK</font><br />"; } } } $i = 0; $contents = "\$update_logs = array(\r\n"; $contents .= "\t'{$i}' => '{$update_time}',\r\n"; for ($i = 0; $i < count($update_logs); $i++) { $j = $i + 1; $contents .= "\t'{$j}' => '" . $update_logs[$i] . "',\r\n"; } $contents .= ");"; writetocache('update_logs', $contents); //清空缓存 if ($delete_setting == true) { //0909升级需要重新建立setting文件。 if (!@unlink(F2BLOG_ROOT . "./cache/cache_setting.php")) { echo "<script language=Javascript> \n"; echo "alert('Please update cache!');\n"; echo "</script>\n"; } } else { //更新缓存 settings_recache(); links_recache(); } return false; }
if ($_POST['operation'] == "move" and $stritem != "") { $sql = "update " . $DBPrefix . "links set lnkGrpId='" . $_POST['move_group'] . "' where {$stritem}"; $DMC->query($sql); } //侧边栏隐藏 if ($_POST['operation'] == "ishidden" and $stritem != "") { $sql = "update " . $DBPrefix . "links set isSidebar='0' where {$stritem}"; $DMC->query($sql); } //侧边栏显示 if ($_POST['operation'] == "isshow" and $stritem != "") { $sql = "update " . $DBPrefix . "links set isSidebar='1' where {$stritem}"; $DMC->query($sql); } do_action("f2_link"); links_recache(); logs_sidebar_recache($arrSideModule); } if ($action == "all" or $action == "") { $seekname = ""; } $seek_url = "{$PHP_SELF}?order={$order}"; //查找用链接 $order_url = "{$PHP_SELF}?seekname={$seekname}"; //排序栏用的链接 $page_url = "{$PHP_SELF}?seekname={$seekname}&order={$order}"; //页面导航链接 $edit_url = "{$PHP_SELF}?seekname={$seekname}&order={$order}&page={$page}"; //编辑或新增链接 if ($action == "add") { //新增信息类别。
function update_data($echo, $DMC) { global $DBPrefix, $update_time, $update_logs; $delete_setting = true; $arr_setting = array(); // update 20090512 if (!in_array($update_logs, "20090512")) { //更新附件的文件类别 2009-05-12 $modify_sql[] = "ALTER TABLE `{$DBPrefix}attachments` ADD INDEX `name` (`name`)"; // `isSecret` tinyint(1) NOT NULL default '0', $modify_sql[] = "ALTER TABLE `{$DBPrefix}guestbook` ADD COLUMN `isSpam` tinyint(1) NOT NULL DEFAULT 0 AFTER `isSecret`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}guestbook` ADD COLUMN `HTTP_REFERER` text NULL DEFAULT NULL AFTER `parent`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` ADD INDEX `isApp` (`isApp`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD COLUMN `isSpam` tinyint(1) NOT NULL DEFAULT 0 AFTER `isTrackback`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD COLUMN `isTopNews` tinyint(1) NOT NULL DEFAULT 0 AFTER `isTop`"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD INDEX `postTime` (`postTime`,`saveType`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD INDEX `isComment` (`isComment`,`isTrackback`,`isTop`,`isTopNews`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}members` ADD INDEX `password` (`password`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}members` ADD INDEX `role` (`role`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}setting` ADD INDEX `settName` (`settName`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}trackbacks` ADD INDEX `isApp` (`isApp`)"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD `autoSplit` int(8) NOT NULL default '0'"; // 強化驗證 $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='=http'"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '=http')"; } $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='[url='"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '[url=')"; } $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='[href='"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '[href=')"; } $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='缺 錢 個 人 兼 職'"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '缺 錢 個 人 兼 職')"; } // ★全套愛愛★時間內不限次數★累ㄌ也ㄎ以找我按摩4小時3000★ $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='全套愛愛'"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, '全套愛愛')"; } // 跟新設定檔 $arr_setting['spamfilter'] = 'close'; } // update 20090625 if (!in_array($update_logs, "20090625")) { // `isSecret` tinyint(1) NOT NULL default '0', $modify_sql[] = "ALTER TABLE `{$DBPrefix}comments` ADD COLUMN `isSpam` tinyint(1) NOT NULL DEFAULT 0 AFTER `isSecret`"; } // update 20090630 if (!in_array($update_logs, "20090625")) { // This site baclofen is about baclofen remedy. $SQL = "select count(`name`) from `{$DBPrefix}filters` where `category`='1' and `name`='This site'"; list($intNums) = $DMC->fetchArray($DMC->query($SQL), MYSQL_NUM); if ($intNums == 0) { $modify_sql[] = "INSERT INTO `{$DBPrefix}filters` (`category`, `name`) VALUES (1, 'This site')"; } } /* if (!in_array($update_logs,"20090709")) { $SQL="select count(`name`) from `{$DBPrefix}modules` where `name`='BlogNews'"; list($intNums)=$DMC->fetchArray($DMC->query($SQL),MYSQL_NUM); if ($intNums==0) { $modify_sql[]="INSERT INTO `{$DBPrefix}modules` (`name`, `modTitle`, `disType`, `isHidden`, `indexOnly`, `orderNo`, `isSystem`, `htmlCode`, `pluginPath`, `isInstall`, `installFolder`, `installDate`, `settingXml`, `cateId`, `configPath`) VALUES('BlogNews', '跑馬燈', 3, 0, 0, 2, 1, '', 'include/plung.blognews.php', 0, '', 0, '', 0, '')"; } else $modify_sql[]="update `{$DBPrefix}modules` set isSystem='1',`pluginPath`='include/plung.blognews.php' where `name`='BlogNews'"; } */ if (is_array($arr_setting)) { foreach ($arr_setting as $key => $value) { if (!$DMC->fetchArray($DMC->query("select * from " . $DBPrefix . "setting where settName='{$key}'"))) { $modify_sql[] = "insert into " . $DBPrefix . "setting values('{$key}','{$value}','0')"; } } } //运行SQL语句 foreach ($modify_sql as $key => $value) { $DMC->query($value, "T"); if ($echo) { if ($DMC->error()) { echo $value . " ... <font color=red>" . $DMC->error() . "</font><br />"; } else { echo $value . " ... <font color=blue>OK</font><br />"; } } } $i = 0; $contents = "\$update_logs = array(\r\n"; $contents .= "\t'{$i}' => '{$update_time}',\r\n"; for ($i = 0; $i < count($update_logs); $i++) { $j = $i + 1; $contents .= "\t'{$j}' => '" . $update_logs[$i] . "',\r\n"; } $contents .= ");"; writetocache('update_logs', $contents); //清空缓存 if (!@unlink(F2BLOG_ROOT . "./cache/cache_setting.php")) { echo "<script language=Javascript> \n"; echo "alert('Please update cache!');\n"; echo "</script>\n"; } //更新缓存 settings_recache(); links_recache(); filters_recache(); /* //清空缓存 if ($delete_setting==true){//0909升级需要重新建立setting文件。 if (!@unlink(F2BLOG_ROOT."./cache/cache_setting.php")){ echo "<script language=Javascript> \n"; echo "alert('Please update cache!');\n"; echo "</script>\n"; } }else{ //更新缓存 settings_recache(); links_recache(); } */ return false; }
function update_data($echo, $DMC) { global $DBPrefix, $update_time, $update_logs; $modify_sql = array(); if ($DMC->getServerInfo() > '4.1') { $default_charset = " DEFAULT CHARACTER SET utf8"; } else { $default_charset = ""; } //从f2blog v1.0 build 0909升级 $delete_setting = false; if ($arr_query = $DMC->query("SELECT * FROM " . $DBPrefix . "setting where id='1'", 'T')) { $setInfo = $DMC->fetchArray($arr_query, MYSQL_ASSOC); if ($setInfo['language'] == "zh_cn") { $strGholidayDefault = "{0101,元旦}{0214,情人节}{0308,妇女节}{0401,愚人节}{0501,劳动节}{0512,F2BLOG成立日}{1001,国庆日}{1224,平安夜}{1225,圣诞节}{1226,圣诞节翌日}"; $strNholidayDefault = "{0101,年初一春节}{0102,年初二}{0103,年初三}{0104,年初四}{0105,年初五开市}{0115,元宵节}{0505,端午节}{0701,开鬼门}{0707,七夕情人节}{0815,中秋节}{0909,重阳节}"; } else { if ($setInfo['language'] == "zh_tw") { $strNholidayDefault = "{0101,年初一春節}{0102,年初二}{0103,年初三}{0104,年初四}{0105,年初五開市}{0115,元宵節}{0505,端午節}{0701,開鬼門}{0707,七夕情人節}{0815,中秋節}{0816,中秋節翌日}{0909,重陽節}"; $strGholidayDefault = "{0101,元旦}{0214,情人節}{0308,婦女節}{0401,愚人節}{0501,勞動節}{0512,F2BLOG成立日}{1224,平安夜}{1225,聖誕節}{1226,聖誕節翌日}"; } else { $strNholidayDefault = "{0101,Lunar New Year's Day}{0102,The second day of the Lunar New Year}{0103,The third day of the Lunar New Year}{0104,The forth day of the Lunar New Year}{0105,The fifth day of the Lunar New Year}{0115,Lantern Festival}{0505,Tuen Ng Festival}{0701,Ghost Gate Open Day}{0707,Chinese Valentine's Day}{0815,Chinese Mid-Autumn Festival}{0816,The day following Chinese Mid-Autumn Festival}{0909,Chung Yeung Festival}"; $strGholidayDefault = "{0101,New Year's Day}{0214,Valentine's Day}{0308,Women's Day}{0401,Fool's Day}{0501,Labour Day}{0512,F2BLOG Foundation Day}{1224,Christmas Eve}{1225,Christmas Day}{1226,The day following Christams Day}"; } } //默认值 if (file_exists(F2BLOG_ROOT . "./admin/admin_config.php")) { include F2BLOG_ROOT . "./admin/admin_config.php"; } else { $cfg_page_size = "15"; $cfg_upload_file = "gif,jpg,rar,zip,doc,xls,pdf,ico,png,swf,wma,wav,mp3,wmv"; $cfg_upload_size = 1024000; //以byte单位等于1M 1024000 $cfg_mouseover_color = "#FFFFCC"; $content_width = 500; $backup_size = 1024; // 以KB为单位 $editor_plugins = "f2blog,f2music,flash"; $editor_button1 = 'bold,italic,underline,separator,justifyleft,justifycenter,justifyright,separator,fontselect,fontsizeselect,forecolor,backcolor,separator,hr,link,unlink,flash,f2_music,separator,f2_hide,f2_more,f2_page,separator,code'; $editor_button2 = ''; $editor_button3 = ''; } $editor_button1 = str_replace(',justifyleft,justifycenter', ',pastetext,pasteword,separator,justifyleft,justifycenter,justifyright', $editor_button1); $editor_plugins = "paste," . $editor_plugins; $arr_setting[] = "('about','','0');"; $arr_setting[] = "('adminPageSize','" . $cfg_page_size . "','0');"; $arr_setting[] = "('adminPerPage','25','0');"; $arr_setting[] = "('ajaxstatus','','0');"; $arr_setting[] = "('archivesmonth','5','0');"; $arr_setting[] = "('attachDir','1','0');"; $arr_setting[] = "('attachType','" . $cfg_upload_file . "','0');"; $arr_setting[] = "('autoSave','0','0');"; $arr_setting[] = "('autoSplit','0','0');"; $arr_setting[] = "('backupSize','" . ceil($cfg_upload_size / 1000) . "','0');"; $arr_setting[] = "('blogKeyword','','0');"; $arr_setting[] = "('blogTitle','Free & Freedom Blog','0');"; $arr_setting[] = "('blogUrl','http://localhost','0');"; $arr_setting[] = "('categoryImgPath','images/tree/folder_gray','0');"; $arr_setting[] = "('closeReason','Close Blogs!','0');"; $arr_setting[] = "('commentOrder','asc','0');"; $arr_setting[] = "('commLength','800','0');"; $arr_setting[] = "('commPage','10','0');"; $arr_setting[] = "('commTimerout','30','0');"; $arr_setting[] = "('defaultedits','tiny','0');"; $arr_setting[] = "('defaultSkin','default','1');"; $arr_setting[] = "('disType','0','0');"; $arr_setting[] = "('downcode','0','0');"; $arr_setting[] = "('editPluginButton1','" . $editor_button1 . "','0');"; $arr_setting[] = "('editPluginButton2','" . $editor_button2 . "','0');"; $arr_setting[] = "('editPluginButton3','" . $editor_button3 . "','0');"; $arr_setting[] = "('editPluginName','" . $editor_plugins . "','0');"; $arr_setting[] = "('email','*****@*****.**','0');"; $arr_setting[] = "('favicon','','0');"; $arr_setting[] = "('gbookOrder','desc','0');"; $arr_setting[] = "('gbookPage','10','0');"; $arr_setting[] = "('gcalendar','" . $strGholidayDefault . "','0');"; $arr_setting[] = "('genThumb','0','0');"; $arr_setting[] = "('gzipstatus','0','0');"; $arr_setting[] = "('headcode','','0');"; $arr_setting[] = "('img_width','400','0');"; $arr_setting[] = "('isHtmlPage','0','0');"; $arr_setting[] = "('isLinkTagLog','1','0');"; $arr_setting[] = "('isProgramRun','1','0');"; $arr_setting[] = "('isRegister','1','0');"; $arr_setting[] = "('isTbApp','0','0');"; $arr_setting[] = "('isValidateCode','0','0');"; $arr_setting[] = "('language','zh_cn','0');"; $arr_setting[] = "('linkTagLog','10','0');"; $arr_setting[] = "('loginvalid','0','0');"; $arr_setting[] = "('logo','','0');"; $arr_setting[] = "('logscomment','10','0');"; $arr_setting[] = "('logsgbook','10','0');"; $arr_setting[] = "('logspage','18','0');"; $arr_setting[] = "('master','{$admin}','0');"; $arr_setting[] = "('mouseovercolor','#FFFFCC','0');"; $arr_setting[] = "('name','My F2Blog','0');"; $arr_setting[] = "('ncalendar','" . $strNholidayDefault . "','0');"; $arr_setting[] = "('newRss','10','0');"; $arr_setting[] = "('onlineTime','3600','0');"; $arr_setting[] = "('pagebar','A','0');"; $arr_setting[] = "('perPageList','20','0');"; $arr_setting[] = "('perPageNormal','8','0');"; $arr_setting[] = "('readpagebar','1','0');"; $arr_setting[] = "('registerClose','Close Register!','0');"; $arr_setting[] = "('rewrite','0','0');"; $arr_setting[] = "('rssContentType','1','0');"; $arr_setting[] = "('rssLength','500','0');"; $arr_setting[] = "('setattachments','0','1');"; $arr_setting[] = "('setcategories','0','1');"; $arr_setting[] = "('setcomments','" . $setInfo['commNums'] . "','1');"; $arr_setting[] = "('setguestbook','" . $setInfo['messageNums'] . "','1');"; $arr_setting[] = "('setlogs','" . $setInfo['logNums'] . "','1');"; $arr_setting[] = "('setmembers','" . $setInfo['memberNums'] . "','1');"; $arr_setting[] = "('settags','" . $setInfo['tagNums'] . "','1');"; $arr_setting[] = "('settrackbacks','" . $setInfo['tbNums'] . "','1');"; $arr_setting[] = "('showattach','0','0');"; $arr_setting[] = "('showcalendar','1','0');"; $arr_setting[] = "('showcate','0','0');"; $arr_setting[] = "('showcomment','0','0');"; $arr_setting[] = "('showguest','0','0');"; $arr_setting[] = "('showlogs','1','0');"; $arr_setting[] = "('showonline','1','0');"; $arr_setting[] = "('showquote','0','0');"; $arr_setting[] = "('showtags','0','0');"; $arr_setting[] = "('showtoday','1','0');"; $arr_setting[] = "('showtotal','1','0');"; $arr_setting[] = "('showuser','0','0');"; $arr_setting[] = "('showyester','1','0');"; $arr_setting[] = "('sidecommentlength','12','0');"; $arr_setting[] = "('sidecommentstyle','{title}','0');"; $arr_setting[] = "('sidegbooklength','12','0');"; $arr_setting[] = "('sidegbookstyle','{title}','0');"; $arr_setting[] = "('sidelogslength','12','0');"; $arr_setting[] = "('sidelogsPage','10','0');"; $arr_setting[] = "('sidelogsstyle','{title}','0');"; $arr_setting[] = "('skinSwitch','" . $skinSwitch . "','1');"; $arr_setting[] = "('status','0','0');"; $arr_setting[] = "('tagNums','50','0');"; $arr_setting[] = "('tbSiteList','','0');"; $arr_setting[] = "('thumbSize','200x200','0');"; $arr_setting[] = "('timeSystemFormat','Y-m-d H:i','0');"; $arr_setting[] = "('timezone','8','0');"; $arr_setting[] = "('trackNums','10','0');"; $arr_setting[] = "('uservalid','0','0');"; $arr_setting[] = "('visitNums','0','1');"; $arr_setting[] = "('applylink','1','0');"; $arr_setting[] = "('disSearch','0','0');"; $arr_setting[] = "('gbface','1','0');"; $arr_setting[] = "('disAttach','1','0');"; $arr_setting[] = "('forum_user','','0');"; $arr_setting[] = "('loginStatus','1','0');"; $arr_setting[] = "('disTags','1','0');"; $arr_setting[] = "('fastEditor','1','0');"; $arr_setting[] = "('allowTrackback','1','0');"; $arr_setting[] = "('allowComment','1','0');"; $arr_setting[] = "('showKeyword','0','0');"; $arr_setting[] = "('autoUrl','0','0');"; $arr_setting[] = "('showPrint','0','0');"; $arr_setting[] = "('showDown','0','0');"; $arr_setting[] = "('showMail','0','0');"; $arr_setting[] = "('linkshow','0','0');"; $arr_setting[] = "('showUBB','0','0');"; $arr_setting[] = "('linklogo','images/logo.gif','0');"; $arr_setting[] = "('adminstyle','default','0');"; $arr_setting[] = "('footcode','','0');"; $arr_setting[] = "('linkmarquee','0','0');"; $arr_setting[] = "('currFormatDate','Y-m-d H:i','0');"; $arr_setting[] = "('listFormatDate','m-d','0');"; $arr_setting[] = "('showAlertStyle','0','0');"; $arr_setting[] = "('weatherStatus','1','0');"; $arr_setting[] = "('treeCategory','0','0');"; foreach ($arr_setting as $key => $value) { foreach ($setInfo as $subkey => $subvalue) { if (strpos($value, "'{$subkey}'") > 0 && $subkey != "isRegister" && $subkey != "gbookPage" && $subkey != "commPage") { $subvalue = str_replace("'", "'", $subvalue); $arr_setting[$key] = preg_replace("/\\('(.*?)','(.*?)','(.*?)'\\);/is", "('\\1','" . $subvalue . "','\\3');", $value); break; } } } foreach ($arr_setting as $key => $value) { $insert_sql[] = "insert into " . $DBPrefix . "setting values" . $value; } $create_sql[] = "DROP TABLE IF EXISTS `{$DBPrefix}setting`;"; $create_sql[] = "CREATE TABLE `{$DBPrefix}setting` (\r\n\t\t\t\t\t\t`settName` varchar( 30 ) NOT NULL ,\r\n\t\t\t\t\t\t`settValue` tinytext NOT NULL,\r\n\t\t\t\t\t\t`settAuto` tinyint(1) NOT NULL default '0'\r\n\t\t\t\t\t ) ENGINE=MyISAM {$default_charset};\r\n\t\t\t\t\t "; $modify_sql = array_merge($create_sql, $insert_sql); $delete_setting = true; } else { //更新 v1.0 以后的设定值 $arr_setting = array(); $arr_setting['applylink'] = "1"; $arr_setting['disSearch'] = "0"; $arr_setting['gbface'] = "1"; $arr_setting['disAttach'] = "1"; $arr_setting['forum_user'] = ""; $arr_setting['loginStatus'] = "1"; $arr_setting['disTags'] = '1'; $arr_setting['fastEditor'] = '0'; $arr_setting['allowTrackback'] = '1'; $arr_setting['allowComment'] = '1'; $arr_setting['showKeyword'] = '0'; $arr_setting['autoUrl'] = '0'; $arr_setting['showPrint'] = '0'; $arr_setting['showDown'] = '0'; $arr_setting['showMail'] = '0'; $arr_setting['linkshow'] = '0'; $arr_setting['showUBB'] = '0'; $arr_setting['linklogo'] = 'images/logo.gif'; $arr_setting['adminstyle'] = 'new'; $arr_setting['footcode'] = ''; $arr_setting['linkmarquee'] = '0'; $arr_setting['currFormatDate'] = 'Y-m-d H:i'; $arr_setting['listFormatDate'] = 'm-d'; $arr_setting['showAlertStyle'] = '0'; $arr_setting['weatherStatus'] = '1'; $arr_setting['treeCategory'] = '0'; foreach ($arr_setting as $key => $value) { if (!$DMC->fetchArray($DMC->query("select * from " . $DBPrefix . "setting where settName='{$key}'"))) { $modify_sql[] = "insert into " . $DBPrefix . "setting values('{$key}','{$value}','0')"; } } //新增粘贴插件 if (!$DMC->fetchArray($DMC->query("select * from " . $DBPrefix . "setting where settName='editPluginName' and settValue like '%paste%'"))) { $modify_sql[] = "update " . $DBPrefix . "setting set settValue=concat('paste,',settValue) where settName='editPluginName'"; $modify_sql[] = "update " . $DBPrefix . "setting set settValue=replace(settValue,',justifyleft,justifycenter',',pastetext,pasteword,separator,justifyleft,justifycenter,justifyright') where settName='editPluginButton1'"; } //清除属性(2007-02-01) if ($DMC->fetchArray($DMC->query("select * from " . $DBPrefix . "setting where settName='disTop'"))) { $modify_sql[] = "delete from {$DBPrefix}setting where settName='disTop' or settName='calendarmonth'"; } } //更新数据表(2006-11-11) if (!$DMC->query("SELECT cateIcons FROM " . $DBPrefix . "categories", 'T')) { $modify_sql[] = "DROP TABLE IF EXISTS `{$DBPrefix}linkgroup`;"; $modify_sql[] = "CREATE TABLE `{$DBPrefix}linkgroup` (\r\n\t\t\t\t\t\t`id` int(3) NOT NULL auto_increment,\r\n\t\t\t\t\t\t`name` varchar(50) NOT NULL,\r\n\t\t\t\t\t\t`isSidebar` tinyint(1) NOT NULL default '0',\r\n\t\t\t\t\t\t`orderNo` int(5) NOT NULL default '0',\r\n\t\t\t\t\t\tPRIMARY KEY (`id`),\r\n\t\t\t\t\t\tKEY `name` (`name`)\r\n\t\t\t\t\t\t) ENGINE=MyISAM {$default_charset};\r\n\t\t\t\t\t "; $modify_sql[] = "ALTER TABLE `{$DBPrefix}logs` ADD `autoSplit` int(8) NOT NULL default '0'"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}categories` ADD `cateIcons` tinyint(4) NOT NULL default '1'"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` ADD `lnkGrpId` int(3) NOT NULL default '1'"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` ADD `blogLogo` varchar(150) NOT NULL default ''"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` ADD `isApp` tinyint(1) NOT NULL default '0'"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}links` CHANGE `isHidden` `isSidebar` tinyint(1) NOT NULL default '0'"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}attachments` CHANGE `attTitle` `attTitle` varchar(150) NOT NULL default ''"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}members` CHANGE `role` `role` varchar(8) NOT NULL default 'user'"; $modify_sql[] = "INSERT INTO `{$DBPrefix}modules` VALUES (17, 'links', '[var]strLinks[/var]', 1, 0, 0, 4, 1, '', 'include/links.inc.php', 0, '', 0, '', 0, '')"; $modify_sql[] = "INSERT INTO `{$DBPrefix}modules` VALUES (18, 'archives', '[var]strArchives[/var]', 1, 0, 0, 4, 1, '', 'include/archives.inc.php', 0, '', 0, '', 0, '')"; $modify_sql[] = "INSERT INTO `{$DBPrefix}modules` VALUES (19, 'userPanel', '[var]strUserPanel[/var]', 2, 1, 0, 1, 1, 'side_userPanel()', '', 0, '', 0, '', 0, '')"; $modify_sql[] = "UPDATE `{$DBPrefix}modules` set modTitle='[var]strHomePageGBook[/var]' where id='16'"; $modify_sql[] = "INSERT INTO `{$DBPrefix}linkgroup` VALUES ('1', 'Links', '1', '1')"; $modify_sql[] = "UPDATE {$DBPrefix}links set lnkGrpId='1',isApp='1',isSidebar='1'"; $modify_sql[] = "UPDATE {$DBPrefix}categories set cateIcons='1'"; } //更新评论2007-02-01,因为恢复的地方没有使用它。 if (!$DMC->query("SELECT homepage FROM " . $DBPrefix . "comments", 'T')) { $modify_sql[] = "ALTER TABLE `{$DBPrefix}setting` CHANGE `settValue` `settValue` text NOT NULL"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}comments` ADD `homepage` varchar(100) NOT NULL default ''"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}comments` ADD `email` varchar(100) NOT NULL default ''"; $modify_sql[] = "ALTER TABLE `{$DBPrefix}comments` ADD `face` varchar(30) NOT NULL default ''"; } //更新附件的文件类别(2007-02-01 $arrResult = $DMC->fetchQueryAll($DMC->query("SELECT name,id FROM " . $DBPrefix . "attachments where not fileType like '%/%' and not fileType like '%-%' ")); foreach ($arrResult as $value) { if ($value['name'] != "") { $fileType = updateFileType($value['name']); $modify_sql[] = "update " . $DBPrefix . "attachments set fileType='{$fileType}' where id='" . $value['id'] . "'"; } } //运行SQL语句 foreach ($modify_sql as $key => $value) { $DMC->query($value, "T"); if ($echo) { if ($DMC->error()) { echo $value . " ... <font color=red>" . $DMC->error() . "</font><br />"; } else { echo $value . " ... <font color=blue>OK</font><br />"; } } } $i = 0; $contents = "\$update_logs = array(\r\n"; $contents .= "\t'{$i}' => '{$update_time}',\r\n"; for ($i = 0; $i < count($update_logs); $i++) { $j = $i + 1; $contents .= "\t'{$j}' => '" . $update_logs[$i] . "',\r\n"; } $contents .= ");"; writetocache('update_logs', $contents); //清空缓存 if ($delete_setting == true) { //0909升级需要重新建立setting文件。 if (!@unlink(F2BLOG_ROOT . "./cache/cache_setting.php")) { echo "<script language=Javascript> \n"; echo "alert('Please update cache!');\n"; echo "</script>\n"; } } else { //更新缓存 settings_recache(); links_recache(); } }
function reAllCache() { settings_recache(); modules_recache(); categories_recache(); hottags_recache(); archives_recache(); links_recache(); keywords_recache(); filters_recache(); recentLogs_recache(); recentGbooks_recache(); recentComments_recache(); calendar_recache(); statistics_recache(); categories_recount(); }
function rethestats($cachename = '') { global $DB, $db_prefix; if (!$cachename || $cachename == 'settings') { settings_recache(); } if (!$cachename || $cachename == 'statistics') { // 更新首页显示的文章数 $article_count = $DB->result($DB->query("SELECT COUNT(articleid) FROM {$db_prefix}articles WHERE visible = '1'"), 0); // 更新首页显示的评论数 $comment_count = $DB->result($DB->query("SELECT COUNT(commentid) FROM {$db_prefix}comments c LEFT JOIN {$db_prefix}articles a ON (a.articleid=c.articleid) WHERE a.visible='1' AND c.visible='1'"), 0); // 更新首页显示的标签(Tags)数 $tag_count = $DB->result($DB->query("SELECT COUNT(mid) FROM {$db_prefix}metas WHERE type='tag'"), 0); $DB->unbuffered_query("UPDATE {$db_prefix}statistics SET article_count='{$article_count}', comment_count='{$comment_count}', tag_count='{$tag_count}'"); //$DB->unbuffered_query("DELETE FROM {$db_prefix}metas WHERE type='tag' AND count=0"); // 更新主人发表文章数 $query = $DB->query("SELECT userid,articles FROM {$db_prefix}users WHERE groupid='1' OR groupid='2'"); while ($user = $DB->fetch_array($query)) { $total = $DB->result($DB->query("SELECT COUNT(articleid) FROM {$db_prefix}articles WHERE visible = '1' AND uid='" . $user['userid'] . "'"), 0); if ($user['articles'] != $total) { $DB->unbuffered_query("UPDATE {$db_prefix}users SET articles='{$total}' WHERE userid='" . $user['userid'] . "'"); } } statistics_recache(); } if (!$cachename || $cachename == 'newarticles') { newarticles_recache(); } if (!$cachename || $cachename == 'stick') { stick_recache(); } if (!$cachename || $cachename == 'newcomments') { newcomments_recache(); } if (!$cachename || $cachename == 'categories') { // 更新所有文章的评论数 $query = $DB->query("SELECT mid,count FROM {$db_prefix}metas"); while ($meta = $DB->fetch_array($query)) { $ctotal = get_meta_article_count($meta['mid']); if ($meta['count'] != $ctotal) { update_meta_count($meta['mid'], $ctotal); } } categories_recache(); } if (!$cachename || $cachename == 'archives') { // 重建文章数据 $query = $DB->query("SELECT articleid,comments FROM {$db_prefix}articles"); while ($article = $DB->fetch_array($query)) { // 更新所有文章的评论数 $ctotal = $DB->result($DB->query("SELECT COUNT(commentid) FROM {$db_prefix}comments WHERE articleid='" . $article['articleid'] . "' AND visible='1'"), 0); if ($article['comments'] != $ctotal) { $DB->unbuffered_query("UPDATE {$db_prefix}articles SET comments='{$ctotal}' WHERE articleid='" . $article['articleid'] . "'"); } } archives_recache(); } if (!$cachename || $cachename == 'hottags') { hottags_recache(); } if (!$cachename || $cachename == 'links') { links_recache(); } if (!$cachename || $cachename == 'stylevars') { stylevars_recache(); } if (!$cachename || $cachename == 'allarticleids') { allarticleids_recache(); } }
function restats() { allarticleids_recache(); links_recache(); newarticles_recache(); newcomments_recache(); settings_recache(); categories_recache(); statistics_recache(); archives_recache(); hottags_recache(); stylevars_recache(); stick_recache(); }