".__('Spy','statpress')."
"; $sql="SELECT ip,nation,os,browser,agent FROM $table_name WHERE (spider='' AND feed='') AND (date BETWEEN '$yesterday' AND '$today') GROUP BY ip ORDER BY id DESC LIMIT 20"; $qry = $wpdb->get_results($sql); ?>";
print " ";
print "".$rk->os.", ".$rk->browser;
// print " ";
print "";
print ""; print " "; if($rk->nation) { print " ".gethostbyaddr($rk->ip).""; } print " ".$rk->agent.""; print " | ";
$qry2=$wpdb->get_results("SELECT * FROM $table_name WHERE ip='".$rk->ip."' AND (date BETWEEN '$yesterday' AND '$today') order by id LIMIT 10");
foreach ($qry2 as $details) {
print "|
".irihdate($details->date)." ".$details->time." | ";
print "urlrequested."' target='_blank'>".iri_StatPress_Decode($details->urlrequested)."";
if($details->searchengine != '') {
print " ".__('arrived from','statpress')." ".$details->searchengine." ".__('searching','statpress')." ".$details->search.""; } elseif($details->referrer != '' && strpos($details->referrer,get_option('home'))===FALSE) { print " ".__('arrived from','statpress')." ".$details->referrer.""; } print " | ";
print "
".__('Results','statpress').""; $sql="SELECT $fields FROM $table_name $where $groupby $orderby $limit;"; // print "$sql
"; print "
| ".ucfirst($_GET["where$i"])." | "; } } if($groupby != '') { print "".__('Count','statpress')." | "; } print "
|---|---|
| "; if($_GET["where$i"] == 'urlrequested') { print iri_StatPress_Decode($rk[$i-1]); } else { print $rk[$i-1]; } print " | "; } print "
sql: $sql
$fldtitle
| ".__('Visits','statpress')." | ||
|---|---|---|
| ".$rk->pageview." | "; //$pc% | "; print "$pc% ";
print " |
"; # Update Feed print "Updating Feeds... "; $wpdb->query("UPDATE $table_name SET feed='';"); # not standard $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE urlrequested LIKE '%/feed/%';"); $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE urlrequested LIKE '%wp-feed.php%';"); # standard blog info urls $s=iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='COMMENT ATOM' WHERE INSTR(urlrequested,'$s')>0;"); } $s=iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='COMMENT RSS' WHERE INSTR(urlrequested,'$s')>0;"); } $s=iri_StatPress_extractfeedreq(get_bloginfo('atom_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='ATOM' WHERE INSTR(urlrequested,'$s')>0;"); } $s=iri_StatPress_extractfeedreq(get_bloginfo('rdf_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='RDF' WHERE INSTR(urlrequested,'$s')>0;"); } $s=iri_StatPress_extractfeedreq(get_bloginfo('rss_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='RSS' WHERE INSTR(urlrequested,'$s')>0;"); } $s=iri_StatPress_extractfeedreq(get_bloginfo('rss2_url')); if($s != '') { $wpdb->query("UPDATE $table_name SET feed='RSS2' WHERE INSTR(urlrequested,'$s')>0;"); } # elim $wpdb->query("UPDATE $table_name SET feed='Y' WHERE (urlrequested LIKE '%feed=%') or (urlrequested LIKE '%wp-rss%') or (urlrequested LIKE '%wp-rdf%') or (urlrequested LIKE '%wp-commentsrss%') or (urlrequested LIKE '%wp-atom%');"); print "".__('done','statpress')."
"; # Update OS print "Updating OSes... "; $wpdb->query("UPDATE $table_name SET os = '';"); $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/os.dat'); foreach($lines as $line_num => $os) { list($nome_os,$id_os)=explode("|",$os); $qry="UPDATE $table_name SET os = '$nome_os' WHERE os='' AND replace(agent,' ','') LIKE '%".$id_os."%';"; $wpdb->query($qry); } print "".__('done','statpress')."
"; # Update Browser print "Updating Browsers... "; $wpdb->query("UPDATE $table_name SET browser = '';"); $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/browser.dat'); foreach($lines as $line_num => $browser) { list($nome,$id)=explode("|",$browser); $qry="UPDATE $table_name SET browser = '$nome' WHERE browser='' AND replace(agent,' ','') LIKE '%".$id."%';"; $wpdb->query($qry); } print "".__('done','statpress')."
"; # Update Spider print "Updating Spiders... "; $wpdb->query("UPDATE $table_name SET spider = '';"); $lines = file(ABSPATH.'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/def/spider.dat'); foreach($lines as $line_num => $spider) { list($nome,$id)=explode("|",$spider); $qry="UPDATE $table_name SET spider = '$nome',os='',browser='' WHERE spider='' AND replace(agent,' ','') LIKE '%".$id."%';"; $wpdb->query($qry); } print "".__('done','statpress')."
"; # Update feed to '' print "Updating Feeds... "; $wpdb->query("UPDATE $table_name SET feed = '' WHERE isnull(feed);"); print "done
"; # Update Search engine print "Updating Search engines... "; print "
"; $wpdb->query("UPDATE $table_name SET searchengine = '', search='';"); print "...null-ed!
"; $qry = $wpdb->get_results("SELECT id, referrer FROM $table_name"); print "...select-ed!
"; foreach ($qry as $rk) { list($searchengine,$search_phrase)=explode("|",iriGetSE($rk->referrer)); if($searchengine <> '') { $q="UPDATE $table_name SET searchengine = '$searchengine', search='".addslashes($search_phrase)."' WHERE id=".$rk->id; $wpdb->query($q); } } print "".__('done','statpress')."
"; $wpdb->hide_errors(); print "
".__('Updated','statpress')."!
"; } function iriStatPressEmpty() { global $wpdb; $table_name = $wpdb->prefix . "statpress"; $wpdb->show_errors(); # empty table print "Emptying table struct $table_name... "; $wpdb->query("TRUNCATE $table_name"); print "".__('done','statpress').""; $wpdb->hide_errors(); print "
".__('Emptied','statpress')."!
"; } function StatPress_Widget($w='') { } function StatPress_Print($body='') { print iri_StatPress_Vars($body); } function iri_StatPress_Vars($body) { global $wpdb; $table_name = $wpdb->prefix . "statpress"; if(strpos(strtolower($body),"%visits%") !== FALSE) { $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE date = '".gmdate("Ymd",current_time('timestamp'))."' and spider='' and feed='';"); $body = str_replace("%visits%", $qry[0]->pageview, $body); } if(strpos(strtolower($body),"%totalvisits%") !== FALSE) { $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE spider='' and feed='';"); $body = str_replace("%totalvisits%", $qry[0]->pageview, $body); } if(strpos(strtolower($body),"%thistotalvisits%") !== FALSE) { $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM $table_name WHERE spider='' and feed='' AND urlrequested='".iri_StatPress_URL()."';"); $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body); } if(strpos(strtolower($body),"%since%") !== FALSE) { $qry = $wpdb->get_results("SELECT date FROM $table_name ORDER BY date LIMIT 1;"); $body = str_replace("%since%", irihdate($qry[0]->date), $body); } if(strpos(strtolower($body),"%os%") !== FALSE) { $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : ''); $os=iriGetOS($userAgent); $body = str_replace("%os%", $os, $body); } if(strpos(strtolower($body),"%browser%") !== FALSE) { $browser=iriGetBrowser($userAgent); $body = str_replace("%browser%", $browser, $body); } if(strpos(strtolower($body),"%ip%") !== FALSE) { $ipAddress = $_SERVER['REMOTE_ADDR']; $body = str_replace("%ip%", $ipAddress, $body); } if(strpos(strtolower($body),"%visitorsonline%") !== FALSE) { $to_time = current_time('timestamp'); $from_time = strtotime('-4 minutes', $to_time); $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as visitors FROM $table_name WHERE spider='' and feed='' AND timestamp BETWEEN $from_time AND $to_time;"); $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body); } if(strpos(strtolower($body),"%usersonline%") !== FALSE) { $to_time = current_time('timestamp'); $from_time = strtotime('-4 minutes', $to_time); $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as users FROM $table_name WHERE spider='' and feed='' AND user<>'' AND timestamp BETWEEN $from_time AND $to_time;"); $body = str_replace("%usersonline%", $qry[0]->users, $body); } if(strpos(strtolower($body),"%toppost%") !== FALSE) { $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' AND urlrequested LIKE '%p=%' GROUP BY urlrequested ORDER BY totale DESC LIMIT 1;"); $body = str_replace("%toppost%", iri_StatPress_Decode($qry[0]->urlrequested), $body); } if(strpos(strtolower($body),"%topbrowser%") !== FALSE) { $qry = $wpdb->get_results("SELECT browser,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' GROUP BY browser ORDER BY totale DESC LIMIT 1;"); $body = str_replace("%topbrowser%", iri_StatPress_Decode($qry[0]->browser), $body); } if(strpos(strtolower($body),"%topos%") !== FALSE) { $qry = $wpdb->get_results("SELECT os,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' GROUP BY os ORDER BY totale DESC LIMIT 1;"); $body = str_replace("%topos%", iri_StatPress_Decode($qry[0]->os), $body); } return $body; } function iri_StatPress_TopPosts($limit=5, $showcounts='checked') { global $wpdb; $res="\n- \n";
$table_name = $wpdb->prefix . "statpress";
$qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' AND urlrequested LIKE '%p=%' GROUP BY urlrequested ORDER BY totale DESC LIMIT $limit;");
foreach ($qry as $rk) {
$res.="
- ".iri_StatPress_Decode($rk->urlrequested)." \n"; if(strtolower($showcounts) == 'checked') { $res.=" (".$rk->totale.")"; } } return "$res
%totalvisits% %visits% %thistotalvisits% %os% %browser% %ip% %since% %visitorsonline% %usersonline% %toppost% %topbrowser% %topos%
';
}
function widget_statpress($args) {
extract($args);
$options = get_option('widget_statpress');
$title = $options['title'];
$body = $options['body'];
echo $before_widget;
print($before_title . $title . $after_title);
print iri_StatPress_Vars($body);
echo $after_widget;
}
register_sidebar_widget('StatPress', 'widget_statpress');
register_widget_control(array('StatPress','widgets'), 'widget_statpress_control', 300, 210);
// Top posts
function widget_statpresstopposts_control() {
$options = get_option('widget_statpresstopposts');
if ( !is_array($options) ) {
$options = array('title'=>'StatPress TopPosts', 'howmany'=>'5', 'showcounts'=>'checked');
}
if ( $_POST['statpresstopposts-submit'] ) {
$options['title'] = strip_tags(stripslashes($_POST['statpresstopposts-title']));
$options['howmany'] = stripslashes($_POST['statpresstopposts-howmany']);
$options['showcounts'] = stripslashes($_POST['statpresstopposts-showcounts']);
if($options['showcounts'] == "1") {$options['showcounts']='checked';}
update_option('widget_statpresstopposts', $options);
}
$title = htmlspecialchars($options['title'], ENT_QUOTES);
$howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);
$showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);
// the form
echo '';
echo '';
echo '';
echo '';
}
function widget_statpresstopposts($args) {
extract($args);
$options = get_option('widget_statpresstopposts');
$title = htmlspecialchars($options['title'], ENT_QUOTES);
$howmany = htmlspecialchars($options['howmany'], ENT_QUOTES);
$showcounts = htmlspecialchars($options['showcounts'], ENT_QUOTES);
echo $before_widget;
print($before_title . $title . $after_title);
print iri_StatPress_TopPosts($howmany,$showcounts);
echo $after_widget;
}
register_sidebar_widget('StatPress TopPosts', 'widget_statpresstopposts');
register_widget_control(array('StatPress TopPosts','widgets'), 'widget_statpresstopposts_control', 300, 110);
}
load_plugin_textdomain('statpress', 'wp-content/plugins/'.dirname(plugin_basename(__FILE__)).'/locale');
add_action('admin_menu', 'iri_add_pages');
add_action('plugins_loaded', 'widget_statpress_init');
add_action('send_headers', 'iriStatAppend'); //add_action('wp_head', 'iriStatAppend');
register_activation_hook(__FILE__,'iri_StatPress_CreateTable');
?>