Forum Home Enhancements - Track Guest Visits

As of 23 Nov 2017 this modification has been withdrawn.

This tracks the number of guests that have visited a forum each day. This isn't possible in stock vbulletin as no record is kept of guest visits, they are a 'realtime' display only.

This modification adds another section to the "What's Going On" area.
It also has seperate pages to display (1) the list of guests, and (2) the pages a particular guest has visited

Options / Features ;

* The ability to turn the whole modification on/off.
* The ability to turn just the forumhome display on/off.
* The ability to allow (or prevent) certain usergroups viewing the forumhome display.
* The ability to switch between 'Today' and Rolling 24 Hours display (default).
* The script that the Guest is running is logged (e.g. showthread, usercp etc).
* The request variables in use are logged (e.g. threadid, userid etc).
* The guest table can be cleaned of old records to help control it's size.
* The datastore read (for spider detection) will read from the File/APC/Xcache datastore if used [note, not Memcache].
* Guest Views data collection - tracking each guests viewing of the forum index page, forums and threads.
* Guest Views data collection can be separately disabled.
* Multiple guest visits to the same page are logged separately.
* The option to keep a record of [and display] the most ever guests.
* Usergroup permissions are done with the standard vbulleten usergroup permissions system.
* Clicking on the main display icon will list the recent visits by all guests (if allowed).
* Clicking on a Guest type in the main display will list all recent visits by guests of that type (again, if allowed).
* Clicking on the option in the guest listing will show that guests viewing data (if enabled, and allowed).
* The main display can be set as always collapsed on initial page load (4.0.3 +)

Four new usergroup permissions are provided in the usergroup manager.

* Can View the Guests Visited Display - Members can view the guests visited display on Forumhome.
* Can View Guest IP Addresses - Members can see the ip addresses of visiting guests.
* Can View Guest Visits List - Members can view the list of guest visits page.
* Can View Guest Tracking Data - Members can view the individual guest visit tracking page.

* All (non usergroup) modification settings are in vBulletin Options > Guest Tracking.

To install (or upgrade);

• Unzip the files.
• If upgrading from a previous version, delete any old trg bitfield xml files from your ../includes/xml/ folder.
• Upload the new bitfields file to your ../includes/xml/ folder.
• Import the product into vBulletin using the ACP Product Manager.
• Set your required permissions in the usergroup manager.

Note that by default no usergroup permissions are given, you must set them.


You can get an improved Spiders Definition file from this post.

Note: For Spider detection to work you must set Enable Spider Display to 'Yes' in vBulletin Options > Who's Online Options.
The installation code will turn this on for you.

It is recommended that you visit your Who's Online page after installing this mod (or after updating your spiders file) to make sure your spider definitions are built / rebuilt.


History:


Beta Releases

v4.0.0.2 : 04-Jan-2010 : Initial Beta release for vb 4.0.0 Gold.
v4.0.0.3 : 05-Jan-2010 : Fix scope error in global hook database write.
v4.0.0.5 : 06-Jan-2010 : Second stage Beta - Main Guest List Display added.
v4.0.0.6 : 06-Jan-2010 : Fix IP display error in Guest List Display.

v4.0.1 : 08-Jan-2010 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 09-Jan-2010 : Minor code changes and fixes.
v4.0.3 : 16-Jan-2010 : Added always collapsed option.
v4.0.4 : 20-Feb-2010 : Internal update, not released.
v4.0.5 : 27-Feb-2010 : Style code updates for vB 4.0.2.
v4.0.6 : 19-Sep-2010 : Fix bug in attachment viewing links.
v4.0.7 : 23-Oct-2010 : Fixed for WGO style changes in vB 4.0.8.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.
v4.1.8.0 : 18-Nov-2011 : Updated for vBulletin 4.1.8 onwards (only).
v4.1.11.0 : 03-Mar-2012 : Updated for vBulletin 4.1.11 image changes.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.

[Paul M]

I suggest you re-read the install instructions

[Dave-M]

Hi Paul,

Yesterday, I started getting Vbulletin errors, once I get them, the site goes dead and the server people have to repair the database. After they fixed it, it was OK for a few hours, and then I woke up today to several thousand emails telling me of errors again.

They look something like this:

Database error in vBulletin 4.0.5:

Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
			
			
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
			
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 21 AND postparsed.languageid = 1)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 21 AND sigparsed.languageid = 1)
		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
			
		WHERE post.postid IN (089129,89145,89148,89174,89186,89284,89304,99824,100011,100020)
		ORDER BY post.dateline;

MySQL Error   : Table './databasenamehere/user' is marked as crashed and should be repaired
Error Number  : 145
Request Date  : Wednesday, December 8th 2010 @ 07:38:43 AM
Error Date    : Wednesday, December 8th 2010 @ 07:38:43 AM
Script        : http://www.mysite.com/forums/blah-blah.html
Referrer      : 
IP Address    : edited
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

I'm running 4.0.5. Never had any problems with this until yesterday, and nothing has changed on the server, at least not by me.

I wonder if you could shed any light on this please? I'd really appreciate it.

Thanks.

[Paul M]

Not sure why you have posted in this thread ? That error means your User table has crashed and needs to be repaired. It has no connection to the Guest Tracking mod.

[Dave-M]

Oops, sorry

What happened was, I googled the error from one of the early emails, and there were a few links pointing to this thread (including one from vbseo.com), but today's errors, as you quite rightly say, aren't related.

I do apologise

Dave.

[Boofo]

Paul, for some reason when this is enabled, it is adding a trailing comma to the Currently Active Users ($activusers). If I disable the mod, the comma is gone.

[Paul M]

No idea on that.

This makes no changes to active users, and I dont see any extra comma on my test forum.

[Boofo]

I'm sure it has something to do with the commalist. That is still screwed up in certain browsers.

[OldSchoolDSL]

Another job well done Paul

Working in 4.0.8 Patch Level 2

[Habsy]

Not working on 4.1 PL2. Does not appear on mainpage

[djbaxter]

Originally Posted by Habsy

Not working on 4.1 PL2. Does not appear on mainpage

Working fine for me on 4.10 PL2.

Check your settings and/or rebuild/revert your styles.