Member Visit Tracking

[Paul M]

As of 24 Nov 2017 this modification has been withdrawn.

This tracks the number of members that have visited the forum each day, and displays a list in the same manner as the "Who has visited (https://vborg.vbsupport.ru/showthread.php?t=196458)" modification. However, this also tracks a lot more data, such as the script (and request variables) run on their last visit, and all threads and forums visited.

Note that installing this will automatically remove the "Members Who Have Visited Today" modification.

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 members can be set to be always collapsed on initial view.
* The script that the member is running is logged (e.g. showthread, usercp etc).
* The request variables in use are logged (e.g. threadid, userid etc).
* The member visits table can be cleaned of old records to help control it's size.
* Controls for the automatic template update system.
* Member Views data collection - tracking each members viewing of the forum index page, forums and threads.
* Member Views data collection can be separately disabled.
* Multiple member visits to the same page are logged separately.
* Clicking on a member in the main display will show that members viewing data (if enabled, and you have permission).
* Usergroup permissions are done with the standard vbulleten usergroup permissions system.
* Clicking on the "Total members that have visited" line will list all members who have visited and their last action.
* The option to keep a record of [and display] the most ever members can be enabled.

Four new usergroup permissions are provided in the usergroup manager.

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

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

To install;

Unzip the XML files.
Upload the 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 permissions are given, you must set them.


Template Hook

Please note that this modification uses the following template hook in the FORUMHOME template ;

forumhome_wgo_pos2

This must be present in any customised template/style you are using, otherwise this modification will not display.


History:

v3.8.001 : Initial vb 3.8 release.
v3.8.002 : Fix install code SQL error.
v3.8.003 : Fix column title bug in memberlist display.
v3.8.004 : Fix bug in attachment viewing links.

[Bounce]

Get this error when installing..


Database error in vBulletin 3.8.0:

Invalid SQL:

CREATE TABLE membervisits
(
userid int(10) unsigned NOT NULL default '',
ipaddress varchar(15) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
dateline int(10) unsigned NOT NULL default 0,
script varchar(20) NOT NULL default '',
rdata text NOT NULL,
PRIMARY KEY (userid),
KEY ipaddress (ipaddress),
KEY dateline (dateline)
);

MySQL Error : Invalid default value for 'userid'
Error Number : 1067
Request Date : Friday, January 9th 2009 @ 09:39:14 PM
Error Date : Friday, January 9th 2009 @ 09:39:14 PM

[SnowBot]

Waiting on an update Mr P :)

[SuperDave71]

I am also waiting on the update...



And a screenshot would be helpful as well.


Always enjoy your work Paul. Keep it up!!



-Dave :D

[KEKforce]

same error here

[ecihanuysal]

same error and waiting..

[-=Leb=-]

Sweet paul , i was waiting for it :).

Hey guys i just uploaded it and didn't get any error and its working fine in my forum:S

[ecihanuysal]

Problem is still continuing. Here is the image..

http://img395.imageshack.us/img395/8286/adszwd2.jpg

[-=Leb=-]

If i'm not mistaken, make sure you update your templates. Go to admin cp, then styles and templates, then hit find updated templates.

Anyway, paul will give you the final answer.

[Bounce]

If i'm not mistaken, make sure you update your templates. Go to admin cp, then styles and templates, then hit find updated templates.


The style I am trying to install it too IS up to date :up:

[KEKforce]

Also here!

[Paul M]

Try it now (3.8.002)

[ecihanuysal]

tnx for the solution Paul !
Installed..

[abroad]

and where can I see the collected data of a user?

[Bounce]

and where can I see the collected data of a user?

You need to turn it on for each you usergroup you want to see it and it displays in the What's Going On section..

Total members that have visited the forum in the last 24 hours:

You can set various options in VBOptions > Member Tracking

To get more info simply click on the username in the stats section, brilliant!

Thanks Paul for the fixed product,installed and working a treat :up:

[anuanu]

Im running 3.8.0 RC2 and i get this error:

"The following dependencies were not met:

1. This product is not compatible with version 3.8.0 Release Candidate 2 of vBulletin. (Compatible starting with 3.8.0 / Incompatible with 3.8.99 and greater)"

[KEKforce]

Why not upgrade to 3.8.0 ??? (gold)

[anuanu]

Didnt realize they were past RC2, Ill download it and try it again.

[anuanu]

Yep, upgrading seemed to work :) Thank you

[digicom]

Thanks Installed n Working :up:

[frosch68]

great hack :up:

Is it possible to do this in a VbAcmps-module as the "who is visited" hack ? that were great.. :rolleyes:

Thanks a lot...

[Paul M]

Sorry, I cannot help with 3rd party mods.

[DjEddie]

$template_hook[forumhome_wgo_pos2]

How do you change the positioning on the above hook. Since I installed this the members list has moved below another mod that is attached to this hook.

[Paul M]

You cant, unless you start playing with execution orders and possibly hooks.

[Mark.B]

Thanks Paul for this modification, it's great.

One observation: titles seem to show up funny when viewing an individual member, the title bar shows the html for the link to the user's profile.

<title>Member : <a href='member.php?userid=2674'>scrotnig</a> : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 - BC Forums</title>

[morrow]

I'm surprised nobody asked for a screenshot yet... How bout it?

[Paul M]

Thanks Paul for this modification, it's great.

One observation: titles seem to show up funny when viewing an individual member, the title bar shows the html for the link to the user's profile.

<title>Member : <a href='member.php?userid=2674'>scrotnig</a> : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 - BC Forums</title>


So it does, i'll look into that when I have a few moments.

[-=Leb=-]

hi Paul, i'm getting database error afterwhen i updated member visit . Would you plz check the problem?
Thank You
Jonas



Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT * FROM membervisits AS membervisits FORCE INDEX (dateline)
INNER JOIN user AS user USING (userid)
WHERE membervisits.dateline > 1232065944 ORDER BY username;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, January 16th 2009 @ 05:32:24 PM
Error Date : Friday, January 16th 2009 @ 05:32:25 PM
Script : http://www.firewallcs.net/forums/
Referrer :
IP Address : 213.1
Username : -=Leb=-
Classname : vb_database
MySQL Version : 5.0.67-log

[-=Leb=-]

I turned it off now and the forum is back up

[SnowBot]

Thanks for the update Paul

[frosch68]

Sorry, I cannot help with 3rd party mods.

Doesn't matter, Paul. Thanks for your response

[Paul M]

hi Paul, i'm getting database error afterwhen i updated member visit . Would you plz check the problem?
Thank You
Jonas

Database error in vBulletin 3.8.0:

MySQL Error : Got error 28 from storage engine


Error code 28: No space left on device

This is a problem with your server, mysql is running out of space.

[jazde86]

Hi Paul,

can you let me know the variable of this Add-on to put the infobar on other pages, like a vBa module? The code from the Who have visited today doesn't work anymore.

Thanks.

[Paul M]

This will only work on the forumhome page.

[Sunka]

The member visits table can be cleaned of old records to help control it's size.

How to do that?

[Paul M]

Its a setting in the mod options.

[Rottimom]

Hello

I have a problem.
I would like a tracking member in a different place than it appears by default the case.
Red where it is displayed, the arrow is where I would be happy.
Change I $template_hook[\'forumhome_wgo_pos2 in $template_hook[\'forumhome_wgo_pos1 it is too far above.
How can I get it exactly at the point where I can show it would have been happy?
Before the upgrade to vB 3.8.1 from 3.7.2, it was at this point.

Thanks

[Drago912]

I get this error when trying to set usergroup permissions:

Fatal error: Using $this when not in object context in /home/content/A/u/s/XXXXXXXXX/html/forums/admincp/usergroup.php(335) : eval()'d code on line 1

any ideas?

[Paul M]

That is an error on the admin_usergroup_save hook (which is not used by this mod) - so some other product is broken.

[Drago912]

cool....thanks, found the problem product. However, I dont know where you see all this ifo at? Im also confused as to the hook you mention that needs to be in any custom template??

[J0PA]

Great!! thank you

[Drago912]

ummm........still waiting on some help here. I cant see the mod and dont understand the template issue. I'm sure I clicked "installed"

[sqzdog]

I don't understand the "forumhook" part when installing this. What I am I supposed to do here?

[Paul M]

You dont do anything unless you have a customised Forumhome - the hook is part of the default vbulletin template.

[MindStar]

Hi excellent Mod, couple of suggestions for improving it...


Only show the link for detailed Member Tracking reports to users who have permission to see the link, i.e. rather than having a link that leads to a "permission denied" screen, omit the link.
Re-Order the permissions in the UserGroup screen so it is clear which permissions depend on others, i.e. the view IP addresses and Tracking Data options are irrelevant if users cannot see the Member Visits List.Nominated! :)

[Paul M]

Thanks,

1. That cannot be done atm due to how they work, so they will remain as they are until I have time to convert them.

2. I suppose I could do this, but its not worth updating the mod just for that.

[Kills]

running 3.8.1 ..no problems here... Thanks Paul

[Makc666]

When you visit the page:
https://vborg.vbsupport.ru/misc.php?do=memberlist

There is a column named "User Name".

The name of that column is a URL
https://vborg.vbsupport.ru/member.php?userid=

Screenshot:
103446

I see a fix for this one:

1.

