Extension talk:UserSnoop

Suggestion
Saw your quick fix for the UserPageViewTracker and it worked for UserSnoop too (Super thanks!!). Do you think you could make it so that you can either search the user list (ajax would be great) or pick users from a drop down list?

Since the UserSnoop does what the UserPageTracker does, are you going to just continue one of them and improve it?

Also you might want to take a look at http://firestats.cc/ your plugin would be great if you could integrate that into a full blown statistics system.

SellFone 07:30, 4 December 2007 (UTC)


 * Thanks! I am thinking about continuing the UserSnoop extension and add more functionality to it going forward. I have considered extending it all the way to a full wiki stats extension but, haven't really had the time to dedicate to it. My paying job takes precedence :) Perhaps over the holidays. --Kimon 18:14, 4 December 2007 (UTC)

SQL
I get following error when trying to run UserPageHits.sql (in phpMyAdmin).

for the right syntax to use near 'VIEW `user_page_hits` AS SELECT `u`.`user_name` AS `user_name`, `u`.`' at line 1
 * 1) 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

--Mopster 20:00, 5 December 2007 (UTC)


 * Hmmmm.... I just copy & pasted this into my test DB and it worked fine. I'm running on MySQL 5.0.41-community. What version are you running? (Execute "select @@version"). --Kimon 20:26, 5 December 2007 (UTC)