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)

northernstar 02-05-2005 02:55 AM

This looks like a great hack! But just one question, how much does it affect server load?
Are all the queries run when someone requests the statistics, or are they updated at a predetermined time and a cache is used?
Sorry for the newbie question, but I have a 20,000+ members, and over 500,000 posts, it kills me to think what this could do to the server if a bunch of ppl request the stats page around the same time :ermm:

PcFreak 02-05-2005 08:51 AM

The serverload is very low.

Querys for the logging part.

Max. 6 Querys for the first log. (3 normal and 3 shoutdown querys)
After that, 3 Querys. (1 normal and 2 shoutdown) for each side refresh.

Show one side of the statistic it the same like show the index.php or a other part of the forum. (need between 8 and 12 querys)

PcFreak

SnowBot 02-05-2005 05:15 PM

Installed without any problems...GREAT work again :)

Zachariah 02-05-2005 06:59 PM

/me hands PcFreak a brew and a hardy handshake.

4number8 02-05-2005 11:39 PM

Installed flawlessly, thank you so much PcFreak on another outstanding job.
This will be very useful :)

[high]* 4number8 clicks install[/high]

Sweet Evil 02-07-2005 02:13 AM

I installed ti and it seems to work fine, but when i add the code
PHP Code:

<script type="text/javascript" src="./clientscript/statistic_java.js"></script

to my headerinclude i get a gap at the top of my forums.

Any Ideas? Thanks!

h75 02-07-2005 02:29 AM

use this one ;)
Code:

<div style="display:none">
<script type="text/javascript" src="./clientscript/statistic_java.js"></script>
</div>


Sweet Evil 02-07-2005 02:57 AM

Thanks, Much Better :)

weirdpixels 02-08-2005 11:10 AM

great hack :) *clicks install

S@NL - BlackBik 02-09-2005 07:50 PM

Uninstall of V2 and install of V3 worked like a charm *thumbs up*
Thanks a lot!
Now there only rests the task for me of translating the phrases to Dutch :D

Jenta 02-10-2005 12:07 PM

Why doesn't this work?
PHP Code:

if ($statistic_on_off == "1") {
    if (!(
$permissions['forumpermissions']) OR !($permissions['genericpermissions']) OR $bbuserinfo['usergroupid'] == 9)
{
    
print_no_permission();        
    }            


i added OR $bbuserinfo['usergroupid'] == 9 but they can still see it

Battle_Ring 02-12-2005 01:14 AM

i installed this set my domain in the options it said saved sucessfully but than it goes back to the page and nothing is i nthere for the domain

Delphiprogrammi 02-12-2005 05:05 AM

the install script is in german ?????? sorry but i don't understand that language and i'm getting database crashes i downloaded https://vborg.vbsupport.ru/attachmen...chmentid=23192 it says vbstats_english but the install runs in german ??


edit

never mind that installed & up and running fine

[high]* Delphiprogrammi clicking install[/high]

Delphiprogrammi 02-12-2005 12:13 PM

hi,

this hack works fine however if would prefer if the system info like for example the webserver and the php(MySQL) version i'm using is only visible to me (Admin) because that information is kind off sensitieve besides that great hack

interfx 02-12-2005 02:42 PM

Works great...

Make sure you put the line

include("./statistic_counter.php");

at the very bottom of the phpinclude_start template...

Outside of the /*...

I made that mistake, and just figured it out...

S@NL - BlackBik 02-14-2005 10:44 PM

Sorry guys, but we found a "bug" in the vB Stats.

We recieved complaints that people couldn't see who was browsing a thread. All they saw was themselves, but not the other people who were in the thread. The "Who's online" page showed that serveral more people were browsing the thread, but they didn't show in the thread itself.

Our programmer has spent two evenings troubleshooting this problem and we found the cause.
It's the image that is generated by the statistic_java.js and that is in the header of every page. This image executes a script to see what browser, os, resolution etc he is using. The problem is this:

1. The user is opening the page and is put in the session table of the vB database.
2. The image is being execute, the vB Stats are updated, but the user is removed from the session table because at this time he is not viewing a forumpage but a generic page caused by the execution of the javascript.

Result: the sessions table is not up to date and the user is not being shown browsing the thread.

A possible sollution for this problem is not to touch the session in the statistic_java_counter.php. You can probably make sure of that by not using global.php, but only mysql includes and config includes.

We solved our problem by removing the java image from our header, but the result is that some statistics are not being updated. We hope you can find a better solution by making some changes to the program.

Greetz,
S@NL - BlackBiker

neocorteqz 02-16-2005 03:48 AM

Is there an uninstall if i choose to remove this?

lifesourcerec 02-16-2005 06:29 AM

very nice... :) Installed and it works like a charm.

Onkel_Tom 02-16-2005 07:17 AM

Quote:

Originally Posted by neocorteqz
Is there an uninstall if i choose to remove this?

Yes!
You can run the installer twice to uninstall the complete hack.

S@NL - BlackBik 02-16-2005 02:43 PM

Since we've translated the vB statistic phrases to Dutch, I might as well share those with you.
See the attached file.

Have fun with it :)

lange 02-17-2005 11:45 AM

Thanks. I'll try it.

kall 02-17-2005 04:44 PM

Quote:

Originally Posted by Delphiprogrammi
hi,

this hack works fine however if would prefer if the system info like for example the webserver and the php(MySQL) version i'm using is only visible to me (Admin) because that information is kind off sensitieve besides that great hack

Wow, that would be really cool!

*reads the thread*

Hey look! Someone has posted how to do it already! All I had to do was read the thread!!

https://vborg.vbsupport.ru/showpost....3&postcount=70

@PC Freak - You may want to add a link to that post in the first post - Hides server details for non-admins. :)

Onkel_Tom 02-17-2005 05:09 PM

Thanks to all voters!
I think we will get HotM February as well ;)

Grendel 02-17-2005 05:27 PM

Maybe I'm blind, but where is the german version?

Delphiprogrammi 02-17-2005 05:40 PM

Quote:

Originally Posted by kall
Wow, that would be really cool!

*reads the thread*

Hey look! Someone has posted how to do it already! All I had to do was read the thread!!

https://vborg.vbsupport.ru/showpost....3&postcount=70

@PC Freak - You may want to add a link to that post in the first post - Hides server details for non-admins. :)

:speechless: :speechless:

S@NL - BlackBik 02-17-2005 07:45 PM

Quote:

Originally Posted by kall
Wow, that would be really cool!

:)

LOL. I've implemented this hack to the hack :rolleyes:
I'ts even cooler if you replace "Admin only!" by a new statisticsphrase.
For example, i've made a phrase "vbstatistic_admin_only" and translated it to Dutch :)

Just a thought ;)

Onkel_Tom 02-17-2005 09:25 PM

Quote:

Originally Posted by Grendel
Maybe I'm blind, but where is the german version?

Just look at vbulletin-germany.com ;)
here is the direct link to the thread => http://www.vbulletin-germany.com/for...ad.php?t=15191

neocorteqz 02-17-2005 11:09 PM

Quote:

Originally Posted by Onkel_Tom
Yes!
You can run the installer twice to uninstall the complete hack.

sweet. Thanks,

This is a great hack. GL in the HotM vote. :)

PcFreak 02-18-2005 06:50 AM

Quote:

Originally Posted by kall
@PC Freak - You may want to add a link to that post in the first post - Hides server details for non-admins. :)

Done ;)

Quote:

Originally Posted by S@NL - BlackBik
Since we've translated the vB statistic phrases to Dutch, I might as well share those with you.
See the attached file.

Many thanks for sharing the dutch ;) phrases. I add them in the first post. The Copyright remains with you.

Quote:

Originally Posted by utlamer
i added OR $bbuserinfo['usergroupid'] == 9 but they can still see it

Hmm.
I dont have a solution for this problem.
Perhaps, it could be you have not set the userpermission correctly for the usergroup 9.
My tip: Check the userpermissions of your forum. I think, there is set something wrong.

PcFreak

Delphiprogrammi 02-20-2005 01:14 PM

hi,

i upgraded to vb 3.0.7 and this refuses to work .... it work fine on 3.0.6

Code:

Database error in vBulletin 3.0.7:

Invalid SQL:
            SHOW TABLE STATUS
            FROM add
            LIKE 'vb3_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 'add
            LIKE 'vb3_pm'' at line 2

mysql error number: 1064

Date: Sunday 20th of February 2005 04:10:45 PM
Script: http://**************/statistic.php?
Referer: http://************/index.php?
Username: **********
IP Address: **********

any solution ? cause i like this hack

jeepinator 02-21-2005 04:28 AM

I was hoping someone else would mention that it doesn't work with 3.0.7 :paranoid:
I just get a blank white page.
I freaking love this hack.

Lizard King 02-21-2005 04:41 AM

Quote:

Originally Posted by Delphiprogrammi
hi,

i upgraded to vb 3.0.7 and this refuses to work .... it work fine on 3.0.6

Code:

Database error in vBulletin 3.0.7:

Invalid SQL:
            SHOW TABLE STATUS
            FROM add
            LIKE 'vb3_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 'add
            LIKE 'vb3_pm'' at line 2

mysql error number: 1064

Date: Sunday 20th of February 2005 04:10:45 PM
Script: http://**************/statistic.php?
Referer: http://************/index.php?
Username: **********
IP Address: **********

any solution ? cause i like this hack

I have it working on 3.0.7 working perfectly :)
Check it out here http://forum.ayyas.com/statistic.php

Delphiprogrammi 02-21-2005 11:28 AM

Quote:

Originally Posted by Lizard King
I have it working on 3.0.7 working perfectly :)
Check it out here http://forum.ayyas.com/statistic.php


hmmmm you're right well i guess there is a problem with the MySQL version i use then i'll ask my host for help ;)

MissKalunji 02-21-2005 11:31 AM

Quote:

Originally Posted by jeepinator
I was hoping someone else would mention that it doesn't work with 3.0.7 :paranoid:
I just get a blank white page.
I freaking love this hack.


run the install file and update the template

Lizard King 02-21-2005 12:03 PM

Quote:

Originally Posted by MissKalunji
run the install file and update the template

It is easier to merge the old forum files with the new ones so you dont have to make any file edit for the previously installed hacks ;)

MissKalunji 02-21-2005 12:07 PM

Quote:

Originally Posted by Lizard King
It is easier to merge the old forum files with the new ones so you dont have to make any file edit for the previously installed hacks ;)


i didnt know that way...how do you do that????

Lizard King 02-21-2005 12:19 PM

Quote:

Originally Posted by MissKalunji
i didnt know that way...how do you do that????

Check out this thread

Delphiprogrammi 02-21-2005 12:33 PM

Quote:

Originally Posted by Delphiprogrammi
hmmmm you're right well i guess there is a problem with the MySQL version i use then i'll ask my host for help ;)


my domainname doesn't get saved i enter the domainname in statistic homepage options and i hit save vb tells me "settings saved successfully" but after the redirect the same field is empty ?????? hmmmm getting frusterated here :devious:

shadiguy1 02-21-2005 02:14 PM

need unsinstall for this. please advise.

Delphiprogrammi 02-21-2005 02:35 PM

hi,

this piece of php code is causing the error i get

PHP Code:

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

but that query seems correct to me ?????? and i can't find anything in the MySQL manual about this just a "syntax" example on my old host this worked fine now it refuses to work on my new host ... i dropped my old host because they forced people to go dedicated if you want crontab support :devious:

if i comment that code out it works fine


All times are GMT. The time now is 01:21 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.01850 seconds
  • Memory Usage 1,838KB
  • 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
  • (3)bbcode_php_printable
  • (16)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