vb.org Archive - vB Statistic version 3.0.0 (directors Cut *g*)

Page 2 of 14

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

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)

kall	01-19-2005 09:25 AM

And you can enter any other domains in as well in counter.php AFAIK, preventing them from being logged, along with your own redirections.

sv1cec

01-19-2005 09:33 AM

Quote:

Originally Posted by kall

And you can enter any other domains in as well in counter.php AFAIK, preventing them from being logged, along with your own redirections.

A couple of small issue, it does not identify the number of users with an avatar. It shows 0.

Also, in the Search engines window, when I put the mouse cursor over the sign that shows that the search string was shortened, it does not show the whole string, it shows "shorten Search string".

Finally, in the Browser Plugins and Monitor Resolution page, the only thing that contains some information, is the line which shows Users who block Javascript on their system. All others are zeros. Same thing with my systems information. Not all installed components are identified. I do not particularly care about this, I know what I have, I just let you know, in case you are not aware of it.

One question also: If I set the show statistics page option to 1 (admins and mods) , does that includes super moderators as well?

Rgds

PcFreak

01-19-2005 10:01 AM

@sv1cec
Did you make Step 6?

HTML Code:

==============================

== step 6                                                               ==

==============================



Now let's activate the statistics and count of visitors

---------------------------------------------------------------------

6.1) Open Template "headinclude" in your AdminCP

     add the following code at the end of the template in the last line!

---------------------------------------------------------------------



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

This step is important for the Browser Plugins and Monitor Resolution page (Systemcheck page).

Quote:

Also, in the Search engines window, when I put the mouse cursor over the sign that shows that the search string was shortened, it does not show the whole string, it shows "shorten Search string".

This is the alternate text of the image. ;) The whole string you can see in the alt text of the link.

Quote:

couple of small issue, it does not identify the number of users with an avatar. It shows 0.

I cannot confirm. Works perfect.

PcFreak

PcFreak

01-19-2005 10:06 AM

Quote:

One question also: If I set the show statistics page option to 1 (admins and mods) , does that includes super moderators as well?

I dont know the permissions of you super moderators but normally yes.

PcFreak

sv1cec

01-19-2005 10:14 AM

Quote:

Originally Posted by PcFreak

@sv1cec
Did you make Step 6?

HTML Code:

==============================

== step 6                                                               ==

==============================



Now let's activate the statistics and count of visitors

---------------------------------------------------------------------

6.1) Open Template "headinclude" in your AdminCP

     add the following code at the end of the template in the last line!

---------------------------------------------------------------------



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

This step is important for the Browser Plugins and Monitor Resolution page (Systemcheck page).

This is the alternate text of the image. ;) The whole string you can see in the alt text of the link.

I cannot confirm. Works perfect.

PcFreak

Yes, I did, here is how the end of that template looks in my system:

HTML Code:

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

<if condition="$show['popups']"><script type="text/javascript" src="clientscript/vbulletin_menu.js"></script></if>

<!-- Edited to show the favicon -->

<link rel="shortcut icon" href="favicon.ico">

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

Re. alt text, that's what I mean, I hover my cursor about that image and expected to see the whole string. Instead, I see "shorten Search string" in the small yellow alt text window.

https://vborg.vbsupport.ru/external/2005/01/1.jpg

As for the users with avatar issue, here is the image from the stats page. And I know for sure that there are a lot of my users with an avatar, me included.

Rgds

Torqued

01-19-2005 11:02 AM

Quote:

Originally Posted by kall

Well...for one, you have the wrong path somewhere there.

statistic_java_counter.php should be in /public_html/forums , the same place as global.php and statistic.php

That's the problem. I have statistic_java_counter.php in /public_html/forums but when the script runs, I get the error message for the other path. :ermm:

sv1cec

01-19-2005 11:17 AM

Cancel all my other problems, they are all solved, I had missed one file when I uploaded to the live server. My only issue is still the avatars count, which denies to move from zero.

OK, I figured that out, you are counting only users who have a custom avatar. Not the ones which are using one of the site's provided ones. I modified your code as below.

Edit file /statistic/sides/forum.php and find:

PHP Code:


		
			
//User und Profilbilder

//Avatars

    $avatars = $DB_site->query_first("

            SELECT COUNT(*) as avatar, SUM(filesize) AS size 

            FROM " . TABLE_PREFIX . "customavatar 

            ");

            $all_avatars = vb_number_format($avatars['avatar']);

Replace that with:

PHP Code:


		
			
//User und Profilbilder

//Avatars

    $avatars1 = $DB_site->query_first("

            SELECT COUNT(*) as avatar, SUM(filesize) AS size 

            FROM " . TABLE_PREFIX . "customavatar 

            ");

            $all_avatars1 = vb_number_format($avatars1['avatar']);                                

            

    $avatars2 = $DB_site->query_first("

            SELECT COUNT(*) as avatar  

            FROM " . TABLE_PREFIX . "user where avatarid!='0' 

            ");        

            $all_avatars2 = vb_number_format($avatars2['avatar']);                                

            

            $all_avatars = $all_avatars1 + $all_avatars2;

That solved the issue.

Rgds

Beermonster

01-19-2005 11:46 AM

A request for 3.0.1 :) could you add the option to exclude certain IP(s) from the stats? or even better a certain user, I would like to exclude myself from the stats.

btw great hack blows v2 out of the water, got to be a contender for HOTM :)

PcFreak

01-19-2005 11:59 AM

Quote:

A request for 3.0.1 could you add the option to exclude certain IP(s) from the stats? or even better a certain user

Hmm... :disappointed:
But why not. Not so difficult :)

@sv1cec
I add the link to your avatar solution in the first post.
Is it ok?

PcFreak

Nordinho

01-19-2005 12:15 PM

Excellent work!! installed flawless...

oldfan

01-19-2005 01:28 PM

I'll install this tonight, looks frigin great !!

sv1cec

01-19-2005 01:28 PM

Quote:

Originally Posted by PcFreak

@sv1cec
I add the link to your avatar solution in the first post.
Is it ok?

Sure thing, always glad to help.

-------

John

yoyoyoyo

01-19-2005 01:49 PM

Amazing hack, but I don't see the stat to indicate the actual IP address of the server or a link to the last post/thread (or 10 last posts/threads)

sv1cec

01-19-2005 01:53 PM

Well, the issue of the blank line on the top of the site, is partially solved, with the instructions you gave us. In my site, it was replaced with a thinner line, in the color of the background, but it is still there. If you can visit the site (forum.m1911.org) using IE you will see that above the two pictures on the top left and right, there is a blue line. That shouldn't be there, the pictures should touch the top edge of the browser's window.

This looks particularly ugly in my site, and I would appreciate if you could eliminate it. Personally I do not care much, as this does not happen with Firefox browser I am using, but the majority of the visitors are using IE and it will break up the forum's image for them.

Again, thanks for a GREAT hack and rgds

TheVirus

01-19-2005 02:50 PM

Quote:

Originally Posted by PcFreak

Are you or anybody interests to provide a new?
Please contact me.

Sorry, but i am not a graphic freak.

PcFreak

Hey dude, I'm working on a new image pack for you...will send it to you when it's done.

Spinball

01-19-2005 02:52 PM

I think you might need to add an 'addslashes' in there somewhere?

Quote:

Database error in vBulletin 3.0.5:

Invalid SQL:
SELECT full_referer_id, counter
FROM statistic_referer_full
WHERE full_referer ='http://www.google.com/search?hl=en&lr=&safe=off&q=B&W 602's amp recommend&btnG=Search'
ORDER BY full_referer_id DESC

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 's amp recommend&btnG=Search'
ORDER BY full_referer_id DESC'

mysql error number: 1064

Date: Wednesday 19th of January 2005 05:37:42 PM
Script: http://www.avforums.com/forums/showthread.php?t=172283
Referer: http://www.google.com/search?hl=en&l...nd&btnG=Search
Username: Unregistered
IP Address: 80.164.34.4

Onkel_Tom

01-19-2005 02:58 PM

Quote:

Originally Posted by Spinball

I think you might need to add an 'addslashes' in there somewhere?

PcFreak, I thought this was fixed in Dezember in a beta release ????

sv1cec

01-19-2005 05:14 PM

Quote:

Originally Posted by Onkel_Tom

PcFreak, I thought this was fixed in Dezember in a beta release ????

OK, I've find the problem with the icon in the search engines search strings. In the file statistic/sides/searchengines.php, you have this code:

PHP Code:


		
			
$et = "<img src='statistic/images/misc/noaktiv.gif' alt='$vbphrase[vbstatistic_searchstring_alt]' width='20' height='20' />"

This should be changed as shown below:

PHP Code:


		
			
$et = "<img src='statistic/images/misc/noaktiv.gif' alt='$keyword_alt' width='20' height='20' />";

With this change, when the cursor hovers over the https://vborg.vbsupport.ru/external/2005/01/1.gif sign, you get the full search string.

Rgds

Bryan Ex

01-19-2005 05:36 PM

Confirmed to be working fine on vB 3.0.1 btw. Quick question... where can I edit the data for forum install date as I haven't been able to track it down in the database? It's currently defaulting to Dec 1969...

manguish

01-19-2005 05:55 PM

Quote:

Originally Posted by Bryan Ex

Me too - mines defaulting to 01-01-1970 at 18:00 (12803 days)

But no show of a search for %1970% in the database......

