« Blogging Wishlist |
Main Index
| The Bigger Gold Box »
comments | incoming pings | outgoing pings
if (time() > strtotime ("September 13, 2002 10:48 PM")) { ?>
Voting in "Fun With Macros"
It's time to vote for a photo in Photojunkie's 100K Photo Contests "Fun With Macros" category. My entry is the lionfish entitled "Fish Face."
.: Posted September 13, 2002 10:48 PM in $entry_cats="Participation, ";print substr($entry_cats, 0, -2); ?> :.$blogid = "1"; //replace this with the blog_id of your blog $entry_id = "1235"; $pingcount = mysql_query("SELECT p.tbping_blog_id, t.trackback_entry_id FROM mt_tbping p, mt_trackback t WHERE (p.tbping_blog_id = $blogid) and (t.trackback_entry_id = $entry_id) and (t.trackback_id = p.tbping_tb_id)"); $count = mysql_num_rows($pingcount); echo ""; echo "Trackbacks on this post: ", $count, ""; $pingarray = "SELECT p.tbping_source_url, p.tbping_blog_name, p.tbping_created_on, p.tbping_excerpt, p.tbping_tb_id, t.trackback_id, t.trackback_entry_id FROM mt_tbping p, mt_trackback t WHERE (p.tbping_blog_id = $blogid) and (t.trackback_entry_id = $entry_id) and (t.trackback_id = p.tbping_tb_id)"; $resultping = mysql_query($pingarray) or die (mysql_error()); while ($row = mysql_fetch_array($resultping)) { //set up the variables being used - the date can be configured below $url = ($row['tbping_source_url']); $blog = ($row['tbping_blog_name']); $date = date("F d, Y g:i A", strtotime($row['tbping_created_on'])); $excerpt = ($row['tbping_excerpt']); echo "
", $excerpt, "
Posted by ";
echo "", $blog, "";
echo " on ", $date, "
";
}
?>
Ping this post
http://www.neuroticfishbowl.com/mt/mt-tb.cgi/498
$pingsent = "SELECT entry_pinged_urls FROM mt_entry WHERE $entry_id = entry_id and entry_pinged_urls !=\"\""; $pingsentcountresult = mysql_query($pingsent) or die (mysql_error()); $pingsentcountarray = mysql_fetch_row($pingsentcountresult); $pingsentcounts=explode("\n", $pingsentcountarray[0]); ?> if (!is_array($pingsentcountarray)) { echo "No URLs Pinged"; } else { $pingsentcount = count($pingsentcounts); if ($pingsentcount=="1") { echo $pingsentcount, " URL Pinged:";} else {echo "URLs Pinged: ", $pingsentcount;} } ?>
"..."
Comments } else { ?>
You're too early! Come back at September 13, 2002 10:48 PM to see this post.>
} ?>
Post a comment
{HTML ok, IP address logged}
Enter e-mail address to subscribe/unsubscribe to comments on this post without having to post a comment:
Subscribe to post
Unsubscribe to post
E-mail:
(e-mail field must be filled in) -->
* Please note: Comments that are inappropriate
will be deleted - mean, spiteful, rude comments. Don't let that stop
you from posting comments. Just wanted to let you know the rules of
the house.