Track Guest Visits

[aquariumpros]

Updated! Thanks!

I did the update and it says I'm running 1.09 still?

Make sure that you have "Allow Overwrite" set to yes when you import the new XML.

HTH

[Shazz]

Lets try this update :)

[MeMySelfNi]

<font color="Yellow">updated</font>

[Tulsa]

Updated! Thanks!



Make sure that you have "Allow Overwrite" set to yes when you import the new XML.

HTH

Did that, twice.

[Paul M]

Hmm, that's odd, I just downloaded it and got v1.09 as well, yet I uploaded the new version this morning. I've deleted the file and uploaded it again.

[Mudvayne]

But I got 1.10 as well :S.

[munch]

OK, now I am confused. I downloaded and installed this on Dec 12th, my version when checked is 1.10

Is that possible?

my understanding is that 1.10 is new today (?)

$Author: pem $
$Revision: 1.10 $
$Date: 2006/12/12 15:08:02 $

[Paul M]

That's the CVS revision number, not the version, look a bit further down ;

<?xml version="1.0" encoding="ISO-8859-1"?>
<!--
$Author: pem $
$Revision: 1.12 $
$Date: 2007/01/03 10:02:23 $
-->
<product productid="paulm_20061109" active="1">
<title>Guest Tracking</title>
<description>Track Guest Visits</description>
<version>1.10</version>
<url><![CDATA[https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=paulm_20061109]]></url>

FYI: CVS revision 1.10 was version 1.08

[munch]

understood, thanks,

will update !

[Shazz]

Updated again before I got to update the last one :rolleyes:

[sinisterpain]

Paul,
Curious why you change the datastore call. Is there a known issue with the datastore use. And thanks for the update.

[Tulsa]

Now I've got 1.10...

Thanks Paul!

[Paul M]

Paul,
Curious why you change the datastore call. Is there a known issue with the datastore use. And thanks for the update.The standard datastore fetch does not just load the list you supply, it also loads about 10 "default" items, which can cause problems.

[Philster]

Paul, do we have to remove the previous version prior to installin this version ? Thanks bud.

Phil.

[Paul M]

Importing this will automatically replace the previous version - that's how the vb product system works.

[Smoothie]

Hmm, downloaded mine around 10 am this morning and I got <version>1.10</version>

[Shazz]

Hmm, downloaded mine around 10 am this morning and I got <version>1.10</version>

Thats what has been released

[Smoothie]

Thats what has been released
https://vborg.vbsupport.ru/showpost.php?p=1150040&postcount=255
:rolleyes:

[dj_melayu]

Importing this will automatically replace the previous version - that's how the vb product system works.

I've been using this hack since it on v1.03, and I frequently kept updating this hacks cuz its a one of the wonderful hacks! Unfortunetly, after I upgraded to v1.10, I got this error on my index.php on my vbadvanced page.
My forumhome page is on forum.php.

Fatal error: Cannot use string offset as an array in *****\htdocs\global.php(356) : eval()'d code on line 1350

Not to blame forwardly to this product but this just happened after the upgrade process.It works fine on my forum.php. Come and shout something :D

[cerulean]

I have the same error as dj_melayu and I to have vbadvanced. I had to disable the product in order to get my forum to work.

Ps. It only gives the error if a guest goes to the page but if you where previously logged in and go to it it is fine.

Any thoughts?

[testpig]

Hi Paul. This hack still doesnt appear in my forum.

I have removed the previous version and uploaded V1.10 but absolutely nothing happens. Still using the default skin with some additional plugins installed.

Hmmmmmm,

[Quantnet]

Updated.

Paul, i looked at http://www.theadminzone.com/forums/ and on the Currently Active Users, it shows spiders, members and guests in the same box..

Is that a version of your mod ? I would like to add spiders to that list too. Right now, guests and spiders are shown as guests
Thanks

Edit : just found that the spiders on forumhome is https://vborg.vbsupport.ru/showthread.php?t=119134

[jw00dy]

This hack causes a problem with the "Direct Category Links" feature of vbSEO. Here is the fix:

Original code:


if (
$vbulletin->userinfo['userid'] == 0
AND $vbulletin->options['trg']
AND $vbulletin->options['trgspiders']
)
{
define('SKIP_DEFAULTDATASTORE',true);

$vbulletin->datastore->fetch(array('wol_spiders'));
}
Changed to:


if (
$vbulletin->userinfo['userid'] == 0
AND $vbulletin->options['trg']
AND $vbulletin->options['trgspiders']
)
{
define('SKIP_DEFAULTDATASTORE',true);
$__temp_fc = $vbulletin->forumcache;
$vbulletin->datastore->fetch(array('wol_spiders'));
$vbulletin->forumcache = $__temp_fc;
}
Credit to: Oleg Ignatiuk (http://www.vbseo.com/members/oleg-ignatiuk/)
Where are you putting this in the 1.10 version? Or did you implement this in 1.10 paul? I was unclear on this and I use vBSEO as well.

[Paul M]

Where are you putting this in the 1.10 version? Or did you implement this in 1.10 paul? I was unclear on this and I use vBSEO as well.
That plugin does not exist in 1.10.

Hi Paul. This hack still doesnt appear in my forum.

I have removed the previous version and uploaded V1.10 but absolutely nothing happens. Still using the default skin with some additional plugins installed.

Hmmmmmm,One of those plugins must be intefering, try disabling other products one at a time until you find which one (past experience suggests it's probably one with a plugin linked to the cache_templates hook, try them first).

I've been using this hack since it on v1.03, and I frequently kept updating this hacks cuz its a one of the wonderful hacks! Unfortunetly, after I upgraded to v1.10, I got this error on my index.php on my vbadvanced page.
My forumhome page is on forum.php.I have installed vbadvanced on my test forum and cannot reproduce this, so there's not much I can tell you.

[jw00dy]

That plugin does not exist in 1.10.
Even better ;)

Thanks Paul, Seriously, your work is top notch, and I appreciate it.

[Paul M]

I have the same error as dj_melayu and I to have vbadvanced. I had to disable the product in order to get my forum to work.

Ps. It only gives the error if a guest goes to the page but if you where previously logged in and go to it it is fine.

Any thoughts?As above, I cannot recreate this on a test vba (2.2.1). Try turning off the "Detect Spiders" option, see if it's related to that.

[blogtorank]

Thanks for the update Paul, with over 70+ hacks on a forums this is working just fine with your v1.10

[dj_melayu]

As above, I cannot recreate this on a test vba (2.2.1). Try turning off the "Detect Spiders" option, see if it's related to that.

Thanks..it fix when disable the spiders option..Good job! Or should I downgrade to v1.90. which version is better? :D

[snowman872]

Installed and seems to be working. Thanks for this useful hack Paul!

[Paul M]

Thanks..it fix when disable the spiders option..Good job! Or should I downgrade to v1.90. which version is better? :DHiding the problem is never a good idea, fixing it is much better. Can you confirm that you have read and done this ;

Note: For Spider detection to work you must set Enable Spider Display to 'Yes' in vBulletin Options > Who's Online Options and then visit your Who's Online page. This will enable vBulletin to build it's cache of spider details.

[T.S.]

1.10 gives guests a blank page on one of my forums, while 1.09 worked fine. It seems to be working normal on my other forum. Both sites are the same vB version and have the same mods installed. :cross-eyed:

[paldo]

updated this last night on my forum and peeps couldnt log in or see the site
/home/birdbox/public_html/forums/global.php(356) : eval()'d code on line 356

was all they could see uninstalled the hack and everything is fine . the old one at least worked lol

[Paul M]

Sorry, but unless someone gives me access to a forum that has an error then we are not going to get anywhere. I cannot make this fail no matter what I try.

BTW both paldo and T.S - I would assume that as with the previous member, turning off Spider Detect should cure the error until someone gives me access to a failing board to trace the problem.

[A0007]

Thanks !

[dj_melayu]

Hiding the problem is never a good idea, fixing it is much better. Can you confirm that you have read and done this ;

Yes, enable spider display is already enable on who's online options and v1.11 is still couldnt fix that problem..Have to disable detect spider on guest tracking options. Thats not the big issue anyway. Well done and great job for your work! :D

[paldo]

Just out of interest - can anyone who has an error in global.php upload the version attached to this post and see if it makes any difference.

same error for me

[Paul M]

Sorry, but I cannot find anyway to make it fail on my test forum, so unless one of you wants to give me access to your forum to do some testing then there is nothing I can do. The randomness of it suggests it may be clashing with something else.

[BoYagoob]

installed

[Shazz]

Working perfect on new update

[dj_melayu]

downgrade to v1.90..not blaming to this hacks..maybe it was conflict with other hacks..good job! :)