Add the phrase:
<phrase name="trm_username" date="1191000001" username="Paul M" version="3.8.002"><![CDATA[<a href='member.php?userid={1}'>{2}</a>]]></phrase>

2.

Find the code:

<td class='alt$altclass'>
<a href='member.php?userid=$memberlist[userid]'>$memberlist[user]</a>
</td>

Replace it with:

<td class='alt$altclass'>
$memberlist[user]
</td>

3.
Find the code:

$memberlist['user'] = $username[$memberlist['userid']];

Replace it with:

$memberlist['user'] = construct_phrase($vbphrase['trm_username'],$memberlist[userid],$username[$memberlist['userid']]);

And all works fine then ;)

[Paul M]

Yep, agreed, its minor but does need fixing. :)

[MarkoP]

Anyone have any idea why it shows so many members on this:

Called with DO = 'securitytoken'

Instead of being on a page it shows that...

Thanks!

[oldlock]

Is it possible to store the login info long term ? I have a forum that is subscriber access and the admins would like to be able to view a members login IP over time to see if wildly different ones are being used and if the timeframe the information is accessible for could be changed this might be a way to do it ?

[Paul M]

Anything is possible if you write the code, however, is it stands, you cannot do what you ask unless you keep all the information collected (which would create some huge tables).

[rule0]

This is awesome!! Thank you for sharing this.

[SnowBot]

Hi

Is their a way to remove the browser info?

Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1 BLAH BLAH BLAH bit :) cheers

[Paul M]

Remove it from where ?

[SnowBot]

When you click on one of the usernames it shows you their history, where they have been and what theyhave done :) Well on that page it shows you all the browser info also.

[Paul M]

Any particular reason you want to remove that ?

Its part of the "trm_memberview" phrase, edit that to remove it.

[SnowBot]

Hi Paul, its just not something my Mods need or have a use for thats all.

FOUND it, THANKS!

Changed to

{1} : <a href='member.php?userid={4}'>{3}</a>

[TheChaosFactor]

Very useful. Thank you.

[Silencer Groans]

Very nice

The installation operation was

Facility in Arabic for those who want

[linuxututs]

When you visit the page:
https://vborg.vbsupport.ru/misc.php?do=memberlist

There is a column named "User Name".

The name of that column is a URL
https://vborg.vbsupport.ru/member.php?userid=

Screenshot:
103446

I see a fix for this one:

1.

Add the phrase:
<phrase name="trm_username" date="1191000001" username="Paul M" version="3.8.002"><![CDATA[<a href='member.php?userid={1}'>{2}</a>]]></phrase>

2.

Find the code:

<td class='alt$altclass'>
<a href='member.php?userid=$memberlist[userid]'>$memberlist[user]</a>
</td>

Replace it with:

<td class='alt$altclass'>
$memberlist[user]
</td>

3.
Find the code:

$memberlist['user'] = $username[$memberlist['userid']];

Replace it with:

$memberlist['user'] = construct_phrase($vbphrase['trm_username'],$memberlist[userid],$username[$memberlist['userid']]);

And all works fine then ;)

Mine seems to working fine, but if these edits are correct , please do tell where to edit these edits.
And thank you, and Thanks for the Mod also.

Thanks,

[segwayon]

If I already have the "Members who have visited today (https://vborg.vbsupport.ru/showthread.php?t=196458)" mod, can I install this one, too? Should I first uninstall that one to get the more features of this one?

Update: Wow, there was my answer on paragraph 1! Thanks Paul! [embarrassed] . . .

[Paul M]

Perhaps you should read the main post ;)

Note that installing this will automatically remove the "Members Who Have Visited Today" modification.

[segwayon]

Paul,

I don't see the member tracking options within the Usergroup Manager, but the general options are under the VBOptions list. Am I looking for 4 new options within an existing header? Or should they be contained within a new 'Member Tracking' header?

[Paul M]

Sorry, Im not sure what your asking. What exactly are you looking for ?

[segwayon]

Sorry, Im not sure what your asking. What exactly are you looking for ?

I'm looking for the viewing permissions within the UserGroup Manager. There I can see your 'Guest Tracking Permissions' options listed but not this new 'Member Tracking' options. I also tried to uninstall this mod and reinstall it but there's still no options for usergroups to view the member tracking page or the new tracking data on forumhome's 'whats going on' area.

[Paul M]

The you probably havent uploaded the bitfield file to the correct place.

[segwayon]

The you probably havent uploaded the bitfield file to the correct place.

Yes, that was it. I saw the "/includes/" folder in the instructions but not the "/xml/". Thanks again, Paul!

[oldlock]

I've just installed this on a new site running 3.8.4 PL1 and it's not working . Odd, I have it working fine on other sites that have been upgraded to 3.8.4 PL1 .. (note they were upgraded with the patch files)

The sites are running the same mods too, which would seem to discount a conflict with other mods but point towards a conflict of some kind with the PL1 ???

[Paul M]

PL1 has zero effect on this (or any modification I would think).

Most likely the style you are using is missing the template hook.

[VonDoom]

Great Mod Paul, But im wondering if you might have any idea why it would show in every instance except one "Viewing Home Page"? Ive been all over my forum in testing this and the home page (vBadvanced) was not one of the pages i was ever on. However that the only place it says ive been.

[Paul M]

Home is actually the Forum Home, not vbadvanced.

Since I have no idea how vba works, maybe its interferring somehow.

[oldlock]

PL1 has zero effect on this (or any modification I would think).

Most likely the style you are using is missing the template hook.

Seems to be there ?

105459

[oldlock]

PS. Does'nt seem to be working in the default style either ...

Any pointers as to what else could be wrong ?

[oldlock]

I found out what was wrong, my brain ! Or rather lack of it. Seeing that I have this great mod working on other sites one would assume that I could remember how to use it ! (Doh).

All working fine now.

Thanks

[VonDoom]

Thanks Paul, Everything seems to have straightened itself out overnight.

[Jeweetog]

Hi Paul,

Got a quick question, can you modify this mod to have it a tab next to 'statistics' in the member's profile to show their tracked data in?

Thanks in advance!

[Paul M]

I think thats unlikely, but I wont completely dismiss it atm.

(It certainly wont happen in any 3.x version).

[Gero50]

Installed great no errors as of yet for me though I will report any I find.

[Lolli]

Is possible to tracking this: "send pm", "reply to", etc, in misc.php?do=memberview&member=xxx

[sinpin]

Dear Paul,

Thanks for your always great mods,
I installed this one but I have a little problem here,
It seems this mod conflicts with Members who have visited today (https://vborg.vbsupport.ru/showthread.php?t=196458) and I can't install and use both of them concurrently.

Yours sincerely

[Paul M]

Correct, one replaces the other, as the big brown message says :)

[sinpin]

Correct, one replaces the other, as the big brown message says :)

So, what's the solution buddy?

[Paul M]

There is no solution, its by design. This is a replacement for WVT.

[darkie79]

Paul,

One particular member is receiving a db error on login, see below please:

Database error in vBulletin 3.8.4:

Invalid SQL:

REPLACE INTO bb_membervisits
(userid, ipaddress, useragent, dateline, script, rdata)
VALUES
(14868, '*removed*', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1.10) Gecko/20100504 Firefox/3.5.10', 1277847284, 'adv_index', 'a:6:{s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:8:\"threadid\";i:0;s:7:\"forumid\" ;i:0;s:6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Duplicate entry '14868' for key 1
Error Number : 1062
Request Date : Tuesday, June 29th 2010 @ 05:34:44 PM
Error Date : Tuesday, June 29th 2010 @ 05:34:44 PM
Script : *url removed*/forums/index2.php
Referrer :
IP Address : *removed*
Username : *removed*
Classname : vB_Database
MySQL Version :

[MrAd]

PS. Does'nt seem to be working in the default style either ...

Any pointers as to what else could be wrong ?

Nothing has appeared in my footer (I am using default skin), does anyone has screenshot how this mod works ? Shall I expect an additional line item as in who has visited today ?

[Paul M]

Paul,

One particular member is receiving a db error on login, see below please:

That shouldn't be possible in mysql, I would suggest you run a repair on the table.

[troybtj]

Will there be a version of this for 4.x?

I'm holding off on upgrading until my favorite mods are available.

[Paul M]

It was released over six months ago. Just look in the 4.x section of my profile.

[Cybershaolin]

Great hack but one big problem. Although invisible users do not show on the forumhome list, it shows them when you click to see the detailed list. Not useful for an admin who would like to remain invisible to evrybody (including moderators) when you want your moderators to access this list.

[Paul M]

Yes.

That was corrected in the vb4 release, but remains in the older 3.8 version.

[Cybershaolin]

Hi Paul,

Thanks for the quick answer. Would it be possible for you to tell me how to fix it for 3.8 version as I did not move on 4.X? This would be really appreciated. I could fix it myself with some instructions if it's not too hard.

[Paul M]

Its not that simple - it needs a set of extra code adding.

[Cybershaolin]

I see, well, as I don't plan to upgrade to 4.X, I guess I'm gonna have to live with it. Anyhow, thanks for your great hacks and if the envy comes to you to find a way about this little problem, I would be really glad for sure.

[DigitalCop]

Excellent MOD!!! Exactly what I have been searching for!

[edytwinky]

Is there a way to change the 24 hour period to 48 hours?