« Finally! Pictures! |
Main Index
| Nothing of Note »
comments | incoming pings | outgoing pings
if (time() > strtotime ("January 10, 2003 11:22 PM")) { ?>
Won't You Be My Neighbor?
This is a cool little thing. By adding a few lines of code to your site, you can use GeoURL to find out who's blogging near you. Not surprisingly, Christine is my nearest neighbor.
.: Posted January 10, 2003 11:22 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 = "1836"; $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/1100
$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
That's kinda scary to think the rednecks around here might be blogging -- I'd rather not know.
.: trish said on January 11, 2003 09:25 AM :: link it :.I'm love this! :) Thanks for pointing this out. I found a few new reads because of it. :)
.: Mandie said on January 11, 2003 09:41 AM :: link it :.How cool! I am definitely going to do this later today, when I have time to add myself to the database.
.: Heather said on January 11, 2003 01:48 PM :: link it :.wow, what a neat little tool.
glad you posted it! :)
I think it's great, but I altered my location by about an hour's drive. The thought of anyone with GPS device waltzing right up to our front door...well... ;-)
.: robyn said on January 12, 2003 02:42 AM :: link it :.} else { ?>
You're too early! Come back at January 10, 2003 11:22 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.