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)

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.


All times are GMT. The time now is 03:53 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.01662 seconds
  • Memory Usage 1,751KB
  • 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
  • (2)bbcode_code_printable
  • (7)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