vb.org Archive - psiStats 2006 (The New vBStats for vBulletin 3.5.x

Page 3 of 15

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=104213)

akanevsky

01-07-2006 07:06 PM

You fotgot to cancel file changes for class_core.

bashy

01-07-2006 07:08 PM

Please can you let me know what they were as i over wrote you original zip :o

Dont matter i just searched your name and deleted all of the edit :)
i take it this is waht you meant?
Cheers

Bashy

akanevsky

01-07-2006 07:35 PM

Quote:

Dont matter i just searched your name and deleted all of the edit
i take it this is waht you meant?

Yes. Heh, I wrap all my file edits with a comment block that contains my name, so that it is easy to find them :)

bashy

01-07-2006 07:56 PM

Yeah tis a very good idea that m8, it made it really easy for me to find your edits :)

Still awaiting for my bots to show a little more action before i can report anything concrete, but so far eveerything elses is hunky dory, thanks Psionic

Regards

Bashy

bashy

01-07-2006 08:53 PM

Hi Psionic :)

erm, i got mr MSN bot in my forum atm.....
Still, your erm, stats dont record him lol

8 Minutes Ago MSNBot Spider Viewing Index
Bashy's Place

Strange really, cause the Spider stats that i said i ahev installed records it with no problems as does the crawler block that i use as well....

Oh well, perhaps it's just not meant to be lol :ermm:

Regards

Bashy

ForYou

01-07-2006 08:53 PM

Hello ,

I was installed the hack with out any problem but there is no stats for ,
Countries & Regions | Browsers & Operating Systems | Referring Sites

there is no countries and no Referring sites ,

Please what can i do to see the stats of the countries and Browser and Referring ,

Regards

firstrebel

01-07-2006 09:05 PM

The stats build up as people visit the board, how long ago did you install?

Bob

akanevsky

01-07-2006 09:08 PM

Quote:

Originally Posted by bashy

The googlebot is working, checked. I'll check msn too. It should be working now though...

Quote:

ForYou

Statistics are updated once per hour. They also build up with time after you install the hack.. Patience, and it'll be ok ;)

firstrebel

01-07-2006 09:30 PM

I totally removed 1.2.7 and reverted all templates and files, then installed 1.3.0. Got this error now:

Quote:

Invalid SQL:
TRUNCATE TABLE `psistats_cache`;

MySQL Error : Table 'vb_forum.psistats_cache' doesn't exist
Error Number : 1146
Date : Saturday, January 7th 2006 @ 11:25:21 PM
Script : http://www.volvoclub.org.uk/forum/cron.php?&rand=620968
Referrer : http://www.volvoclub.org.uk/forum/forumdisplay.php?f=14

Bob

Replicators

01-07-2006 09:34 PM

I never seem to get stats for "Display Colors & Resolutions" but everything else works fine. Except it now don't recognize firefox browser's for some reason.

akanevsky

01-07-2006 09:46 PM

Quote:

I totally removed 1.2.7 and reverted all templates and files, then installed 1.3.0. Got this error now:

You need to make sure that you have installed the product XML.

Quote:

I never seem to get stats for "Display Colors & Resolutions" but everything else works fine. Except it now don't recognize firefox browser's for some reason.

If it recognize Firefox before, it will recognize Firefox now.
Keep in mind that stats are now updated once per hour, rather than immediately

firstrebel

01-07-2006 09:50 PM

The product is installed correctly, also my server load is high at times since I installed this with CPU utilisation up to 80% at times:

Quote:

1.93 1.59 1.39

Bob

akanevsky

01-07-2006 09:53 PM

Quote:

1.93 1.59 1.39

How is that high? Are you hinting that it is caused by this hack? If so - nope. Stats are only updated once an hour, and that's when you might experience a lil bit more load. But it's alright...

firstrebel

01-07-2006 10:05 PM

Not sure what's going on, but to check I totally removed this and server load is back down with CPU not getting much above 8%. I will reinstall in the morning and see what happens, it's late over here now.

Bob

silurius

01-07-2006 10:55 PM

Works beautifully (*tip*). Looks like most data (except for "Top Threads & Forums") needs to be gathered somehow before it will actually get displayed?

msimplay

01-07-2006 10:56 PM

whose online seems to have a bug where all my users are for some reason always on the psistats page

bashy

01-07-2006 10:58 PM

Hi Psionic...

What would be the easyist way to add extra bots...
I think i have found one of the unknown bots by following the IP addy.

So how would i add this m8 please?

Regards

Bashy

akanevsky

01-07-2006 11:09 PM

Quote:

Works beautifully. Looks like most data (except for "Top Threads & Forums") needs to be gathered somehow before it will actually get displayed?

Yes.

Quote:

whose online seems to have a bug where all my users are for some reason always on the psistats page

Doesn't seem to have such bug on my board.

Quote:

What would be the easyist way to add extra bots...
I think i have found one of the unknown bots by following the IP addy.

./includes/psistats/database_agent.php
Which bots do you want to add?

msimplay

01-07-2006 11:37 PM

Quote:

Originally Posted by Psionic Vision

Yes.

Doesn't seem to have such bug on my board.

./includes/psistats/database_agent.php
Which bots do you want to add?

i conclude two theories one because the arcade is installed or two because i'm using vb3.5.3

Rickie3

01-08-2006 01:29 AM

Quote:

whose online seems to have a bug where all my users are for some reason always on the psistats page

I have the exact same error

akanevsky

01-08-2006 01:41 AM

I'll take a deeper look at it... For now, just to pinpoint the problem: Those of you who have the problem - what other hacks do you have installed?

Rickie3

01-08-2006 02:06 AM

i'm not sure if i'm correct here,i removed the headinclude template just out of interest,and my WOL showed correctly,and that is with psiStats still enabled,could maybe a bug in headinclude template??

MooMan65

01-08-2006 03:08 AM

This is interesting: I disabled the online_location_process plugin so it became an 'unknown' location, and I noticed that all the people who were viewing the statistics (way more than there actually were), it was at the location:

Code:

/psistats.php?do=update_info

Does that mean anything to you? Probably some sort of background task that is always being picked up? I checked the psistats.php file and an 'update_info' section doesn't even exist, only 'updateinfo'...

On another issue, I've noticed that the headinclude additions seems to slow down the loading of every page by about 6-10 seconds or so. When I remove it pages load fine, so it's definitely related to what the block of code does. Unfortunately, this issue alone is enough to make me unable to keep this hack installed as I don't want to be inundated with complaints. ;) Shame really, as it is great to finally have a stats hack for v3.5. Awesome job. :)

Oh, I'm also have the issue with the Display Colours & Resolutions page not displaying any information (the others are all counting up as they should though), and this is even after a few hours.

EDIT: Ah HA! In the headinclude code at this point, this:

PHP Code:


		
			
req.send("$session[sessionurl]do=update_info&width=" + self.screen.width + "&height=" + self.screen.height + "&depth=" + self.screen.colorDepth);

should be (remove the underscore):

PHP Code:


		
			
req.send("$session[sessionurl]do=updateinfo&width=" + self.screen.width + "&height=" + self.screen.height + "&depth=" + self.screen.colorDepth);

If I'm not mistaken? You were calling a non-existant section? After changing that I ran the cron job and the hack is now recording resolution and depth information, AND the page loading time issue has disappeared too! :)

That still doesn't fix the issue of everyone being redirected to the background task which shows up in Who's Online, and I'm not sure how to fix that one...

Rickie3

01-08-2006 03:48 AM

ok i found the WOL problem its working great for me now original headinclude template as below

Code:

<script type="text/javascript">

if (window.XMLHttpRequest)

{

        req = new XMLHttpRequest();

}

else if(window.ActiveXObject)

{

        req = new ActiveXObject("Microsoft.XMLHTTP");

}



if (typeof req == "object")

{

        req.open("POST", "psistats.php", false);

        req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

        req.send("$session[sessionurl]do=update_info&width=" + self.screen.width + "&height=" + self.screen.height + "&depth=" + self.screen.colorDepth);

}

</script>

the error was here

Quote:

req.open("POST", "psistats.php", false);

should have = in front of false,try this headinclude template below see if it fixes your problem

Code:

<script type="text/javascript">

if (window.XMLHttpRequest)

{

        req = new XMLHttpRequest();

}

else if(window.ActiveXObject)

{

        req = new ActiveXObject("Microsoft.XMLHTTP");

}



if (typeof req == "object")

{

        req.open("POST", "psistats.php", =false);

        req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

        req.send("$session[sessionurl]do=updateinfo&width=" + self.screen.width + "&height=" + self.screen.height + "&depth=" + self.screen.colorDepth);

}

</script>

MooMan65

01-08-2006 04:21 AM

Interesting, that did seem to work! So if you apply both our changes it should solve these two recent issues? :)

Rickie3

01-08-2006 04:47 AM

Quote:

Originally Posted by MooMan65

Interesting, that did seem to work! So if you apply both our changes it should solve these two recent issues? :)

it appears to have,working perfectly so far

firstrebel

01-08-2006 08:56 AM

I have resinstalled this again this morning, and was monitoring 'top' throughout the install.

All was OK until the last part where I installed the product. Apache started to use up to 98% CPU utilisation and very rarely dropped below about 45%.

Did the mod that MooMan65 mentioned in #104 = no change.

Added the mod from Rickie3 in #105 = bingo. CPU utilisation dropped back to single figures and remained low.

The only other thing I noticed is that CPU utilisation shoots up to about 45% when I click 'Quick Links' > 'Site Statistics' and then drops again. Otherwise it seems to be going OK. Will check the CPU util in about an hour or so to see what it does when I go through all the options.

Bob :classic:

firstrebel

01-08-2006 09:09 AM

:tired:

Just checked my email and got this error again

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:
TRUNCATE TABLE `psistats_cache`;

MySQL Error : Table 'vb_forum.psistats_cache' doesn't exist
Error Number : 1146
Date : Sunday, January 8th 2006 @ 10:56:09 AM
Script : http://www.volvoclub.org.uk/forum/cron.php?&rand=330997
Referrer : http://www.volvoclub.org.uk/forum/sh...ad.php?t=14496

'vb_forum.psistats_cache' does not indeed exist but 'vb_psistats_cache' does???

Bob

Rickie3

01-08-2006 09:20 AM

Quote:

Originally Posted by firstrebel

:tired:

Just checked my email and got this error again

'vb_forum.psistats_cache' does not indeed exist but 'vb_psistats_cache' does???

Bob

did you update to v1.3.0?????? i just checked your board its showing v1.2.8

firstrebel

01-08-2006 10:22 AM

I saw that also, but I did a clean install of 1.3.0 and used overwrite when I installed the product.

Bob

Rickie3

01-08-2006 10:29 AM

hmmmmmmmmmmmm strange i noticed its the same on my board as well

vau7	01-08-2006 10:29 AM

Since the Update it doesnt display anymore the Display Colors & Resolutions
Countries & Regions | Browsers & Operating Systems | Referring Sites.

What did i do wrong?

Feckie (Roger)

01-08-2006 10:32 AM

Quote:

Originally Posted by vau7

Since the Update it doesnt display anymore the Display Colors & Resolutions
Countries & Regions | Browsers & Operating Systems | Referring Sites.

What did i do wrong?

Does for me

bashy

01-08-2006 10:34 AM

Hi Psionic

I also have not had any stats recorded for the displays res'
But i do have MSN recrding now :) thanks for that, much appreciated

Regards

Bashy

Quote:

Originally Posted by vau7

Since the Update it doesnt display anymore the Display Colors & Resolutions
Countries & Regions | Browsers & Operating Systems | Referring Sites.

What did i do wrong?

firstrebel

01-08-2006 10:34 AM

The file psistats.php in the current zip file (v1.3.0) still shows 1.2.8

Quote:

$version = '1.2.8';

Does anyone have 1.3.0 showing on their board?

Bob

firstrebel

01-08-2006 10:36 AM

Quote:

Originally Posted by bashy

Hi Psionic

I also have not had any stats recorded for the displays res'
But i do have MSN recrding now :) thanks for that, much appreciated

Regards

Bashy

The new one drops all the tables created for the last one and creates new ones, so you need to wait for them to get populated.

Bob

vau7	01-08-2006 10:37 AM

Yeah, but no change since yesterday, and i made some linkclicks from my other site, so hte referrer should be shown.

bashy

01-08-2006 10:42 AM

Hi Bob

I did assume this but as i did it yesterday, well as soon as the update came
out, i thought it might have recorded sommat by now is all....
I have had quite a few peeps in since thye update....

Quote:

Originally Posted by firstrebel

The new one drops all the tables created for the last one and creates new ones, so you need to wait for them to get populated.

Bob

firstrebel

01-08-2006 10:51 AM

Quote:

Invalid SQL:
TRUNCATE TABLE `psistats_cache`;

MySQL Error : Table 'vb_forum.psistats_cache' doesn't exist
Error Number : 1146
Date : Sunday, January 8th 2006 @ 12:25:26 PM
Script : http://www.volvoclub.org.uk/forum/cron.php?&rand=10874
Referrer : http://www.volvoclub.org.uk/forum/sh...ght=cold+start

My knowledge of MySQL is only basic but is from psistats_update.php is this correct:

Quote:

$vbulletin->db->query_write("TRUNCATE TABLE `psistats_cache`");

Bob

akanevsky

01-08-2006 10:56 AM

Quote:

Yep. Heh... That'd be it.
The reason is, each page sends a request do psistats for update. Thus making everyone written down as if they are on stats page. I'll see whether I can make a walk-around this.

Quote:

should have = in front of false,try this headinclude template below see if it fixes your problem

What exactly does the = do? The = is not in any ajax tutorials I've read...
What happens if you just put it to "true"?

Quote:

Just checked my email and got this error again

Will fix. Forgot table prefix. Must be:
$vbulletin->db->query_write("TRUNCATE TABLE `" . TABLE_PREFIX . "psistats_cache`");
instead of
$vbulletin->db->query_write("TRUNCATE TABLE `psistats_cache`");

Quote:

$version = '1.2.8';

Heh, forgot to change that too.

All times are GMT. The time now is 08:17 AM.

Page 3 of 15

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01655 seconds Memory Usage 1,861KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (28)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: