vB3 Boardstatistic Version 2

no more support for statistic version 2



In the next days we will release a new statistic Version (vB Statistic 3).
For this reason I give from today on, no more support for the Statistic Version 2

This version is bigger, faster and we want to publish the statistic in two languages. (german and english).


In order to use the new Statistic Version, the old version must be unfortunately removed.

A deinstallation script you found here >> https://vborg.vbsupport.ru/showpost....47&postcount=2

For a first impression

You find a English demonstration of the Statistic here >> http://at-lantis.de/statistic.php

You find a German demonstration of the Statistic here >> http://boardszene.de/statistic.php

May someone will translate our Phrases from the new version 3.0 into other languages. If you are interested please send me or Onkel_Tom a PM with your eMail Address and we will sent you the phrases file in english to be translated into other languages.

The vB Statistic is free. However, if you would like to donate a small amount, feel free.

• Statistic Version 3 have more as 7000 Lines of code and possibly, one of the largest Hacks that was ever written for vBulletin.
• More as 450 different images
• 46 new Templates are provided
• More than 350 phrases are needed.
• Everything is completely adjustable over the AdminCp
• More than 350 phrases are needed.
• No much server load. Maximally 5 querys for logging. (normal 3 querys.)
• The start side of the statistics needs approx. 15 querys (only if this is indicated)
• More than 350 phrases are needed.
• Possibility for later updates (e.g. new Spider and Crawler implements)
• The installation is very, very simply, been made by an installscript and does not need more than 30 seconds. All attitudes and changes take maximally 5 minutes.
• no changes of the existing vBulletin data base tables
• 15 new data base tables with more than 1100 inserts are provided
• Support for international time formats implements.
• Detect now browser plugins, resolutions and more with javascript.
• vB Statistic Version 3 show Information about your System on a special side.
• Detect now browser plugins, resolutions and more with javascript

More Infos soon
PcFreak

[Ian Emu-UK]

Originally Posted by Onkel_Tom

Sorry, it's not the PHP version !
We need the MySQL Version

I've never tried to name a database with "-", mine are always with "_" in the name and it works.

Do you use also table prefixes for your tables ?
You can try this:

find in statistik.php:

LIKE 'pm'

and replace it with:

LIKE " . TABLE_PREFIX . "'pm'

MySQL on my test home server is the latest, and on my site server it's 4.0.16.

It still said the same after I altered the part you said to, but I removed the "FROM $dbname" bit from the query and now it works and gives the size for the PM table.

Is that part un-needed or will I run into problems having removed it at some point?

Thanks for your help Onkel_Tom

[Onkel_Tom]

Originally Posted by Ian Emu-UK

... I removed the "FROM $dbname" bit from the query and now it works and gives the size for the PM table.

Is that part un-needed or will I run into problems having removed it at some point?

This is not a problem because we are still in this database. The MySQL syntax mentioned to give the database with this command but if we are not outside this db it's not a problem
I will fixed this also in the next release !

Thanks for your help to get this hack working

Hope more people will install this hack and give a click in the "hack of the month August " section for this very nice work from PcFreak.

[iceman-x]

Database error in vBulletin 3.0.3:

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

mysql error number: 1146

Date: Sunday 22nd of August 2004 03:33:14 PM

The table fix workt perfekt. but now i goth a new problem. it keep looking for the old tabel. I tryed to deleted alle the tabel. and reinstalled. but dident work.

It look like the statistik work. the error apers when i am trying to enter the admin opitons. "statistikadmin.php?do=statistik_general"

[iceman-x]

Found the ansvare to the problem. In the "statistikadmin.php"

i canged this..

Find this

	$statistikaktiv = $DB_site->query("
		SELECT Summe as Datum
		FROM statistik_zaehler
		WHERE Zaehler_fuer = 'Statistik_Aktiv'
        ");

and replaced whit this.

	$statistikaktiv = $DB_site->query("
		SELECT Summe as Datum
		FROM " . TABLE_PREFIX . "statistik_zaehler
		WHERE Zaehler_fuer = 'Statistik_Aktiv'
        ");

and then it works fine.

thanks for all the help.

[Wential]

I took a few hours and worked through all the MySQL errors and it seems to work except for Browser & Operating System Stats. See my attachment. I know not EVERYONE is using "Other" for a browser. Did I miss something on the install?

[Onkel_Tom]

@ Iceman-X

thanks for the hint of another missing table_prefix

@ Wential
Browsers and OS are identified from the file /includes/functions_statistik.php so please check if this file is in that directory.
In that file the the Browsers are identified by getenv("HTTP_USER_AGENT") and a listing with the Browsernames.

Is only Browsertyp and OS version not identified by the statistics ?

[Wential]

Ah, I missed replacing the " . TABLE_PREFIX . " with vb3_ in that file. Hopefully it will start showing up now. And yes, that was the only part that wasn't filling in with data. You're assistance is much appreciated.

[Onkel_Tom]

Your welcome

If the script still not identify the browsers and OS try this.

open file functions_statistik.php from Directory /includes and find:

$agent = getenv("HTTP_USER_AGENT");

replace it with this syntax:

$agent = $_SERVER['HTTP_USER_AGENT'];

for the $_SERVER Syntax you must have at least php 4.1.0 installed on your server

[Wential]

The first solution didn't work after waiting an hour. I'm trying your second $_SERVER fix now. I'm running MYSQL 4.0.18 and PHP 4.3.6 so hopefully it will work. I hope it's not a problem that I run my own local Windows 2003 servers on a dedicated T-3 line. You wouldn't believe how many things (VB related) are designed around Apache. Yuck!

[Wential]

Darn that was fast. It works perfectly now! Onkel Tom, you're a genius!