psiStats 2010 (The New vBStats for vBulletin 4.0.x)

[akanevsky]

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*===================================*\
|| psiStats 2010
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 4.0.x
|| Released : Sep 19, 2010
||
|| Time required to install: 3 minutes
|| Difficulty: easy
\*===================================*/

DESCRIPTION

A sophisticated statistics module for your vBulletin board.

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.

STATISTICS

File Uploads: 1
Products to Install: 1


FEATURES

Statistics Tracking:

General Board Statistics
Style Usage Statistics
Top Threads & Forums Statistics
Display Colors + Resolutions (Requires JavaScript) Statistics
Countries + Regions Statistics
Browsers + Operating Systems Statistics
Referring Sites Statistics
Referrer Statistics
Age & Gender Demographics


Features:

No code or template modifications required.
Modules can be enabled or disabled, as needed.
Statistics are updated every fifteen minutes via cron.
Mother site, e.g. the site where your forum is hosted, will never be listed as a referrer.
Only one extra query per forum page.
Statistics can be sorted either numerically or alphabetically.
Automatic Integration with Referrer Statistics (if installed)[/i]
Configurable number of last items for top threads / forums.
Allows to specify whether to show data from from forums with post counts disabled.
Configurable number of last items in referring site statistics.
Configurable gender field and responses (optional).
Configurable list of usergroups that can access statistics (optional).
Referring site statistics censure (by word) and individual site blockage.
Detects most popular browsers and operating systems.
Requires cookies for screen color depth and resolution tracking.


VERSION HISTORY

1.7.1 - stable
[F] Fixed a few minor template bugs.

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

1.6.2 - stable
[+] Added recognition for Windows 7-based user agents.

1.6.1 - stable
[+] The navbar link is now shown only to those who can access the statistics.

1.6.0 - stable
[+] Added two new modules: Referrer Statistics Age & Gender Demographics
[+] Added Google Chrome recognition (this includes a matching icon).
[+] Added Setting to control whether top threads & forums data is gathered from forums where posts are not counted towards user post counts.
[+] Updated ip to country databases to the most recent ones.
[F] Corrected a few phrasing bugs and phrased things that were not phrased in 1.5.2.

1.5.2 - stable
[+] Added a few more translations (thanks to those who submitted these).
[+] Fixed a few bugs that were mentioned for 1.5.1.

1.5.1 - stable
[+] Added option to globally enable / disable any stats modules.
[+] Fixed bug with some staff being counted twice.
[+] All numbers are now nicely formatted.

1.5.0 - stable
[+] No more template edits, just upload the files and the product and you're ready to go.
[+] vBulletin 3.5.x - 3.8.x compatible.

1.4.4 - stable
[+] Referrering Sites now have a JS and an XML feed capability.
[+] Added a better firefox icon into the icon database.
[F] Fixed a couple of minor bugs.

1.4.3 - stable
[+] The hack now respects vBulletin's "Show Active Users" setting.
[+] The hack is now valid XHTML (all templates must be reverted).

1.4.2 - stable
[+] Corrected a bug, which caused incorrect number of moderators to be displayed.
[+] gb.gif renamed to uk.gif.

1.4.1 - stable
[+] The front page has been revised, and it now loads four times as fast regardless of the size of your database.
[+] The ip database has been updated to the revision of October 18, 2006.
[+] The flag database has been updated to the revision of October 18, 2006.
[+] Referrer statistics hack, if installed, is now detected automatically. No configuration required.
[+] Added an option to specify a custom board creation date, if not reflected correctly by the joindate of a user with lowest userid.

1.4.0 - stable
[+] The system is now cross-compatible with both vBulletin 3.5 and 3.6.
[+] The ip database has been updated to the revision of August 30, 2006.
[+] A variety of code optimizations and template corrections have been done.
[+] To keep statistics legible, the engine now only tracks the major and the minor browser versions. X.Y.Z.E is now stripped to become X.Y.

