vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - psiStats 2009 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=203767)

akanevsky 01-30-2009 10:00 PM

psiStats 2009 (The New vBStats for vBulletin 3.5.x - 3.8.x)
 
1 Attachment(s)
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

akanevsky 01-31-2009 09:52 PM

Custom Icons for Black Skin (Martin9887):

https://vborg.vbsupport.ru/showpost....4&postcount=47 (small icons - png)
https://vborg.vbsupport.ru/showpost....8&postcount=52 (large icons - png)

figu120 01-31-2009 09:54 PM

reserved

yahoooh 01-31-2009 11:02 PM

thank u

lasto 01-31-2009 11:10 PM

going to install this now psionic

/me clicks install

EDIT:
Installs without a hitch.

Good stats them as well m8

TandyServices 01-31-2009 11:13 PM

Great Mod.. Thanks alot..

Black Tiger 02-01-2009 12:07 AM

Looks nice.
A pre-installation question... If I put the "Refering Sites: Items to show" to 0. Is this option disabled then? If not, is there a way to disable display of refering sites?
Will there also be an option to disable display of OS and browser, disable flags?
Not that I really need that at the moment, but this way it's more customizable for people who wish to customize it a little for which stats are shown.

digicom 02-01-2009 12:12 AM

Much Apprciated Thankyou :up:

dvbusuario 02-01-2009 03:47 AM

1 Attachment(s)
Translate un Spanish

Install & Nominated!!!

Thank You!:up:

djrichards 02-01-2009 05:00 AM

"Unable to unarchive...(Error 1 - Operation not permitted.)"

Can't unzip your file!

Jon Tolzien 02-01-2009 05:09 AM

Got the same thing... I am using Mac OS. I will check back soon. Looks good though

lasto 02-01-2009 06:54 AM

Pressing any other option such as Resoultion/Refferes etc bring No data up.
Only General and Styling bring info up - the other linksshow nothing at all.
Its set in options to show to usergroups as well so its not that

redlabour 02-01-2009 07:34 AM

Bug:

Staff: 30 (8 admins, 4 s-mods, 18 mods)

useless since the Mod does not prove which UserIDs are double counted.

Correct was:

Staff: 19 (8 admins, 4 s-mods, 7 mods)

oPPoSiTe 02-01-2009 10:49 AM

Thank you

Skyrider 02-01-2009 11:40 AM

Awesome plugin, installed! Possible you can add dots or commas after a large number? Like, 10000 will be 10.000 or 10,000.

klaush 02-01-2009 01:15 PM

Same here. We had this problem in previous versions already, did we?

Quote:

Originally Posted by redlabour (Post 1730672)
Bug:

Staff: 30 (8 admins, 4 s-mods, 18 mods)

useless since the Mod does not prove which UserIDs are double counted.

Correct was:

Staff: 19 (8 admins, 4 s-mods, 7 mods)


cmedic101 02-01-2009 01:44 PM

Wow! what a powerful Add-on...Thanks for your hard work!

cmedic101

akanevsky 02-01-2009 02:08 PM

Quote:

Originally Posted by lasto (Post 1730658)
Pressing any other option such as Resoultion/Refferes etc bring No data up.
Only General and Styling bring info up - the other linksshow nothing at all.
Its set in options to show to usergroups as well so its not that

This data is updated once in a while. It doesn't show up immediately, and it will only show data from after you installed the hack.

Quote:

Originally Posted by redlabour (Post 1730672)
Bug:

Staff: 30 (8 admins, 4 s-mods, 18 mods)

useless since the Mod does not prove which UserIDs are double counted.

Correct was:

Staff: 19 (8 admins, 4 s-mods, 7 mods)

Fixed in 1.5.1.

Quote:

Originally Posted by Black Tiger (Post 1730447)
Looks nice.
A pre-installation question... If I put the "Refering Sites: Items to show" to 0. Is this option disabled then? If not, is there a way to disable display of refering sites?
Will there also be an option to disable display of OS and browser, disable flags?
Not that I really need that at the moment, but this way it's more customizable for people who wish to customize it a little for which stats are shown.

Quote:

Originally Posted by djrichards (Post 1730605)
"Unable to unarchive...(Error 1 - Operation not permitted.)"

Can't unzip your file!

Please try another zip utility - the mime type of this zip file is application/x-zip-compressed, and your utility must support that.

Quote:

Originally Posted by FF|Skyrider (Post 1730800)
Awesome plugin, installed! Possible you can add dots or commas after a large number? Like, 10000 will be 10.000 or 10,000.

Implemented in 1.5.1.

Quote:

Originally Posted by Black Tiger (Post 1730447)
Looks nice.
A pre-installation question... If I put the "Refering Sites: Items to show" to 0. Is this option disabled then? If not, is there a way to disable display of refering sites?
Will there also be an option to disable display of OS and browser, disable flags?
Not that I really need that at the moment, but this way it's more customizable for people who wish to customize it a little for which stats are shown.

Implemented in 1.5.1.

Quote:

Originally Posted by dvbusuario (Post 1730577)
Translate un Spanish

Install & Nominated!!!

Thank You!:up:

Thank you, your translation was added to the archive.

ackack 02-01-2009 02:21 PM

problem when i enable that modul C:\AppServ\www\forum\includes\adminfunctions_optio ns.php on line 693

DJ_Rguez 02-01-2009 02:31 PM

I installed the latest version of the mod but the attempt was to see this page as the countries and regions always remains in the same place never changes .... solve this please

on the following link you can check

http://maomusic.net/foro/psistats.php?do=toptf

redlabour 02-01-2009 02:34 PM

1 Attachment(s)
Quote:

Originally Posted by DJ_Rguez (Post 1730928)
I installed the latest version of the mod but the attempt was to see this page as the countries and regions always remains in the same place never changes .... solve this please

Same for me - at 1.5.1 only the Startpage of Stats is viewable. The redirect of the other Categorys is no longer working since updating.

BTW - failure in Language:

(X referrals) <- is not phrased.

Anyway - german Translation attached. Frontend completed without this small failure described above.

Martin9887 02-01-2009 02:39 PM

Just updated but now it doesn't change stats page even after clicking on one. Just reloads the category ''General''.

DJ_Rguez 02-01-2009 02:45 PM

I do the same thing happens and I think I will stay with the previous version

akanevsky 02-01-2009 03:35 PM

Quote:

Originally Posted by ackack (Post 1730915)
problem when i enable that modul C:\AppServ\www\forum\includes\adminfunctions_optio ns.php on line 693

Which version of vBulletin are you talking about? Is your adminfunctions_options.php file modified at all? What is the precise error message you're getting? Can you copy and paste the lines 692-694 in that file?

Quote:

Originally Posted by redlabour (Post 1730933)
Same for me - at 1.5.1 only the Startpage of Stats is viewable. The redirect of the other Categorys is no longer working since updating.

BTW - failure in Language:

(X referrals) <- is not phrased.

Anyway - german Translation attached. Frontend completed without this small failure described above.

Thank you for pointing this out (to be fixed in 1.5.2 when the first guy in this post responds).

Quote:

Originally Posted by Martin9887 (Post 1730937)
Just updated but now it doesn't change stats page even after clicking on one. Just reloads the category ''General''.

Thank you for pointing this out (to be fixed in 1.5.2 when the first guy in this post responds).

redlabour 02-01-2009 04:32 PM

BTW - is there any Change to get some Silkicons in further Releases at the Categories? Would be nice to have.. ;)

glorify 02-01-2009 04:55 PM

Thank you. Only stat hack I ever used thru the years.

Doctor Death 02-01-2009 05:21 PM

Got this error after install... any ideas?

Quote:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT DISTINCT userid
FROM aaaaaaaa_moderator
LEFT JOIN vaaaaaaaa_user as user USING (userid)
WHERE forumid <> -1
AND (user.usergroupid NOT IN (6)
AND NOT FIND_IN_SET(6, user.membergroupids)) AND (user.usergroupid NOT IN (5)
AND NOT FIND_IN_SET(5, user.membergroupids));

