$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\" ?>";
