Go Back   vb.org Archive > vBulletin Modifications > vBulletin 4.x Modifications > vBulletin 4.x Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
psiStats 2010 (The New vBStats for vBulletin 4.0.x) Details »»
psiStats 2010 (The New vBStats for vBulletin 4.0.x)
Version: 1.7.2, by akanevsky akanevsky is offline
Developer Last Online: Feb 2016 Show Printable Version Email this Page

Category: Major Additions - Version: 4.0.x Rating:
Released: 09-17-2010 Last Update: 10-04-2010 Installs: 190
DB Changes Uses Plugins Auto-Templates
Additional Files  
No support by the author.

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 2010
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 4.0.x
|| Released : Sep 19, 2010
||
|| Time required to install: 3 minutes
|| 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.7.1 - stable
[F] Fixed a few minor template bugs.

1.7.0 - stable
[+] Ported the statistics engine to vBulletin 4.0.x.

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

Download Now

File Type: zip psiStats.2010_1.7.2_by.Psionic.Vision.zip (993.6 KB, 982 views)

Screenshots

File Type: png screenshot02 - Admin Panel.png (20.1 KB, 0 views)
File Type: jpg screenshot03 - Front End.jpg (64.4 KB, 0 views)
File Type: jpg screenshot04 - Front End.jpg (36.3 KB, 0 views)
File Type: jpg screenshot05 - Front End.jpg (44.0 KB, 0 views)
File Type: jpg screenshot06 - Front End.jpg (53.7 KB, 0 views)
File Type: jpg screenshot07 - Front End.jpg (83.2 KB, 0 views)
File Type: jpg screenshot08 - Front End.jpg (54.5 KB, 0 views)
File Type: jpg screenshot09 - Front End.jpg (59.8 KB, 0 views)
File Type: jpg screenshot01 - Admin Panel.jpg (140.1 KB, 0 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Благодарность от:
iiioroh

Comments
  #102  
Old 03-10-2013, 06:35 PM
ikorolis's Avatar
ikorolis ikorolis is offline
 
Join Date: Sep 2006
Location: Athens , Greece
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

installed VB 4.2.x and works fine for now.
Reply With Quote
  #103  
Old 03-10-2013, 06:48 PM
Nirjonadda Nirjonadda is offline
 
Join Date: Dec 2011
Location: Italy
Posts: 739
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ikorolis View Post
installed VB 4.2.x and works fine for now.
Add link is not appearing in navbar or Quick Links Menu?
Reply With Quote
  #104  
Old 03-12-2013, 01:55 PM
tanzeelniazi tanzeelniazi is offline
 
Join Date: Apr 2012
Posts: 375
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Not Working in Vb4.2.0
DataBase Error
Reply With Quote
  #105  
Old 05-08-2013, 01:57 AM
nrms?'s Avatar
nrms? nrms? is offline
 
Join Date: Dec 2008
Location: Portugal
Posts: 71
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by |Jordan| View Post
With this mod (v1.7.2) installed on vb 4.1.11 i get the following error on my forum:



Any idea how to fix? This is a new installation of VB with only a few other mods installed.
Same problem/error...
Reply With Quote
  #106  
Old 05-08-2013, 03:28 PM
ikorolis's Avatar
ikorolis ikorolis is offline
 
Join Date: Sep 2006
Location: Athens , Greece
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

works fine vb 4.2.1
Reply With Quote
  #107  
Old 08-08-2013, 06:27 AM
ikorolis's Avatar
ikorolis ikorolis is offline
 
Join Date: Sep 2006
Location: Athens , Greece
Posts: 144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i have recieve this error (error.log)

PHP Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 1468600 bytes) in /home/xxxxx/public_html/includes/cron/psistats_update.php on line 83

dont like have errors for any plugin/addon and force to Uninstalled the product.

sorry coder
Reply With Quote
  #108  
Old 05-18-2016, 05:47 AM
RedHacker RedHacker is offline
 
Join Date: Jan 2009
Posts: 878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
Database error in vBulletin 4.1.7:

Invalid SQL:

		REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
		VALUES ('xxx.xxx.xxx.xxx', 'country', 'xx.xxx.xxx.xxx_country'), ('Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:44.0) Gecko/20100101 Firefox/44.0', 'useragent', 'xx.xxx.xxx.xxx_useragent');

MySQL Error   : Table 'xxx.psistats_cache' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 18th 2016 @ 03:43:17 AM
Error Date    : Wednesday, May 18th 2016 @ 03:43:17 AM
Script        : http://www.xxx.xxx/forum/forum.php
Referrer      : http://www.xxx.xxx/forum/forum.php
IP Address    : xx.xxx.xxx.xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.5.49-MariaDB
Can help with this problem ?

Forget it the solution is here : https://vborg.vbsupport.ru/showpost....4&postcount=96
Reply With Quote
  #109  
Old 11-25-2016, 02:53 PM
Rakehel's Avatar
Rakehel Rakehel is offline
 
Join Date: Dec 2005
Location: Columbus, Ohio - USA
Posts: 68
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Most everything still works for us in vB 4.23 Patch X. It's s shame when some of these better mods aren't kept up. I don't have enough knowledge to help.
Reply With Quote
  #110  
Old 03-23-2018, 01:28 PM
BasilFawlty BasilFawlty is offline
 
Join Date: Jul 2012
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I know this is an old mod but when I try to D/L the file, what gets downloaded is just a readme HTML file? Is this mod no longer available for download?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08244 seconds
  • Memory Usage 2,358KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (1)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete