";
// Print a table header
echo "| ID | Domain | Path | ";
if($extended) {
echo "All Comments | ";
echo "Not Spam | ";
echo "% Spam | ";
echo "Posts | ";
echo "Pages | ";
echo "Links | ";
echo "Categories | ";
}
echo "
|---|
";
for($i=0; $i$id | $domain | $path | ";
// Now we get extended info... IF configured
if($extended) {
// Number of comments
$query = "SELECT COUNT(comment_ID) AS totalcomments FROM wp_" . $id . "_comments";
$rsl = query($query);
$comments = mysql_result($rsl, 0, 'totalcomments');
echo "$comments | ";
// Visible comments
$query = "SELECT COUNT(comment_ID) AS nonspam FROM wp_" . $id . "_comments WHERE comment_approved='1'";
$rsl = query($query);
$visible = mysql_result($rsl,0,'nonspam');
echo "$visible | ";
// Calculate % good
if($comments) {
$pct_good = round(($visible / $comments) * 100, 3);
$pct_good = (100-$pct_good);
echo "$pct_good% | ";
} else echo "n/a | ";
// Total posts
$query = "SELECT COUNT(ID) AS countposts FROM wp_" . $id . "_posts WHERE post_type='post'";
$rsl = query($query);
$posts = mysql_result($rsl,0,'countposts');
echo "$posts | ";
// Total pages
$query = "SELECT COUNT(ID) AS countpages FROM wp_" . $id . "_posts WHERE post_type='page'";
$rsl = query($query);
$pages = mysql_result($rsl,0,'countpages');
echo "$pages | ";
// Links
$query = "SELECT COUNT(link_id) AS links FROM wp_" . $id . "_links";
$rsl = query($query);
$links = mysql_result($rsl,0,'links');
echo "$links | ";
// Categories
$query = "SELECT COUNT(term_id) AS cats from wp_" . $id . "_terms";
$rsl = query($query);
$cats = mysql_result($rsl,0,'cats');
echo "$cats | ";
}
// we close the row
echo "";
}
echo "";
?>