$result = $DMC->query($sql); while ($my = $DMC->fetchArray($result)) { @unlink("../attachments/" . $my['name']); } $sql = "delete from " . $DBPrefix . "attachments where logId='{$mark_id}'"; $DMC->query($sql); } $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); add_bloginfo("logNums", "minus", count($itemlist)); //更新Cache hottags_recache(); categories_recache(); settings_recache(); recentLogs_recache(); recentComments_recache(); archives_recache(); calendar_recache(); } } //引用传送 if ($action == "sendtb") { $mark_id = $_GET['mark_id']; $quoteUrl = $_POST['quoteUrl']; $dataInfo = getRecordValue($DBPrefix . "logs", " id='{$mark_id}'");
$empty_sql = "delete from " . $DBPrefix . "visits where visittime<='{$prevtime}'"; $DMF->query($empty_sql); // 是否增加访问记录 (1小时之内相同IP不增加) $sameip_time = time() - 3600; $same_sql = "select * from " . $DBPrefix . "visits where visittime<'" . time() . "' and visittime>='{$sameip_time}' and ip='" . getip() . "'"; $same_result = $DMF->query($same_sql); if ($DMF->numRows() == 0) { $DMF->query("insert into " . $DBPrefix . "visits (ip,visittime) values ('" . getip() . "','" . time() . "')"); $query = $DMF->query("SELECT visitDate FROM " . $DBPrefix . "dailystatistics WHERE visitDate='" . $curDate . "'"); $num = $DMF->numRows(); if ($num == 0) { $DMF->query("insert into " . $DBPrefix . "dailystatistics (visitDate,visits) values ('{$curDate}','1')"); } else { $DMF->query("UPDATE " . $DBPrefix . "dailystatistics SET visits = visits+1 where visitDate='{$curDate}'"); } add_bloginfo("visitNums", "adding", 1); } // 统计在线人数 (以1小时内) $online_time = time() - 3600; $online_sql = "select * from " . $DBPrefix . "visits where visittime<='" . time() . "' and visittime>='{$online_time}'"; $online_result = $DMF->query($online_sql); $online_count = $DMF->numRows(); // 增加Blog基本信息中的日志,评论等数量 function add_bloginfo($field, $type, $value) { global $DMF, $DBPrefix; $types = $type == "adding" ? "+" : "-"; $modify_sql = "UPDATE " . $DBPrefix . "setting set {$field}={$field}{$types}{$value} WHERE id=1"; $DMF->query($modify_sql); } // 取得$table表中符合条件$where的整条记录值
$trytb = $DMF->numRows($DMF->query("SELECT * FROM " . $DBPrefix . "trackbacks WHERE ip='" . getip() . "' AND postTime+30>='" . time() . "'")); if ($trytb > 0) { tb_xml_error("Error."); } $spam = $settingInfo['isTbApp']; // 1为开启审核 if ($spam == 0 or strpos($url, ";" . $settingInfo['ttSiteList']) >= 1) { $isApp = 1; } else { $isApp = 0; } @fopen_url($url); $sql = "INSERT INTO " . $DBPrefix . "trackbacks (logId,tbTitle,blogSite,blogUrl,content,postTime,ip,isApp) VALUES ('{$tid}',\"{$title}\",\"{$blog_name}\",\"{$url}\",\"{$excerpt}\"," . time() . ",'" . getip() . "','{$isApp}')"; $DMF->query($sql); if ($isApp == 1) { add_bloginfo("tbNums", "adding", 1); $DMF->query("UPDATE " . $DBPrefix . "logs SET quoteNums=quoteNums+1 WHERE id='{$tid}'"); settings_recache(); } tb_xml_success(); function tb_xml_error($error) { header("Content-type:application/xml"); echo "<?xml version=\"1.0\" ?>"; print "<response><error>1</error><message>{$error}</message></response>"; exit; } function tb_xml_success() { header("Content-type:application/xml"); echo "<?xml version=\"1.0\" ?>";