Track Guest Visits

[Paul M]

vBulletin 3.7 Version
Please remember to click Mark as Installed if you use this modification.
Support questions from members who have not marked this as installed will be considered low priority.

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 will add (another) section to the "What's Going On" area.

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 .
* 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 done with the standard vbulleten usergroup permissions system.
* The option to keep a record of [and display] the most ever guests can be enabled.

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 XML files.
Upload the bitfields file to your ../includes/xml folder.
If upgrading from the vb 3.6 version, delete the [I]bitfield_track-guests.xml file from 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 (http://www.vbulletin.com/forum/showpost.php?p=565415) - and now a more recent version is available from this site (http://spiderlist.codeforgers.com/).

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


History:

v3.7.001 : Initial vb 3.7 release.
v3.7.002 : Fix for cron_script hook changed in 3.7 Beta 4.
v3.7.003 : Header, Navbar and Footer added to guest display pages.
v3.7.004 : Tracking of visits to archive pages added.

[AdemGENÇ]

Thanks
ok

[Zaiaku]

Someone has been busy. Thx

[KURTZ]

oh yes Paul!!!!! :D

[JAuthement]

Thanks Paul for porting this over to 3.7

[Mutt]

I've never used this mod. How is it on a very large board? I love the idea but worry my traffic might be too much for it. any input would be appreciated. thanks

FYI - we get approx 20 million page views a month

[Paul M]

The data collection uses a simple sql insert/replace per guest, the forumhome display uses one select - the table is indexed. I dont see why it would cause any issues. The only way to be sure is try it.

[Barakat]

works good .....

[projectego]

Thanks very much, Paul. :)

[KidCharlemane]

Nevermind... sucks to think youre working on one forum and realize youre actually uploading files to another by mistake.

[Mutt]

The data collection uses a simple sql insert/replace per guest, the forumhome display uses one select - the table is indexed. I dont see why it would cause any issues. The only way to be sure is try it.

thank you sir

[Chance4Today]

Thank you thank you thank you I have been awaiting for this one. Installed happy as always and here is a gift for ya Paul LMAO

http://img141.imageshack.us/img141/7532/develap8.gif

[Freesteyelz]

I like the fact that in all of your mods we're able to display them where we want. Thanks again, Paul. :)

[DeRBeDeR©]

<removed, not in English>

[Paul M]

Please remember to post in English only, Thanks.

[MrNase]

Hey Paul,

Do you think it's possible to extend it further so that you can keep track of banned users when they are logged out and still browsing the forums?

Maybe a link to a page where you can check the guest's IP against the list of banned IPs or something.

The problem I have right now is that I banned a user account and that person also got barred and I want to prove that this guy is still using my forums.

[ptstefa]

i have installed and enable it but i can't see any difference or a button to see the tracjing!
In ACP is enabled
in usergroups permission i did not find any point for geust tracking


thanks in advance

[waynehindle]

i have installed and enable it but i can't see any difference or a button to see the tracjing!
In ACP is enabled
in usergroups permission i did not find any point for geust tracking


thanks in advance

I have the same issue and not sure where i've gone wrong.

Regards

[Paul M]

Did you actually upload the bitfield file, and then import the product ?

[ptstefa]

SERIOUS PROBLEM after upload xml file


You have been banned for the following reason:
No reason was specified.

Date the ban will be lifted:


I CAN'T LOGIN AND FORUM IS DOWN!!!HELP

[Paul M]

Um, I dont see how uploading this could possibly cause such an effect.

[ARB4HOSTING.COM]

Thanks

[asj]

Thank you very much

[KURTZ]

Paul, just wondering ...

about THIS (http://www.vbulletin.com/forum/showpost.php?p=565415) post, if i wanna increase my spider detection i must download and rename the spiderlist.xml in spiders_vbulletin.xml right?

[Paul M]

Updated for Cron Script changes.

[Paul M]

...if i wanna increase my spider detection i must download and rename the spiderlist.xml in spiders_vbulletin.xml right?
Yes.

[Chance4Today]

Thanks Paul I love this hack and never have had a issue with it :)

[KURTZ]

Paul, i've just updated, but i don't uninstalled the previously version ... :(

when i tried to install the latest i saw the request that we must uninstall the old hack (.001)... but i've overwrited the new hack ... however after that i uninstalled your hack and reinstalled the .002 ... maybe i've troubles? something about the old hack is "hooked" on my DB?

i made the same error with the "who has read" ...

edit: another question Paul, is possible that the old hacks made my forum slow? now, with the new hacks my board seems more faster ...

[Paul M]

I'm not sure what you are talking about here - what request to uninstall .001 ?

[KURTZ]

sorry for my bad english Paul ... :)

anyway i try to explain better ...

when i installed the .002 (the latest hack that you release) the plug-in tells me that i must uninstall any previously version that i've installed, then the .001 ... but i don't uninstalled the .001 i simply overwrite the .002 onto the .001 ... (i don't stopped the installing process)

it's clear now? :)

[Paul M]

I think you are misreading the message - it simply informs you that it is has removed any older version (pre 3.7). It does not ask you to do anything. I'll probably update the message slightly to make it clearer.

[KURTZ]

OK thx Paul :)

[AdemGENÇ]

<removed, not in English>

[bainsey]

installed, brilliant.

[Dream]

Would be nice if the spiders linked to their <info></info> on spiders_vbulletin.xml

[Paul M]

I'm not sure what use that would be to most people.

[Dream]

Just a curiosity to see what are those names that visited the forum, members sometimes wonder.

[Brew]

I noticed that on new boards the date is set to 01-01-1970 if there are no guest visitors.

Not a big deal because as soon as someone visits this will get updated. But it is something you may want to change.

Thanks for this great mod :)

[mac27]

Thanks Paul.

[Dream]

Paul, this has all the spiders the old XML had and some more. You can update your link to the spiders detection file if you want, as this is being updated and the old one is from 2006.

http://spiderlist.codeforgers.com/

[Paul M]

Added to first post. :)

[iyihost]

thanks:)

[shlomot]

Here here to a cool MOD and smooth installation and configuration ride.

Thanks a lot. INSTALLED & RATED.

[iyihost]

my version 3.7.0 beta 4 but can't run hack ?

[Paul M]

If you are running beta software then you should be on Beta 6 by now.

[Holfy.com]

Thanks working fine on 3.7 Beta 6

[rolandogomez]

Excellent! *Installed* Working fine on 3.7 B6 Thanks, rg sends!

[PaulSonny]

can anybody help with this.

I want to edit the currently active users bit below:

Currently Active Users: 9 (2 members and 7 guests)

So that it displays:

Currently Active Users: 9 (2 members and 7 guests) Total Visitors Today: {param}

param being the total number of visitors from this hack?

Thanks, Paul.

[djpassion]

i cant get this to work. im using vb 3.7 rc1

[chrissmith]

i cant get this to work. im using vb 3.7 rc1

worked for me ... same vb version

[angusv]

I am running the latest version of vB (3.7). I have installed the hack and enabled it via the AdminCP. However, nothing appears by the "What's Going On Box". I haven't edited any of the templates; should I have?

[Paul M]

No template edits are needed, did you follow all the instructions ?

[djpassion]

ok its ok Paul. i forgot to do the permissions "Set your required permissions in the usergroup manager. "

great plugin

cheers chris

[angusv]

No template edits are needed, did you follow all the instructions ?

Ohhh, I saw what djpassion wrote. I hadn't enabled it in the usergroup manager.

Great hack - thanks!

[slickdawg]

Any chance of being ported to 3.8?

[Paul M]

3.8 ???

[djpassion]

Any chance of being ported to 3.8?

3.7 isnt even out yet :p

[Boofo]

I don't know how I missed this. Excellent hack, sir. ;)

[Dream]

I don't know how I missed this. Excellent hack, sir. ;)

I would have told you if I knew you didn't know :)

[redlabour]

I still cant see anything.

Permissions are set, Bitfield uploaded - the Guest Tracking Systems i missing in the "Who´s online Area".

[ShawnV]

One of my favorite hacks, thanks Paul.

_V

[redlabour]

Ah works now....

[J98680B2423E]

Installed (also marked). Works well. :up:

Would be good to have the "List of Guests Visiting the Forum" displayed between the forum (Header, Navbar) and Footer, and not as a standalone. :)

[readjono]

I have one thing popping up a lot which seems to be the FAQ Smilies page. It says -

Called with DO = 'bbcode/werbungFrame.php?do=http://www.omegadm.co.uk/new/fdfffffffffffff/.inc/prc.gif?'

What's that all about?

[Paul M]

Just a guess, but maybe someone trying to exploit your forum.

[Haenk]

Variable "guestlisttitle" is always empty

where can I fill it?

Thanks

[Paul M]

Its built from the phrase "trg_guestlist".

[axg]

Kudos! Thanks for this mod. Works great. Marked.

[freebase69]

This works awesome. You see their IP and can highlight it and search Google to identify spammers with ease. Made my life easy other than the fact I had to keep adding new IP's to my blacklist lol.

[Larz979]

I just uninstalled this mod because I was starting to get some errors that pointed to the guests table.

After uninstalling it my "usergroup" table is now missing off the server. Any ideas why this would go missing after the uninstall?

3.7 gold

Larz

[Haenk]

I'm missing a title for
".../misc.php?do=guestlist",
".../misc.php?do=guestview..."
I see only "- forum title"
Is it possible to activate the navbar with broadcum and so on in the view?Thanks

[Paul M]

I just uninstalled this mod because I was starting to get some errors that pointed to the guests table.

After uninstalling it my "usergroup" table is now missing off the server. Any ideas why this would go missing after the uninstall?

1. If you get mysql errors then thats a mysql problem, not this (you probably needed to repair the table).

2. This has no effect on the usergroup table, either installing, using, or uninstalling it.

[Larz979]

Somehow the permissions on the table got screwed up. I am back up and running. May or may not have had to do with the uninstall.

I just uninstalled this mod because I was starting to get some errors that pointed to the guests table.

After uninstalling it my "usergroup" table is now missing off the server. Any ideas why this would go missing after the uninstall?

3.7 gold

Larz

[Paul M]

I'm missing a title for
".../misc.php?do=guestlist",
".../misc.php?do=guestview..."
I see only "- forum title"
Is it possible to activate the navbar with broadcum and so on in the view?Thanks
Title are there on a full, unedited install, what have you changed ?

[Paul M]

As requested a number of times, I have now added the Header, Navbar and Footer to the guest information display pages.

[ercy]

thank a lot

[Hugo Holbling]

I've occasionally been getting a database error since installing this mod:

Invalid SQL:
SELECT * FROM guest FORCE INDEX (lastactive) WHERE lastactive > 1210374000;
MySQL Error : Table './hugoholb_vbulletin/guest' is marked as crashed and should be repaired
Error Number : 145

When I switched off the mod in the admincp the error went away. Do you have any idea what's going wrong and what I can do to fix it? I'm going to uninstall it and then install again to see if that corrects the table.

[Paul M]

It means exactly what it says - the mysql table has crashed - you need to use the mysql repair command to repair it (you can do this via phpmyadmin or the ACP).

Uninstalling/re-installing it might work as that will attempt to drop and then re-create the table - however, im not sure if mysql will drop a crashed table.

[Hugo Holbling]

Thanks, Paul. It's working fine now.

[PenPusher1000]

Cool hack. Great for focusing marketing efforts.

One question. Where is the 'what's going on" section.