1.3.2 - stable
[+] Since more browsers support cookies than ajax, screendepth/screenresolution tracking is now done via cookies.
[+] One less query per page - e.g. now it's only one query per page.
[+] Statistics are now updated every 15 minutes rather than every hour.
[F] Fixed faulty count in cron and in region stats screen.
[F] Fixed bug which prevented the cron from being created in some cases.
[F] Fixed minor bugs which caused errors of the E_NOTICE level.

1.3.1 - stable
[F] Fixed AJAX coding error, which used synchronous ajax instead of asynchronous, evidently causing higher load.
[F] Fixed WOL error that was caused by AJAX stats update and that made it look like everyone is browsing the stats.
[F] Fixed a query in update cron.

1.3.0 - stable
[+] Yay, no more file edits! :)
[+] No more multiple queries. The hack now takes up a maximum of two (2) queries per page in contemporary browsers, and one (1) query in non-javascript browsers.
[+] New vBulletin Option: Statistics can be configured either numerically or alphabetically.
[+] Since Opera is updated way too often, the engine, from now on, will only identify the primary version marker (7,8,9 as opposed to 7.01, 7.02, 7.21, 8.01 etc).
[+] Templates and phrases are now in their own separate group.
[F] Eliminated a bug which prevented bot identification from working properly.

1.2.8 - beta
[+] Removed 5 queries during the stats recording.
[+] Countries mapped to valid cia abbreviations and the countrybit template has been updated.
[+] Added missing Fiji flag (Thanks to firstrebel!)
[F] Eliminated a bug which prevented the thread and post limit from having any effect.
[F] Eliminated a bug which prevented the browser identification from working properly in some cases.

1.2.7
[F] Corrected online users count.
[F] Corrected staff count.
[F] Eliminated the style stats bug, which originated from users who had invalid styles saved in their profiles.
[F] Eliminated the posts per day bug.
[F] Renamed "gb.gif" to "uk.gif"
[F] Renamed "Oceania" region to "Australia and Oceania".
[F] Only threads and forums to which the user has permissions are displayed in top threads and forums.

1.2.6
[F] Minor template fix.

1.2.5
[+] Rewritten Browser and OS detection (previosly somebody else's module was used).
[F] For staff stats, only primary usergroups are now counted.

1.2.1
[+] New "Usergroups Allowed To View Stats" admincp option.
[+] Navigation split in two rows, for greater view
[+] Crawlers now have a browser picture associated with them.
[F] Eliminated Tracking of Empty Referrers.
[F] Updated country database with a number of missing countries, including UK.
[F] Minor fix to style statistics screen, applying to styles that are not used.

1.2.0
First Official Release.

1.1.0
Development release; Excess queries, phrases, and code has been removed.

1.0.0
Development release; All phrases that were hard-coded were moved into the phrase system.

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=250773)

[akanevsky]

First Post Reserved for Q&A.

[mgcom]

Excellent

Does it have viewing permissions ?

Edit just read it does, nice work

[mgcom]

XML Error: Invalid character at Line 962

[akanevsky]

XML Error: Invalid character at Line 962

When and how did you get that error?

[hatiramolsun]

database_agent

database_flag

database_os

no images ?

link: http://www.aykocity.com/psistats.php?do=os

[akanevsky]

database_agent

database_flag

database_os

no images ?

link: http://www.aykocity.com/psistats.php?do=os

Did you upload the images?

It seems to me that you have not.

http://www.aykocity.com/includes/psistats/database_agent/internetexplorer.gif
http://www.aykocity.com/forums/includes/psistats/database_agent/internetexplorer.gif
http://www.aykocity.com/includes/psistats/database_agent/googlechrome.gif
http://www.aykocity.com/forums/includes/psistats/database_agent/googlechrome.gif

These URL's do not work, which implies that you have not uploaded the images to your site. Please upload them and it will work.

[hatiramolsun]

I've uploaded all the files


click link: http://www.aykocity.com/psistats.php?do=os

What is the problem?

[hatiramolsun]

in my site root directory
Not in the forum folder

[akanevsky]

in my site root directory
Not in the forum folder

I tried to access the images both from the forums folder and from the root folder. Neither one works - I can't open the images in my browser. This means they are either not uploaded or blocked by some script from being displayed (such as anti-leech script).

[hatiramolsun]

Well yet another way of showing pictures ????

How can I solve this problem ?

sorry my English is not good

[akanevsky]

Well yet another way of showing pictures ????

How can I solve this problem ?

sorry my English is not good

Could you please upload all the images?

Thanks.

[Dennis Kaczor]

I missed this from the old 3.X days when I switched to vb 4.X.
Installed and is working great, glad to see this ported over to version 4.

[hatiramolsun]

Could you please upload all the images?




yes all images upload

[sulasno]

tagged and thanks

[mgcom]

When and how did you get that error?

when i was importing the product from admin cp

[ellinofatsa]

1)i have upload the folder name upload in my ftp.
2)insert the xml named product-psistats.
3) bad not working i cant not schow the statics! ! what i doing wrong???

4,07

[akanevsky]

when i was importing the product from admin cp

I exported the product XML using vBulletin's product export tool. There shouldn't be any broken code in it since it was generated automatically. Maybe there's something wrong with your installation. When I import the product to my installation, it works fine.

If you care to send me your admincp details via pm, maybe I can take a look at it and troubleshoot it.

1)i have upload the folder name upload in my ftp.
2)insert the xml named product-psistats.
3) bad not working i cant not schow the statics! ! what i doing wrong???

4,07

You should have uploaded the CONTENTS of the folder to your VBULLETIN ROOT. Is this what you have done?

[Skyrider]

I'm getting a blank screen except on the default skin of vB4.. doesn't seem to work on the custom style I'm using.

[Paul M]

when i was importing the product from admin cp
Download it again. Sometimes files get slightly corrupted as they are downloaded or unzipped.

[Leica.Robbiani]

Hi Psionic,

thank you for upgrading this one to vB4, works perfectly. Since I have upgraded my board to vB4 I was missing this mod.

Best regards

L.R.

[Scan Cape Cod]

Very nicely done, and appreciated. First time install for me; works dandy. Marked as installed, excellent, and nominated. Thanks.

[ellinofatsa]

I exported the product XML using vBulletin's product export tool. There shouldn't be any broken code in it since it was generated automatically. Maybe there's something wrong with your installation. When I import the product to my installation, it works fine.

If you care to send me your admincp details via pm, maybe I can take a look at it and troubleshoot it.



You should have uploaded the CONTENTS of the folder to your VBULLETIN ROOT. Is this what you have done?

yes that i have do!:)

[TheLastSuperman]

I like ya but follow the rules please ;).

https://vborg.vbsupport.ru/showthread.php?threadid=203767
*Last Update: 28 Feb 2010

https://vborg.vbsupport.ru/showthread.php?t=250773

https://vborg.vbsupport.ru/announcement.php?f=245&a=45

Edit: This is one of the few I appreciate the update on so Installed :D.

[ellinofatsa]

can i have a litle help please for that mod?
i have upload all the files bud i cant see statics?
i upload all the files from upload folder all the settings ok bud i dont see anithing sory for that bud litle more help.

thank you

[basilrath]

5 mins - like a charm

Nice work

[akanevsky]

I like ya but follow the rules please ;).

https://vborg.vbsupport.ru/showthread.php?threadid=203767
*Last Update: 28 Feb 2010

https://vborg.vbsupport.ru/showthread.php?t=250773

https://vborg.vbsupport.ru/announcement.php?f=245&a=45

Edit: This is one of the few I appreciate the update on so Installed :D.

Thank you for this information.

[mgcom]

can i have a litle help please for that mod?
i have upload all the files bud i cant see statics?
i upload all the files from upload folder all the settings ok bud i dont see anithing sory for that bud litle more help.

thank you

check the user permissions, none are set on install you need to do it yourself, then its under quick links

[akanevsky]

Updated to version 1.7.1. Fixed a few template bugs. To upgrade, just re-import product XML with the overwrite option set to "yes".

[sulasno]

Installed and working in 4.0.7

note : including instructions on how to access the options would be helpful;

Site Statistics is located in the navtab Quick Links;

thanks mgcom

[sulasno]

Bug

Style Usage: Not showing correct style

Countries & Regions : Classifications of Regions

Operating Systems: Possible to include Windows 7 ?

[akanevsky]

Style Usage: Not showing correct style

It shows the styles chosen in User CP, not via the quick style chooser.

Operating Systems: Possible to include Windows 7 ?

Windows 7 is included.

[sulasno]

I use 4.0.7 style generator to create a style known as "vB Style Generator"
(This is the default style used; will conduct further testing)
Your mod shows style as Yellow :-)

edit

ps I got 2 users using 2 different style;

me bad; I just noticed Windows 7

[PJSkiboy]

Great mod. Had this installed on my 3.8.4 board, glad to see this now available for 4.0.x.

Much thanks!

[Bob_R]

I can't unzip the download.

Can I/we get a re-up?

Thanks!!

[Bob_R]

Actually I did manage to unzip it.

Can someone provide a demo (in English). :)

[PJSkiboy]

I can't unzip the download.

Can I/we get a re-up?

Thanks!!

I just downloaded the .zip file not 3 hours ago and it unpacked just fine.

Have you tried downloading it again?

[haidm]

Why the newest member in this mod and the newest member in forum index is different?

[sulasno]

It shows the styles chosen in User CP, not via the quick style chooser.

Style usage is showing correct statistics

[SABRSox]

Format error in the zip file.

[Skyrider]

Style usage is showing correct statistics
Not for me.. it's showing 0, and it only shows 1 style while I have 5 installed.

[PJSkiboy]

Not for me.. it's showing 0, and it only shows 1 style while I have 5 installed.

Ditto.

I only have 2 styles installed, but it shows everyone as having the same style in use when I know that isn't the case. I'm running 4.0.6.

[Popa Andrei]

Smae problem with the styles at me to and ussing 3 styles with vb 4.0.7

[Bob_R]

Can someone provide a demo (in English). :)

Anyone?

[akanevsky]

Why the newest member in this mod and the newest member in forum index is different?

Possibly because one of those two pages is outdated. Try refreshing.

Not for me.. it's showing 0, and it only shows 1 style while I have 5 installed.

The system only shows those styles which are user selectable.

[rayden512]

Is there a way to refresh the style usage? It shows all of my 2000+ users are using one style. That can't be correct, for one, i'm not using it, and 2, it's now even the default style. My guess no more then 20 people are using that one.

https://vborg.vbsupport.ru/external/2010/10/41.png

[akanevsky]

Is there a way to refresh the style usage? It shows all of my 2000+ users are using one style. That can't be correct, for one, i'm not using it, and 2, it's now even the default style. My guess no more then 20 people are using that one.

Are there other styles that are set as selectable?
Are you sure the styles are chosen in user cp and not in the quick chooser?

[rayden512]

Yes, i have 11 styles selectable. Yes, they are chosen in cp - mine for one is chosen in CP.

[rayden512]

Also, i have another question. In the stats it says that the forum began in 1970, with is of course false - the forum began in 2007.
How can i change this?

[Skyrider]

Possibly because one of those two pages is outdated. Try refreshing.

The system only shows those styles which are user selectable.
All my styles are user selectable. All options are tagged in the style options menu within the AdminCP.

[WILFMAN]

Top Job - exactly what I was looking for...neh, more than what I was looking for!

Thanks v much

[haidm]

How can I add more group in Staff in Members Stats?

[akanevsky]

Also, i have another question. In the stats it says that the forum began in 1970, with is of course false - the forum began in 2007.
How can i change this?

It is possible that your database got corrupt at one point and the joindate of the oldest registered member does not correctly reflect the date of forum's creation.

There's a setting you can set in the settings that is called "Date of Creation of Your Board". Set it to the correct value and that should solve your problem.

Yes, i have 11 styles selectable. Yes, they are chosen in cp - mine for one is chosen in CP.

All my styles are user selectable. All options are tagged in the style options menu within the AdminCP.

The problem has been fixed in version 1.7.2. Please download and install by overwriting the product file as well as the psistats.php file.

How can I add more group in Staff in Members Stats?

The only way to do so is by further hacking this hack.

[rayden512]

Thank you very much, everything works now!

[haidm]

I have a problem with my style when using this mod like in images in attach (when I'm in mydomain.com/psistats.php). How can I fix this?

[akanevsky]

I have a problem with my style when using this mod like in images in attach (when I'm in mydomain.com/psistats.php). How can I fix this?

What doesn't work? I don't see a problem on your screen shots.

[haidm]

Please see the border of the forum in two images, you will see the problem.

[PreciseDemise]

Hi, you've got the Mod listed as version 1.7.2, but the changelog only shows 1.7.1, is theree missing information, or is hte Mod number in error?

[Skyrider]

Thanks for the update! Just wanted to report small issue:

Powered by psiStats 2010 v{$version}
I think the version should be shown :p.

Also I'm having issues loading up the images within a few pages... EG:

/includes/psistats/database_flag/al.gif

Going to the IMG URL brings me to the main page. Any idea what's up? Maybe images within includes are being re-directed?

[akanevsky]

Thanks for the update! Just wanted to report small issue:


I think the version should be shown :p.

That was fixed in the version 1.7.2. Please revert all templates you may have modified.

Also I'm having issues loading up the images within a few pages... EG:

/includes/psistats/database_flag/al.gif

Going to the IMG URL brings me to the main page. Any idea what's up? Maybe images within includes are being re-directed?

Maybe the flag isn't there because you didn't upload it? Please check.

[sulasno]

will this mod be updated to include IE 9 and Opera 11 ?

[persianpros]

Persian Translation :cool:

By Persian Prince

[sulasno]

using this hack to check the current version

https://vborg.vbsupport.ru/showthread.php?t=255054

there is an error;

[HellBoy]

will this mod be updated to include IE 9 and Opera 11 ?I would like this as well. As it is now, Opera 9, 10 and 11 are all identified as Opera 9.

Opera 11 id string:
Opera/9.80 (Windows NT 6.1; U; nb) Presto/2.7.62 Version/11.00

[Lexor]

Looks good !
Is there a way to display the top referrer Links in a widget oder Block ?

[BadgerDog]

Downloaded, but unable to UNZIP file ... says "the operation is NOT permitted"? :confused:

Regards,
Doug

[SuperTaz]

Error:


Database error in vBulletin 4.1.0:
Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_psistats AS phrasegroup_psistats,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;
MySQL Error : Unknown column 'phrasegroup_psistats' in 'field list'
Error Number : 1054
Request Date : Thursday, December 30th 2010 @ 09:06:44 PM
Error Date : Thursday, December 30th 2010 @ 09:06:44 PM
Script : http://www.xxxxxxxxxxx.com/forums/psistats.php
Referrer :
IP Address : 66.249.68.139
Username :
Classname : vB_Database
MySQL Version :

[New Joe]

Where should this be sowing?
I have installed the xml file, uploaded everything to the correct folder but it just doesn't show anywhere on my Forum.

[andyv72]

can anyone create a German lang ??

[inshooter]

I have downloaded the file at least half-a-dozen times and I get this error:

Unable to unarchive "psoStats.2010_1.7.2_Psionic.Vision.zip" into "vbulletin addons".

It will NOT unzip.

[20KingSize]

This is brilliant, but I've noticed a couple of things.

It doesn't seem to be recognising Android or iOS as an operating system.
It doesn't recognise any of the Android Browsers (Skyfire, Dolhpin HD etc).
It doesn't recognise users logged in via Tapatalk.

One of the main reasons for my installing this is to compare how many users log with their mobile devices and whether they use tapatalk or a mobile browser, to see if its worth creating new styles for them.

This is not a major gripe and I don't mean to sound like I'm complaining because I appreciate how much work you've already put into this, but I am just wondering whether these few things will be updated at any time?

[War.Frog]

Error:

Database error in vBulletin 4.1.0:
Invalid SQL:
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_psistats AS phrasegroup_psistats,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;
MySQL Error : Unknown column 'phrasegroup_psistats' in 'field list'
Error Number : 1054
Request Date : Thursday, December 30th 2010 @ 09:06:44 PM
Error Date : Thursday, December 30th 2010 @ 09:06:44 PM
Script : http://www.xxxxxxxxxxx.com/forums/psistats.php
Referrer :
IP Address : 66.249.68.139
Username :
Classname : vB_Database
MySQL Version :

I get the same error and have for months and months. Any resolution on this??

[Speedy1505]

this error when FlashGame save score

Fatal error: Call to a member function escape_string() on a non-object in [parth]/forum/global.php(37) : eval()'d code on line 51
on this line in your product
// initialize replacements array
$replacements = array(
"('" . IPADDRESS . "', 'country', '" . IPADDRESS . "_country')",
"('" . $db->escape_string($_SERVER['HTTP_USER_AGENT']) . "', 'useragent', '" . IPADDRESS . "_useragent')"
);

[S3Ponline]

Looks interesting.

[Bob_R]

Is this working with vbulletin 4.12?

Thanks!

[Wordplay]

One of the main reasons for my installing this is to compare how many users log with their mobile devices and whether they use tapatalk or a mobile browser, to see if its worth creating new styles for them.
this is also what i am looking for.

once this mod or any other mod comes with this feature and works on 4.1.2 somebody please pm me and let me know!

[BANDiT600]

Nice, works for me for 4.1.2.

[BadgerDog]

Downloaded, but unable to UNZIP file ... says "the operation is NOT permitted"? :confused:

Regards,
Doug

Any fix for this yet, or can someone else post a valid ZIP file ...

Thanks .. :)

Regards,
Doug

[BANDiT600]

Any fix for this yet, or can someone else post a valid ZIP file ...

Thanks .. :)

Regards,
Doug
Use WinRAR to unzip. All works fine!

[BadgerDog]

Use WinRAR to unzip. All works fine!

I'm using an Apple MacBook Pro and have never had a problem with ZIP files before ...

Your ZIP file unzipped just fine .. thank you very much ... :)

Regards,
Doug

[sulasno]

any updates to reflect statistics for Chrome 13 and Firefox 6 ?

[reddyink]

This this MOD add the statistics by Usergroups? Thanks

[NTMID8]

Having a problem. Most stats are working fine but I can not change any options as the psiStats 2010 option does not show up under Settings in my AdminCP. I have re-upped the files and re-imported the XML with the same results. Very odd.

[NTMID8]

Having a problem. Most stats are working fine but I can not change any options as the psiStats 2010 option does not show up under Settings in my AdminCP. I have re-upped the files and re-imported the XML with the same results. Very odd.

I had the same issue but eventually found the options were merged uder the Site Statistics option. Look for that one.

[Konsolenheld]

Using 4.0.6, I cant select the different Modules, i only see the Site "General". All modules are active.

[S@NL - BlackBik]

Installs flawless on 4.1.8

[Dragaon]

Fast, easy install. Nice mod, Thanks!
I've been waiting for something like this. :)
Odd that I haven't noticed it in the year or so since its release.

[Bob_R]

Can anyone provide a link to a working site with this mod? Preferably in english.

Thanks.

[GhostHunter2010]

nice one i like it thanks for sharin with us

[Merjawy]

I know this is an old mod but still works on 4.1.10 and very nice.. thanks

I hope the author still around.. few issues
it only pulls data from the default usergroups, I have other usergroups including new members and the data from the extra usergroups don't get pulled
for mods/s-mods and new users

I haven't looked at the code yet to see if I can fix it.. other than that, it seems to be working ok

I noticed rather few people having issues, like images don't show.. make sure they are uploaded correctly (binary) and in the right place.. and for where to find the mod on your forum? its under quick links :) (it took me a while to find it)


Thanks

[Merjawy]

Very strange, my server is unreachable now.. I hope it's nothing to do with this mod I just installed :) and its not just my IP, I tried from another and I get error 502

[Merjawy]

Ok, I am back.. after 24 hours exactly, the server is back and found

About the stats data, I take that back.. it reads data from all groups but the banned one
It won't list the number of Mods unless they are listed under at least one forum. (kinda make sense)

[|Jordan|]

With this mod (v1.7.2) installed on vb 4.1.11 i get the following error on my forum:

Database error in vBulletin 4.1.11:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('x.x.x.x', 'country', 'x.x.x.x_country'), ('Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.24) Gecko/20111103 Firefox (.NET CLR 3.5.30729)', 'useragent', 'x.x.x.x_useragent');

MySQL Error : Table 'xxxxxxxxxxxx.psistats_cache' doesn't exist
Error Number : 1146
Request Date : Thursday, March 8th 2012 @ 03:32:13 AM
Error Date : Thursday, March 8th 2012 @ 03:32:13 AM
Script : http://xxxxxxxxxxxxxxx/forum.php
Referrer : http://xxxxxxxxxxxx/adm1ncp/index.php?do=head
IP Address : x.x.x.x
Username : Admin
Classname : vB_Database
MySQL Version : x.x.x.x

Any idea how to fix? This is a new installation of VB with only a few other mods installed.

[Nirjonadda]

Iinstalled...Still Works On 4.1.10

[Tri@de]

someone tested it on 4.1.11?

[|Jordan|]

Nevermind. I got it to work by changing a few lines in the xml file.

For those of you that also use newer versions of MySQL server you will need to:

1) At line 28 and line 35 change "TYPE=MyISAM" to "ENGINE=MyISAM"
2) Uninstall the plugin from your board and reinstall the one you just modified (reinstalling without uninstalling first will not fix it).

[lapiervb]

Anybody using this with 4.2?

[Tri@de]

Anybody using this with 4.2?

Me. The only thing i had to do is adding a navbar button to the stats page.

[myke2008]

For some reason my referral statistics have NOT changed since I first installed this mod about 2 months ago, all the information is stuck and not changing, except for the top thread and forum information, this seams to work.

in the control panel when I choose referring site statistics it says this,

There are no referring sites in the database at this time.

If anyone can offer some idea's I would appreciate it. What can I try to start the diagnostic procedure?

2 separate domains hosted on the same account, one website shows the referral statistics fine, while the second one dose not.

Is there some cache that I can try clearing? possibly a directory with the wrong permissions?

I have tried the following so far:
1.waiting (2 months)
2.installing again, overwriting the files
3.rebuilt statistics

[Nirjonadda]

Please any update for work on 4.2.0 ?

[ikorolis]

installed VB 4.2.x and works fine for now.

[Nirjonadda]

installed VB 4.2.x and works fine for now.

Add link is not appearing in navbar or Quick Links Menu?

[tanzeelniazi]

Not Working in Vb4.2.0 :(
DataBase Error

[nrms?]

With this mod (v1.7.2) installed on vb 4.1.11 i get the following error on my forum:



Any idea how to fix? This is a new installation of VB with only a few other mods installed.
Same problem/error...

[ikorolis]

works fine vb 4.2.1

[ikorolis]

i have recieve this error (error.log)

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

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

sorry coder

[RedHacker]

Database error in vBulletin 4.1.7:

Invalid SQL:

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

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

Can help with this problem ?

Forget it the solution is here : https://vborg.vbsupport.ru/showpost.php?p=2307694&postcount=96

[Rakehel]

Most everything still works for us in vB 4.23 Patch X. It's s shame when some of these better mods aren't kept up. I don't have enough knowledge to help.

[BasilFawlty]

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