Forum for users of JoomlaWatch / ExtraWatch for Joomla, Wordpress, Drupal, Magento, Prestashop

JoomlaWatch / ExtraWatch has following features: live real-time visitor statistics, location of your visitors on a map, blocking of users based on bad word list, front-end counters, click heat map, definition of goals and rules, graphs, directory size monitoring, monitoring of increase of database data in time, nightly email reports, interactive HTML5 chart of traffic flow within your website, SEO report with keyword statistics and keyword position trends

Welcome, Guest
Please Login or Register.    Lost Password?

Visitors/Bots most recently active on top list
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Visitors/Bots most recently active on top list
#964
Visitors/Bots most recently active on top list 8 Years, 3 Months ago  
Hello,
Thanks for this component, really powerful !
When I was looking at my connected Visitors and Bots, I was wondering if it was possible to get the visitors connected the most recently on top of the list (as well as the bot), I made two modifications, in that way I have all the visitors/bots connected most recently on top of the list, better I think that scrolling through the list to search depending on dates/times (which I have also added ) :

in the file class.joomlawatch.html.php function renderVisitors()

instead of :
$query = "select ip from #__joomlawatch where (browser is not NULL and browser != '') order by id desc limit $limit";

I wrote :

$query = "SELECT ip, max(timestamp) FROM #__joomlawatch LEFT JOIN #__joomlawatch_uri ON #__joomlawatch.id = #__joomlawatch_uri.fk where (browser is not NULL and browser != '') group by ip order by 2 desc limit $limit";

in the same file function renderBots
instead of
$query = "select ip from #__joomlawatch where (browser is NULL) order by id desc limit $limit";

I wrote (not sure if this one is really correct) :

$query = "select ip, max(timestamp) from #__joomlawatch LEFT JOIN #__joomlawatch_uri ON #__joomlawatch.id = #__joomlawatch_uri.fk where (browser is NULL) group by ip order by 2 desc limit $limit";
francois (Visitor)

The administrator has disabled public write access.
 
Go to topPage: 1