« Fonty Goodness |
Main Index
| Insomnia »
comments | incoming pings | outgoing pings
if (time() > strtotime ("April 23, 2004 04:33 PM")) { ?>
Being a Bug
Thanks to Katie, I'm now a bug on Breedster. Well, right now I'm a larva, but soon I'll grow up and be a bug. Here's what I look like:
$blogid = "1"; //replace this with the blog_id of your blog $entry_id = "2657"; $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, "
Ping this post
http://www.neuroticfishbowl.com/mt/mt-tb.cgi/1919
$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
Congrats on making it to a larva....I wish you well on your journey. Eat green leaves :)
.: amanda said on April 24, 2004 05:06 AM :: link it :.oooh... I wanna be a bug too! what a cute idea. :-)
.: erika said on April 24, 2004 08:03 AM :: link it :.} else { ?>
You're too early! Come back at April 23, 2004 04:33 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.