Thanks!!

[Paul M]

On the homepage, at the bottom.

[pasyvr6]

Thanks Paul for the hack.

I will give a shot today!

[digicom]

Thanks Paul.:up:

[KURTZ]

Paul just a question:

i've already changed the default spiders.xml with the more recent, so if i go into the who's on line 'hidden' box (where i can vew the IPs) i saw that the software recognizes the spider (Snap Shots Spider) but i don't see it in your hack like Yahoo or Google ... where it count each visit of a spider ...

edit: nevermind after some minutes, now it works ... :)

[Paul M]

The spider has to actually read a page after you update the file.

[butch3r]

Great mod. Here comes russian translation

[Paul M]

:up:

[topmedic]

It means exactly what it says - the mysql table has crashed - you need to use the mysql repair command to repair it (you can do this via phpmyadmin or the ACP).

Uninstalling/re-installing it might work as that will attempt to drop and then re-create the table - however, im not sure if mysql will drop a crashed table.

Had the same issue. Repairing via ACP and phpmyadmin did not work so I had to uninstall/reinstall. It did drop the crashed table.

[Jason Buchanan]

I have installed and all is working. Do the spiders automatically show up in the currently active users? If not can you explain how to make it so. Take it easy on me I am a rookie. Thanks.

[Paul M]

This mod has its own display section in the "Whats going on" section, the visiting spiders are listed there.

[skogen]

This is a great plugin! :up:

One question... On my forums many people doesn't log in (they are to lazy) so they just read the forums. I know lot's of the IPs where they are from (schools here in my town and company's). Would it be possible that instead of "guest" it would check the IP from a xml-file and the print "guest - any-school" or "guest - any-company"

You could compare it to the spiderlist but here it's about "known" guests. Would it be possible?

Thanks

/Fredrik

[readjono]

The latest update sees the table just cut off half way down and leave a lot of blank space. Would this be to do with the template? Or is it because I added over 500 rows?

[Paul M]

The latest update sees the table just cut off half way down and leave a lot of blank space. Would this be to do with the template? Or is it because I added over 500 rows?
I have looked at your site and cannot see that happening, please provide an example link.

One question... On my forums many people doesn't log in (they are to lazy) so they just read the forums. I know lot's of the IPs where they are from (schools here in my town and company's). Would it be possible that instead of "guest" it would check the IP from a xml-file and the print "guest - any-school" or "guest - any-company"
You can define spiders by IP address in the vb spiders file, so I would suggest you customize it for yourself, making sure you keep a copy for when you upgrade vb.

[skogen]

In the guest list, would it be difficult to implement the resolve function? I think that would be very handy if the IP-adress could be link as it is on the WOL-page :)

[readjono]

I have looked at your site and cannot see that happening, please provide an example link.
http://www.unofficialmills.co.uk/communities/misc.php?do=guestlist&type=Visitors

[Paul M]

Sorry but I dont see any gaps or blank rows in that display, looks fine to me (as it did when I last looked).

[readjono]

Ah... perhaps it's just from admin view then.

[Paul M]

That column should be the IP address.

[readjono]

That column should be the IP address.
Yeah, I blanked that one out. I meant the grey underneath as the footer is a distance below.

[Paul M]

Sorry, no idea, must be something on your site, there is nothing in the code to do that and its fine on my site.

[mikeinjersey]

I just installed this. Does it take a little time to gather information? Nothing is being shown yet.

Also, is there a way to just seperate the Real visitors from the Spiders ? It would be nice to have a seperate option to show 'who is online' to eliminate all spiders and ONLY have the number of real people visiting and block all the spiders.

This plugin is helpful because normal vBulletin without any mods displays spiders and visitors combined...this one can atleast seperate the 2. My goal is to completely eliminate the numbers of spiders and only show visitors to regular users... although in a seperate area (unseen from regular members) it could display to spiders to me so that I could tell if im getting alot of hits from regular members or if its just a spider surge.

If there is another plugin out there that someone might know of aware of , i'd appreciate it.

[mikeinjersey]

I got the stuff to display...didnt have usergroup settings enabled. sorry about that.


But the other question ^^ im still interested in. That would also be a great thing for usergroup permissions as well. To enable Members to ONLY see the real human visitor number that are visiting the site..and eliminating the spider stuff completely.

great plugin by the way.

[Paul M]

Hmm, seperate permissions for visitors and spiders, not sure many people would really need that tbh. Still, I'll think about it.

[mikeinjersey]

I think it would be the 'Purest' and most greatest thing. This way they are totally seperated and what you see are Actual human visitors...no bots of any kinds and thats the ONLY number that is show on the forum. It would be great to have that I do believe. An optional thing though.

For instance regular members only see that.....and moderators could see the detailed stuff if they wish.

I dont think it would be too difficult to incorporate...I was searching mods today and couldnt find even one that had that.

The only slight negative effect for people initially is that your "currently active users" number would be much lower and some people might not want to take that risk... even myself, I fear if people see the numbers declining alot...they may decide this is a crappy forum and they wont hang around.

[dt_truck11]

*installed*

great hack

[StRiKeR035]

ok i have this mod and it tells me this 05-26-2008, 08:49 AM Visitor No register 58.83.45.91 Member Registration for bobo69x11
05-26-2008, 08:07 AM Visitor No register 121.204.36.216 Member Registration for lovetxtin
05-26-2008, 06:55 AM Visitor No register 74.85.13.52 Member Registration for cdef174
and much more and when i click on these so called members it tells me they dont appear even regisered so ive had aabout 29 guests register and none of them show up on my registered user count in the stats i dont no if its a mod interfearecne or or something i did wrong

[russbo]

As usual, perfect design, flawless execution. Thanks Paul!

[Paul M]

ok i have this mod and it tells me this 05-26-2008, 08:49 AM Visitor No register 58.83.45.91 Member Registration for bobo69x11
05-26-2008, 08:07 AM Visitor No register 121.204.36.216 Member Registration for lovetxtin
05-26-2008, 06:55 AM Visitor No register 74.85.13.52 Member Registration for cdef174
and much more and when i click on these so called members it tells me they dont appear even regisered so ive had aabout 29 guests register and none of them show up on my registered user count in the stats i dont no if its a mod interfearecne or or something i did wrong

The fact they are on the registration page does not mean they sucessfully registered. :)

