psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x)

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*===================================*\
|| psiStats 2009
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 3.5.x - 3.8.x
|| Released : Feb 28, 2010
||
|| Time required to install: 1 minute
|| Difficulty: easy
\*===================================*/

DESCRIPTION

A sophisticated statistics module for your vBulletin board.

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

STATISTICS

File Uploads: 1
Products to Install: 1


FEATURES

Statistics Tracking:

• General Board Statistics
• Style Usage Statistics
• Top Threads & Forums Statistics
• Display Colors + Resolutions (Requires JavaScript) Statistics
• Countries + Regions Statistics
• Browsers + Operating Systems Statistics
• Referring Sites Statistics
• Referrer Statistics
• Age & Gender Demographics

Features:

• No code or template modifications required.
• Modules can be enabled or disabled, as needed.
• Statistics are updated every fifteen minutes via cron.
• Mother site, e.g. the site where your forum is hosted, will never be listed as a referrer.
• Only one extra query per forum page.
• Statistics can be sorted either numerically or alphabetically.
• Automatic Integration with Referrer Statistics (if installed)[/i]
• Configurable number of last items for top threads / forums.
• Allows to specify whether to show data from from forums with post counts disabled.
• Configurable number of last items in referring site statistics.
• Configurable gender field and responses (optional).
• Configurable list of usergroups that can access statistics (optional).
• Referring site statistics censure (by word) and individual site blockage.
• Detects most popular browsers and operating systems.
• Requires cookies for screen color depth and resolution tracking.

VERSION HISTORY

1.6.2 - stable
[+] Added recognition for Windows 7-based user agents.

1.6.1 - stable
[+] The navbar link is now shown only to those who can access the statistics.

1.6.0 - stable
[+] Added two new modules:

• Referrer Statistics
• Age & Gender Demographics

[+] Added Google Chrome recognition (this includes a matching icon).
[+] Added Setting to control whether top threads & forums data is gathered from forums where posts are not counted towards user post counts.
[+] Updated ip to country databases to the most recent ones.
[F] Corrected a few phrasing bugs and phrased things that were not phrased in 1.5.2.

1.5.2 - stable
[+] Added a few more translations (thanks to those who submitted these).
[+] Fixed a few bugs that were mentioned for 1.5.1.

1.5.1 - stable
[+] Added option to globally enable / disable any stats modules.
[+] Fixed bug with some staff being counted twice.
[+] All numbers are now nicely formatted.

1.5.0 - stable
[+] No more template edits, just upload the files and the product and you're ready to go.
[+] vBulletin 3.5.x - 3.8.x compatible.

1.4.4 - stable
[+] Referrering Sites now have a JS and an XML feed capability.
[+] Added a better firefox icon into the icon database.
[F] Fixed a couple of minor bugs.

1.4.3 - stable
[+] The hack now respects vBulletin's "Show Active Users" setting.
[+] The hack is now valid XHTML (all templates must be reverted).

1.4.2 - stable
[+] Corrected a bug, which caused incorrect number of moderators to be displayed.
[+] gb.gif renamed to uk.gif.

1.4.1 - stable
[+] The front page has been revised, and it now loads four times as fast regardless of the size of your database.
[+] The ip database has been updated to the revision of October 18, 2006.
[+] The flag database has been updated to the revision of October 18, 2006.
[+] Referrer statistics hack, if installed, is now detected automatically. No configuration required.
[+] Added an option to specify a custom board creation date, if not reflected correctly by the joindate of a user with lowest userid.

1.4.0 - stable
[+] The system is now cross-compatible with both vBulletin 3.5 and 3.6.
[+] The ip database has been updated to the revision of August 30, 2006.
[+] A variety of code optimizations and template corrections have been done.
[+] To keep statistics legible, the engine now only tracks the major and the minor browser versions. X.Y.Z.E is now stripped to become X.Y.

1.3.2 - stable
[+] Since more browsers support cookies than ajax, screendepth/screenresolution tracking is now done via cookies.
[+] One less query per page - e.g. now it's only one query per page.
[+] Statistics are now updated every 15 minutes rather than every hour.
[F] Fixed faulty count in cron and in region stats screen.
[F] Fixed bug which prevented the cron from being created in some cases.
[F] Fixed minor bugs which caused errors of the E_NOTICE level.

1.3.1 - stable
[F] Fixed AJAX coding error, which used synchronous ajax instead of asynchronous, evidently causing higher load.
[F] Fixed WOL error that was caused by AJAX stats update and that made it look like everyone is browsing the stats.
[F] Fixed a query in update cron.

1.3.0 - stable
[+] Yay, no more file edits!
[+] No more multiple queries. The hack now takes up a maximum of two (2) queries per page in contemporary browsers, and one (1) query in non-javascript browsers.
[+] New vBulletin Option: Statistics can be configured either numerically or alphabetically.
[+] Since Opera is updated way too often, the engine, from now on, will only identify the primary version marker (7,8,9 as opposed to 7.01, 7.02, 7.21, 8.01 etc).
[+] Templates and phrases are now in their own separate group.
[F] Eliminated a bug which prevented bot identification from working properly.

1.2.8 - beta
[+] Removed 5 queries during the stats recording.
[+] Countries mapped to valid cia abbreviations and the countrybit template has been updated.
[+] Added missing Fiji flag (Thanks to firstrebel!)
[F] Eliminated a bug which prevented the thread and post limit from having any effect.
[F] Eliminated a bug which prevented the browser identification from working properly in some cases.

1.2.7
[F] Corrected online users count.
[F] Corrected staff count.
[F] Eliminated the style stats bug, which originated from users who had invalid styles saved in their profiles.
[F] Eliminated the posts per day bug.
[F] Renamed "gb.gif" to "uk.gif"
[F] Renamed "Oceania" region to "Australia and Oceania".
[F] Only threads and forums to which the user has permissions are displayed in top threads and forums.

1.2.6
[F] Minor template fix.

1.2.5
[+] Rewritten Browser and OS detection (previosly somebody else's module was used).
[F] For staff stats, only primary usergroups are now counted.

1.2.1
[+] New "Usergroups Allowed To View Stats" admincp option.
[+] Navigation split in two rows, for greater view
[+] Crawlers now have a browser picture associated with them.
[F] Eliminated Tracking of Empty Referrers.
[F] Updated country database with a number of missing countries, including UK.
[F] Minor fix to style statistics screen, applying to styles that are not used.

1.2.0
First Official Release.

1.1.0
Development release; Excess queries, phrases, and code has been removed.

1.0.0
Development release; All phrases that were hard-coded were moved into the phrase system.

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL

[PoetJA-1975]

hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

[akanevsky]

Originally Posted by PoetJA-1975

hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

Hmm, it should have been added. The is_newer_version() function of vBulletin seems to be buggy though... Anyway, please run the following query to create the cron:

[SQL]INSERT INTO `cron` VALUES (NULL, 1136665500, -1, -1, -1, 'a:1:{i:0;i:25;}', './includes/cron/psistats_update.php', 1, 'psiStats 2006 Update (15-Minute Interval)')[/SQL]

[PoetJA-1975]

Well - I did the query and the cron updates - But I've seen numerous DB errors:

Database error in vBulletin 3.5.4:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user '********' to database '*******'
Error Number : 1044
Date : Sunday, October 8th 2006 @ 10:34:41 PM
Script : http://jpicforum.info/cron.php?&rand=39200
Referrer : http://jpicforum.info/search.php?searchid=3347
IP Address : ************
Username : Unregistered
Classname : vB_Database

I actually have spent the last hour or so reading this entire thread. Seems others have had similar probs and one of the solutions was to comment out a line in ...includes/functions_cron.php

PHP Code:

$vbulletin->db->close(); 


In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???

At anyrate - I'd love to have this working for my board, as it is a fabulous idea and could really help me in future promotional activities!

So HELP! And if you call me a dummy - I'm actually inclined to nod my head in a gesture of YEP lol - Don't know much about the coding thing - But seriously - would love to have this one working

Thanx again for providing such a wonderful addition - Just want it working properly!

Jacquii.

[akanevsky]

In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?

Please read the FAQ post, 2nd in this thread.

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???

Different IP - People have different IPs.
Different Username - People have different Usernames, too. It doesn't only happen for you.

[PoetJA-1975]

OH - But I think I'm special
OK OK OK - I suppose I will contact my webhost about the lock table DB error.
At anyrate - thanx for not cursing me out and adding to your ignore list LOL
I will let you know the status when I hear back from my webhost - Thanx for taking the time to remind me about the faq :P

Jacquii.

[PoetJA-1975]

Hey PSIONIC - thanx very much! It's working 100% now and is an AWESOME addition to JPiC!

Really nice work - cheers!

Jacquii.

[jwashburn]

Originally Posted by 3z3k3l

Wow can someone tell me what happened?
I have 1500 email messages from this database error, I logged in via phpmyadmin and empted the table and things seem to be back to normal.
I have made no changes to the site in the past 24-48 hours, it looks like a bot or something messed with the stats somehow.

Will this happen again? Anyone know what happened, thanks!

I have the exact same problem and the table are gone completley. I have tried making them by hand with no luck. I have tried the diable hooks plan, but then I get new errors. I still cant get into my admincp to fix it.

I am down for 2 days now.

Any ideas on how to get it out

[akanevsky]

I cannot help unless you post the specific error message that you are seeing.

[akanevsky]

<a href="https://vborg.vbsupport.ru/showthread.php?t=130551" target="_blank">Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks.</a>

[JohnBee]

What is the Human Referer option(link) in the Stats selections?
Whenever I click on it I get an invalid page. I installed the Human Referer Hack but it did not change the outcome.