Track Guest Visits

[Paul M]

As of 24 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 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 a previous version, delete the old bitfield 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/forum/general/managing-your-community/361239-ws-spiders-list-for-updated-vbulletin-spiders-vbulletin-xml-files).

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

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 bug in attachment viewing links.

[SnowBot]

hhmm great idea but i got an error

Database error in vBulletin 3.8.0:
Invalid SQL:
CREATE TABLE guest
(
guestid varchar(32) NOT NULL default '',
hostip varchar(15) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
lastactive int(10) unsigned NOT NULL default 0,
spider varchar(32) NOT NULL default '',
script varchar(20) NOT NULL default '',
rdata text NOT NULL,
PRIMARY KEY (guestid),
KEY ipaddress (ipaddress),
KEY lastactive (lastactive)
);
MySQL Error : Key column 'ipaddress' doesn't exist in table
Error Number : 1072
Request Date : Friday, January 9th 2009 @ 04:31:44 PM
Error Date : Friday, January 9th 2009 @ 04:31:44 PM
Script : http://www.socialspace.co.uk/forum/admincp/plugin.php?do=productimport
Referrer : http://www.socialspace.co.uk/forum/admincp/plugin.php?do=productadd
IP Address :
Username : Snowy
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

[eh9 daddy]

When i try to install the product, it shows this error:


Invalid SQL:

CREATE TABLE guest
(
guestid varchar(32) NOT NULL default '',
hostip varchar(15) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
lastactive int(10) unsigned NOT NULL default 0,
spider varchar(32) NOT NULL default '',
script varchar(20) NOT NULL default '',
rdata text NOT NULL,
PRIMARY KEY (guestid),
KEY ipaddress (ipaddress),
KEY lastactive (lastactive)
);

MySQL-Fehler : Key column 'ipaddress' doesn't exist in table
Fehler-Nr. : 1072
Skript : http://www.domain.de/admincp/plugin.php?do=productimport
Referrer : http://www.domain.de/admincp/plugin.php?do=productadd
Klassenname : vB_Database
MySQL-Version : 5.0.51a-community-log

[KEKforce]

same error here

[Vaupell]

Same error, dosent work.

[Idawg]

Same here

[-=Leb=-]

Sweet, thx for the update.
Hey guys, i didn't get any error. I just updated it from 3.7 to 3.8

[digicom]

Same error here aswell

[steven s]

Sweet, thx for the update.
Hey guys, i didn't get any error. I just updated it from 3.7 to 3.8Upgrade worked here too. Thanks! :up:

[Paul M]

Hmm, ok, I guess the sql has an error, i'll have a look in a minute. :)

[Paul M]

Try it now (3.8.002)

[readjono]

Thank you kind sir. Working nicely in v3.8. I've had mine coded by a geek on here so it flows a bit better :)

[eh9 daddy]

thanks, works fine now

[dt_truck11]

whats the template hook that should be in inserted, because it doesnt seem to have been inserted automatically.

[ijob]

Hi,

The hack is installed but it doesn't display on the index page and there are no options in the usergroup manager?

I had the previous vbersion with no problems....

[readjono]

Hi,

The hack is installed but it doesn't display on the index page and there are no options in the usergroup manager?

I had the previous vbersion with no problems....

I had to edit the usergroup managers for it to appear :)

[RedDevil]

Just upgraded to 3.8 and installed, it seems not to be working.

There is no forum display, however the previous version worked fine.

1. I uploaded the bitfield file to includes/xml deleting the .37 file also
2. Imported product using admin cp using overwrite / it auto uninstalled the old version
3. Set group 6 administrators permissions to all yes.
4. reviewed settings in VB options menu

all seems to be set correctly, yet no display, and idea what the problem could be.

I have member tracking installed this is ok.

[RedDevil]

reverted to the older version for now.

[Paul M]

Sorry, but I cannot guess at problems, I would need ftp/acp access to see what was going on.

[RedDevil]

Sorry, but I cannot guess at problems, I would need ftp/acp access to see what was going on.


Pm me what you need then i can send you the access details.

[Voltar]

I just installed this on a new board, and each time I go to set the usergroup permissions it creates a new usergroup instead of updating the usergroup that I try to edit, and neither retain the set permissions. Any ideas?

Edit: Scratch that, disabled all plugins, then disabled the plugin system globally and still does it.

[digicom]

Thanks Paul Upgraded And Workin Great Now Much Apprciated :up:

[christon26]

Thank you kind sir. Working nicely in v3.8. I've had mine coded by a geek on here so it flows a bit better :)

readjono, would you mind pointing me in the direction of your 'geek'? LOL I would like to have mine display as yours does with just the line above the stats bit :)

NM figured it out lol

[christon26]

Thanx Paul! I've installed several of your mods :D

[EricPSF]

Thanks Paul! Installed and hv no problems right now. =)

[FreshFroot]

is there anything wrong with the 3.7 version. I'm using it on 3.8 and it seems to be working fine.

[Paul M]

No, there is nothing wrong with it, just minor differences.

