« Happy Birthday, Shawn! |
Main Index
| Life Changing Decisions »
comments | incoming pings | outgoing pings
if (time() > strtotime ("April 20, 2003 07:35 PM")) { ?>
Monthly Comment Leaders
If you look in the sidebar, you'll see a new section under comment leaders that shows the people with the most comments this month. You can now lead for the month and for totals on the site, so leave me lots of comments. I found the script at Scripty Goddess (of course) and you can get it here if you want to add it to your site.
.: Posted April 20, 2003 07:35 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 = "2173"; $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/1435
$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
Yay! I had fun playing with the SQL to figure out the date stuff. Glad you like it. :)
.: Lisa, Gal of Unix said on April 20, 2003 09:27 PM :: link it :.I just want to know how you do the "Show this months" and then you can close it. THAT rocks.
.: Robin said on April 21, 2003 08:05 AM :: link it :.Cooolies!!! I'm a contender for the big numbers in the month of April! :)
.: susan said on April 21, 2003 08:31 AM :: link it :.This one is fun, I added it recently as well :)
.: gingersmack said on April 21, 2003 04:32 PM :: link it :.} else { ?>
You're too early! Come back at April 20, 2003 07:35 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.