MySQL Error : Column 'userid' in field list is ambiguous
Error Number : 1052
Request Date : Sunday, February 1st 2009 @ 02:18:33 PM
Error Date : Sunday, February 1st 2009 @ 02:18:33 PM
Script : http://www.dxxxx.com/foxxxxx/psistats.php
Referrer :
IP Address : 70.161.40.132
Username : Doctor Death
Classname : vb_database
MySQL Version : 4.1.22-standard

akanevsky 02-01-2009 06:59 PM

Quote:

Originally Posted by redlabour (Post 1731045)
BTW - is there any Change to get some Silkicons in further Releases at the Categories? Would be nice to have.. ;)

Can you please explain the connections between these icons and the existing categories?

Quote:

Originally Posted by glorify (Post 1731070)
Thank you. Only stat hack I ever used thru the years.

Thank you. Glad to hear it.

Quote:

Originally Posted by Doctor Death (Post 1731094)
Got this error after install... any ideas?

Thank you for pointing this out (to be fixed in 1.5.2).

jujubins 02-01-2009 07:02 PM

1 Attachment(s)
Quote:

Originally Posted by lasto (Post 1730658)
Pressing any other option such as Resoultion/Refferes etc bring No data up.
Only General and Styling bring info up - the other linksshow nothing at all.
Its set in options to show to usergroups as well so its not that

I have the same problem, but nothing works beyond the general.

Anyway...
Portuguese (Brazil) translation:

akanevsky 02-01-2009 08:52 PM

Update 1.5.2 released.

Updated File: psistats.php
Overwrite Product: Of course.

Doctor Death 02-01-2009 09:14 PM

Great job, 1.5.2 worked out my bugs!!!

Thanks again, terrific job.

Skyrider 02-01-2009 10:14 PM

Thanks for the update! Is there any way though that you can see which people are using what size and or are from what country? Also nominated as MOTM.

EDIT:
After I updated, I no longer see the bottom bar with the country, browser, etc options. It's empty for me and my usergroup is added already within the adminCP.

jujubins 02-01-2009 10:16 PM

Thanks! Now its working :D

dvbusuario 02-01-2009 10:50 PM

1 Attachment(s)
Translation 1.5.2 in Spanish

Re-Install!

Thank you!

akanevsky 02-01-2009 10:52 PM

Quote:

Originally Posted by FF|Skyrider (Post 1731369)
Thanks for the update! Is there any way though that you can see which people are using what size and or are from what country? Also nominated as MOTM.

That would require way too much space. I don't think I'll be adding this.

Quote:

Originally Posted by FF|Skyrider (Post 1731369)
After I updated, I no longer see the bottom bar with the country, browser, etc options. It's empty for me and my usergroup is added already within the adminCP.

Check vBulletin Options -> psiStats 2009, and see whether the modules are enabled. Also, please revert any psistats_ templates you may have modified for previous versions. And also make sure to overwrite psistats.php with the updated version of the file. :)

Vaupell 02-01-2009 10:53 PM

tx for this update, now it works for me aswell

Installed. tx really needed to know some screen size stats..

awsome. + installed

Ryuk 02-02-2009 12:10 AM

installed, thank you very much

nascartr 02-02-2009 12:49 AM

How can I edit the quick links link? I'd like to add an icon beside of it the same way I have icons on every other menu item. http://diecastcrazy.com/community/forums.php

djrichards 02-02-2009 03:12 AM

Quote:

Originally Posted by Jon Tolzien (Post 1730608)
Got the same thing... I am using Mac OS. I will check back soon. Looks good though

Same here. Mac OS. But I can open any other Zip with no problem.

redlabour 02-02-2009 03:30 AM

Any change to get the Regions and Countries phrased to complete Translation?


All times are GMT. The time now is 02:09 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.01536 seconds
  • Memory Usage 1,864KB
  • 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
  • (20)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