Track Guest Visits

[ViViD]

Hi ,
Is there any hack like this to track registered users visits ?

[Paul M]

Not at the moment.

[golfum]

Kinda having a problem. New to Vbulletin and making changes.

I have unzipped the files to my includes/xml folder

then go to the control pannel to install a new product. point to the xml file bitfield_track-guests.xml.

and it says: Invalid File Specified

Any help. I know i am doing something stupid.

I have a few things i have installed but must be missing something.

[Paul M]

You don't import the bitfields file, just copy it to the includes/xml fiolder, and import the product file.

[golfum]

You don't import the bitfields file, just copy it to the includes/xml fiolder, and import the product file.

i uploaded the bitfields file in the xml folder of includes.

and then put this in:
./includes/xml/bitfield_track-guests.xml

in the import the product file.

then get Invalid File Specified

[Paul M]

Why are you trying to import the bitfield file ?

You don't import the bitfields file, just copy it to the includes/xml fiolder, and import the product file.

[golfum]

Why are you trying to import the bitfield file ?

What product file there are two files that come across in the zip file.
bitfield_track-guest.xml
bitfield_vbulletin.xml

Thanks for your help.

[TigerWare]

bitfield_vbulletin.xml

I dunno where you got that file from, but it doesn't exist in the zip I have, the product file is called track-guest.xml and the bitfield file (to upload) is called bitfield_track-guests.xml.

HTH

[golfum]

I dunno where you got that file from, but it doesn't exist in the zip I have, the product file is called track-guest.xml and the bitfield file (to upload) is called bitfield_track-guests.xml.

HTH


YYYYEEEEAAAAAA!!!!!!!!!! You rock. I dont know where i got it from but i went back and downloaded the zip file again and that product file was there. GOT IT!
Thanks.

[popowich]

Hello,

I installed this on my new Discuss New York (http://www.discussny.com/nychat.php) Forum.

Quick question, something seems odd with the math here.

Please see the attached image. Thanks!

-Raymond

[apiasto]

nice addition,what if updating from old version?

[popowich]

DERRRRR. Most ever and total over 24hrs... long night. :eek:

[Paul M]

nice addition,what if updating from old version?


You need to be a bit more explicit with your question.

[711]

Great mod as usual Paul, installed!

One suggestion:

I prefer to only allow admins to view the page tracking features, and allow registered users only to view the summary stats on FORUMHOME. However, even though registered users cannot see the page tracking stats pages (they get the default no_permission message), a link still shows for them in the What's Going On section on FORUMHOME. It would be great if those links only were presented to usergroups that actually have permissions to view the page tracking pages.

[Paul M]

That's already been mentioned :)

It may get added in the future, possibly when this gets ported to vb 3.7.

[apiasto]

sorry i meant when upgrading the hack do i have to do the whole procedure or just over write

[Paul M]

That depends on what version you are upgrading from.

[hurik]

here the german language file for the for the 1.22 version. it only translate the frontend phrases. all the things in the admincp is still in english.

[DarthCoder]

This Crash Big Forums With Alot Of Guest Visits At Same Time

[yeku]

Thank Paul

Installed
:)

[Paul M]

here the german language file for the for the 1.22 version. it only translate the frontend phrases. all the things in the admincp is still in english.

Thanks. :)

[apiasto]

That depends on what version you are upgrading from.

i believe its 1.18

[Roberto1978]

Sorry, existing an version on Italian?

[Artes_Marciales]

Thanks!
Installed :)

[Paul M]

i believe its 1.18v1.18 was a beta version, and at least four beta's were released (with different revision numbers).

The best option would probably be to uninstall v1.18 and install v1.22 from scratch.

Sorry, existing an version on Italian?
I'm not aware of any Italian translations. You're free to provide on if you wish.

[apiasto]

ok thnx paul

[711]

Great mod as usual Paul, installed!

One suggestion:

I prefer to only allow admins to view the page tracking features, and allow registered users only to view the summary stats on FORUMHOME. However, even though registered users cannot see the page tracking stats pages (they get the default no_permission message), a link still shows for them in the What's Going On section on FORUMHOME. It would be great if those links only were presented to usergroups that actually have permissions to view the page tracking pages.

That's already been mentioned :)

It may get added in the future, possibly when this gets ported to vb 3.7.

Is there no way for me to edit the templates to accomplish this?

I scoured the templates, and finally got dizzy trying to find out how the final html output code is built in this thing lol. I even examined your XML product file and cant see where the a href links come from.

I also have your Who Visited Today mod installed. One nice feature of that mod is the ability to only show the summary stats (e.g. how it looks when collapsed).

This would be a great addition to this mod, imho. I have the two mods one on top of the other, so it would very tidy if I could get both to display collapsed for users, while the admins can use the full functionailty.


Anyway, great work on your mods, always top notch. :up:

Happy Turkey Day!

[Paul M]

Is there no way for me to edit the templates to accomplish this?



Nope, if there was, it would already be done.

[711]

Nope, if there was, it would already be done.

Ahh ok. Looking forward to the next version then ;)

Also, any thoughts on including this feature that you use in Who Visited Today mod?


I also have your Who Visited Today mod installed. One nice feature of that mod is the ability to only show the summary stats (e.g. how it looks when collapsed).

This would be a great addition to this mod, imho. I have the two mods one on top of the other, so it would very tidy if I could get both to display collapsed for users, while the admins can use the full functionailty.

[Danny Diamond]

reinstalled. thanks babycakes:eek:

[Danny Diamond]

I have looked everywhere. How do you change it from this.............

https://vborg.vbsupport.ru/external/2007/11/3.gif (http://www.monksdiner.com/entertainmentforum/#top) Total members that have visited the forum in the last 24 hours: 57 https://vborg.vbsupport.ru/external/2007/11/3.gif (http://www.monksdiner.com/entertainmentforum/members/list/)) (http://www.monksdiner.com/entertainmentforum/members/-85-.html)https://vborg.vbsupport.ru/external/2007/11/3.gif (http://www.monksdiner.com/entertainmentforum/#top) Total guests that have visited the forum in the last 24 hours: 123 https://vborg.vbsupport.ru/external/2007/11/3.gif (http://www.monksdiner.com/entertainmentforum/online.php?who=guests)The most guests online over 24 hours was 123, Today at 07:36 PM.
Visitors (51) (http://www.monksdiner.com/entertainmentforum/misc.php?do=guestlist&type=Visitors), Yahoo! Slurp Spiders (69) (http://www.monksdiner.com/entertainmentforum/misc.php?do=guestlist&type=Yahoo! Slurp), AskJeeves Spiders (1) (http://www.monksdiner.com/entertainmentforum/misc.php?do=guestlist&type=AskJeeves), Google AdSense Spiders (1) (http://www.monksdiner.com/entertainmentforum/misc.php?do=guestlist&type=Google AdSense), Google Spiders (1) (http://www.monksdiner.com/entertainmentforum/misc.php?do=guestlist&type=Google)



To this...........................(where the guests show right after the members)

http://wrestlingsociety.net/forums/images/greenfox/buttons/collapse_thead.gif (http://wrestlingsociety.net/forums/#top) Users active in the past 24 hours: 118 (58 members and 60 guests) http://wrestlingsociety.net/forums/images/greenfox/misc/whos_online.gif - (http://wrestlingsociety.net/forums/members/3-16.html)



Many thanks for anyone that can help

[cyberws]

Cool mod. We really need something like this as the spiders visit often and wanted a way to track the information from within VBulletin instead of web log files.

Good job!

[SSG.D]

Installed: on 3.6.7 However the usergroup permissions did not seem to install Need some advise I really want this to work. ::)

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.

Thanks to anyone that can help

[mmmender]

I tried to install this on 3.6.8 but during the product install the screen just freezes at "Rebuilding Spider Cache"

Any ideas?

[Paul M]

Installed: on 3.6.7 However the usergroup permissions did not seem to install Need some advise I really want this to work. ::)

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.

Thanks to anyone that can help

