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

[oldfan]

jesus murphy...
nothing but database errors, I've run 100's of installs and never had this many problems
/me clicks un-install again

[integra99]

I installed this hack the first time, no problems.

[oldfan]

I've found out its not working for me because my prefix is vB3 not vB3_, the installer doesn't recognize other prefixes.

[Onkel_Tom]

Okay, here we go....

I'm using this hack also on my Forum and do some bugfixing in the german vBulletin Forum for this hack. I saw this thread here in at vBulletin.com yesterday night and found a lot of questions, problems and db errors, so I decided today to do a complete rework of this hack from my installed german version to a new english Version.
I worked now 8 hours on this hack and hope that most of the bugs are fixed

All changes from this forum and also from the german one are implemented in my new version.
So I also will give further support for this hack if using my new files for install.

Please read the installation instruction to see what is changed and work carefully through it to get this hack work.

have fun

@ oldfan
the name of the tableprefix is defined in the file config.php with $tableprefix, so the install script only reads the prefix name from there and installs your tables like that name.


After additional 6 hours with installing this hack in a new Testboard I found again several bad translations and also again some german words
Also 2 db queries has wrong syntax for prefixed tables again !

If you found misspelling or bugs please let me know that I can fix the download.

for a updated zip file please look some posts later

[iceman-x]

I keep geting the same problem over and over.

Database error in vBulletin 3.0.3:

Invalid SQL: 
INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

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

mysql error number: 1146

Date: Sunday 22nd of August 2004 07:54:20 AM
Script: http://www.xxxxxxx.xxxxxxxxxx.com/admincp/install_statistik_english.php
Referer:

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

Yes i have downloaded the new versjon of the Onkel_tom fix.

thanks for any help.

[Ian Emu-UK]

Originally Posted by Onkel_Tom

Okay, here we go....

I'm using this hack also on my Forum and do some bugfixing in the german vBulletin Forum for this hack. I saw this thread here in at vBulletin.com yesterday night and found a lot of questions, problems and db errors, so I decided today to do a complete rework of this hack from my installed german version to a new english Version.
I worked now 8 hours on this hack and hope that most of the bugs are fixed

All changes from this forum and also from the german one are implemented in my new version.
So I also will give further support for this hack if using my new files for install.

Please read the installation instruction to see what is changed and work carefully through it to get this hack work.

Thanks Onkel_Tom, used your fixed version and it's fine.

I still get a problem with the bit "like 'pm'" saying invalid SQL, but it works fine if I comment that bit out.

[Onkel_Tom]

@ Ian Emu-UK

Which PHP Version do you have ? < 3.23 ?
The Show Table syntax is working from V 3.23 and higher:
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']

You can also have a look at http://dev.mysql.com/doc/mysql/en/SH...LE_STATUS.html to read the documentation of MySQL


@ iceman-x

You are right ! There was again a table prefix missing in the install script "install_statistik_english.php"
Search for:

INSERT INTO statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

and replace it with:

INSERT INTO " . TABLE_PREFIX . "statistik_einstellungen VALUES (0, 900, '', 10, 10, 10, 5, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10)

or just download the updated zip file 3 posts before

[Ian Emu-UK]

Originally Posted by Onkel_Tom

@ Ian Emu-UK

Which PHP Version do you have ? < 3.23 ?
The Show Table syntax is working from V 3.23 and higher:
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern']

You can also have a look at http://dev.mysql.com/doc/mysql/en/SH...LE_STATUS.html to read the documentation of MySQL

PHP is 4.3.2 on the server.

Looking at the error message, it might be because the host has put an - in the database name. (In truth I have no idea though as I know very little about SQL)

Invalid SQL: 
	SHOW TABLE STATUS
	FROM total-em_forum
	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 '-em_forum
	LIKE 'pm'' at line 2

I'm sure I can live without it though

One translation hasn't been done that I've spotted so far:

The last 10 Searchwords (Big Brother ist watching you)

Should be (Big Brother is watching you) but I kinda like it the way it is so I'll be keeping it that way on my forum

[oldfan]

whoo thank Onkel_Tom!!!
I'll give it a test run later night, I'll let you know how things turned out

Thanks!!

[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'