[TheWhite]

having the same problems, downgraded to version 1.90 toooo :surprised:

[Paul M]

At the risk of repeating myself - unless someone gives me access to a forum displaying the error then nothing is going to get investigated/fixed.

[ShawnV]

At the risk of repeating myself - unless someone gives me access to a forum displaying the error then nothing is going to get investigated/fixed.

I PM'd you info and access.

_V

[Paul M]

Thank you, I'l take a look in a bit. :)

[Paul M]

I have looked at your forum and you seem to be working ok atm (I have loaded 1.11 for you).

Unfortunately, you are not getting the problem I was looking to try and track down (the "Cannot use string offset as an array" error in global.php).

Can someone who is getting this error please give me access to look into it.

[ShawnV]

I have looked at your forum and you seem to be working ok atm (I have loaded 1.11 for you).

Unfortunately, you are not getting the problem I was looking to try and track down (the "Cannot use string offset as an array" error in global.php).

Can someone who is getting this error please give me access to look into it.


Thank you sir, appreciated. ;)

edit: for some odd reason though, it will show everything, ergo: Visitors (37), Yahoo! Slurp Spiders (3) Google (1)

Then an hour later it will only show Visitors (37) or visitors and yahoo, is there some cron or something else that is clearing out the stored data for those, it is very random?

Cheers,

_V

[Paul M]

There is a cron function to clear out old records, I didn't notice what you had it set to.

[ShawnV]

There is a cron function to clear out old records, I didn't notice what you had it set to.


I have it set to 7 days atm, wonder why its only clearing out the spider info though, not the Visitors?

[Rop]

Hi Paul,

Thank you for this nice mod!
Could you explain a bit how guests and spiders are counted? As mentioned by others, it seems to greatly undercount spiders. That's probably by design, and it would help if I understood how a guest/spider is counted. From the dB table it looks like it's tracking IP, so I guess unique IPs are only counted once? Even with that in mind the count seems low, so there must be more to it. How is the ID in the table calculated? Possibly multiple instances of a spider result in the same ID?

In the last few posts you mention there's a cron job doing cleanup. What is job called? Or is it part of an existing job, like Daily Cleanup? There doesn't seem to be anything in my list of cron jobs that's related to guest visit tracking. I just want to make sure there is something cleaning up the guests table, so it doesn't grow unbounded.

Thank you!

-Rob-

[Spiffware]

*updated*

[Paul M]

Hi Paul,

Thank you for this nice mod!
Could you explain a bit how guests and spiders are counted? As mentioned by others, it seems to greatly undercount spiders. That's probably by design, and it would help if I understood how a guest/spider is counted. From the dB table it looks like it's tracking IP, so I guess unique IPs are only counted once? Even with that in mind the count seems low, so there must be more to it. How is the ID in the table calculated? Possibly multiple instances of a spider result in the same ID?

In the last few posts you mention there's a cron job doing cleanup. What is job called? Or is it part of an existing job, like Daily Cleanup? There doesn't seem to be anything in my list of cron jobs that's related to guest visit tracking. I just want to make sure there is something cleaning up the guests table, so it doesn't grow unbounded.

Thank you!

-Rob-
The unique id is generated by standard vbulletin, iirc it's based on ip and useragent - you will see them in the vb session table if you look.

Basically what this does is create a record for each unigue visitor, as determined by vb, and update that record each time that visitor loads a new page (exactly as happens for a member).

If spider detection is enabled then each time a visitor record is updated it loads vb's spider list (as used on the WOL) and uses this to check if the visitor is a known spider, if it is recognised then the record is updated with the spider name as well as the new lastactive time. (That means if it was off, and you turn it on, you will not see an instant change, visitors will only be updated as they visit).

The count is simply built by loading all the records where the lastactive time is greater than the cutoff (either 24 hours ago, or midnight, depending on the setting).

The cleanup does not use a seperate cron job, it's via a hook in the hourly cleanup job.

[Rop]

Thanks Paul! That does make things a little clearer.
I understand now why spiders that come from the same IP will only be counted once, even if they come back multiple times within 24 hours.

I still have a little bit of a puzzle with spiders though: About an hour ago 6 Slurp spiders were showing on my board. They were all from different IPs. Yet the guest stats show that only 3 Slurp spiders have visited in the past 24 hours. So, is this because vBulletin classifies some of these (despite the unique IPs) as 'the same' guest? No way around this I suppose?

-Rob-

[Paul M]

I still have a little bit of a puzzle with spiders though: About an hour ago 6 Slurp spiders were showing on my board. They were all from different IPs. Yet the guest stats show that only 3 Slurp spiders have visited in the past 24 hours. So, is this because vBulletin classifies some of these (despite the unique IPs) as 'the same' guest? No way around this I suppose?Actually, what is happening is that the slurp spiders are from a similar subset of ips - e.g. 74.6.71.x

By default, vbulletin builds the unique id using just the first three bits of the ip address - so 74.6.71.1 will be seen the same as 74.6.71.2, 74.6.71.3 etc. You can change this in the vBulletin Options > Server Settings and Optimization Options > Session IP Octet Length Check - change it from '255.255.255.0' to '255.255.255.255' and vb (and hence this mod) will see them all as unique.

I think I might add my own option for this in the next update, or maybe just build the guest id seperately from vb so that setting does not cause a problem.

[Rop]

Thanks Paul! Perfectly clear now!
I was going to change the Session IP Octet Length Check to use the full IP address, but the notes that go with it gave me pause. Seems that using the full IP for session IDs can cause trouble for users behind transparent proxies (and there are many of those). So, I'll leave things as they are now, and live with it. Of course, you have my vote to use your own guest ID solution for the mod. It would make a great add-on even better! :)

-Rob-

[Paul M]

Seems that using the full IP for session IDs can cause trouble for users behind transparent proxies (and there are many of those).It doesn't really affect transparent Proxies - it's mostly AOL users whose proxy IP can change mid session.

[funkmeister]

How can I reposition the output? I want to place the content in a different position on my FORUMHOME, but I don't see any "call" to it within that template?

Is it elsewhere or can I turn off the display and use the contents of the 'Display_Guests' template and place within FORUMHOME in my desired location?

Thanks, awesome product as usual Paul M.

[funkmeister]

To answer my own question! Well, yes I can place the contents of 'Display Guests' into the position I would like it to appear, but with the display turned off, of course, it's content is empty!