Bryan Ex

01-19-2005 06:03 PM

It's most likely in Unix time and probably has a value of 0 right now... I just can't find the actual field for a forum install date.

manguish

01-19-2005 06:03 PM

Found this :

vbstatistic_board_online

Shows :

Forums online since: {1} at {2} ({3} days)

Where do we alter {1}, {2} and {3} ?

Bryan Ex

01-19-2005 06:19 PM

I got it... it's based on the registration date of the first user id in the database (normally user #1) but I did an import from phpBB2 so admin is user 2. In /statistic/side/forum.php find AROUND LINE 48;

PHP Code:


		
			
    $the_begin = $DB_site->query_first("

            SELECT username AS name, joindate AS installdate

            FROM " . TABLE_PREFIX . "user

            WHERE userid = 1

            ");

Change "WHERE userid = 1" to to match the first user id # actually listed in your database.

Torqued

01-19-2005 07:43 PM

I want to try a re-install of this from the beginning. How do I quickly delete all the phrases?

S@NL - BlackBik

01-19-2005 08:43 PM

Quote:

Originally Posted by Trosun

I'm not sure if you HAVE to delete the v2 data.
But i would anyway, since it's logging more things now etc.[/URL]

Thanks Trosun, I just mist that little piece of info :)

PC Freak and Onkel Tom, thanks a lot for this great hack. I've just hit the "Install" button :banana:

FWF	01-19-2005 10:56 PM

installed on 3.0.1 , my staff members as well as regular members love this hack! thanks for releasing it :D

aussiev8

01-19-2005 11:18 PM

this script is great, credit to the author, but its not showing that i've been hit by the googlebot.. why's that? this is driving me insane. i really would like to know how many times i get hit by each particular bot, so i can customise my website to suit. I'm being indexed in google so i must be getting visited, why isn't it showing up in here?

Onkel_Tom

01-20-2005 01:51 AM

Quote:

Originally Posted by Torqued

I want to try a re-install of this from the beginning. How do I quickly delete all the phrases?

Just read the readme.txt file and run your installation script from the beginning.

Onkel_Tom

01-20-2005 01:54 AM

Quote:

Originally Posted by aussiev8

It is showing !
I think you must wait a few days until you get the first visit of googlebot. Visits of Googlebot are not as much as visits from yahoo slurp.

kall	01-20-2005 02:20 AM

If anyone wants to restrict the display of the Server type values on the main page, do the following change to STATISTIC template:

Find

PHP Code:


		
			
<td class="alt2">$webserver</td>

</tr>

<tr> 

    <td class="alt1"><img src="statistic/images/misc/php.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt1">$vbphrase[vbstatistic_php_version]</td>

    <td class="alt1">$phpversion</td>

</tr>

<tr> 

    <td class="alt2"><img src="statistic/images/misc/sql.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt2">$vbphrase[vbstatistic_sql_version]</td>

    <td class="alt2">$mysqlversion</td>

Replace with:

PHP Code:


		
			
<td class="alt2"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$webserver<else /><strong>Admin only!</strong></if></td>

</tr>

<tr> 

    <td class="alt1"><img src="statistic/images/misc/php.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt1">$vbphrase[vbstatistic_php_version]</td>

    <td class="alt1"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$phpversion<else /><strong>Admin only!</strong></if></td>

</tr>

<tr> 

    <td class="alt2"><img src="statistic/images/misc/sql.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt2">$vbphrase[vbstatistic_sql_version]</td>

    <td class="alt2"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$mysqlversion<else /><strong>Admin only!</strong></if></td>

Just take out the 5 and 6 conditions if you dion't want to show to mods and supermods.

Amavisca

01-20-2005 03:33 AM

Awsome hax. Work great on v3.06 Thnx

yoyoyoyo

01-20-2005 03:41 AM

Quote:

Originally Posted by kall

If anyone wants to restrict the display of the Server type values on the main page, do the following change to STATISTIC template:

Find

PHP Code:


		
			
<td class="alt2">$webserver</td>

</tr>

<tr> 

    <td class="alt1"><img src="statistic/images/misc/php.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt1">$vbphrase[vbstatistic_php_version]</td>

    <td class="alt1">$phpversion</td>

</tr>

<tr> 

    <td class="alt2"><img src="statistic/images/misc/sql.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt2">$vbphrase[vbstatistic_sql_version]</td>

    <td class="alt2">$mysqlversion</td>

Replace with:

PHP Code:


		
			
<td class="alt2"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$webserver<else /><strong>Admin only!</strong></if></td>

</tr>

<tr> 

    <td class="alt1"><img src="statistic/images/misc/php.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt1">$vbphrase[vbstatistic_php_version]</td>

    <td class="alt1"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$phpversion<else /><strong>Admin only!</strong></if></td>

</tr>

<tr> 

    <td class="alt2"><img src="statistic/images/misc/sql.gif" alt="$vbphrase[vbstatistic_infos_data_dec]" width="32" height="32" border="0" /></td>

    <td class="alt2">$vbphrase[vbstatistic_sql_version]</td>

    <td class="alt2"><if condition="$bbuserinfo[usergroupid]==5 OR $bbuserinfo[usergroupid]==6 OR $bbuserinfo[usergroupid]==7">$mysqlversion<else /><strong>Admin only!</strong></if></td>

Just take out the 5 and 6 conditions if you dion't want to show to mods and supermods.

cool- now I can move this in to the public area :)

PcFreak

01-20-2005 05:26 AM

Quote:

Originally Posted by spinball

I think you might need to add an 'addslashes' in there somewhere?

Quote:

Originally Posted by Onkel_Tom

PcFreak, I thought this was fixed in Dezember in a beta release ????

Nope. ;)
I fix this for keywords, not for referers. ;)
I have add a new statistic counter.php. Just exchange the new statistic_counter.php with the old one to fix this problem.

Quote:

Originally Posted by Torqued

I want to try a re-install of this from the beginning

Not the statistic is the problem. It?s your portal.
vBadvanced is a really very good modification. But it is change so much the orginal vBulletin file structur.
At the moment i have no solution for this portal problem.

Quote:

Originally Posted by Bryan Ex

My mistake
I had never thought that userid 1 will be miss sometimes :)
Your solution to change the userid in the forum.php is correctly

Quote:

Originally Posted by sv1cec

OK, I've find the problem with the icon in the search engines search strings

That wasn?t a problem
It was not intended of me, display a link in the alternate text of an image.
The alternate text is the image description. (It is for user with exotic Browsers, or for user which block images). For exampel: Some user surf with Text Browsers (blind user or user with a see handicap) I want make my code accessible for all without barriers. (besides it is xhtml conform)

Greets
PcFreak

sv1cec

01-20-2005 05:43 AM

Quote:

Originally Posted by PcFreak

Then I am afraid that I do not understand your explanation.

"You can show the complete Search string while resting the mouse over the sign. The string will be shown in the "Alt" Tag."

The Alt tag of an image, appears when you rest your cursor over the image. Am I wrong? In any case, that does not bother me, so don't bother yourself either.

Rgds and tnx

kall	01-20-2005 05:44 AM

Quote:

Originally Posted by Torqued

That's the problem. I have statistic_java_counter.php in /public_html/forums but when the script runs, I get the error message for the other path. :ermm:

You can either use the full path to the file ie:

PHP Code:


		
			
include("/home/youraccount/public_html/forums/statistic_counter.php");

or...

PHP Code:


		
			
if (THIS_SCRIPT != 'adv_index')

{

include("./statistic_counter.php");

}

.. if you want to stop the including when people are viewing your adv_index page.

Ah. Right, sorry. Just stick the full path to statistic_java.js in the template. Then, you will need to edit the .js file, on line 113, enter your full forum path.

Onkel_Tom

01-20-2005 06:02 AM

Quote:

Originally Posted by sv1cec

Ooops, that was a translation mismatch from me ;)

Spinball

01-20-2005 06:09 AM

Quote:

Originally Posted by Spinball

I think you might need to add an 'addslashes' in there somewhere?

Still getting regular database errors.
Any chance of a patch, or instructions on how to patch, please?

PcFreak

01-20-2005 06:15 AM

Quote:

Originally Posted by sv1cec

Then I am afraid that I do not understand your explanation.
"You can show the complete Search string while resting the mouse over the sign. The string will be shown in the "Alt" Tag."

Its ok. Thats mean, shown in the alt tag of the link ;).
Sorry for this misunderstanding

Quote:

Originally Posted by sv1cec

But I would appreciate some help in solving the additional line issue on the top of my site.

I look around for a solution.
At the moment i have no idea.
I use the IE 6.0 and dont see any line on the top of your side.
Maybe there more users here, with the same problem. I am sure, together we find a solution for this.

PcFreak

PcFreak

01-20-2005 06:18 AM

Quote:

Originally Posted by Spinball

Still getting regular database errors.
Any chance of a patch, or instructions on how to patch, please?

I have add a new statistic counter.php. Just exchange the new statistic_counter.php with the old one to fix this problem

Have you done this?

PcFreak

hugo	01-20-2005 06:28 AM

MMHH...

I´m looking for the lenguage SPANISH.. i understand that german is great, but ... i need the spanish translation.

=P If anyone do the translation, i´m interesting..

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

Page 2 of 14

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02035 seconds Memory Usage 1,942KB 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_html_printable (11)bbcode_php_printable (29)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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: