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;
$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')";
}
}
}
//运行ＳＱＬ语句
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;
}
}
//其它操作行为：编辑、删除等
if ($action == "operation") {
$stritem = "";
$itemlist = $_POST['itemlist'];
for ($i = 0; $i < count($itemlist); $i++) {
if ($stritem != "") {
$stritem .= " or id='{$itemlist[$i]}'";
} else {
$stritem .= "id='{$itemlist[$i]}'";
}
}
if ($_POST['operation'] == "delete" and $stritem != "") {
$sql = "delete from " . $DBPrefix . "filters where {$stritem}";
$DMC->query($sql);
filters_recache();
}
}
if ($action == "all") {
$seekname = "";
$seekcategory = "";
}
$seek_url = "{$PHP_SELF}?order={$order}";
//查找用链接
$order_url = "{$PHP_SELF}?seekname={$seekname}&seekcategory={$seekcategory}";
//排序栏用的链接
$page_url = "{$PHP_SELF}?seekname={$seekname}&seekcategory={$seekcategory}&order={$order}";
//页面导航链接
$edit_url = "{$PHP_SELF}?seekname={$seekname}&seekcategory={$seekcategory}&order={$order}&page={$page}";
//编辑或新增链接
if ($action == "add") {
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();
}