So to my original question, is there way of postioning this wherever I would like on FORUMHOME, as I can't seem to find where the relevant code is, other than what I have mentioned.

If it's not possible right now, can you add the ability for folks like me who would like a little more layout possibilities.

Thanks again.

[ShawnV]

I think I might add my own option for this in the next update, or maybe just build the guest id seperately from vb so that setting does not cause a problem.


Awaiting this one, since I still seem to have a problem with it keeping the spiders info, a conflict I assume is with another mod I have installed, has anyone checked this with the Inferno RPG, or the IBpro Arcade as those are the only new mods that have been added to the site recently.

_V

[funkmeister]

To answer my own question! Well, yes I can place the contents of 'Display Guests' into the position I would like it to appear, but with the display turned off, of course, it's content is empty!

So to my original question, is there way of postioning this wherever I would like on FORUMHOME, as I can't seem to find where the relevant code is, other than what I have mentioned.

If it's not possible right now, can you add the ability for folks like me who would like a little more layout possibilities.

Thanks again.

Answering my own question again :) But for the benefit of others, in case it's needed...

You need to edit the .xml and replace the CDATA value in the "text_trg" section of the "<options>" section towards the end of the file. The default value is "<![CDATA[<!-- end logged-in users -->]]>" - simply change the string to the appropriate end string that is defined in your FORUMHOME template, where you would like things positioned.

Sure would be nice to have this as an admincp option though ;)

Thanks.

[Paul M]

Sure would be nice to have this as an admincp option though ;)
It's already an ACP option.

vBulletin Options > Auto-Template Settings

:D

[funkmeister]

Thanks Paul - wish I'd spotted that earlier! Is that part of the plug-in? If so, naming it somewhat related would be helpful. Perhaps with initials or something. Or just include the 2 options within the 'Guest Tracking' section.

Anyway, will remember that for next time, will save some editing :)

[Paul M]

Version 1.12 released

This version now generates the unique id for each guest internally rather than using the default vb generated id - this is to get round the potential problems caused by the "Session IP Octet Length Check" setting in vbulletin.

I have also made some minor changes to the spider detection code to try and solve the "Cannot use string offset as an array" problem that some people are experiencing. However, since I cannot replicate this error these are 'blind' changes, and I cannot say if they will work. If they don't then you can run this with spider detection disabled.

Finally, please note - since the guest id generated is now different to the past system, installing v1.12 will clear all the existing guest records so that data collection starts again with a fresh empty table. This is necessary otherwise guest counts would be falsely inflated for a period of time.

[Shazz]

/me updates

[red-dna]

Very nice plugin, thank you.

Only one problem, when i update, the tracking is show only visitors now (no spiders at all).

[chkdgate]

Updated. Thank you.

[storpappa]

Guest Tracking 1.12 Track Guest Visits

Installed or rather updated.

Is this version showing spiders?

[Paul M]

As per the note ;

Note: For Spider detection to work you must set Enable Spider Display to 'Yes' in vBulletin Options > Who's Online Options.
Previous versions did not enforce this, which resulted in some problems - v1.12 does enforce it.

[KURTZ]

UPDATED

[onehost]

helo PaulM..this is really a nice modifications..

can it be shown in the same block of "User Visited Today"
also can it show Spider Visited today in the same block? Hence its showing the spider too...

thnx in advance

did you ever get a reply about showing spiders? that is something
I saw on a site, i am looking for that also.

Thank

[Paul M]

This shows spiders.

[jw00dy]

Thanks Paul, Nicely done.

[Ricsca]

Thanks! :)

[red-dna]

I check that set Enable Spider Display is allreadt set to 'Yes' in vBulletin Options
and i also visit the online.php page (and the spiders are displayed ok)
but i get:
Total guests that have visited the forum in the last 24 hours: 609
Visitors (609)

The previous version is worked ok, but with the update i got stuck with this problem.

