vb.org Archive - psiStats 2006 (The New vBStats for vBulletin 3.5.x

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=104213)

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

FAQ
READ BEFORE YOU ASK QUESTIONS!!!
IF YOU ASK A QUESTION THAT'S ALREADY BEEN ANSWERED IN THIS POST, THAT'S BEEN ANSWERED MULTIPLE TIMES IN GENERAL, OR IF YOU ASK SAME QUESTION MORE THAN ONCE, YOU WLL BE ADDED TO IGNORE LIST!!!

Q: I am using vB 3.5.3 and am receiving an error about "UNLOCK TABLES".
A: Read: http://www.vbulletin.com/forum/bugs3...iew&bugid=2056

Q: How do I install the product XML?
A: http://www.vbulletin.com/docs/html/plugin_system

Q: How do I upgrade?
A: Find the last one of the "Upgrade: X.Y.Z" posts which contain banana and large font in them. Those posts contain upgrade instructions from the "X.Y.Z-1" version. Which means that you need to find each of those posts that came out since your last upgrade.

Q: How do I hide a certain part that I don't need?
A: You edit any of the psistats_yaddayadda templates to your needs.

Q: Stats do not get updated.
A: Stats are updated once every 15 minutes (not instantly).

Q: Can I limit viewing of the stats to certain usergroups?
A: Yes, using hack options which are located under vBulletin Options -> psiStats 2006

Q: I get a LOCK TABLES error...
A: Make sure you have set proper permissions for the MySQL user. To find out how to set MySQL permissions, contact your hosting provider.

Q: It's not tracking full referrer URLs, only domains.
A: That's how it is designed. It will not be changed.

Q: A country flag is missing.
A: I know. If you have the flag, please send it to me, otherwise there is nothing I can do.

Q: I have upgraded to 1.3.0 (or higher), and now I receive the following error: TABLE psistats_country does not exist.
A: Make sure that you have cancelled the changes done to class_core.php prior to version 1.3.0 of this hack.

Q: I have ____ hack and yours isn't working properly with it.
A: I do not provide support for 3rd party hacks.

Q: This and that isn't working properly...
A: Shh! First, make sure that you have the latest version installed, and doble check that you have done all the steps correctly. If you are 100% sure in both, post your problem.

Quote:

Originally Posted by Psionic Vision

@Yorixz
>> On the toplist page it's totally ignoring the max amount I set to list for the Most viewed/Most replied collumn, it is actually following it for the Top forums though.
What? It uses the same number that you set in admincp for top threads/forums...

The file you attached didn't for me, the one that other user attached on page 7 or so did.

Quote:

>>The link on the country page of Iceland links to a page about Isreal.
The link of Croatia links to Coral Sea Islands.
The link of Andorra doesn't exist.
Theres a continent without a phrase
There is a country without a phrase (this image: )

Please provide the problematic country codes.

They are not "missing", they simply have invalid codes in the country database for some reason. I fixed those.

Is some of this thread missing?

Bob

I asked the moderator to clean up the thread, so it's ok. I have extracted a list of countries which are incorrectly mapped. So it'll be some time until I remap them.

From now on, please do not post pointless posts in this thread, as it is harder for me to follow up with the problems. Please only reply with either bug reports (and do so only once per bug), or testimonials. Thanks.

Here is a list of abbreviations that do not match, and potentially need to be remapped:

Code:

dz => ag => ac

at => au => as => aq => ay

ad => an => nt

ai => av

aw => aa

az => aj

bs => bf => uv

bz => bh => ba => bk

mm => bm => bd => bg => bu

bi => by => bo => bl

bj => bn

bw => bc

vg => vi => vq

kh => cb

ky => cj

tp => tt => td => cd => cg => cf => ct

cl => ci => iv

km => cn => ch => sz => wz

cx => kt

cc => ck => cw

cr => cs

cz => ez

dk => da

dm => do => dr

sj => sv => es => sp

gu => gq => ek

ee => en

gf => fg

pf => fp

tf => fs

de => gm => ga => gb

ge => gg => gk

gd => gj

gn => gv

gw => pu

ht => ha

va => vt

hn => ho

il => is => ic

iq => iz

jp => ja

ki => kr => ks

kp => kn => sc => se => sw

kw => ku

lv => lg

lb => le

lr => li => ls => lt => lh

mc => mn => mg => ma => mo

mw => mi

ms => mh => rm

mq => mb

om => mu => mp => cq

yt => mf

na => wa

ng => ni => nu => ne => ng

pw => ps

py => pa => pm => sb => bp

pg => pp

ph => rp

pn => pc

pt => po

pr => rq

ru => rs

lc => st

sg => sn => sg

sk => lo

zm => za => sf

gs => sx

lk => ce

sd => su

sr => ns

tj => ti

tg => to => tn => ts

tc => tk => tl

tr => tu

tm => tx

ua => up

vu => nh

vn => vm

eh => wi

ye => ym

zw => zi

Kind of long, isn't it?

Option #1: A couple of volunteers could help me do the actual remap, which would be easy using Search&Replace program.
Pros: None. Cons: All script country databases known to me use the same abbr's as the current ones. All online country databases use the same abbr as cia.gov, or they use something completely different; It would be hard to update the database.

Option #2: Find a website that has acceptable information about countries and that uses matching abbreviations.
Pros: No works involved. Cons: CIA has the fullest list of countries, and perhaps the most valid ones.

Option #3: Simply insert the CIA data into the database.
Pros: No work required, is relatively simple in comparison with #1. Cons: A bit more storage space (negligible).

Code:

>> Any possible performance issues with this, does it add queries etc?

Yes, it does add queries. And yes, there are a couple of performance issues. I am currently working on their elimination.



>> Also, is this only visable to admin/mods, or everyone (or is this an option, I would guess it would be)?

That is up to you. You can configure the list usergroups who have access to the script.

Alright, I choose option 3 then.

Okay, on the top stats page, I get 0's for the threadcount and replycount total variables.

Are you speaking about Top Forums?

What do you mean.... 'so it's ok'? 'Clean up the thread'? You mean like delete like 95% of it.

WTF, my issues were deleted AND unanswered? This seems a little strange. And no, I don't think you code 24/7

Quote:

Originally Posted by Psionic Vision

Alright, I choose option 3 then.

Like I already suggested; why not simply use Wikipedia? If you link to http://en.wikipedia.org/wiki/$countryname then the link is correct in 99% of the cases, you probably just need to convert spaces to underscores and then you're done - no need to worry about all the abbrevations.

Quote:

Yes.

That'll be looked into.

Quote:

WTF, my issues were deleted AND unanswered?

I thought I asked to post only to the point, and only once per issue. I thought I also said that I read everything. If the latter be true, you should be sure that your post was read too. If I am not replying, it only means that I know what causes the issue and how to fix it, and thus do not feel the need to discuss anything. Please also remember that this is a free hack and I am therefore not obliged neither to you nor to anyone else, to even support the hack.

If you'd like to receive any further support, you gotta calm yourself down and express yourself more diplomatically. Otherwise, feel free to uninstall my hack, because next time you are going into my ignore list.

Quote:

Like I already suggested; why not simply use Wikipedia?

Wikipedia contains too much extra data, and it has 99% of the countries rather than 100%. In addition, wikipedia is an open encyclopedy, the contents of which can be modified by anyone. Therefore, wikipedia is not a reliable source - unlike cia.gov, which has - or is supposed to have - 100% correct information. I am going to simply add cia abbreviations into counrty database, in addition to "native" abbreviations. ;)

Quote:

Originally Posted by Psionic Vision

That'll be looked into.If you'd like to receive any further support, you gotta calm yourself down and express yourself more diplomatically. Otherwise, feel free to uninstall my hack, because next time you are going into my ignore list.

Don't worry, I am uninstalling this hack since I never received support ANYHOW. I personally do not need a teenager telling me to calm down or threats of adding me to ignore list. Advice, concentrate and focus your engergy on fixing your releases rather than worrying about getting a moderator to delete unanswered posts OR telling people to calm down with threats of ignoring. I don't know who you think you are with statements like that. I can see your immaturity shining here. Uninstalls

*installed*

Works like a charm on 3.5.3

Quote:

Originally Posted by TonysDesigns

Are you not displaying arrogance by taking this stance, or is this just about the age difference? Anthony *does* fix things although he may not say that in his posts, otherwise we would not be up to 1.2.7 with this hack. All the errors I had are now fixed. He, like us all, has a life away from vBulletin.org.

Rome was not built in a day, but it was built.

Just my few pence worth.

Bob

I love this but have uninstalled it untill it becomes stable.

Hi Psionic

I have had the MSN Bot on my forum and the standard Google bot...
But neither are showing on the stats,

I do know that you added the MSN bot and the Standard Google bot when you did the update, heres whats showing....

Bot (Google Adsense) (15.19%) - 203
Bot (Unknown) (5.31%) - 71
Bot (Yahoo! Slurp) (1.57%) - 21

Regards

Bashy

O.k., let?s take another step to build Rome. :-)

As i wrote already, mod?s are not displayed, only s-mods.

And one description to a country is missing.

https://vborg.vbsupport.ru/

Quote:

Originally Posted by klaush

And one description to a country is missing.

http://www.nikon-fotografie.de/images/missing.jpg

I have already reported that one.

Attached is the Fuji flag as it was missing from the package. Upload it to the /database_flags directory.

Bob

Quote:

Originally Posted by firstrebel

I have already reported that one.

Attached is the Fuji flag as it was missing from the package. Upload it to the /database_flags directory.

Bob

Thanks Bob!

I think it was no good idea to delete most of the postings, because nobody still knows what was reported or not.

That?s my 2 cents...

Quote:

I don't know who you think you are.

Quote:

Uninstalls.

Cheers! Just please don't forget about the fact of uninstallation when I make my next release. ;) Thanks.

Quote:

@firstrebel

Thank you for your support. :) And for the flag. That flag will be included in the flag database of PsiStats 1.2.8.
EDIT: Maybe you have a better quality flag? Your flag's resolution is kind of low in comparison to the rest of the flags. Thanks ;)

Quote:

@klaush

Country with a missing label is the old Ireland entry. That entry will be removed from your database after you install next release.
As for mods, my question still remain unanswered (I don't know, maybe it was in the one of the deleted posts): Are any of your supermoderators also designated as mods (I don't know why would you do that, maybe in order for them to show up in forum leaders screen, but anyway...)?

Quote:

I love this but have uninstalled it untill it becomes stable.

It's perfectly fine, however don't forget to subscribe to this thread so that you receive update notifications. :)

Quote:

bashy

Are you sure that google and msn have visited your forum after the update? In any case, I'll look into it.

Quote:

Originally Posted by klaush

I think it was no good idea to delete most of the postings, because nobody still knows what was reported or not.

It was a good idea, because the thread was bloated with pointless posts and screenshots, many of which reported the same problem.
Nothing was reported, simply every single post - including the ones made by me - were erased from this thread by my request. Now, for a short time, it will be easy to keep track of the new posts :)

Hi Psionic

Thanks for the quick response...

Yeah they both have, i know this due to the crawler block that i have now updates the crawlers again, Also the WOL also has started to show the crawlers again, this is how i know they have been on....

Regards

Bashy

Here's a better Fiji flag.

Thank you very much :)

Thanks, i did have a wee look for 1 but gave up :o
Thanks again

Bashy

Quote:

Originally Posted by firstrebel

Here's a better Fiji flag.

The only problem I have with my installation is it's not displaying Resolution or Color Depth stats... other than that I have no problems on vB 3.5.3

I really like the instructions you have coded with the boxes to collapse the steps you've finished, really nice... great hack :)

Quote:

Originally Posted by Psionic Vision

As for mods, my question still remain unanswered (I don't know, maybe it was in the one of the deleted posts): Are any of your supermoderators also designated as mods (I don't know why would you do that, maybe in order for them to show up in forum leaders screen, but anyway...)?

Yep, i answered already, but no problem. Yes, you are right! So, if they are both, only the s-mods are shown, correct?

If, that?s o.k. in this way...!

Quote:

The only problem I have with my installation is it's not displaying Resolution or Color Depth stats...

I am not really sure what causes the problem, because for others it works fine..

Quote:

I really like the instructions you have coded with the boxes to collapse the steps you've finished

Thank you :)

Quote:

Yes, you are right! So, if they are both, only the s-mods are shown, correct?

In next release they will count both ways (e.g. the actual way of set-up).

I just found this site:
http://www.flags.net/
What about I use that in the hack?

Quote:

Originally Posted by Psionic Vision

In next release they will count both ways (e.g. the actual way of set-up).

Thanks! But my life is not depending on this change! :-)

Quote:

Originally Posted by Psionic Vision

I just found this site:
http://www.flags.net/
What about I use that in the hack?

Looks fine; but you have to change most of the code?

Quote:

Looks fine; but you have to change most of the code?

Fortunately, no. I simply run a script, which scans the index page, extracts the abbreviations, and saves them into the country database, just as with option 3 here.

Quote:

Originally Posted by Psionic Vision

Fortunately, no. I simply run a script, which scans the index page, extracts the abbreviations, and saves them into the country database, just as with option 3 here.

Good to know. From Germany the site is fast, has a solid structure as well and the most important information about the country.

So what do you guys think?

On the second thought.. I am staying with cia. The flags cite has about 10 countries missing, whereas cia site is only missing Yugoslavia.

Psionic Vision nice work seems to be working great i just have one question how do i get Display Colors & Resolutions to work i just didnt see nothing in that section

You don't see anything until any stats are recorded. Just wait a while for a couple of visitors, and you should start seeing those stats.

Quote:

Originally Posted by TonysDesigns

I was away for a day, mate posts like that goes vb.org far away back...Here we share our ideas - coding abillities, we dont request anything as certain....where are your manners? How old are u and talk like that?

The lad is keep supporting this product, with often updates...what else did u looking for? To give u his msn and serve u all day long? FFS, i hope users like u really get banned from communities like Vb.org ...

Anyway, i calm down and ask, Psionic Vision have u read my comments of strange appear on the Who's Online, that users are in the Stats page when they are just on the homepage? Didnt saw an answer, for this i ask that :)

And some quick questions. What the numbers means? I mean, ok in the Regions i have that from US i have 400. This means 400 sessions? 400 hits? 400 members?

Thnx in advance as always, if u are 16 and code like that, the feature is in your hand, keep up:)

Update:

I searched a bit more the bug, and it seems that if the user is on Arcade (tested just there for sure) its shows that he is on the stats page!! Please help, something must be messed up :)

Hi Psionic

Just took a copy of my WOL..

MSNBot Spider Viewing User Profile daniel 207.46.98.47 12 Minutes Ago
Yahoo! Slurp Spider Viewing Thread Farcry xbox 68.142.251.50 1 Minute Ago
Google AdSense Spider Viewing Thread New shot box 66.249.66.102 2 Minutes Ago
Yahoo! Slurp Spider Viewing User Profile jolotull 68.142.251.88

Just to show you that MSN does definatley come in the forum, Still not shown up on your stats though m8......

I chose red font, why is it green lol :rolleyes:

Regards

Bashy

Last night I upgraded 3.5.2 > 3.5.3. I now cannot view top forums and threads with /psistats.php?do=toptf. I get page cannot be displayed error. All the other options work OK. I have gone through the install again totally.

Any ideas?

Bob

Quote:

strange appear on the Who's Online, that users are in the Stats page when they are just on the homepage?

Then they are in stats. What appears in WOL does not have anything to do with the hack.

Quote:

What the numbers means?

Numbers mean the # of user sessions that have this particular item applied to it.
E.g. 150 next to Russia means that there were 150 forum sessions initiated from a Russian IP.

Quote:

if u are 16 and code like that, the feature is in your hand, keep up

Thanks :)

Quote:

and it seems that if the user is on Arcade

That's not likely. However, if you give me a link to the Arcade hack, I'll look at it for you.

Quote:

Just took a copy of my WOL..

Thank you.

Quote:

I chose red font, why is it green lol

Because that's how they tweaked it on vbulletin.org.

Quote:

Wait until next release. It might be happening because of the unlimited thread select (instead of 10 or whatever is set in admincp).

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02083 seconds Memory Usage 1,920KB 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 (34)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (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
Messages: