Major Additions - 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

[nonet]

Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?

[akanevsky]

Originally Posted by 711

I tried that edit, which produces this error:

Database error in vBulletin 3.6.4:

Invalid SQL:
-86400
		AND forumid NOT IN (0)
		ORDER BY views DESC
		LIMIT 10;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-86400
		AND forumid NOT IN (0)
		ORDER BY views DESC
		LIMIT 10
Error Number : 1064

Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)

Originally Posted by nonet

Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?

Check vBulletin user activity settings. Perhaps they are off or set to 0.

[711]

Originally Posted by Psionic Vision

Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)





Check vBulletin user activity settings. Perhaps they are off or set to 0.

That worked great, thanks!

I just noticed that this query as edited doesn't pull the threads with the most views or replies in the last 24 hours, but rather pulls the threads with the most view or replies all-time that were active in the last 24 hours (lastpost).

But it's close enough


Thanks again.

Great work on this hack, my members love it.

[Makc666]

I was wrong in my description.
On the main stats page (psistats.php) the date is displayed in correct format:
dd/mm/yyyy

But in ACP in psiStats 2006 section there is a BUG with how a date must be entered.

As description says:

Date of Creation of Your Board
... please specify the correct date here is dd/mm/yyyy format.

But for now that field is parsed in format:
mm/dd/yyyy

In other words on the main page is:
25.10.2002

And in ACP you have to enter for now:
10/25/2002

Please, can you update it to correct format:
dd/mm/yyyy

Thanks

[aggiefan]

great script.... its very cool to track the stats.

one request and i dont even know if it is possible but 98% of our requests are from within the US so that doesnt help us a whole lot. Would it be possible to break that down by state (start with the US and add other countries when needed). Im sure this is something we would all love is a breakdown of even more specific data. (maybe replace the country info link with a state breakdown) or add a small link next to it with each countries hits broken down by area (ie states for the US)

[AzH]

Originally Posted by Psionic Vision

The reason it is not updated is because when user chooses a style using the switcher, it is not saved to his or her account. It is only stored in his or her cookie. The only way to fix this would be to have vBulletin save the style to database, but I am not sure that alterting vBulletin's behavior is the best way to go in this case.

https://vborg.vbsupport.ru/showthread.php?p=1137190 - Possible fix for this issue. It might be something you can incorporate. I'm going to re-install psiStats to see what happens. Will let you know.

[halpern]

Is there a stats pluggin that can be placed in a vbadvanced module? Can this one?

[Cybershaolin]

Excellent mod.

My moderating team is showing correct but with this mod, I get all my supermods as admins because I let them use some parts of the admincp.

I also noticed many other users having problems with the different part of moderators or supermods.

One suggestion: Why don't you use the same settings than the mod team page use in order to reflect exactly the same information?

[McCarroll21]

This is a great mod, my only problem is getting screen resolutions and color depths to show up. Everything else is working, and I waited the 15 minutes to see if that would help but nothing is happening.

Any help?

[Betablocker]

I to am having problems with screen resolutions and colour depths showing

i have 5 people with 1024x768 showing and with 32 bit
but there are like 80 members a day logging in + who ever else coming to the site. And i use 1280x768 myself and that dont show either.

i am on 1.4.3 and has been running a while on 3 of my sites but the screen resolutions and colour depths don't seem to be right on any of them.

Any idea how i can fix this ?

Great hack and thanks in advance