« Best. Day. Ever. |
Main Index
| So Well Known »
comments | incoming pings | outgoing pings
if (time() > strtotime ("March 22, 2003 07:47 PM")) { ?>
Comments With Totals
Played around with the Recent Comments section and now each comment shows how many that person has made. I know it's geeky, but everytime I leave a comment at someone's site with a comment count, I wonder how many I've made. Now you can know.
.: Posted March 22, 2003 07:47 PM in $entry_cats="Geeky Things, ";print substr($entry_cats, 0, -2); ?> :.$blogid = "1"; //replace this with the blog_id of your blog $entry_id = "2104"; $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/1366
$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
Check it out! I had no idea I would be your top commenter. LOL! :)
.: kristine said on March 22, 2003 08:45 PM :: link it :.how super fun... I realy need to add this functionality!
.: amancay said on March 22, 2003 10:20 PM :: link it :.And pray tell, how did you figure out this tweak? Are you going to share your secrets?
.: Jenni said on March 22, 2003 10:23 PM :: link it :.yeah, i am #7 on the list! that is too cool! :)
.: Kathy said on March 23, 2003 12:16 AM :: link it :.How Cool *S*
.: Sonia said on March 23, 2003 01:15 AM :: link it :.I'm still trying to figure this out with php. I looked on the MT boards, but I don't get it =P
.: Dania said on March 23, 2003 01:13 PM :: link it :.Well done :)
.: Martie said on March 23, 2003 10:34 PM :: link it :.yeahhhhhh baby! i'm #4!
.: mikey said on March 25, 2003 03:08 AM :: link it :.} else { ?>
You're too early! Come back at March 22, 2003 07:47 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.