Neurotic Fishbowl: Monthly Comment Leaders

« Happy Birthday, Shawn! | Main Index | Life Changing Decisions »
comments | incoming pings | outgoing pings



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 Geeky Things, ";print substr($entry_cats, 0, -2); ?> :.


"; 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, "

"; echo "
Posted by "; echo "", $blog, ""; echo " on ", $date, "
"; } ?>

Ping this post
http://www.neuroticfishbowl.com/mt/mt-tb.cgi/1435




"..."




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 :.

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}

Name:


E-mail Address: (Optional)


URL: (Optional)


Add a smilie (launches smilie 'palette')

Comments:


Remember info?





Subscribe to post
Unsubscribe to post
(e-mail field must be filled in)
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.