[bitbender]

Those are most likely bot registration attempts... I see them on my test 3.7 with this mod...

PaulM, congrats, I really like this one. I have forever wanted to know what were guest counts and what were spider counts.

[StRiKeR035]

o ok so it tells me they registered as "name" and since they didnt regester successfully they dont exist?

[mariocaz]

I don´t see the another section of this mod in my forum, help!!

www.all-reefs.com

[Paul M]

Did you follow the install instructions ?

[mariocaz]

I think is this, but I don´t understand it very well. :( sorry

Set your required permissions in the usergroup manager.

[mariocaz]

Ok I see it, never mind so sorry.

[bitbender]

o ok so it tells me they registered as "name" and since they didnt register successfully they dont exist?
Yes, exactly... perhaps it entered data in error on the forum beyond the user name, forcing a partial resend for correction .. Being a bot, it didn't reply.. but.. The tracking software simply saw the last transaction and registered what data it knew.

I know the registration process works, and I know these ghost registrations happen on my site from time to time, same forensic, saw them registering, but they don't exist. Logic tells me that they simply did not complete....

[Mirage Guardian]

Congrats, PaulM
may you alter this mod to check Guests IP? so it can tell us that the user "named bla bla" is viewing the forum as a guest.

[EvilJohn]

Thank You Sir! :up: (waiting on that 1st guest)

[GPTB]

Just posting to say thanks for this mod. Working fine for me on vB 2.7.1.

[drsli]

Thank you so much for another awesome add-on! :)

[mannaraja]

That is a tiny image.........

[Gamezod]

Ive got the mod installed, the Correrct XML uploaded to the includes/xml folder, and have imported the product ok. But im not getting the permissions options apearing in the usergroup permissions bit. I know where it should be located, as ive had previous installations working fine, but i just dont seem to be able to get this one to work. Any ideas or suggestions?

[Paul M]

Try manually rebuilding the bitfields ;

..../forumpath/admincp/index.php?do=buildbitfields

[camoman]

How would I put this on my cmps page?

[tt_chatter]

I am wondering the same thing. How do you put this on your CMS page.

Thanks

[chuckhodson]

Works great thanks...

[vissa]

Nice mod. I installed it, but had to disable it due to some problems.. Followed the directions to a T and it works fine for my admin usergroup.. However, the guest (unregistered) usergroup will not display the guest visit stats no matter when I set their group permissions to.

-vissa

[CPOWA]

Try manually rebuilding the bitfields ;

..../forumpath/admincp/index.php?do=buildbitfields

Paul, I executed ...do=buildbitfields as you suggested but still don't see any permission options in any usergroup. This is my first ever product/add-on so I may well have botched it. The instructions are pretty clear though...

Downloaded the zip file
Unziped the XML files.
Uploaded the bitfields file to my ../includes/xml folder.
Imported the product into vBulletin using the ACP Product Manager.
Set your required permissions in the usergroup manager.

Executed ..../forumpath/admincp/index.php?do=buildbitfields form the command line

Still can't see any permissions in any usergroup in the usergroup manager.

I'm running a vanilla 3.7.1 package with the exception of a custom Logo, color customizations, and minor modifications that I've made to the FORUMHOME template.

http://www.cpowa.org

[Paul M]

Well you must have made an error somewhere along the line, but without access to your forum acp and ftp, there is no way for me to tell you what. :)

[ArnyVee]

As always....awesome hack Paul. :D

[ArnyVee]

What's today's update?

[KURTZ]

What's today's update?

v3.7.004 : Tracking of visits to archive pages added.

[EvilJohn]

Thanks for the update! Installed

[cmedic101]

Great Mod.....Works perfect with 3.71

thank you for your hard work


cmedic101

[kurtbarker]

with allthe guest information that is logged, where can I view it. It was somewhere in the ACP or is it a file?

[Joey805]

I had to temporarily uninstall this because it was conflicting with another plugin I had but now all my spiders in Who's online show up as guests. Why would this be? My spiders_vbulletin.xml still has all my entries in it. But everyone of them shows up as a guest.

[peterpigman]

Works very well but it made my server cry, had to remove it as my figures doubled

[KURTZ]

I had to temporarily uninstall this because it was conflicting with another plugin I had but now all my spiders in Who's online show up as guests. Why would this be? My spiders_vbulletin.xml still has all my entries in it. But everyone of them shows up as a guest.

i think there is an issue: i don't know if this hack caused something ... however HERE (http://www.vbulletin.com/forum/project.php?issueid=25874) i've got a feed-back from Jelsoft ...

[KURTZ]

OK i'm back, i just made some tests onto my boards, then i can say this:

it's really weird ... but now it seems to be correct (but i need more testing)

if you have changed the spiders.xml BEFORE upgrade this hack you must uninstall this hack and you also must put the default spiders.xml, then you can re-install this hack, see if it detects correctly the main spiders (like google or yahoo!) and after that you can put the dream's .xml ...

if you install this hack with dream's or default spiders.xml enabled magically all the spiders lose their name (so you can't catch them onto WOL or guests display) ... so we must re-upload the spiders file (dream's or default it's the same) again ...

also i've tried onto a fresh board WITHOUT this hack, i've only substitute the default .xml with dream's and it didn't recognize the new spiders (like snapshots), so i take the default .xml and i've only added manually the snapshots ident, then i saw if this runs and i can get the snapbot onto WOL ... yes it runs, now it recognized the new spiders, then and finally i've re-changed the default .xml with dream's file and it still recognized the new spiders ... after this i put Paul's hack onto my testing/fresh board and it runs ...

hope you can understand what i wrote :p

[Ryan Ashbrook]

Hey, Paul, after updating this plugin to 3.7.004 I started receiving the following error via AJAX Edit Post.



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------





Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



(Note: I'm using the full formatted YUI and vBulletin Javascript files, not the minimized versions. However, this error appeared before I switched the JS files.)

I also have "Code Option" set to "Run Code on all pages"

I've temporarily disabled this plugin for now, however it is a nice plugin and will Enable it again when a patch is served. :)

[StepOnFrog]

Thanks for this Paul, I think you've created something that hasn't been recognised for its potential in Spamming Prevention...!

This MOD actually logs activities performed on the registration page, and it is here where SpamBots fail the CAPTCHA image process. What I've proposed on vBulletin.com (http://http://www.vbulletin.com/forum/showthread.php?t=276686), and requested as a MOD in the Unpaid Mod Requests section (http://http://www.vbulletin.org/forum/showthread.php?p=1563594#post1563594)on here (I know, I'm skint!) is something that places all new registrations into a table, and from there, the new users can be marked as spammers (for moderation on their posts), or moved into the memberlist should they succeed the registration process.

Your MOD --> Track Guest Visits <-- has a lot more potential than just tracking guests.

Track Guest Visits is my new piece of heavy duty Get Stuffed Spammer kit.

Seriously, it truely is great work.!

[Paul M]

I've temporarily disabled this plugin for now, however it is a nice plugin and will Enable it again when a patch is served. :)
Sorry, but I can edit posts just fine, and tbh, if it was really an issue, I think it would have been reported before now. You must have something wrong locally. Try removing it and then re-installing it.

[karlm]

A suggestion for future release of this product.

Link the IP addresses similar to 'whos online' (so they resolve in the page), or to acp so admin (only) can inspect the IP address and cross reference it to past member activity or similar.

Otherwise and in all ways, an excellent release.

[Pander23]

A statistic would be nice which record the score of the user visits today and show them in a grafical diagram.
Perhaps will this in a feature version available.

regards

Pander23

[jswiss]

Hi Paul,

This is just the mod I need as I have a lot of guests, so it'd be cool to track them.

My question is: can you add this to vbadvanced cmps (3.1)? I'm running vbadvanced and was just wondering how to tie your mod into their 'Online Users' mod.

Many thanks!

[Paul M]

Sorry, I cant help with VBA questions - I suggest you try their forum. :)

[jswiss]

Thanks Paul,

Cool mod! I disabled vbadvanced and i've got it working now.

Cheers!

[wayne3]

thanks!

[StepOnFrog]

My question is: can you add this to vbadvanced cmps (3.1)? I'm running vbadvanced and was just wondering how to tie your mod into their 'Online Users' mod.

I believe you would setup and add this MOD as a module in the VBA control panel in your Admin CP... there are options to add PHP files and templates as sections in your vBA_CMPS page, such as is the Birthday box, or Statistics that come pre packaged with VBA.

Not sure you would need to disable vBAdvanced, though!?

I'd do it myself if I knew how. :(

[jswiss]

I believe you would setup and add this MOD as a module in the VBA control panel in your Admin CP... there are options to add PHP files and templates as sections in your vBA_CMPS page, such as is the Birthday box, or Statistics that come pre packaged with VBA.

Not sure you would need to disable vBAdvanced, though!?

I'd do it myself if I knew how. :(

Thanks Frog,

I don't know how to do it either :confused: - I had a look atvbadvanced forums for info about adding a separate mod/php page, but didn't really find an 'easy-1-2-3' guide so I just disabled vbadvanced.

Cheers!

[TFEX]

very nice, installed :)

[rotor]

Ok, I couple of posts here that had trouble with this not showing in permissions ....

I'm having the same trouble - installed as instructed and tried the /admincp/index.php?do=buildbitfields fix .... but still not showing in permissions

Uninstalled and reinstalled and still not showing in permissions .... rebuilt bitfields again and still not showing ........

Anything else to try before I give up???


rotor

[Paul M]

Try copying the bitfields file to the correct place ?

[rotor]

it's in the /includes/xml

sorry it's not on the site in my signature - it's at Oz Toyota Club (http://www.oztoyotaclub.com/)


rotor

[rotor]

mmm it's working ok now!! After checking my ftp log I must have just gone to upload it but never did :o

ok all working fine now ... thanks

Working ok on both sites now ....

[SMosher]

Having the same issue with no permissions found under USERGROUP MANAGER. Im not to familiar with the mods for this is my first vBulliten go around in the last 3 years and alot has changed.

Paul, I executed ...do=buildbitfields as you suggested but still don't see any permission options in any usergroup. This is my first ever product/add-on so I may well have botched it. The instructions are pretty clear though...

Downloaded the zip file
Unziped the XML files.
Uploaded the bitfields file to my ../includes/xml folder.
Imported the product into vBulletin using the ACP Product Manager.
Set your required permissions in the usergroup manager.

Executed ..../forumpath/admincp/index.php?do=buildbitfields form the command line

Still can't see any permissions in any usergroup in the usergroup manager.

I'm running a vanilla 3.7.1 package with the exception of a custom Logo, color customizations, and minor modifications that I've made to the FORUMHOME template.

http://www.cpowa.org

[SMosher]

woohoo! Got it working.

Thank you.

[VIPER-MAN]

Installed, working great, EZ 1 minute install. Thank you.

[REVHEAD]

Hi

I want to just show certain users the guest stats but nothing else, what should I leave ticked and unticked? allso on my Forums it sais quest visits not Guest visits in the stats box, is this normal?

Thanks in advance.

[Paul M]

You can only control what usergroups can view it, by setting the permissions in the usergroup manager.

[REVHEAD]

For SEO purposes would it be better if I enabled guests ect. ect. to view the guest list? at the moment I only have them set to view the stats.

[Paul M]

Sorry, no idea, Im not an SEO expert.

[BuCwIld]

installed ty

[MCP]

OK, I'm a newbie, so bare with me if this is a dumb question, but I just got this in my Visit Information Called with DO = 'securitytoken' waht does that mean? visit area was ajax

[kofoid]

Great add-on - thanks

[repairman jack]

I'm also having some troubles getting it to work. I installed the bitfields to includes/xml, I installed the mod itself and finally set permissions to administrator. Everything looks to be installed properly but I'm not getting the addition to the "What's Going On?" section. Thoughts?

[sava700]

very impressive and useful tool... installed!

[Paul M]

I'm also having some troubles getting it to work. I installed the bitfields to includes/xml, I installed the mod itself and finally set permissions to administrator. Everything looks to be installed properly but I'm not getting the addition to the "What's Going On?" section. Thoughts?
Impossible to say without admin access to your forum, Id just be guessing.

[Videx]

I can't get it installed on one of my 3.7.2.pl1 boards. Works okay on the other.

Install hangs at:Importing Product, Please Wait...

[:]
Rebuilding Spider CacheChecking for Guest TableCreating Guest TableChecking for Guest Views TableCreating Guest Views TableAdding Permissions
Guest Tracking
Installing : Version 3.7.004 ; Revision 3.14
( Replacing : Version 3.7.004 ; Revision 3.14 )I tried closing the board, uninstalling, repairing tables, reinstalling, uninstalling, etc. Any ideas?

[Paul M]

Looks like its hanging on the php sleep command, try commenting that out (line 260 in the xml).

[Videx]

Thanks. Yes, commenting that line did the trick.

[ErrorLog]

Thank You. ...

[sdsvtdriver]

Very nice, Paul.

Installed.

[shimpaku]

Thanks Paul. Just installed on both of my forums. I clicked on "Marked as Installed" but I have no idea if it took as it gave no verification message.
I'll see how it goes in the next few days.

~Phil

[popowich]

{off topic}

and now a more recent version is available from this site.

How often is this one going to be updated?

It does not have Yahoo in there correctly.

-Raymond

[sdsvtdriver]

Suggestion for future releases:

Make the IP clickable to resolve DNS names like in Who's Online.

[shimpaku]

Suggestion for future releases:

Make the IP clickable to resolve DNS names like in Who's Online.

Yep....my thoughts exactly!

~Phil

[powerful_rogue]

Ive just installed on the latest 3.7 vb and it comes up with this error when I click on the "Total guests that have vistied....."

Database error in vBulletin 3.7.2:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, August 29th 2008 @ 12:35:16 AM
Error Date : Friday, August 29th 2008 @ 12:35:16 AM
Script : http://www.thefreebiefinder.co.uk/forum/misc.php?do=guestlist&type=Visitors
Referrer : http://www.thefreebiefinder.co.uk/forum/index.php
IP Address : 80.4.18.212
Username : Dave
Classname : vb_database
MySQL Version : 4.1.20

[x-death]

thanks

[zelnik]

Brilliant mod, installed and marked as installed..

I would like to echo what previous people have said and having the ip clickable to resolve it would be great!

[powerful_rogue]

Ive just installed on the latest 3.7 vb and it comes up with this error when I click on the "Total guests that have vistied....."

Database error in vBulletin 3.7.2:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, August 29th 2008 @ 12:35:16 AM
Error Date : Friday, August 29th 2008 @ 12:35:16 AM
Script : http://www.thefreebiefinder.co.uk/forum/misc.php?do=guestlist&type=Visitors
Referrer : http://www.thefreebiefinder.co.uk/forum/index.php
IP Address : 80.4.18.212
Username : Dave
Classname : vb_database
MySQL Version : 4.1.20

Any help greatly appreciated

[powerful_rogue]

Still getting the same error, not quite sure what to do.

[Paul M]

Fix the collations on your tables, or upgrade mysql.

[ArnyVee]

{off topic}



How often is this one going to be updated?

It does not have Yahoo in there correctly.

-Raymond

FYI, the spider list was just updated today. :D

[e7saas]

Excellent work

Thank you

[PHILLYFAN]

***Installed***

Paul M, I prob have just about all ur mods and Hasaans installed. You guys do great work. THANK YOU

[powerful_rogue]

Fix the collations on your tables, or upgrade mysql.

Paul,

What do I need to do to fix them?

[Paul M]

Sorry, I cant provide that level of support.

[Videx]

Paul,

What do I need to do to fix them?The first step would be to search here and at vb.com for the error phrase. I did, and it leads me to this thread:
http://www.vbulletin.com/forum/showthread.php?t=124003

[powerful_rogue]

Thanks for everyones help.
Managed to get it sorted.

[Gimmick]

I have installed this mod, thanks, I am a super n00b and got this working and I updated my spider.xml

Do I need to rebuild the bitfield to get it reading the newest spider.xml or is it fine from the off?

[Paul M]

Fine from the off, its not a bitfield file.

[xoutlawz00x]

how do i update my spider list??? i have the xml file but dont know where to put it

[xoutlawz00x]

If you have set the "Enable Spider Display" to yes, the file includes/xml/spiders_vbulletin.xml is used to determine how a spider is identified.

The file looks similar to this:

k got it thanks

[DungBeetle]

first sorry for my english.
Thanks for great mod. I'm wonder its possible to integrate to view country flags

[Paul M]

Dont really understand what you mean, where do countries fit into this ?

[DungBeetle]

Dont really understand what you mean, where do countries fit into this ?

Currently I have two mods for displaying " who is online"
1. GLA - Geographic Location Awareness for vBulletin (http://www.vbulletin.org/forum/showthread.php?t=151601&highlight=country+flag)
2.Country Display for Who's Online (http://www.vbulletin.org/forum/showthread.php?t=151600)
This two mods are working together so I wonder its possible to implement some mode to display the Country name or flags for the track guest visit, because will be nice to see from where was the guest is come.

Thanks for your support.

[digitalnorte]

Great Product ! INSTALLED

[ritunb]

Help!! I'm getting 'Invalid File' when I try to import the bitfield_track-guests.xml file in ACP. I've vBulletin® v3.7.3 Patch Level 1.

[Paul M]

Why are you trying to import that file ?

Please read the instructions in the main post.

[Floris]

Nice stuff, installed it for our admins on wetalk.tv

[Dominiek]

Installed and operational.
Good stuff :up:

[sensimilla]

Somehow I get this error on all my forums since last week.


INSERT INTO guestviews
(guestid, forumid, threadid, dateline, ipaddress)
VALUES
('58b22a6c9f1488d7713ad3b68510d6d0', 0, 0, 1222960016, '81.182.xx.xx');

MySQL Error : Got error 127 from storage engine

Any ideas what could cause this, Ive tried to reinstall it and still the same thing.

[Paul M]

Error 127 is basically a crashed table, try running a repair on it.

Alternatively, uninstall the mod, delete the guestviews table and then re-install - that will recreate the table.

[TsirhCitna]

Is it possible to make it so that duplicate IP's don't get multiple entries?

Also, is there anyway to track visits to the photo album pages? As far as I can tell it just says "picture."

[Paul M]

Is it possible to make it so that duplicate IP's don't get multiple entries?No, they should be recorded.

Also, is there anyway to track visits to the photo album pages? As far as I can tell it just says "picture."Possibly in the future, if I have time. I dont use photo albums, or the social networking features, so they are not included atm

[TsirhCitna]

No, they should be recorded.
Why? As it stands 1 person views 40 pages and it's displayed as 40 visitors. It's very misleading.

[Paul M]

No, it isnt. I suggest you check again, more than just the IP is involved in recognising a visitor.

[TsirhCitna]

How is that this can show 1200+ visitors excluding spiders and google analytics will show 300 pageviews?

[Paul M]

I cannot comment on what Google Analytics does.

[ProAzn]

Ok the guest list is too long.. How do I make pages instead of one long list? I'm in vboptions--->guest tracking. There are 2 settings..

Guest List Row Limit
The maximum number of rows to display on the guest list screen.
set as 1000


Guest Views Row Limit
The maximum number of rows to display on the guest views screen.
set as 500

What do i have to change to make it paginate??

[ProAzn]

Ok the guest list is too long.. How do I make pages instead of one long list? I'm in vboptions--->guest tracking. There are 2 settings..

Guest List Row Limit
The maximum number of rows to display on the guest list screen.
set as 1000


Guest Views Row Limit
The maximum number of rows to display on the guest views screen.
set as 500

What do i have to change to make it paginate??

OK i changed guest row limit to 100, now the list is 100 rows but does not paginate over 100 lines.. anyone help??

Guest view row limit is still at 500. ..what is the difference between guest list row limit and guest views row limit??

[Paul M]

They are two seperate views, one is the list of all guests, the other is all the views a single guest has made. There is no paging in this mod, whatever you set the limits too.

[fodvapor]

Great mod...thanks for sharing !

[TitanJeff]

I'm having a problem and thought I would ask...

The hack worked perfectly until earlier this week when I was hacked. In the process of repairing the server, I went ahead and upgraded vB from 3.7 to 3.73. Now, the guest tracking doesn't show up on forumhome though all settings are the same as before the hack.

I uninstalled then reinstalled earlier today and it did show up on forumhome but was followed with a database error. Now, it's not showing up again.

Any ideas?

[Paul M]

Did you remember to copy the bitfields file to the XML folder when you upgraded ?

[TitanJeff]

I did. I should have copied the database error to post here. I may try to recreate the error.

[glennybee]

Not sure how to word this one lol...

When you access the forum you are a visitor...until you log in then you are a member.

I have the 'track visitors' mod installed and I was wondering, does the visitors count change when you eventually log in, i.e. -1.

[Paul M]

No, the visitor count will not decrease, you were a valid visitor at the time.

[RS25com]

Disregard, it's working fine. :cool:

[Red-Devil]

thanks - installed very useful

[geevest.com]

hello paul.
how to modif this guest visit with member visit.
so in forum home we have :
Total members that have visited the forum today: 2,087 guest: 4,982

thx

[RS25com]

I believe I have found a bug:

Total guests that have visited the forum today: 135

The most guests online in one day was 220, Today.
Visitors (135)
How can the most guest be 220 "today" when today I only have 135? I believe that should say "Yesterday" (in red).

[lovechandigarh]

Excellent.
Paul, can you change the words: Note that by default no permissions are given, you must set them. to Note that by default no usergroup permissions are given, you must set them.
It clarifies a bit for new users...
Meanwhile, I just installed it and enjoying to see it work on www.lovechandigarh.com Love Chandigarh

[Paul M]

Seems reasonable, changed.

[Paul M]

I believe I have found a bug:


How can the most guest be 220 "today" when today I only have 135? I believe that should say "Yesterday" (in red).

Possibly, but if there is such a bug then its in the standard vbdate() function, as that is what creates that timestamp. The code is identical to that used by default vb for the "Currently Active Users" timestamp. I think its just related to members having different timezones.

[geevest.com]

hello paul.
how to modif this guest visit with member visit.
so in forum home we have :
Total members that have visited the forum today: 2,087 guest: 4,982

thx

[Paul M]

Sorry, they are seperate mods, such changes are beyond the support I can provide.

[jerx]

I have a problem with editing posts, when this add-on is turned on. I get an error message which says 'maxloggedin'. I have seen two other posts where a similar problem has been reported, one in this thread and the other in your Member Tracking Mod. Other people don' t seem to have this problem. What could be the reason for this problem?

[Paul M]

No idea, and since I cannot re-create it, there is not much I can do.

[wanno]

Great work!

I would like to ask you if it is possible to have this on my home:
Currently Active Users: 20 (8 members and 12 guests) - Total Visitors Today (or last 24 hours): {param}

The reason is that I do not want to let all members see the spiders, only the administrator.
If I uncheck the spiders feature in VBA option the administrator won't see them either

[munnakv]

Thanks Paul. Installed.

[GlamRockTalk]

This mod ROCKS! :D

Thanks Paul

[Barteh]

Nice, installed :)

Is it possible for identified spiders from vbulletin_spiders.xml to be logged separately?
Or, to rephrase that, I don't care that google and yahoo periodically check every public page there is, and not logging them would keep the database size low even with a longer history period.

And a bit of a feature request: one of the first 'visitors' turned out to be a forum user who was simply logged out... would it be possible in a future version, to include an IP query (like the native one in the adminCP) showing matching registered forum users in a column?

[jerx]

I have one question regarding the guest count. Although guests cannot do very much on our site (can only read forum), we have 3 times the amount of guests than the amount of registered users. When does the guest count increase?

1. user visits as guest, logs in and leaves the site. Counted or not?
2. user visits as guest, logs in, logs out and leaves the site. Counted or not? If yes, how many times?
3. user visits as registered user, logs out and leaves the site. Counted or not?

[Paul M]

1. Yes.
2. Yes, they only count as one visitor.
3. I dont believe so, but not 100% sure.

[jerx]

1. Yes.
2. Yes, they only count as one visitor.
3. I dont believe so, but not 100% sure.

1 and 2 is what I have expected, but I thought that the count would be increased in situation 3, too.

Wouldn' t it be better to substract the number of registered user, who have visited the forum (if your other mod is also installed of course)? Ok, this would give you false numbers for those who visit as registered member without ever logging out. Maybe only substract half of the amount.

[Paul M]

Nope, it would not be better to subtract anything.

If someone visits a page, not logged in, then they are a visitor, simple as that. I see no reason to start complicating matters and start fudging things.

JFYI, in my experience, few members ever actually log out once they have logged in, so they never visit the site as a guest.

[Barteh]

Some people have very restrictive cookie settings (keep until the browser closes) or regularly wipe them manually, but you're probably right in that this is a small percentage.

Any chance you could separate recognised spiders from other IPs where the log cut-off date is concerned? The reason I've started using your mod is for antispam purposes, to see if any unrecognised crawlers are poking around our forums and I bet yahoo's slurp spider alone will end up producing half the log size. Would help if you could only save the last 24 hours of known spider IPs (for the display) and log everything elsefor a longer period.

[Paul M]

Sorry, but I dont plan any changes to this other than I may one day collect the referer (and that would be in the 3.8 or 4.0 version).

[LG Alex]

Screenshots? please

[caliman]

Possibly, but if there is such a bug then its in the standard vbdate() function, as that is what creates that timestamp. The code is identical to that used by default vb for the "Currently Active Users" timestamp. I think its just related to members having different timezones.

I am having this issue with total guests today as well.
Something is off. Perhaps it is the timezones. Any way to set the timezone or something?

[KHALIK]

Product installation does not work with 3.8.0 RC1


will there be a release for 3.8.0 RC1 ?

[Paul M]

Yes.

[AWJunkies]

I had it installed on one of my sites to test it was working nice had over 1000 guests in 24 hour period on average.

Now I had it installed on another site same server and its guests where only at 250 average.

Both have latest update XML for spiders etc.

1000 guests seemed to work perfect from what I could tell except the site with only 250 guests has on average of 20 spiders on at all times and over 15 guests at all times and over 50 users constant all day everyday. So something is going on really the two sites should be flipped according to site stats etc.

Now here is tricky part. The site with 1000 guests I 301 header safe redirected to another site and traffic went from 1000 average to 250 average same as the other site like it is hitting a peak wall now.

So have few questions #1 is how does this mod handle safe redirects of spiders and bots and so on will it register it when site still shows X instead of Y.

Meaning this www.yourdomain.com is original site then safe it to www.yourdomain2.com so if someone goes to yourdomain it will stay URL wise to it but be yourdomain2 if that makes any sense.

Second question is have you installed this more then once on a server NOT the same install of vB have to make that clear multiple domains.

Sorry I am not familiar with all this stats and spiders and so on come from an age before there was such things :).

[KHALIK]

The following dependencies were not met:

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


Unable to install on 3.8.0 RC1

[momo2]

I downloaded more spider xml from vb.com, now what do i do with it ?

[pete_brady]

I have a problem with editing posts, when this add-on is turned on. I get an error message which says 'maxloggedin'. I have seen two other posts where a similar problem has been reported, one in this thread and the other in your Member Tracking Mod. Other people don' t seem to have this problem. What could be the reason for this problem?

No idea, and since I cannot re-create it, there is not much I can do.

I got that same error as soon as i configured & enabled memcache in vB config. disabling vB_Datastore_Memcache makes the error go away.

[ecky]

installed, thank you

[popowich]

For those that like to know, the spiders file was updated recently on 12/16.

-Raymond

[shlomot]

Just upload and overwrite the previous spiders_vbulletin.xml file in your /includes/xml folder.

I downloaded more spider xml from vb.com, now what do i do with it ?