function guestBookPost($intSpamFiler, $intIsSecret) { global $DMC, $DBPrefix, $arrSideModule; $parent = 0; $_POST['isSecret'] = !empty($_POST['isSecret']) ? $_POST['isSecret'] : 0; $author = !empty($_POST['username']) ? $_POST['username'] : $_SESSION['username']; $replypassword = !empty($_POST['replypassword']) ? md5($_POST['replypassword']) : ""; if (!empty($_POST['homepage'])) { if (strpos(";" . $_POST['homepage'], "http://") < 1) { $homepage = "http://" . $_POST['homepage']; } else { $homepage = $_POST['homepage']; } } else { $homepage = ""; } $email = !empty($_POST['email']) ? $_POST['email'] : ""; $_POST['bookface'] = !empty($_POST['bookface']) ? $_POST['bookface'] : "face1"; $sql = "insert into " . $DBPrefix . "guestbook(author,password,homepage,email,ip,content,postTime,isSecret,parent,face,isSpam) values('{$author}','{$replypassword}','" . encode($homepage) . "','" . encode($email) . "','" . getip() . "','" . encode($_POST['message']) . "','" . time() . "','" . max(intval($intIsSecret), intval($_POST['isSecret'])) . "','{$parent}','" . substr(encode($_POST['bookface']), 4) . "','" . $intSpamFiler . "')"; //echo $sql; $DMC->query($sql); //更新cache settings_recount("guestbook"); settings_recache(); recentGbooks_recache(); logs_sidebar_recache($arrSideModule); //保存时间 $_SESSION['replytime'] = time(); }
function skinlist_recache() { global $settingInfo, $arrSideModule, $DMC, $DBPrefix; //列出Skins目录 $handle = opendir(F2BLOG_ROOT . "./skins/"); while (false !== ($file = readdir($handle))) { if (is_dir(F2BLOG_ROOT . "./skins/{$file}") && file_exists(F2BLOG_ROOT . "./skins/{$file}/skin.xml")) { $arrSkinList[$file] = getSkinInfo($file); } } closedir($handle); $contents = "\$skinlistcache = array(\r\n"; foreach ($arrSkinList as $key => $value) { $contents .= "\t'" . $key . "' => array(\n\t\t"; foreach ($value as $subkey => $subvalue) { if ($subvalue != "" && in_array($subkey, array('SkinName', 'SkinSource', 'SkinDesigner', 'DesignerURL', 'DesignerMail', 'UseFlash', 'FlashPath', 'FlashWidth', 'FlashHeight', 'FlashAlign', 'FlashTop', 'FlashTransparent'))) { $contents .= "'{$subkey}' => '" . $subvalue . "',\n\t\t"; } } $contents .= "),\n"; } $contents .= ");"; writetocache('skinlist', $contents); //保存当前skin信息 if (file_exists(F2BLOG_ROOT . "./skins/" . $settingInfo['defaultSkin'] . "/skin.xml")) { $arrDefaultSkinInfo = getSkinInfo($settingInfo['defaultSkin']); } else { //如果默认skin不存在,则选择上述列表中的第一个皮肤做为默认皮肤。 $arrDefaultSkinInfo = $value; $DMC->query("update " . $DBPrefix . "setting set settValue='" . $key . "' where settName='defaultSkin'"); settings_recache(); } $contents = "\$defaultskincache = array(\r\n"; foreach ($arrDefaultSkinInfo as $subkey => $subvalue) { if ($subvalue != "" && in_array($subkey, array('SkinName', 'SkinSource', 'SkinDesigner', 'DesignerURL', 'DesignerMail', 'UseFlash', 'FlashPath', 'FlashWidth', 'FlashHeight', 'FlashAlign', 'FlashTop', 'FlashTransparent'))) { $contents .= "\t'{$subkey}' => '" . $subvalue . "',\n"; } } $contents .= ");"; writetocache('defaultskin', $contents); }
@unlink(F2BLOG_ROOT . "./cache/html/{$mark_id}_index.php"); } } $sql = "delete from " . $DBPrefix . "logs where {$stritem}"; $DMC->query($sql); //删除关联的评论和引用 $stritem1 = str_replace("id=", "logId=", $stritem); $sql = "delete from " . $DBPrefix . "comments where {$stritem1}"; $DMC->query($sql); $sql = "delete from " . $DBPrefix . "trackbacks where {$stritem1}"; $DMC->query($sql); settings_recount("logs"); //更新Cache hottags_recache(); categories_recache(); settings_recache(); recentLogs_recache(); recentComments_recache(); archives_recache(); calendar_recache(); attachments_recache(); logsTitle_recache(); logs_sidebar_recache($arrSideModule); } } //引用传送 if ($action == "sendtb") { $mark_id = $_GET['mark_id']; $quoteUrl = $_POST['quoteUrl']; $dataInfo = getRecordValue($DBPrefix . "logs", " id='{$mark_id}'"); header("Content-Type: text/html; charset=utf-8");
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; }
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 guestBookPost($intSpamFiler, $intIsSecret) { global $DMC, $DBPrefix, $arrSideModule, $settingInfo; $_POST['isSecret'] = isset($_POST['isSecret']) ? $_POST['isSecret'] : 0; $author = isset($_POST['username']) ? $_POST['username'] : $_SESSION['username']; $replypassword = isset($_POST['replypassword']) ? md5($_POST['replypassword']) : ""; //$_POST['homepage']=(isset($_POST['homepage']))?$_POST['homepage']:""; if (!empty($_POST['homepage'])) { if (strpos(";" . $_POST['homepage'], "http://") < 1) { $_POST['homepage'] = "http://" . $_POST['homepage']; } } else { $_POST['homepage'] = ""; } $_POST['email'] = isset($_POST['email']) ? $_POST['email'] : ""; $_POST['bookface'] = !empty($_POST['bookface']) ? $_POST['bookface'] : "face1"; if ($_GET['load'] == "read") { //评论 $sql = "insert into " . $DBPrefix . "comments(author,password,logId,homepage,email,face,ip,content,postTime,isSecret,parent) values('{$author}','{$replypassword}','" . $id . "','" . encode($_POST['homepage']) . "','" . encode($_POST['email']) . "','" . substr(encode($_POST['bookface']), 4) . "','" . getip() . "','" . encode($_POST['message']) . "','" . time() . "','" . max(intval($intIsSecret), intval($_POST['isSecret'])) . "','{$postid}')"; } else { $sql = "insert into " . $DBPrefix . "guestbook(author,password,homepage,email,ip,content,postTime,isSecret,parent,face) values('{$author}','{$replypassword}','" . encode($_POST['homepage']) . "','" . encode($_POST['email']) . "','" . getip() . "','" . encode($_POST['message']) . "','" . time() . "','" . max(intval($intIsSecret), intval($_POST['isSecret'])) . "','{$postid}','" . substr(encode($_POST['bookface']), 4) . "')"; } //echo $sql; $DMC->query($sql); //保存时间 $_SESSION['replytime'] = time(); //更新cache if ($_GET['load'] == "read") { //评论 //更新LOGS评论数量 settings_recount("comments"); settings_recache(); $DMC->query("UPDATE " . $DBPrefix . "logs SET commNums=commNums+1 WHERE id='{$id}'"); //更新cache recentComments_recache(); logs_sidebar_recache($arrSideModule); } else { settings_recount("guestbook"); settings_recache(); recentGbooks_recache(); logs_sidebar_recache($arrSideModule); } //不使用Ajax技术 if (strpos(";{$settingInfo['ajaxstatus']};", "G") < 1) { $load = $_GET['load']; $page = $_GET['page']; echo "<script language=javascript> \n"; if ($_GET['load'] == "read") { if ($settingInfo['rewrite'] == 0) { $gourl = "index.php?load={$load}&id={$id}&page={$page}"; } if ($settingInfo['rewrite'] == 1) { $gourl = "rewrite.php/{$load}-{$id}-{$page}"; } if ($settingInfo['rewrite'] == 2) { $gourl = "{$load}-{$id}-{$page}"; } echo " opener.location.href='{$gourl}{$settingInfo['stype']}';\n"; echo " opener.reload;\n"; } else { if ($settingInfo['rewrite'] == 0) { $gourl = "index.php?load={$load}&page={$page}"; } if ($settingInfo['rewrite'] == 1) { $gourl = "rewrite.php/{$load}-{$page}"; } if ($settingInfo['rewrite'] == 2) { $gourl = "{$load}-{$page}"; } echo " opener.location.href='{$gourl}{$settingInfo['stype']}';\n"; echo " opener.reload;\n"; } echo " window.close();\n"; echo "</script> \n"; exit; } }
function guestBookPost($id, $intSpamFiler, $intIsSecret, $settingInfo, $gourl) { global $DMC, $DBPrefix, $arrSideModule; $parent = 0; $_POST['isSecret'] = $_POST['isSecret'] ? $_POST['isSecret'] : 0; $author = $_POST['username'] ? $_POST['username'] : $_SESSION['username']; $replypassword = $_POST['replypassword'] ? md5($_POST['replypassword']) : ""; $_POST['bookface'] = !empty($_POST['bookface']) ? $_POST['bookface'] : "face1"; if (isset($_POST['homepage'])) { if (strpos(";" . $_POST['homepage'], "http://") < 1) { $_POST['homepage'] = "http://" . $_POST['homepage']; } } else { $_POST['homepage'] = ""; } $_POST['email'] = !empty($_POST['email']) ? $_POST['email'] : ""; $sql = "insert into " . $DBPrefix . "comments(author,password,logId,homepage,email,face,ip,content,postTime,isSecret,parent) values('{$author}','{$replypassword}','" . $id . "','" . encode($_POST['homepage']) . "','" . encode($_POST['email']) . "','" . substr(encode($_POST['bookface']), 4) . "','" . getip() . "','" . encode($_POST['message']) . "','" . time() . "','" . max(intval($intIsSecret), intval($_POST['isSecret'])) . "','{$parent}')"; //echo $sql; $DMC->query($sql); //更新LOGS评论数量 settings_recount("comments"); settings_recache(); $DMC->query("UPDATE " . $DBPrefix . "logs SET commNums=commNums+1 WHERE id='{$id}'"); //更新cache recentComments_recache(); logs_sidebar_recache($arrSideModule); //保存时间 $_SESSION['replytime'] = time(); //清空内容 $_POST['message'] = ""; header("location:" . str_replace("&", "&", $gourl) . "{$settingInfo['stype']}"); exit; }
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 blogger_deletePost($values) { global $settingInfo, $DMC, $DBPrefix, $arrSideModule; global $strArrayMonth, $strArrayDay, $strYear, $strMonth, $arrWeek, $strDayLogs, $strCalendar; global $strModifyInfo, $strLogout, $strLoginSubmit, $strUserRegister; global $strSearchErr, $strKeyword, $strSearchTitle, $strSearchContent, $strSearchTitleContent, $strFind; $userdetail = check_user_pw($values['username'], $values['password']); $records = $DMC->fetchArray($DMC->query("SELECT * FROM `{$DBPrefix}logs` WHERE `id`='{$values['postid']}'")); if ($records['id'] == '') { xml_error("Entry does not exist."); } else { $DMC->query("DELETE FROM `{$DBPrefix}logs` WHERE `id`='{$values['postid']}'"); //更新Cache settings_recount("logs"); settings_recache(); categories_recount(); categories_recache(); recentLogs_recache(); archives_recache(); calendar_recache(); logsTitle_recache(); logs_sidebar_recache($arrSideModule); $xml_logContent = make_xml_piece("boolean", '1'); $body_xml = xml_generate($xml_logContent); //writetofile ("text2.xml", $body_xml); //For debug use send_response($body_xml); } }
function guestBookPost($intSpamFiler, $intIsSecret) { global $DMC, $DBPrefix, $arrSideModule; $parent = 0; $_POST['isSecret'] = $_POST['isSecret'] ? $_POST['isSecret'] : 0; $author = $_POST['username'] ? $_POST['username'] : $_SESSION['username']; $replypassword = $_POST['replypassword'] ? md5($_POST['replypassword']) : ""; $_POST['bookface'] = !empty($_POST['bookface']) ? $_POST['bookface'] : "face1"; if (!empty($_POST['homepage'])) { if (strpos(";" . $_POST['homepage'], "http://") < 1) { $_POST['homepage'] = "http://" . $_POST['homepage']; } } else { $_POST['homepage'] = ""; } $sql = "insert into " . $DBPrefix . "guestbook(author,password,homepage,email,ip,content,postTime,isSecret,parent,face,isSpam) values('{$author}','{$replypassword}','" . encode($_POST['homepage']) . "','" . encode($_POST['email']) . "','" . getip() . "','" . encode($_POST['message']) . "','" . time() . "','" . max(intval($intIsSecret), intval($_POST['isSecret'])) . "','{$parent}','" . substr(encode($_POST['bookface']), 4) . "','" . $intSpamFiler . "')"; //echo $sql; $DMC->query($sql); //更新cache settings_recount("guestbook"); settings_recache(); recentGbooks_recache(); logs_sidebar_recache($arrSideModule); //保存时间 $_SESSION['replytime'] = time(); //清空内容 $_POST['message'] = ""; //echo "<script language=\"javascript\">window.location.href='$gourl';</script>"; //echo "<script language=\"javascript\">window.reload</script>"; header("location:" . str_replace("&", "&", $gourl) . "{$settingInfo['stype']}"); exit; }
function restats() { allarticleids_recache(); links_recache(); newarticles_recache(); newcomments_recache(); settings_recache(); categories_recache(); statistics_recache(); archives_recache(); hottags_recache(); stylevars_recache(); stick_recache(); }