- b2evolution CMS Support Forums
- b2evolution Development
- A look into the future
- Feature requests and Feedback
- Extended admin stats
1 user_133 Feb 17, 2004 10:56
Hi everybody,
Yesterday I was hit by idea to extend current stats for admin part of the blog. What do you think about ability to track visitors time, their IP (resolved to country), requested page and offset by blog? Ability to delete hit is also required (I'm looking suspicious to my hit_log table's rapid grow...)
Someone may already have it implemented. Maybe willing to share it? B)
This could be quick start:
function mg_visits ()
{ global $row_stats;
$sql = "SELECT visitID, hit_blog_ID, hit_remote_addr, referingURL, DATE_FORMAT(visitTime, '%Y.%m.%d, %H:%m') AS visitTime, visitURL FROM mg_hitlog ORDER BY visitTime DESC";
$result = mysql_query ($sql) or die (mysql_error());
//here is the loop that produces the IPs, etc
while (list($row_stats["visitID"], $blog, $IP, $refer, $time, $url) = mysql_fetch_row($result)) {
?><a href="b2stats.php?action=delete&hit_ID=<?php echo $row_stats["visitID"]; ?>&show=visits&blog=<?php echo $blog ?>" title="<?php echo T_('Delete this hit!') ?>"><img src="img/xross.gif" width="13" height="13" class="middle" alt="<?php echo /* TRANS: Abbrev. for Delete (stats) */ T_('Del') ?>" /></a>
<?php
echo "IP: $IP - Time: $time - Ref: <a href=\"$refer\">$refer</a> - Page: <a href=\"$url\">$url</a><br />";
}
}
Cheers!
I think that'd be super-cool and way useful.