PDA

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


Pages : [1] 2

akanevsky
01 Oct 2006, 15:55
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 (http://www.vbulletin.org/forum/vborg_miscactions.php?do=installhack&threadid=203767)

akanevsky
01 Oct 2006, 15:55
FAQ

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

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

Q: Can I limit viewing of the stats to certain usergroups?
A: Yes. Go to vBulletin Options -> psiStats 2006 and edit that.

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

Q: A country flag is missing.
A: There are some missing flags, yes. If you have a flag icon of the same format, it'll be much appreciated if you can send it to me.

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

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

kenanulas
01 Oct 2006, 16:00
second mine:D
thanks

Deepdog009
01 Oct 2006, 16:05
Kbp 2 Kbp4 :D


Beauts *** Checkmate :cool:

akanevsky
01 Oct 2006, 16:21
Question to everyone:

On some large boards, the browser stats parts get very large due to the fact that there is a lot of different browser versions. What approach would you guys recommend to shorten that list?

Example of a long list: http://waw-df.com/forum/psistats.php

Edit:

I changed it not to track more than the major and the minor versions. E.g., if a version if X.Y.Z, it'll only track X.Y. To reset browser stats, run this query:

DELETE FROM `psistats_data` WHERE `ctype` = 'browser'

hotwheels
01 Oct 2006, 16:36
wow, simply amazing work..........again

Thanks so much for sharing your mod's with us. It seem's simply flawless.

I attatched a working image of it from my site. AMAZING.

morrow
01 Oct 2006, 16:41
Download doesn't work

akanevsky
01 Oct 2006, 16:43
Try again, I've been updating the file.

Endurer
01 Oct 2006, 16:47
Awesome mod. Can I change the update interval? It can become resource intensive for fairly large boards therefore I'd like to increase the update time.. Is it possible?

akanevsky
01 Oct 2006, 16:47
Awesome mod. Can I change the update interval? It can become resource intensive for fairly large boards therefore I'd like to increase the update time.. Is it possible?

The smaller the update time, the less is the load. :) 15 minutes is the optimal delay for large boards esspecially.

morrow
01 Oct 2006, 17:19
Very nice hack! I've installed it with no issues so far. Thanks for your hard work.


<--! Clicks Install --> :)

Phooey
01 Oct 2006, 17:28
Awesome. I'm so glad you decided to make this for 3.6.X. Definately one of my favorite hacks.

/installs

gedsta
01 Oct 2006, 17:37
installed and thx

Yorixz
01 Oct 2006, 17:39
Very glad it's updated now, installed here as well!

Ronak
01 Oct 2006, 18:00
Was Waiting for this hack for a long time to be released !! Awesome :) Nominated !! for MOTM

akanevsky
01 Oct 2006, 18:02
Was Waiting for this hack for a long time to be released !! Awesome :) Nominated !! for MOTM
Thanks, much appreciated. :)

hotwheels
01 Oct 2006, 18:37
Awesome :) Nominated !! for MOTM I second that click..... :D

Foxter
01 Oct 2006, 18:38
Anthony, your hack is brilliant as ever! Thank you so much! :)

BruceWest
01 Oct 2006, 18:51
Installed! Thanks so much! I'll let you know how things turn out.

hotwheels
01 Oct 2006, 19:30
For those running php portals and want this in the drop down quick links, just add <tr><td class="vbmenu_option"><a href="/forums/psistats.php$session[sessionurl_q]">$vbphrase[psistats_link]</a></td></tr> underneath <tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr> in your p_block_navbar.....works like a champ.

Darat
01 Oct 2006, 19:31
I've installed this and everything seems to be working but in "Countries:"
it isn't reporting anyone from the UK? I've just checked and several of our UK Members are posting (I'm also posting from the UK). I've checked the IP addresses and they do resolve to the UK. Any ideas?

gedsta
01 Oct 2006, 19:31
Hi

Have installed and it would appear that all the UK members are showing as North America, is there anything i need to do or will it sort itslef out?

Great hack btw

lexx27
01 Oct 2006, 19:42
I get this error

Database error in vBulletin 3.6.1:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user 'webz'@'localhost' to database 'webz_gr_-_forum'
Error Number : 1044
Date : Sunday, October 1st 2006 @ 09:30:46 PM
Script : http://www.webz.gr/forum/ajax_cron.php?rand=469666
Referrer :
IP Address : 212.251.121.219
Username : guest
Classname : vb_database

zendiver
01 Oct 2006, 19:43
I am playing around with this on my test site and receive this when I go to 'Referring Stats Statistics' in the vBulleting Options part of the ADMINCP

The referring sites database is empty.

Also, when going to the statistics, it seems that only the first row of links work, the rest of them shows NO data.

Using 3.5.4 and 3.6 on my test sites.

akanevsky
01 Oct 2006, 19:47
Hi

Have installed and it would appear that all the UK members are showing as North America, is there anything i need to do or will it sort itslef out?

Great hack btw

It may report some countries incorrectly, there's nothing that can be done about it. The most likely cause is that the IP traces to North America - but the party responsible for it is your ISP.

I get this error

Please make sure that you have LOCK and UNLOCK permission turned on for your mysql user. If you don't know how to check that, please contact your hosting provider.

I am playing around with this on my test site and receive this when I go to 'Referring Stats Statistics' in the vBulleting Options part of the ADMINCP

The referring sites database is empty.

Also, when going to the statistics, it seems that only the first row of links work, the rest of them shows NO data.

Using 3.5.4 and 3.6 on my test sites.

As stated in the first reserved post, the statistics are updated every 15 minutes. So the stats will appear after a while.

zendiver
01 Oct 2006, 19:56
Thanks Andrew...I went ahead and tried to run the cron from the AdminCP and got a db error...I will wait. :)

akanevsky
01 Oct 2006, 20:15
Thanks Andrew...I went ahead and tried to run the cron from the AdminCP and got a db error...I will wait. :)

You'll wait for what? The error is caused by server configuration, and I explainded how to fix it in my previous post.

gedsta
01 Oct 2006, 20:17
thx for previous answer

however now i have

Members: 1274 | Staff: 17 (2 admins, 15 s-mods, 0 mods) | Active: 718 |

It has assigned all the normal mods to super mods - any ideas?

zendiver
01 Oct 2006, 20:25
You'll wait for what? The error is caused by server configuration, and I explainded how to fix it in my previous post.
I own my server and have no problems with LOCK / UNLOCK...what I meant when I said, "I will wait" is for the 15 minute interval to pass. :D

akanevsky
01 Oct 2006, 21:44
thx for previous answer

however now i have

Members: 1274 | Staff: 17 (2 admins, 15 s-mods, 0 mods) | Active: 718 |

It has assigned all the normal mods to super mods - any ideas?

It counts people that have IS_MODERATOR permission turned on in their usergroup as supermoderators (except admins, of course).

I own my server and have no problems with LOCK / UNLOCK...what I meant when I said, "I will wait" is for the 15 minute interval to pass.

So, did it pass yet? :)

zendiver
01 Oct 2006, 21:50
{snip}So, did it pass yet? :){/snip}
Yes sir, it sure did my friend...thank you. Now I am going over the information shown in each of the stats....will let you know what I find. ;)

Excellent MOD Andrew....Good work!

akanevsky
01 Oct 2006, 22:05
Yes sir, it sure did my friend...thank you. Now I am going over the information shown in each of the stats....will let you know what I find. ;)

Excellent MOD Andrew....Good work!

I beg you a pardon, but who is Andrew?

zendiver
01 Oct 2006, 22:27
Sorry about that 'ANTHONY'...client that just left my office was named Andrew....please accept my apologies. :D

eNforce
01 Oct 2006, 22:39
I had the 3.5.4 version and loved it.

Install went smoothly on my 3.6 board, thanks!

Snake
01 Oct 2006, 22:44
Thanks a bunch! I was waiting for this.

Emanet-Kaos
01 Oct 2006, 22:46
awsome hack thanks :O)

Darat
01 Oct 2006, 22:50
It may report some countries incorrectly, there's nothing that can be done about it. The most likely cause is that the IP traces to North America - but the party responsible for it is your ISP.

...snip...

I'm seeing exactly the same problem - manually checking the IP traces of the UK members they are all resolving to the UK.

akanevsky
01 Oct 2006, 23:00
Sorry about that 'ANTHONY'...client that just left my office was named Andrew....please accept my apologies. :D

No problem. :)

I'm seeing exactly the same problem - manually checking the IP traces of the UK members they are all resolving to the UK.

Please give me some sample IP addresses of yours and I'll see if there is anything that can be done.

smoknz28
01 Oct 2006, 23:29
Very well done! ;)

Thank you for sharing this code with the rest of us. :D

Mark

oberheimhaven
01 Oct 2006, 23:40
Per usuall!! Another Kick @ss Hack!!! Thxs for the hard work and the awesome errorless hack zero issues in 3.6.0
Thxs again
MarkAnthony
MusiciansQuarters!!!:cool:

smoknz28
02 Oct 2006, 00:50
Okay, I have found some features not working.

I've installed this mod and ran the cron task manually a couple of times to see if I can get the stats to show up when going to the Site Statistics link in the navbar quick links.

It shows the Forum Stats, and Top Threads and Forums.....however, when I click on the other links to show me Display Colors and Resolutions or Countries and Regions, etc....I don't get any stats coming back to me.