Any help ?:(

[MeMySelfNi]

updated..........

[Paul M]

Any help ?:(As I have previously mentioned a few times, if you want me to look at a specific problem then unless you provide me with access to your forum (admin access, with the ability to run sql queries) then there is nothing I can do. I cannot investigate problems that are not reproducable on my system.

[storpappa]

Stats are showing visits from the 3 major search engines, but these do not show up in the visitors for the mod. Any suggestions on what to check?

Or a way to send a spoofed bot visit to the site and see what shows up?

As above, I am fine with that. Just PM me if you are interested in looking at the site - thanks

****turned this off, back on, changed a babies popy diaper and now it is working. Your mileage with or without the diaper may vary. Thanks for another great mod Paul

[aciurczak]

As much as I like the functionality of this mod, it had such a performance hit on my board I had to disable it. My board felt sluggish recently, so I paid closer attention to the Microstats at the bottom saying how many seconds & queries it took to create the page. With this plug-in enabled, it would sometimes take 4 or 5 seconds to display my forum home page, (with only 14 queries). It was never less than 3 seconds.

After disabling this hack, it is back down to between 0.4 and 1.0 seconds to create the home page, with 13 queries. This hack reported that I was getting about 2000 guests visiting per day (vast majority were spiders), and my server load never reports over 0.8, so it likely wasn't a server load problem.

Any suggestions on indexing certain tables to improve performance?

[Paul M]

Hmm, looking at this on my homepage, mysql is not using the index for some reason, even though it exists. By forcing it the query is quicker.

Change the SQL call (in Plugin 3) to this and let me know what happens ;

$todaysguests = $vbulletin->db->query_read_slave("
SELECT * FROM ".TABLE_PREFIX."guest FORCE INDEX (lastactive) WHERE lastactive > $cutoff
");

[aciurczak]

That did it. Page load time is back under a second, with the mod enabled. Thx for the quick fix.

[Paul M]

That did it. Page load time is back under a second, with the mod enabled. Thx for the quick fix.Good, I'll release that as an update tomorrow.

Investigating that has highlighted some index issues in a few other mods as well, so I've a few updates to issue ......

[Paul M]

v1.13 - as per posts #327 to #329, I have changed the SQL to force MySQL to use the index on forumhome - it wasn't being used - on forums with a large number of guests this will speed up the query this runs.

[storpappa]

downloaded, updated - thanks for the update

[KURTZ]

<font color="SeaGreen">UPDATED!</font>

PS. Paul just a question: the better way to update is first unistall the previous version and after this re-install the hack or simply overwrite?

[Neutral Singh]

why this isnt working with 3.6.2 :( ?

[Mudvayne]

Why are you using an older version of vB where there is a new & security bug fixed version available :S.

[Shazz]

/me updated thanx

[firstrebel]

I just upgraded this mod now I have this:
Visitors (334), Yahoo! Slurp Spiders (853), MSNBot Spiders (9), Google Spiders (1)
I don't think so!!

Bob

[Viper007Bond]

All updated. Thanks. :)

[Mudvayne]

Updated. Works like charm..

[Paul M]

I just upgraded this mod now I have this:

I don't think so!!

BobThat didn't upgrade properly I would say, do an uninstall/install to clear the table.

[Shazz]

I can't get it to display the yahoo bots etc.

It only says
Visitors (457)

I have all the the options checked to "yes" in the vBoptions

[firstrebel]

That didn't upgrade properly I would say, do an uninstall/install to clear the table.
Got this when I tried to uninstall:Fatal error: Direct Instantiation of vB_Database_Alter class prohibited. in /includes/class_dbalter.php on line 106


Bob

[firstrebel]

Now I cannot access ther forum at allDatabase error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM vb_guest FORCE INDEX (lastactive) WHERE lastactive > 1168560000;

MySQL Error : Table 'vb_forum.vb_guest' doesn't exist
Error Number : 1146
Date : Friday, January 12th 2007 @ 08:06:17 PM
Script : http://www.volvoclub.org.uk/forum/index.php
Referrer : http://www.volvoclub.org.uk/forum/acon/index.php?do=head
IP Address : 80.168.254.234
Username : admin
Classname : vb_database
Bob

[firstrebel]

Paul,

I think one of the mods you updated today may have caused this. I disabled all them and now I have access to the forum again.

I'll try to reproduce it and see if I can tie it down to the problem.

Bob

[firstrebel]

I have the same problem on my dev site. I cannot uninstall this mod. I now cannot run with it enabled either as it causes the db error above. The only way I can now run the forum is with this disabled.

Bob

[firstrebel]

I have managed to sort this out. I suspect something went wrong importing the updated product. I manually removed the vb_guest table and then imported one from an earlier backup. Then did the uninstall and reinstall.

Time for a drink...

Bob

[Shazz]

I can't get it to display the yahoo bots etc.

It only says
Visitors (457)

I have all the the options checked to "yes" in the vBoptions

I tried disabling it then putting it back on, didn't do anything :(

[firstrebel]

Something is not right here, after just over an hour after removing and reinstalling I have this:
Visitors (158), Yahoo! Slurp Spiders (507), MSNBot Spiders (4), Google Spiders (1)
Bob

[firstrebel]

I have just tried to uninstall this again, guess what, again - Fatal error: Direct Instantiation of vB_Database_Alter class prohibited. in /includes/class_dbalter.php on line 106
And the forum was not accessible again, until I disabled the product. The table had been removed from the database but because I could not totally remove the product it generated lots of db errors.
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT * FROM vb_guest FORCE INDEX (lastactive) WHERE lastactive > 1168560000;

MySQL Error : Table 'vb_forum.vb_guest' doesn't exist Error Number : 1146
Date : Friday, January 12th 2007 @ 11:01:37 PM
Script : http://www.volvoclub.org.uk/forum/index.php
Referrer : http://www.volvoclub.org.uk/forum/acon/index.php?do=head
IP Address : 80.168.254.234
Username : admin
Classname : vb_database

Database error in vBulletin 3.6.4:

Invalid SQL:

REPLACE INTO vb_guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('023eeebea3b0ca22284bcda48e947451', '88.90.177.82', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)', 1168642897, '', 'index', 'a:6:{s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:8:\"threadid\";i:0;s:7:\"forumid\";i:0;s:6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Table 'vb_forum.vb_guest' doesn't exist Error Number : 1146
Date : Friday, January 12th 2007 @ 11:01:37 PM
Script : http://www.volvoclub.org.uk/forum/index.php
Referrer :
IP Address : 88.90.177.82
Username : Unregistered
Classname : vb_database

..to quote just a few.

I had to reimport the table from an earlier backup and then I could uninstall the product cleanly. I am not reinstalling this again as something is just not right.

Bob :mad:

[Shazz]

^You've posted about 7 times ina row :|

[firstrebel]

Yes, how observant. It is because I am getting a series of problems and as soon as I think it is fixed, it's not. It's called going round in circles. If you read them in sequence, and note the time stamps you may understand.

Bob

[jw00dy]

I had some trouble as well, and mine had to do with the spider watchers hack. I removed it, re-added, and now all is happy now.

[Smoothie]

So..... maybe I should wait to upgrade until this gets sorted out.

[funkmeister]

Works fine for me :)

[Paul M]

I have just tried to uninstall this again, guess what, again -
And the forum was not accessible again, until I disabled the product. The table had been removed from the database but because I could not totally remove the product it generated lots of db errors.


..to quote just a few.

I had to reimport the table from an earlier backup and then I could uninstall the product cleanly. I am not reinstalling this again as something is just not right.

Bob :mad:Whatever you uninstall problem is/was, it's related to your forum setup, I can happily uninstall/install this on my forum.

I can't even imagine what's calling the db alter class.

I'm still puzzled why you thought this was odd ;

Visitors (158), Yahoo! Slurp Spiders (507), MSNBot Spiders (4), Google Spiders (1)

I can't see anything wrong with them

[Shazz]

I can't get it to display the yahoo bots etc.

It only says
Visitors (457)

I have all the the options checked to "yes" in the vBoptions

Help would be appreciated :(

[Viper007Bond]

Something is not right here, after just over an hour after removing and reinstalling I have this:

Bob

Nothing unusual about that. Yahoo enjoys sending a TON of bots at sites. When I changed subdomains after first installing vB, I literally had around 200 bots at once crawling the site.

[funkmeister]

See below for my current visitor list, what you see is not unusual, as has been stated earlier.

I do have one question - is a Visitor (or "Lurker" in my setup) - simply a non-member who's hit the forum or can it also include an undefined spider? If so - it could only be those 2 types of visitors that make up the total visitor number, right?

Thanks and keep up the good work.

[Nathan2006]

Thanks Paul

Updated

[Paul M]

@funkmeister - "Visitor" is any guest not specifically listed (detected) as a spider.

[Paul M]

Help would be appreciated :(Unless you provide me with admin access (with sql query permission) then there is nothing I can do or look at.

[CSS59]

Any way to how the total unique hits counting the members AND visitors?
Also, to total hits would be nice as well :D

Please

[bo0oost]

updated... thanks!

works great as always :)

[Philster]

Updated and still working smooth. Thanks.

Phil.

[ShawnV]

I can't get it to display the yahoo bots etc.

It only says
Visitors (457)

I have all the the options checked to "yes" in the vBoptions

Same thing here.

[Mudvayne]

Update your spiders.xml from here http://www.vbulletin.com/forum/showthread.php?t=76662

[firstrebel]

Getting back to my difficulty uninstalling this product a few pages back, I though I had now fully removed it as I intended installing an earlier verson then working up.

But in ACP -> vBulletin Options it shows a gap in the list where this product was. This suggests it is not totally removed. Any ideas please?

Thanks

Bob

[storpappa]

Wondering if Yahoo really really likes me

Visitors (117), Yahoo! Slurp Spiders (418), MSNBot Spiders (1), Google Spiders (1)

[Ricsca]

Visitatori (673), Yahoo! Slurp Spiders (939), MSNBot Spiders (11), AskJeeves Spiders (1), Google Spiders (1) ;)

[Paul M]

Yahoo likes everyone, they flood you with spiders - take this example from one of the sites I administer.

Visitors (4704), Yahoo! Slurp Spiders (1127), MSNBot Spiders (13), Google Spiders (22), AskJeeves Spiders (1), Google AdSense Spiders (1)

[Paul M]

Getting back to my difficulty uninstalling this product a few pages back, I though I had now fully removed it as I intended installing an earlier verson then working up.

But in ACP -> vBulletin Options it shows a gap in the list where this product was. This suggests it is not totally removed. Any ideas please?

Thanks

BobThat's the auto-template options, it's a shared section used by some of my other mods as well - sadly the idea doesn't work very well as removing the last one installed deletes the options phrase. If you reinstall one of the others (like visitors today) it will restore the phrase. Future versions will not use this sharing due to this flaw.

[Code Monkey]

Is there a 3.54 version of this mod?

[Paul M]

Is there a 3.54 version of this mod?Nope, sorry, there isn't - nor, I'm afraid, will there ever be one.

Most of my 3.5 stuff is no longer fully supported, and anything new is only for the current vb version. All my 3.5 stuff will be out of support by the summer. I simply don't have the time/resources to maintain old versions.

[loonytune15]

I am also having probs with the hack only showing visitors

Pm sent.

[Paul M]

Your spider cache was broken (the unserialize bit was not set in the datastore).

I have fixed that for you locally so your spiders will start to show again.

While I can (and will) add a bit of code to the install routine that will fix spider caches broken in this way, I cannot tell you how you managed to do it (which means that whatever happened could happen again).

[loonytune15]

could this of happened to others as well?

May have happened when i switched server :)

[loonytune15]

G'day paul, sorry to bother you again, but me thinks the cache has broken again???

i am only getting visitors again..

[misticjeff]

Sorry to be a bother here but I don't have time to read through 26 pages of this thread.

Will this mod track guests I.P. addresses and if not, is there a way to make it do so? I had a mod similar to this on a Xoops site a while back and it tracked guest I.P. addresses which was helpful.

[Paul M]

The ip address of all visitors is recorded, but atm it is not displayed anywhere, you would need your own code to query it.

[Paul M]

G'day paul, sorry to bother you again, but me thinks the cache has broken again???

i am only getting visitors again..
Yes it has broken again - I took a closer look and a product called vbBOL (Shows spiders/bots in who's online) is breaking it - the code was written for vb3.5.

To fix the broken cache run this sql query ;

update datastore set unserialize = 1 where title = 'wol_spiders'

[farooqaaa]

This is great! thanks

Installed ;)

[loonytune15]

thanks paul, I will enquire over in that thread as to why its breaking the cache all the time..

I'm hoping this can be fixed as I really like that hack..

[Paul M]

The fix is easy, to make it 3.6 compatible the datastore build needs updating.

build_datastore('wol_spiders', serialize($spiders));

becomes

build_datastore('wol_spiders', serialize($spiders), 1);

[Shazz]

Paul I know Ive already asked this, but I don't want to waste your time :)

How would I fix so it would display spiders/bots (all is yes in vboptions)
Ever since the last upgrade it stopped showing them.
Could you suggest anything I could do?

-Thanx

[Paul M]

I already answered you.

https://vborg.vbsupport.ru/showpost.php?p=1158268&postcount=361


Also read post #380.

[loonytune15]

ok Paul, I'll update the product to include that. Hopefully this works :D

[Paul M]

Version 1.14 is only a change to the install code, no need to update.

[KURTZ]

anyway i do the update :)

thx Paul

[AzzidReign]

It's been awhile since I gave you an update Paul. There was something wrong with my PHP and Apache...so we got everything back up and running fine now. The mod works like a charm with this new 1.14 update...I can finally see how many spiders have been on my site!!!

Thanks Paul!

[Al-Fateh]

great mod@! installed

[rouho1]

Hi, I have installed this hack but since I am a newbie I have this stupid question on how to access the guests track! On onine.php page nothing has been added.

[Mudvayne]

1. Admin CP > Whois Online > Enable Spider Display
2. Admin CP > Guest Tracker > Config Who Can View This Block
3. Check Forum Home
4. Smile!

[reebosak]

edit: wow, i've only had 5 posts on these forums so far? i guess i should post more :p

I have also made some minor changes to the spider detection code to try and solve the "Cannot use string offset as an array" problem that some people are experiencing. However, since I cannot replicate this error these are 'blind' changes, and I cannot say if they will work. If they don't then you can run this with spider detection disabled.

Hey Paul, i installed this mod tonight and had the "Cannot use string offset as an array" error pop up. After some debugging i found that the $vbulletin->wol_spiders is a serialized array, but the plugin code is using it as if it is unserialized. i've made some modifications to your code to unserialize() the data before accessing it and since then it's been running like a charm, afaict.

here's the modified code:
<plugin active="1" executionorder="5">
<title>Guest Tracking (4)</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[$process = false;
if ($vbulletin->userinfo['userid'] == 0 AND $vbulletin->options['trg'])
{
$scripts = explode(',',$vbulletin->options['trgscript']);
if (empty($scripts))
{
$process = true;
}
else if (!in_array(THIS_SCRIPT, $scripts))
{
$process = true;
}
}

if ($process)
{
$time = TIMENOW;
$host= SESSION_HOST;
$script = THIS_SCRIPT;
$requests = $_REQUEST;
$guest = md5(USER_AGENT.IPADDRESS.COOKIE_SALT);
$useragent = $vbulletin->db->escape_string(USER_AGENT);
$excludes = explode(',',$vbulletin->options['trgrequests']);
if (!empty($excludes))
{
foreach ($excludes AS $exclude)
{
unset ($requests[$exclude]);
}
}
$spidername = '';
$requests = $vbulletin->db->escape_string(serialize($requests));
if ($vbulletin->options['trgspiders'] AND $vbulletin->options['enablespiders'])
{
unset($agent, $vbulletin->wol_spiders, $ip);
$vbulletin->datastore->do_db_fetch("'wol_spiders'");
if (preg_match('#(' . $vbulletin->wol_spiders['spiderstring'] . ')#si', USER_AGENT, $agent))
{
$agent = strtolower($agent[1]);

$unserialized_spiders = unserialize($vbulletin->wol_spiders);
$u_agent = $unserialized_spiders['agents'][$agent];

if (false && !empty($u_agent['lookup']))
{
$ourip = ip2long($host);
foreach ($u_agent['lookup'] AS $key => $ip)
{
if ($ip['startip'] AND $ip['endip'])
{
if ($ourip >= $ip['startip'] AND $ourip <= $ip['endip'])
{
$spidername = $u_agent['name'];
}
}
else if ($ip['startip'] == $ourip)
{
$spidername = $u_agent['name'];
}
}
}
else
{
$spidername = $u_agent['name'];
}
}
}
$db->query_write("
REPLACE INTO ".TABLE_PREFIX."guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('$guest', '$host', '$useragent', $time, '$spidername', '$script', '$requests')
");
}]]></phpcode>
</plugin>

In case anybody is interested, i'm running:
vBulletin : v3.6.4
Guest Tracking : my modified version of 1.14
psiStats 2006 : 1.4.3
Spider Watcher : 1.0.0 Beta 9
Members who have visited the forum : 4.41

i've also attached my modified xml file

Edit: removed file. While I appreciate the effort, it would be a support nightmare for different versions called 1.14 to be in circulation, and the problem is a little more complicated than you think - please see my post below (Paul).

[reebosak]

upon further inspection, it appears that the "Total guests" section is not displaying crawlers, it just says "Visitors (xx)", but if i view my current users list, i see about 10 crawlers displayed there.this could be something with the settings, or maybe something left to be fixed, or un-broken (if i broke something along the way) i'll try and take a look at the code again tomorrow, for now though, sleep!

[Paul M]

After some debugging i found that the $vbulletin->wol_spiders is a serialized array, but the plugin code is using it as if it is unserialized. i've made some modifications to your code to unserialize() the data before accessing it and since then it's been running like a charmActually, the datastore fetch should unserialize it automatically - the problem is a bit more complicated - as follows ;

In vb 3.6 a new column was added to the datastore table, telling vb if the data should be automatically unserialised when loaded = a value of 0 = no, 1 = yes, 2 = detect (it tries to work it out from the contents). The entry for "wol_spiders" should be 1 - and when you install this mod, it will delete the existing entry and rebuild it with the correct value.

Now the problem is that the new 'unserialize' value is taken from the build_datastore() function (as an added third parameter) but they have defaulted it to 0 if it's not supplied. Code written for vb3.5 does not supply a third parameter (as it didn't exist) so what happens is some old code somewhere runs, and rebuilds the wol_spiders entry with an unserialze value of 0 (due to the missing parameter) - and because of this, subsequent datastore fetches do not unserialise the data, and everything breaks. (This happens a lot to the 'maxloggedin' datastore entry as well - which is why a lot of people who have upgraded to 3.6 have problems with their WOL data resetting to 1 and 1970).

I posted/requested a change to fix this here (http://www.vbulletin.com/forum/showthread.php?t=216663), but it got zero response.

I hope you understood all that - I think the solution for me will be to add a bit of code to detect if the data was unserialised correctly, and if not, do it myself and rebuild the datastore entry correctly.

[reebosak]

ah, that makes sense. around the time of my last vB update my "most users ever" date was reset to unix start time.

i'll try to grep through my installed plugins tonight to try and find out the culprit that is resetting the datastore

[reebosak]

this won't solve the big picture problem, but adding a quick check to unserialize if needed may be a good work around specific to this plugin to make it work universally. i just added a ternary check to my previously modified code:

if (preg_match('#(' . $vbulletin->wol_spiders['spiderstring'] . ')#si', USER_AGENT, $agent))
{
$agent = strtolower($agent[1]);
if(is_string($vbulletin->wol_spiders)){
$wol_spiders = is_string($vbulletin->wol_spiders)?
unserialize($vbulletin->wol_spiders)
:$vbulletin->wol_spiders;
$u_agent = $wol_spiders['agents'][$agent];

if (false && !empty($u_agent['lookup']))
{
$ourip = ip2long($host);
foreach ($u_agent['lookup'] AS $key => $ip)
{
if ($ip['startip'] AND $ip['endip'])
{
if ($ourip >= $ip['startip'] AND $ourip <= $ip['endip'])
{
$spidername = $u_agent['name'];
}
}
else if ($ip['startip'] == $ourip)
{
$spidername = $u_agent['name'];
}
}
}
else
{
$spidername = $u_agent['name'];
}
}

[Paul M]

Version 1.15 - as per the above posts, many of the spider issues are due to the spider cache being broken by other modifications - this version will check the loaded data and try to fix the cache if it has been broken in this manner. If it cannot then spider detection will not take place, meaning no errors should occur.

If you are not having any spider detection issues then there is no need to update to this version, there are no other changes.

[Shazz]

/me updates much thanx

[johnrizz]

Like always Paul, your the man! **installed**

[KURTZ]

updated!

thx Paul :)

[MeMySelfNi]

updated

[verbs]

newb question....where/how in my Admincp do I go to install this? I have 3.6.4 . Thanks!

[Shazz]

newb question....where/how in my Admincp do I go to install this? I have 3.6.4 . Thanks!

Unzip the XML and import into vB using the ACP Product Manager.

[verbs]

Unzip the XML and import into vB using the ACP Product Manager.

awesome, thanks!

[MrSquid]

I installed this and it works great - except I only see details on whoever's logged in at the moment - but the "Total number of visitors" on the main page shows how many people have been on today.

Is this the way it's supposed to work? Just curious...

[Paul M]

I don't quite understand, please post an example of what you mean.

[MrSquid]

I don't quite understand, please post an example of what you mean.

My home page shows just like your screenshot. But when I click on that icon to the left (which takes me to _____.com/online.php?who=guests) and then I click on User Agents > Yes, it only shows me who's on the site at that very moment.

Or is that what the _____.com/online.php?who=guests page is supposed to show? Right now I'm the only person on my site and this page shows my name under user ID, then...

Viewing Who's Online

65.27.80.83
Mozilla/4.0 (compatible; MSIE
7.0; Windows NT 5.1; .NET
CLR 1.0.3705; Media Center PC 2.8;
.NET CLR

[Chicago_VLNU_4s]

yeah, too bad this isn't for 3.5.4. Any idea if it ever will be?

[Shazz]

yeah, too bad this isn't for 3.5.4. Any idea if it ever will be?

Paul probablly could make a lower version for it but I think he said its unsupportive

[Paul M]

Sorry, this will not be released for vb 3.5.x

[BobbyBig]

*Installed*

One question: When a Guest logins, is he reduced from the Guest list ?

regards

[Paul M]

No, they visited as a guest, therefore they count.

[rockmyway5]

EXCELLENT - Thanx a bunch PAUL.
For anyone who's interested - 3.5.x version uploaded :)

Jacquii.

Thanks a lot.
this one worked for me :)

[Paul M]

Thanks a lot.
this one worked for me :)That's a very old version (1.04).

