';
$currenttot = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currenttot FROM $table_name WHERE timestamp BETWEEN $from_date AND $to_date");
$currenttot = $currenttot+0; //set to integer
print "
Visitors online: ".$currenttot."
";
if ($currenttot > 0) {
$qryC = $wpdb->get_results("SELECT id, wassup_id, max(timestamp) as max_timestamp, ip, hostname, searchengine, urlrequested, agent, referrer, spider, username, comment_author FROM $table_name WHERE timestamp BETWEEN $from_date AND $to_date GROUP BY ip ORDER BY max_timestamp DESC");
foreach ($qryC as $cv) {
//$timestamp = $cv->max_timestamp; //redundant
$timed = gmdate("H:i:s", $cv->max_timestamp);
$ip = @explode(",", $cv->ip);
if ($cv->referrer != '') {
if (!eregi($wpurl, $cv->referrer) OR $cv->searchengine != "") {
if (!eregi($wpurl, $cv->referrer) AND $cv->searchengine == "") {
$referrer = ''.stringShortener($cv->referrer, round($max_char_len*.8,0)).'';
} else {
$referrer = ''.stringShortener($cv->referrer, round($max_char_len*.9,0)).'';
}
} else {
$referrer = "Direct hit";
}
} else {
$referrer = "From your blog";
}
$numurl = $wpdb->get_var("SELECT COUNT(DISTINCT id) as numurl FROM $table_name WHERE wassup_id='".$cv->wassup_id."'");
?>
'."\n".''."\n";
//display the last few hits here. The rest will be added via spy.js
$to_date = (wassup_get_time()-2);
$from_date = ($to_date - 12*(60*60)); //display last 10 visits in 12 hours...
spyview($from_date,$to_date,10);
print '
';
echo " ";
// HERE IS THE OPTIONS VIEW
} elseif($_GET['page'] == "wassup-options") {
//#moved content to external include file, "settings.php"
//# to make "wassup" code easier to read and modify
//# -Helene D. 1/15/08.
include(dirname(__FILE__).'/lib/settings.php'); ?>
0";
} elseif ($type == 'nospam') {
$whereis = " AND spam=0";
} elseif ($type == 'nospamspider') {
$whereis = " AND spam=0 AND spider=''";
} elseif ($type == 'searchengine') {
$whereis = " AND searchengine!='' AND search!=''";
} elseif ($type == 'referrer') {
$whereis = " AND referrer!='' AND referrer NOT LIKE '%$wpurl%' AND searchengine='' AND search=''";
} elseif ($type == 'comauthor') {
$whereis = " AND comment_author!='' AND username=''";
} elseif ($type == 'loggedin') {
$whereis = " AND username!=''";
}
$pages = 1;
if(isset($_GET['pages']) and is_numeric($_GET['pages']) and $pages = $_GET['pages']) {
$limit = " LIMIT ".(($pages-1)*$items).",$items";
} else {
$limit = " LIMIT $items";
}
print "
";
}
// DELETE EVERY RECORD MARKED BY IP
if ($_GET['deleteMARKED'] == 1) {
$rec_deleted = $wpdb->get_var("SELECT COUNT(ip) as deleted FROM $table_name WHERE ip='".urlencode(attribute_escape($_GET['dip']))."'");
$wpdb->query("DELETE FROM $table_name WHERE ip='%s'", urlencode(attribute_escape($_GET['dip'])));
echo "
".$rec_deleted." records deleted
";
}
echo "
Items per page: - Show items by:
";
if ($wassup_settings['wchart'] == 1) {
// Print Site Usage
//#print useage/google chart only on page 1...
//if (!isset($_GET['pages']) || (int)$_GET['pages'] < 2) {
echo "
";
}
}
// Widget TOP Referers
if ($wassup_settings['wassup_widget_ref'] == 1) {
$query_ref = $wpdb->get_results("SELECT referrer FROM $table_name WHERE searchengine='' AND referrer!='' AND referrer NOT LIKE '$wpurl%' GROUP BY referrer ORDER BY timestamp DESC LIMIT $reflimit");
if (count($query_ref) > 0) {
print "$before_title Last referers $after_title";
print "
";
}
}
// Widget TOP Browsers
if ($wassup_settings['wassup_widget_topbr'] == 1) {
$query_topbr = $wpdb->get_results("SELECT count(browser) as top_browser, browser FROM $table_name WHERE browser!='' AND browser NOT LIKE '%N/A%' GROUP BY browser ORDER BY top_browser DESC LIMIT $topbrlimit");
if (count($query_topbr) > 0) {
print "$before_title Top Browsers $after_title";
print "
";
foreach ($query_topbr as $etopbr) {
print "
- ".stringShortener($etopbr->browser, $chars)."
";
}
print "
";
}
}
// Widget TOP Oses
if ($wassup_settings['wassup_widget_topos'] == 1) {
$query_topos = $wpdb->get_results("SELECT count(os) as top_os, os FROM $table_name WHERE os!='' AND os NOT LIKE '%N/A%' GROUP BY os ORDER BY top_os DESC LIMIT $toposlimit");
if (count($query_topos) > 0) {
print "$before_title Top OS $after_title";
print "
";
$currenttot = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currenttot FROM $table_name WHERE timestamp BETWEEN $from_date AND $to_date ");
$currentlogged = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currentlogged FROM $table_name WHERE username!=''AND timestamp BETWEEN $from_date AND $to_date");
$currentauth = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currentauth FROM $table_name WHERE comment_author!='' AND username=''AND timestamp BETWEEN $from_date AND $to_date");
if ((int)$currenttot < 10) $currenttot = "0".$currenttot;
print "
".$currenttot." visitor(s) online
";
if ((int)$currentlogged > 0 AND $wassup_settings['wassup_widget_loggedin'] == 1) {
if ((int)$currentlogged < 10) $currentlogged = "0".$currentlogged;
print "
".$currentlogged." logged-in user(s)
";
}
if ((int)$currentauth > 0 AND $wassup_settings['wassup_widget_comauth'] == 1) {
if ((int)$currentauth < 10) $currentauth = "0".$currentauth;
print "
";
}
}
if ($wref == 1) {
$query_ref = $wpdb->get_results("SELECT referrer FROM $table_name WHERE searchengine='' AND referrer!='' AND referrer NOT LIKE '$wpurl%' GROUP BY referrer ORDER BY timestamp DESC LIMIT $reflimit");
if (count($query_ref) > 0) {
print "$before_title Last referers $after_title";
print "
";
}
}
if ($wtopbr == 1) {
$query_topbr = $wpdb->get_results("SELECT count(browser) as top_browser, browser FROM $table_name WHERE browser!='' AND browser NOT LIKE '%N/A%' GROUP BY browser ORDER BY top_browser DESC LIMIT $topbrlimit");
if (count($query_topbr) > 0) {
print "$before_title Top Browsers $after_title";
print "
";
foreach ($query_topbr as $etopbr) {
print "
- ".stringShortener($etopbr->browser, $chars)."
";
}
print "
";
}
}
if ($wtopos == 1) {
$query_topos = $wpdb->get_results("SELECT count(os) as top_os, os FROM $table_name WHERE os!='' AND os NOT LIKE '%N/A%' GROUP BY os ORDER BY top_os DESC LIMIT $toposlimit");
if (count($query_topos) > 0) {
print "$before_title Top OS $after_title";
print "
";
$currenttot = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currenttot FROM $table_name WHERE timestamp BETWEEN $from_date AND $to_date ");
$currentlogged = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currentlogged FROM $table_name WHERE username!=''AND timestamp BETWEEN $from_date AND $to_date");
$currentauth = $wpdb->get_var("SELECT COUNT(DISTINCT wassup_id) as currentauth FROM $table_name WHERE comment_author!='' AND username=''AND timestamp BETWEEN $from_date AND $to_date");
if ((int)$currenttot < 10) $currenttot = "0".$currenttot;
print "
".$currenttot." visitor(s) online
";
if ((int)$currentlogged > 0 AND $wassup_settings['wassup_widget_loggedin'] == 1) {
if ((int)$currentlogged < 10) $currentlogged = "0".$currentlogged;
print "
".$currentlogged." logged-in user(s)
";
}
if ((int)$currentauth > 0 AND $wassup_settings['wassup_widget_comauth'] == 1) {
if ((int)$currentauth < 10) $currentauth = "0".$currentauth;
print "
wassup_id.""; ?>" class="thickbox">
.'.png'; ?> "Language: <?php print strtolower($rk->language); ?>")
OS: os; ?>