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

Page 22 of 58

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)

Rickie3

01-11-2006 10:52 PM

Quote:

Originally Posted by SmEdD

Fix to show Firefox. Not 100% tested!

Find in database_agent.php:

PHP Code:


		
			
'Firefox'            => array('/Firefox\/([0-9\.]+)/i',                'Gecko',        false,        false    ),

Replace with:

PHP Code:


		
			
'Firefox'            => array('/Firefox\/([0-9\.]+)/i',                false,        false,        false    ),

that done the trick working now, cheers

akanevsky

01-11-2006 11:39 PM

Quote:

Psionic Vision

free-bsd = "FreeBSD"
net-bsd = "NetBSD"
open-bsd = "OpenBSD"
sun = "SunOs"

Those should be good since thats what the majority of my users will be using (guessing)

Ok, will add.

Quote:

$vbulletin->db->close(); is not in that file they updated it i installed the new copy of vbulletin... i still get the error and no stats show up so im clueless on what to do now...

What's the problem then?

Quote:

that done the trick working now, cheers

I thought all firefoxes have "Gecko" in their ID string. If not - yes, that will work for firefoxes that do not have gecko in them... I got that Gecko thing from browscap.ini.

DementedMindz

01-12-2006 02:11 AM

Quote:

Originally Posted by Psionic Vision

What's the problem then?

that none of the stats show up cause the cron cant run cause it gives a database error.... and that fix $vbulletin->db->close(); aint in the new vbulletin files... so thats why im posting here thinking maybe you would know why it wont run the cron....

SmEdD

01-12-2006 04:55 AM

Quote:

Originally Posted by Psionic Vision

I thought all firefoxes have "Gecko" in their ID string. If not - yes, that will work for firefoxes that do not have gecko in them... I got that Gecko thing from browscap.ini.

They all do but it seems this works . . .

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5

GamerJunk.net

01-12-2006 07:15 AM

After upgrade to 1.3.1 all stats get erased?

MThornback

01-12-2006 07:25 AM

Your folder names changed in this update mate....agent and flag both had "s" on them in a previous version

akanevsky

01-12-2006 08:59 PM

Quote:

After upgrade to 1.3.1 all stats get erased?

After upgrade to 1.3.0 and above from 1.2.8 and below.

Quote:

Your folder names changed in this update mate....agent and flag both had "s" on them in a previous version

That's why I ask to *revert* templates.

GamerJunk.net

01-12-2006 10:22 PM

So to upgrade what do I do? I basically uploaded all teh files again and imported the file again...

Still no stats and the bottom links aren't like they were before...

http://www.gsnforce.com/forum/psistats.php

MPDev

01-12-2006 10:37 PM

Upgraded, thanks.

One thing I added you might consider - I track the last referrer link into my site for each entry so that instead of click on www.google.com, it clicks to the last google.com referrer link into the site - this shows me what search term was used last to get to my site - or if coming from another website tells me what page actually directed the user to my site.

Having just the domain name is nice, but knowing where the referral came from is even nicer.

Since I haven't looked at the new caching code, here's what I had under the older code:

Code:

                                                                $db->query_write("

                                                                        UPDATE " . TABLE_PREFIX . "psistats_referrer

                                                                        SET count = count + 1, dateline = '" . TIMENOW . "', refline = '". $db->escape_string($_SERVER["HTTP_REFERER"]) ."'

                                                                        WHERE referrer = '" . $db->escape_string($referrerdata['host']) . "'

                                                                ");

GamerJunk.net

01-12-2006 11:29 PM

When I try to view an avatar...

I get this error..

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT * FROM vb3_psistats_country WHERE code = 'US' LIMIT 1;

MySQL Error : Table '*********vb.vb3_psistats_country' doesn't exist
Error Number : 1146
Date : Thursday, January 12th 2006 @ 08:27:10 PM
Script : http://www.gsnforce.com/forum/image....ine=1137115255
Referrer : http://www.gsnforce.com/forum/image....ine=1137115255
IP Address : 198.68.128.190
Username :
Classname : vb_database

This is only for uploaded avatars....not ones already on my server that I put through the admincp

All times are GMT. The time now is 08:33 PM.

Page 22 of 58

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01558 seconds Memory Usage 1,752KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: