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

[akanevsky]

The pages are too small to duplicate the navigation.

[lucky64]

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

Thanks, all I did was add the cron and it works, no new product update needed.

[nitro]

The pages are too small to duplicate the navigation.
Well it would be better to just have the navigation at the top then as any amount of scrolling to get to navigation is bad in the eyes of professional web design and I have to scroll as I am almost allways in 1280 res, which isnt far out of average most likely. Simple enough to do either just top or both navigation anyway, apart from that its a nice hack and it works fine except the screen res in 3.6, look forward to an update sometime for that but its good enough without screen info till then. :)

[akanevsky]

Feel free to customize templates to fit your needs.

[lucky64]

Still loving this, I am however still hoping some tweaks come :)

It isn't very accurate as far as browser versions. It doesn't detect FF 2.0 it seems.

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

I just mean a option to turn it off, or to enable a seperate section just showing the browser types not the versions, like Opera, IE and Firefox etc, not FF 1.5.whatever, if that makes any sense.

And I seem to have a large number of 'unknown' os's, which maybe is it not detecting versions again?

Great job though :D

[Phooey]

Any chance of there being a 3.6 release of this soon? :D

[akanevsky]

Any chance of there being a 3.6 release of this soon? :D
Read my signature. The answer is no, but if I have time - yes... I don't expect to have a great lot of time this year.

[nerofix]

Hi Anthony, great idea and work .. just .. i also got a blank page after installing the mod step by step, admin menus etc are okay, just when calling the psistats.php there is nothing shown as just a white page..

Any Ideas?

[akanevsky]

Thanks for the feedback..

Are you running vBulletin 3.5 or 3.6?
In either case, can you look in error.log right after you see blank page to find out what the error is? Thanks.

[nerofix]

Thx for your answer Anthony.

We are running a vBulletin 3.5.4 board.

By the way, the error.log i should take a look, where is it located? .. in the admin cp logs there is nothing about psistats (except of the psistats updated message every hour).

The referrals sites statistik in admin cp works.. just the psistats.php which should be pubic to everyone at the moment shows a blank page.

Wanna take a look? (http://forum.gamesserver.net/psistats.php)

I really have no clue about yet, would be sad if i can't get it working because i like the idea x)

[akanevsky]

By the way, the error.log i should take a look, where is it located? .. in the admin cp logs there is nothing about psistats (except of the psistats updated message every hour).

Login to your site via ftp, it should be in your vbulletin folder.

[Phooey]

Read my signature. The answer is no, but if I have time - yes... I don't expect to have a great lot of time this year.
No sweat. It's still a great hack for 3.5.X. If you get the time to port it to 3.6.X that'd be awesome, but in the mean time beggars can't be choosers. ;)

[akanevsky]

:banana: UPDATE 1.4.0 :banana:

To upgrade, simply overwrite the files from under upload directory and then reload product xml. It's as simple as that.

If you want to reset your browser stats (the system now tracks no more than the major and minor version, and X.Y.Z.W is limited to X.Y), run this query:

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

[interfx]

Installed on VB 3.6.1.... Works great!!!!

[akanevsky]

Installed on VB 3.6.1.... Works great!!!!

You should click install the in the 3.6.1 thread of this hack. :)

[Olly_K]

do the stats include things like hits, etc ?

[akanevsky]

The stats included by the hack are listed in the first post.

[Olly_K]

that'll be a no then, shame, unless I'd defiantely use this.
Looks like a great deal of work has gone into this !

[PoetJA-1975]

Hey PSIONIC - AWESOME hack - I'm very excited about this one! Thanx for making it available for us!

I do have a concern though - I do believe I followed the install directions to the letter. With my vB 3.5.4 Display Colors & Resolutions, Countries & Regions, Browsers & Operating Systems AND Referring Sites is turning up no results at all.

One thing is that with the navbar template edit .... I have a custom header on my forums - so I applied that edit to header template instead... Since it's just the link to the PsiStats - it doesn't seem like that would make any difference though.

At anyrate - I have PsiStats available for only ADMIN & Mods - Is there something that I'm missing? HELP!

Thanx in advance - And again = excellent work on this hack - especially considering you're like 16 - right?!? Very impressive!

Jacquii.

[akanevsky]

Hey PSIONIC - AWESOME hack - I'm very excited about this one! Thanx for making it available for us!

I do have a concern though - I do believe I followed the install directions to the letter. With my vB 3.5.4 Display Colors & Resolutions, Countries & Regions, Browsers & Operating Systems AND Referring Sites is turning up no results at all.

One thing is that with the navbar template edit .... I have a custom header on my forums - so I applied that edit to header template instead... Since it's just the link to the PsiStats - it doesn't seem like that would make any difference though.

At anyrate - I have PsiStats available for only ADMIN & Mods - Is there something that I'm missing? HELP!

Thanx in advance - And again = excellent work on this hack - especially considering you're like 16 - right?!? Very impressive!

Jacquii.

vBulletin Options -> psiStats 2006 -> Usergroups Allowed To View Statistics :)

As for empty sections, please allow 15 minutes for the cron to run and actually update them (it does say that the statistics are only updated once in 15 minutes in the description). :)

[PoetJA-1975]

hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

[akanevsky]

hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

Hmm, it should have been added. The is_newer_version() function of vBulletin seems to be buggy though... Anyway, please run the following query to create the cron:

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)')

[PoetJA-1975]

Well - I did the query and the cron updates - But I've seen numerous DB errors:

Database error in vBulletin 3.5.4:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user '********' to database '*******'
Error Number : 1044
Date : Sunday, October 8th 2006 @ 10:34:41 PM
Script : http://jpicforum.info/cron.php?&rand=39200
Referrer : http://jpicforum.info/search.php?searchid=3347
IP Address : ************
Username : Unregistered
Classname : vB_Database

I actually have spent the last hour or so reading this entire thread. Seems others have had similar probs and one of the solutions was to comment out a line in ...includes/functions_cron.php

$vbulletin->db->close();

In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???

At anyrate - I'd love to have this working for my board, as it is a fabulous idea and could really help me in future promotional activities!

So HELP! And if you call me a dummy - I'm actually inclined to nod my head in a gesture of YEP lol - Don't know much about the coding thing - But seriously - would love to have this one working ;)

Thanx again for providing such a wonderful addition - Just want it working properly!

Jacquii.

[akanevsky]

In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?

Please read the FAQ post, 2nd in this thread. :)

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???

Different IP - People have different IPs.
Different Username - People have different Usernames, too. It doesn't only happen for you.

[PoetJA-1975]

OH - But I think I'm special ;)
OK OK OK - I suppose I will contact my webhost about the lock table DB error.
At anyrate - thanx for not cursing me out and adding to your ignore list LOL
I will let you know the status when I hear back from my webhost - Thanx for taking the time to remind me about the faq :P

Jacquii.

[PoetJA-1975]

Hey PSIONIC - thanx very much! It's working 100% now and is an AWESOME addition to JPiC!

Really nice work - cheers!

Jacquii.

[jwashburn]

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!


I have the exact same problem and the table are gone completley. I have tried making them by hand with no luck. I have tried the diable hooks plan, but then I get new errors. I still cant get into my admincp to fix it.

I am down for 2 days now.

Any ideas on how to get it out

[akanevsky]

I cannot help unless you post the specific error message that you are seeing.

[akanevsky]

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

[JohnBee]

What is the Human Referer option(link) in the Stats selections?
Whenever I click on it I get an invalid page. I installed the Human Referer Hack but it did not change the outcome.

[akanevsky]

You define that link in admincp options...

[akanevsky]

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

[akanevsky]

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

See changelog for details.
To upgrade:

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

[akanevsky]

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

[akanevsky]

You guys are gonna kill me, but...

:banana: RELEASE 1.4.3! :banana:

[akanevsky]

If you downloaded the package prior to this post, please re-download and overwrite the product XML with the latest one.

[akanevsky]

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

[Chirag patel]

I'm keep getting this error:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user: Access denied for user: 'myusername@localhost' to database 'vbforum'

How can I resolve it?

[akanevsky]

I'm keep getting this error:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user: Access denied for user: 'myusername@localhost' to database 'vbforum'

How can I resolve it?

You must allow LOCK permission for MySQL user.

[Ziki]

You guys are gonna kill me, but...

:banana: RELEASE 1.4.3! :banana:


What's new?

[akanevsky]

What's new?

Please see first post - there is a changelog.

[Ziki]

And no, I don't think you code 24/7

Psionic has a life and he is not required to code.And with people like you I wouldn't even like to do that

I personally do not need a teenager telling me to calm down or threats of adding me to ignore list. Advice, concentrate and focus your engergy on fixing your releases rather than worrying about getting a moderator to delete unanswered posts OR telling people to calm down with threats of ignoring. I don't know who you think you are with statements like that. I can see your immaturity shining here. Uninstalls

I don't see what is the problem with his age.He did more than you did and I believe he will achieve more than you.I think you are the one being immature.Psionic is being rational.

Rome was not built in a day, but it was built.
Bob

Pretty much yes you are right

================================================== ====
Yes I just realized that there is one :p

and I believe you want to delete the executionorder column from the plugins so it works both on 3.5 and 3.6 :)

[akanevsky]

Psionic has a life and he is not required to code.And with people like you I wouldn't even like to do that



I don't see what is the problem with his age.He did more than you did and I believe he will achieve more than you.I think you are the one being immature.Psionic is being rational.



Pretty much yes you are right

================================================== ====
Yes I just realized that there is one :p

and I believe you want to delete the executionorder column from the plugins so it works both on 3.5 and 3.6 :)

What happened, why you replying to old posts? :confused: But thanks. :)

and I believe you want to delete the executionorder column from the plugins so it works both on 3.5 and 3.6

Yep, you are right. I normally do that, but sometimes forget.

[Ziki]

What happened, why you replying to old posts? But thanks.

Well I was about to jump to the last page but I somehow bumped into them :p

[Ziki]

2 errors I found.

1.No images for XML and js feeds

2.When trying to view a XML feed: Fatal error: Cannot instantiate non-existent class: vb_xml_builder in /psistats.php on line 777

[akanevsky]

1.No images for XML and js feeds

Huh? There are images in the archive. What's the problem?

2.When trying to view a XML feed: Fatal error: Cannot instantiate non-existent class: vb_xml_builder in /psistats.php on line 777

Oh, damn. I forgot that there is no vB_XML_Builder class in 3.5. I'll fix that.

[Ziki]

Huh? There are images in the archive. What's the problem?

Well I somehow can't see the images

[akanevsky]

Make sure to place them under the right style...

[Ziki]

Oh yeah good point sorry :p

[Ziki]

Psionic where did the activity levek go?It was great

[akanevsky]

Psionic where did the activity levek go?It was great

You need to turn this on for the forum. The same settings as the activity on homepage.

[Ziki]

Please could you make it separate because active members on homepage has no use for me and on the psistats page it was great.Also I think you should implement a top member(posts) and such usual things.

[akanevsky]

Please could you make it separate because active members on homepage has no use for me and on the psistats page it was great.Also I think you should implement a top member(posts) and such usual things.

So then just edit the forumhome template. :)

[Ziki]

When I do that it doesn't show the active.Just Active: | Non Active: 205 | Activity: 0%

[akanevsky]

When I do that it doesn't show the active.Just Active: | Non Active: 205 | Activity: 0%

No.... Enable it for the forum, but then edit the part of the FORUMHOME template that actually displays the number.

[Ziki]

I did that....nvm I actually don't need it that much.But it could be made separate so we don't have to have it on FORUMHOME :)

[akanevsky]

I did that....nvm I actually don't need it that much.But it could be made separate so we don't have to have it on FORUMHOME :)

Ziki, you don't have to have it on FORUMHOME. However, turning it on for the whole forum is required so that it would be cached in vBulletin User Stats. Otherwise, the psiStats homepage will require much more processing time.

[Ziki]

Dude!I don't want to have it on forumhome.I disabled it and removed the variable from the template.But when I did that the stats disappeared!

[akanevsky]

Dude!I don't want to have it on forumhome.I disabled it and removed the variable from the template.But when I did that the stats disappeared!

That's exactly what I'm saying:
a) You need it turned on in settings, which makes it show on forumhome.
b) Since you don't want it on forumhome, you don't have to have it. Just edit the forumhome template. But keep it turned on in settings.

[Ziki]

And that's what I am saying,that's what I did and the active stats don't show up.THe phrases do but no numbers

[akanevsky]

And that's what I am saying,that's what I did and the active stats don't show up.THe phrases do but no numbers

That would only occur if it is not turned on in vbulletin options.

[Ziki]

Anthony we both know it is irrational but that's the truth.It shows up but no numbers are being displayed

[akanevsky]

Can you send me your ftp/admincp details via pm please thanks?

[Ziki]

Uh no :p .No nvm I don't really need it ,it was just a report

[akanevsky]

Uh no :p .No nvm I don't really need it ,it was just a report

The problem is that it works correctly on my installation. But yeah, don't send me your details if you don't need it fixed. I'm just offering my services...

[Ziki]

I am just too paranoic to do that.Anyways I can fix it myself :p

[PoetJA-1975]

I had this installed on 3.5.4 - Recently upgraded to 3.6.4
This issue has been asked - but I think no resolution has been offered.
I'd love to get this functioning properly.

Issue:


Display Colors & Resolutions
Countries & Regions
Browsers & Operating Systems
Referring Sites


NONE showing up!

I've tried fresh install... Fresh uploading of files... Lock tables permissions granted...
Don't know what to do = Help please!

Jacquii.

[akanevsky]

Go over the instructions and make sure everything is done correctly.

[PoetJA-1975]

Go over the instructions and make sure everything is done correctly.

I have.... 3 times :confused:

Jacquii.

[akanevsky]

I have.... 3 times :confused:

Jacquii.

Then maybe you need to revert some templates after upgrading to 3.6. Esspecially templates like headinclude and header. Then reapply the modifications for those templates.

[PoetJA-1975]

Then maybe you need to revert some templates after upgrading to 3.6. Esspecially templates like headinclude and header. Then reapply the modifications for those templates.

nope! seems like the cron isn't working...
Anyway - uninstalled!

Jacquii.

[akanevsky]

nope! seems like the cron isn't working...
Anyway - uninstalled!

Jacquii.

Ok.

[SirFlash]

Question:

Does psiStats detect the Windows Vista OS from the list of detected OS's, or will it show up as 'unknown'?

Thanks in advance - terrific mod!

[akanevsky]

Question:

Does psiStats detect the Windows Vista OS from the list of detected OS's, or will it show up as 'unknown'?

Thanks in advance - terrific mod!

No, Vista will not be detected yet.

[Ziki]

Funny it detects windows vista on my board :-\

[karabalsagun]

Yep, it detects windows vista ;)

[akanevsky]

Yea, it does. I just checked, turns out I actually placed Windows Vista into the OS database even before Vista came out. Thought I didn't, heh.

[S@NL - BlackBik]

To whom it may concern: Dutch language phrase for this great hack :)

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