Changeset 1273

Timestamp:

08/11/08 17:01:39 (4 months ago)

Author:

_ck_

Message:

0.1.0 statistics, referrer tracking, more bots detected, including spoofing/steath bots that use regular user agents

Files:

• mini-track/trunk/mini-track.php (modified) (12 diffs)
• mini-track/trunk/readme.txt (modified) (4 diffs)

mini-track/trunk/mini-track.php

@@ -6 +6 @@
-Author: _ck_
-Author URI: http://bbShowcase.org
-0.9
+1.0
-
-License: CC-GNU-GPL http://creativecommons.org/licenses/GPL/2.0/
@@ -16 +16 @@
-If you only want it on the front page you can do it like this: <?php if (is_front() ) {mini_track(1);} ?>
-If you also want a list of the member names, use <?php mini_track(2); ?>
+For statistics, use <?php mini_track_statistics(); ?>
-You can see a list of users and locations by going to  your-forum-url.com/?mini_track_display
-*/
@@ -23 +24 @@
-$mini_track_options['automatic_in_footer'] = true;              // set false if you place mini_track(1) or mini_track(2) in your templates
-$mini_track_options['show_names_in_footer'] = true;             // display user names (optional)
-        
+         
-$mini_track_options['last_online_in_profile'] = true;           // automatic in profiles
-$mini_track_options['online_status_in_post'] = true;            // automatic in posts
-
+
+
+
+
+
+
+
-
-$mini_track_options['display_refresh_time'] = 30;               // seconds for real-time display update
-tracks NAT/proxy users better, true = faster
+= accurately tracks NAT/proxy/spoof users // true = faster by
-
-$mini_track_options['style']="
-
-
+
+
+
+
-        .mini_track_online {font-size:90%; color:green;} 
-        .mini_track_offline {font-size:90%; color:#aaa;}
@@ -39 +48 @@
-";
-
-
-
-
-
+
+
+
+
+
+
+
+
+
-
-/* STOP EDITING HERE */
-
+$mini_track_options['debug'] = false;
+
+$bb->load_options = true;       // better db performance, but probably won't work here, put it into your bb-config.php
+
-$mini_track_options['bots']=explode("|",str_replace("\\","", strtolower($mini_track_options['bots']) ));
-
-$mini_track_options['debug'] = false; 
-
-$bb->load_options = true;       // better db performance, but probably won't work here, put it into your bb-config.php
-
-// hooks and triggers
@@ -64 +78 @@
-if (isset($_GET['mini_track_display']) || isset($_GET['mini_track_reset'])) {add_action('bb_init','mini_track_display',100);}
-if (isset($_GET['mini_track_ip'])) {add_action('bb_init','mini_track_ip',100);}
+// statistics hooks
+if ($mini_track_options['statistics_in_footer']) {add_action('bb_foot','mini_track_statistics',200);}
+add_action( 'bb_new_post','mini_track_statistics_update');
+add_action( 'bb_delete_post','mini_track_statistics_update');
+add_action('register_user','mini_track_statistics_update');
+add_action('user_register','mini_track_statistics_update');
-
-function mini_track_init() {  
@@ -71 +91 @@
-list($index,$debug)=mini_track_index($bb_current_user->ID);
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
-if ($bb_current_user->ID) {$mini_track[$index]->name=$bb_current_user->data->user_login;}
-
-
-
-
-
+
+
+
+
+
+
+
+
-++$mini_track[$index]->pages;   // count how many pages they've viewed
-
+
+
+
-$bb_uri=bb_get_option('uri'); $profile=$bb_uri."profile.php?id=";
-
-
-
+
+
+
+
-
-foreach ($mini_track as $key=>$value) { 
-
+
+
-// store last seen date when they leave
-if ($value->id) {mini_track_logout($value->id);} 
@@ -104 +133 @@
-// @bb_update_option('mini_track',$mini_track); // argh stupid bbPress read before write wastes queries
-// $bbdb->get_var("UPDATE bb_topicmeta SET `meta_value` = '' WHERE topic_id = '0' AND meta_key = 'mini_track' LIMIT 1");
-
+
+
+
+
+
+
-
-// this serialized string will get nasty for more than a few dozen people online
@@ -125 +159 @@
-if ($display) { // to do: internationalize i18n
-if (bb_current_user_can('administrate')) {$start="<a href='?mini_track_display'>"; $end="</a>";} else {$start=""; $end="";}
-trong>".$mini_track_current['users']."</strong
-trong>".$mini_track_current['onpage']."</strong
-trong>".$mini_track_current['members']."</strong
+pan class='mini_track_num'>".$mini_track_current['users']."</span
+pan class='mini_track_num'>".$mini_track_current['onpage']."</span
+pan class='mini_track_num'>".$mini_track_current['members']."</span
-if ($mini_track_current['members']>0 && ($display==2 || $display=="members")) {echo ": ".$mini_track_current['names'];} 
-elseif ($mini_track_current['members']>0 && $display==1) {echo ".";}
@@ -141 +175 @@
-echo '<html><head><title>'.count($mini_track).' Users Online &laquo; '.bb_get_option('name').'</title>
-<meta http-equiv="refresh" content="'.$mini_track_options['display_refresh_time'].';url='.$bb_uri.'?mini_track_display" />
-
-
-
+
+
+
+
+
-echo "<div style='float:right;'>[<a href='$bb_url?mini_track_reset'><small>reset</small></a>]</div>";
-mini_track(2); 
-br /><
-
+
+referer</th><th>
-$mini_track=array_reverse($mini_track,true);
-$counter=0;
-foreach ($mini_track as $key=>$value) {
-$url=urldecode($value->url);
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
-}
-echo "</table></body></html>";
@@ -165 +209 @@
-$id=intval($id);
-if ($mini_track_options['fast_index']) {
-
+
+
-} else {
-// more advanced indexing technique on the next two lines - disable for speed at expense of no NAT/proxy detection
-
+,'HTTP_CLIENT_IP'
-$meta=$id; foreach ($indexlist as $check) {if (isset($_SERVER[$check])) {$meta.=" ".$_SERVER[$check];}} $index=md5($meta);
-}
-// $array['index']=$index; $array['debug']=$meta; return $array;
-return array($index,$meta);
+}
+
+function mini_track_remote_addr() {     // detects true IP of known proxies and NATs
+// 67\.195\.|74\.6\. == inktomi/yahoo slurp, sometimes masqurades as regular browser too!
+if (ereg("^(67\.195\.|74\.6\.)",$_SERVER['REMOTE_ADDR']) && isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
+return $_SERVER['HTTP_X_FORWARDED_FOR'];
+} else {return $_SERVER['REMOTE_ADDR'];} 
+}
+
+function mini_track_bot_lookup() { 
+global $mini_track_options; $bot=0;
+$agent=strtolower($_SERVER['HTTP_USER_AGENT']);
+foreach ($mini_track_options['bots'] as $key=>$name) {if (!(strpos($agent,$name)===false)) {$bot=$key+1; break;}}
+if ($bot==0)  {if (ereg("^(67\.195\.|74\.6\.)",$_SERVER['REMOTE_ADDR'])) {$bot=1+array_search("yahoo stealth",$mini_track_options['bots']);}} // yahoo fakes it
+return $bot;
-}
-
@@ -206 +266 @@
-function mini_track_style() {global $mini_track_options; echo "<style type='text/css'>".$mini_track_options['style']."</style>"; }
-
-
+
+
+
+
+
+
+
+
-
-function mini_track_logout($id=0) {
@@ -251 +318 @@
-return $data;
-}
+
+function mini_track_statistics() {
+global $mini_track, $mini_track_options, $mini_track_statistics_done; 
+if (isset($mini_track_statistics_done)) {return;} $mini_track_statistics_done=true;     // only run once if manually called
+if ($mini_track_options['statistics_only_on_front_page'] && !is_front()) {return;}
+$results=bb_get_option('mini_track_statistics'); if (!$results) {$results=mini_track_statistics_update();}
+$months=ceil((time()-strtotime($results->days)) / (3600 * 24 * 30));
+$output="<div class='mini_track_statistics'>";
+$output.="<span class='mini_track_wrap'>";
+$output.=" <span class='mini_track_num'>".$results->posts."</span> ".__('posts in'); 
+$output.=" <span class='mini_track_num'>".$results->topics."</span> ".__('topics over'); 
+$output.=" <span class='mini_track_num'>$months</span> ".__('months by'); 
+$output.=" <span class='mini_track_num'>".$results->active."</span> ".__('of')." <span class='mini_track_num'>".$results->members."</span> ".__('members.'); 
+$output.=" </span> <span class='mini_track_wrap'> ";
+if (!empty($results->latest)) {$output.=__('Latest:'); $uri=bb_get_option('uri')."profile.php?id="; foreach ($results->latest as $key=>$value) {$output.=" <a href='$uri$key'>$value</a>, ";}}
+$output=trim($output,", ")."</span></div> ";
+echo $output;
+}
+
+function mini_track_statistics_update($x="") {
+global $bbdb, $mini_track;      // this is kind of insane overkill to do each new post / new user - might want to calculate incrementally somehow
+$query="SELECT count(*) as posts, count(distinct topic_id) as topics, count(distinct poster_id) as active, min(post_time) as days FROM bb_posts WHERE post_status=0";
+$results=$bbdb->get_results($query);
+$usertable=$bbdb->users; $usermeta=$bbdb->usermeta;
+$base="FROM $usertable as t1 LEFT JOIN $usermeta as t2 on t1.ID=t2.user_id WHERE user_status=0 AND (meta_key='bb_capabilities' AND NOT (meta_value LIKE '%inactive%' OR meta_value LIKE '%blocked%'))";
+$query="SELECT user_login,ID $base ORDER BY user_registered DESC LIMIT 3";
+$results2=$bbdb->get_results($query);
+$results2=array_reverse($results2);
+foreach ($results2 as $key=>$value) {$results[0]->latest[$value->ID]=$value->user_login;}
+$query="SELECT count(*) as members $base";
+$results2=$bbdb->get_results($query);
+$results[0]->members=$results2[0]->members;
+bb_update_option('mini_track_statistics',$results[0]);
+return $results[0];
+}
-?>

mini-track/trunk/readme.txt

@@ -19 +19 @@
-If you upgrade from an old version you need to use the RESET link in the tracking display.
-
+This plugin is now bbPress 1.0 compatible.
+
-== Installation ==
-
@@ -30 +32 @@
-        <div id="footer">
-                <?php mini_track(1); ?>
+                <?php mini_track_statistics(); ?>
-                <p><?php printf(__('%1$s is proudly powered by <a href="%2$s">bbPress</a>.'), bb_option('name'), "http://bbpress.org") ?></p>
-        </div>
@@ -36 +39 @@
-* With non-automatic placement, if you also want a list of the member names, use `<?php mini_track(2); ?>`
-or if you only want it on the front page you can do it like this: `<?php if (is_front() ) {mini_track(1);} ?>` or you can put it anywhere in `front-page.php` that you'd like.
+
+* Mini-Track can now show some basic statistics in your footer, or with manual placement anywhere on the page via `<?php mini_track_statistics(); ?>`
+
+* it is highly recommend you put this line in your `bb-config.php`  which will help with database performance on active forums by loading all  bbPress options at once instead of piecemeal
+`
+$bb->load_options = true;
+`
-
-== Frequently Asked Questions ==
@@ -90 +100 @@
-* bug fixes for last online, IP tracked/displayed + IP lookup, bots recorded/displayed by agent
-
+= Version 0.1.0 (2008-08-11) =
+
+* more bots detected, including spoofing/steath bots that use regular user agents
+
+* remote IP lookup at RIPE (click IP in tracking display)
+
+* referer from remote site tracked upon entry
+
+* statistics of topics/posts and members
+
-== To Do ==
+
+* total online today
+
+* online today by name
-
-* store time online per member in profile ++(first seen - last seen)