[Lizbaby4]

Installed.

[mktrilogy]

is it possible to track the highest number ever visitors? like the record for most number of visitors

so it will appear like

Visitors (295), Yahoo! Slurp Spiders (4), Google Spiders (1)
Most Visitors ever 1-01-07 (500)

I think that would be really cool :) thanks.

[PoetJA-1975]

is it possible to track the highest number ever visitors? like the record for most number of visitors

so it will appear like

Visitors (295), Yahoo! Slurp Spiders (4), Google Spiders (1)
Most Visitors ever 1-01-07 (500)

I think that would be really cool :) thanks.

Hmmm - I have the "most visitors ever" modification installed on my forum - Downloaded from vBH.

Jacquii.

[Paul M]

is it possible to track the highest number ever visitors? like the record for most number of visitors
https://vborg.vbsupport.ru/showthread.php?t=122425 - this will show you the most Guests if installed with this mod. The most 'visitors' is something vbulletin already tracks.


Hmmm - I have the "most visitors ever" modification installed on my forum - Downloaded from vBH.Don't know what that is - but (as above) vb already records the most visitors - so I wonder what it does.

[PoetJA-1975]

Ooops - sorry 'bout that PAUL - It was your modification I was talking about!
And it works seemlessly = Thanx!

Jacquii.

[Paul M]

Ooops - sorry 'bout that PAUL - It was your modification I was talking about!Nothing of mine is available on vbH.

[chkdgate]

Has anyone tried it with 3.6.5 yet?

[burntire]

Has anyone tried it with 3.6.5 yet?


Working fine on 3.6.5 for me.

[chkdgate]

Thank you.

[Navarre]

Currently Active Users: 49 (10 members and 39 guests)

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

Total guests that have visited the forum in the last 24 hours: 503

Visitors (50), Yahoo! Slurp Spiders (436), MSNBot Spiders (15), Google Spiders (1), Google AdSense Spiders (1)

-------

Above are the current stats I have after installing this mod a couple of days ago.

It would be nice if I could filter out the Spiders completely - From the 'Currently Active Users,' from the 24 Hour Guest Total, and from the spider list at the bottom.

As you can see, my results are very skewed by the 'Yahoo Slurp! spiders' - Which I could block, but, after doing a bit of research, it appears it would be detrimental to do so.

The mod is working otherwise, though, on 3.6.4. Thank you! Easy install!

[kingvillain]

Thanks for this, very useful info provided

[cfish]

This morning, my forum developed a database error and could not be viewed. An error ocurred in the guest table and it looks like a googlebot may have been the cause. Here's the email notification:


Database error in vBulletin 3.6.5:
Invalid SQL:
REPLACE INTO guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)

