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?

Report on Registered Users
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Report on Registered Users
#3217
Report on Registered Users 5 Years, 5 Months ago Karma: 0
Is it possible to obtain a report or listing from Joomlawatch to see which pages have been visited by registered users?
evolutionsystems (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3218
Re: Report on Registered Users 5 Years, 5 Months ago Karma: 31
not now, maybe in next version from history. now all users appear there
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3219
Re: Report on Registered Users 5 Years, 5 Months ago Karma: 0
When you say all users appear there, is it possible to get a report / listing of which pages have been visited by specific users?
evolutionsystems (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3220
Re: Report on Registered Users 5 Years, 5 Months ago Karma: 31
Sorry I meant, that there appear users together with all other visits (anonymous users).

One idea how can you accomplish this now is to change the select:

in class.joomlawatch.visit.history.php, line 57

$query = sprintf("SELECT * FROM #__joomlawatch_history LEFT JOIN #__joomlawatch_uri_history ON #__joomlawatch_history.id = #__joomlawatch_uri_history.fk WHERE #__joomlawatch_history.browser %s order by #__joomlawatch_history.id desc, #__joomlawatch_uri_history.timestamp desc limit %s", $this->database->getEscaped($browserCondition), $this->database->getEscaped($limit));

to

$query = sprintf("SELECT * FROM #__joomlawatch_history LEFT JOIN #__joomlawatch_uri_history ON #__joomlawatch_history.id = #__joomlawatch_uri_history.fk WHERE #__joomlawatch_history.browser %s and #__joomlawatch_history.username is not null order by #__joomlawatch_history.id desc, #__joomlawatch_uri_history.timestamp desc limit %s", $this->database->getEscaped($browserCondition), $this->database->getEscaped($limit));

(and #__joomlawatch_history.username is not null)
but you have to increase the visit history limit in settings)

Then, you'll see only pages in history from registered users. Hope this helps.
matto (Admin)
Moderator
Posts: 770
graph
User Offline Click here to see the profile of this user
Last Edit: 2011/06/27 01:05 By matto.
The administrator has disabled public write access.
 
Go to topPage: 1