vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Statistic version 3.0.0 (directors Cut *g*) (https://vborg.vbsupport.ru/showthread.php?t=74603)

Sir_Yaro 01-23-2005 10:01 PM

Quote:

Originally Posted by PcFreak
Because these browsers are very exotic.
I have not found a browserstamp (agent) to detect this browsers.
Lynx will detect with the agent "lynx" (you linx agent must use an other agent) and the browser "link" was unknown for me.
Never heard something about this browser. Sorry...
They logged under the point "not identified" browsers

not link but links :)
http://links.sourceforge.net/
its a well known text browser in linux. only lynx is known better. :)

Quote:

Originally Posted by PcFreak
Is not very difficult to add new browsers and os.
Needed just one new data insert and just one new condition.
Will add more Browsers/OS/Spider and Crawlers with an Update.
Suggestions on further Browser/OS are welcome.

if you want im will help you with pleasure. just tell me how i can find this browserstamps....

and what with this topic duplicates? how can i remove it?

tpr 01-24-2005 03:58 AM

I have a small problem with the statistics.
While you do show me how many bots entered (and what precentage they take out of my visitors) The rest of the statsistics do not take that into account.
This means that when i get 514 visitors today its actually more like 350 (damn slurp) or when i check in Referrers the precentage that come directly/through an external Referrer calculate the bots within which is not something i would want.
Any way to bypass thats ?

p.s.
am i the only one that gets harassed by slurp ?

PixelFx 01-24-2005 04:19 AM

your not the only one my site is getting attacked by Slurp as well.

Carl Anderson 01-24-2005 05:48 AM

I ran the uninstall script for version 2 so I could upgrade to 3 and now I get this.....

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT LOGTIME FROM statistik_einstellungen

mysql error: Table 'goldism_goldism.statistik_einstellungen' doesn't exist

mysql error number: 1146

Date: Monday 24th of January 2005 02:47:10 AM
Script: http://goldismoney.info/forums/index.php?
Referer:
Username: G-khan
IP Address: 68.119.29.63

I can't log in or do anything not even to my admincp

Anyone know a fix......

Onkel_Tom 01-24-2005 05:59 AM

You haven't done the remove of the logging in your template phpinclude_start as it is described in the readme and also in the uninstalling file !!!
But you should login in admincp to get ride of this code in your phpinclude_start template also afterwards.
If this did't work you have to go with phpmyadmin to your database directly and edit the template there.

Carl Anderson 01-24-2005 06:05 AM

Quote:

Originally Posted by Onkel_Tom
You haven't done the remove of the logging in your template phpinclude_start as it is described in the readme and also in the uninstalling file !!!
But you should login in admincp to get ride of this code in your phpinclude_start template also afterwards.
If this did't work you have to go with phpmyadmin to your database directly and edit the template there.

How do I get to my phpmyadmin as it wont let me login to my admincp....... I do not have a control panel on my server so I would have to telnet in...

Carl Anderson 01-24-2005 06:13 AM

I got this fixed..................

h75 01-24-2005 07:49 AM

Double-Posts!!!

yes you can use paypal :)

tpr 01-24-2005 08:16 AM

Hi,
I recived a db error from the vB statistics (already works on my site for a couple of days)
here is the error :
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM frm_statistic_searchengine_keywords
WHERE keywords = '???\'

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''???\'' at line 3

mysql error number: 1064

The forum is in hebrew thus the ??? in the syntax, anyway around this ?

Marco van Herwaarden 01-24-2005 11:26 AM

Quote:

Originally Posted by tpr
Hi,
I recived a db error from the vB statistics (already works on my site for a couple of days)
here is the error :
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM frm_statistic_searchengine_keywords
WHERE keywords = '???\'

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''???\'' at line 3

mysql error number: 1064

The forum is in hebrew thus the ??? in the syntax, anyway around this ?

I am not the coder of this hack, but try the following changes.

in file statistic_searchengines.php
find:
PHP Code:

    $keywords_known $DB_site->query("
        SELECT counter 
        FROM " 
TABLE_PREFIX "statistic_searchengine_keywords
        WHERE keywords = '
$keyword_found'
        "
); 

Replace by:
PHP Code:

    $keywords_known $DB_site->query("
        SELECT counter 
        FROM " 
TABLE_PREFIX "statistic_searchengine_keywords
        WHERE keywords = '" 
addslashes($keyword_found) . "'
        "
); 

This will be a solution to this one query. I noticed there are more places where this could happen, so just keep adding the 'addslashes()' as you go.

The Realist 01-24-2005 12:58 PM

Installed but when I click on update within admin panel I get this error:

Could not find phrase 'vbstatistic_admin_cp_set'.

I have search phrases and it is there. I have edited and saved and still the same error?

