vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - Track Guest Visits (https://vborg.vbsupport.ru/showthread.php?t=201214)

Paul M 01-08-2009 10:00 PM

Track Guest Visits
 
As of 24 Nov 2017 this modification has been withdrawn.

This tracks the number of guests that have visited a forum each day. This isn't possible in stock vbulletin as no record is kept of guest visits, they are a 'realtime' display only. This will add (another) section to the "What's Going On" area.

Options / Features ;

* The ability to turn it on/off.
* The ability to turn just the display on/off.
* The ability to allow (or prevent) certain usergroups viewing the display.
* The ability to run the display code on all pages (not just forumhome).
* The ability to switch between 'Today' and Rolling 24 Hours display (default).
* The list of guests can be set to be always collapsed on initial view.
* The script that the Guest is running is logged (e.g. showthread, usercp etc).
* The request variables in use are logged (e.g. threadid, userid etc).
* The guest table can be cleaned of old records to help control it's size.
* Controls for the displays automatic template update.
* The datastore read (for spider detection) will read from the File/APC/Memcache/Xcache datastore [if used].
* Guest Views data collection - tracking each guests viewing of the forum index page, forums and threads.
* Guest Views data collection can be separately disabled.
* Multiple guest visits to the same page are logged separately.
* Clicking on a Guest type in the main display will list all recent visits by guests of that type.
* Clicking on the option in the guest listing will show that guests viewing data (if enabled).
* Usergroup permissions are done with the standard vbulleten usergroup permissions system.
* The option to keep a record of [and display] the most ever guests can be enabled.

Four new usergroup permissions are provided in the usergroup manager.

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

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

To install (or upgrade);
  • Unzip the XML files.
  • Upload the bitfields file to your ../includes/xml folder.
  • If upgrading from a previous version, delete the old bitfield xml file from your ../includes/xml folder.
  • Import the product into vBulletin using the ACP Product Manager.
  • Set your required permissions in the usergroup manager.
Note that by default no usergroup permissions are given, you must set them.


You can get an improved Spiders Definition file from this post.

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

Template Hook

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

forumhome_wgo_pos2

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



History:

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


SnowBot 01-09-2009 07:33 PM

hhmm great idea but i got an error

Code:

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


eh9 daddy 01-09-2009 07:34 PM

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

Code:

Invalid SQL:

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

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


KEKforce 01-09-2009 07:55 PM

same error here

Vaupell 01-09-2009 08:08 PM

Same error, dosent work.

Idawg 01-09-2009 09:55 PM

Same here

-=Leb=- 01-09-2009 10:13 PM

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

digicom 01-09-2009 10:29 PM

Same error here aswell

steven s 01-10-2009 01:50 AM

Quote:

Originally Posted by Leb (Post 1706812)
Sweet, thx for the update.
Hey guys, i didn't get any error. I just updated it from 3.7 to 3.8

Upgrade worked here too. Thanks! :up:

Paul M 01-10-2009 11:47 AM

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

Paul M 01-10-2009 11:57 AM

Try it now (3.8.002)

readjono 01-10-2009 12:48 PM

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

eh9 daddy 01-10-2009 01:09 PM

thanks, works fine now

dt_truck11 01-11-2009 12:22 AM

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

ijob 01-11-2009 08:44 AM

Hi,

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

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

readjono 01-11-2009 10:04 AM

Quote:

Originally Posted by ijob (Post 1708360)
Hi,

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

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

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

RedDevil 01-11-2009 11:48 AM

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

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

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

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

I have member tracking installed this is ok.

RedDevil 01-11-2009 12:34 PM

reverted to the older version for now.

Paul M 01-11-2009 01:30 PM

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

RedDevil 01-11-2009 03:18 PM

Quote:

Originally Posted by Paul M (Post 1708533)
Sorry, but I cannot guess at problems, I would need ftp/acp access to see what was going on.


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

Voltar 01-12-2009 01:12 AM

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

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

digicom 01-12-2009 04:57 PM

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

christon26 01-13-2009 05:55 AM

Quote:

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

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

NM figured it out lol

christon26 01-13-2009 06:05 AM

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

EricPSF 01-13-2009 10:22 PM

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

FreshFroot 01-14-2009 08:08 PM

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

Paul M 01-14-2009 09:32 PM

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

TimberFloorAu 01-15-2009 09:01 PM

Nominated for MOTM

-=Leb=- 01-17-2009 12:48 AM

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

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

I hope you update it soon lol

Paul M 01-17-2009 10:28 AM

Quote:

Originally Posted by Leb (Post 1715282)
Same error here paul, i can't even uninstall it. I get database error on everything. Like couldn't read PM or use usercp, and also i coun't vew members profile.

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

I hope you update it soon lol

Huh ?

Same error as what exactly ?

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

--- Edit ---

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

Your problem is server related.

-=Leb=- 01-17-2009 05:07 PM

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

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

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

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

One more time , sorry for the trouble paul.



Database error in vBulletin 3.8.0:

Invalid SQL:

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

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

MV Blackie 01-18-2009 08:58 AM

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

Paul M 01-18-2009 11:59 AM

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

Vaupell 01-21-2009 05:13 PM

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

Armyqt 01-28-2009 04:28 PM

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

bullet07 01-28-2009 04:54 PM

Another great addon thanks paul :)

Jon Tolzien 01-29-2009 02:55 AM

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

jesus likes pie 01-29-2009 03:00 AM

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

Just wondering.

Paul M 01-29-2009 07:10 AM

If they visit as a guest then yes.

lgnd 02-03-2009 05:49 PM

Thank You! Installed!


All times are GMT. The time now is 06:25 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02017 seconds
  • Memory Usage 1,820KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete