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

[alqafelah]

Gteat hack, but have error

PHP Code:

Database error in vBulletin :

Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1

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 'ORDER BY styleid ASC
    LIMIT 1' at line 4

mysql error number: 1064 


any idea?

[Onkel_Tom]

Originally Posted by alqafelah

Gteat hack, but have error

PHP Code:

Database error in vBulletin :

Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1

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 'ORDER BY styleid ASC
    LIMIT 1' at line 4

mysql error number: 1064 


any idea?

Sorry, but this code you mentioned is not from vB3 Boardstatistic Version 2 hack !
You get this error because there is no number after the "styleid = " command, but this not from statistic hack

[Wential]

Originally Posted by alqafelah

Gteat hack, but have error

PHP Code:

Database error in vBulletin :
 
Invalid SQL: 
    SELECT * FROM style
    WHERE (styleid = 0 AND userselect = 1)
        OR styleid = 
    ORDER BY styleid ASC
    LIMIT 1
 
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 'ORDER BY styleid ASC
    LIMIT 1' at line 4
 
mysql error number: 1064 


any idea?

What php file is this error from?

[alqafelah]

Onkel_Tom, thx for reply but i got this error in this hack only !

Wential, the Statistics home worked fine .. but the error got when i press on any of these links :

Overview | Browsers / Operating Systems | Countries of visitors | Searchrobots / Spiders | Last days | Referers / Top Level Domains | Polls / Stickys / Searchwords

thanx

[Onkel_Tom]

Hmm, we only use the variable styleid in the installation file to install all the Templates to the database. No where else this variable is used.

[Wential]

I tried to re-create this error and failed. It looks like something went wrong on the installation. Considering the number of Mods in your Forum, I'm not really surprised.

[Code Monkey]

Installed. Works great.

One question though. How is this affected by something like vbindex or the like? Since many visitors enter the site through the front page.

[Wential]

It is unaffected by VBindex since I use both hacks on my board and my stats are great!

[venomx]

Noone can help me?

[Code Monkey]

One thing I noticed in functions_statistik.php. You use ereg quite a bit. Such as.

PHP Code:

if(ereg("Opera", $agent)) $c_browser = "Opera"; 


More efficient would be to use PCRE functions.

PHP Code:

 if(preg_match('#Opera#', $agent)) $c_browser = 'Opera'; 


And since no regular expresions are really needed for this, far more efficient would be.

PHP Code:

if(strpos($agent, 'Opera')) $c_browser = 'Opera'; 


Anyway, thanks for the hack.