Any help on this is greatly appreciated. ;)

Mark
www.f-bodyhideout.com/forums

akanevsky
02 Oct 2006, 01:25
Okay, I have found some features not working.

I've installed this mod and ran the cron task manually a couple of times to see if I can get the stats to show up when going to the Site Statistics link in the navbar quick links.

It shows the Forum Stats, and Top Threads and Forums.....however, when I click on the other links to show me Display Colors and Resolutions or Countries and Regions, etc....I don't get any stats coming back to me.

Any help on this is greatly appreciated. ;)

Mark
www.f-bodyhideout.com/forums

They do not appear immediately - and make sure you've done template modifications, too.

syrus.xl
02 Oct 2006, 01:48
Nice script apart from the UK resolving problem.

I've been monitoring my site most of the evening, and know most of the users that have been online, using the site are from the UK. Yet not once as their been any sign of a UK flag.:confused:

I have seen similar scripts to this before, and even they put me in the US. lol I wouldn't mind being in San Francisco with the current horrid weather here in the UK! :D

RS_Jelle
02 Oct 2006, 06:21
/me clicks unistall for the 3.5 version and install for the 3.6 version :)

A small bug: the version number isn't showing in the footer.

Darat
02 Oct 2006, 11:14
...snip...

Please give me some sample IP addresses of yours and I'll see if there is anything that can be done.

One of the ones I checked was: 86.129.226.157 - when I do a "WhoIs" lookup (using www.dnsstuff.com) I got the following:

Location: United Kingdom [City: Bath, England]

% This is the RIPE Whois query server #2.
% The objects are in RPSL format.
%
% Note: the default output of the RIPE Whois server
% is changed. Your tools may need to be adjusted. See
% http://www.ripe.net/db/news/abuse-proposal-20050331.html
% for more details.
%
% Rights restricted by copyright.
% See http://www.ripe.net/db/copyright.html

% Information related to '86.128.0.0 - 86.135.255.255'

inetnum: 86.128.0.0 - 86.135.255.255
remarks: ******************************************************
remarks: * Please send abuse reports to *****@btbroadband.com *
remarks: ******************************************************
netname: BT-CENTRAL-PLUS
descr: IP pools
country: GB
admin-c: BTCP1-RIPE
tech-c: BTCP1-RIPE
status: ASSIGNED PA
remarks: Please send abuse notification to *****@btbroadband.com
mnt-by: BTNET-MNT
mnt-lower: BTNET-MNT
mnt-routes: BTNET-MNT
changed: ********@bt.com 20050223
source: RIPE




That shows the country as "GB" and I looked in your database_country.php file and noticed that there is a entry for the "UK" but not for "GB" - so I made a new entry:

"GB" => array("United Kingdom", "Europe", "London", "Pound Sterling", "uk")

And now it looks as if it is correctly distinguishing UK visitors?

gedsta
02 Oct 2006, 12:11
That shows the country as "GB" and I looked in your database_country.php file and noticed that there is a entry for the "UK" but not for "GB" - so I made a new entry:

"GB" => array("United Kingdom", "Europe", "London", "Pound Sterling", "uk")

And now it looks as if it is correctly distinguishing UK visitors?

works for me as well, just no image for country

renamed uk.gif to gb.gif and now it works

akanevsky
02 Oct 2006, 13:08
* RS_Jelle clicks unistall for the 3.5 version and install for the 3.6 version :)


A small bug: the version number isn't showing in the footer.

Fixed...

That shows the country as "GB" and I looked in your database_country.php file and noticed that there is a entry for the "UK" but not for "GB" - so I made a new entry:

"GB" => array("United Kingdom", "Europe", "London", "Pound Sterling", "uk")

And now it looks as if it is correctly distinguishing UK visitors?

That would be it, I forgot to replace all instances of GB with UK when I downloaded a new version of the database. It's fixed now - please download the new archive, overwrite the XML and reupload database_ip under includes/psistats/.

Darat
02 Oct 2006, 13:22
Will do - thanks

syrus.xl
02 Oct 2006, 13:53
Cool... working fine now with UK. :)

Great hack.

smoknz28
02 Oct 2006, 14:12
They do not appear immediately - and make sure you've done template modifications, too.

Yea, verified that I made the template changes in the two templates and they are there.

Here's my forums: www.f-bodyhideout.com/forums

Thanks

akanevsky
02 Oct 2006, 14:37
Yea, verified that I made the template changes in the two templates and they are there.

Here's my forums: www.f-bodyhideout.com/forums

Thanks

Perhaps you have cron or plugins disabled then...

Gripemaster
02 Oct 2006, 15:40
I LOVE this hack!

I have 1.3.2 already installed, do I just need to import/overwite the product xml?

Thanks for the great mods.

akanevsky
02 Oct 2006, 16:10
The upgrade instructions are posted in the vBulletin 3.5 thread of this hack :).

Blittz
02 Oct 2006, 17:14
Installed and working perfectly. I especially love your checkbox installation list, very very well done.

Live demo: http://racketradio.com/forum/psistats.php

Zelda-King
02 Oct 2006, 17:15
Excellent! The cron URL error I always got on the old version is gone. :)

MrNase
02 Oct 2006, 19:45
One very minor request: Could you please use the vB number formats when you release a new version?
Right now '34,000' is displayed as '34000'. :)

gedsta
02 Oct 2006, 20:46
small piece of help

I did the change before with the GB field and now having done your updated instructions i have 2 UK values

The first one has now stopped counting as per your fix, how would i remove them values?

tia

akanevsky
02 Oct 2006, 22:04
small piece of help

I did the change before with the GB field and now having done your updated instructions i have 2 UK values

The first one has now stopped counting as per your fix, how would i remove them values?

tia

You shouldn't have done your fix in the first place. To remove GB, run this query:

DELETE FROM `psistats_data` WHERE `ctype` = 'country' AND `cdata` = 'GB'

dragonhart
02 Oct 2006, 22:45
thank you great addon Dragonhart

gedsta
02 Oct 2006, 23:16
You shouldn't have done your fix in the first place. To remove GB, run this query:

Thanx again :rolleyes:

Dennis Kaczor
03 Oct 2006, 01:54
Installed and working perfectly. I especially love your checkbox installation list, very very well done.

Live demo: http://racketradio.com/forum/psistats.php

Wow, I was impressed that ths could be put on the main page, now I have to find out how to do this. Thanks for sharing your site for us to view.

Dennis

Dennis Kaczor
03 Oct 2006, 02:01
Very nice job love the program, and the one question I have is that this only shows up in the Quick Links area, is there a way to show the stats on the front end in the forums. For give me, but I sort of learning as a go here and cannot seem to find a way to do this.

I commend you for writing great docs for the install of this program, and I was very impressed with the check boxes, very professional looking.

Thanks in advance

Dennis

smoknz28
03 Oct 2006, 03:19
Perhaps you have cron or plugins disabled then...

Obviously I'm some where boogered up here cause there are plenty who are running this with no problems.

I went in and found that my cron task is working as it just ran on it's own about 5 mins from my posting of this. Also looked to see that all the psiStats plugins were checked as Active.

Just can't get this to show the browsers, etc.....

akanevsky
03 Oct 2006, 03:28
Wow, I was impressed that ths could be put on the main page, now I have to find out how to do this. Thanks for sharing your site for us to view.

Dennis

You can't put it on the main page, not without using up unnecessary resources for people who don't want to see the stats. His link in no different that the default setup.

Very nice job love the program, and the one question I have is that this only shows up in the Quick Links area, is there a way to show the stats on the front end in the forums. For give me, but I sort of learning as a go here and cannot seem to find a way to do this.

I commend you for writing great docs for the install of this program, and I was very impressed with the check boxes, very professional looking.

Thanks in advance

Dennis

Yup, I actually like my checkboxes too. :)

Obviously I'm some where boogered up here cause there are plenty who are running this with no problems.

I went in and found that my cron task is working as it just ran on it's own about 5 mins from my posting of this. Also looked to see that all the psiStats plugins were checked as Active.

Just can't get this to show the browsers, etc.....

Something's wrong with your vBullletin then. What version are you running, and what hacks?

Gripemaster
03 Oct 2006, 03:51
The upgrade instructions are posted in the vBulletin 3.5 thread of this hack :).

Thank you. Wonderful hack.

*Installed/Upgraded* :)

Rich
03 Oct 2006, 11:45
Something's wrong with your vBullletin then. What version are you running, and what hacks?

I have the same problem, so my vBulletin must be wrong too. lol I am running 3.5.5 on my dev site. Cron and plugins are both functioning correctly.

I know this may sound like a stupid question, but will the cron appear in the schedule tasks manager? I ask, because I don't have any scheduled tasks that run off of the psistats_update.php file in there.

perfphysio
03 Oct 2006, 21:16
my stadard stats from the forum itself are working e.g. top threads, forums topics etc and members, online etc.

However stuff that seems to look at new stored data from elsewhere e.g. countries, browsers, colours, screen etc is all empty with no results. Have I missed something? I have installed it three times now in case something g corrupt somewhere? What I already have makes this an excellent hack but i'd like to have it all

akanevsky
03 Oct 2006, 21:33
I have the same problem, so my vBulletin must be wrong too. lol I am running 3.5.5 on my dev site. Cron and plugins are both functioning correctly.

