query("SELECT id FROM {$table_prefix}blogs WHERE pagename='$p'");
if($blogq->num_rows > 0) {
$res = $blogq->fetch_assoc();
$blogid = $res['id'];
$postq = $mysqli->query("SELECT tracksacc FROM {$table_prefix}blogposts WHERE id='$m' AND blogid='$blogid'");
if($postq->num_rows > 0) {
$res = $postq->fetch_assoc();
$tracksacc = $res['tracksacc'];
if($tracksacc == "1") {
$tracksq = $mysqli->query("SELECT fromurl FROM {$table_prefix}trackbacks WHERE pageid='$blogid' AND entryid='$m'");
if($tracksq->num_rows > 0) $error = "Your URL has already been submitted for a trackback on this post.";
else {
$insertdata = "NULL, '$blogid', '$m', '$blog_name - $title', '$tb_url', '$excerpt', '$curtime', '$trackmod'";
if(!$mysqli->query("INSERT INTO {$table_prefix}trackbacks VALUES($insertdata)")) $error = "Sorry - trackback info could not written to database.";
else {
if($commsmail == 1) {
$titleq = $mysqli->query("SELECT * FROM {$table_prefix}$area WHERE id='$blogid'");
if($titleq->num_rows > 0) {
$res = $titleq->fetch_assoc();
$pagetitle = $res['pagetitle'];
$pagename = $res['pagename'];
$entryq = $mysqli->query("SELECT * FROM {$table_prefix}blogposts WHERE id='$m'");
$res = $entryq->fetch_assoc();
$pagetitle .= " $splitter " . $res['entrytitle'];
$entryname = $res['pagename'];
$urlbit = "news/$pagename/$entryname/";
$subject = "$sitetitle $splitter New trackback on $pagetitle";
$message = "Hello,\n\nA new trackback has been posted on your site, in "$pagetitle":\n\n$commmessage\n\nTo view who posted it, and any other trackbacks, go to {$baseurl}$urlbit\n\nThanks,\n\n$sitetitle";
htmlmail($siteemail, "\"$sitetitle\" <$siteemail>", $subject, $message);
}
}
}
}
}
else $error = "Sorry - that post does not accept trackbacks.";
}
else $error = "Post does not exist";
}
else $error = "Blog does not exist.";
if(!empty($error)) $err = 1;
response($err, $error);
}
function response($err, $error) {
header('Content-Type: text/xml');
if ($err == "1") {
echo '\n";
echo "\n";
echo "1\n";
echo "$error\n";
echo "";
die();
}
else {
echo '\n";
echo "\n";
echo "0\n";
echo "";
}
}
?>