Forum Home Enhancements - Track Guest Visits

This modification is no longer available or supported.

Something that has been repeatedly asked in the "Members who visited today" modifications (all versions) is a similar way to track 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. I've therefore finally got round to looking at the issue and produced this modification.

This will add (another) section to the "What's Going On" area. The data is kept in a new table so it should be possible for other uses to be made of it (or display it in other ways). A screenshot of the current display is attached.

Options / Features ;

* The ability to turn it on/off.
* The ability to turn just the display on/off.
* The ability to allow (or prevent) certain usergroups viewing the display.
* The ability to run the display code on all pages (not just forumhome).
* The ability to switch between 'Today' and Rolling 24 Hours display (default).
* The list of guests can be set to be always collapsed on initial view.

* 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.
* Controls for the displays automatic template update.
* The datastore read (for spider detection) will read from the File/APC/Memcache/Xcache datastore [if used].

Version 1.19+

* 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.
* Clicking on a Guest type in the main display will list all recent visits by guests of that type.
* Clicking on the option in the guest listing will show that guests viewing data (if enabled).
* Usergroup permissions are now done with the standard vbulleten usergroup permissions system.

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.


Version 1.22+

The option to keep a record of [and display] the most ever guests has been added - this used to be provided by a seperate add-on product.


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

To install ;

• Unzip the XML files.
• Upload the bitfields file to your ../includes/xml folder.
• Import the product into vB using the ACP Product Manager.
• Set your required permissions in the usergroup manager.

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

You can get an improved Spiders Definition file, that recognises many more spiders, from this post.

Note: For Spider detection to work you must set Enable Spider Display to 'Yes' in vBulletin Options > Who's Online Options.

A German translation has been provided by hurik in post #769 - (for Version 1.22).


History:

v1.00 : Internal dev version.
v1.01 : Initial vb 3.6 beta release.
v1.02 : Phrasing added, final beta version.
v1.03 : Initial full version, some new options added.
v1.04 : Fix potential variable name clash with WVT Mod.
v1.05 : More options added, script and request variable logging added.
v1.06 : Minor internal code changes, phrasing altered slightly.
v1.07 : Datastore call changed to standard fetch function.
v1.08 : Moved Datastore call due to oddities, and fixed small bug.
v1.09 : Simplified always collapsed code.
v1.10 : Datastore call moved and reverted back to db_fetch.
v1.11 : Added Spider Cache Refresh on install (limited release).
v1.12 : Unique Guest id changed from standard vb id to internally created id.
v1.13 : Changed the SQL to force MySQL to use the index on forumhome.
v1.14 : Changed install code to delete old spider cache before rebuilding it.
v1.15 : Added check to try and detect a broken spider cache and fix it.
v1.16 : Number formatting added to individual totals in display list.
v1.17 : New usergroup display options added, datastore read updated.
v1.18 : Beta for new display options - listing guests and tracking guest views.
v1.19 : First release with the new permissions and display options.
v1.20 : Minor changes to install code only.
v1.21 : Internal development version, not released.
v1.22 : Added the "Most ever guests" option.

[Paul M]

Originally Posted by GateKeper

Not sure but we were getting a lot of these message's yesterday



I think it was because in those few moments I did not setup the permissions in the user group manager, but I cannot confirm this was the reason, as one of the other Admins, did a restore of a previous backup, and the messages went away, this did not affect the installation of this hack, as it's still on and running, however no one is reporting the above error messages anymore, current version of hack is running, user group permissions are all done....

so not sure still as to why...

any thoughts ?

The first test version (V1.18, R1.23) had a primary key on the guestviews table, it was removed in the next test version. If you upgraded from the first test version direct to 1.19 then you would get those errors. Uninstalling and then reinstalling the modification would fix it.

[Paul M]

Originally Posted by jluerken

Hi PaulM,

with version 1.19 I get a MySQL Error when clicking on a Spider link
(misc.php?do=guestlist&type=Visitors)

Database error in vBulletin 3.6.8:

PHP Code:

Invalid SQL:

        SELECT COUNT(dateline) AS count, guest.* 
        FROM vb3_guest AS guest
        LEFT JOIN vb3_guestviews as guestviews
        ON (guest.guestid = guestviews.guestid AND guestviews.dateline > 1190098883)
        WHERE lastactive > 1190098883 AND spider = ''
        GROUP BY guestid 
        ORDER BY lastactive DESC 
        LIMIT 1000;

MySQL Error  : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error Number : 1267 


That's an issue with your tables. Mysql has created them with different collations, you need to edit one to match the other (in phpmyadmin).

[djbaxter]

Originally Posted by Paul M

If your XML says 1.17 then you have the wrong version, the XML uploaded says 1.19.

The xml indicates 1.19 as the version:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- $Header: d:\cvs/3.6/Track-guests.xml,v 1.19 2007/09/01 14:38:57 pem Exp $ -->
<product productid="paulm_20061109" active="1">
	<title>Guest Tracking</title>
	<description>Track Guest Visits</description>
	<version>1.17</version>	
                <url/>
	<versioncheckurl/>
	<cvs><![CDATA[$Revision: 1.19 $]]></cvs>
	<dependencies>
		<dependency dependencytype="vbulletin" minversion="3.6.0" maxversion="3.6.99" />
	</dependencies>
	<codes>
		<code version="*">
			<installcode><![CDATA[
// Start v1.13 //

Addendum:

Never mind. That must have been the beta version. I apparently downloaded but didn't unip the 1.19 release version.

[Paul M]

Ignore the Revision number - that's just my local CVS tracking - the Version is what's important - so the example above was Version 1.17.

[djbaxter]

OK. See my Addendum above. I had downloaded but neglected to unpack the latest version. I've now corrected that, uninstalled the o0ld version and installed the new version, and everything is as it should be.

[GateKeper]

Originally Posted by Paul M

The first test version (V1.18, R1.23) had a primary key on the guestviews table, it was removed in the next test version. If you upgraded from the first test version direct to 1.19 then you would get those errors. Uninstalling and then reinstalling the modification would fix it.

I have completely redone the work, un-installed and reinstalled, will let you guys know if anymore error messages are sent....

Thanks

[DieselMinded]

Mr. M

How Do I Get the Most Ever Visitors Online Thing Likes in the Screen Shot?

Thanks

[Paul M]

You look in my profile ....... and suddenly notice this

Most ever Members, Posters, Guests and Chatters

[DieselMinded]

Thanks
/me Clicks installed 2 times today
Members Rejoice

[GateKeper]

Originally Posted by GateKeper

I have completely redone the work, un-installed and reinstalled, will let you guys know if anymore error messages are sent....

Thanks

Still problems, still getting error email's like the one below

Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO guestviews
(guestid, forumid, threadid, dateline, ipaddress)
VALUES
('c4007f4e8d7ec5f39552297f33487eed', 0, 0, 1190219076, 'xx.xx.xx.xx');

MySQL Error : Duplicate entry 'c4007f4e8d7ec5f39552297f33487eed-0-0' for key 1 Error Number : 1062
Date : Wednesday, September 19th 2007 @ 04:24:36 PM
Script : http://www.ftaview.com/index.php
Referrer :
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vb_database

I did an uninstall of the hack, I installed the latest version, and I get the errors, I once again removed it, and tried to go back to an older version, ended up with even more errors in the user group manager area, it had the guest tracking permissions, with just the radio buttons but no descriptions, so I removed everything again, installed the latest again and have disabled the hack to see if I get anymore messages, if none, I will enable the hack tomorrow and see if errors come in again....

.