Anyone with some pointers on this?

MissKalunji 01-24-2005 03:20 PM

when you click on the Country of origin and browser language then u click on lets say .com its suppose to bring you to WIKIPEDIA free encyclopedia but it gives an error page http://no name of domain ...what do i do to fix that???

Smitty 01-24-2005 04:56 PM

Quote:

Originally Posted by MissKalunji
when you click on the Country of origin and browser language then u click on lets say .com its suppose to bring you to WIKIPEDIA free encyclopedia but it gives an error page http://no name of domain ...what do i do to fix that???

EDIT: The Links to take you to the WIKIPEDIA page do not work on a *few* links in my install either.

And - The popup pages are not resizable (bummer).

I will make this note - Off topic from the reply above - On the main stats page it appears search engine spiders / bots are part of the count for page hits, average number of users, etc. The statistics are relatively useless when bots/spiders are included.

MissKalunji 01-24-2005 09:57 PM

Quote:

Originally Posted by Smitty
EDIT: The Links to take you to the WIKIPEDIA page do not work on a *few* links in my install either.

And - The popup pages are not resizable (bummer).

I will make this note - Off topic from the reply above - On the main stats page it appears search engine spiders / bots are part of the count for page hits, average number of users, etc. The statistics are relatively useless when bots/spiders are included.


in wich file??

Smitty 01-25-2005 04:17 AM

Quote:

Originally Posted by MissKalunji
in wich file??

I'll check tomorrow and let you know which links. For my board it's a relative issue because it takes users to WIKIPEDIA pages in German and most of my registered users are English speakers.

If you want to see my stats (elsmar.com/Forums/), you can log in with user name: vborg, password: statstest

I'll leave that account active for a day or two.

Torqued 01-25-2005 04:32 AM

Is there maybe a 3.1 bugfix version soon? :)

PcFreak 01-25-2005 05:54 AM

Quote:

Originally Posted by MissKalunji
when you click on the Country of origin and browser language then u click on lets say .com its suppose to bring you to WIKIPEDIA free encyclopedia but it gives an error page http://no name of domain ...what do i do to fix that???

You can?t fix that.
Not for every language or tld, there is a side on wikipedi encyclopedia.
I have made the inserts (the urls) to wikipedia in October 2004.
(It could be it in the meantime a side gives)

Quote:

Originally Posted by Smitty
And - The popup pages are not resizable (bummer).

Yes. I intended this also in such a way.

My philosophy over the visitors
What is a visitor?
When i started to code the statistic, i have think about this very much
For me it is all the same whether now the visitor Spider, Crawler or an actual visitor is.
I wanted to know how many vistits or page hits are on my sides. (All together)

@MarcoH64
Thank you for the tipp with 'addslashes()' .
I will use this in a comming update.

@The Realist
The Phrase 'vbstatistic_admin_cp_set' is not a global phrase. This phrase is a CP Stop Message (phrasetypeid = 9000).

Quote:

Originally Posted by Torqued
Is there maybe a 3.1 bugfix version soon?

I think, there are not really many bugs.
Of course, there are some problems. But most of them are individually (for example: problems to deinstall the old statistic version, links Browser is not detected ;), misunderstandings, and few problems with querys particularly with keywords.)
For the most users, the statistic works perfekt.

PcFreak

yinyang 01-25-2005 08:54 PM

here's the oddest thing. i just noticed that all the statistics seem to be counting fine except :

Page hits since statistics began: 0
Number of visitors since statistics began: 0
Average visitors per day: 0

I installed it on January 19 and it's been tracking the last days members, threads, search bots, etc. any ideas what happened?

I installed it on another board and it works fine there! help!

Smitty 01-26-2005 10:53 PM

I had to uninstall. Too many database errors and other issues.

Oh, well. I'll probably put the old verson 2 back in.

yinyang 01-27-2005 04:55 AM

Quote:

Originally Posted by yinyang
here's the oddest thing. i just noticed that all the statistics seem to be counting fine except :

Page hits since statistics began: 0
Number of visitors since statistics began: 0
Average visitors per day: 0

I installed it on January 19 and it's been tracking the last days members, threads, search bots, etc. any ideas what happened?

I installed it on another board and it works fine there! help!

hello? this is so odd!

Jenta 01-27-2005 06:52 AM

great job on this
its amazing
the only thing i would hope is to exclude myself from being counted as im always there and it tends to scew? the stats

kall 01-27-2005 07:13 AM

Quote:

Originally Posted by yinyang
hello? this is so odd!

Did you do the include thing for the statistic_counter.php file?

Check your error logs if you did, it may be trying to call it from the wrong place, in which case you would need to change the path.

Onkel_Tom 01-27-2005 07:21 AM