[TimberFloorAu]

Nominated for MOTM

[-=Leb=-]

Same error here paul, i can't even uninstall it. I get database error on everything. Like couldn't read PM or use usercp, and also i coun't vew members profile.

OK i turned off the forum so i could uninstall it. Now i can acccess everything like normal.

I hope you update it soon lol

[Paul M]

Same error here paul, i can't even uninstall it. I get database error on everything. Like couldn't read PM or use usercp, and also i coun't vew members profile.

OK i turned off the forum so i could uninstall it. Now i can acccess everything like normal.

I hope you update it soon lol

Huh ?

Same error as what exactly ?

This is working fine for me and I see no other error reports. Nothing will be updated as you have not provided any information on your "error".

--- Edit ---

NM, seen you posted in another thread, it would have helped if you had linked to that or just posted in one thread.

Your problem is server related.

[-=Leb=-]

Alright paul sorry for the trouble, here i copied the error .

I contacted the hosting account company and they had error on the SQL but it fixed now.

It seems like when i updated the mod , for some reason the guest got errased .

Anyway, i reintalled the mod and it created a new guest.

One more time , sorry for the trouble paul.



Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT * FROM guest FORCE INDEX (lastactive) WHERE lastactive > 1232132646;

MySQL Error : Table 'rerwadmin.guest' doesn't exist
Error Number : 1146
Request Date : Saturday, January 17th 2009 @ 12:04:06 PM
Error Date : Saturday, January 17th 2009 @ 12:04:07 PM
Script : http://firewallcs.net/forums/index.php
Referrer : http://firewallcs.net/forums/admincp/index.php?do=head
IP Address : 213.114.186.180
Username : -=Leb=-
Classname : vB_Database
MySQL Version : 5.0.67-log

[MV Blackie]

I upgraded from 3.7 to 3.8, did the track guest update, but it does not show
usergroups are edited and mod is active, but nothing show up ...
went back to the 3.7 version ....

[Paul M]

You prob have a customised forumhome template, missing the vb template hooks.

[Vaupell]

tx for the update, top notch. (thumbs up thingy) :D

[Armyqt]

This is not showing up at all. What do I need to update in the usergroups?

[bullet07]

Another great addon thanks paul :)

[Jon Tolzien]

nice, I just realized that this guest, was a crawler bot.

[jesus likes pie]

If a guest registers, does he still count as a guest?

Just wondering.

[Paul M]

If they visit as a guest then yes.

[lgnd]

Thank You! Installed!

[hescominsoon]

I got a similar database error..i wound up having to uninstall it AND my vbull blog 2.x version because the blog was also hosed. I am reinstalling the latest blog and i'll try this again.

[Merjawy]

Thanks

[harlita]

Working great, easy install and admins are cheering for you.
Nominating for MOTM.

Thanks again, PaulM for another excellent mod.

[japancars]

I installed the mod and made the permissens in the usergroups manager...
But i cant see anythin on the index page... what have i done wrong?
I use vb 3.8.1

[Paul M]

Sorry, but I dont have special magic powers - I could only guess at what you have done wrong. Most likely you need to read the brown note about template hooks.

[harlita]

I installed the mod and made the permissens in the usergroups manager...
But i cant see anythin on the index page... what have i done wrong?
I use vb 3.8.1


So the section doesn't even show up? It doesn't stand out, it looks very neat and natural, right below the list of folks online right now as you can see here: http://i166.photobucket.com/albums/u101/gbfc/harli/visitor.jpg
Very neat and tidy.

Once it shows up for you, there is a noted delay after initial installation before you'll see any data showing up for the Visitors / Spiders / Bots, but that's of course due to the fact it's a new install, so there's no data to display yet.

Is the box not showing up at all, though? I'm running 3.8.0 as well, but not 3.8.1 - though I can't imagine a non-major release would adversely affect the code PaulM gave us to the point it doesn't even display.. :S

[Welshy2008]

Hi Paul,

I have installed it to the tee (Even removed your old hack on th 3.6.8) but I am getting no box. :(

I am still pretty new to this, so, would you (or anyone else) mind explaining what is meant by what you say here, Please? Where & how would I check for it, what is it exactly that I am looking for? And how do I overcome it Please? I am running 3.8.1.

You prob have a customised forumhome template, missing the vb template hooks.

I know that you are very busy - But I would appreciate some help. :)

[Paul M]

Compare your template to the vb default, you will see the missing template hook(s) that you must add.

[Welshy2008]

Thanks for your reply, Paul. I will check it later. :)

[rizelim]

forumhome_wgo_pos2

Where to it will combine. thanks!

[Welshy2008]

Hi Paul,

I have installed it to the tee (Even removed your old hack on th 3.6.8) but I am getting no box. :(

I am still pretty new to this, so, would you (or anyone else) mind explaining what is meant by what you say here, Please? Where & how would I check for it, what is it exactly that I am looking for? And how do I overcome it Please? I am running 3.8.1.



I know that you are very busy - But I would appreciate some help. :)