VALUES
('515a16cdb6749a9b916f78baa1b491db', '66.249.65.230', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 1173784232, 'Google', 'showthread', 'a:7:{s:1:\"t\";s:4:\"1150\";s:8:\"threadid\";i:1150;s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:7:\"forumid\";s:2:\"18\";s:6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Duplicate entry '515a16cdb6749a9b916f78baa1b491db' for key 1 Error Number : 1062

Date : Tuesday, March 13th 2007 @ 11:10:32 AM

Script : http://www.cadtutor.net/forum/showthread.php?t=1150

Referrer :

IP Address : 66.249.65.230

Username : Unregistered

Classname : vb_database


The IP address resolves to: crawl-66-249-65-230.googlebot.com

I solved the problem from the AdminCP by running Repair/Optimize Tables on just the guest table. The results of the repair are as follows:

Warning: 4 clients are using or haven't closed the table properly

Error: Found too long record (13) at 1597528

Error: Corrupt

The board is now running normally but I thought I'd flag this up in case anyone should encounter the same problem.

My question is; how could this have happened?

I am running the 1.13 version of the mod - would 1.15 have prevented this?

[Paul M]

That was a mysql error - they can happen anytime, to any table - just one of those things.

[cfish]

OK, thanks Paul.

As I was looking at the visitor stats, I noticed that the formatting is not consistent with the vB stats and with your other mods. The visitor stats do not have comas between the thousands so that values are given as 1000 and not 1,000. See the attached image for details:

61792

I know this is a bit picky but could you add the comas, I think it makes the stats more readable as well as being consistent.

[aciurczak]

It shows up with commas on mine, using this same mod, so it must be a setting somewhere in your ACP or in a template:

[Paul M]

That is actually this mod (https://vborg.vbsupport.ru/showthread.php?t=122425) - you need version 2.16 or above.

However, I am already aware that some formatting also needs adding to this at some point (the counts in the actual visitor and spider list).

[Paul M]

v1.16

As above, number formatting added to individual totals in display list.

A minor change - no need to upgrade unless you want the formatting, there are no other changes.

[iardon]

Sorry if this has been asked before but how are guests counted? Is it unique IP in the last 24 hours?

[Paul M]

vBulletin bases it on unique IP and useragent.

[daddygrim]

updated!!!!

[mcqwert]

Where exactly is it logging this info?

As far as I can see it only shows you the count of guests in the last 24 hours. If a guest is online you can see what they're doing, but as soon as they leave that data is gone.

Is it not supposed to log where every guest went? If so, where is this located?

[Paul M]

In the 'Guest' table.

[cfish]

v1.16

As above, number formatting added to individual totals in display list.

A minor change - no need to upgrade unless you want the formatting, there are no other changes.

Thanks Paul. Installed and works a treat.

[odie3]

Very nice - was looking for something like this!

Thank You!

[WAHMama]

I'm a bit confused. I installed this yesterday and it shows my board as having 3 vitors and 7 spider but when I click on the icon it shows nothing at all, no listing of IP addy's of those visitors in the previous 24 hours. Is this not an option? I was hoping I would be able to not only track how many visitors but their IP addresses so I know when my troll is back with us. Any help here would be appreciated

[Paul M]

I'm a bit confused. I installed this yesterday and it shows my board as having 3 vitors and 7 spider but when I click on the icon it shows nothing at all, no listing of IP addy's of those visitors in the previous 24 hours. Is this not an option? I was hoping I would be able to not only track how many visitors but their IP addresses so I know when my troll is back with us. Any help here would be appreciatedThere are no display or listing options in this atm, since I haven't had time to add any (I have a life outside of vb you know ;)). However, the data is collected in the table if you want to view it directly. More display features will probably get added later in the year.

[RENDY81]

Install thanks

[Itzbenreel]

Very nice. Clicky clicky

[Sir_Yaro]

Is there any chance for 3.5 version ?

[Nathan2006]

Is there any chance for 3.5 version ?


Think this might help.

Post 22 https://vborg.vbsupport.ru/showthread.php?t=131314&page=2

[Paul M]

I'm not sure it will work on 3.5 even if you manage to import it.

[Sir_Yaro]

I think he meant:
https://vborg.vbsupport.ru/showpost.php?p=1119154&postcount=90
Paul would you like attach it to your first post ?

Thank you Nathan2006 !!

[Paul M]

Sorry but no, I won't - I would also advise you not to use it (I certainly won't support it) - it is a very old version (v1.04) dating from almost five months ago.

[Sir_Yaro]

Fair enough, but unfortuatelly it's the only one that works with 3.5 so I have no choice.... :(

[KURTZ]

updated! (thx Paul)

[Paul M]

Fair enough, but unfortuatelly it's the only one that works with 3.5 so I have no choice.... :(That's fine, like all advice, you make your own decision on whether to use it, knowing that it's old and unsupported. :)

[bashy]

Hi Paul, I just installed and tried this but gave me a blank forumhome :(
Any thoughts please?

[Paul M]

No idea - but a blank screen is usually a sign of a php error - do you have php error display disabled.

[The Lord of Dip]

The best hack!

[karlm]

Is there any means to change how long (24hrs) the coverage is? I'd like to see it work for a week or perhaps couple of days (mine's a slow forum, so won't be too large on the numbers).

[Mr.Windows]

how do you install this?

[bashy]

php error disabled? where do i enabled it please?

No idea - but a blank screen is usually a sign of a php error - do you have php error display disabled.

[Paul M]

how do you install this?

As it says ;

Unzip the XML and import into vB using the ACP Product Manager.

[GrendelKhan{TSU]

question:

does this effect forum performance in anyway? like loading time for forumhome or something?

[Shazz]

question:

does this effect forum performance in anyway? like loading time for forumhome or something?

IMO, hasen't effected performance in any way,
I have seen this on low quality servers running well

[GrendelKhan{TSU]

IMO, hasen't effected performance in any way,
I have seen this on low quality servers running well

good to know.

but to be clear, by the way you are saying that... theoretically...it COULD (like if you didn't have a great server or shared hosting)? is that correct? I mean its not running any queries but maybe effects server load?

just so ppl know though, I'm really just guess here.

[Paul M]

Any modification will theoretically affect performance.

This does not have any noticeable effect that I'm aware of. I don't know why you think it isn't running any queries though - it does - it would be hard to store any data in it's table otherwise.

[dbirosel]

<i>Suggestion:</i> I don't want too many mods on my forum, so i was wondering if you can somehow integrate the number of members on this hack?

Example:

Members (13), Visitors (29), Yahoo! Slurp Spiders (15), MSNBot Spiders (3), Google Spiders (1)

Thanks!!!!

[Paul M]

Sorry, this is a mod purely for tracking guest counts.

[inciarco]

Great Add-On Paul M!! :up:

;) It'd be Great if you could make it more Flexible by including the possibility to select the number of Hours, to be able to choose a different number than 24 hours!! :up:

Like in the Add-On Cyb - Visitors in Last X Hours (https://vborg.vbsupport.ru/showthread.php?t=122999), where Cybernetec made it possible to choose a different number than 24 hours for the Visits!! :up:

Thank You Very Much!! Works Great in vb3.6.5; I hope you can make it more Flexible, to choose more than 24 hours!! :up:

:)

[GrendelKhan{TSU]

Any modification will theoretically affect performance.

This does not have any noticeable effect that I'm aware of. I don't know why you think it isn't running any queries though - it does - it would be hard to store any data in it's table otherwise.


i see. thank you for your response. :)

<< upgrade installed

[Paul M]

Thank You Very Much!! Works Great in vb3.6.5; I hope you can make it more Flexible, to choose more than 24 hours!! :up: I'm sure I could look at this at some point, but I'm not convinced that many people would make use of such an option, what other number would you want, and why ?

[karlm]

As in my last psot on this thread, I said the same asinciarco - i think it woul dbe gr8 to offer the flexibility so the hours can be set in the acp. this way, it could be pulled inline with other hacks which monitor members in the last x hours.other than that, it's a fantastic tool.

[Skavenger]

Hi, is there any way to integrate with this (https://vborg.vbsupport.ru/showthread.php?t=121883) mod?
I want to show the number of guests in the other hack

[inciarco]

I'm sure I could look at this at some point, but I'm not convinced that many people would make use of such an option, what other number would you want, and why ?

I'd like to know for example How Many Guests have visited my Forums in the last 168 Hours ( Days), because my Forums are just starting and don't have much Visitors yet. (24 Hours will show few Visitors, and could be better to show more in 168 Hours than less in 24 Hours)!! :up:

Any other addition and Information would be great, but I'd only like Flexibility in choosing how many Hours will the Information last in the Table that stores the Data!! :up:

(Perhaps in Addition you could provide a Table with the Details of Information os the Visitors, like the IP, the Day and Hour of the Visit, like in the /online.php?who=guests page, because that Information would be the one you need to store and also delete after some determinate Hours greater than the number of hours specified for Counting the Visits, to keep track of the Guests that have Visited the Forums)!! ;)

Edit: (Perhaps another Addition could be to present the Maximum Number of Visitors, Daily, and also in the Chosen Period of Time, and the Day that It Happened; that Information can be obtained based on the Periodic Counts made by the Add-On)!! ;)

My Best Regards To You, Paul M!! :up:

Thank You Very Much For Your Message!! :up:

:)

[Sean James]

Awesome work. installed ;)

[DieselMinded]

Clicked Install Thanks Make sure you let us know when you can work this feature into your other hack

Total members that have visited the forum today

That would be sweet !

DM

[Paul M]

Clicked Install Thanks Make sure you let us know when you can work this feature into your other hack
The total guests and total members mods will always remain separate.

[DieselMinded]

Ok Thanks Anyway !

This thing installed perfectly on my site took me about 2 mins, Results took about 10 mins before it kicked in and started working .... but now its doing awesome !

Visitors (117), Yahoo! Slurp Spiders (2), MSNBot Spiders (4), Google Spiders (1)

Total members that have visited the forum today: 151

My forums born on date is 3-14-2007

Im pretty happy with things so far

DM

[Almotmaiz.Net]

wooow Great Hack ^_^

click installed !!


& Arabic Language in Attachment :up:


63760

Regard's
Almotmaiz.net:cool:

[WielerArchieven]

<font color="Blue">WielerArchieven clicks install</font>

Very nice Hack/Mod Paul, thanks for the effort you put into this.

[inciarco]

Magnific Add-On!! :up:

Works Ok With vBulletin 3.6.6!! :up:

:)

