psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x)

[nonet]

Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?

[akanevsky]

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


Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)

Excellent Hack!

Installed flawlessly but the "Active", "Non-Active", and "Activity Level" stats don't show. Anybody know if I missed something?



Check vBulletin user activity settings. Perhaps they are off or set to 0.

[711]

Try replacing:
TIMENOW - 86400
with:
(TIMENOW - 86400)





Check vBulletin user activity settings. Perhaps they are off or set to 0.


That worked great, thanks!

I just noticed that this query as edited doesn't pull the threads with the most views or replies in the last 24 hours, but rather pulls the threads with the most view or replies all-time that were active in the last 24 hours (lastpost).

But it's close enough :)


Thanks again.

Great work on this hack, my members love it.

[Makc666]

I was wrong in my description.
On the main stats page (psistats.php) the date is displayed in correct format:
dd/mm/yyyy

But in ACP in psiStats 2006 section there is a BUG with how a date must be entered.

As description says:
Date of Creation of Your Board
... please specify the correct date here is dd/mm/yyyy format.

But for now that field is parsed in format:
mm/dd/yyyy

In other words on the main page is:
25.10.2002

And in ACP you have to enter for now:
10/25/2002

Please, can you update it to correct format:
dd/mm/yyyy

Thanks :)

[aggiefan]

great script.... its very cool to track the stats.

one request and i dont even know if it is possible but 98% of our requests are from within the US so that doesnt help us a whole lot. Would it be possible to break that down by state (start with the US and add other countries when needed). Im sure this is something we would all love is a breakdown of even more specific data. (maybe replace the country info link with a state breakdown) or add a small link next to it with each countries hits broken down by area (ie states for the US)

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

https://vborg.vbsupport.ru/showthread.php?p=1137190 - Possible fix for this issue. It might be something you can incorporate. I'm going to re-install psiStats to see what happens. Will let you know.

[halpern]

Is there a stats pluggin that can be placed in a vbadvanced module? Can this one?

[Cybershaolin]

Excellent mod. :cool:

My moderating team is showing correct but with this mod, I get all my supermods as admins because I let them use some parts of the admincp.

I also noticed many other users having problems with the different part of moderators or supermods.

One suggestion: Why don't you use the same settings than the mod team page use in order to reflect exactly the same information?

[McCarroll21]

This is a great mod, my only problem is getting screen resolutions and color depths to show up. Everything else is working, and I waited the 15 minutes to see if that would help but nothing is happening.

Any help?

[Betablocker]

I to am having problems with screen resolutions and colour depths showing

i have 5 people with 1024x768 showing and with 32 bit
but there are like 80 members a day logging in + who ever else coming to the site. And i use 1280x768 myself and that dont show either.

i am on 1.4.3 and has been running a while on 3 of my sites but the screen resolutions and colour depths don't seem to be right on any of them.

Any idea how i can fix this ?

Great hack and thanks in advance

[deeoo]

Great mod! Installed!
Would be nice to have some stats (like screen-res) clickable to show which users still use 800x600.

ps.
I have 1 Admin, 2 Mods and 1 S-mod, but Psi says just 4 Admins.

[akanevsky]

I to am having problems with screen resolutions and colour depths showing

i have 5 people with 1024x768 showing and with 32 bit
but there are like 80 members a day logging in + who ever else coming to the site. And i use 1280x768 myself and that dont show either.

i am on 1.4.3 and has been running a while on 3 of my sites but the screen resolutions and colour depths don't seem to be right on any of them.

Any idea how i can fix this ?

Great hack and thanks in advance

Make sure to enable javascript in your browsers. And, if you use some less known browser, there may be problems too. Works fine in IE, Opera and Firefox.

I have 1 Admin, 2 Mods and 1 S-mod, but Psi says just 4 Admins.

Perhaps all have admincp access rights?

[Cybershaolin]

Well, don't you use the same disposition than the moderating team page?

Wouldn't it be more simple in order to reflect the same team like the one we actually have?

[Betablocker]

Make sure to enable javascript in your browsers. And, if you use some less known browser, there may be problems too. Works fine in IE, Opera and Firefox.


Yes all enabled, i use IE7 and firefox 2 and i can see the stats on some other users sites so not a java problem.

Everything else works perfect.

Cheers

[akanevsky]

Yes all enabled, i use IE7 and firefox 2 and i can see the stats on some other users sites so not a java problem.

Everything else works perfect.

Cheers

IE7 is not a stable browser and I cannot provide support for javascript-related stats if you use that.

[Betablocker]

IE7 is not a stable browser and I cannot provide support for javascript-related stats if you use that.

lol

i use Firefox 2 99% of the time and use IE7 to make sure things look right in both, seen as IE6 & IE7 is used by most the population. And it shows the same in all 3.

Thanks

[akanevsky]

lol

i use Firefox 2 99% of the time and use IE7 to make sure things look right in both, seen as IE6 & IE7 is used by most the population. And it shows the same in all 3.

Thanks

It works correctly in firefox 2 on my installation.

[Mupetz]

seen as IE6 & IE7 is used by most the population.
ROFL, nobody use IE :tired: , even my grandma has firefox
Maybe microbsoft use it

[akanevsky]

ROFL, nobody use IE
Oh? Show me some statistical proof, please, or withdraw your comment (that is, by the way, completely irrelevant to this thread). Thanks.

[akanevsky]

Sorry for off topic Psionic
That is a very sincere statement, indeed.

[Bison]

Great mod! Installed!
Would be nice to have some stats (like screen-res) clickable to show which users still use 800x600.

If he added that feature to this great hack, he might as well put this hack up for sale. I believe that would require a lot of code to tie an individual to a screen setting.

[Bison]

Psionic Vision, What's the list of operating systems and browsers does this program detect?

[Betablocker]

Psionic Vision, What's the list of operating systems and browsers does this program detect?

I am not Psionic Vision as you know:D but hope this helps a little, as seen on one of my sites.

Browsers:
Bot (Ask Jeeves) (0.01%) - 2
Bot (Google) (9.76%) - 1734
Bot (MSN) (1.69%) - 301
Bot (Unknown) (1.4%) - 249
Bot (Yahoo! Slurp) (18.11%) - 3217
Firefox 0.8 (0.01%) - 1
Firefox 0.9 (0.01%) - 1
Firefox 1.0 (0.87%) - 154
Firefox 1.5 (9.58%) - 1702
Firefox 2.0 (12.49%) - 2218
Galeon 1.3 (0.03%) - 5
Internet Explorer 5.0 (0.05%) - 8
Internet Explorer 5.5 (0.17%) - 31
Internet Explorer 6.0 (26.54%) - 4714
Internet Explorer 7.0 (17.67%) - 3139
Netscape 7.0 (0.01%) - 1
Netscape 8.1 (0.01%) - 2
Opera 8 (0.32%) - 56
Opera 9 (0.07%) - 12
Safari (0.24%) - 43
Unknown (0.97%) - 172

Operating Systems:
Free BSD (0.02%) - 2
Linux (0.19%) - 17
Mac OS X (0.54%) - 49
Macintosh (0.02%) - 2
Unknown (38.19%) - 3488
Windows 2000 (4.34%) - 396
Windows 2003 Server (0.86%) - 79
Windows 98 (0.96%) - 88
Windows ME (0.01%) - 1
Windows Vista (1.26%) - 115
Windows XP (53.61%) - 4897

[akanevsky]

I believe that would require a lot of code to tie an individual to a screen setting.

Not really.

Psionic Vision, What's the list of operating systems and browsers does this program detect?

You can see that for yourself by exploring the ./includes/psistats/ folder. :)

hope this helps a little, as seen on one of my sites.

That is not a full list, but thanks for trying. :)

[DementedMindz]

here is a little gif for OmniWeb's browser just upload it to /includes/psistats/database_agent and it will pick it up auto.

58166

[cupra]

wow that is very very cool thing, thx a lot installd!

[TheWhite]

great mod

[enrique007]

I Just installed the mod and I have a couple of questions. are the stats reset every month? how can you tell what your stats are daily, weekly or monthly?

and another thing, how can I tell how many vistors i have recieved on my site?

thanks

[akanevsky]

I Just installed the mod and I have a couple of questions. are the stats reset every month? how can you tell what your stats are daily, weekly or monthly?

No, the stats are not reset.

and another thing, how can I tell how many vistors i have recieved on my site?

I am sorry, I don't understand the question.

[Bison]

No, the stats are not reset.



I am sorry, I don't understand the question.

I think he means "how many *un-registered* visitors" have viewed his site.

[akanevsky]

Oh, that item is not tracked.

[Bison]

here is a little gif for OmniWeb's browser just upload it to /includes/psistats/database_agent and it will pick it up auto.

58166

Is it that simple to add a browser icon and the software will detect it? If not, then how can I get this to detect other browsers (ex: SeaMonkey, Maxthon, Netcaptor, etc...)

[akanevsky]

Is it that simple to add a browser icon and the software will detect it? If not, then how can I get this to detect other browsers (ex: SeaMonkey, Maxthon, Netcaptor, etc...)

Yes, it is that easy to add icons for items that are recognized. I don't think Maxthon is in the list of detected browsers, but if seamonkey is, then go ahead and add it. Make sure that the filename of the gif file is the same as the abbreviation for that browser in the database.

[Bison]

Which table in the database are these browsers listed?

I only see the psistats_data and psistats_cache tables...

[akanevsky]

Which table in the database are these browsers listed?

I only see the psistats_data and psistats_cache tables...

They are not in the database. They are in includes/psistats/.

[Bison]

Thanks, I figured out how to add additional browsers to the list as well. Now i've added SeaMoney, NetCaptor, and Maxthon. I've also changed the icon associated with IE7 browser to differ with the current IE6 browser as well. ;)

[akanevsky]

Thanks, I figured out how to add additional browsers to the list as well. Now i've added SeaMoney, NetCaptor, and Maxthon. I've also changed the icon associated with IE7 browser to differ with the current IE6 browser as well. ;)

It would be nice if you submit your icons to this thread. :)

[Bison]

Here you go!

Firefox, Maxthon, SeaMonkey, and NetCaptor

[Kasey]

Installed!

[storpappa]

Installed!

Any plans to update these additional browsers and the IE7 icons on a future update?

[akanevsky]

Installed!

Any plans to update these additional browsers and the IE7 icons on a future update?

Of course. Anything contributed is added.

[Bison]

Of course. Anything contributed is added.

So why hasn't the last update been changed?

[akanevsky]

So why hasn't the last update been changed?

Correction: it is added at the new release, whenever the new release comes.

[Brandon Sheley]

looks pretty nice
I'll check it out

[Quantnet]

Not sure if it's a bug or me but my Styles usage always show 100% for the forum default style and 0 the rest even after i change default style to a different style.

[akanevsky]

Not sure if it's a bug or me but my Styles usage always show 100% for the forum default style and 0 the rest even after i change default style to a different style.

Make sure you change in options, not in quick chooser.

[YeşiLMeN]

Thanks :) perfect statistics

Turkish Language pack
T?rkLer i?in T?rk?e DiL Dosyası Ektedir.

[stinger2]

another remarkable hack fro psionic....thx bro...looks great

[lukemax]

SOS, I am trying to install this hack, all the steps are done except the file uploads.
I have the forum installed in /forum/ and the instructions say to upload 1 file, so I uploages psistats.php into that directory and I dont see any changes.
eeerrr Help.
Thanks.

[akanevsky]

SOS, I am trying to install this hack, all the steps are done except the file uploads.
I have the forum installed in /forum/ and the instructions say to upload 1 file, so I uploages psistats.php into that directory and I dont see any changes.
eeerrr Help.
Thanks.

Have you done template customizations?
What exactly do you expect to see?

[lukemax]

(I was looking at the screenshot and they didn't jive (nothing new below the vBulletin options, byut it is an option, in the list box, so I just was confused)
k, think I got it to work, i uploaded the file in includes/xml and includes/cron as well as the folder, includes/psistats as well as the file in the admincp/ lastly the psistats.phpp into my forums/.
OK, but when I take a look at the site statistics and click on the bottom three links( Countries & Regions | Browsers & Operating Systems | Referring Sites), no data is shown (Just the Title bars)?

Is that ok?

[akanevsky]

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

[interfx]

This might ahve been asked already, but if I integrate the headinclude part of the code to a non-vbulletin page on my site, will it also keep track track of stats on non-vbulletin type pages?

Thanks

[akanevsky]

No.

[iardon]

Psionic Vision,

Great mod, installed, but it would be nice if the images didn't need to be under /includes/. That way I could continue to .htaccess that folder which is recommended by VB.

Thanks.

[akanevsky]

That way I could continue to .htaccess that folder which is recommended by VB.

You can .htaccess that folder but then not .htaccess the psistats folder...

[iardon]

Thanks, but I can't figure out how to do that via cpanel. Can you tell me what to write in my .htaccess file so that everything but your folder will be protected?

EDIT... was able to figure it out.

Thanks.

[Kasey]

:confused: not sure what the problem is...maybe I'm reading it wrong...

for instance...if I look at the countries and regions stats....if I am reading that correctly...
it is saying we have 1996 members in north america....which I know is false as we don;t have that many members period. Or am I reading this all wrong?

[akanevsky]

:confused: not sure what the problem is...maybe I'm reading it wrong...

for instance...if I look at the countries and regions stats....if I am reading that correctly...
it is saying we have 1996 members in north america....which I know is false as we don;t have that many members period. Or am I reading this all wrong?

Read it as "hits, 15 minute interval".

[Kasey]

THANKS!


Now I get it.....NOW it makes sense!


(I'm Blonde, so I have an excuse)

[DARKSTARVB]

Very good hack - Awesome

Ty

DarkStar

[Forza]

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.

I have about 17000 members and about 100-150 people online at the same time. I have this installed on my localhost now and I would really like to put this on my live board. will this have a noticable effect on the speed of my site? And what if i just give access to my admins, would that take away some server load and speed issues?

either way, the mod looks great!

[akanevsky]

I have about 17000 members and about 100-150 people online at the same time. I have this installed on my localhost now and I would really like to put this on my live board. will this have a noticable effect on the speed of my site? And what if i just give access to my admins, would that take away some server load and speed issues?

either way, the mod looks great!

A new version has already been released - shouldn't slow down your site at all.

[evilfairygirl]

OK, I havent a clue whats wrong here...I have followed the directions to the letter....I think =\

MySQL Error : Table 'dbuser_vbullshit.vdpsistats_cache' doesn't exist Error Number : 1146
Date : Friday, January 19th 2007 @ 03:11:03 PM
Script : http://www.domain.com/forum/attachment.php?attachmentid=1624&stc=1&thumb=1&d=1169174700
Referrer : http://www.domain.com/forum/showthread.php?t=338
IP Address : xx.3.19.xxx
Username : userone
Classname : vb_database

:eek:

any ideas...? I know i haven't

Thanks in advance...

[akanevsky]

Have you installed the product? If yes, the error message should not appear.

[evilfairygirl]

You're a genius!

It was installed I did leave out a file though....

installed!!

[GNDI]

Look at this line:

Table 'dbuser_vbullshit.vdpsistats_cache' doesn't exist

It says it all You are missing this table in your database try to uninstall the script and re-install it

[axyr]

Hi, first of all, kudos on the new version!

I have a question though. What was the reason for changing the coding that calculated the moderators and administrators to this:

$adminugs = array();
$smodugs = array();

foreach ($vbulletin->usergroupcache as $usergroupid => $usergroup)
{
if ($usergroup['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
$adminugs[] = $usergroupid;
}
else if ($usergroup['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['ismoderator'])
{
$smodugs[] = $usergroupid;
}
}

if (sizeof($adminugs))
{
$adminugs_cond = array();
foreach ($adminugs as $ugid)
{
$adminugs_cond[] = "FIND_IN_SET($ugid, membergroupids)";
}

$getadmins = $db->query_first("
SELECT COUNT(userid) as X
FROM " . TABLE_PREFIX . "user
WHERE usergroupid IN (" . implode(',', $adminugs) . ")
" . (sizeof($adminugs_cond) ? "OR " . implode(' OR ', $adminugs_cond) : "") . "
");

$c['administrators'] = $getadmins['X'];
}

if (sizeof($smodugs))
{
$smodugs_cond = array();
foreach ($smodugs as $ugid)
{
$smodugs_cond[] = "FIND_IN_SET($ugid, membergroupids)";
}

$getsmods = $db->query_first("
SELECT COUNT(userid) as X
FROM " . TABLE_PREFIX . "user
WHERE usergroupid IN (" . implode(',', $smodugs) . ")
" . (sizeof($smodugs_cond) ? "OR " . implode(' OR ', $smodugs_cond) : "") . "
");

$c['smoderators'] = $getsmods['X'];
}

$getmods = $db->query_read("
SELECT DISTINCT userid
FROM " . TABLE_PREFIX . "moderator
WHERE forumid <> -1
");

$c['moderators'] = $db->num_rows($getmods);

$c['staff'] = $c['administrators'] + $c['smoderators'] + $c['moderators'];
}


In the last version I was able to change what defined an administrator, and what defined a moderator. I was able to change it to define it by usergroups. I need to be able to do that because I have multiple groups that use the admin cpanel, but aren't actual administrators.

I also have two different moderator groups that I was able to define and show on the last version. Now it shows everyone that has access to the mod cp as moderator, and some of them are only blog mods, which I don't want showing up.

Under this new piece of coding, will I be able to define my custom groups, and define them by usergroup instead of by who has access to mod and admin cpanels?

Thank you! :)

[akanevsky]

Hi, first of all, kudos on the new version!

I have a question though. What was the reason for changing the coding that calculated the moderators and administrators to this:

$adminugs = array();
$smodugs = array();

foreach ($vbulletin->usergroupcache as $usergroupid => $usergroup)
{
if ($usergroup['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
$adminugs[] = $usergroupid;
}
else if ($usergroup['adminpermissions'] & $vbulletin->bf_ugp_adminpermissions['ismoderator'])
{
$smodugs[] = $usergroupid;
}
}

if (sizeof($adminugs))
{
$adminugs_cond = array();
foreach ($adminugs as $ugid)
{
$adminugs_cond[] = "FIND_IN_SET($ugid, membergroupids)";
}

$getadmins = $db->query_first("
SELECT COUNT(userid) as X
FROM " . TABLE_PREFIX . "user
WHERE usergroupid IN (" . implode(',', $adminugs) . ")
" . (sizeof($adminugs_cond) ? "OR " . implode(' OR ', $adminugs_cond) : "") . "
");

$c['administrators'] = $getadmins['X'];
}

if (sizeof($smodugs))
{
$smodugs_cond = array();
foreach ($smodugs as $ugid)
{
$smodugs_cond[] = "FIND_IN_SET($ugid, membergroupids)";
}

$getsmods = $db->query_first("
SELECT COUNT(userid) as X
FROM " . TABLE_PREFIX . "user
WHERE usergroupid IN (" . implode(',', $smodugs) . ")
" . (sizeof($smodugs_cond) ? "OR " . implode(' OR ', $smodugs_cond) : "") . "
");

$c['smoderators'] = $getsmods['X'];
}

$getmods = $db->query_read("
SELECT DISTINCT userid
FROM " . TABLE_PREFIX . "moderator
WHERE forumid <> -1
");

$c['moderators'] = $db->num_rows($getmods);

$c['staff'] = $c['administrators'] + $c['smoderators'] + $c['moderators'];
}


In the last version I was able to change what defined an administrator, and what defined a moderator. I was able to change it to define it by usergroups. I need to be able to do that because I have multiple groups that use the admin cpanel, but aren't actual administrators.

I also have two different moderator groups that I was able to define and show on the last version. Now it shows everyone that has access to the mod cp as moderator, and some of them are only blog mods, which I don't want showing up.

Under this new piece of coding, will I be able to define my custom groups, and define them by usergroup instead of by who has access to mod and admin cpanels?

Thank you! :)

The reason is - speed of execution.

[rjmjr69]

I cant seem to view this anywhere on my forum. I know I installed it to the word. But nothing appears anywhere that i can see other than in the admincp under options. I can only change a few but nothing appears on the forum no statics at all. What am I missing.

[akanevsky]

I cant seem to view this anywhere on my forum. I know I installed it to the word. But nothing appears anywhere that i can see other than in the admincp under options. I can only change a few but nothing appears on the forum no statics at all. What am I missing.

Have you looked under Quick Links?

[Forza]

finally installed it on my live board. the script gives some very interesting and often unexpected information (like the huge amount of people using a 800x600 ratio).

So thanks for this!

a feature i would love to see in a future release is general trafic information (unique visitors per day/week/month, pageviews etc.)

[Dustman]

Hi,

is there any fix with the Lock Table Problem: ?

Invalid SQL:
LOCK TABLES vb3_psistats_cache READ, vb3_psistats_data READ;

...

My Hoster don't support it...

[akanevsky]

Hi,

is there any fix with the Lock Table Problem: ?



My Hoster don't support it...

You get LOCK errors in vBulletin crons too, don't you? Cause if you hoster doesn't support it, some of vBulletin's crons won't work either.

[Dustman]

Sry, my Englisch is not so good...

I get every 15 minutes this Error Message:

Datenbankfehler in vBulletin 3.6.4:

Invalid SQL:
LOCK TABLES vb3_psistats_cache READ, vb3_psistats_data READ;

MySQL-Fehler : Access denied for user 'xxx'@'localhost' to database 'xxx'
Fehler-Nr. : 1044
Datum : Sunday, February 4th 2007 @ 07:47:44 PM
Skript : http://www.deepblueboard.com/vb/cron.php?&rand=946324
Referrer : http://www.deepblueboard.com/vb/index.php?
IP-Adresse : ---
Benutzername : Unregistriert
Klassenname : vB_Database

The Other crons works normal... So what shoud i ask my Hoster?

[akanevsky]

Sry, my Englisch is not so good...

I get every 15 minutes this Error Message:



The Other crons works normal... So what shoud i ask my Hoster?

Ask them to enable LOCK/UNLOCK permission for the MySQL user.

[DementedMindz]

Psionic Vision thanks again for the update.

[HMBeaty]

EDIT: Nevermind, fixed

[blogtorank]

Thanks for the update again!

[Makc666]

Psionic Vision
Compare this one with you 1.4.4 with something like Araxis Merge v6.5.
I fixed all errors I was speaking about in this post.
This will help you to include them very easily in 1.4.5 ;)

[jw00dy]

Updated, thank you!

[akanevsky]

Psionic Vision
Compare this one with you 1.4.4 with something like Araxis Merge v6.5.
I fixed all errors I was speaking about in this post.
This will help you to include them very easily in 1.4.5 ;)

What are you talking about?

[rjmjr69]

Have you looked under Quick Links?


Yes I have looked there. I guess the code is either misplaced or messed up either or I would not doubt with me doing the work....lol I'll look it over but I have had problems placing items into my drop downs I think it has something to do with the skin. I use Surge does anyone else have this problem or a fix?


Thanks

[encryption]

any ideas why I'm getting this ? Mod was working fine yesterday and I only had the datacenter add a new hard drive to my server last night and this morning I wake up to find my site is down and thats the error on the front page.

Database error in vBulletin 3.6.4:

Invalid SQL:

REPLACE INTO `ms_psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('207.255.58.76', 'country', '207.255.58.76_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1', 'useragent', '207.255.58.76_useragent'), ('1024x768', 'screenresolution', '207.255.58.76_screenresolution'), ('32', 'screendepth', '207.255.58.76_screendepth');

MySQL Error : Incorrect key file for table './XXXX_XXXX/ms_psistats_cache.MYI'; try to repair it
Error Number : 126
Date : Wednesday, February 7th 2007 @ 05:15:17 AM
Script : http://www.mercuryserver.com/forums/index.php
Referrer :
IP Address : 207.255.58.76
Username : XXXXX
Classname : vB_Database

How do I go about disabling this from phpmyadmin (because I cant even login to the admin panel anymore due to the above error)

[encryption]

ok I repaired the table and all appears to be ok now

[karabalsagun]

What are you talking about?

Don't be rude =), I think he was talking about this post (https://vborg.vbsupport.ru/showpost.php?p=1133728&postcount=255)


By the way, it'd be cool if you defined some major linux distros

[DementedMindz]

I dont think he was being rude he was just asking a question I was puzzled to by the reply.

[akanevsky]

Don't be rude =), I think he was talking about this post (https://vborg.vbsupport.ru/showpost.php?p=1133728&postcount=255)


By the way, it'd be cool if you defined some major linux distros

If that's the case, the post doesn't make any sense - the typo has been fixed. That's why I am not sure why he is talking about. And rudeness has nothing to do with this...

[karabalsagun]

Umm... I think I'd choose the wrong word, sorry I'm not a native english speaker =)

As I stated in my previous post, can psiStats detect which Linux distro I am using?

[akanevsky]

As I stated in my previous post, can psiStats detect which Linux distro I am using?

No, it cannot.

[parrot5]

Read it as "hits, 15 minute interval".

So the data that is displayed is only for a 15 minute interval? Not accumlated?

[enrique007]

Anyway I could keep my stats private without the rest of the world looking at them? Once the crawler(s) index the website in a search engine, anyone can just click on the link and see your stats. Anyway I Can prevent that?

Thanks

[Betablocker]

Thanks for this update.

Now all my sites are showing the correct Display Colors & Resolutions

Thanks again.

[Betablocker]

Anyway I could keep my stats private without the rest of the world looking at them? Once the crawler(s) index the website in a search engine, anyone can just click on the link and see your stats. Anyway I Can prevent that?


Thanks

Goto your Admin cp
then goto vBulletin Options (http://www.disturbingthepeace.co.uk/vb/admincp/options.php?null=0)
find psistats 2006
there find Usergroups Allowed To View Statistics
there you will find the option as to what group can see the stats
6 is Admins only

Hope this helps

[iardon]

Psionic,

If I decide to uninstall this mod, will it remove the added tables for me or do I have to manually remove them from the database?

Thanks.

[akanevsky]

So the data that is displayed is only for a 15 minute interval? Not accumlated?

No. The stats are updated every 15 minutes.

Anyway I could keep my stats private without the rest of the world looking at them? Once the crawler(s) index the website in a search engine, anyone can just click on the link and see your stats. Anyway I Can prevent that?


Thanks

vBulletin Options -> psiStats 2006

Psionic,

If I decide to uninstall this mod, will it remove the added tables for me or do I have to manually remove them from the database?

Thanks.


It will remove them automatically. Why would you want to uninstall it though?

[iardon]

It will remove them automatically. Why would you want to uninstall it though?

Oh, nothing against your mod as it's a good one but I just don't find myself looking at my stats that often. Maybe once a week. So I just thought it's better not to have it installed if I really don't use it.

[akanevsky]

Oh, nothing against your mod as it's a good one but I just don't find myself looking at my stats that often. Maybe once a week. So I just thought it's better not to have it installed if I really don't use it.

I don't think stats are supposed to be viewed on a daily basis... I look at them only twice a month, yet I still have 'em installed. :)

[enrique007]

Thanks Betablocker, that solve the problem.

[Pete C]

Thank you. A useful and informative addition - *installed*

Just one minor problem: It's counting Admins and Supermods correctly, but it's showing 2 additional Moderators. We used to have 1 Supermod and 2 Mods, we now have 3 Supermods and no Mods but the display says Supermods = 3 Mods = 2. Any way to fix this?

(if the answers been posted already, may I have the link please?)

[akanevsky]

Thank you. A useful and informative addition - *installed*

Just one minor problem: It's counting Admins and Supermods correctly, but it's showing 2 additional Moderators. We used to have 1 Supermod and 2 Mods, we now have 3 Supermods and no Mods but the display says Supermods = 3 Mods = 2. Any way to fix this?

(if the answers been posted already, may I have the link please?)

Please check your forum moderators and make sure that the supermoderators are not also listed as moderators of specific forums.

[toddos]

i have a problem with psistats:
It doesnt show any statistiscs about the users. Only the statistics about the forum (How may Posts, PMs, Threads etc.) are ok.

But statistics like the countries of the users, the browsers etc. aren't showed. The site is empty then...

Whats wrong?

[akanevsky]

i have a problem with psistats:
It doesnt show any statistiscs about the users. Only the statistics about the forum (How may Posts, PMs, Threads etc.) are ok.

But statistics like the countries of the users, the browsers etc. aren't showed. The site is empty then...

Whats wrong?

Have you waited 15 minutes since the installation?

[toddos]

yes, about 14 days. ;)

[akanevsky]

That is odd. Have you enabled the crons? Also, try uninstalling and then reinstalling the product xml.

[toddos]

yes i had enabled it, but i always got emails with sql errors like

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('82.207.241.82', 'country', '82.207.241.82_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1', 'useragent', '82.207.241.82_useragent');

MySQL-Fehler : Server shutdown in progress
Fehler-Nr. : 1053

and the server was ok, everything else worked normally

reinstalling didnt help

[akanevsky]

MySQL-Fehler : Server shutdown in progress
Fehler-Nr. : 1053

That's the problem. Please contact your hosting provider.

[toddos]

i contacted him, but he couldnt help. He didnt know why this script shutdown the server?

[akanevsky]

i contacted him, but he couldnt help. He didnt know why this script shutdown the server?

It's not the script. It's the server. This error can only happen if the MySQL server is being restarted. If the hosting provider thinks it is the script, then he is clearly incompetent and you might want to switch to a different one.

[toddos]

andyes i know now. the server was rebooted every few hours. Now it is set to eery 6 hours a reboot.

but this couldnt be the problem because psistats doesnt work. It can only be a problem, if psistats tries to write something in the database during the reboot. But the reboot takes about 6 seconds or less.. so ...

[Pete C]

Please check your forum moderators and make sure that the supermoderators are not also listed as moderators of specific forums.

Thanks for the reply - they are indeed still listed as moderators of specific forums. Clearly that isn't necessary now they have Supermod status. My fault, thanks for the heads-up :up:

[toddos]

hi,
i installed it again and i dont know why, but now its working :)

One question: how can i delete the statistic site: "Home" ?

[akanevsky]

hi,
i installed it again and i dont know why, but now its working :)

One question: how can i delete the statistic site: "Home" ?

Why would you want to delete that?

[toddos]

because i dont want to view this to the users, only for me..

[Tralala]

I like this hack, thanks for making it, Psionic Vision!

Configurable list of usergroups that can access statistics (optional).
I set this so that only admins (usergroup 6) can access statistics. The menu option in "Quick Links" was still available to all users, though. (It didn't afford them access to anything, but I preferred they not see it at all.) I fixed this by putting this in navbar:

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


It'd be nicer if this tied in automatically with the permitted usergroups set via the AdminCP, obviously.

As a future feature request, I'd also love more detailed/specific permissions. For example, I'd like to allow registered users to view "Top Threads & Forums," but nothing else.

/clicks install

[Tralala]

Oh, and now that I have this information, is there a way to discover specifically which users are using what style? In other words, if psiStats reports there are only two users who have chosen "SkyBlue" in their UserCP, is there a way to find out who those two users are? Like a search in the AdminCP or something? I can't seem to find it. If I get rid of that style I'd like to let them know ahead of time.

Thanks again for a great add-on!

[Makc666]

What are you talking about?
I am talking about bugs about which I wrote in this topic before:
1. Several untranslated words.
2. A missed space.

[toddos]

and, Psionic Vision? How can i realize this ? ;)

[akanevsky]

I like this hack, thanks for making it, Psionic Vision!


I set this so that only admins (usergroup 6) can access statistics. The menu option in "Quick Links" was still available to all users, though. (It didn't afford them access to anything, but I preferred they not see it at all.) I fixed this by putting this in navbar:

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


It'd be nicer if this tied in automatically with the permitted usergroups set via the AdminCP, obviously.

As a future feature request, I'd also love more detailed/specific permissions. For example, I'd like to allow registered users to view "Top Threads & Forums," but nothing else.

/clicks install

Your suggestion will be noted. Thank you.

Oh, and now that I have this information, is there a way to discover specifically which users are using what style? In other words, if psiStats reports there are only two users who have chosen "SkyBlue" in their UserCP, is there a way to find out who those two users are? Like a search in the AdminCP or something? I can't seem to find it. If I get rid of that style I'd like to let them know ahead of time.

Thanks again for a great add-on!

You could run query. Something like this:
SELECT userid, username FROM user WHERE styleid = XXX

I am talking about bugs about which I wrote in this topic before:
1. Several untranslated words.
2. A missed space.

If you can, please link me to those posts. I offered to post suggestions over at visionscripts, where would have been addressed promptly, but nobody responded so I dropped the offer. Now, all suggestions are to be posted in this thread, where they are likely to be forgotten unless reminded of.

[toddos]

i dont want to get on your nervs, but can you help me Psionic Vision?

How can i delete the stats page "Home" / how can i make it (only this page) invisible for normal users ?

[akanevsky]

i dont want to get on your nervs, but can you help me Psionic Vision?

How can i delete the stats page "Home" / how can i make it (only this page) invisible for normal users ?

That is not possible in the current version unless you have some coding knowledge. Sorry, but I am not going to provide modding advice. Thanks.

[toddos]

ok, tell me only how i can delete the link of the homestats and how i can it make so that the statistic is starting with the Top Threads & forums ?

[akanevsky]

ok, tell me only how i can delete the link of the homestats and how i can it make so that the statistic is starting with the Top Threads & forums ?

You can edit the psistats_footer template to remove the link, and then add do=toptf to the quick links statistics link.

[toddos]

ah ok, this was very easy, sorry for asking ^^

[PoetJA-1975]

hmmmm - One last thing before ditching...
One 3.5.4 version I was told to run query, because the cron didn't install correctly...
https://vborg.vbsupport.ru/showpost.php?p=1090815&postcount=529

INSERT INTO `cron` VALUES (NULL, 1136665500, -1, -1, -1, 'a:1:{i:0;i:25;}', './includes/cron/psistats_update.php', 1, 'psiStats 2006 Update (15-Minute Interval)')

would this have any affect on 3.6.4? Because like I've said ((in the 3.5.x psistats thread...)) fresh install, lock tables permission OK, all instructions followed properly.

When running the cron the message simply states: psiStats 2006 Update (15-Minute Interval) and nothing else.

Any ideas?

Jacquii.

[TrIn@dOr]

Installed thanks.

Translated to spanish.

[akanevsky]

One 3.5.4 version I was told to run query, because the cron didn't install correctly...

No, the 3.6.4 version installs the cron correctly.

When running the cron the message simply states: psiStats 2006 Update (15-Minute Interval) and nothing else.

It should not say anything else if everything is OK.

Translated to spanish.

Can you please post your translation?

[RS_Jelle]

I think it would be nice to add a new os icon for Windows Vista since it will become more and more popular :)

A small remark for the xml-feed.png and js-feed.png images: can you add a border="0" to it, because not everyone has got this as a standard item in their CSS (and a border around it is very ugly).

[LisaD1]

I need help with the activity settings. How do you set them in admincp? As much as I would LOVE to think we have 100% active members, we don't.
I added an attachment to show what it is doing.
Sorry if this has been posted, I looked but am super tired and didn't find it :(

[kaptanblack]

Thanks..

[giovannicosta]

<font color="Red">*Installed"</font>

[DJ XtAzY]

i believe i found a bug... some of my styles have replacement variables but it seems psistats can use them correctly, causing broken images

[BANDiT600]

* BANDiT600 Updated :)

[Keyser S?ze]

u should consider adding attachment stats

[woody200456]

Hello there,

was just wondering how i would port this into the Forum Home template if possible at all??

[aycan555]

Hi, thanks for this free mod, i like your all mods, they are usefull:)

But i have got someproblem with stats, why it is dublicating the countries? examples shown on the picture below:

http://img407.imageshack.us/img407/8131/statsed0.jpg

[akanevsky]

I am not sure why it does that, never seen such thing before. Can you please link me to the actual psistats page on your site?

[aycan555]

<a href="http://www.dizi-tr.com/forum/psistats.php?do=regions" target="_blank">http://www.dizi-tr.com/forum/psistats.php?do=regions</a> This is the link to the stats, also it does same thing on the referer sites..

[akanevsky]

Anyone else with the same problem?

[DementedMindz]

nope mine is working fine no doubles

[66mustang93]

Nice job on this !

[momo2]

installed on 3.6 works like a charm... thanksssssssssss

[MediaHound]

woe is me...

#1017 - Can't find file: 'psistats_cache.MYI' (errno: 2)

A db repair did not fix it, so...
I've dropped this table but I'm still having major problems with my forum.
I need to do a manual uninstall. I cannot log into my admin panel without a database error.
So what must I do to totally rid my site of this mod by hand?

thanks in advance

[MediaHound]

woe is me...

#1017 - Can't find file: 'psistats_cache.MYI' (errno: 2)

A db repair did not fix it, so...
I've dropped this table but I'm still having major problems with my forum.
I need to do a manual uninstall. I cannot log into my admin panel without a database error.
So what must I do to totally rid my site of this mod by hand?

thanks in advance

anybody?

[akanevsky]

anybody?

Please contact your hosting provider... This will likely need you to drop the table and recreate it.

[FReeSTER]

Great Mod If I dont get it working correctly. The Problema I have is that 4 some reason wont give the Graph images stats. It goes Blank. All other stats works great but no Graph.

Anyone knows what am I doing wrong?

Sorry, problem fixed.

Solution!
Refresh the page. LMAO

TY for this great Mod :)

[MediaHound]

Please contact your hosting provider... This will likely need you to drop the table and recreate it.

It's my server and I have phpMyAdmin installed
Could you give me the sql to recreate the tables?
I've already dropped the psi tables.

Thank you!

[akanevsky]

You don't need the queries. Just re-import (w/ overwrite) the product XML, and it will run the queries for you. :)

[MediaHound]

Yes I think I do as I'm unable to access the admin panel (well, I can't get past the admin login screen) nor the public site.
I get database errors basically everywhere.

[akanevsky]

Assuming those are psistats database errors, please do the following:

Open ./includes/config.php, and add the following code on the next line after <?php:

define('DISABLE_HOOKS', true);

Re-install the product, then remove the line.

[MediaHound]

That got me up and running, thanks!

[TrIn@dOr]

Can you please post your translation?

Tell me how and i will for sure, sorry for the delay!

[TrIn@dOr]

Tell me how and i will for sure, sorry for the delay!

Done, please double check this, is my first one!

Language: Spanish, Argentina

[akanevsky]

Perfect, thanks for sharing.

[Murty]

Hey, I love this mod and it all works fine... except...

For some reason, none of the "Display Colors & Resolutions" statistics are shown.
Any thoughts as to why it wouldn't be showing?

[z0diac]

WHere exactly are the stats supposed to show up? I've done the template edits, I've imported the xml file... I cant see where the stats are. (???)

Or is it just Quicklinks -> Site Statistics ?

http://forum.icedogfans.com

[Murty]

Should be a link under 'quick links' or something i think.

[Murty]

Hey, I love this mod and it all works fine... except...

For some reason, none of the "Display Colors & Resolutions" statistics are shown.
Any thoughts as to why it wouldn't be showing?

Bump.

[navajotex?]

The referring sites database is empty.
not inglese
non conosco l'iglese
uso versione 3.6.8

[KidCharlemane]

Any ideas?

psiStats 2006 Update (15-Minute Interval)

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /usr/local/psa/home/vhosts/mydomaingoeshere/httpdocs/includes/psistats/database_ip/192.php on line 7096

Any ideas?

[aycan555]

Any ideas?

psiStats 2006 Update (15-Minute Interval)


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 35 bytes) in /usr/local/psa/home/vhosts/mydomaingoeshere/httpdocs/includes/psistats/database_ip/192.php on line 7096

Any ideas?

This error usually comes when you upload the files with wrong mode, just read the installation notice carefully ;)

[KidCharlemane]

I must be blind. I dont see anything in the manual or the FAQ that says the files have to be uploaded in a particular mode.

[navajotex?]

The referring sites database is empty.
not inglese
non conosco l'iglese
uso versione 3.6.8


............is ok:D:up:

[z0diac]

How do I get this to show up anywhere? I mean, I can enter the url <domain>/psistats.php and get it, but nobody ELSE knows where it is. How I can I get it to say, show up in QuickLinks?

[redlabour]

Does it work with 3.7 ?

[vmacedonia]

Does it work with 3.7 ?

Yes,
for now no problems.

[Pro Scribz]

Looks good, but I would have liked it more if there were capabilities of checking unique views and views of all pages clearly!

Thanks for the modification though!

[Silver Boy]

I was upgrade my board from 3.6.8 to 3.7 and I should revert my style
so my question is if I revert style then add template edit(for this mod), old database is work correctly ?

OR is new version of this modification for 3.7 edition that work with old database of this mod ?

[deLi_kurT]

Thanks..

[akanevsky]

I was upgrade my board from 3.6.8 to 3.7 and I should revert my style
so my question is if I revert style then add template edit(for this mod), old database is work correctly ?

OR is new version of this modification for 3.7 edition that work with old database of this mod ?

Yes, it will work correctly.

[Empoeq]

thanx brother

[citroenar]

works ok with 3.7.1

[Kanustep]

After a PHP/MySQL/Apache upgrade this error start appear to me in vBulletin:

Invalid SQL:

SELECT COUNT(`cdata`) as count, `ctype`, `cdata`
FROM `psistats_cache`
GROUP BY `ctype`, `cdata`;

MySQL Error : Error writing file '/tmp/MYD1IQUd' (Errcode: 122)
Error Number : 3


Any one got the same or know how to fix? Thank you.

[vitrag24]

this was really nice mod.
any plan to have such mod for vb 3.7?

[edgecutioner]

this was really nice mod.
any plan to have such mod for vb 3.7?


vB 3.7 already has a social networking feature built in IIRC

[vitrag24]

vB 3.7 already has a social networking feature built in IIRC

this psistats was showing several stats where i can see them in vbulletin?

[akanevsky]

vB 3.7 already has a social networking feature built in IIRC
psiStats isn't a social networking feature. It's a statistics module. And yes, it does work on 3.7. :)

[princeedward]

hi...can anyone pls...help me to solve this problem...and what cause this trouble to my site...appreciate any help from anyone out there...


Database error in vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('xx.xx.xx.xxx', 'country', 'xx.xx.xx.xxx_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16', 'useragent', 'xx.xx.xx.xxx_useragent');

MySQL Error : Can't find file: 'psistats_cache' (errno: 2)
Error Number : 1017
Date : Thursday, August 21st 2008 @ 05:50:11 AM
Script : http://mysite.com/index.php
Referrer :
IP Address : xx.xx.xx.xxx
Username : princeedward
Classname : vB_Database

thanks in advance...

[princeedward]

hi...can anyone pls...help me to solve this problem...and what cause this trouble to my site...appreciate any help from anyone out there...


Database error in vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('xx.xx.xx.xxx', 'country', 'xx.xx.xx.xxx_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16', 'useragent', 'xx.xx.xx.xxx_useragent');

MySQL Error : Can't find file: 'psistats_cache' (errno: 2)
Error Number : 1017
Date : Thursday, August 21st 2008 @ 05:50:11 AM
Script : http://mysite.com/index.php
Referrer :
IP Address : xx.xx.xx.xxx
Username : princeedward
Classname : vB_Database

thanks in advance...BUMP!

[princeedward]

hi...can anyone pls...help me to solve this problem...and what cause this trouble to my site...appreciate any help from anyone out there...


Database error in vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('xx.xx.xx.xxx', 'country', 'xx.xx.xx.xxx_country'), ('Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16', 'useragent', 'xx.xx.xx.xxx_useragent');

MySQL Error : Can't find file: 'psistats_cache' (errno: 2)
Error Number : 1017
Date : Thursday, August 21st 2008 @ 05:50:11 AM
Script : http://mysite.com/index.php
Referrer :
IP Address : xx.xx.xx.xxx
Username : princeedward
Classname : vB_Database

thanks in advance...any possible help on this problem pleaseeeeeeee...:(

[princeedward]

:down: Mark Uninstalled !

no chance for solution to this problem...

:mad:

[akanevsky]

Release: Version 1.6.0.

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

(30 minutes later):

Release: Version 1.6.1.

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

[vitrag24]

available for vb 3.7.1?

[akanevsky]

This hack works on all vBulletin version from 3.5.x through 3.8.x.

[BadgerDog]

Is download file faulty?

I get a fail to UNZIP type error?

Thanks... :)

Regards,
Badger

[akanevsky]

Is download file faulty?

I get a fail to UNZIP type error?

Thanks... :)

Regards,
Badger

It's not, please try a different zip utility such as 7-zip.