Quote:

Originally Posted by Smitty
I had to uninstall. Too many database errors and other issues.

Oh, well. I'll probably put the old verson 2 back in.

I can't undestand!
We tested this version on more than one vB and all went fine. Also PcFreak do a lot of bugfixing before release and after release.
Did you really use the latest scripts ?
Or did you correct uninstall of the old vB2 version ?

Some guys didn't uninstall der vB 2 version correct and so they get database errors from the old one and not from the new version 3 !

tpr 01-27-2005 07:29 AM

Quote:

Originally Posted by PcFreak
My philosophy over the visitors
What is a visitor?
When i started to code the statistic, i have think about this very much
For me it is all the same whether now the visitor Spider, Crawler or an actual visitor is.
I wanted to know how many vistits or page hits are on my sides. (All together)
PcFreak

While i do like your philosophy it does seems to get in the way of me getting to know how my visitors act (where they come from etc...) so can we perhaps come to an understanding where you could choose your life philosophy ? :nervous:
(an option to turn the bot counting on/off).

its a great hack nontheless :D

Beermonster 01-27-2005 08:15 AM

I havn't had any problems with it but one of my mods was viewing it and it returened an error

Code:

Invalid SQL:
SELECT Summe as Datum
FROM statistik_zaehler AS statistik_zaehler
WHERE Zaehler_fuer = 'Statistik_Aktiv'
       
mysql error: Table 'vb3.statistik_zaehler' doesn't exist

mysql error number: 1146

any ideas?

Onkel_Tom 01-27-2005 08:32 AM

Quote:

Originally Posted by Beermonster
I havn't had any problems with it but one of my mods was viewing it and it returened an error

Code:

Invalid SQL:
SELECT Summe as Datum
FROM statistik_zaehler AS statistik_zaehler
WHERE Zaehler_fuer = 'Statistik_Aktiv'
       
mysql error: Table 'vb3.statistik_zaehler' doesn't exist

mysql error number: 1146

any ideas?

I think there is a TABLE_PREFIX missing in this query.

Beermonster 01-27-2005 08:51 AM

Quote:

Originally Posted by Onkel_Tom
I think there is a TABLE_PREFIX missing in this query.

Yes there is it's my database name, I removed it from the post

TTG 01-27-2005 09:26 AM

Installed with no problems and works well on 3.0.6 .. great hack.

Clicked install

Sir_Yaro 01-27-2005 12:42 PM

PcFreak, you wrote that you never heard about Links browser - thats why statistic doesnt recognised it.
But why Links IS in this list:
http://justget.org/statistic.php?do=now_browser_info
(17th from below) ??

In that case which browser is recogniser as Links ?

Smitty 01-27-2005 01:27 PM

Quote:

Originally Posted by Onkel_Tom
I can't undestand!
We tested this version on more than one vB and all went fine. Also PcFreak do a lot of bugfixing before release and after release.
Did you really use the latest scripts ?
Or did you correct uninstall of the old vB2 version ?

Some guys didn't uninstall der vB 2 version correct and so they get database errors from the old one and not from the new version 3 !

Well, one problem was with the 'posts since last visit' function. See: Issue with "Since Last Visit" Search

I was also getting database errors from referrer entries. I went through the uninstall of version 2 pretty thoroughly, I think. Example:
Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = '\iso rules for lead free solder\'

mysql error: You have an error in your SQL syntax near ''\iso rules for lead free solder\'
' at line 4

mysql error number: 1064

Date: Wednesday 26th of January 2005 07:03:59 PM
Script: http://elsmar.com/Forums/showthread.php?t=8031
Referer: http://search.yahoo.com/bin/search?p=\'iso%20rules%20for%20lead%20free%20solde r\'
Username: Unregistered
At this point I'm pretty busy with a few things and want to make sure the 'posts since last visit' function is working correctly without this 'hack'. This weekend I'll take a look at everything and see if I did something wrong in editing the files. Actually, version 2 was OK for me. There are some things in it I did like better as to presentation. And, as I said earlier, including bots / spiders in stats like visitors on the main page dilute the information. Bots and spiders come and go while my main interest is in the people who visit.

Most of this isn't an isssue for me over all - I saw this as something for forum users more than anything else - I have a log analysis program I use on the site as a whole which segrates things like bot / spiders vs. 'people' - And most everything else I need.

I like the idea. I think it's a very nice 'hack'. And I'm not disappointed. A lot of time and hard work went into it. But for me, it'll be something I have to look more closely at - And to do that I have to find some time.

Note that I'm not a programmer so I'm not really very good at debugging. As the old saying goes, I know enough to be dangerous.

bkaul 01-27-2005 10:04 PM

Threads in hidden forums are shown to users who don't have access when listing the top replied to threads, etc. - this is a *BIG* flaw for anyone with "secret" subforums!

Other than that, great add-on...

yinyang 01-27-2005 10:54 PM

Quote:

Originally Posted by kall
Did you do the include thing for the statistic_counter.php file?

Check your error logs if you did, it may be trying to call it from the wrong place, in which case you would need to change the path.

thanks kall. i went through and everything is where it should be. and it still doesn't work. *sigh*

Sir_Yaro 01-27-2005 11:21 PM

PcFreak you shoud say that its SO easy to add new browser to statistic code....
just add
Code:

elseif(strpos($agent, 'links') !== false)  $browser = "Links";
under
Code:

elseif(strpos($agent, 'mozilla') !== false)  $browser = "Mozilla";                                                          //Mozilla
in statistic_browser_os.php file :)


Regards

Viks 01-27-2005 11:57 PM

Thanks PCfreak.

Installed on vb3.0.x with no issues

Thanks Kall for showing how to hide sever details for selected users.

Viks

azher 01-28-2005 05:24 PM

Hello,

Is there some sort of caching feature I'm missing? If I haven't hit the stats page all day, it usually takes between 120-200 seconds to generate the page. After that lag, the pages usually load up a bit quicker but this could definitely benefit from some form of a statscache.

PcFreak 01-29-2005 07:49 AM

Quote:

Originally Posted by azher
Hello,

Is there some sort of caching feature I'm missing? If I haven't hit the stats page all day, it usually takes between 120-200 seconds to generate the page. After that lag, the pages usually load up a bit quicker but this could definitely benefit from some form of a statscache.

This could be an other Problem (Performance Hit Since PHP 4.3.10 / 5.0.3)
Quote:

Originally Posted by kier from vBulletin
Many people have noticed that vBulletin (any a lot of other PHP applications) suddenly started to run significantly slowed than normal after installing PHP 4.3.10 or 5.0.3 in order to patch the security flaw in previous versions of PHP.

This cause of this slow-down has been identified as a problem with the unserialize() function in PHP. For more details, see bugs.php.net.

The full artikel you can read here: http://www.vbulletin.com/forum/showt...545#post801545

@Sir_Yaro
Ups. Sorry. It could be that i have forgot to define the Links Browser. I cant remember.

Quote:

Originally Posted by bkaul
Threads in hidden forums are shown to users who don't have access when listing the top replied to threads, etc. - this is a *BIG* flaw for anyone with "secret" subforums!

I cant confirm this.
I have make tests on my forum, but this funktion works well for me.
User without the permission to see a hidden forum cant see a hidden thread.

Perhaps, it could be you have not set the userpermission correctly or you have build new usergroups which have this permissions.
My tip. Check the userpermissions of your forum. I think, there is set something wrong.

PcFreak

Anarchy 01-29-2005 08:48 AM

Code:

Database error in vBulletin 3.0.6:

Invalid SQL:
            SHOW TABLE STATUS
            FROM toontowncentral_com_-_database
            LIKE 'pm'
           
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '-_database
            LIKE 'pm'' at line 2

mysql error number: 1064

Date: Saturday 29th of January 2005 04:50:21 AM
Script: http://www.toontowncentral.com/forums/statistic.php
Referer:
Username: Nick
IP Address: 203.173.16.50


PcFreak 01-29-2005 09:16 AM

@Anarchy
in statistic/sides/forum.php found
PHP Code:

$pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE '" 
TABLE_PREFIX "pm'
         "
); 

replace ist with
PHP Code:

    $pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE 'pm'
         "
); 

This will fix this error (i hope)

(toontowncentral_com_-_database is not a good database name. This "-" is a the sign for subtraction. Better is to use this "_".)

Greets
PcFreak

Guy G 01-29-2005 09:35 AM

Is there uninstallation script as well?

Anarchy 01-29-2005 10:51 AM

Quote:

Originally Posted by PcFreak
@Anarchy
in statistic/sides/forum.php found
PHP Code:

$pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE '" 
TABLE_PREFIX "pm'
         "
); 

replace ist with
PHP Code:

    $pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE 'pm'
         "
); 

This will fix this error (i hope)

(toontowncentral_com_-_database is not a good database name. This "-" is a the sign for subtraction. Better is to use this "_".)

Greets
PcFreak


After much playing around, i back quoted the `$dbname`

This fixed the problem.

Maybe you want to add this to your next release.

Code:

$pm_speicher_groesse = $DB_site->query("SHOW TABLE STATUS FROM `$dbname` LIKE 'pm'");


All times are GMT. The time now is 12:35 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01956 seconds
  • Memory Usage 1,879KB
  • 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
  • (6)bbcode_code_printable
  • (6)bbcode_php_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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