[demojames]

Awesome work. I love this! Installed!

[kollam003]

great hack

easy to install and manage thanks :)

[karel1985]

today i had a really major vbulletin database error,

suddenly nothings works anymore and i about one hour i got 200 error messages in my mailbox

Database error in vBulletin 3.6.7:

Invalid SQL:

REPLACE INTO vbguest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('f683c55a3fa49581c1f9135b735fdf46', '66.249.66.6', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 1181072530, 'Google', 'THIS_SCRIPT', 'a:6:{s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:8:\"threadid\";i:0;s:7:\"forumid\";i:0;s:6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Can't open file: 'vbguest.MYI' (errno: 145)
Error Number : 1016
Date : Tuesday, June 5th 2007 @ 09:42:10 PM
Script : http://www.pc-helpforum.be/tags/index.php/skins/

the last line 'scipt' is always different, login, forum.php, etc...

for solving the prob i disabled all my producthacks and then enabled one by one
everything is working til the last one was this hack and when i enable it, again vb errors

any suggestion what happened???

[Paul M]

Your Guest table (in mysql) has crashed - run a repair on it via the ACP.

[karel1985]

Your Guest table (in mysql) has crashed - run a repair on it via the ACP.

ok i did that, mod is working fine now :-)
what should cause that? i hope it don't happen again :-)

thx !

[vitrag24]

cool
installed
but i didnt understand spider detection option

how it will work?

if i banned certain ip and that fellow in on as guest then can i know?or certain ip not banned?

wht abt this google spiders?

[Paul M]

ok i did that, mod is working fine now :-)
what should cause that? i hope it don't happen again :-)Tables crash sometimes, usually a server hiccup - that's why mysql has a repair command. :)

[Audentio]

Thanks, always have used this hack.

[PugWD]

* PugWD marks installed. :up:

One thing I noticed though, I installed the Members version first and it immediately showed users from the previous day/24hours; this one however only showed the amount from the time I installed it.
I had 54 guests online at the time but it was only showing 2 from the previous 24 hours (now showing 56 online/35 in past 24hrs, five minutes later).


Also, I notice that it takes an extra five seconds or so to display the What's Going On after the main forum list comes in. What sort of extra overhead do these two products generate?
Reason I ask is because I'm still on shared hosting but am really pushing the limits of it with the size and traffic of my forum. :o

[child_abadan200]

Thanks

[msalman]

i got a little issue, i don't know if someone else noticed it or ran into this problem. I just noticed today, it seems that on my board the google spider count doesn't increase after 1 person visits, it always shows 1. And i know that not only 1 google spider comes every day. so could someone please help me with this? thanking in advance!

[Paul M]

it seems that on my board the google spider count doesn't increase after 1 person visits
I don't understand what you mean, how is people visiting related to google spiders ?

JFYI, google does not send many spiders to forums, esp smaller ones, one spider visits and does all the work (as opposed to yahoo, which floods you with spiders).

[msalman]

I don't understand what you mean, how is people visiting related to google spiders ?

JFYI, google does not send many spiders to forums, esp smaller ones, one spider visits and does all the work (as opposed to yahoo, which floods you with spiders). I saw multiple google spiders today but in guest track it only shows one and that's what i mean.

[odie3]

Today I had this error, I took the table backup from yesterday and Drop/reCreated it. All is well now. However, any ideas why this happened?

Invalid SQL:

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

MySQL Error : Can't open file: 'guest.MYI' (errno: 145)
Error Number : 1016

[Paul M]

The table index crashed - that's just one of those things that happens with mysql, which is why it has a repair command. All you needed to do was repair it via the ACP.

[imports]

any step by step procedure on this one? i transfered the file using smart FTP to my forum folder and when i open my vb options its not there?

[Paul M]

No file transfers are required for this - you import the xml file using the plugin/product manager.

[loonytune15]

The table index crashed - that's just one of those things that happens with mysql, which is why it has a repair command. All you needed to do was repair it via the ACP.

I have the same prob, and it has happened for 3 consecutive days. If I go offline for a few days no-one will be able to access the forum.

It seems strange that this has happened to a number of people and my self 3 times in a matter of a week..

[Paul M]

I have the same prob, and it has happened for 3 consecutive days. Then you probably have a dodgy table. Backup the table, drop it, and then restore it from backup (we had to do the same here a couple of weeks ago when one of our custom tables kept crashing).

It seems strange that this has happened to a number of people and my self 3 times in a matter of a week..
There is nothing strange about mysql table faults, they happen all the time.

[UaeStar]

realy nice ^_^

[fringehead]

Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

[fringehead]

Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

Paul, I have show spiders on in who's online options. I still get no spiders just guests.

[dknelson]

Thanks for the mod! I had this working before, but not I only get (x) Visitors and no actual names of the spiders, etc.. I have removed the members who visited today hack and am just running this but I still have the same problem... Any suggestions?

Thanks,

Sean

I'm suddenly seeing this exact same problem. It has been working fine but now only showing (x) visitors and nothing else.