PDA

View Full Version : Major Additions - psiStats 2009 (The New vBStats for vBulletin 3.5.x - 3.8.x)


akanevsky
01-30-2009, 10:00 PM
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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=203767)

akanevsky
01-31-2009, 09:52 PM
Custom Icons for Black Skin (Martin9887):

https://vborg.vbsupport.ru/showpost.php?p=1732234&postcount=47 (small icons - png)
https://vborg.vbsupport.ru/showpost.php?p=1732978&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
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?

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
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.

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.

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.

"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.

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.

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.

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
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
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?

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).

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 (http://www.famfamfam.com/lab/icons/silk/) 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?

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
BTW - is there any Change to get some Silkicons (http://www.famfamfam.com/lab/icons/silk/) in further Releases at the Categories? Would be nice to have.. ;)

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

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

Thank you. Glad to hear it.

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
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
Translation 1.5.2 in Spanish

Re-Install!

Thank you!

akanevsky
02-01-2009, 10:52 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.

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

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
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?

troppodel
02-02-2009, 09:00 AM
please fix the problem ......the stat quick link from the vbadvanced cmps is broken .....it must add the "forum" path

Ivan

Trek
02-02-2009, 04:16 PM
Good mod, installed, etc. However I have a few bugs to report:

You can see my forums here: http://www.darkhandofvalor.com/psistats.php?do=styles

And the style isn't displayed correctly for some reason, no logo, etc.

But if you for instance click here: http://www.darkhandofvalor.com/psistats.php?do=os

Everything looks like it should.

Also, when I installed, I got this added to my ACP: *[]*

There's nothing in it but another entry with the same text. I tried uninstalled and it left this there, no idea.

Also, I don't have the referrers section as displayed in the screenshot either.

Martin9887
02-02-2009, 04:30 PM
Working excellently now, thanks for the update.

I have question though, the styles on my forum are mostly dark and the icons don't look great against them. If I was to make some new icons for the operating systems, etc, will they work? if I save with the same file names and types and overwrite them?

Thanks.

Trek
02-02-2009, 04:55 PM
If I was to make some new icons for the operating systems, etc, will they work? if I save with the same file names and types and overwrite them?Thanks.

Of course they'll work, but they'll only work if you share them so others like myself with dark styles can use them. ;)

ckeins
02-02-2009, 06:28 PM
Very nice Mod. Is there a possibility to show the statistics from die ACP: new posts, threads, users / day, week or month?

TheInsaneManiac
02-02-2009, 06:45 PM
Queries?

Martin9887
02-02-2009, 06:56 PM
Of course they'll work, but they'll only work if you share them so others like myself with dark styles can use them. ;)

I hope it's okay to upload them here, didn't do them all but the more popular ones I think. They aren't perfect but look a little better I guess. I'd like to use .png images but editing templates would be involved for that.

https://vborg.vbsupport.ru/

akanevsky
02-02-2009, 08:18 PM
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

Right now the only way to do this is to edit the plugin at global_start and change the replacement code. In the next version it will be saved to a template.

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

Please try another zip utility.

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

I can't answer this question at this time, but I'll look into it.

please fix the problem ......the stat quick link from the vbadvanced cmps is broken .....it must add the "forum" path

Ivan


Please add psistats.php to the list of vbadvanced header replacements. That'll fix the "bug".

Good mod, installed, etc. However I have a few bugs to report:

You can see my forums here: http://www.darkhandofvalor.com/psistats.php?do=styles

And the style isn't displayed correctly for some reason, no logo, etc.

But if you for instance click here: http://www.darkhandofvalor.com/psistats.php?do=os

Everything looks like it should.

Also, when I installed, I got this added to my ACP: *[]*

There's nothing in it but another entry with the same text. I tried uninstalled and it left this there, no idea.

Also, I don't have the referrers section as displayed in the screenshot either.

For the style problem, I'm not sure what the problem is. Maybe you could send me your admincp details so that I can take a look?

As for referrers, that's added from another hack. Currently psiStats does not have an integrated referrers page. It will have in a future version.

Working excellently now, thanks for the update.

I have question though, the styles on my forum are mostly dark and the icons don't look great against them. If I was to make some new icons for the operating systems, etc, will they work? if I save with the same file names and types and overwrite them?

Thanks.


Any icons will work as long as you save them with the right filenames on top of the existing icons. Also it'll be very nice of you if you can share your icons, so that others can use them. :)

Very nice Mod. Is there a possibility to show the statistics from die ACP: new posts, threads, users / day, week or month?

I can't answer this question at this time, but I'll look into it.

Chadi
02-03-2009, 12:15 AM
How can I disable the automatic quick link insertion? Thanks.

TheInsaneManiac
02-03-2009, 01:29 AM
How much stress will this put on the server? How many queries?

terminator2k2
02-03-2009, 09:38 AM
I hope it's okay to upload them here, didn't do them all but the more popular ones I think. They aren't perfect but look a little better I guess. I'd like to use .png images but editing templates would be involved for that.

http://i312.photobucket.com/albums/ll336/Martin_Sherwood/1.png

you can create png file and rename it to gif, this way it still looks like png with better tranparency ;)

by the way.. how can i update the language?

xml language import -> select file "german" -> overwrite "german" -> ignore language version (yes?)

Martin9887
02-03-2009, 11:42 AM
I'm using png's now, I edited the two templates, also made the icons bigger. Works fine.

Excellent mod this is, Psionic Vision.

akanevsky
02-04-2009, 08:26 PM
How can I disable the automatic quick link insertion? Thanks.

Right now, the only way you can disable that is by editing the plugin at global_start - remove the replacement that adds stuff to navbar.

you can create png file and rename it to gif, this way it still looks like png with better tranparency ;)

by the way.. how can i update the language?

xml language import -> select file "german" -> overwrite "german" -> ignore language version (yes?)

That is correct.

I'm using png's now, I edited the two templates, also made the icons bigger. Works fine.

Excellent mod this is, Psionic Vision.

Thank you for your submissions and kind feedback, I added links to these to the second post in the thread.

PtitLu
02-06-2009, 01:22 PM
I installed the mod and the french language.
Now, when my forum is in english, everything is a mess. The page "turned from left to right".
Here are two shots. As you can see, with the english language, there is no problem. But in French...

English language (http://www.ptitlu.org/pix/tmp/vb-langue-inverse-texte-01.png)
French language (http://www.ptitlu.org/pix/tmp/vb-langue-inverse-texte-02.png)

Uninstalling the mod does not solve anything. I deleted the phrases with "psistats" in them, but the problem is still there. :(

PtitLu
02-06-2009, 01:32 PM
Corrected. In fact, every setting for the French language was deleted and the "Left to Right" turned to "Right to Left". I had to re-enter every setting as the were all blanked.
Am i the only one ?

akanevsky
02-06-2009, 04:39 PM
Corrected. In fact, every setting for the French language was deleted and the "Left to Right" turned to "Right to Left". I had to re-enter every setting as the were all blanked.
Am i the only one ?

Maybe you imported it as a language instead of just importing the phrases into an already existing French language?

PtitLu
02-06-2009, 06:32 PM
Maybe you imported it as a language instead of just importing the phrases into an already existing French language?No, i thought i made the mistake, but, i did it again, slowly, and the result was the same.

akanevsky
02-06-2009, 09:51 PM
No, i thought i made the mistake, but, i did it again, slowly, and the result was the same.

Maybe you should contact vBulletin and see what they say about this.

crkgb
02-07-2009, 12:06 AM
Any plans on adding Google Chrome to the list of the browsers?

Vaupell
02-07-2009, 07:46 AM
Any plans on adding Google Chrome to the list of the browsers?

yes please, getting quite a few "unknown" several of my users use google chrome.
including myself :D

alehawk
02-08-2009, 04:49 PM
It works but when I imported the sp language it messed up all the language I had and I had to reimport the original language file.

bleros
02-08-2009, 06:10 PM
installed! and Nominated.. really nice job mann

ackack
02-11-2009, 04:47 AM
https://vborg.vbsupport.ru/showthread.php?t=189175&highlight=Age+Gender+Demographics
Why dont you improve this mod in newversion 1.53 :D
i see it is very usefull :">

Nantrox
02-12-2009, 07:49 AM
well after importing the de language file my whole board messed up.. I am glad that I made a Backup right before I installed the language..

Anyways, besides the Problem with the Language, the hack is really good !! *marked as installed*

Vaupell
02-12-2009, 08:00 AM
It works but when I imported the sp language it messed up all the language I had and I had to reimport the original language file.

well after importing the de language file my whole board messed up.. I am glad that I made a Backup right before I installed the language..

Anyways, besides the Problem with the Language, the hack is really good !! *marked as installed*

You guys do know after importing a language, you need to open it once in the language editor and save it.

this will add those "costum" phrases not there originally.
that usually works for me, cause the language im importing do not have
any mod support, and by simply opening it and saveing it again
it adds the default values from my installed mods. and board works.

ackack
02-13-2009, 04:26 AM
why not add Age And Gender Demographics in newversion
https://vborg.vbsupport.ru/showthread.php?t=189175&highlight=Age+Gender+Demographics
please i very like your's mod

Makc666
02-13-2009, 02:50 PM
I will pay attention once again to this one:

There is also no translation on page Color Depths for words:


bits
colors


This one is in template:
psistats_depthbit

Current code:
<span class="smallfont"><strong>$depth bits ($depth[colors]<if condition="is_numeric($depth[colors])">colors</if>)</strong></span>

Good code will be:
<span class="smallfont"><strong>$depth[bits] $vbphrase[psistats_bits] ($depth[colors]<if condition="is_numeric($depth[colors])">$vbphrase[psistats_colors]</if>)</strong></span>

Plus new phrase #1:
$vbphrase[psistats_colors]

with text:
colors
[B]P.S. note for space at the beginning of the phrase.

Plus new phrase #2:
$vbphrase[psistats_bits]

with text:
bits

Jedric
02-14-2009, 08:25 AM
Installed :)

PossumX
02-15-2009, 08:35 AM
EXCELLENT. I have been waiting for an updated version for 3.8.x. I've missed this mod!! PossumX marks Installed

akanevsky
02-15-2009, 02:11 PM
Any plans on adding Google Chrome to the list of the browsers?

Yes, thank you for reminding me.

https://vborg.vbsupport.ru/showthread.php?t=189175&highlight=Age+Gender+Demographics
Why dont you improve this mod in newversion 1.53 :D
i see it is very usefull :">

I'll consider that.

well after importing the de language file my whole board messed up.. I am glad that I made a Backup right before I installed the language..

Anyways, besides the Problem with the Language, the hack is really good !! *marked as installed*

I don't know why is everyone having issues with languages. Maybe they were not exported correctly by original authors. I'll check.

I will pay attention once again to this one:

There is also no translation on page Color Depths for words:


bits
colors


This one is in template:
psistats_depthbit

Current code:
<span class="smallfont"><strong>$depth bits ($depth[colors]<if condition="is_numeric($depth[colors])">colors</if>)</strong></span>

Good code will be:
<span class="smallfont"><strong>$depth[bits] $vbphrase[psistats_bits] ($depth[colors]<if condition="is_numeric($depth[colors])">$vbphrase[psistats_colors]</if>)</strong></span>

Plus new phrase #1:
$vbphrase[psistats_colors]

with text:
colors
[B]P.S. note for space at the beginning of the phrase.

Plus new phrase #2:
$vbphrase[psistats_bits]

with text:
bits

Thank you for the detailed information about text not phrased. It shall be fixed.

perfphysio
02-18-2009, 02:42 PM
Hi there, great mod. Can you tell us how to hide it totally in the navbar when not logged in and then only show it in the nav bar if the user ID that has [permissions to view the stats matches that of the logged in user. Right now my users can click on it only to get disappointed that they don't have permissions to view. I'd rather hide the link from them all together

Many thanks for a great update :)

vspro
02-18-2009, 05:01 PM
Thank you

redlabour
02-20-2009, 05:19 PM
Small cosmetic Bug:

All Usergroups that are not allowed to view the Statistic will still see the Quicklink. Please make it invisible for those Usergroups who are not allowed to view it. ;)

aakhan136
02-20-2009, 06:15 PM
thanks

nascartr
02-21-2009, 02:39 AM
Has anyone had the problem of being randomly logged out since installing this mod?

Ever since I installed it I have to log in sometimes twice a day and a few members have made some complaints about the same problem.

This is the only thing I've added since the problem started occuring.

akanevsky
02-22-2009, 02:27 AM
Hi there, great mod. Can you tell us how to hide it totally in the navbar when not logged in and then only show it in the nav bar if the user ID that has [permissions to view the stats matches that of the logged in user. Right now my users can click on it only to get disappointed that they don't have permissions to view. I'd rather hide the link from them all together

Many thanks for a great update :)

Small cosmetic Bug:

All Usergroups that are not allowed to view the Statistic will still see the Quicklink. Please make it invisible for those Usergroups who are not allowed to view it. ;)

Thanks for the notice, will be considered for future release.

Mahar
03-02-2009, 02:29 AM
Question....I've installed this and, upon looking at the number of staff members, it says:

8 admins, 0 s-mods, 3 mods

When there are...4 admins, 1 smod and 6 moderators.

I have a few users that are hidden admins...but I only want the Administrator user group to show up for that one...Smod...there is one but it says Zero....and Mods there are 6...but it only says three.

Maybe you could make it so whether or not the user has said usergroup as their Primary...it still counts them in the statistic..

What's up?

EDIT: Another good idea would be for when you're looking at the Top Thread and Forum Statistics that it doesn't show anything from forums with the post counts off. We have a "Trash Bin" kind of forum where all threads go when they get old and are ready to be deleted etc...

TandyServices
03-06-2009, 08:30 AM
Was all working fine then I had to disable it.. I only have this Database error.


Database error in vBulletin 3.8.1:
Invalid SQL:
REPLACE INTO `vb_psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('63.241.57.214', 'country', '63.241.57.214_country'), ('Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.30618; .NET CLR 3.5.30729)', 'useragent', '63.241.57.214_useragent');
MySQL Error : Incorrect file format 'vb_psistats_cache'
Error Number : 130
Request Date : Friday, March 6th 2009 @ 03:27:26 AM
Error Date : Friday, March 6th 2009 @ 03:27:26 AM
Script : http://www.mysite/index.php?
Referrer : http://www.mysite/showthread.php?p=498&styleid=7
IP Address : 63.241.57.214
Username : me
Classname : vB_Database
MySQL Version : 5.0.75-community-log


disabled till there is a fix

Sooner95
03-07-2009, 01:42 AM
Easy install, thx for the update!

nascartr
03-07-2009, 02:56 AM
I uninstalled this mod and all logout problem have dissapeared. Is their any reason why this would cause members to be randomly logged out?

TandyServices
03-09-2009, 10:54 PM
Guess I will uninstall it too.. no answers

Mahar
03-11-2009, 07:11 PM
I uninstalled this mod and all logout problem have dissapeared. Is their any reason why this would cause members to be randomly logged out?

It sounds like a cookie issue.

Anyways, I've uninstalled this as well...it looks very sloppy the way it is and I don't have the know how to fix it.

kaderith
03-12-2009, 12:48 PM
Installed and works great! Thank you so much for this, its an outstanding tool!

toxin
03-14-2009, 02:15 AM
What's the quickest way to reset the stats to zero? Empty the psistats_data and psistats_cache tables?

TandyServices
03-14-2009, 07:29 AM
Ok I fixed my database error my self. i just went into my database and cleared out the 'vb_psistats_cache' hope it stay working again. If it happens again and there is no fix I will have to uninstall and not come back.. And that would really suck because I like this mod alot.. Thanks and no thanks for your help..

OcR Envy
03-20-2009, 04:57 PM
Any way to set the site referral to show the entire url not just the domain?

Gio Takahashi
03-26-2009, 10:42 PM
Looks like I'm having language problem, I installed the hack but most of the "phrases" have disappeared.

Screenshots included.

mrtroybaker
03-26-2009, 11:09 PM
WOW!!! Thank you. Very NIce!!!!!

*INSTALLED*

Gio Takahashi
03-26-2009, 11:13 PM
Nevermind. Everything seems to appear automatically, however, the numbers for User Styles are inaccurate. I KNOW 100% of my members aren't using 1 style.

trucker01
03-28-2009, 06:18 AM
thnx i installed this one looks good to me :D

tlwwolfseye
03-28-2009, 08:57 AM
Where exactly do i find the QUICK link in my templates so I can make it not show at all ?
Seems also as if the Referrer is not counting any Sites, or does that take a while to show up ?
Also in the Referrer Section i can´t get any of the XML + JS Feeds working, is that Mod compatible with 3.7.5 or is that why I can´t get that to work ?

crazlunatic
03-29-2009, 02:45 PM
I installed it, where do I view the stats?

RK1gaming
03-31-2009, 01:41 PM
I installed it, where do I view the stats?


For me its in my quick links pull down

CFodder
04-05-2009, 01:38 AM
Another great mod thanks Psi :) ... one question tho, would it be possible to add a feature to disable the inclusion of certain forums/threads in the Top Threads & Forum display, we have RSS forums that I don't really want included in it :).

Matrixthestar
04-24-2009, 09:21 PM
countries browsers systems
don't show anything

keharris53
04-27-2009, 09:56 PM
Installed, but nothing...can't view anything, like it's not there...usng 3.8.1

I should add that it does not appear in my quick links.

Freddy.k
04-28-2009, 10:01 AM
Merci cool

viper357
04-29-2009, 09:01 AM
I uninstalled your previous one, v 1.4.4 and installed this one but as soon as I enable it I am getting this error

Fatal error: Cannot redeclare cache_styles() (previously declared in /home/*****/public_html/includes/adminfunctions_template.php:2249) in /home/*****/public_html/includes/local_links_include.php on line 1036

ageurtse
05-10-2009, 04:59 AM
is it possible to put some of the statistics on the forum homepage ?

viper357
05-10-2009, 05:19 PM
Any help with post #98?

akanevsky
05-11-2009, 11:55 AM
countries browsers systems
don't show anything

It will after a while.

I uninstalled your previous one, v 1.4.4 and installed this one but as soon as I enable it I am getting this error

That's weird, where are you getting the error at?

viper357
05-11-2009, 12:15 PM
I uninstalled your previous one, v 1.4.4 and installed this one but as soon as I enable it I am getting this error


That's weird, where are you getting the error at?
Everywhere :p As soon as the hack is enabled I can't access my forum at all.

I'm wondering if this is a permissions problem on the vbadvanced portal - local_links_include.php I think that is from the Links and Downloads Manager addon?

Reef Man
05-12-2009, 06:44 PM
Well,
This think broke all my template.

any idea of how to turn it to the correct side?

https://vborg.vbsupport.ru/

https://vborg.vbsupport.ru/

unknownkind
05-21-2009, 08:31 PM
Installed, but nothing...can't view anything, like it's not there...usng 3.8.1

I should add that it does not appear in my quick links.

I have this same problem but for version 3.8.2

Whats up?

--UK

ageurtse
05-21-2009, 08:45 PM
no stats displayd, or even the psi stat not displayed.

when no stats are displayed check tommorow, it need some time to collect stats.

akanevsky
05-29-2009, 12:18 PM
I uninstalled your previous one, v 1.4.4 and installed this one but as soon as I enable it I am getting this error

Fatal error: Cannot redeclare cache_styles() (previously declared in /home/*****/public_html/includes/adminfunctions_template.php:2249) in /home/*****/public_html/includes/local_links_include.php on line 1036


Maybe if you can send me your ftp info via pm, I could take a look, because right now I have no idea what this error might be caused by.

Well,
This think broke all my template.

any idea of how to turn it to the correct side?

http://www.acuarios-marinos.com/reefman/imagenes/image002.jpg

http://www.acuarios-marinos.com/reefman/imagenes/image004.jpg

Why would it be on the wrong side in the first place?
You should install the standard vBulletin style and it will be from left to right.

Megatr0n
05-29-2009, 01:42 PM
Will, this back be updated soon to fix the latest bugs?

akanevsky
05-29-2009, 02:02 PM
What bugs are there?

Megatr0n
05-29-2009, 02:30 PM
Not sure any specific but guessing there's a few with a few people having problems and mentioning getting error messages.

Was just wondering, I'll install it and give it ago.

Tacama
05-29-2009, 02:30 PM
Maybe if you can send me your ftp info via pm, I could take a look, because right now I have no idea what this error might be caused by.



Why would it be on the wrong side in the first place?
You should install the standard vBulletin style and it will be from left to right.

Errr.... he has the standard vbulletin style... I had exactly the same problem.

The problem is with the translations. All my forum was completely messed up until i removed the language.

Will try to reinstall this mod later and i'll come back with anything new.

Megatr0n
05-31-2009, 02:11 PM
Will, this hack be updated with new features previously requested in the thread, anytime soon?

akanevsky
06-24-2009, 04:42 PM
Yes, I will fix bugs soon, and also integrate Referrer Statistics into this mod.

kalisekj
06-24-2009, 05:19 PM
ok I Installed, Looks Nice and will wait a day or 2 for the other stats to populate, question I downloaded the dark styles icons,, where do I place these and do I need to change anything to make them appear?

NVM Figured it Out :D now that the others stats are showing up.

akanevsky
06-26-2009, 11:28 AM
Release: Version 1.6.0.

Two major additions, plus a lot of bugs were fixed.
Please see the first post for a detailed list of changes.

(30 minutes later):

Release: Version 1.6.1.

Navbar link is now shown only to users who can access the statistics.

ubcforums
06-26-2009, 01:42 PM
Thanks For Update :)

bleros
06-26-2009, 04:15 PM
thnx for update

66mustang93
06-28-2009, 01:44 PM
Installed, but nothing...can't view anything, like it's not there...usng 3.8.1

I should add that it does not appear in my quick links.

Same issue in 3.8.3

I can manually browse to the page though.

nascartr
06-28-2009, 02:54 PM
The hooks that this mod calls for must be missing in the templates on the installations that the link doesn't show up.

RedHacker
06-29-2009, 06:10 AM
For update must upload product or all files....?

Makc666
06-30-2009, 11:21 AM
It will be nice to add a space before "$vbphrase[psistats_display_colors]":

<span class="smallfont"><strong>$depth[bits] $vbphrase[psistats_display_bits] ($depth[colors]<if condition="is_numeric($depth[colors])">$vbphrase[psistats_display_colors]</if>)</strong></span>

:)

SirHappy
06-30-2009, 11:32 AM
For update must upload product or all files....?

yes.

Matrixthestar
06-30-2009, 12:00 PM
yes.

yes what
product or all files

Makc666
06-30-2009, 12:32 PM
For update must upload product or all files....?
It is always depends on what version you have.

So, just upload the files and this will be ok.

|Jordan|
07-01-2009, 01:24 AM
It would be great if on the "Referring Sites Statistics" section of admincp, entire domains can be hidden from view. For example, i i see several referrers that are subdomains of free email providors. Rather then hiding each individually, it would be great to be able to hide referrers from the whole domain (eg. by125w.bay125.mail.live.com , by126w.bay126.mail.live.com , etc.).

skol
07-02-2009, 07:46 AM
Same issue in 3.8.3

I can manually browse to the page though.


I uninstalled the product then re-installed it again and it worked.The link is on vb default skin quick links, if you have a custom style you'll have to add it manually.

66mustang93
07-06-2009, 11:35 PM
I uninstalled the product then re-installed it again and it worked.The link is on vb default skin quick links, if you have a custom style you'll have to add it manually.

It does have a custom style. Thank you for the response.

trotskid
07-11-2009, 01:24 PM
It will be very useful if there are an option to hide some stats for members or usergroups :)

Celebutopia
07-26-2009, 08:48 AM
worked fine on a test board
install on my board and had a strange pb (can't memorise what part of stats 'general', 'browser' and so on .. i wanna display) so i've uninstalled it and had the same kind of error

grrr .. love this feature

Was all working fine then I had to disable it.. I only have this Database error.


Database error in vBulletin 3.8.1:
Invalid SQL:
REPLACE INTO `vb_psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('63.241.57.214', 'country', '63.241.57.214_country'), ('Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 3.0.30618; .NET CLR 3.5.30729)', 'useragent', '63.241.57.214_useragent');
MySQL Error : Incorrect file format 'vb_psistats_cache'
Error Number : 130
Request Date : Friday, March 6th 2009 @ 03:27:26 AM
Error Date : Friday, March 6th 2009 @ 03:27:26 AM
Script : http://www.mysite/index.php?
Referrer : http://www.mysite/showthread.php?p=498&styleid=7
IP Address : 63.241.57.214
Username : me
Classname : vB_Database
MySQL Version : 5.0.75-community-log


disabled till there is a fix

SorentoUltimate
07-31-2009, 09:03 PM
after installation i go to put the settings
when i save these message appear

Warning: Invalid argument supplied foreach() in [path]/includes/adminfunctions_options.php(490):eval()'d code on line 26

any idea ?

SorentoUltimate
08-01-2009, 09:20 AM
Unistall and Install again but ste same message when i check the modules @ Admin Control Panel !!!!!!!

Devanand
08-04-2009, 03:58 AM
It doesn't show visitors from Serbia, like that country doesn't exist.
80% of my traffic is from this country. Can you please add Serbia in list?

LifesGreatestGift
08-08-2009, 01:56 AM
how can I add Windows 7 to the recognized Operating systems? Its User Agent string is Windows 6.1

Thank you

akanevsky
08-10-2009, 02:09 PM
how can I add Windows 7 to the recognized Operating systems? Its User Agent string is Windows 6.1

Thank you

Open ./includes/psistats/database_agent.php, find:

'Windows XP' => array('winnt5.1', 'windows nt 5.1'),

Add above:

'Windows 7' => array('winnt6.1', 'windows nt 6.1'),

This should do it.

relaxiha
08-10-2009, 06:46 PM
Hello. Please Update for Windows can both Opera 10 and 7
Icons for Windows 7 how to replace

relaxiha
08-10-2009, 07:31 PM
psistats.php?do=demographics
Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT COUNT(*) as X
FROM userfield
WHERE field5 = 'male';

MySQL Error : Unknown column 'field5' in 'where clause'
Error Number : 1054
Request Date : Monday, August 10th 2009 @ 08:27:33 PM
Error Date : Monday, August 10th 2009 @ 08:27:33 PM
Script : http://************.com/forums/psistats.php?do=demographics
Referrer : http://**********com/forums/psistats.php?do=os
IP Address : *****************
Username : **********
Classname : vB_Database
MySQL Version : 5.0.81-community

akanevsky
08-11-2009, 12:53 AM
Well, you have to add a custom userfield for gender first, and then configure psiStats options correctly.

NTMID8
08-22-2009, 11:39 PM
Open ./includes/psistats/database_agent.php, find:

'Windows XP' => array('winnt5.1', 'windows nt 5.1'),

Add above:

'Windows 7' => array('winnt6.1', 'windows nt 6.1'),

This should do it.
Thanks. Its showing stats for Windows 7 now great. How do I had an icon for Win7 though?

NTMID8
08-29-2009, 11:48 PM
Any chance we can get the top search words or phrases that led to our site in the next release? I know my cpanel reports that along with most of the other stats you are currently reporting, so was hoping it would be possible.

NTMID8
09-01-2009, 02:10 AM
I'd like to submit a request to have Most Thanked Users and Most Thanked Posts added to the stats.

i.s.s.w
09-18-2009, 03:37 AM
thank x


look error after uninstalling

Database error in vBulletin 3.8.4:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('212.43.7.2', 'country', '212.43.7.2_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 GTB5 (.NET CLR 3.5.30729)', 'useragent', '212.43.7.2_useragent'), ('900x1440', 'screenresolution', '212.43.7.2_screenresolution'), ('32', 'screendepth', '212.43.7.2_screendepth');

twista46
10-01-2009, 07:11 PM
I become this Error in ACP if i change Usegroup settings

Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderatoren',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"font-weight:bold; font-style:italic; color:#0066FF;\" title=\"Moderator\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`vbpt_permissions` = '6',
`userjaq` = '0',
`forumpermissions` = '12312063',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '75535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '70000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`sfmpermissions` = '0',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_size||1|||core||allo w_bbcode_font||1|||core||allow_bbcode_align||1|||c ore||allow_bbcode_list||1|||core||allow_bbcode_url ||1|||core||allow_bbcode_code||1|||core||allow_bbc ode_php||0|||core||allow_bbcode_html||0|||non_core ||hide||1|||non_core||Spoiler||1|||non_core||nfo|| 1|||non_core||mod||1'
WHERE usergroupid=7;

MySQL-Fehler : Unknown column 'userjaq' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 01.10.2009 @ 22:04:06
Datum : Thursday, 01.10.2009 @ 22:04:06
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2

|Jordan|
10-03-2009, 02:10 PM
This mod could really use a function in the AdminCP to easily clear the stats. Another great thing to have would be an archive feature where after each month or set period, the stats are archived and cleared for the next time period.

NTMID8
10-03-2009, 06:09 PM
Thanks. Its showing stats for Windows 7 now great. How do I had an icon for Win7 though?

Any chance we can get the top search words or phrases that led to our site in the next release? I know my cpanel reports that along with most of the other stats you are currently reporting, so was hoping it would be possible.

I'd like to submit a request to have Most Thanked Users and Most Thanked Posts added to the stats.

Any word on any of these?

lnxtr
10-05-2009, 06:15 AM
where is demo?

twista46
10-05-2009, 06:58 PM
No idea ??


Datenbankfehler in vBulletin 3.8.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderatoren',
`description` = '',
`usertitle` = '',
`opentag` = '<span style=\"font-weight:bold; font-style:italic; color:#0066FF;\" title=\"Moderator\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`vbpt_permissions` = '6',
`userjaq` = '0',
`forumpermissions` = '12312063',
`genericpermissions` = '1609504463',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '75535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '70000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`sfmpermissions` = '0',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_ size||1|||core||allow_bbcode_font||1|||core||allow _bbcode_align||1|||core||allow _bbcode_list||1|||core||allow_bbcode_url||1|||core ||allow_bbcode_code||1|||core| |allow_bbcode_php||0|||core||allow_bbcode_html||0| ||non_core||hide||1|||non_core ||Spoiler||1|||non_core||nfo||1|||non_core||mod||1 '
WHERE usergroupid=7;

MySQL-Fehler : Unknown column 'userjaq' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Thursday, 01.10.2009 @ 22:04:06
Datum : Thursday, 01.10.2009 @ 22:04:06
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny2

akanevsky
10-05-2009, 07:24 PM
No idea ??

The message says:

MySQL-Fehler : Unknown column 'userjaq' in 'field list'

Some other mod (not this one) failed to add column "userjaq" to the usergroup table, but it is trying to access that column. Hence, there is an error message. Please try to find out which hack causes this problem by disabling all your hacks one-by-one. Once you find the correct hack, you can uninstall it or ask the author of that hack to fix it.

BigDog56
10-06-2009, 12:09 AM
Works like a charm! thank you!

realmr
10-15-2009, 10:20 AM
can we limit referrer stats based on month or date ?? i.e user registered from 1Oct only should be visible instead of the entire list, the other referrer stats add-on isn't working as expected for 3.8 and as u mentioned the support will b given only here, can u help me

BucWiLd
10-15-2009, 02:16 PM
Installed .. thank you.. look forward to some updates.


edit: i just went to enable the dempgraphics page and when i clicked it i got a database error. anyone know what i did wrong?
i have this hack for gender https://vborg.vbsupport.ru/showthread.php?t=196749..
i think i may be entering the demographics gender field wrong.

help.... thanks

Tanapangarap
10-18-2009, 06:56 AM
Hi.

Is there a way to allow regular members to view the statistics?

Regards,

Kevin

gunboard
10-18-2009, 07:38 AM
Thanks. Its showing stats for Windows 7 now great. How do I had an icon for Win7 though?

put the attachment (named windows7.gif) in the directory ../includes/psistats/database_os .... finished :rolleyes:

for a seperated Vista pic open psistats.php

find

case 'Windows Vista':

replace

// case 'Windows Vista': :D

put a pic with name windowsvista.gif in the ../includes/psistats/database_os directory

greets, Uwe (gunboard.de) (nick:megashooter) for more questions (sorry for my bad english)

akanevsky
10-19-2009, 12:49 PM
Installed .. thank you.. look forward to some updates.


edit: i just went to enable the dempgraphics page and when i clicked it i got a database error. anyone know what i did wrong?
i have this hack for gender https://vborg.vbsupport.ru/showthread.php?t=196749..
i think i may be entering the demographics gender field wrong.

help.... thanks

This hack already includes a gender field ... you do not need another hack.

BucWiLd
10-19-2009, 02:07 PM
got it... thanks

NTMID8
10-20-2009, 02:01 AM
put the attachment (named windows7.gif) in the directory ../includes/psistats/database_os .... finished :rolleyes:

for a seperated Vista pic open psistats.php

find



replace

:D

put a pic with name windowsvista.gif in the ../includes/psistats/database_os directory

greets, Uwe (gunboard.de) (nick:megashooter) for more questions (sorry for my bad english)
Thank you very much!

woffie
10-20-2009, 08:53 PM
Great tool!

BucWiLd
10-27-2009, 04:34 PM
any update coming to show how many users using windows 7?

ricardoNJ
10-27-2009, 07:03 PM
I have a problem: When I' click in "psistats.php" / Show All....
...you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


I'm Administrator of my forum.

TheInsaneManiac
10-29-2009, 02:44 AM
I love how it says Stats 2007 lol.

akanevsky
10-31-2009, 01:29 AM
any update coming to show how many users using windows 7?

Yes.

I love how it says Stats 2007 lol.

Where? :)

Tanapangarap
10-31-2009, 07:07 PM
Hi.

As mine was the last post on the previous page, I just want to bump it to make sure it was seen:

Hi.

Is there a way to allow regular members to view the statistics?

Regards,

Kevin

trotskid
10-31-2009, 11:58 PM
put the attachment (named windows7.gif) in the directory ../includes/psistats/database_os .... finished :rolleyes:

for a seperated Vista pic open psistats.php

find



replace

:D

put a pic with name windowsvista.gif in the ../includes/psistats/database_os directory

greets, Uwe (gunboard.de) (nick:megashooter) for more questions (sorry for my bad english)

Thank you :up:

Here is the logo of Symbian. Just import to includes/psistats/database_os directory.

Jeweetog
11-07-2009, 02:14 PM
Hi,

Where would the installation dir of vbulletin be?

"Please upload the files from under the "upload" directory in the archive into your vBulletin installation directory."

Thanks in advance!

Jeweetog
11-10-2009, 08:48 AM
Hi,

How do i 'run' the installer if i managed to upload it to the right dir?

Jeweetog
11-13-2009, 02:37 PM
Hi,

I've managed to install the product, but it seems that "Usergroups Allowed To View Statistics" option doesn't work. I fill in 'Administrators' and then reload the main page of the forum and i don't see the link. But once i remove the 'Administrators' from that usergroups field, it works fine.

What am i doing wrong?

josantos
11-14-2009, 07:26 PM
It don't works on my forum :down:

Jeweetog
11-15-2009, 10:22 AM
It don't works on my forum :down:

which one do you have?

Jeweetog
11-16-2009, 09:15 AM
Hi,

I've managed to install the product, but it seems that "Usergroups Allowed To View Statistics" option doesn't work. I fill in 'Administrators' and then reload the main page of the forum and i don't see the link. But once i remove the 'Administrators' from that usergroups field, it works fine.

What am i doing wrong?


It seems that i have to put the ID of the usergroup. Don't ask me how i found out!

Jeweetog
11-24-2009, 08:31 AM
I think i found a bug in this mod.

Read this topic:

http://www.vbulletin.com/forum/showthread.php?327733-most-users-ever-online

Jeweetog
11-30-2009, 07:43 AM
Disregard my last post.

Uninstalled.

Oliver G
12-22-2009, 03:17 AM
Will PsiStats 2009 be uprgraded to vBulletin 4?

realmr
12-27-2009, 09:49 AM
r u planning to release the add-on for vb4 ?

Jackie1
12-27-2009, 12:16 PM
When ver 1.6.2 release for vbb 4.0.
I like this mod so much :"> but it's dont work on vb 4

Emmmmrz
12-31-2009, 05:31 AM
I also would like a younger age group shown; my forum is very much based on teen usage. Would it be possible to add an option so you can change the age display options in the adminCP?

My desired age group settings:
10-13
14-16
17-19
20-30
31-40
41-69
70+^ from the other demographics mod's thread.