I know this may sound like a stupid question, but will the cron appear in the schedule tasks manager? I ask, because I don't have any scheduled tasks that run off of the psistats_update.php file in there.

Please post vBulletin 3.5 issues in vBulletin 3.5 thread and vBulletin 3.6 issues in the vBulletin 3.6 thead of this hack.

perfphysio
03 Oct 2006, 22:49
Don't know what happened to my post about part of the stats system not working. Anyway I looking in the scheduled taksa dn it is there but when i view the logs there is no reference to it ever being done. Now I ran it manuall from there and got the following database error:

Database error in vBulletin 3.6.1:

Invalid SQL:
LOCK TABLES vb_psistats_cache READ, vb_psistats_data READ;

MySQL Error : Access denied for user: 'bobforum@%' to database 'physiobobforum'
Error Number : 1044
Date : Tuesday, October 3rd 2006 @ 02:46:04 PM
Script : http://www.physiobob.com/forum/admincp/cronadmin.php?do=runcron&cronid=30
Referrer : http://www.physiobob.com/forum/admincp/cronadmin.php?do=modify
IP Address : 81.151.146.110
Username : physiobob
Classname : vb_database


Any ideas?

tekstylez
03 Oct 2006, 22:54
Any idea why this is not showing up in my quick links? All the template edits were done...

Is this hack 3.6.1 specific?

akanevsky
03 Oct 2006, 23:06
Don't know what happened to my post about part of the stats system not working. Anyway I looking in the scheduled taksa dn it is there but when i view the logs there is no reference to it ever being done. Now I ran it manuall from there and got the following database error:

Database error in vBulletin 3.6.1:

Invalid SQL:
LOCK TABLES vb_psistats_cache READ, vb_psistats_data READ;

MySQL Error : Access denied for user: 'bobforum@%' to database 'physiobobforum'
Error Number : 1044
Date : Tuesday, October 3rd 2006 @ 02:46:04 PM
Script : http://www.physiobob.com/forum/admincp/cronadmin.php?do=runcron&cronid=30
Referrer : http://www.physiobob.com/forum/admincp/cronadmin.php?do=modify
IP Address : 81.151.146.110
Username : physiobob
Classname : vb_database


Any ideas?

That question is answered both in the FAQ post and earlier in this thread. :)

Any idea why this is not showing up in my quick links? All the template edits were done...

Is this hack 3.6.1 specific?

Absurd. If template edits were done correctly, the hack shows up under quick links. If it does not show up, you can logically conclude that template edits were not done correctly.

perfphysio
03 Oct 2006, 23:12
That question is answered both in the FAQ post and earlier in this thread. :)



Absurd. If template edits were done correctly, the hack shows up under quick links. If it does not show up, you can logically conclude that template edits were not done correctly.

I don't see this anywhere being answered in this thread? And can you provide the link to the FAQ's please.

tekstylez
03 Oct 2006, 23:12
then im lying.... i checked the template edits multiple times... they are done

akanevsky
03 Oct 2006, 23:39
I don't see this anywhere being answered in this thread? And can you provide the link to the FAQ's please.

It's the second post in this thread.

then im lying.... i checked the template edits multiple times... they are done

The fact is, this works on an unhacked vBulletin version 3.6.0/3.6.1. If it doesn't work that it's either you did something wrong, or your vBulletin is too heavily modified and some hack is conflicting with this one.

Tork64
03 Oct 2006, 23:53
amazing stuff, installed, thanks!

edit: Mine also doesnt show up in quick links.

akanevsky
04 Oct 2006, 00:49
amazing stuff, installed, thanks!

edit: Mine also doesnt show up in quick links.

So then you also have a modified quick links?
For example, this site:
http://www.brassreview.com/forums/psistats.php (to the admin of the site: I looked this up via google, if you are not ok with the link having been posted, please let me know).
does not even have a quick links. which makes it impossible for a link to the hack to show up under a quick links that does not even exist. Use common sense to determine what the problem is...

Floris
04 Oct 2006, 11:57
This is really cool. I will talk to my staff on vbfans if we should install this: I think we should :D Very cool stuff, vbstats by bane is my fav hack and this is the perfect follow up i think. Could this add a big lag on big sites? resource problems or just performing fine?

Tork64
04 Oct 2006, 13:44
Uninstalled it. Followed everything in the instructions (not the hardest thing to install) Dont think it likes one of my other mods.

akanevsky
04 Oct 2006, 19:52
This is really cool. I will talk to my staff on vbfans if we should install this: I think we should :D Very cool stuff, vbstats by bane is my fav hack and this is the perfect follow up i think. Could this add a big lag on big sites? resource problems or just performing fine?

No, it won't add any lag unless you start increasing delay for cron runs.

perfphysio
04 Oct 2006, 19:59
I don't see this anywhere being answered in this thread? And can you provide the link to the FAQ's please.

Just for reference my situation was fixed by the following response from my adminsitrator: The lock permission is granted for bobforum on database physio............

regards to all

akanevsky
04 Oct 2006, 20:08
Just for reference my situation was fixed by the following response from my adminsitrator: The lock permission is granted for bobforum on database physio............

regards to all
That's what I was talking about - contact your host when you get that error. :)

smoknz28
05 Oct 2006, 01:46
Something's wrong with your vBullletin then. What version are you running, and what hacks?

Sorry it took so long to get back on this. Here are the following mods I have installed on my vB 3.6.1:

Bills PayPal Donate 1.31
FlashChat Integration 3.06
Members who are using flashchat 4.32
Members who are using flashchat (Add-on) 1.01
Multiple Login Detector 1.03
psiStats 2006 1.4.0
v3 Arcade 1.0.6
vBadvanced CMPS 2.2.0
vbgooglemap Member Edition by StonyArc 2.5.2
Zoints Profile System 1.4.4

Thanks for any help on this one.

Mark
www.f-bodyhideout.com/forums

daylight
05 Oct 2006, 02:10
nice work, and Istalled and it works great..
thanks first of all for this hard work
just a question !
is there any way to see those users list who belongs to any piticular countries? like say uk have 5 users here. can i see who those 5 users are?
and same as style ...can i see which users are using what?
thanks

akanevsky
05 Oct 2006, 03:13
Sorry it took so long to get back on this. Here are the following mods I have installed on my vB 3.6.1:

Bills PayPal Donate 1.31
FlashChat Integration 3.06
Members who are using flashchat 4.32
Members who are using flashchat (Add-on) 1.01
Multiple Login Detector 1.03
psiStats 2006 1.4.0
v3 Arcade 1.0.6
vBadvanced CMPS 2.2.0
vbgooglemap Member Edition by StonyArc 2.5.2
Zoints Profile System 1.4.4

Thanks for any help on this one.

Mark
www.f-bodyhideout.com/forums

Try disabling your other hacks one by one and running cron every time, see which one conflicts.

is there any way to see those users list who belongs to any piticular countries? like say uk have 5 users here. can i see who those 5 users are?

No, that is not possible, as it does not even track specific users.

RS_Jelle
06 Oct 2006, 15:57
A little suggestion:

Add a url and a versioncheck to the product file. Very easy to do and it makes the product management of your site a bit easier :)

Zelda-King
07 Oct 2006, 15:41
This doesn't seem to show the UK. I get shown under the US.

mcyates
07 Oct 2006, 16:24
I get a server 500 error which is weird. I have a shared server so i might not have something installed. But i'm not sure what it might be.

akanevsky
07 Oct 2006, 17:15
This doesn't seem to show the UK. I get shown under the US.

Download the latest package and overwrite the psistats database folder.

perfphysio
07 Oct 2006, 17:41
HI all, I have this hack working nicelt on my vBulletin 3.6.2. The one things the whole hack doesn't seem to mention is what is the actual stats showing me. i.e. for country and region stats, it this the numbers for the current month? Is it overall, it is accumulative until I reset it etc etc.

Also how is that decision made. Is is via the IP of the user when logged in, is it from any visitor via their local IP, is it a resolution of the ISP?

USA always wins out in stats packages due to the generic .com and we all know not everyone with a .com ending is in the USA. The same with .net. If it is users IP then this is somewhat better but if someone can help me understand the actual data this would be great.

Many thanks :)

akanevsky
07 Oct 2006, 19:18
HI all, I have this hack working nicelt on my vBulletin 3.6.2. The one things the whole hack doesn't seem to mention is what is the actual stats showing me. i.e. for country and region stats, it this the numbers for the current month? Is it overall, it is accumulative until I reset it etc etc.

Also how is that decision made. Is is via the IP of the user when logged in, is it from any visitor via their local IP, is it a resolution of the ISP?

USA always wins out in stats packages due to the generic .com and we all know not everyone with a .com ending is in the USA. The same with .net. If it is users IP then this is somewhat better but if someone can help me understand the actual data this would be great.

Many thanks :)

The country is identified based on the ip address and the ip2country database that the hack package contains.

perfphysio
07 Oct 2006, 19:37
The country is identified based on the ip address and the ip2country database that the hack package contains.

Thanks, and the stats themselves for the countries and regions? Are they cummulative? Are they for the current month?

akanevsky
07 Oct 2006, 20:45
Cumulative.

perfphysio
07 Oct 2006, 21:11
OK, thanks.

As a suggestion for the future it would be great to have a few options from the top of the page when viewing. e.g. Cummulative stats as standard, quarterly option, and monthly option for both country, referral and top forums and posts would be excellent. I suppose you could work that out from a data datestamp somewhere that we store in the logs or in a table in the database.

Keep up the good work :)

Zelda-King
07 Oct 2006, 22:58
Download the latest package and overwrite the psistats database folder.That did the job. Thanks for the quick fix!

GrendelKhan{TSU
08 Oct 2006, 14:23
nice !
installed.

future feature:


* executive summary page.
(general is ok, but would love to see all the stuff laid out on one page - two columns with graphics. perhaps top 3-5 for each stat.)

just a thought. great job anyway. :)

amnesia623
09 Oct 2006, 07:56
Nice job on this one!

Hoffi
09 Oct 2006, 08:25
I just mentioned that this is not fully Phrased. In the Footer Template the Link "Referrer Sites" is Hardcoded.

I would be fine If you can change is for the next release.

Mike-D
10 Oct 2006, 11:29
Anthony,
you wrote regarding the Template modification...

In template(s) headinclude

FIND: <if condition="$vboptions['externalrss']">

Add Above:

<script type="text/javascript">
document.cookie = "psistats_screenwidth = " + self.screen.width;
document.cookie = "psistats_screenheight = " + self.screen.height;
document.cookie = "psistats_screendepth = " + self.screen.colorDepth;
</script>

Reason I ask is: When I install this I get some strange errors. That means that the forum Logo on top left disappear and my MemberMap (German Addon) won't works. May I ask you: Is this modification really necessary? -Mike

Greek Wizard
11 Oct 2006, 12:10
I am getting a "skipping - 0 bytes" error when trying to upload vc.gif.

Seems the file is damaged. I redownloaded and the same thing. Can we have a replacement please (may want to update your next release as well.)

Nandakal
13 Oct 2006, 09:41
Is there any way to get this to work without the LOCK function?

My provider wont turn it on.

-N.

mrderanged
17 Oct 2006, 03:40
Love the mod, but how does it generate the active/inactive # of members? It's not matching up with my forum settings which has active members visiting in the past 90 days.

Thanks

jw00dy
17 Oct 2006, 10:13
Very very nice.

*installed* Nomination for MotM

akanevsky
18 Oct 2006, 19:55
I am getting a "skipping - 0 bytes" error when trying to upload vc.gif.

Seems the file is damaged. I redownloaded and the same thing. Can we have a replacement please (may want to update your next release as well.)

If the file is damaged in the archive, then it's damaged. If anyone has a non-damaged flag for that country, feel free to contribute.

Is there any way to get this to work without the LOCK function?

My provider wont turn it on.

-N.

Yes, but data may get corrupted.

Love the mod, but how does it generate the active/inactive # of members? It's not matching up with my forum settings which has active members visiting in the past 90 days.

Thanks

It's counting for 30 days instead. Might change it for next release.

mrderanged
18 Oct 2006, 20:06
It's counting for 30 days instead. Might change it for next release.

could I suggest make it user changeable, pretty much the same way vB has it setup standard?

I love the countries and regions page :)

Spikeman
18 Oct 2006, 21:37
nice hack, thanks.

Nandakal
18 Oct 2006, 22:11
If the file is damaged in the archive, then it's damaged. If anyone has a non-damaged flag for that country, feel free to contribute.



Yes, but data may get corrupted.



It's counting for 30 days instead. Might change it for next release.

If possible, could you guide me in the direction to go, even tho the data might be damaged, im willing to test atleast :)

-N.

akanevsky
18 Oct 2006, 22:42
The data is not damaged, the flag is. To test, ask someone from that country to access your site. :)

bashy
20 Oct 2006, 20:40
Hi psionic

In my referals list i aint seeing United Kingdom
Any ideas as to the problem please, my member base is mainly UK lol

akanevsky
20 Oct 2006, 20:42
Hi psionic

In my referals list i aint seeing United Kingdom
Any ideas as to the problem please, my member base is mainly UK lol
Download the latest package and overwrite your files. The problem has already come up and it's been fixed without changing the version tag.

akanevsky
21 Oct 2006, 23:29
God bless you, Mike-D. FYI, I can't recall you asking any questions.

Phooey
30 Oct 2006, 15:31
I'm having issues where the Display Colors & Resolutions page isn't showing any data. Everything else is working fine, it's just that page. I've double checked everything and I think I have it installed correctly.

Any suggestions?

You can see my stats page at http://www.digitallywise.com/forums/psistats.php

Lottis
30 Oct 2006, 19:55
Thank you, Psionic Vision.
This was a great product and it works great. No problem at all. Thanks and nominating.

Lottis
30 Oct 2006, 19:56
Hmm, why cant this be nominated?

transitbus
30 Oct 2006, 21:33
Edit NM Can't use this mod due to the lock issue. Oh well, looked good at the time.

akanevsky
30 Oct 2006, 23:34
I'm having issues where the Display Colors & Resolutions page isn't showing any data. Everything else is working fine, it's just that page. I've double checked everything and I think I have it installed correctly.

Any suggestions?

You can see my stats page at http://www.digitallywise.com/forums/psistats.php

Did you do template modifications?

Hmm, why cant this be nominated?

What do you mean - it can't be nominated?

As for the lock issue, why not fix it?

transitbus
31 Oct 2006, 02:13
As for the lock issue, why not fix it?

Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?

Nandakal
31 Oct 2006, 08:12
Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?

Same, cant use it due to lock issue, had to deinstall it.

-N.

akanevsky
01 Nov 2006, 00:09
Because many hosts including mine don't allow for such things (it also runs mysql 4.0.16). Lock and unlock produce loads (even if minute) on sql servers. I share a server with dozens of other clients so performance is a top concern.

Why not instead find another way that does not require people to contact their host to give them high level rights?
Because that's the only method of locking data.

transitbus
01 Nov 2006, 03:30
Not sure why you need to use locking in the form you do for this type of database but seeing how many of us can not have that access (no everyone runs their own mysql server) and almost no other add on here uses this method, I would think you would choose a different way to make this compatible.

and I am going to quote mysql.com because I like to back up my statements with evidence ;)

http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html

Normally, you do not need to lock tables, because all single UPDATE statements are atomic; no other thread can interfere with any other currently executing SQL statement. However, there are a few cases when locking tables may provide an advantage:

If you are going to run many operations on a set of MyISAM tables, it is much faster to lock the tables you are going to use. Locking MyISAM tables speeds up inserting, updating, or deleting on them. The downside is that no thread can update a READ-locked table (including the one holding the lock) and no thread can access a WRITE-locked table other than the one holding the lock.
The reason some MyISAM operations are faster under LOCK TABLES is that MySQL does not flush the key cache for the locked tables until UNLOCK TABLES is called. Normally, the key cache is flushed after each SQL statement.
If you are using a storage engine in MySQL that does not support transactions, you must use LOCK TABLES if you want to ensure that no other thread comes between a SELECT and an UPDATE. The example shown here requires LOCK TABLES to execute safely:


LOCK TABLES trans READ, customer WRITE;
SELECT SUM(value) FROM trans WHERE customer_id=some_id;
UPDATE customer
SET total_value=sum_from_previous_statement
WHERE customer_id=some_id;
UNLOCK TABLES;
Without LOCK TABLES, it is possible that another thread might insert a new row in the trans table between execution of the SELECT and UPDATE statements.
You can avoid using LOCK TABLES in many cases by using relative updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function. See Section 1.9.5.3, “Transactions and Atomic Operations”.
You can also avoid locking tables in some cases by using the user-level advisory lock functions GET_LOCK() and RELEASE_LOCK(). These locks are saved in a hash table in the server and implemented with pthread_mutex_lock() and pthread_mutex_unlock() for high speed. See Section 12.9.4, “Miscellaneous Functions”.

Lottis
01 Nov 2006, 11:55
What do you mean - it can't be nominated?

Earlyer it was a nominating button on the hack. But now it issent.
Do we have to nominat manually now?

maxicep
01 Nov 2006, 16:40
i installed this hack successfully but i come with White empty Screen.
i modified permissions .
what can i do now ?

akanevsky
02 Nov 2006, 03:30
Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks. (http://www.vbulletin.org/forum/showthread.php?t=130551)

Apoco
02 Nov 2006, 06:12
Getting error:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('***IP ADDY****', 'country', '***IP ADDY****_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0', 'useragent', '***IP ADDY****_useragent');

MySQL Error : Can't find file: 'psistats_cache.MYI' (errno: 2)
Error Number : 1017


It was working fine until, this afternoon

akanevsky
02 Nov 2006, 21:26
Judging from the error message, the table has become corrupt. Please contact your hosting provider to correct the problem.

Masked Crusader
02 Nov 2006, 23:56
FANTASTIC MOD! --- INSTALLED!

I have been looking for a very detailed summary of my user's experience on my forum and now I have found the key.

Very well done my friend.

Phooey
03 Nov 2006, 14:36
Did you do template modifications?
Thanks for making me take a second look at them. I had put the code that goes in the headinclude below the code shown instead of above it. Works fine now. :p


P.S. You've got my vote for MotM!

Factory Ten
03 Nov 2006, 22:03
Easy to install and works great. I wish all the vB add-ons had such detailed directions. Thanks again! :)

ga2000gt
04 Nov 2006, 00:43
I've been using this hack since it was released, but now today, I come home and have this error:

Database error in vBulletin 3.6.2:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('202.101.6.85', 'country', '202.101.6.85_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7', 'useragent', '202.101.6.85_useragent');

MySQL Error : Can't find file: 'psistats_cache.MYI' (errno: 2)
Error Number : 1017
Date : Friday, November 3rd 2006 @ 07:39:13 PM


When I check my DB tables, all are OK, except:
error : Can't find file: 'psistats_cache.MYI' (errno: 2)

Is there anyway to fix this?

Nevermind, already posted.

harmor19
04 Nov 2006, 04:29
Great hack.

farooqaaa
04 Nov 2006, 13:31
Ahh thanks alot :). Its a major hack ;).

*farooqaaa have already clicked install....

ga2000gt
05 Nov 2006, 07:31
I've been using this hack since it was released, but now today, I come home and have this error:

Database error in vBulletin 3.6.2:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('202.101.6.85', 'country', '202.101.6.85_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7', 'useragent', '202.101.6.85_useragent');

MySQL Error : Can't find file: 'psistats_cache.MYI' (errno: 2)
Error Number : 1017
Date : Friday, November 3rd 2006 @ 07:39:13 PM


When I check my DB tables, all are OK, except:
error : Can't find file: 'psistats_cache.MYI' (errno: 2)

Is there anyway to fix this?

Nevermind, already posted.

Keeps happening. I had to restore my DB twice today.

akanevsky
05 Nov 2006, 12:27
Keeps happening. I had to restore my DB twice today.

Restoring database won't help. The backup might already have a fault in it. You need to actually fix the table, dude. Contact your hosting provider about it. If you hosting provider does not help... drop the table, then overwrite product XML, which will restore it.

AzH
05 Nov 2006, 15:59
Just ignore me, I'm a retard. INSTALLED.

itorrents
05 Nov 2006, 17:32
Got my vote, thanks :)

iran.gs
06 Nov 2006, 16:02
Installed Excelent job 3.62

zooman
11 Nov 2006, 16:25
installed on 3.6.3 all I'm getting is

http://www.consumeractiongroup.co.uk/forum/psistats.php

any thoughts

akanevsky
11 Nov 2006, 18:44
If you have a very large site, then the front page might take a while to load. I'll fix that in the next release though.

akanevsky
12 Nov 2006, 23:46
Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks. (http://www.vbulletin.org/forum/showthread.php?t=130551)

MediaHound
14 Nov 2006, 14:11
Clicked the install link in readme.html
vb.org returned this:
Could not find phrase 'hack_installed'.
anyway, great hack, thanks!

a squared
14 Nov 2006, 15:09
Anxiously awaiting updated version. :)

akanevsky
14 Nov 2006, 23:13
Clicked the install link in readme.html
vb.org returned this:

anyway, great hack, thanks!

That's a bug with vBulletin.org :) Please report in site feedback of this site.

Anxiously awaiting updated version. :)

???

hotwheels
15 Nov 2006, 02:03
I voted for this mod for mod of the month..........awesome work

a squared
16 Nov 2006, 19:33
Not that my site is that large. I'll take a closer look at this over the weekend.



???

If you have a very large site, then the front page might take a while to load. I'll fix that in the next release though.

Makc666
17 Nov 2006, 12:53
in temlate:
PSISTATS_HOME

in part:
<strong><a href="member.php?$session[sessionurl]userid=$c[maxrefs_userid]">$c[maxrefs_username]</a></strong> ($c[maxrefs] referrals)

word:
referrals
in part:
($c[maxrefs] referrals)

doesn't have a translation string!

Makc666
17 Nov 2006, 13:07
in temlate:
psistats_footer

in part:
<a href="psistats.php?$session[sessionurl]do=refsites">Referring Sites</a><if condition="$vboptions['psistats_refstatshack']">

word:
Referring Sites
in part:
refsites">Referring Sites</a>

doesn't have a translation string!

---------------------------

in temlate:
psistats_footer

in part:
<center><div class="smallfont">Powered by psiStats 2006 v$version<br />

word:
Powered by psiStats 2006 v

doesn't have a translation string!

---------------------------

There is also no translation on page Color Depths
for words:
(True Color)
(High Color)
(256colors)

Also I think that
(256colors)
we have to type with space:
(256 colors)

This one is in template:
psistats_depthbit

akanevsky
17 Nov 2006, 19:49
in temlate:
psistats_footer

in part:
<a href="psistats.php?$session[sessionurl]do=refsites">Referring Sites</a><if condition="$vboptions['psistats_refstatshack']">

word:
Referring Sites
in part:
refsites">Referring Sites</a>

doesn't have a translation string!

---------------------------

in temlate:
psistats_footer

in part:
<center><div class="smallfont">Powered by psiStats 2006 v$version<br />

word:
Powered by psiStats 2006 v

doesn't have a translation string!

---------------------------

There is also no translation on page Color Depths
for words:
(True Color)
(High Color)
(256colors)

Also I think that
(256colors)
we have to type with space:
(256 colors)

This one is in template:
psistats_depthbit

Referring Sites - perhaps, but the info bits are hardcoded into the script and currently cannot be translated.

TaBaTaN
20 Nov 2006, 04:41
Great hack Installed

Thank you

Makc666
20 Nov 2006, 13:39
Referring Sites - perhaps, but the info bits are hardcoded into the script and currently cannot be translated.
(True Color)
(High Color)
Can't be translated. Agreed :) (I inspeckted the code after I posted).
But word "colors" can be translated and I made translation for it :)

Makc666
20 Nov 2006, 14:14
Once more sort of bug.
In psistats.php
we have (line 259):
if ($user['userid'] == NUMBER_ONE)

I think this is not a good one.
I imported my forum from phpBB to VB.
And user NUMBER ONE was created when I installed VB engine for the first time.
But user number one from phpBB is not user #1 for now on my new VB forum.
So the date: Forum Began is not displayed correctly.

Why not to add to PSI configuration page such option as:
User's ID number first registered on your forums

P.S.
I found this one in psistats.php
define('THIS_SCRIPT', 'psistats');^M
define('ONE_DAY', 86400);^M
define('ONE_MONTH', 2629743.83);^M
define('NUMBER_ONE', 5);^M
define('MODERATOR_GROUP', 7);^M

Why not to and some note about this one in Documenatation? :)

scabbed
20 Nov 2006, 20:38
for french people who wants a translation of this hack

here it is (see attached file)

akanevsky
20 Nov 2006, 20:41
for french people who wants a translation of this hack

here it is (see attached file)

Thanks, much appreciated.

firstrebel
22 Nov 2006, 19:27
I am about to upgrade to 1.4.0 and notice that there are 2 template changes. I cannot find my previous version but my records show that only the navbar template changed with the previous version. Is this correct, meaning the only new template change is headinclude.

Thanks

Bob

akanevsky
22 Nov 2006, 20:09
I am about to upgrade to 1.4.0 and notice that there are 2 template changes. I cannot find my previous version but my records show that only the navbar template changed with the previous version. Is this correct, meaning the only new template change is headinclude.

Thanks

Bob

Yea, it's correct.

Goat Boy
25 Nov 2006, 04:17
When I click style Usage I get Warning: Division by zero in /psistats.php on line 36
On all 4 styles

Cool hack though

akanevsky
25 Nov 2006, 13:51
When I click style Usage I get Warning: Division by zero in /psistats.php on line 36
On all 4 styles

Cool hack though

You need to have at least one style installed...

Goat Boy
25 Nov 2006, 13:57
You need to have at least one style installed...



I have 4 styles, I figured it out. When first installed it needs 15 minutes to update. For each style I had a warning of zero. It works now.

Thanks

akanevsky
25 Nov 2006, 14:04
I have 4 styles, I figured it out. When first installed it needs 15 minutes to update. For each style I had a warning of zero. It works now.

Thanks

Oh... It shouldn't show division by zero even after 0 minutes. I'll check it out.

akanevsky
25 Nov 2006, 17:38
UPDATE: 1.4.1

See changelog for details.
To upgrade:

1. Re-Upload Files.
2. Re-Upload Product XML.
3. Revert PSISTATS_HOME, if modified.

xtrass
25 Nov 2006, 18:01
I like this mod a lot, it's definitely a keeper. And the support is very good too. Much appreciated.

A question, what is new in this new upgrade?

And a wish list...

The single most important feature I would like to see is complete urls for referrals, not just domain name urls. It's important to see what page they came from. That would be THE feature to have!

Also nice would be to be able to have running stats for the week, month, and be able to check previous days.

Any way to log length of time each visitor stayed, and what the exist page was when they left?

All that would be really useful too, but if you can only do one, I'd like to see complete referring urls!

Thanks a lot for a terrific mod!

akanevsky
25 Nov 2006, 18:08
A question, what is new in this new upgrade?
An answer, see changelog in first post?

The single most important feature I would like to see is complete urls for referrals, not just domain name urls. It's important to see what page they came from. That would be THE feature to have!
That's actually easier to implement than the stripped down URL's. I'll make it an option in the next release. :)

Spikeman
25 Nov 2006, 19:08
Have been using this for a time now and all is good, just updated and now I have 23 staff in stats should only be 4, checked users and usergroups and all is good there. Seems that i have 17 extra mods :) Any ideas?

akanevsky
25 Nov 2006, 19:10
Have been using this for a time now and all is good, just updated and now I have 23 staff in stats should only be 4, checked users and usergroups and all is good there. Seems that i have 17 extra mods :) Any ideas?

Please write out the following:
Read Numbers of Admins, S-Mods and Mods
Shown Numbers of Admins, S-Mods and Mods
Thanks.

Spikeman
25 Nov 2006, 19:20
Please write out the following:
Read Numbers of Admins, S-Mods and Mods
Shown Numbers of Admins, S-Mods and Mods
Thanks.

Real Numbers of Admins, S-Mods and Mods = 2 admins, 2 s-mods, 1 mod
Shown Numbers of Admins, S-Mods and Mods = 2 admins, 3 s-mods, 18 mods

ncangler
25 Nov 2006, 19:35
Just discovered this mod and it is awesome. I installed with no problems but I am not getting the correct read on the Staff information.

I have: (1) Admin, (2) Moderators, (2,208) Registered Users, (46) Custom usergroup 'Captains Club' members, 6 custom 'Triumph Dealer' members.

But these show up as:
Members: 2,212
Staff: 46 (1 Admin, 2 s-mods, 43 mods)

Any ideas where those 43 mods came from? The (2) Moderators and the Admin (me) are also 'Captains Club' Members which would make the total number, but I don't know why a special usergroup that is not a Staff usergroup position would show up as Staff. Can custom usergroup designations be added to the code? It would be great if the custom user group name and total members were listed after the staff. Thanks for any help.

ncangler
25 Nov 2006, 20:21
Also, the Site Statistics link in "Quick Links" is linking to my site root (www.mysite.com/psistats.php) not my forum root (www.mysite.com/forums/psistats.php), which is where I installed psistats.php. What would I need to change in the template edit to give it the correct path?

<tr><td class="vbmenu_option"><a href="psistats.php$session[sessionurl_q]">$vbphrase[psistats_link]</a></td></tr>

akanevsky
25 Nov 2006, 20:22
Also, the Site Statistics link in "Quick Links" is linking to my site root (www.mysite.com/psistats.php) not my forum root (www.mysite.com/forums/psistats.php), which is where I installed psistats.php. What would I need to change in the template edit to give it the correct path?

<tr><td class="vbmenu_option"><a href="psistats.php$session[sessionurl_q]">$vbphrase[psistats_link]</a></td></tr>

Add psistats to the replacements of whatever portal software you are using.

Just discovered this mod and it is awesome. I installed with no problems but I am not getting the correct read on the Staff information.

I have: (1) Admin, (2) Moderators, (2,208) Registered Users, (46) Custom usergroup 'Captains Club' members, 6 custom 'Triumph Dealer' members.

But these show up as:
Members: 2,212
Staff: 46 (1 Admin, 2 s-mods, 43 mods)

Any ideas where those 43 mods came from? The (2) Moderators and the Admin (me) are also 'Captains Club' Members which would make the total number, but I don't know why a special usergroup that is not a Staff usergroup position would show up as Staff. Can custom usergroup designations be added to the code? It would be great if the custom user group name and total members were listed after the staff. Thanks for any help.

Does your Captains Club group have moderator abilities?

ncangler
25 Nov 2006, 20:26
No they do not. Does your Captains Club group have moderator abilities?

ncangler
25 Nov 2006, 20:29
Just that easy! Sorry I didn't think of or find it in the thread sooner. I appreciate the addition of this wonderful mod to our sites!
Add psistats to the replacements of whatever portal software you are using.

akanevsky
25 Nov 2006, 20:38
Just discovered this mod and it is awesome. I installed with no problems but I am not getting the correct read on the Staff information.

I have: (1) Admin, (2) Moderators, (2,208) Registered Users, (46) Custom usergroup 'Captains Club' members, 6 custom 'Triumph Dealer' members.

But these show up as:
Members: 2,212
Staff: 46 (1 Admin, 2 s-mods, 43 mods)

Any ideas where those 43 mods came from? The (2) Moderators and the Admin (me) are also 'Captains Club' Members which would make the total number, but I don't know why a special usergroup that is not a Staff usergroup position would show up as Staff. Can custom usergroup designations be added to the code? It would be great if the custom user group name and total members were listed after the staff. Thanks for any help.

Do you have any forum-specific moderators?

ncangler
25 Nov 2006, 21:01
The two moderators are assigned to all the forums. I don't have any moderators on this site that are assigned to just one forum. Do you have any forum-specific moderators?

akanevsky
25 Nov 2006, 21:55
The two moderators are assigned to all the forums. I don't have any moderators on this site that are assigned to just one forum.

So they are supermoderators, right? But are they (the s-mods) also listed as moderators of each forum (just for the sake of showing up in the forumbit)?

ncangler
26 Nov 2006, 04:08
Actually no I don't have any supermoderators, just two moderators and I have them assigned to all the forums. I've attached a jpg that shows my usergroup setup. I installed the stats program on another site and it is doing the same thing.
So they are supermoderators, right? But are they (the s-mods) also listed as moderators of each forum (just for the sake of showing up in the forumbit)?

ncangler
26 Nov 2006, 04:35
Everything seems to be working great except the listing of staff (s-mods and moderators) and the "Active/Non-Active/Activity level" counters. On both sites that I have installed the psistats today it is showing no activity and all as inactive. This is obviously not correct as several members have been on and posted today. I've attached jpg's of the stat screens for both sites.

ncangler
26 Nov 2006, 05:07
Okay I found where I had each of the moderators setup as super moderators by having one button activated in the usergroup setting. They are now just moderators and are not showing up as s-mods anymore. I also turned off the "Viewable on Show Groups" for the large usergroup "Registered Users". That apparently has enabled the activity statistics to start working now. Only thing left is to figure out why the custom usergroup Captains Club members are showing up as Moderators. :)

jw00dy
26 Nov 2006, 06:28
I have the same deal. I have a group that is allowed access to a private forum, and they are being added to the moderators groups listing as well.

I actually have 0 moderators.

The rest of the data looks good to me.

EvilHawk
26 Nov 2006, 11:07
I have the same deal. I have a group that is allowed access to a private forum, and they are being added to the moderators groups listing as well.


Same thing happens to my forum too ...

EvilHawk
26 Nov 2006, 11:14
Anothe minor bug, if someone has set the vBulletin option "Active Members Time Cut-Off" to zero to disable it, the stats shows all members as inactive and activity level as 0% ...

EvilHawk
26 Nov 2006, 11:18
Anothe minor bug, if someone has set the vBulletin option "Active Members Time Cut-Off" to zero to disable it, the stats shows all members as inactive and activity level as 0% ...

Xmmmm in fact it doesn't take in account the setting, it shows all members as inactive and activity level 0% ...

akanevsky
26 Nov 2006, 14:06
I have the same deal. I have a group that is allowed access to a private forum, and they are being added to the moderators groups listing as well.

I actually have 0 moderators.

The rest of the data looks good to me.

Ok, I understand. There is no need to keep reporting the bug. I'll work on fixing it.


Xmmmm in fact it doesn't take in account the setting, it shows all members as inactive and activity level 0% ...

That's because 0 does not disable the cutoff. In fact, it cuts off all users after 0 seconds. The script uses vbulletin userstats to retrieve that information so it cannot be incorrect.

akanevsky
26 Nov 2006, 14:32
Just discovered this mod and it is awesome. I installed with no problems but I am not getting the correct read on the Staff information.

I have: (1) Admin, (2) Moderators, (2,208) Registered Users, (46) Custom usergroup 'Captains Club' members, 6 custom 'Triumph Dealer' members.

But these show up as:
Members: 2,212
Staff: 46 (1 Admin, 2 s-mods, 43 mods)

Any ideas where those 43 mods came from? The (2) Moderators and the Admin (me) are also 'Captains Club' Members which would make the total number, but I don't know why a special usergroup that is not a Staff usergroup position would show up as Staff. Can custom usergroup designations be added to the code? It would be great if the custom user group name and total members were listed after the staff. Thanks for any help.

From your screenshot, I don't know where the mods came from.
If you can send me your admincp details via pm, it would be very helpful.

EvilHawk
26 Nov 2006, 14:40
The script uses vbulletin userstats to retrieve that information so it cannot be incorrect.

I have over 2500+ active users every day, the stats report active none, inactive all , activity % , i haven't had this problem with version 1.4.0 ;)

akanevsky
26 Nov 2006, 14:45
I have over 2500+ active users every day, the stats report active none, inactive all , activity % , i haven't had this problem with version 1.4.0 ;)

Version 1.4.0 retrieved data on its own. Version 1.4.1 uses vBulletin UserStats to retrieve the information. How many active users does it show on front page of your forums? Perhaps you turned off the display of active users?

akanevsky
26 Nov 2006, 14:50
Release - Version 1.4.2.
Overwrite psistats.php, the product xml, and rename ./includes/psistats/database_flags/gb.gif to uk.gif.

EvilHawk
26 Nov 2006, 14:56
Version 1.4.0 retrieved data on its own. Version 1.4.1 uses vBulletin UserStats to retrieve the information. How many active users does it show on front page of your forums? Perhaps you turned off the display of active users?

You stand correct! Thank you, sir.

ncangler
26 Nov 2006, 15:00
Perfect! Thank you!

akanevsky
26 Nov 2006, 16:06
You guys are gonna kill me, but...

:banana: RELEASE 1.4.3! :banana:

Overwrite psistats.php...
Overwrite product XML...

Done!

GNDI
26 Nov 2006, 16:12
your right, it ain't 5 minuts ago i upgraded to 1.4.2 :)

Darat
26 Nov 2006, 16:16
I had installed the 1.4.2 release and that seemed fine, just overwrote the product XML and psistats.php from the 1.4.3 zip and all I'm getting is a blank page?

akanevsky
26 Nov 2006, 16:23
I had installed the 1.4.2 release and that seemed fine, just overwrote the product XML and psistats.php from the 1.4.3 zip and all I'm getting is a blank page?

Eh... Not even an error message? Try refreshing the page.

Kalina
26 Nov 2006, 16:39
I get an error now.


Parse error: syntax error, unexpected T_STRING in /home/webtalkf/public_html/psistats.php(759) : eval()'d code on line 3

Parse error: syntax error, unexpected T_VARIABLE in /home/webtalkf/public_html/psistats.php(760) : eval()'d code on line 2

Also, for this release you say all templates must be reverted, it doesn't say that anywhere else.

Vossi
26 Nov 2006, 16:41
I'm getting the following error when I'm trying to access psistats.php:
Parse error: parse error, unexpected T_STRING in /var/www/vhosts/****************/httpdocs/psistats.php(736) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /var/www/vhosts/****************/httpdocs/psistats.php(737) : eval()'d code on line 2
All I did was replacing the files on the server and then import the product.

Any ideas? :confused:

akanevsky
26 Nov 2006, 16:54
I'm getting the following error when I'm trying to access psistats.php:

All I did was replacing the files on the server and then import the product.

Any ideas? :confused:

Is that on vBulletin 3.5 or 3.6?

redlabour
26 Nov 2006, 16:54
I had installed the 1.4.2 release and that seemed fine, just overwrote the product XML and psistats.php from the 1.4.3 zip and all I'm getting is a blank page?

Same here ! No Errormessage only a blank Page without any Pagesourcecode. 3.6.3 !

Kalina
26 Nov 2006, 16:56
Is that on vBulletin 3.5 or 3.6?
I have the same error, version 3.6.4.

Kanustep
26 Nov 2006, 16:56
The same error appears to me - Version 3.6.4

Betablocker
26 Nov 2006, 16:56
Parse error: parse error, unexpected T_STRING in vb/psistats.php(759) : eval()'d code on line 3

Parse error: parse error, unexpected T_VARIABLE in /vb/psistats.php(760) : eval()'d code on line 2

Same Errors for me

Darat
26 Nov 2006, 16:57
Eh... Not even an error message? Try refreshing the page.

Nothing at all... however it looks like our server was falling over when I was running your script and it just went down so this may be purely coincidental! When we're back I'll check again.

akanevsky
26 Nov 2006, 16:58
Ah. For some reason, the product XML got malformed, and the templates were, as a result, imported in a wrong way. Downloading the package again and overwriting your product will fix the problem. :)

Darat
26 Nov 2006, 17:06
Just re-imported the product from a fresh download and it seems to be fine.

Betablocker
26 Nov 2006, 17:08
Yeah thats cracked it :classic:

Thank you.

Any idea why the Resolutions only comes up with 1024x768 on one of my sites.....seems ok on the others.
It is also reporting i have 40 mods :surprised:

akanevsky
26 Nov 2006, 17:09
Yeah thats cracked it :classic:

Thank you.

Any idea why the Resolutions only comes up with 1024x768 on one of my sites.....seems ok on the others.
It is also reporting i have 40 mods :surprised:

Perhaps you do have 40 mods? It counts the number of unique users added as moderators to at least one forum.

Darat
26 Nov 2006, 17:11
Looks like there is a flag missing:

Betablocker
26 Nov 2006, 17:12
Perhaps you do have 40 mods? It counts the number of unique users added as moderators to at least one forum.

Well it is getting better..says i have 10 mods now lol but i have 5 mods really

akanevsky
26 Nov 2006, 17:12
Looks like there is a flag missing:

It's true, the flag database is not complete. If you find the flag, you are more than welcome to contribute to the creator of the database: http://www.phptutorial.info/iptocountry/the_script.html...

akanevsky
26 Nov 2006, 17:14
Well it is getting better..says i have 10 mods now lol but i have 5 mods really

What does it show on showgroups.php? What about the admincp show all moderators page?

AzH
26 Nov 2006, 17:16
I have an issue with the stats and I'm interested to see if anyone has a solution. The option for Style Usage does not update based on the style switcher drop down box on the forum. The only way to get the data updated is to switch the style being used via the User CP. I currently have three options open to me.

* Leave it as it is
* Remove the style usage option from the stats page
* Remove the drop down box on the forums and force people to change via UserCP

Ideally I'd like a fourth option which is some kind of update to fix this minor flaw.

You can see what I am talking about here: http://azhforum.co.uk/psistats.php?do=styles

Any suggestions?

Great hack, by the way. :D

akanevsky
26 Nov 2006, 17:19
I have an issue with the stats and I'm interested to see if anyone has a solution. The option for Style Usage does not update based on the style switcher drop down box on the forum. The only way to get the data updated is to switch the style being used via the User CP. I currently have three options open to me.

* Leave it as it is
* Remove the style usage option from the stats page
* Remove the drop down box on the forums and force people to change via UserCP

Ideally I'd like a fourth option which is some kind of update to fix this minor flaw.

You can see what I am talking about here: http://azhforum.co.uk/psistats.php?do=styles

Any suggestions?

Great hack, by the way. :D

The reason it is not updated is because when user chooses a style using the switcher, it is not saved to his or her account. It is only stored in his or her cookie. The only way to fix this would be to have vBulletin save the style to database, but I am not sure that alterting vBulletin's behavior is the best way to go in this case.

If you want, remove the quick chooser by editing the footer template.

Betablocker
26 Nov 2006, 17:26
What does it show on showgroups.php? What about the admincp show all moderators page?


Good call...........even though i had removed some mods they still seemed to be there in the Show All.......also it was counting a admin or 2

Thanks

AzH
26 Nov 2006, 17:45
The reason it is not updated is because when user chooses a style using the switcher, it is not saved to his or her account. It is only stored in his or her cookie.
Yeah, I kinda figured out the reason for it, I was just hoping for a fix. Thanks anyway. :classic:


If you want, remove the quick chooser by editing the footer template.

I don't think that is the best way to go. I guess I'll just remove the Style statistics option from psi-stats.

GNDI
26 Nov 2006, 18:17
Same her at 3.6.4

Parse error: syntax error, unexpected T_STRING in /usr/local/psa/home/vhosts/gndindex.com/httpdocs/psistats.php(759) : eval()'d code on line 4

Parse error: syntax error, unexpected T_VARIABLE in /usr/local/psa/home/vhosts/gndindex.com/httpdocs/psistats.php(760) : eval()'d code on line 3

akanevsky
26 Nov 2006, 18:21
http://www.vbulletin.org/forum/showpost.php?p=1125600&postcount=199

GNDI
26 Nov 2006, 18:23
your right :) thanks mate :)

Vossi
26 Nov 2006, 22:44
Anthony, the error ist fixed for me now, thanks for your work.

But there's just one problem left, which has been written down already: The amount of mods and admins doesn't fit to my system-configuration. I got 7 mods (and nobody else has mod-statusfor sure), but the stats tell me that I have 38 mods in my system. :o

akanevsky
26 Nov 2006, 22:46
Anthony, the error ist fixed for me now, thanks for your work.

But there's just one problem left, which has been written down already: The amount of mods and admins doesn't fit to my system-configuration. I got 7 mods (and nobody else has mod-statusfor sure), but the stats tell me that I have 34 mods in my system. :o

Are any of these mods added to more than one forum?
What does it show on the admincp "Show All Moderators" page?

Vossi
26 Nov 2006, 22:51
Are any of these mods added to more than one forum?
Yep, one mod has more forums to moderate.
What does it show on the admincp "Show All Moderators" page?
It shows 9 Mods (actually I got 7 mods and 2 admins (forgot to say, sorry).

akanevsky
26 Nov 2006, 22:57
Yep, one mod has more forums to moderate.

Are you sure you have the latest psistats.php? The problem with one mod listed under multiple forums has already been fixed.

jw00dy
27 Nov 2006, 02:28
Thank you. Just wanted to let you know it's working perfect for me now.

Sorry about beating a dead horse earlier.

akanevsky
27 Nov 2006, 03:00
Just wanted to let you know it's working perfect for me now.

I'm glad. :)

Sorry about beating a dead horse earlier.

???

xtrass
27 Nov 2006, 04:43
I just upgraded to vb 3.6.4 and vbprotal and now psiStats doesn't work.

Please advise as this is a very good mod!

thank you.

GNDI
27 Nov 2006, 07:57
I just upgraded to vb 3.6.4 and vbprotal and now psiStats doesn't work.

Please advise as this is a very good mod!

thank you.

read this article http://www.vbulletin.org/forum/showpost.php?p=1125673&postcount=212

Makc666
27 Nov 2006, 13:30
This one has not been fixed ;)

in temlate:
PSISTATS_HOME

in part:
<strong><a href="member.php?$session[sessionurl]userid=$c[maxrefs_userid]">$c[maxrefs_username]</a></strong> ($c[maxrefs] referrals)

word:
referrals
in part:
($c[maxrefs] referrals)

doesn't have a translation string!

akanevsky
27 Nov 2006, 19:16
This one has not been fixed ;)

Sorry, there are a lot of posts in this thread and some do get forgotten about. Maybe I should create a section for this hack in the visionscripts bugtracker. :)

Vossi
27 Nov 2006, 23:18
Are you sure you have the latest psistats.php? The problem with one mod listed under multiple forums has already been fixed.

Anthony, I'm sorry! :cry: I was still using the older version and forgot to transfer the latest version of psistats.php into the root-directory.

It works fine now, thanks for your time and knowledge you spent into this product!

akanevsky
30 Nov 2006, 23:43
Anthony, I'm sorry! :cry: I was still using the older version and forgot to transfer the latest version of psistats.php into the root-directory.

It works fine now, thanks for your time and knowledge you spent into this product!

Perhaps you may want to click the install button then? :)

xtrass
01 Dec 2006, 03:09
read this article http://www.vbulletin.org/forum/showpost.php?p=1125673&postcount=212


What happened was vbportal installed a new theme so I had to add the codes to the new theme (3 minutes) and all is well again. Luckily the documentation for this mod is very good and the readme file was helpful.

Now I just got a email for a upgrade of this mod!

If I'm not having any probs is there any hurry to upgrade?

Any new features or just big fixes?

thx

akanevsky
01 Dec 2006, 13:09
What happened was vbportal installed a new theme so I had to add the codes to the new theme (3 minutes) and all is well again. Luckily the documentation for this mod is very good and the readme file was helpful.

Now I just got a email for a upgrade of this mod!

If I'm not having any probs is there any hurry to upgrade?

Any new features or just big fixes?

thx

Bugfixes, but the upgrade is very easy. To see what's changed, see the changelog in the first post.
To upgrade, overwrite product xml and then revert the psistats template if you have modified them. Then re-upload psistats.php. Temlate modifications do not need to be reapplied.


Are there any sorts of statistics that should be added to this hack? How come there are no feature suggestions? Ever?..

GNDI
01 Dec 2006, 13:14
I'll think it because you have thought of all most it all from the beginning :)

akanevsky
01 Dec 2006, 13:34
That's not true though - I can right now thing of a couple of things that can be added to this hack. However, for some strange reason, nobody is requesting anything.

And if what you are saying is true - how come this hack never got a MOTM?

akanevsky
01 Dec 2006, 13:40
Please vote for psistats MOTM!
http://www.vbulletin.org/forum/showthread.php?t=132928

yui333
01 Dec 2006, 20:23
Ok, I love this hack.. I have voted for it in the MOTM

da420
01 Dec 2006, 20:34
Ok, I love this hack.. I have voted for it in the MOTM

As did I. ;)

Darat
02 Dec 2006, 09:08
Feature wish list: A way to look at just a given period within the results.

EvilHawk
02 Dec 2006, 11:36
Are there any sorts of statistics that should be added to this hack? How come there are no feature suggestions? Ever?..

Registration Statistics, User Activity Statistics, New Thread Statistics, New Post Statistics for a given month will be welcomed ... ;)

EvilHawk
02 Dec 2006, 11:39
how come this hack never got a MOTM? The competition is tough, just keep supporting and expanding this great add on and it will get it sooner or later .. ;)

akanevsky
02 Dec 2006, 15:07
I created a forum for suggestions here:
http://visionscripts.com/forum/forumdisplay.php?f=80

And a bug tracking project here:
http://visionscripts.com/forum/bugtracker.php?s=&do=listbugs&bugtracker_projectid=11

Please post your feature request in that forum.
Once again, this modification is not going to be commercial, it's just that this is a large modification and it's going to be easier to keep track of features and bugs if there is a separate place for it. :)

furst
02 Dec 2006, 22:30
Good work here, very nice hack.

Any chance of getting the ability to create a feed out of the site referrers? I want to be able to place a list of top referring sites on other pages, like forum home.

akanevsky
02 Dec 2006, 22:36
Good work here, very nice hack.

Any chance of getting the ability to create a feed out of the site referrers? I want to be able to place a list of top referring sites on other pages, like forum home.

What type of feed would you want to create? And in what format?

furst
03 Dec 2006, 08:46
What type of feed would you want to create? And in what format?
To put it in simplest terms, what I'm asking for is an external.php for the referring sites page in psistats.


I suppose it could easily be done with javascript and rss. Javascript would probably be easier to add to a page than rss would be.

I would like it if I could choose how many items the feed would have. Would be nice if I could also manipulate the format a bit. For instance, in some cases I may want to have one long column with all the site referrers, but at other times I may want to display it a little bit differently, maybe showing two columns containing an ordered list of all the referring sites.

All this combined would basically be creating something which I could use to trade traffic, just like a toplist. It seems like psistats is only steps away from having this functionality.

jw00dy
03 Dec 2006, 10:58
Very minor typo.

In the PSI ACP, you have the date format for the date of forum creation as dd/mm/yyyy format, however it appears to be mm/dd/yyyy as the other way doesn't work.

akanevsky
03 Dec 2006, 14:49
To put it in simplest terms, what I'm asking for is an external.php for the referring sites page in psistats.


I suppose it could easily be done with javascript and rss. Javascript would probably be easier to add to a page than rss would be.

I would like it if I could choose how many items the feed would have. Would be nice if I could also manipulate the format a bit. For instance, in some cases I may want to have one long column with all the site referrers, but at other times I may want to display it a little bit differently, maybe showing two columns containing an ordered list of all the referring sites.

All this combined would basically be creating something which I could use to trade traffic, just like a toplist. It seems like psistats is only steps away from having this functionality.

So you would prefer a javascript or and xml feed, right? Because RSS feed is for RSS newsfeeds, not for traffic trade.

furst
03 Dec 2006, 17:52
So you would prefer a javascript or and xml feed, right?

Yeah, that would work best for me.

nocte
04 Dec 2006, 21:59
Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

akanevsky
04 Dec 2006, 22:18
Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

Unfortunately, I cannot help you if you see a blank page (which means that error display is suppressed). I need an error messge...

blogtorank
04 Dec 2006, 22:18
Please vote for psistats MOTM!
http://www.vbulletin.org/forum/showthread.php?t=132928




Voted and also will be putting a list here for you to do ;) then you can take the rest of the coders out with this list I'm coming up for new add-ins for you as I'm a person that lives off stats, breathes stats, eats stats and sleeps with stats as you can see the screenshot below why I do ;)

So hopefully your fingers are rested cause I have many options for you to add in!!!

blogtorank
04 Dec 2006, 22:20
Hi,

I upgraded to PHP 5.2.0-0 - now i see a blank page, wenn i open psistats.php

I had Problems with vB CMPS too after upgrading, so i think it's the new PHP Version.

You need to check your error_log files wherever on your server and it's pretty early isn't it to be upgrading to a recent PHP? How many other things are broken too is my question? LOL

nocte
04 Dec 2006, 22:53
Unfortunately, I cannot help you if you see a blank page (which means that error display is suppressed). I need an error messge...

error reporting is on!

On vB CMPS i got this error: http://www.vbadvanced.com/forum/showthread.php?t=18878

akanevsky
04 Dec 2006, 23:15
Voted and also will be putting a list here for you to do ;) then you can take the rest of the coders out with this list I'm coming up for new add-ins for you as I'm a person that lives off stats, breathes stats, eats stats and sleeps with stats as you can see the screenshot below why I do ;)

So hopefully your fingers are rested cause I have many options for you to add in!!!

Can you please post suggestions at visionscripts? Cause this thread is way too long to track suggestions otherwise. Thanks. (for voting too)

711
05 Dec 2006, 03:47
I have installed this mod, and really like it.

One thing I would like to change is this:

In the Top threads and posts section, rather than show the All Time leaders, I'd love to show the most popular threads and posts from the last 24 hours.

I would imagine this would require a WHERE clause added here:


// top threads by views
$getthreads = $db->query_read("
SELECT threadid, title, views
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
AND forumid NOT IN (0$limitfids)
ORDER BY views DESC
LIMIT " . $vbulletin->options['psistats_toptflimit'] . "
");


and here:


// top threads by replies
$getthreads = $db->query_read("
SELECT threadid, title, replycount
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
AND replycount > 0
AND forumid NOT IN (0$limitfids)
ORDER BY replycount DESC
LIMIT " . $vbulletin->options['psistats_toptflimit'] . "
");



but I am not familar enough with SQL to do this.

Im guessing it's something close to this:


WHERE lastpost >= (curdate() - 24*60)


but that produces an error.

Any suggestions?

Thanks!

akanevsky
05 Dec 2006, 19:58
It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

711
06 Dec 2006, 06:11
It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

I tried that edit, which produces this error:


Database error in vBulletin 3.6.4:

Invalid SQL:
-86400
AND forumid NOT IN (0)
ORDER BY views DESC
LIMIT 10;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-86400
AND forumid NOT IN (0)
ORDER BY views DESC
LIMIT 10
Error Number : 1064