Compare your template to the vb default, you will see the missing template hook(s) that you must add.

Thanks for your reply, Paul. I will check it later. :)



Hi Paul,

It is now showing for me Mate. I have searched my "FORUMHOME" and the 'forumhome_wgo_pos2' is there as follows...

</div>

</td>
</tr>
</tbody>
<!-- end logged-in users -->
</if>
$template_hook[forumhome_wgo_pos2]
<tr>

Any Ideas, Please?

[Welshy2008]

Cancel the above post, Paul. I un-installed and re-installed them and it works great.

Thank You.

[Tophon]

Thanks Paul, great add-on!

Installed

[Dave-M]

Hi Paul,

Thanks for this, I have been using the older version for 3.7 plus the "Members who have visited" add on.

I've updated to 3.8.1 from 3.7.4 and now neither of the add ons will display.

Having read through this thread, I've made sure that I have the latest version of my template and it does indeed contain the required hook (see piccy below). The add ons seem to have installed correctly and are enabled, but I cant see them on the forumhome page.

I've reinstalled them, but still no luck.

Would you have any idea why this may not be working please? If you need any more details, please say.

Thanks :)

Dave

Edit: Fixed, changed to a different template, reinstalled the add on and then changed the template back and it's ok now...weird!

[reverse1312]

changed to a different template, reinstalled the add on and then changed the template back and it's ok now...weird!

Hello Dave,

I have the same problem

Wonder what you mean with "changed to a different template" and "changed the template back"

Could you just explain a bit more please ?:confused:

Thanks

EDIT : After having once more uploaded the "bitfield xml file" - you must erase the existent one, everyting is running fine again :-)

[Phobos49]

Great!!! Thanks!

I have a problem:
After editing the phrase [trg_visitors] the whole plugin stops working!
I would like to change "Visitors" into "Heutige Gäste". How can I do this without crashin' the PlugIn?
The problem seems to be the blank between the 2 words!

[Paul M]

I have changed it to that on my test forum and it seems to be working fine, what do you mean by "crashing" ?

[Phobos49]

I have changed it to that on my test forum and it seems to be working fine, what do you mean by "crashing" ?

"crashing" means that if you click on the number of guests, the displayed guest tracking page has no entrys.
I think I figured out the problem: the blank between the two words "Heutige G?ste" appears as "%20" in the link to misc.php

But don't worry about the problem! I now use the single word "G?ste" instead of "Heutige G?ste" and everything works fine.

[Paul M]

It works fine for me, with the space :)

[Rakehel]

This is the 4th(?) version of this mod that I've used and it has always worked well and been a favorite. For some reason this version isn't functioning properly. The appropriate display with a Guest count/link shows on the main board but the individual spiders are no longer listed. I can click the link for the generated guest count and review all of the pertinent information, as before.

I'm running vB v3.8.1 w/PL1. I began the Track Guests upgrade after moving to a new server about two weeks ago. We've been using a dedicated I.P. longer than that without issues in displaying individual spiders.

-I've uninstalled the old version, removed the bitfield.
-Uploaded the new bitfield.
-Imported the product.
-Set permissions.
-Verified the hook location in defult and customized styles.
-Made certain the mod was activated in vB ACP options and Plug-In mgr.
-Double-checked spider detection in WOL. (ACP options)
-Uninstalled product and removed bitfield from server a few times over 2-3 days. (Reinstalled with vB default style activated too.)
-Verified chmodding.
-Verfied content and re-uploaded vbulletin_spider.xml list.
-Repaired SQL tables.

What am I missing here? The most recent reinstall has been in place for over 12 hours, spiders are visiting but not displayed individually and the total count keeps growing. Do I need to wait longer? Run the query to clear the WOL cache?

[Paul M]

I cannot see anything you have missed.

[Oliver G]

HI
I have just installed but when I try to edit permissions they are not there. Any ideas.

[paul41598]

This mod is awesome! Nice Paul!

So one question, is it basically a log? Like could I go back a week and look at the guest visits for a given day? Would I do this from the frontend or backend?

[RedHacker]

The xml from Spiders Definition what doing?

[Paul M]

So one question, is it basically a log? Like could I go back a week and look at the guest visits for a given day? Would I do this from the frontend or backend?
As it says ;

* 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).

[RedHacker]

The xml from Spiders Definition what doing?

Do know anyone...?

[pneumothorax]

It would be great if there is an option to change the log order i.e. by IP, visit area and so on.;)
Great mod and thanx for it!:)

[Niner1000RR]

Installed, but new so still trying to figure out how to get it to work :)

[pneumothorax]

Niner1000RR, you must set the usergroup permissions for the group you want to have access to these logs. After that the group members will see it at the bottom of the forum main page, just above the statistics.

[Niner1000RR]

Ah! Got it, I swear I looked before and didn't see it, but I do! DONE!

THANKS

[pneumothorax]

A few days ago I've banned an A class network and everything was fine until today, when I saw high activity from this particular network in the log. Is that normal?
And also an you tell me if "Logged" means that the visitor is logged in the forum with a username and pass?
Thank you!

[Farman]

I was facing a problem, when I installed new template it was not showing there, and later I figured it out.

If everything is fine there in Usergroups and Admincp > VB Options > Guest Tracking than just add $template_hook[forumhome_wgo_pos2] to the "ForumHome" template, and It will be shown.

[Paul M]

A few days ago I've banned an A class network and everything was fine until today, when I saw high activity from this particular network in the log. Is that normal?
Yes. When you ban an IP in vbulletin, it can still connect, all that happens is they get redirected to a no access page.


And also an you tell me if "Logged" means that the visitor is logged in the forum with a username and pass?
No, it means how many times they have been logged visiting certain areas of the site (which can be listed if you have that permission).

[Orakk]

My favorite mod Paul..

I have a request - Back at the ranch we make a game out of banning bots and I'm curious if some kind of botometer could be run off this mod showing how many bots have been captured so far.

[Kadi]

I read through all the posts, checked and rechecked but I can't see the permissions.

:confused:

[lm3a.net]

Thanks bro ..

[SirHappy]

thx Paul. works in 3.8.3.

[Brathamike]

unable to install i get invalid error

am i supposed to install this from admin - manage products - add/import product?

is this correct? if now how do you install this

thanks

[Brathamike]

I was uploading wrong file thanks for the file

[Brathamike]

How do i install spiders_vbulletin that you offer? do i need to FTO this in my includes - xml file? if not how do you install that script

thanks

[joedirt]

i installed this on Version 3.8.3 and everything is ok but the time how can you set the time on this mod its showing

The most guests online over 24 hours was 0, 12-31-1969 at 07:00 PM.

is there anyway to fix this problem?

thanks

[mattwmc2001]

Sweet! Got it working!

I was wondering about this. Nice one!

[Paul M]

i installed this on Version 3.8.3 and everything is ok but the time how can you set the time on this mod its showing

The most guests online over 24 hours was 0, 12-31-1969 at 07:00 PM.


is there anyway to fix this problem?

thanks
That will update once a guest visits.

[The Realist]

Installed in 3.8 working fine.

Thanks.

[BigDog56]

Question. I have a problem with a troll that was banned. She keeps coming back in under web shared proxies. (She has registered under fake ip's over 50 times now.) Is there a way to tell (Like site meter, which I had to uninstall due to the tracking cookies they are now putting on everyone's pc.) if it's the same pc as a guest using different proxies? In other words, once I get a "fingerprint" of her pc, be able to tell if it's her registering again.

[steven s]

Is it possible to have a separate page that shows me
time ip, etc for Member Registration attempt for only?

[Kahuna900]

Question. I have a problem with a troll that was banned. She keeps coming back in under web shared proxies. (She has registered under fake ip's over 50 times now.) Is there a way to tell (Like site meter, which I had to uninstall due to the tracking cookies they are now putting on everyone's pc.) if it's the same pc as a guest using different proxies? In other words, once I get a "fingerprint" of her pc, be able to tell if it's her registering again.I have been using this plug-in for a while now and it seems to help if they are using the same machine to login.

https://vborg.vbsupport.ru/showthread.php?t=183268

[chick]

Excellent, thank you this works great. Again, much appreciation for this mod.

[MarkoP]

This is probably going to be a goofy question but I just need to make sure...where it says this:

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

Is that taken care of automatically or do I need to do it manually somewhere?

Thanks!

[Paul M]

Its a setting in the options.

[Brathamike]

fixed

thank u

[Madlike]

<i><body style="margin:1px"></i>

This code crashed my fixed style. When i delete "margin:1px", it's OK. Why "margin:1px" ?

[Paul M]

Why not. Its just a margin, nothing to worry about.

[cfww2]

Works great. Thank you Paul, your add-ons are excellent and making the life if a newbie so much easier

[MagicThemeParks]

Great work again Paul! :up:

[surfer2124]

Works great

Thanks

[Silencer Groans]

I have a version number 3.8.4

I have also vBSEO

To convert the links

When you install the product that you throw depends Forum

Forum works .. When you shut down one of the producers Track Guest Visits or vBSEO

There is a conflict between the two

I hope that you have a solution to this problem

[Paul M]

I have no idea what your actually reporting as a problem, but I run vbseo and this mod without any issues.

[VonDoom]

Thanks for this great hack Paul, i love all these statistical mods.

[SamirDarji]

Awesome mod. Noting to remind myself to test it.

[Skydiver10]

Works fine...accept...how do you get the users names to show instead of a number?

Example: Visitors (9) ....I want the users names to show instead.

I want it to show the Users names that have already signed in and left.

How do I make it show the users names like I have seen on other forums?

Thanks for this mod! Can you help with with the above question?

[SamirDarji]

When you refer to user names, do you refer to spider names? These are unregistered visitors. They don't have user names.

[Paul M]

Example: Visitors (9) ....I want the users names to show instead.
As posted above, these are guests, they dont have usernames.

[Skydiver10]

Hi there SamirDarji,

I did not mention anything about spiders, and everyone here knows that spiders do not have user names.:confused:

Do you know what a users is? :eek:

I'm looking for someone to help answer my question in my previous post. :rolleyes:

A user is someone who is registered,
obviously a spider does not have a user name unless you let them register and they spam you to death. :rolleyes:

Back to my original question...:)...how do I show MY users names (REGISTERED) on :
"Total guests that have visited the forum in the last 24 hours"

Any help would be greatly appreciated.

[SamirDarji]

vbulletin allows certain spiders that are recognized to be listed as such, hence a "user name." I'm fully aware of what a user name is. I don't think you're fully aware of what this modification does. It will not do what you want. This one by Paul will:
https://vborg.vbsupport.ru/showthread.php?t=196458

Speaking of this mod. Paul, how well do these two mods play together? Are there any issues?

[Paul M]

I'm looking for someone to help answer my question in my previous post. :rolleyes:

A user is someone who is registered,
obviously a spider does not have a user name unless you let them register and they spam you to death. :rolleyes:

Back to my original question...:)...how do I show MY users names (REGISTERED) on :
"Total guests that have visited the forum in the last 24 hours"

Any help would be greatly appreciated.
If you want help then I suggest you adopt a better attitude in my modification threads, thanks :)

This modification is for Guests, hence its name. If you want to list members, then you need a different modification (linked above). This is not what you originally asked,

Speaking of this mod. Paul, how well do these two mods play together? Are there any issues?
They work just fine. :)

[SamirDarji]

Thank you Paul.

I noticed someone created a vbadvanced cmps module for the other mod, which I am using. Do you know of a module that exists for this one?

[Skydiver10]

If you want help then I suggest you adopt a better attitude in my modification threads, thanks :)

Paul,

Thanks for your help and thanks for the mod :) Samir thanks for the link. :)I think we had a communication breakdown with the mod I'm asking about. I thought that the mod was able to show my users names that have visited in the last 24 hours, I have now realized that this mod does not do that, thanks for the help.

I installed the wrong mod and asked Samir about his knowledge. That's no reason to jump to conclusions and perceive me to adopting a better attitude. :) Sometimes asking people questions directly prevents additional posts that are unnecessary when trying to get the correct answers about a mod (miss-communication).

I'm just trying to communicate to you all in finding answers, which can be difficult when slinging back and forth questions and answers that are misinterpreted. Is it OK to ask if someone knows what a user is, if I'm thinking that they think a spider has a user name? And I believe that is what I was asking, no need to follow your miss-perception of me.

I have read your "Preventing Hacking/DDoS Attempts"...my opinion - the best post on this entire forum.

My forum was hacked earlier this weak after being live for just one and half months.
An invisible malicious code was injected into the forums home template, which directed it to some turkish site. The IP's came from Japan. It took me two days to fix this and I could not find the code anywhere. After combing this VB forum I found the Fix-it template mod (which is the second best post or mod here). Hackers, animated malicious software, etc. should all be terminated out of the cyber world, I wish I can make these morons pay for all of the labor and slave they cost us.

So what if I install your other mod https://vborg.vbsupport.ru/showthread.php?t=196458 as well as keep the same mod on my board that I already installed, would both show, and with no problems?

Thank you both for your help, greatly appreciated....

[Paul M]

So what if I install your other mod https://vborg.vbsupport.ru/showthread.php?t=196458 as well as keep the same mod on my board that I already installed, would both show, and with no problems?

Thank you both for your help, greatly appreciated....
As answered above, yes, you can run both without any issues.

[Paul M]

Thank you Paul.

I noticed someone created a vbadvanced cmps module for the other mod, which I am using. Do you know of a module that exists for this one?
Nope, I dont know if one exists or not, best to ask on the vba forum.

[Skydiver10]

Hey Paul... I will install and run both then, by your recommendation, thank you.

Is it overkill to have both? By the way, a high profile spammer tried to register and I used your track guests mod to grab his IP and the user name he used, I then dropped his IP in my htaccess file.

Sorry if I gave you too much information but it can be frustrating when hackers attack 24/7/365 with automated software, and you just want and need help from people who have already been through this, like you. What mods do you use, and have you been able to defend them off with no damage since you have developed a working plan?

Thank you again for all of your mods. :) I have a question about the firewall mod you developed. I read the entire discussion on it, and I'm still wondering if I should install it on my board. Does it need to be completely redone or fixed?

What other types of firewall mods are available for VB?

[SamirDarji]

Nope, I dont know if one exists or not, best to ask on the vba forum.Thank you Paul. I've asked and searched over there with no avail. Hopefully someone will make one. I'm not a programmer, but I'll try to make one too.

[SamirDarji]

What other types of firewall mods are available for VB?I"m not sure how much help this would be, but try this:
https://vborg.vbsupport.ru/showthread.php?t=176481

[Skydiver10]

Thanks, I think that is the one I was talking about, not sure?:confused: I thought Paul had a better one but maybe I'm mistaken...the stopforumspam one seems to have issues.

[Paul M]

I have never done a firewall mod.

