psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.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 2009
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 3.5.x - 3.8.x
|| Released : Feb 28, 2010
||
|| Time required to install: 1 minute
|| Difficulty: easy
\*===================================*/

DESCRIPTION

A sophisticated statistics module for your vBulletin board.

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

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

STATISTICS

File Uploads: 1
Products to Install: 1


FEATURES

Statistics Tracking:

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


Features:

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


VERSION HISTORY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1.2.6
[F] Minor template fix.

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

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

1.2.0
First Official Release.

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

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

The installation manual is contained within the attached file.

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

[akanevsky]

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]

second mine:D
thanks

[Deepdog009]

Kbp 2 Kbp4 :D


Beauts *** Checkmate :cool:

[akanevsky]

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]

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]

Download doesn't work

[akanevsky]

Try again, I've been updating the file.

[Endurer]

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]

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]

Very nice hack! I've installed it with no issues so far. Thanks for your hard work.


<--! Clicks Install --> :)

[Phooey]

Awesome. I'm so glad you decided to make this for 3.6.X. Definately one of my favorite hacks.

/installs

[gedsta]

installed and thx

[Yorixz]

Very glad it's updated now, installed here as well!

[Ronak]

Was Waiting for this hack for a long time to be released !! Awesome :) Nominated !! for MOTM

[akanevsky]

Was Waiting for this hack for a long time to be released !! Awesome :) Nominated !! for MOTM
Thanks, much appreciated. :)

[hotwheels]

Awesome :) Nominated !! for MOTM I second that click..... :D

[Foxter]

Anthony, your hack is brilliant as ever! Thank you so much! :)

[BruceWest]

Installed! Thanks so much! I'll let you know how things turn out.

[hotwheels]

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]

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]

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]

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]

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]

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]

Thanks Andrew...I went ahead and tried to run the cron from the AdminCP and got a db error...I will wait. :)

[akanevsky]

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]

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]

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]

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]

{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]

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]

Sorry about that 'ANTHONY'...client that just left my office was named Andrew....please accept my apologies. :D

[eNforce]

I had the 3.5.4 version and loved it.

Install went smoothly on my 3.6 board, thanks!

[Snake]

Thanks a bunch! I was waiting for this.

[Emanet-Kaos]

awsome hack thanks :O)

[Darat]

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]

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]

Very well done! ;)

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

Mark

[oberheimhaven]

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]

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]

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]

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]

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

[Darat]

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

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]

* 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]

Will do - thanks

[syrus.xl]

Cool... working fine now with UK. :)

Great hack.

[smoknz28]

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]

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]

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]

The upgrade instructions are posted in the vBulletin 3.5 thread of this hack :).

[Blittz]

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]

Excellent! The cron URL error I always got on the old version is gone. :)

[MrNase]

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]

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]

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]

thank you great addon Dragonhart

[gedsta]

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

Thanx again :rolleyes:

[Dennis Kaczor]

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]

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]

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]

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]

The upgrade instructions are posted in the vBulletin 3.5 thread of this hack :).

Thank you. Wonderful hack.

*Installed/Upgraded* :)

[Rich]

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]

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]

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]

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]

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]

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]

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]

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

[akanevsky]

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]

amazing stuff, installed, thanks!

edit: Mine also doesnt show up in quick links.

[akanevsky]

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]

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]

Uninstalled it. Followed everything in the instructions (not the hardest thing to install) Dont think it likes one of my other mods.

[akanevsky]

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]

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]

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]

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]

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]

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]

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]

This doesn't seem to show the UK. I get shown under the US.

[mcyates]

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]

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]

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]

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]

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]

Cumulative.

[perfphysio]

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]

Download the latest package and overwrite the psistats database folder.That did the job. Thanks for the quick fix!

[GrendelKhan{TSU]

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]

Nice job on this one!

[Hoffi]

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]

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]

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]

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

My provider wont turn it on.

-N.

[mrderanged]

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]

Very very nice.

*installed* Nomination for MotM

[akanevsky]

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]

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]

nice hack, thanks.

[Nandakal]

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]

The data is not damaged, the flag is. To test, ask someone from that country to access your site. :)

[bashy]

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]

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]

God bless you, Mike-D. FYI, I can't recall you asking any questions.

[Phooey]

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]

Thank you, Psionic Vision.
This was a great product and it works great. No problem at all. Thanks and nominating.

[Lottis]

Hmm, why cant this be nominated?

[transitbus]

Edit NM Can't use this mod due to the lock issue. Oh well, looked good at the time.

[akanevsky]

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]

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]

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]

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]

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]

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]

i installed this hack successfully but i come with White empty Screen.
i modified permissions .
what can i do now ?

[akanevsky]

<a href="https://vborg.vbsupport.ru/showthread.php?t=130551" target="_blank">Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks.</a>

[Apoco]

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]

Judging from the error message, the table has become corrupt. Please contact your hosting provider to correct the problem.

[Masked Crusader]

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]

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]

Easy to install and works great. I wish all the vB add-ons had such detailed directions. Thanks again! :)

[ga2000gt]

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]

Great hack.

[farooqaaa]

Ahh thanks alot :). Its a major hack ;).

*farooqaaa have already clicked install....

[ga2000gt]

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]

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]

Just ignore me, I'm a retard. INSTALLED.

[itorrents]

Got my vote, thanks :)

[iran.gs]

Installed Excelent job 3.62

[zooman]

installed on 3.6.3 all I'm getting is

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

any thoughts

[akanevsky]

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]

<a href="https://vborg.vbsupport.ru/showthread.php?t=130551" target="_blank">Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks.</a>

[MediaHound]

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

[a squared]

Anxiously awaiting updated version. :)

[akanevsky]

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]

I voted for this mod for mod of the month..........awesome work

[a squared]

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]

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]

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]

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]

Great hack Installed

Thank you

[Makc666]

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]

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]

for french people who wants a translation of this hack

here it is (see attached file)

[akanevsky]

for french people who wants a translation of this hack

here it is (see attached file)

Thanks, much appreciated.

[firstrebel]

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]

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]

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]

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]

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]

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]

<font size="4">UPDATE: 1.4.1</font>

See changelog for details.
To upgrade:

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

[xtrass]

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]

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]

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]

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]

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]

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]

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]

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]

No they do not. Does your Captains Club group have moderator abilities?

[ncangler]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

Release - Version 1.4.2.
Overwrite psistats.php, the product xml, and rename ./includes/psistats/database_flags/gb.gif to uk.gif.

[EvilHawk]

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]

Perfect! Thank you!

[akanevsky]

You guys are gonna kill me, but...

:banana: RELEASE 1.4.3! :banana:

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

Done!

[GNDI]

your right, it ain't 5 minuts ago i upgraded to 1.4.2 :)

[Darat]

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]

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]

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]

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]

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]

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]

Is that on vBulletin 3.5 or 3.6?
I have the same error, version 3.6.4.

[Kanustep]

The same error appears to me - Version 3.6.4

[Betablocker]

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]

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]

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]

Just re-imported the product from a fresh download and it seems to be fine.

[Betablocker]

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]

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]

Looks like there is a flag missing:

[Betablocker]

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]

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]

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]

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]

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]

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]

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]

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]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1125600&postcount=199" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=199</a>

[GNDI]

your right :) thanks mate :)

[Vossi]

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]

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]

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]

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]

Thank you. Just wanted to let you know it's working perfect for me now.

Sorry about beating a dead horse earlier.

[akanevsky]

Just wanted to let you know it's working perfect for me now.

I'm glad. :)

Sorry about beating a dead horse earlier.

???

[xtrass]

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]

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 https://vborg.vbsupport.ru/showpost.php?p=1125673&postcount=212

[Makc666]

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]

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]

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]

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]

read this article https://vborg.vbsupport.ru/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]

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]

I'll think it because you have thought of all most it all from the beginning :)

[akanevsky]

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]

Please vote for psistats MOTM!
https://vborg.vbsupport.ru/showthread.php?t=132928

[yui333]

Ok, I love this hack.. I have voted for it in the MOTM

[da420]

Ok, I love this hack.. I have voted for it in the MOTM

As did I. ;)

[Darat]

Feature wish list: A way to look at just a given period within the results.

[EvilHawk]

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]

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]

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]

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]

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]

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]

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]

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]

So you would prefer a javascript or and xml feed, right?

Yeah, that would work best for me.

[nocte]

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]

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]

Please vote for psistats MOTM!
https://vborg.vbsupport.ru/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]

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]

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]

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]

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]

It would be an:
AND lastpost >= " . TIMENOW - 86400 . "
Add it right under the row that says WHERE.

[711]

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