Is there any chance that you might add Thanks (https://vborg.vbsupport.ru/showthread.php?t=165673)/Groans (https://vborg.vbsupport.ru/showthread.php?t=193489), vBCredits (https://vborg.vbsupport.ru/showthread.php?t=172399), vBExperience (https://vborg.vbsupport.ru/showthread.php?t=199556), iTrader (https://vborg.vbsupport.ru/showthread.php?t=230543), ibProArcade (https://vborg.vbsupport.ru/showthread.php?t=101554) scores, vBulletin Diary (https://vborg.vbsupport.ru/showthread.php?t=223880), Articles (https://vborg.vbsupport.ru/showthread.php?t=211638), PhotoPlog (https://vborg.vbsupport.ru/showthread.php?t=101368)/Album count, Smilie Info (https://vborg.vbsupport.ru/showthread.php?t=137287), Topic Nominations (https://vborg.vbsupport.ru/showthread.php?t=223607), Member Interaction (https://vborg.vbsupport.ru/showthread.php?t=180803), and/or other (configurable) profile fields as well? All optional of course...


I realize that is a lot of feature requests (all of which seem very complicated from this side of the screen), but it would make an awesome paid stat hack for your site. *ducks and covers*

d0zer
12-31-2009, 06:07 AM
thanks you

macjoshua
01-05-2010, 10:49 AM
Will PsiStats 2009 be uprgraded to vBulletin 4?

dendrob
01-19-2010, 02:38 PM
Is it possible to reset the invitation stats to zero? I want to run an invitation contest (using the psiInvites2.0).

3 top people with most invites win prizes...however I already have bunch of invites generated...it would be nice to be able to reset the counter to zero...run a contest, give prizes then update counter and have the real numbers of invites again. I'm assuming, this is wishful thinking... Can someone confirm?

dendrob
02-01-2010, 12:20 PM
wow... takes a while to get a reply here

akanevsky
02-28-2010, 12:19 PM
Is it possible to reset the invitation stats to zero? I want to run an invitation contest (using the psiInvites2.0).

3 top people with most invites win prizes...however I already have bunch of invites generated...it would be nice to be able to reset the counter to zero...run a contest, give prizes then update counter and have the real numbers of invites again. I'm assuming, this is wishful thinking... Can someone confirm?

What invitation stats are there in this hack? Do you mean referrer stats?

akanevsky
02-28-2010, 12:25 PM
Released version 1.6.2 that adds recognition for Windows 7. To upgrade, replace ./includes/psistats/database_agent.php with the new file from the 1.6.2 archive.

RedHacker
02-28-2010, 08:56 PM
Can update to the vBulletin 4 please...?

Don Z.
03-06-2010, 01:01 PM
This files in this download are v 1.6.1, not 1.6.2. The code in the XML file says <version>1.6.1</version>.

How do I get the 1.6.2 files?

Jackie1
03-06-2010, 01:17 PM
do you have plan for this mod in vb4?

akanevsky
03-06-2010, 01:43 PM
This files in this download are v 1.6.1, not 1.6.2. The code in the XML file says <version>1.6.1</version>.

How do I get the 1.6.2 files?

The XML is wrong. It is the 1.6.2 version. The XML was not updated - only ./includes/psistats/database_agent.php was updated in 1.6.2.

Don Z.
03-06-2010, 04:08 PM
Thanks. I wasn't seeing any Windows 7 stats but I am now. That's all I was looking for when I upgraded to 1.6.2.

Thanks again, I love this mod.

Manoel J?nior
03-07-2010, 12:26 AM
do you have plan for this mod in vb4?

myke2008
03-23-2010, 09:05 PM
do you have plan for this mod in vb4?

This question has been asked so many times in this thread, he is obviously not going to answer it until he either figures out how to do it or gives up.

Manoel J?nior
03-23-2010, 10:07 PM
This question has been asked so many times in this thread, he is obviously not going to answer it until he either figures out how to do it or gives up.
Thank you for your education.

ehd
03-27-2010, 11:08 AM
Hi, nice hack, thanks, works fine :D

Is there a way to log the full path of referring sites?

For example:

www.thissite.com/linkpage.html

instead of

www.thissite.com

Thanks :D


How much more load puts it on the server based on your experiences?

Falcon Capt
05-17-2010, 07:54 PM
Is there a plan to release this mod ported for vB4???

If there is not, please let us know so we can find an alternative.

Thank you for your work on this excellent mod. :up:

johkalhaups
05-18-2010, 04:09 AM
http://img443.imageshack.us/img443/7108/nowin7icon.jpg

I just installed this today and Im getting no icon for Win7.

TheInsaneManiac
05-22-2010, 01:35 PM
My settings for this modification are not updating. All other modifications update fine. The modification will save all settings, but modules, and ONLY if I disable all the modules.

THE PSIStats page remains blank as well.

TheInsaneManiac
05-29-2010, 03:49 AM
My settings for this modification are not updating. All other modifications update fine. The modification will save all settings, but modules, and ONLY if I disable all the modules.

THE PSIStats page remains blank as well.

I have tried uninstalling and reinstalling.

TheInsaneManiac
05-29-2010, 04:35 AM
nvm its the new version of vboptimise causing issues...

TheInsaneManiac
05-29-2010, 04:46 AM
I would like to know why I have a ton of members, but on the Operating Systems it only ranges to in the 20s for highs instead of the hundreds, since I have thousands of members....

persianpros
06-10-2010, 10:21 AM
Persian Language For psiStats

By Persian Prince

Good Luck

Falcon Capt
07-29-2010, 12:37 AM
Is there a plan to release this mod ported for vB4???

If there is not, please let us know so we can find an alternative.

Thank you for your work on this excellent mod. :up:

Eric
08-18-2010, 04:29 PM
Not marked as "Re-usable Code", however, I'm assuming since the release post mentions it's licensed under the GPL - there'd be no problem for another developer to update & release a version for vB4?

Viddek
08-20-2010, 05:24 PM
I think it would be great to have this for vb4

Dj Smuggla
09-13-2010, 06:12 PM
Does anyone else get these errors, sent as emails:


Database error in vBulletin 3.8.6:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('65.52.17.163', 'country', '65.52.17.163_country'), ('Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0)', 'useragent', '65.52.17.163_useragent');

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, September 13th 2010 @ 01:46:04 PM
Error Date : Monday, September 13th 2010 @ 01:48:01 PM
Script : http://www.---------------------.com/showthread.php?t=36041
Referrer :
IP Address : **.52.1*.1**
Username : Unregistered
Classname : vB_Database
MySQL Version :


Ive had 100's of these over the last few months & today i had 12 in 3 minutes.

Psionic, Can you look into this m8?

Thanks

mdawg
04-03-2015, 04:24 AM
How about making this for vb 5 - vb5 is the wave of the future!

esskmk
11-25-2020, 06:03 AM
Thanks!