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

[akanevsky]

@MPDev Yorixz, Thank you :)

@MPDev:
The changes you introduced are not correct. Please look at the following two lines:

$deletions[] = "(`cdata` = '$ident[1]' AND `count` = '$data[0]' AND `ctype` = '$ident[0]' AND `cmisc` = '$data[2]')";
$insertions[] = "('$ident[1]', '" . ($data[0] + $data[1]) . "', '$ident[0]', '$data[2]')";

$data[0]+$data[1] is where the old count is added to the new count.

[akanevsky]

I was referring to your response! I used to drive coaches professionally for almost 35 years and if I spent my time throwing my toys out the pram at some of the stupid/silly/annoying comments from my passengers I would have been driving an empty coach all that time.
Relax, take it all with a pinch of salt. Of course you are going to get frustrating little tic-turds pestering you all the time, but thats life! Learn to live with it without embarrassing yourself.

And I was referring to you pointing a finger at yourself :)
I'm sorry, son, but you are not in a position to preach anything to anyone around here.
You have been added to my ignore list.

[gothicuser]

Never mind, you carry on the way you do, the rest of the world will carry on ignoring you!

[MPDev]

@MPDev:
The changes you introduced are not correct. Please look at the following two lines:

$deletions[] = "(`cdata` = '$ident[1]' AND `count` = '$data[0]' AND `ctype` = '$ident[0]' AND `cmisc` = '$data[2]')";
$insertions[] = "('$ident[1]', '" . ($data[0] + $data[1]) . "', '$ident[0]', '$data[2]')";

$data[0]+$data[1] is where the old count is added to the new count.

I believe you are incorrect - the reason is, as I pointed out for example, there are multiple US lines being printed; so for every US line, it overwrites the "old" value with a "new" value without taking into consideration that the results need to be cumulative during processing. In other words $data[1] needs to be a sum of all the results returned and not just the last result processed.

After alot of testing on my very busy site, I believe they are correct.

[akanevsky]

I believe you are incorrect - the reason is, as I pointed out for example, there are multiple US lines being printed; so for every US line, it overwrites the "old" value with a "new" value without taking into consideration that the results need to be cumulative during processing. In other words $data[1] needs to be a sum of all the results returned and not just the last result processed.

Hmm... Yes. I see what you mean now. :)
However, the initial query is supposed to group the results and there should be only one single row per value... And there should not be more than one row per value in cache anyway. Let me check it...

[akanevsky]

Yup, the query on my table gives the following results:


count ctype cdata
2 country 19x.12x.5x.25x
1 country 213.6.250.24x
1 country 24.18x.34.5x
1 country 8x.201.64.9x
2 country 84.17x.214.16x
2 country 87.24x.1x.1
1 referrer yandex.ru
2 useragent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
3 useragent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
1 useragent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MRA 4.1 (build 00975))
1 useragent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MRA 4.1 (build 00975); .NET CLR 1.1.4322)
2 useragent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MyIE2; MRA 4.3 (build 01218))

As you can see, there are no two same rows, so there should not be a need to count it twice.

[MPDev]

Look closer at your data.

MSIE 6.0; Windows NT 5.1

$updatecache["browser_||_$browser[bstring]"] = array($existingcache["browser_||_$browser[bstring]"]['count'], $itemcnt, $existingcache["browser_||_$browser[bstring]"]['cmisc']);

Given your example with multiple MSIE 6.0 entries, how does your code keep a cumulation of those entries?

You do not resolve your IP addresses to countries until you process the cache. So, again, where are your results cumulative for, say, US based IP addresses as you process your cache? (Again, looking at the data I posted, you can see how you only account for a single US ip address per cache processing versus the sum of all US based ips.

[akanevsky]

So are you saying that there can be two same entries with the same sessionid?

Given your example with multiple MSIE 6.0 entries, how does your code keep a cumulation of those entries?

Oh. Now I am convinced :) Will implement your fix.

[MPDev]

As I just edited, same goes for IP addresses (as everything else); since you post process country codes you do not track the cumulative totals for country results; you only process the last entry (which is most likely only 1).

$updatecache["country_||_$coucode"] = array($existingcache["country_||_$coucode"]['count'], $item['count'], $existingcache["country_||_$coucode"]['cmisc']);

country_||_US will be processed hundreds of times, but since you don't increment the results, only the last record processed is every recorded.

[MPDev]

Just as an FYI, because of the ip include scripts; larger sites like mine will need to process their cache with much more frequency than 1 hour or the memory requirements can be HUGE. (I had 15,000 records and not even 999MB of memory allocation would allow me to process it).

I'm a total data-junkie and love stuff like this - I hope you don't mind me picking it apart and finding this stuff because I want as accurate of results as possible; this kind of info is very important to advertisers and webmasters who really want to understand who is using their sites.

I'll probably add a referrer tracker to this because I really want to track actual links into my site from external sources.

[akanevsky]

So should I switch to a mysql-based IP database? Or just store the IP database in a single file? Or just make the cron run with 15 minute intervals?

Which would be most efficient?

[MPDev]

My concern there would be the number of queries needed during the execution of the script - it could add hundreds of queries during processing. I'm not sure if it helps, but I added a "unset($ranges);" after the loop where it is used to try and minimize the amount of memory being used.

I don't think a DB solution would be "better"; but will let you know if I find something better than the unset().

[akanevsky]

What about putting everything into one file?
All IP files together are worth 2.47MB on disk...

[MPDev]

I don't know about that; it all seems relative to how many records you have to process. I'm not sure I'd want to read in a 2.5mb array everytime, but I'm not sure that I'm not doing that anyways based on all the traffic I get.

[sidekick]

is there anyway i can remove the MEMBER STATS from the general statistics thing ? like i dont want it to show the first thing, abt activity and all

anyways nice hack, thanks

[bashy]

Hi Psionic

not used the admincp Referring Sites Statistics for some time now
and just decided to take a look at it and it gave me this error, Any
ideas please?

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT *
FROM psistats_referrer
ORDER BY referrer;

MySQL Error : Table 'web18_4rum.psistats_referrer' doesn't exist
Error Number : 1146
Date : Saturday, January 14th 2006 @ 11:58:37 PM
Script : http://www.bashys-place.com/forums/admincp/psistats_admin.php
Referrer : http://www.bashys-place.com/forums/admincp/index.php?do=nav

[akanevsky]

@sidekick,
You edit the PSISTATS_HOME template and take out whatever you don't want to show up.

@bashy,
Make sure you upload the latest version of psistats_admin.php...

[bashy]

Thanks Psionic...
Not sure how i missed that 1 (no comments please :p)

All sorted again thanks :)


@bashy,
Make sure you upload the latest version of psistats_admin.php...

[Club3G]

Quick question, should I be concerned about the performance overhead of this? I love the hack, but via webstats:

Top 30 of 926 Total URLs

# Hits KBytes URL
1 38294 4.31% 287139 5.80% /forum/image.php
2 37135 4.18% 1094015 22.09% /forum/showthread.php
3 32810 3.69% 334297 6.75% /forum/psistats.php

It's #3 on my usage list. I've had it installed for less than a week, and that's a stats snapshot of the same time period. It's not linked anywhere on my forums, I'm the only one that uses it as it takes a bit to load and slows my site down a touch when I hit it.

[akanevsky]

:banana: UPDATE 1.3.2 :banana:

1. Revert every single template created by this hack (if modified).
2. Overwrite product XML.
3. Overwrite ./psistats.php, ./includes/cron/psistats_update.php, ./includes/psistats/database_agent.php
4. Re-do template change for headinclude

[iWonder]

Can I make it viewable only to admins/mods or certain categories ? and also I was expecting the referers to be more specific, like the searches from google. It only shows google.com or the domain from where the referal came :( .

[akanevsky]

<font size="4">FAQ POST CREATED!</font>

[bashy]

Update done

I think its all working ok...
Gonna do a thorough check now..

EDIT: All is OK well done :)

Thanks Psionic :)

:banana: UPDATE 1.3.2 :banana:

1. Revert every single template created by this hack (if modified).
2. Overwrite product XML.
3. Overwrite ./psistats.php, ./includes/cron/psistats_update.php, ./includes/psistats/database_agent.php
4. Re-do template change for headinclude

[4number8]

Thanks alot m8, the update went flawless, everything seems good so far, I will check it in an hour or so and see than, I appreciate all of your releases. :)

[ChurchMedia]

Broke the site :(

I'm getting this error after the upgrade:
MySQL Error : Table 'CMN.psistats_country' doesn't exist

I did an unistall and then reinstall. Any help?

Thanks!

[akanevsky]

@ChurchMedia - Warning: Your question has already been answered in the FAQ post (https://vborg.vbsupport.ru/showpost.php?p=862179&postcount=2).

@4number8 - Why don't you go ahead and click install then?

[ChurchMedia]

Ahh -- that wasn't there a second ago ;)

[S@NL - BlackBik]

Thanks!

Installed the update.
Just had to comment out the lock / unlock database lines again :)
The rest works great. I will monitor the stats for a while.

[Rickie3]

update *installed* thanx for your time and dedication

[akanevsky]

You don't need to uncomment those. Just either download latest copy of vb3.5.3 or fix that bug with the db being closed manually.

[S@NL - BlackBik]

You don't need to uncomment those. Just either download latest copy of vb3.5.3 or fix that bug with the db being closed manually.

Yes, that is what everyone keeps telling me.
But i upgraded to the latest version of vB 3.5.3 and I don't have the line that created the bug and I still get messages about not being authorised to lock/unlock tables. That's why I commented out those lines.
The update seemes to work perfect without those lines. It's the only bug I've found and I'm not sure it's a bug on your side ;)

Thanks again for sticking with us and developing this hack.

[georg1000]

Datenbankfehler in vBulletin 3.5.3:

Invalid SQL:
UNLOCK TABLES;

MySQL-Fehler :
Fehler-Nr. :
Datum : Sunday, January 15th 2006 @ 09:25:24 PM
Skript : http://www.xxxxxxxxxxx//cron.php?&rand=331446
Referrer : http://www.xxxxxxxxxxxxx/showthread.php?t=39
IP-Adresse : 80.108.53.143
Benutzername : Unregistriert
Klassenname : vb_database

Please help me

[S@NL - BlackBik]

The sollution is in this thread.....

[redtailboa]

I am wanting psistats to also track url's for my VBportal pages. (http://www.vbportal.com), is there a easy way to do this? I was thinking of adding this to the P_themeheader template:
<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>

But I am not sure it will work. My board is in /forums and the portal is in /.

[firstrebel]

Well, after a number of issues last week, Psionic said he would fix this hack over the weekend, and he did. Working well.

Thanks for your time.

Bob

[MooMan65]

Great work Psionic! This update solves all of the problems I had. :)

As something extra, I've also never personally liked how the Bots and Unknowns are mixed in amongst the legitimate browsers and operating systems, so I've done a quick modification to my download putting them at the bottom. I'd thought I'd share it if anyone else wants to do it.

NOTE: This works with both numerical sorting and alphabetical sorting, depending on the option you've chosen.

Step 1:
Make the following file edits:

Open: psistats.php

Find:

eval('$browserbit .= "' . fetch_template('psistats_browserbit') . '";');
REPLACE with:

if (substr($browser['browser'], 0, 3) == 'Bot' || $browser['browser'] == 'Unknown')
{
eval('$unbrowserbit .= "' . fetch_template('psistats_browserbit') . '";');
} else {
eval('$browserbit .= "' . fetch_template('psistats_browserbit') . '";');
}
Find:

eval('$osbit .= "' . fetch_template('psistats_osbit') . '";');
REPLACE with:

if ($os['os'] == 'Unknown')
{
eval('$unosbit .= "' . fetch_template('psistats_osbit') . '";');
} else {
eval('$osbit .= "' . fetch_template('psistats_osbit') . '";');
}

Step 2:
Make the following template edits:

Template: PSISTATS_OS

Find:

$browserbit
UNDERNEATH add:

$unbrowserbit
Find:

$osbit
UNDERNEATH add:

$unosbit

That's it! I'm quite new at coding so I apologise if this is not the most effecient way to do this. If you have a better way, please post it here so it benefits all of us. :)

[akanevsky]

That's actually a nice and clean way to do this, although I'm sure it could be done without creating extra variables :) In the next version I'll separate the bots from regular agents.

[GamerJunk.net]

What were the file edits and template edits of the old version? I deleted the stuff from class_core but this still does not update...even after changing the headerinclude

[GamerJunk.net]

Nevermind it all of a sudden started working.....

[georg1000]

The sollution is in this thread.....

If it isn't too much work, could you please give me the link or the number of the posting where I can find the solution? You know, the thread is already quite long....
The problem came up after the last update, it worked fine before.

thanks,
Georg

[akanevsky]

So thread is too long and you want me to re-read it for you?

[MPDev]

Do people really expect solutions to be re-posted over and over again because they are too lazy to skim the thread (or even try search?)?

Come on people....

[tendo]

^^ yeah that is pretty lame

I have one question thats related to this hack and more...

Do 3.5.2 hacks work on 3.5.3?

[akanevsky]

That is another questions that has been answered many times.

[tendo]

oh.... ok i'll just go read twenty pages real quick

a simple yes or no would have been easier for you to type. :P

i may be nubbing on this tip but im catchin up quick and trying to RTFM, the F'ing M just hasnt answered all my questions yet.

For instance, I cannot for the life of me figure out why if you quote a post and say something, and someone else quotes your quoted quote, the original quote dissapears.

How the hell do you search for that lol :)

Peace and respekt!

[vau7]

Hey vB-Admin why dont u use the "search tis thread"-Function?

[akanevsky]

This is certainly not a place to ask that question (just like your previous one). Another offtopic post and you'll get straight into my ignore list.

[georg1000]

Do people really expect solutions to be re-posted over and over again because they are too lazy to skim the thread (or even try search?)?

Come on people....


Hello my friend,
I hope your german is as perfect as my english. I think the hack of Psionic Vision is great, but my school-english and my php - abilities are quite limited. So I think that your comment was more than unfair.
If this hack has been intended just for pros, and you feel annoyed by the questions of a beginner, please make a note in the instructions for the hack.

I didn't want to bother anyone with searching the correct posting for me, but if someone knew the right passage in the text, he/she coud have given me a hint.

Just for info: I found the posting and now, after changing functions_cron.php, it works.

Sch?nen Abend und noch viel Erfolg mit diesem Hack
Georg

[akanevsky]

Hello my friend,
I hope your german is as perfect as my english. I think the hack of Psionic Vision is great, but my school-english and my php - abilities are quite limited. So I think that your comment was more than unfair.
If this hack has been intended just for pros, and you feel annoyed by the questions of a beginner, please make a note in the instructions for the hack.

I didn't want to bother anyone with searching the correct posting for me, but if someone knew the right passage in the text, he/she coud have given me a hint.

Just for info: I found the posting and now, after changing functions_cron.php, it works.

Sch?nen Abend und noch viel Erfolg mit diesem Hack
Georg

It does ask not to re-ask the same question over and over in the second post. And no, this hack is not just for pros.

[tendo]

I'm not sure just how stupid this question is. I installed your hack and everything went perfectly ! I read the instructions and followed them to the letter! Everything went fine, no errors.

My question is (and yes I read the manual), once I've added your Product in the Project Manager, do I have to add it in the "Add New Plugin" also

This thing:
https://vborg.vbsupport.ru/external/2006/01/1.png

And if so, I have no idea what the code should be. Maybe you should include that in the readme?

[Rickie3]

its a product not a plugin,go to your admincp/manage products/ scroll to the bottom and click [Add/Import Product] click browse and find the product-psistats xml then click import

[akanevsky]

@tendo,
http://www.vbulletin.com/docs/html/plugin_system

[misuse]

Uninstalled this hack. It worked fine for 3 days then went haywire. php-cgi started loading up 60-70 at a time, cpu's started running hot, my whole site started running very slow. I did have a shoutbox installed and it wouldn't even load when I had this hack installed. 1/2 of the features of the stat program did not work. Yes I read all the pages on this hack. No I will not EVER install this mod again.

This is the first hack I have uninstalled in 2006.

Hint Change the admin email address in the config.php before you do anything with uninstalling this mod. 17,000+ error messages spammed instantly to my email when I "uninstalled" this product. MAKE SURE TO delete the psistats.php or errors will still fly through the email. Clean up the rest of the files that were copied over. Ohhh my server runs sooo smooth once again.

Thanks for the try Anthony K.

[Rickie3]

such negativity, a simple i uninstalled would have be more appropriate,what 1/2 the features didnt work?????? ive had this installed from the time Anthony released this hack and used every update he's released,and must say the last update has been really stable,and all my features are working and have not noticed any changes to my site and is definatley not running slow,"shakes head"

[Lizard King]

such negativity, a simple i uninstalled would have be more appropriate,what 1/2 the features didnt work?????? ive had this installed from the time Anthony released this hack and used every update he's released,and must say the last update has been really stable,and all my features are working and have not noticed any changes to my site and is definatley not running slow,"shakes head"

He gave his opinion and he is totally right. I installed this hack and 15 minutes later i decided to uninstall also because of high cpu usage. When i installed it was dead time on my board (5 am). I cannot comment on features if they are working or not because i didn't want to check it after the high server load.

We all need a good statistics hack for our boards but not this one .

[Loki12]

Getting loads of database errors again...

[rasp187]

This is an excellent hack, I just wish there was a "Lite" version that would just display statistics in text form only, and without the pictures and bars. Overall, a great forum addition, though. Easy installation and no problems as of yet. Great job.

[firstrebel]

This hack is working OK on my server, no extra load at all. I suppose you have to consider that any hack can conflict with other hacks. After all, vB support always tell those with problems to remove all hacks as the first stage of troubleshooting. So maybe it is a bit unfair to blame this hack as the sole cause. There are many possibilities.

Bob

[tendo]

Wow after reading these new responses I'm glad it isn't fully installed. *REMOVES*

[silurius]

I'm sad to say that I must uninstall as well. Was somewhat limited on features to begin with, failed to pull certain types of stats, began generating similar errors to those listed above and I'm concerned that it might not be getting the attention it really deserves. I do like some of your other mods, though, so I'll keep this bookmarked for the time being.

[firstrebel]

Here is the flag for Aruba, add it to your flag directory.

Bob

[S@NL - BlackBik]

Let's post something positive :)

Anthony, this hack is great. We have no problem with serverperformance and since your last update all the stats seem to be OK.
I'm gonna release it to our population :)

And I'll be sure to follow this thread for future developments.
Keep up the good work! Thanks.

Rob.

[Rickie3]

Wow after reading these new responses I'm glad it isn't fully installed. *REMOVES*shouldnt you try it first????? you didnt even fully install it lol,so how will you ever know,if it didnt work for you how hard would it be to uninstall???

[akanevsky]

This is an excellent hack, I just wish there was a "Lite" version that would just display statistics in text form only, and without the pictures and bars. Overall, a great forum addition, though. Easy installation and no problems as of yet. Great job.

Then why don't you click the button? :) As for lite version, see FAQ post.

17,000+ error messages spammed...
Getting loads of database errors again...
Read the FAQ post before you post your concerns. Both of you have been added to the ignore list because you broke the rules of this thread.

We all need a good statistics hack for our boards but not this one.
High server load may only occur because there is something wrong with YOUR board, not this hack. Congratulations, you too have been added to the ignore list. Reason: if you have uninstalled the hack and have not checked out even the latest version(s), you have no valid say, thus please do not intervene with other peoples' business. Thank you.

Here is the flag for Aruba, add it to your flag directory.
Thank you, but what is the abbreviation of Aruba?

@S@NL - BlackBik, @Rickie3
Thanks.

[KayDEE]

nice to see the regions and countries stats got fixed :)

for those ppl complaining about this hack ... we have 3.5.3 running with way above 20+ hacks installed and it runs smooth without any "high" cpu loads or sql erros.

read close and get a bit knowledge of php/sql and vB itself ... (you might be surprised how easy it can be to fix some things yourself, without +++++ing)

[silurius]

Saw the update & thought I'd give it another go. What's the upgrade process? Did not see that in FAQ, initial post or in readme file.

[akanevsky]

Upgrade instructions come with an update. You gotta find the post which came with the last update. I am not doing that for you.

You, however, won't have much trouble finding the last of those posts, because each of the posts contains bananas in them.

[misuse]

Then why don't you click the button? :) As for lite version, see FAQ post.


Read the FAQ post before you post your concerns. Both of you have been added to the ignore list because you broke the rules of this thread.


High server load may only occur because there is something wrong with YOUR board, not this hack. Congratulations, you too have been added to the ignore list. Reason: if you have uninstalled the hack and have not checked out even the latest version(s), you have no valid say, thus please do not intervene with other peoples' business. Thank you.


Thank you, but what is the abbreviation of Aruba?

@S@NL - BlackBik, @Rickie3
Thanks.


Wow. Very mature response. How about taking criticism as a positive to making your product better and more compatable with a wide usergroup. I even gave you a hint. OOOPS I forgot I am on your ignore list.

[Lizard King]

Then why don't you click the button? :) As for lite version, see FAQ post.


Read the FAQ post before you post your concerns. Both of you have been added to the ignore list because you broke the rules of this thread.


High server load may only occur because there is something wrong with YOUR board, not this hack. Congratulations, you too have been added to the ignore list. Reason: if you have uninstalled the hack and have not checked out even the latest version(s), you have no valid say, thus please do not intervene with other peoples' business. Thank you.


Thank you, but what is the abbreviation of Aruba?

@S@NL - BlackBik, @Rickie3
Thanks.

Are you 6 year old ?

[silurius]

Upgrade instructions come with an update. You gotta find the post which came with the last update. I am not doing that for you.

You, however, won't have much trouble finding the last of those posts, because each of the posts contains bananas in them.Nice. I'm curious, have you ever dabbled in Sales? :ermm:

[akanevsky]

Sales? Last time I checked, this hack was free :) You get what you pay for. Say "thanks" that I was nice enough to give this.

[silurius]

Sales? Last time I checked, this hack was free :) You get what you pay for. Say "thanks" that I was nice enough to give this.My sarcasm was actually intended to address the snarky tone. I am quite appreciative, if you really need to know, and have thanked you once already. I'll be sure to thank you again when I upgrade.

[akanevsky]

I'm sure your tone would also be "snarky" if you were in my position. ;)

[bashy]

Hi Psionic..

Just a quicky m8..
I have notices that the WOL shows peeps viewing the Viewing psiStats 2006 even though they have not been anywahere near the stats page, i know this for a fact as it does it to me :)