Did you upload the bitfields file to the correct place, before you imported the product ?

I tried to install this on 3.6.8 but during the product install the screen just freezes at "Rebuilding Spider Cache"

Any ideas?

Nope, no idea.

[DePhauEll]

Hello,
where do I import the German XML-file, which hurik postet here (https://vborg.vbsupport.ru/showthread.php?p=1385038#post1385038)? I used to know that, but I'm getting old. :o

[Paul M]

The file only contains phrases - so I would assume you cut/paste them over the top of the english phrases in the main xml.

[SSG.D]

Thanks Paul !! got it, works great now!:)

[DianaDiana]

Hi! I am new to the Vbul world!
I love it but some times I have a hard time getting things lol
I have this mod installed and added. It's showing up in my acp already.
It's just not showing up on the main index page. This is what I have.

What's Going On?
Currently Active Users: 2 (2 members and 0 guests)
View Who's Online
Most users ever online was 3, 20 Hours Ago at 09:42 AM.

Total members that have visited the forum today: 2

The most members online in one day was 4, 1 Hour Ago.

Statistics
Threads: 0, Posts: 0, Members: 4
Welcome to our newest member,
Upcoming Events for the Next 60 Day(s)
Calendar

I set my permissions so that unregistered could see the main index page. That is all they are able to see.

Please help me! I love this mod!

[needaltuna]

Fantastic, greatly useful mod.

Installed!

[Paul M]

I set my permissions so that unregistered could see the main index page. That is all they are able to see.


Not really sure what you mean by this. Have you set the usergroup permissions for this modification (it has it's own).

[DianaDiana]

Never mind, I am a dumbass. I figured everything out. Sorry!

[thefullmaza]

install and thanks Demo (http://thefullmaza.com)

[JohnUK]

The new section did not install into the forums.

[katan]

thanks you Paul M!!!

[netzrate]

Thanx fro this cool Hack in the new Version!
I use the old Version, but the new is very GREAT!!

[micky007]

i have installed this on my forum but it is not being displayed.

PM sent with the URL.

[Chance4Today]

i have installed this on my forum but it is not being displayed.

PM sent with the URL.
You need to enable it by going into

Admin CP>Vbulletin>Track Guest>

Also per

Admin CP>UserGroup>and edit each usergroup on it

[dartho]

I'd really like to see referrer information in this add-on also if possible?

[Saviour]

I have this installed...great mod!

What I'd like to see addressed, if it hasn't been already, is the fact that when you click on any number next to Visitors, bots, etc., etc., the page opens in the parent window with no navigation menu.

I didn't feel like searching through all the pages of this thread to see if it has been addressed, but definitely something that needs to be fixed in the next release...if any.

[Paul M]

What's to fix exactly ?

[Vinyljunky]

Paul,

Thank you for sharing another great mod!

VinylJunky

[Saviour]

What's to fix exactly ?

What I'd like to see in the next release...

Your mod will list the number of vistors and bots...if enabled, correct? When you click on this number, you'll see the complete list of visitors and/or bots that have visited for the day or the last 24 hours...whatever you have enabled. This page opens in the parent page of the forum...with no header, navbar, or footer.

I'd like to see my header, navbar and footer...know what I mean?

[Paul M]

I don't really see any point in wasting loads of screen space with headers and footers on that page.

[Paul M]

I'd really like to see referrer information in this add-on also if possible?Interesting idea, I might think about that.

[Saviour]

I don't really see any point in wasting loads of screen space with headers and footers on that page.

I don't understand your reasoning...

What do you mean by "loads of screen space"? I'm simply talking about adding a forum's header, navbar and footer...so that the page follows the flow of the forum your mod is implemented on.

[Paul M]

I don't understand your reasoning...
Not much i can do about that I'm afraid.

Sorry, but I have no plans to change it as I'm quite happy with it as it is. :)

[Saviour]

Not much i can do about that I'm afraid.

Sorry, but I have no plans to change it as I'm quite happy with it as it is. :)

Don't get me wrong...I'm happy with it as well...

I just would like to know (if you don't intend to change it) how I can get my header, navbar and footer to display on the Guestlist template.

[Dream]

Referrer information would be nice.

[Saviour]

I don't really see any point in wasting loads of screen space with headers and footers on that page.

This being the case, then why have the Guestlist open in the parent window...

Why not have it open in a "new" window?

[Mr.Danko Jones]

My version of this plug-in crashed my vBulletin about half a month ago. Search my posts to see my earlier thread.

I am considering re-enabling the plug-in and see if it crashes again. It was fine for at least a month with no problems. Is a new version forthcoming in 2008?

[Paul M]

Crashed ?

[Chance4Today]

Well I went back to the 3.6.8 version and got it all working nicely and had a problem later on not with this hack just my silly azzz self and the only way that I could figure things out was to upgrade to 3.7.0 beta 3 and it fixed my template issue but I lost my hack on this. I can not wait for the new release! Any ideas when? :)

[Paul M]

Sometime in the next few weeks.

[Lombardo]

Thanks for this.

[newtsys]

it might be me or I missed something . It does not display anywhere on my forum .I have checked settings all are enabled but still nothing...any suggestions.

[Chance4Today]

Sometime in the next few weeks.

WHOOO HOOOO I don't party anymore but I might go out and give my dog and I a ice cream LOL Thank YOU!:up:

[Chance4Today]

it might be me or I missed something . It does not display anywhere on my forum .I have checked settings all are enabled but still nothing...any suggestions.

Have you gone into each usergroup and clicked yes to all? It won't show up until that is done.

[newtsys]

Chance4today, thanks I did over look that all is working fine now thanks again.

[S7rik3R]

Cool this is really handy ...

*Installed*

[afmarko99]

I had an older version installed just fine but the new version I am having trouble with.

What setting in usergroups do I need to set to yes? I can't find any new options in my adminstrator group and I currently don't see the stats on my forum. Also what is the bitfield_track-guests.xml file for? Do I need to upload this file somewhere?

[Paul M]

The instructions are in the main post, just above the history. It won't work without the bitfield file.

[SEOvB]

workd good on 3.7b3 if you change the max version in the product xml :)

[afmarko99]

The instructions are in the main post, just above the history. It won't work without the bitfield file.

Sorry for the durka durka jihad move on my part.

Thanks, it works as advertised now.

[Snake]

Thanks for the release, but is there a possibility to integrate this hack with the Members Online Today? I mean, merge both of the hacks to have them as a one single product.

[Paul M]

Nope.

[vNew]

Hi, Paul:

I just installed your guest-tracking vB mod on my new vB. Thanks for making it available.

After installing the guest-tracking mod, I found:

vB's What's going on says: 1 member, 1 guest. [This is correct]

But your vB Mod says:
Total guests that have visited the forum in the last 24 hours: 0 [This is not correct].

I wonder if the discrepancy is due to the fact that the time frame is different.

Ideally, the two should agree,
i.e. Total guests during the last 24 hours should be >= 1 in this case.

Regards,
vNew

[Paul M]

Guests will not be counted (by this) until they actually view something. Your guest had not looked at anything yet (only before you installed this).

[voter]

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
");
This query takes sometime 25 seconds in my forum? Any idea what it could be or better how I can solve the problem?

[Paul M]

Not without full access to our forum and database to run test queries.

[voter]

Seems I found it, the table was too big, 30 days guest tracking for my forum with 10thsnd per day:eek: I change it to 3 days, but, I will come back to your proposal check my forum if it not help.:)

[Paul M]

30 Days !!

This is only designed for tracking/displaying one day - the cleanup is set to 2 days by default.

[jpbryan]

Great!! Thanks..

[dartho]

Any chance of adding in AJAX IP address resolution? I manually edited the Display_Guestlist_Bit and changed

<if condition="$show[trgips]">
<td class='alt$altclass'>
$guestlist[ipaddress]
</td>
</if>


to