[Classico]

Hi!!!

Does this work in VB4.0? ;)

Thanks

[JHC]

Hi Paul, thanks for making a great mod.

I have a couple questions, and I hope it makes sense.

1) How can I keep a permanent log of these guest visits?
I have it set to rolling 24 hour & clean up period at 365, but it's wiping it out after a couple days.

2) Is there a file somewhere I could download the list of guest visits?
Maybe FTP in and get it or something?

Thanks in advance!

[Paul M]

1. If you have the clean up set to 365 then it will keep a years worth, however it wont display them as thats limited to 500 (or 1000 ?) in the settings.

2. They are stored in a database, so no, you cannot download them via FTP.

A word of warning - a years worth of data could be a huge amount of data to keep, esp if you are getting a few hundred per day.

[JHC]

1. If you have the clean up set to 365 then it will keep a years worth, however it wont display them as thats limited to 500 (or 1000 ?) in the settings.

2. They are stored in a database, so no, you cannot download them via FTP.

A word of warning - a years worth of data could be a huge amount of data to keep, esp if you are getting a few hundred per day.

Thanks you or the reply. Are they stored in a table that I can export from sql? Then review them in an editor. I only set it at 365 temporarily to make shure none got erased. And I know this may sound stupid, but what the use of setting the clean up if you can't view them later anyway? But anyway, thanks again!

[Paul M]

Yes you could export the data from mysql (guest & guestviews).

[JHC]

Yes you could export the data from mysql (guest & guestviews).

Excellent. That's exactly what I need.
You have know idea how much I appreciate your mod, as well as your help.
Thanks again!

[CeesT]

I am using this mod on VB3.8.4 and will upgrade to 4.0 soon. Do you plan to make a 4.0 version of this mod ?

If so: I have to uninstall all mods before upgrading VB, so will I loose my 'most guests online over 24 hours' top-score then ? Or could I just switch-off the mod and leave it installed and upgrade if a new version is out and so keeping the stats ?

[Paul M]

Uninstalling it should not lose the most ever score.

I do plan to upgrade this, so you can just disable it if you prefer. The vb4 version will automatically remove it upon install.

[Freddy.k]

I look forward to the VB4 version hack excellent thank you very much

[Paul M]

It should be in January, tho possibly towards the end of the month.

[Freddy.k]

thank you very much

[Barteh]

For some reason I don't see any related permissions in my usergroups, so I unfortunately can't enable it. Just to be sure, what exactly is the trg-permission named, and is it supposed to appear under 'Who's Online Permissions'?

*EDIT*
Slight D'oh moment there. bitfield_trg_38.xml now uploaded to /includes/xml/ .

[scpgsm_rnd02]

Our forum is forum.revosupport.com. I has just download and install this product and this succesfull. But i don't see anything changes.
I am just check my forum home template and compare it with default template, and i found nothing diffrent.
the vbulletin option and product manager, show that this product is enable..
But i am still not seeing anything changes..
:confused::confused:
i will apreciate any help..
:(:(:(

[Brandon Sheley]

Our forum is forum.revosupport.com. I has just download and install this product and this succesfull. But i don't see anything changes.
I am just check my forum home template and compare it with default template, and i found nothing diffrent.
the vbulletin option and product manager, show that this product is enable..
But i am still not seeing anything changes..
:confused::confused:
i will apreciate any help..
:(:(:(

did you check the usergroups ;)
you have to enable it for your group

[fluidswork]

Great............

[garyopa]

I installed this plugin and it is working great.

Nice, simple, and lots of useful information!

But one question I have, I am currently only using Vbulletin and Vbadvanced (NO VBSEO)

And in the tracking of the visitors list, if I click on a URL, it works and displays it.

But if I click on a vistor that is viewing an ATTACHMENT, I get an error because it:

forums/attachment.php?a=17976

instead of the real url which is:

forums/attachment.php?attachmentid=17976

Is there anyway I can mod it, so it gives me the right URL for attachments, add in
the missing ttachmentid part.

[SamirDarji]

I installed this plugin and it is working great.

Nice, simple, and lots of useful information!

But one question I have, I am currently only using Vbulletin and Vbadvanced (NO VBSEO)

And in the tracking of the visitors list, if I click on a URL, it works and displays it.

But if I click on a vistor that is viewing an ATTACHMENT, I get an error because it:

forums/attachment.php?a=17976

instead of the real url which is:

forums/attachment.php?attachmentid=17976

Is there anyway I can mod it, so it gives me the right URL for attachments, add in
the missing ttachmentid part.Wow, looks like you discovered a bug to me.

[Paul M]

Wow, looks like you discovered a bug to me.
Yep, looks that way.

[garyopa]

Yep, looks that way.

Thanks for reply to my message.

Any ideas, no rush it fixing it, but when you get a chance.

If you need to poke around my site to see the BUG in action, since me a PM and give you more info.

-----------------------
Second question, to those using this mod (I also using Paul's other mod, to track members):

I was wondering or if one existed, that I could make a mini-stats version on my front page for Vbadvanced,
I don't want all the members names, and vistors listed, just a few lines like this:

6286 Users Online Right Now! (523 members and 5763 guests)

Total members that have visited the forum today: 1,464
The most members online in one day was 1,976, 09-14-2010.

Total guests that have visited the forum in the last 24 hours: 49,624
The most guests online over 24 hours was 49,990, Today at 10:05 AM.


What would be variable names to grab this info, as I could code the module myself, if does not exist already!

[Paul M]

Thanks for reply to my message.

Any ideas, no rush it fixing it, but when you get a chance.

If you need to poke around my site to see the BUG in action, since me a PM and give you more info.

Its just a phrase issue, i'll probably update it at the weekend as it affects four mods in total (Track Guests and Track Members, 3.8 and 4.0 versions).

[BirdOPrey5]

Looks good... will probably install when this bug is fixed.

[Paul M]

You mean the bug thats already fixed ?

v3.8.003 : Fix bug in attachment viewing links.

[BirdOPrey5]

That's quick!

Working great, Thanks... and great info on updating the spiders xml file, never knew to do that before.

[Simon Lloyd]

Worked straight away without any trouble :)

Thanks Paul!

[MagicThemeParks]

For the upgrade do we delete the old bitfield xml and upload the new one? Or, simply overwrite the product? Or both?

[Paul M]

Only the product xml has changed.

[soundbarrierpro]

Hey Paul, if we get the other spiders definition do we just import that into the product manager as well? Or do we use one or the other? Meaning, yours or theirs or both?

Thank you,

[BirdOPrey5]

I just over-wrote the spiders_vbulletin.xml file in my /forums/includes/xml/ directory and it seems to be working fine... I hope that was the right way to do it...

Paul, I don't believe I've used any of your mods before so I really don't know the answer to this- but when I downloaded this package I noticed there was no documentation (readme file or install instructions) in the ZIP, is that by design or was it maybe an oversight? The install instructions were in the thread so no big deal, just want to be sure.

[soundbarrierpro]

Thank you, I found the info after looking for it in the faq at the site where the spider file is.


This should help your install

To install (or upgrade);

* Unzip the XML files.
* Upload the bitfields file to your ../includes/xml folder.
* If upgrading from a previous version, delete the old bitfield 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.

[Paul M]

I just over-wrote the spiders_vbulletin.xml file in my /forums/includes/xml/ directory and it seems to be working fine... I hope that was the right way to do it...
Thats correct.

Paul, I don't believe I've used any of your mods before so I really don't know the answer to this- but when I downloaded this package I noticed there was no documentation (readme file or install instructions) in the ZIP, is that by design or was it maybe an oversight? The install instructions were in the thread so no big deal, just want to be sure.
Thats also correct, the 3.8 versions only have the instructions in the thread. I believe I added a text file in 4.0.

[BirdOPrey5]

So looking through the visitor logs I now see on occasion a visitor is "Viewing Thread" but the thread is one in a forum visitors don't have access to- can I assume they followed a link somewhere (maybe in someone's email) and simply got a "not logged in" message and didn't see the actual thread, or is this indicating a permissions problem?

[Paul M]

Yes, the attempt will be logged, even if they actually end up on the no permissions page.

[BirdOPrey5]

Thanks...

[MnTom]

Is it possible for this hack to cause Too Many Connections? I have been fighting that error and MySql has gone away and am trying to trouble shoot things. vB says server issue and host says software issue so I am fishing for answers.
Tom

[Paul M]

No, its not possible for it to do that.

[MnTom]

No, its not possible for it to do that.

I thought so......... Even vBulletin.com says the host is crap.....
Yes, you need to find a better host. The connection limit is ridiculous.

[Alfa1]

Is this addon very server intensive when used on high traffic boards?
I recently had to uninstall 'Who's online spider display' due to some mega-queries.

[Paul M]

Shouldnt be, the display query uses an index.

[orillia]

Installed, works just fine. Thanks!

[Phobos49]

When wachting guest tracking list, I was just wondering what "Called with DO =" mean? Any idea?

[mbc100]

i great i will install later

[MnTom]

I moved to a different host and re-installed Guest Tracking. It was working fine one min. and when I refreshed the screen it was gone! Any ideas? No settings have been changed.
Tom

[MnTom]

OK, Now this is really strange.:confused: I am the only administrator on my site and the Mod does not have permission to change the settings, BUT in the Usergroup Manager ALL settings were set to NO!! How in the world would or could they change by themselves????

[Paul M]

Did you uninstall it ?

[SamirDarji]

I have created a vba module that combines the information from this plugin and Paul's Members Who Have Visited Today plugin. The only problem is that I'm not a programmer and I couldn't find a way around just incorporating a chunk of Paul's code into the php file for the vba module. :(

If anyone knows how to pull out the $gueststoday variable by using code similar to this that was used in the vba php file for the Members Today module, I could revise my php to just pull the information vs regenerating it and release the vba module.($hook = vBulletinHook::fetch_hook('forumhome_start')) ? eval($hook) : false;

$whotoday = str_replace( "member.php", $vbulletin->options['bburl'] . "/member.php", $whotoday);

eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_todaysOnline') . '";');(This code is from this module created by Tom M
http://www.vbadvanced.com/forum/showthread.php?t=33815)

Paul if you have any suggestions, I'm open to that as well. :)

Thank you for your plugin! Now my users will see how many hundreds of guests are reading their posts.

[Paul M]

This works off the forumhome_complete hook, not forumhome_start.

[SamirDarji]

Thank you Paul!

So if I would change the hook location to forumhome_complete and then evaluate the template, would I have access to the $gueststoday variable?

[Paul M]

I have no idea, as I dont know whats in the template, or the rest of the code, but it wont work unless you swap the hook name. :)

[SamirDarji]

I don't even know what's going on in that code, so you're ahead of me. :)

The template just uses the $gueststoday variable, so if changing that hook will allow the variables to pass to the template from your plugin, I think we'd be set.

[MissKalunji]

This one is so much better. thank yoU!

[Alfa1]

Feature request / suggestion:

If useragent is disallowed in robots.txt then display the user in red colour.

This allows the admin to quickly identify bots that do not respect robots.txt

[Max Taxable]

Just found this... Installed, works great right out of the box.

Special note after reading this entire thread: Paul's patience seems limitless!


EDIT to add - This is greatly enhanced by the updated spider definitions xml!

[DEGE]

Hi everybody. Have a great new year !!

I'm using this hack and found out that even with the last spiders.xml definition file, there are some listed entries that do not reflect real spiders.

2-ene-12, 16:18 Visitor No attachment 74.125.156.83 Viewing Attachment 683 (http://www.circulobdsm.org/attachments/busquedas-42/683-busco_amo_mar_plata_o_plata-08b.gif)
2-ene-12, 16:18 Visitor No attachment 74.125.64.95 Viewing Attachment 683 (http://www.circulobdsm.org/attachments/busquedas-42/683-busco_amo_mar_plata_o_plata-08b.gif)

If you ping the IP there is no info related, but if you query the IP information with some IP2Loc page, you find out that this is Google:

http://whatismyipaddress.com/ip/74.125.64.95

Is there any way to get a list of this unnamed IPs and add them to the local DNS so that the server solves them properly?

Regards

[EliasAlucard]

Any vB4.2 version coming soon?

[Paul M]

I suggest you look in my profile ;)

[Max Taxable]

You can get an improved Spiders Definition file from this site. (http://www.wolfshead-solutions.com/spiders-list)That link is no longer valid, and I was looking for a updated definitions file for this. Any ideas?

Chiefly, would like to add the archive dot org "Wayback Machine" crawler to the definitions.

[ozzy47]

That link is no longer valid, and I was looking for a updated definitions file for this. Any ideas?

Chiefly, would like to add the archive dot org "Wayback Machine" crawler to the definitions.

You can get the last spiders list here, http://www.vbulletin.com/forum/forum/general/managing-your-community/361239-ws-spiders-list-for-updated-vbulletin-spiders-vbulletin-xml-files

[Max Taxable]

You can get the last spiders list here, http://www.vbulletin.com/forum/forum/general/managing-your-community/361239-ws-spiders-list-for-updated-vbulletin-spiders-vbulletin-xml-filesThanks but, that's the one I have.

[ozzy47]

Ahh ok, AFAIK that is the latest one, I have not seen anything else posted. :(

[Paul M]

Removed that link as its no longer valid.

wolfshead-solutions btw was Mosh, so it would have been the same file.

[Max Taxable]

Removed that link as its no longer valid.

wolfshead-solutions btw was Mosh, so it would have been the same file.He was a good fella.

[Max Taxable]

Paul:

I've added this to the XML, the definitions file. Will it work? Any issues?

<spider ident="Archive Bot">
<name>Wayback Machine</name>
<info>http://www.archive.org/details/archive.org_bot</info>
<email>bot@archive.org</email>

Is the "spider ident" what's found in the user agent string for the bot? Must it match the UA?

[Max Taxable]

Paul:

I've added this to the XML, the definitions file. Will it work? Any issues?

<spider ident="Archive Bot">
<name>Wayback Machine</name>
<info>http://www.archive.org/details/archive.org_bot</info>
<email>bot@archive.org</email>

Is the "spider ident" what's found in the user agent string for the bot? Must it match the UA?And....

That does not work. Any advice Paul? Anyone?

[Max Taxable]

Now I've tried:

<spider ident="archive.org_bot">
<name>archive.org_bot</name>
<info>http://www.archive.org/details/archive.org_bot</info>
<email>bot@archive.org</email>

[Max Taxable]

Now I've tried:

<spider ident="archive.org_bot">
<name>archive.org_bot</name>
<info>http://www.archive.org/details/archive.org_bot</info>
<email>bot@archive.org</email>That one made the entire plugin cease to function. Everything hitting the site was a "guest."

[Max Taxable]

Sweet. Was hoping for this!

[ozzy47]

Not a problem. :)