Admin* Viewing psiStats 2006
1 Minute Ago Bashy Viewing psiStats 2006
3 Minutes Ago cjs130171*+ Viewing psiStats 2006
1 Minute Ago Scrotty Viewing psiStats 2006

any thoughts?

Bashy

[akanevsky]

Eh.... Are you sure you are running the last version? One of the previous versions had such problem, but it was fixed. You shouldn't have the problem if you are up to date.

EDIT: Visited your site, looks like you ARE running latest version. Therefore, make sure that you have cancelled the headinclude template edit from previous version and made the template edit from the new version.

[bashy]

well... erm...Yeah i did update to the latest...BUT
Thinking about it i did upgrade VB the other day, i take it this
has had an effect?

[akanevsky]

Do the following:
1) Revert your headinclude template for each of the skins
2) Apply the headinclude change described in the instructions
3) Re-upload psistats.php

[bashy]

Ok done that..

Seems to be still the same atm, i will see what its liek tomoz once its settled down.....Thanks again Psionc :)

Have a good night :)

Do the following:
1) Revert your headinclude template for each of the skins
2) Apply the headinclude change described in the instructions
3) Re-upload psistats.php

[bashy]

Hi Psionic

Still showing as online on the stats m8, I have now done all that you said...
I thought i'd leave it untill now incase it needed to settle now a tad, but still the same im afraid :(

[akanevsky]

PM me admin access to your board and I'll look at it.

[bashy]

Pm sent m8...thanks alot :)

[akanevsky]

Fixed. The cause was incorrectly updated headinclude template, as I said :)

[Delphiprogrammi]

/me clicked install

nice one i like those checkboxes in the installation instructions

[bashy]

Cheers Psionic...Your a star!" :)
Working fine again....
Although the bot sats are still not 100% accurate, I have had way more in than what yours are displaying....

Fixed. The cause was incorrectly updated headinclude template, as I said :)

[akanevsky]

1) It is 100% accurate with the bots it recognizes, as long as those bots send valid headers.
2) It only counts one hit per 15 minutes.

[silurius]

Update complete, appears to be working fine so far. Thanks, PV. Will report back here when I've let it gather stats that were not showing up before.

[Dez_U]

This works fine apart from one thing.
It slowed my site down something terrible.

[S@NL - BlackBik]

Just wondering if you had any idea why this might be and any suggestions as to how to fix it. It's all working fine, but the stats "home" page takes forever and a day to load up.

I have the same problem.
Maybe we'll have to put an index on some of the fields in some SQL tables.

[akanevsky]

<font size="4">o.O? INDEX? WASSAT??? o.O?? O.O!!!!!</font>

---
For real, there is index on tables already. And it does not run slowly for most of the people here. If you don't want it running slow, then use a normal hosting company that does not use dial up channels....

[S@NL - BlackBik]

LOL.

Well, I just wondered if there was a sort or a query on a field that hasn't normaly an index on it. It doesn't seeme to be the problem if I understand you correct.

I'm afraid it's not my host. We have quit a bit of bandwith and the stupid thing is that I found another board, hosted on the exact same server, that has no performance problem at all (also uses this hack on my recommendation).
Our board has a bit more then 1000 members and the other has about 350 members. Maybe that's the difference.

Don't know yet and it's not such a problem that i'll uninstall or something like that. Like the hack too much :)

[Guest210212002]

It's all sorts of slow for me too, and I'm on dedicated box as well. For that reason, I only allow myself access to it.

[gonon]

It's a good hack. Followed the instructions, installed, worked perfect first time.

Think the beginning of this thread could do with another clean up though ;)

Thanks :)

[silurius]

Still appears to be working great, PV, however "Browsers & Operating Systems" and "Display Colors & Resolutions" do not display anything (as was the case prior to this upgrade). I have been getting traffic and new users, so should I assume that they all have cookies disabled?

[Diggazz]

Hi,

I run the VB Advanced CMPS on the front end

just a couple of questions

1. Fixed this one


2. Does this hack track my VB Advanced CMPS pages?
If it doesnt (and I think this was asked before but an answer maybe missed in all the posts) is there an easy way for me to have these pages included in the stats collection system.

Thanks in advance

Great work btw

[logofreax]

Is it possible to track the whole Refferer Link?

I´ve already read the FAQ that yiu dont change ist, but how can I make this for myself?

cu
logofreax

[interfx]

Thanks for a great mod...
InterFX

[akanevsky]

Q: I have ____ hack and yours isn't working properly with it.
A: I do not provide support for 3rd party hacks.
....

[Gripemaster]

AWESOME!!! *Clicks Install* (And I have no questions...LMAO) :banana:

[Gripemaster]

This is not a MAJOR issue, but I wanted to make it so only admins and supermods can see the stats... I entered their Usergroup ID numbers in the box and registered members can still see them. Have I done something wrong? (Yes, I separated with commas)

[Rickie3]

this is how i set my user group to see,dont put the user group ID in that you dont want to access the stats, see screenshot below that ive allowed viewing of the stats,dont forget to click save

[Gripemaster]

This is not a MAJOR issue, but I wanted to make it so only admins and supermods can see the stats... I entered their Usergroup ID numbers in the box and registered members can still see them. Have I done something wrong? (Yes, I separated with commas)

Nevermind, problem fixed...awesome hack. Thank you :)

[XtremeOffroad]

Thanks Psionic Vision for the update.
It's Great to have all functions working as they should.
Updated without any problems :nervous: :nervous:

[akanevsky]

The slow first page may be looked at sometime, but I am not sure what it could be caused by except for a very large user database. In the latter case, if it be the case, I don't have a solution...

[silurius]

Still appears to be working great, PV, however "Browsers & Operating Systems" and "Display Colors & Resolutions" do not display anything (as was the case prior to this upgrade). I have been getting traffic and new users, so should I assume that they all have cookies disabled?Hey PV. It's been about ten days and I'm still not pulling "Browsers & Operating Systems" and "Display Colors & Resolutions". What should I be looking at first?

[msimplay]

Hey PV. It's been about ten days and I'm still not pulling "Browsers & Operating Systems" and "Display Colors & Resolutions". What should I be looking at first?

Could be firewall some of them block personal info going out

[S@NL - BlackBik]

We have a userdb of 1035 members. That ain't to big, now is it?
And my stats homepage is also loading very slow.

[Kent100]

Классный хак, но что мне делать вот с этим?
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1024 bytes) in /var/www/xxx/forum/includes/functions.php on line 325
Доступа на php.ini у меня нема.
:lick:

[firstrebel]

What do you call slow? Over 30 seconds? I have over 7000 members and it loads in about 5 seconds. Are you on a shared server or dedicated server - what are the server specs...so many other things to consider also.

Bob

[Allan]

Thanks for this hack :)

File attach: French Language ;)

[misuse]

My goodness this hack will not stop plauging me!

February 6th and I've already got.
Required but not found URLs (HTTP code 404)
URL (211)
/forums/psistats.php
Error Hits 321609
Referrers http://www.mysite.com/forums/search.php
/psistats.php -
/gallery/psistats.php http://www.mysite.com/gallery/browseimages.php
Bandwidth 87.9 % 548.64 MB

Same thing last month
Bandwidth 97.8 % 2.56 GB

[akanevsky]

Misuse, just a reminder: you are in my ignore list already. Your post will not get looked at.

Allan,
Thanks, but could you please replace it with language xml file instead?

[silurius]

Could be firewall some of them block personal info going outThanks, msimplay. I do have a pretty small board, but I would expect to see some data.

[akanevsky]

Make sure the cron is present and activated.

[silurius]

Make sure the cron is present and activated.Thanks, that was the prob. Hadn't seen the step listed in the install doc.

[misuse]

Misuse, just a reminder: you are in my ignore list already. Your post will not get looked at.




I don't care about you and the childish attitude.
I was just warning others to watch their stats!

WOW looking further it looks like this program is a trojan! Why does it check in with an outside IP address?

[akanevsky]

silurius,
You are welcome :)
Oh, and firewall has absolutely nothing to do with standard browser properties that are told to every server.

misuse,
I am inclined to think that you are a trojan yourself. ;)

[Rickie3]

WOW looking further it looks like this program is a trojan! Why does it check in with an outside IP address?hahahaaahha that would have to be the best ive heard yet thanx for making me laugh,do you care to back up your claims

[misuse]

I wanted to see if I was really on his ignore list. It worked LOL.

Great hack BTW. Thanks.

[Rickie3]

I wanted to see if I was really on his ignore list. It worked LOL.

Great hack BTW. Thanks.
I don't care about you and the childish attitude.
now who's the childish one?

[akanevsky]

I wanted to see if I was really on his ignore list. It worked LOL.

You are definitely in my ignore list. If you need proof, ask an administrator and they will tell you that your userid is in my ignore list. Nevertheless, there is a "View Post" link on ignored posts. Therefore, if I feel like it, I can still view them. :)

Sorry, but I do not accept "thanks" from people in my ignore list.

[misuse]

Uninstalled.

Both of you are on my ignore list.

[akanevsky]

Haha... That was the expected reaction. Bye :0)

[Bison]

You are definitely a master coder ... I like how you think. You really seem to enjoy what you do ... unlike one of the coders on this forum who think his sh*t doesn't stink, and constantly posting half-cooked beta hacks with no support. Your instructions are high quality and it would take a complete n00b not to understand how to deploy one of your hacks.

Danke!

[silurius]

silurius,
You are welcome :)
Oh, and firewall has absolutely nothing to do with standard browser properties that are told to every server.I myself was skeptical about the firewall idea.

[msimplay]

Just a suggestion that will help users identify common problems would be to list them in the first post of this thread. I'm noticing that the Author doesn't like to answer questions twice obviously on the flipside people don't like to search through long posts.
Thats why my idea makes sense :D

[DR?@M W?@V?R]

The addon works fine for myself. The only problem I have is when the database gets a bit full with stats.

Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to allocate 35 bytes) in /**PATH**/195.php on line 5903

You empty the stats database and it works fine untill it gets up to a limit, what limit I dont know?

[akanevsky]

msimplay,
Second post is an FAQ.

[msimplay]

msimplay,
Second post is an FAQ.

Yep i did see that however it doesn't seem to say about the unlock error.
I had to search a while before i knew what the fix was and everyone that will moved to 3.5.3 will have the error

[akanevsky]

The FAQ was started way after the questions were first answered. I will add the unlock question momentarily.

[silurius]

The FAQ was started way after the questions were first answered. I will add the unlock question momentarily.Just one more thought: perhaps also include specific update details in the second post whenever a new update becomes available? Speaking strictly for myself, whenever I become aware of an update (or want to find info about it) I am faced with a thread-search (update emails do not always arrive in my email inbox).

[akanevsky]

Yes. I might as well do that.

[Red Blaze]

Hey Psi, I'm trying this out for myself here.
I know it spits out new information every 15 minutes, however, is the Countries and Nations page suppose to be completely blank? As in, a white page blank. I'm still waiting on the other stats to see if they collected the data.

I'm sure I did every step correctly. I checked and double checked everything.

EDIT:
Nevermind, I don't want to bother. It's been an hour and nothing updated. It's odd how your add-ons never work on my board while everyone else's add-ons work just fine.

[Symen_4ab]

Great hack there, many thanks !
Quick note, though, most of my users were selecting their own style by using the quick-style chooser (the drop-down list at the bottom of every page of the forum) and not the option in their profile.
I think psistats just checks the setting in the database, not really reflectiong users choices.

I just wrote a quick-fix for this. This is a tiny module which, when activated, writes the style chosen with the qdrop-down list in the database.

create a new module, hook "cache_templates", with the following code

if($vbulletin->userinfo['userid'])
{
if($vbulletin->userinfo['styleid'] != $vbulletin->userinfo['realstyleid'])
{
$tmp1 = $vbulletin->userinfo['styleid'];
$tmp2 = $vbulletin->userinfo['userid'];
$sql = $db->query_first("UPDATE user SET styleid=$tmp1 WHERE userid=$tmp2");
$vbulletin->userinfo['realstyleid'] = $vbulletin->userinfo['styleid'];
}
}


It's crappy dirty code, but it's working ;)


Also, some users are complaining about them not seeing the links for the another stats pages.
They just stay on he main page and never see the browsers stats, countries stats, etc.
I just removed the span class="smallfont" tag in the psi_stats_footer template ;)

[MPDev]

Well, looks like the IP stuff is going to have to go into a database for me - the memory requirements of loading those arrays is just killing my server to where once it starts to fail, the cache table gets to hundreds of thousands of records that can't be processed. Even with 500mb of memory available there are times when it cant process more than 200 records with ip info in them.

Do you have a db conversion of this data?

[akanevsky]

No, but a db conversion would be easy.

[MPDev]

I managed to get around my backlog of 200k records by adding a "no memory limit" line to the cron script. For that that should be okay, but I think that it would be better served as being a query of some sort.

[Snake]

Is this stable to install on my forum now?

[sidekick]

im not sure, but now my WHO IS ONLINE thing doesnt work
this is what it has been showing since ive installed

and nobody was viewing that
https://vborg.vbsupport.ru/

[mholtum]

Installed fine but I cant see stats for:
Display Colors & Resolutions
Countries & Regions
Browsers & Operating Systems
or
Referring Sites

Any Ideas?

[mholtum]

Nevermind figured it out

[Snake]

Will this work on 3.5.3 I wonder?

[Rickie3]

Will this work on 3.5.3 I wonder?from what ive been told "YES"

[Snake]

Ah good good.

[MGM]

Any reason why my style replacements wont work when viewing the Styles stats? See image:

http://www.forevergaming.com/hosted/styles.jpg

EDIT: Image is too big so I just provided the url...

MGM out

[akanevsky]

I don't know, never used replacements...

[MGM]

Well then, any way to fix it :p

MGM out

[akanevsky]

If you find out, tell me. I have no idea what replacements are and what they are for... I'm sure they are an obsolete feature left over from vb 2.

[MGM]

Meh, alright then, I'll look into it a bit... god only knows how many other pieces of code I've fixed from bad coders from here :p

MGM out

[akanevsky]

Well, I do feel compassionate to your god. :)

[eXaulz]

Hey Psionic Vision,

Is there a way for this to also grab the statistics from your forum, site, guest book (examples)? Or can it only grab statistics from your forum?

This'll be a great hack, if, for example, you just have to include a file like 'statistics.php' in the script and it will update all the statistics.

Just my opinions.

[Oblivion Knight]

I'll definately have to take a look at this later (subscribed).. :D

[Holidazed]

What is the "Human Referer" hack you that is mentioned in the ACP options? Can you give me a url to it?

[akanevsky]

See my profile - Referrer Statistics hack.

[Vizionz]

Installed fine but I cant see stats for:
Display Colors & Resolutions
Countries & Regions
Browsers & Operating Systems
or
Referring Sites

Any Ideas?
how didyou figure it out i never got it to work so uninstalled it

[ericgtr]

I can't be sure until I do more digging but I haven't made any modifications other than this one to my board for a long time now. The problem is that upon installing this users are getting logged out on a regular basis, looking at this I am not sure how it can be causiing it but I have pulled it so I can get an idea of the cause. Anyone else ran into this?

[akanevsky]

What makes you think that it is this hack that causes people to get logged out?

[sidekick]

did you upgrade this today ? and dude u didnt reply to my problem that i posted before, see page 27

[ericgtr]

What makes you think that it is this hack that causes people to get logged out?

I was careful not to blame it on this mod however it's the only change I've made to my board in a long time and suddenly people are getting logged out just after installing. I just wanted to confirm that nobody else has had this issue.

[eXaulz]

Hey Psionic Vision,

Is there a way for this to also grab the statistics from your forum, site, guest book (examples)? Or can it only grab statistics from your forum?

This'll be a great hack, if, for example, you just have to include a file like 'statistics.php' in the script and it will update all the statistics.

Just my opinions.

Just incase you missed it.

:ninja:

[ZOban]

I would need except some branch (private forum for moderators) from statistics. How to do that ?

thx for help

[JsnakeJ]

im not sure, but now my WHO IS ONLINE thing doesnt work
this is what it has been showing since ive installed

and nobody was viewing that
http://img9.picsplace.to/img9/7/pcistats.PNG

Please fix this.

[akanevsky]

You have an out of date version.

[Connector]

is the (http://www.club2share.com/forums/)re any chanse to show the sta (http://www.club2share.com/)ts of the remo (http://www.ourbb.org)ved post /thread /user :) (http://www.upload2share.com/)

[DDX]

this is wayyy too buggy sheesh

[akanevsky]

this is wayyy too buggy sheesh

Oh? Is that right? :)

[Wachtmeister]

this is wayyy too buggy sheesh

it works perfect here

[bashy]

same here :)

it works perfect here

[unknownkind]

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

Add this if you only want -- Administrators to See the Added Site Statistics in the Navbar! In replace of the one Psionic has in the Readme file

[TTG]

this is wayyy too buggy sheesh

had NO problems on my forum .. works as designed

[JsnakeJ]

You aware that Whales and Scottland are shown under United Kingdom?

[michaelbenson]

You aware that Whales and Scottland are shown under United Kingdom?
Dont you mean Wales and Scotland?

[firstrebel]

this is wayyy too buggy sheesh

What are the bugs?

Bob

[bashy]

Thats because they are arnt they?

Now if it was England then there would have been sommat to moan about

You aware that Wales and Scotland are shown under United Kingdom?

[JsnakeJ]

Should be seperate in my oppinion.

[lucky64]

Two questions.

Do you have the PSD's available for the images? My board is dark, so I get massive jaggies around the images, I tried editing them but they don't come out very nicely.

Would it be possible to group browser versions together? I have 9 entries for Firefox alone, its a little cluttered.

[akanevsky]

A1: No, I did not make these images and I do not have PSD's available.
A2: Turn off the numerical sorting in psistats settings.

[lucky64]

A1: No, I did not make these images and I do not have PSD's available.
A2: Turn off the numerical sorting in psistats settings.

Thanks for the reply.

However, I did have it off, that's not quite what I ment. I was referring to the fact that it shows;

Firefox 1.0.3
Firefox 1.0.1
Firefox 1.0.6

Its got every version, I think it would be useful to be able to tell the script to group them all together, so it shows one Firefox group with all the versions together, if that makes sense.

This likely isn't posssible without major changes though unfortunately...

Thanks again.

--Lucky

[akanevsky]

Do you want Firefoxes to be aligned by version?

[lucky64]

Do you want Firefoxes to be aligned by version?

No, I mean removing the different versions altogether, or making it an option, so it shows one Firefox, one Opera, one IE and so forth.

For those who want a general % of the people using firefox etc, and not the % for each specific version.

[akanevsky]

I could remove version detection, but I think that it would remove an important bit of information.

[The Realist]

Nice hack M8, just installed and running well.

Laters

[The Realist]

Some country gifs dont show up and under my style usage none of my button and corners within my VB template shows up, but they work in the other options.

Any ideas?

Laters

[BoYagoob]

installed.

[3z3k3l]

Hey I just got up today and found 1500 Messages the first one saying:
"Database error in vBulletin 3.5.4:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('65.19.150.246', 'country', '65.19.150.246_country'), ('OmniExplorer_Bot/6.46 (+http://www.omni-explorer.com) WorldIndexer', 'useragent', '65.19.150.246_useragent');

MySQL Error : Can't find file: 'psistats_cache.MYI' (errno: 2) Error Number : 1017
Date : Tuesday, March 7th 2006 @ 05:47:51 AM
Script : http://www.pbxinfo.com/forums/member.php?u=3827
Referrer :
IP Address : 65.19.150.246
Username : Unregistered
Classname : vb_database"

How do I uninstall manually? My site is down!

Thanks

[3z3k3l]

Hey I just got up today and found 1500 Messages in my inbox all saying:
"Database error in vBulletin 3.5.4:

Invalid SQL:

REPLACE INTO `psistats_cache` (`cdata`, `ctype`, `csid`)
VALUES ('65.19.150.246', 'country', '65.19.150.246_country'), ('OmniExplorer_Bot/6.46 (+http://www.omni-explorer.com) WorldIndexer', 'useragent', '65.19.150.246_useragent');

MySQL Error : Can't find file: 'psistats_cache.MYI' (errno: 2) Error Number : 1017
Date : Tuesday, March 7th 2006 @ 05:48:56 AM
Script : http://www.pbxinfo.com/forums/sendmessage.php?do=mailmember&u=16649
Referrer :
IP Address : 65.19.150.246
Username : Unregistered
Classname : vb_database"

How do I uninstall manually? My site is down!

Thanks


Wow can someone tell me what happened?
I have 1500 email messages from this database error, I logged in via phpmyadmin and empted the table and things seem to be back to normal.
I have made no changes to the site in the past 24-48 hours, it looks like a bot or something messed with the stats somehow.

Will this happen again? Anyone know what happened, thanks!

[akanevsky]

1. put: in your config.php:

define('DISABLE_HOOKS', true);

2. Uninstall product XML.
3. Re-install prodct XML (if desired)

I am not sure what that error of yours is caused by, but it happens very rarely.
So just make sure to remove the plugin to delete the tables and then reinstall it.

[username12]

Got the same error as 3z3k3l. Ended up repairing the table with tools, which worked. Then I tried to uninstall (and did), but then I got errors for not having the table. Had to manually add the table back to get my forums back up. I'd say I like the hack in general, but it does seem to have some issues that need to be worked out.

[akanevsky]

When this happens next time, you just need to check and repair the tables with phpmyadmin or from vbulletin admincp.

The problem is not caused by this hack, I even got this once a standard vbulletin table.... ended up repairing it from phpmyadmin, and then it was alright :)

[username12]

My (eventual) problem was that I couldn't repair the table because I'd uninstalled the hack.

[SMO]

Ok, i read 30 pages of quest/answers and didnt see mine..

1. The header and graphics do not display on "style usage" but do on all the others.

2. The quick link in the nav bar works great when I am in forums but if I am anywhere else (ie gallery) i go to gallery/psistats.php and that doesnt exist..heh.

Any quick fix for this?

I am up to date and re uploaded all new files in .32.
I couldnt find how to revert the psi templates however.

Thanks for this cool hack...kinda fun. :)

[akanevsky]

1. It works fine for me and everyone else so far. Seek problem within your board.
2. You gonna have to configure replacements for whatever 3rd party product you are using. I do not provide help with 3rd party products here.

[DementedMindz]

3z3k3l i had the same problem in the end i had to remove it... all that was happening at the time was he was just putting people on his ignore list... i like the hack but had that problem before thats what is leaning me not to install this again...

[akanevsky]

DementedMindz, you have been added for a well-known reason. Please refrain from posting comments that do not contribute anything to the community. Thank you.

3z3k3l, to avoid getting MYI errors on large boards, try doing Optimize/Repair on your database from time to time.

[DementedMindz]

DementedMindz, you have been added for a well-known reason. Please refrain from posting comments that do not contribute anything to the community. Thank you.

And why is that for asking questions and never getting answers to them or being told its my board? i wasnt downing your hack its a nice hack but that was the only reason i removed it cause there was no answers to that only being told it was my fault or being put on ignore ;)

[akanevsky]

I don't add people to my ignore list because they ask me questions, as that would be nonsense. You, like some other people, have been added to my ignore list for nothing more or less than just being rude. -)

[DementedMindz]

thats funny i wasnt rude one bit..... i was even nice to say your hack is nice but was never rude..... i just simply explained that maybe it aint always the persons boards causing the errors since the same thing has been posted many times and 1.) either you tell them its there boards or 2.) your ignore them.... this is simply all i was stating.... if some people are having problems it would be nicer to try and help them then to get away with it easy and ignore them....

[akanevsky]

Hmm... I just reviewed the thread and couldn't find anything rude in your posts. I must have accidentally added you together with other people or just confused you with someone else ... happens when there are a lot of people that do something like being rude - all at once.

Anyway... I apologize. You've been removed from my ignore list.

[Rickie3]

as a request is it at all possiable to add to stats to show the amount of attachments in the database and the storage space they use??

[akanevsky]

I believe that this is displayed in "Quick Stats" in the homepage of your admincp... As long as "Quick Stats" are turned on.

[Rickie3]

I believe that this is displayed in "Quick Stats" in the homepage of your admincp... As long as "Quick Stats" are turned on.
i would love it to display in your stats hack tho lol:D

[Mr Peabody]

Howdy
Just installed this on two of my forums. One has been going since VB 3.0.1 and upgraded to 3.5.4 recently and the other is fairly new going from 3.5 to 3.5.4.
Now problem is the newer one will display the Style Usage correctly the other only shows everybody on the default skin and all the rest are zero. I've tried uninsalling and reinstalling checking all the FAQ and what not but it does not fix this both forums are set up the same.
Any ideas would be appriciated.
Cheers

[akanevsky]

Howdy
Just installed this on two of my forums. One has been going since VB 3.0.1 and upgraded to 3.5.4 recently and the other is fairly new going from 3.5 to 3.5.4.
Now problem is the newer one will display the Style Usage correctly the other only shows everybody on the default skin and all the rest are zero. I've tried uninsalling and reinstalling checking all the FAQ and what not but it does not fix this both forums are set up the same.
Any ideas would be appriciated.
Cheers

Make sure you have the latest version.

[hitmanuk2k]

Many apologies if this has been asked... but how would one go about placing part of the stats on forum home? I much prefer your way of displaying 'Member Stats', 'Members Online' and 'Forum Stats' and would like to replace this in the What's Going On area of Forum Home.

[akanevsky]

I wouldn't suggest doing that, because these stats do take more queries than the forumhome ones.

[jquan]

Installed without a hitch, perhaps for noobs, on your install page you could add

"and once finished go to http://yourdomain.com/forum/psistats.php to see your new stats"

[akanevsky]

That should actually be obvious from screenshots.

[akanevsky]

Any feature suggestions for this hack?

[Rickie3]

Hi Psionic Vision,I must say your hack is still running perfectly I have not had any problems at all.I still would like this feature tho https://vborg.vbsupport.ru/showpost.php?p=924579&postcount=457
I know its in the adminCP but i would like it in the stats section as well.Plus also maybe a hit counter? cheers keep up the good work.

[hilfe-forum]

Top Hack!

But i can?t use

http://www.hilfe-forum.eu/psistats.php

dont work on big Boards??

[maranello]

I have a problem with this hack. It doesnt show any country or region. Also for the screen resolution, it shows only 1 person, nothing else.

[maranello]

nevermind, should have waited 15 minutes before posting:)

[akanevsky]

nevermind, should have waited 15 minutes before posting:)

Yup. :)

[johnn]

Hi, I just recently installed this hack, and find it pretty cool! My members love it.

Here is my problem:

When it shows staff, it only shows out of 3 usergroups, admin, s-mod, and mods. I actually have more usergroups that are staff, so I went and edited the PHP file to make it find the rest of my staff, and it worked.

What the problem is though, I then figured out that I had to go into the template editor to make it show the individual groups. The problem is, when I have this:

($c[administrators] $vbphrase[psistats_home_admins], $c[smoderators] $vbphrase[psistats_home_smods], $c[amoderators] $vbphrase[psistats_home_amods], $c[moderators] $vbphrase[psistats_home_mods], $c[news_chiefs] $vbphrase[psistats_home_news_chiefs], $c[news_publishers] $vbphrase[psistats_home_news_pubs])

I get this:

https://vborg.vbsupport.ru/

Why are the names not showing up next to the numbers?

[akanevsky]

Hi, I just recently installed this hack, and find it pretty cool! My members love it.

Here is my problem:

When it shows staff, it only shows out of 3 usergroups, admin, s-mod, and mods. I actually have more usergroups that are staff, so I went and edited the PHP file to make it find the rest of my staff, and it worked.

What the problem is though, I then figured out that I had to go into the template editor to make it show the individual groups. The problem is, when I have this:

($c[administrators] $vbphrase[psistats_home_admins], $c[smoderators] $vbphrase[psistats_home_smods], $c[amoderators] $vbphrase[psistats_home_amods], $c[moderators] $vbphrase[psistats_home_mods], $c[news_chiefs] $vbphrase[psistats_home_news_chiefs], $c[news_publishers] $vbphrase[psistats_home_news_pubs])

I get this:

http://i22.photobucket.com/albums/b331/Protodude/problem.jpg

Why are the names not showing up next to the numbers?

First: You do not need to have more than three groups in the script. Administrators are detected by cancontrolpanel permission, supermoderators are detected by ismoderator permission, and moderators are detected by their presence in the moderator table. That'll work with unlimited number of groups, as long as appropriate permissions are set.

Second: Because they are not supposed to show.

[johnn]

First: You do not need to have more than three groups in the script. Administrators are detected by cancontrolpanel permission, supermoderators are detected by ismoderator permission, and moderators are detected by their presence in the moderator table. That'll work with unlimited number of groups, as long as appropriate permissions are set.

Like I said though, when I first installed the hack, it showed only the three groups, which resulted in only showing 7 total staff instead of 15 as shown in the picture. I have more staff that aren't moderators, so they wouldn't be detected in the moderator table anyways. This is why I had to add more groups in the script.


Second: Because they are not supposed to show.

So you are saying that there is no way to make it show? What makes the words admins, s-mods, and mods, show?

Thank you.

[akanevsky]

Oh, the names of the GROUPS?
You just add them into the template. Either as phrases or directly as text.

[johnn]

Oh, the names of the GROUPS?
You just add them into the template. Either as phrases or directly as text.

Lol yes. But now reffer back to what I showed you before! I tried adding them in as $vbphrase (as you see in the coding I posted), but it doesn't seem to work (as you see in my picture that I posted). I guess I could try direct text though...

EDIT: NVM, direct texts works perfect! Thanks for your help. :)

[akanevsky]

If you add vbphrase, you have to add the vbphrase into the right phrasegroup (psistats).

[Snake]

Before I go and install this mod directly, do you plan to release a new version like soon?

[akanevsky]

Nope.

[Snake]

Alrighty then I shall install this hack right way! :)

[Kanustep]

Hi would like to delete all stats from psiStats before July or June, I move the site to another domain this month and want to see the stats using this new domain and fresh forum.

Is it possible to do? How I can do it?

Regards

[akanevsky]

The easiest way would be to uninstall and the to re-install the product XML.

[hilfe-forum]

hmm This Hack dont work with bigger Boards...

http://www.hilfe-forum.eu/psistats.php

[Kanustep]

Thank you.

Another question, why Active Members always difers from vBulletin stats?
How you calculate the active members?

[akanevsky]

hilfe-forum,
not indended to

Kanustep,
people who posted during last month... vB does something else

[davelacey]

Great hack.
Great talent.
Thankyou for sharing it. :)

[hilfe-forum]

hilfe-forum,
not indended to

Kanustep,
people who posted during last month... vB does something else

du you dont think your great Hack on bigger Boards is a good Promotion for you?

is it much work to Create sep. tables in the DB for the data?

[Rickie3]

Hi ive just noticed that when i click on Countries & Regions,and select a country,the site it used to link to has moved https://www.cia.gov/redirects/factbookredirect.html

it is now here https://www.cia.gov/cia/publications/factbook/index.html
is there a fix for this Psionic Vision please

[akanevsky]

Neither of the URLs work for me. :/

[firstrebel]

Has anyone got this working on vB3.6 gold as the headinclude template has changed a lot. This code is not there any more..
<if condition="$vboptions['externalrss']"><link rel="alternate" type="application/rss+xml" title="$vboptions[bbtitle] RSS Feed" href="external.php?type=RSS" /></if>

Bob

[akanevsky]

Just put the INSERT code anywhere between <head></head> tags...

[firstrebel]

Thanks. I added the code to the end of headinclude. All seems OK on my 3.6 dev site with this.

Bob

[ubblite]

Thanks. I added the code to the end of headinclude. All seems OK on my 3.6 dev site with this.

Bob
Not here. The hack was working fine with vb3.5.4 but with 3.6 the only links that show anything are 'general', 'style usage' & 'top threads & forums', everything else is blank.

[akanevsky]

Revert everything that was created by the hack and see if that helps. It works correctly on my vB 3.6 installation.

[ubblite]

Unfortunately, that didn't work. Reverted & re-installed but have the same problem with vb3.6.

[ubblite]

I just finished installing & testing this hack on a test board running off a different database with 3.6 and got the same results as well.

edit: This hack might work if you already have it installed on a previous VB version such as 3.5.4, but it will not work as a fresh install.

Psionic, are you planning on releasing a 3.6 version?

[hypnoticpimp]

Hey, for some reason, i just got this error


Database error in vBulletin 3.5.4:
Invalid SQL:
REPLACE INTO `hypnoticpimp_psistats_cache` (`cdata`, `ctype`, `csid`)

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




I had this mod working for like 1 month, and all of a sudden i get this error
I trued adding the Disable Hooks, on my config, so i can uninstall it and res install it, but when i did, nothing happens, i still get that message

I read on other posts, that can fix i, by reparing tables! my question is on phpadmin there is no Fix table option, and i dont know which table i should fix, or how i fix it, Please help

I even uploaded tools.php to my admin, and i got that page working, and i tried the repair tables tool in there. and i checke don all tables, after it was done, i tried refreshing on forum and still got that error

[akanevsky]

Hey, for some reason, i just got this error





I had this mod working for like 1 month, and all of a sudden i get this error
I trued adding the Disable Hooks, on my config, so i can uninstall it and res install it, but when i did, nothing happens, i still get that message

I read on other posts, that can fix i, by reparing tables! my question is on phpadmin there is no Fix table option, and i dont know which table i should fix, or how i fix it, Please help

I even uploaded tools.php to my admin, and i got that page working, and i tried the repair tables tool in there. and i checke don all tables, after it was done, i tried refreshing on forum and still got that error

You need to repair your database.

[hypnoticpimp]

Hey vision thanks for trying to help, but i just said, How do i repair my tables, and what tables>

[akanevsky]

AdminCP -> Maintenance -> Repair / Optimize Tables / -> Select All -> Choose both repare and optimize -> Run

[hypnoticpimp]

Hey you see thats the problem, I cant login to my admin cp. even if i use that disable hooks, on the config.pgp . I still get that error, and i even tried refreshing, the page a couple of times.

The only thing i can do is use tools.php, but all that has is a repair all tables tools. DOesnt have that optimize tool. But i used the repair all tables on tools.php and still nothing

could you step me through to fixing and optmizing on phpadmin, please

[nitro]

Not here. The hack was working fine with vb3.5.4 but with 3.6 the only links that show anything are 'general', 'style usage' & 'top threads & forums', everything else is blank.
Same for me on 3.6. I thought I would give this one a go a few days after the upgrade, hope theres a 3.6 fix soon. :)

[Rickie3]

I have only tried this on a test board 3.6 and seems to work ok on that for me,havent tried on a live board as i'm still running 3.5. ive also edited the product so it installs on 3.6 'PLEASE USE AT OWN RISK' as i stated ive only tried it on a test board and wont be held responsible for any error it may cause.If you already have this installed you dont need to upload any folders to your server,unless you are doing a fresh install.
1.
In template "HEADINCLUDE" find
<if condition="$vboptions['externalrss']">
<link rel="alternate" type="application/rss+xml" title="$vboptions[bbtitle] RSS Feed" href="external.php?type=RSS2" />
ADD UNDERNEATH
<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>

2. Import the product below,if you already have it installed select overwrite to yes.

now when i did fresh install on 3.6 it did NOT install the cron in sheduled tasks so you might have to add it manually
go to sheduled Tasks
add new sheduled task

Varname=psiStats
Title=psiStats 2006 Hourly update
Description=update psiStats
Day of the Week (Note: this overrides the 'day of the month' option) = *
Day of the Month=*
Hour=*
Minute=25
Active=yes
log enteries=yes
Filename=./includes/cron/psistats_update.php
Product=psiStats 2006
click save,then run the cron manually for the first time.
cheers

[akanevsky]

What exactly did you change in the XML file?
The reason cron did not get installed is because 3.6 has a different format for the cron table.

[nitro]

I just added the cron manually (Thanx for that info, I did wonder if there was suposed to be a cron entry, wonder why I didnt mention there wasnt one incase this was it) and now after running that manually a couple of times all but screen res has data, perhaps a bit more patience now and that one will start to fill aswell. :)

[Rickie3]

What exactly did you change in the XML file?
I simply added this under this code highlighted in green
<product productid="psistats" active="1">
<title>psiStats 2006</title>
<description>Sophisticated forum statistics for your vBulletin board.</description>
<version>1.3.2</version>
<dependencies>
</dependencies>


<codes>
<code version="1.3.2">
<installcode><![CDATA[$db->hide_errors();
then found all instances of
<plugin active="1">
and changed to
<plugin active="1" executionorder="5">

then i added this
</settinggroup>
</options>
<helptopics>
</helptopics>
<faqentries>
</faqentries>


</product>

[akanevsky]

Rickie3
Empty entries are not required though :) The only problem with running this script on 3.6 is the cron and the modified template with javascript...

[Rickie3]

oh well i was only trying:)

[nitro]

With the cron added and the headinclude edit changed I'm still getting nothing in "Display Colors & Resolutions" but everythiung else appears to be filling up fine on 3.6.0 gold.

Also small tip, the navigation maybe better at both the top and bottom of the pages as some of them can get a bit bigger, ye lazy I know but its nice to have it at both ends and not hard to acheive. ;)