<if condition="$show[trgips]">
<td class='alt$altclass'>
<a href="online.php?$session[sessionurl]do=resolveip&amp;ipaddress=$guestlist[ipaddress]" title="$vbphrase[resolve_ip_address]">$guestlist[ipaddress]</a>
</td>
</if>


which links to vBulletins resolve IP address page and does the job, but AJAX resolution in the same manner as vBulletin's "Who's Online" would be nice ...

If you do get the time and inclination to update, don't forget my request for referrer information ;)

Thanks for your work :up:

[REVHEAD]

Will this help me attract more visitors? should I enable all user groups to view this?

BTW I have vbseo installed does this mod have any posotives tioward rankingss and actually pple viewing the forum?

Should I enable any spider features? if so why would I ?

Sorry guy this is my forstime setting up and running a website.

[Dream]

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

[BucShot]

also instead of just Total guests that have visited the forum in the last 24 hours: 17 could you change it so it is Total guests that have visited the forum in the last 24 hours: (15 visitors and 2 search engine spiders)
A clean and simply total guests and total spiders would work well for me too. Is this option possible?

[Dream]

What the spiders in the spiders list are sorted for? Yahoo Slurp always appears at first.

[kfiasche81]

it's compatible with 3.7 ?

[Paul M]

There is a seperate 3.7 release.

[binkuang]

i install the guest track hack...but why it doesn't show up on my forum page. it that i have to disable the whole modification to prevent this?

[Paul M]

i install the guest track hack...but why it doesn't show up on my forum page.
No idea, maybe you have a custom style.

it that i have to disable the whole modification to prevent this?
Sorry I dont really understand what your saying.

[Realbigsource]

Hello forum mates...

I'm having a little problem with this mode, I installed everything ok but no stat is showing on the home page...the instatlltion instruction state I should do the follloing below but i'm not sure what to do in the usergrup manager. any help?

Set your required permissions in the usergroup manager.

[Realbigsource]

I'm not seeing the below in the usergroup permission:

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

[mark|3]

is there anyway to track member's visits?

[Kadi]

Hi,

I had v1.16 installed and it's been working just fine. I just updated to the latest v. and now its diappeared from the forum.

What am I missing?

[Paul M]

Did you follow the install instructions in the main post ?

[Kadi]

Set your required permissions in the usergroup manager.

Found the permissions. Working perfectly. Thanks. :)

[SuperNissans]

I am a super n00b. Please help.

Installed this on 3.6.8

Cannot see it anywhere. I am sorry, I must be dumb, but I am not sure what settings I am supposed to set on this. I went to VBOptions and set it up correctly there, but what permissions exactly do I need to change in the usergroups?

[Goomzee]

wow nice Mod

[Paul M]

but what permissions exactly do I need to change in the usergroups?
The Guest Tracking permissions.

[bluidkiti]

What if I wanted to put this somewhere else besides the What's Going On box - let's say inaa left side column on my board. How would I do that?

[bluidkiti]

What if I wanted to put this somewhere else besides the What's Going On box - let's say inaa left side column on my board. How would I do that?

Never mind - I figured it out myself. :up:

[steveneff]

Thanks Paul very nice mod
Couple of questions about the following setting

"Change this if you want this modifications code to run on all vb pages, not just the forum homepage."

Just wanted to check, does this option if set to No not count visitors that land in a thread and not visit the Forum Home?

If set to yes does it use up much bandwidth/cpu and all that stuff.

[Paul M]

That option actually refers to the display code only. All visitors are counted, no matter where they visit.

[transpetaflops]

Where is the value for "most guests online over 24 hours" stored? I've blocked Yahoo Slurp now and would like to reset it. Search through this thread but couldn't find anything mentioned. Anything special to consider before I do the reset?

[transpetaflops]

Replying to myself here. Not a mysql expert but trying to learn... I found this:


mysql> select * from datastore where title = 'maxloggedin';
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
| title | data | unserialize |
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
| maxloggedin | a:4:{s:13:"maxguestzdate";i:1208349349;s:9:"maxguestz";i:233;s:9:"maxonline";i:2;s:13:"maxonlinedate";i:1208350033;} | 1 |
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
1 row in set (0.01 sec)


The "maxguestz" value of 233 is probably the one I need to reset. What puzzles me is that I used the following command to reset the regular max users statistics:


UPDATE datastore SET data = '' WHERE title = 'maxloggedin'


But I fail to see how this command was able to successfully reset only the "maxonline" value since I see no references to it. I would assume that command would wipe the complete record which it didn't do obviously. I'd be most grateful for an explanation and a pointer to how I can modify the command to reset the Guest Tracking stats.

[transpetaflops]

The UPDATE command actually DOES empty the record as expected but something restores the data a few seconds later... now I'm completely confused ;-)

[transpetaflops]

Ah, I guess the data is being restored by the information in the guest table so I have to wait 24 hours before I clear that field. Sorry for the noise.

[Hawaiian-TV]

First of all, thanks for this hack. If it's really working right, we love it.

I hope this hasn't been answered before...

I can't tell right now when the 24 hour "day" begins and ends. It seems at times like the number of visitors in 24 hours goes DOWN in a day rather than up. Please explain!

[Paul M]

The 24 hours is real time, 24 hours back from when you load the page.

[JKatz]

Love it! Thank you!

[reverse1312]

Hello Paul,

It's a very nice hack !!

Would it be possible to add manually some new spiders IDs ?
I'm in France and we have some spiders that are not among the listed SE spiders...
It would be great to be able to add them manually.

Thank you

[Paul M]

The only way to do that is to edit the spiders file, make sure you keep a copy if you do (for when you upgrade vb).

[reverse1312]

Thanks I'll try that ;-)

Nice job !!!

[reverse1312]

I clicked "installed" ;-)

Edited the spider xml file as you said it's really cool now I can trace more precisely spider real activity :-)

Something I try to understand :

When a visitor is unlogged (cookie erased) he counts as an unlogged guest.
If he logs in. He counts as a logged in visitor and as a guest (he was).
If he erases cookie again, He counts as 1 logged in visitor + 1 guest (same IP)

Correct ?

I wonder how is it possible that Google Bot can be logged and not logged at the same time ?. It has no account on vB... (see attached img)
What doest it mean in that case ?
If it's just the fact that the request of any page has been recorded on the apache access log, I think every visit is logged anyway in that particular sense.
So I'm a bit confused about that...

Thank you

[Paul M]

Logged means the detailed visits logged, only visits to the homepage, forums and threads are logged, anything else is not.

[ArnyVee]

Works great on 3.6.8! :)

I took a quick glance at the add'l list of spider definitions and noticed that all of them (I went through about 50) were all listed in my xml file. If I were to add the whole list, will the duplicates just work their way out or will I have the same spider showing up twice as a duplicate?

[Paul M]

They should only be counted once.

[voter]

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



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???
Same staff happen to me not once.

REPLACE INTO vbguest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('27afa7c9d161e4eadc7ee2bfda9d874b', '91.103.25.142', 'Opera/9.27
(Windows NT 5.1; U; ru)', 1212415507, '', 'adv_index',
'a:6:{s:1:\"s\";s:0:\"\";s:6:\"postid\";i:0;s:8:\"threadid\";i:0;s:7:\"forumid\";i:0;s:6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Duplicate entry '27afa7c9d161e4eadc7ee2bfda9d874b' for
key 1

I found out that it happen at same time as I was backuping my database. Seems for host server it was to much staff to do all databse replacements read etc staff at once.

Paul could it be that one escpae such errors when Duplicate entry escaped by generating the ids for guest more randomly or just escape the usage of REPLACE. INSERT will be ok and it is in not important to replace the information of already existing guests. Sure one will count them same guest more than once, but at least the error will not come out.

[Paul M]

Thats some sort of mysql problem/bug - it should be impossible to get a duplicate key error using RELACE INTO - the whole point is that it updates the found key - I would suggest you run a repair on the guest table, it may be corrupt in some way.

[voter]

Thats some sort of mysql problem/bug - it should be impossible to get a duplicate key error using RELACE INTO - the whole point is that it updates the found key - I would suggest you run a repair on the guest table, it may be corrupt in some way.

Sure the reason was corrupted guest table, and after repairing SQL everything is ok.
My thought was to find a way to escape such a situation again.

I think the scenario is - during database backup, which is hard staff for server, the REPLACE comes and mysql starts to writes the data, but it do not mark it as finished and send any answer to your script for a long time and same request comes once more. Then one have same REPLACE query doubble in query.

[Paul M]

Replace just does an Insert, or Delete & Insert if the key exists.

If vb3.7 required mysql 4.1 or above then I could look at the "Insert ... On Duplicate Key Update" for the 3.7 version - however it only required 4.0.16 or above, this version needs to run on any mysql 4.0.x (and even mysql 3.xx) as well.

[fpattberg]

Hello.

I know that there is limited support on this plugin now but I have had the situation that suddenly (since yesterday) somehow there are now spiders shown next to my regular visitors.

My site: http://www.sustainabilityforum.com/forum

Has anyone an idea why that could be the case? Have I missed something? Are there no more spiders visiting my site?

I am using 3.6.7 PL1 but that should not be a problem right?

Please help.

Thanks.

Fabian

[Paul M]

Maybe your spiders cache has got corrupted, try running this and then waiting a few hours ;

DELETE FROM datastore WHERE title = 'wol_spiders'

[fpattberg]

Okay.

I am getting a not allowed message. Do I have to get permission from my hosting provider?

In the vbseo forum they said that I had a robots.txt problem.
But I have no robots.txt on my ftp root and still it shows up:
http://www.sustainabilityforum.com/robots.txt

What is wrong with this?

Please help.

Thanks.
Fabian

[Dean C]

Hi,

Just installed this. Does it take a few hours to begin showing on the forumhome? I installed it, checked everything was turned on in the vB options and the block isn't showing up on forumhome. Note: I am running a completely stock vBulletin style.

Ack: permissions for admin were all set to no :) Nm

[Philster]

Dean, have you enabled spider display and guests in 'who's online' options of your admincp? Also have you ftp'd the latest spider.xml file to your forum?

Phil.

[Welshy2008]

Great Hack - Thank You Paul.

[ggregg13]

how do l do this exacly lam new to this Upload the bitfields file to your ../includes/xml folder thanks ggregg13

[Paul M]

Upload the file using ftp - or whatever method you used to upload all the other vbulletin files.

[Vackrick]

Make One For 3.7.3 pls

[Masiello]

Make One For 3.7.3 pls
Hi dude,
you find it there: https://vborg.vbsupport.ru/showthread.php?t=167278
it's write in the first post on this thread.

[Welshy2008]

Hello Guys, Does anyone know of an addon? that would accompany this mod with regard to "Spiders" Please? I have the ususal spiders showing, (ask Jeeves, Google, Yahoo) but I would like others on there to show too.

I like the new one that was released in July 2008 - Cuil


Many Thanks.


(PS. Is there a way for me to manually enter them if nothing is available, Please?


EDIT: http://www.vbulletin.com/forum/showpost.php?p=565415 D'oh.

[reverse1312]

Hello,
Is there any mean to get an idea of how many pages in 24 hours have been visited by spiders ?
My worry is to be able to say how many of my pages are read by real people against how many by Google and others.
Thank you

Martin

[Paul M]

Sorry, this counts visits, not viewed pages.

[Forum-Germany]

Hello. :)

The Zip file contains 2 files. Once "bitfield_track-guests" and even "track guests." Both files into. / Includes / xml folder or only one? and which of the two files is the product files?

are bots (search engine) is also counted? I can somewhere a statistic or so to see how many people there were real and how much search engine? You can also see what search engines were there?

apologize if this question has been asked, my English is very bad.

[Forum-Germany]

I can not help? :o

[dartho]

The bitfield_track-guests.xml file gets uploaded to your xml directory, the Track-guests.xml is the product file which you need to install .

[Forum-Germany]

achso thank you. :) What can still answer the other question? would be really nice. :)