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

[gmarik]

Great, really cool.
Is therea any stats for vistitors by
- hours
- days of week too?

[Sam FT]

Ok I had the old Stats 1.0 hack. Removed it completly. Install the new Stats 2.0 hack as writing. So when I go to the statistik.php file, I get this database error

  
  Invalid SQL: 
      	SHOW TABLE STATUS
      	FROM full-throttle_us_-_vb
      	LIKE 'pm'
      	 
  mysql error: You have an error in your SQL syntax near '-throttle_us_-_vb
      	LIKE 'pm'
      	 ' at line 3
  
  mysql error number: 1064

[Battle_Ring]

i installed this and when i go to statistik.php i got this

Database error in vBulletin 3.0.2:

Invalid SQL: SELECT dateline, nuser FROM stats ORDER BY nuser DESC LIMIT 1
mysql error: Table 'chrisr_HipHopStreetz.stats' doesn't exist

mysql error number: 1146

Date: Saturday 03rd of July 2004 12:54:31 AM
Script: http://www.hip-hop-streetz.com/forums/statistik.php
Referer:
Username: Chris
IP Address: 12.27.184.129

[Maddrax]

Maddrax click install

[PcFreak]

@Battle_Ring

Sorry, but I can?t give help for your problem.
Because the table "stats" is a orginal table.

I have check the querie in the statistik.php. Cant found an error there.
I think there is a Problem with the TABLE_PREFIX

Found in the statistik.php

PHP Code:

//Tag mit den meisten Neu Registrierungen
    $getmostregister= $DB_site->query_first("SELECT dateline, nuser FROM " . TABLE_PREFIX . "stats ORDER BY nuser DESC  LIMIT 1");
    $getmostregister_tag = vbdate($vboptions['dateformat'], $getmostregister['dateline']);
    $getmostregister_user = $getmostregister['nuser']; 


and replace tihs code with this

PHP Code:

//Tag mit den meisten Neu Registrierungen
     //$getmostregister= $DB_site->query_first("SELECT dateline, nuser FROM " . TABLE_PREFIX . "stats ORDER BY nuser DESC  LIMIT 1");
    //$getmostregister_tag = vbdate($vboptions['dateformat'], $getmostregister['dateline']);
    //$getmostregister_user = $getmostregister['nuser']; 


Open the statistic side from your forum.
Tell me what is happen.

@Sam FT
hmm.

This is a normal query.
At the moment, i dont know why do you get a mysql error.
This is the orginal query

PHP Code:

SHOW TABLE STATUS
        FROM $dbname
        LIKE 'pm' 


PcFreak

[Scrub]

Nevermind. The table is a defualt. . Stupid me.

Guess I am off to get into his cpanel and figure out if it is missing or if it is the table prefix.

Edit: Weird. He does not have the table by defualt.

[PcFreak]

I need the drop tables, because i have relaese this hack in two different languages. Some of the tables have different inserts e.g the statistik_laender table.

There are two different installation routines (and i must check both)
Thats the reason for the "drops".

PcFreak

[Scrub]

Updated. . Well, it was because of that. He did not have the stats table. O_o. But anyway, this is pretty neat hack! Wish I had a public forum to add this to. . Keep up the good work!

[orca]

Well, I don't know wether anyone of you uses table_prefixes. But on my board I use them and because of that, the installation script was giving errors. After fixing I had the problem ith all other scripts.

[Sam FT]

Originally Posted by PcFreak

@Sam FT
hmm.

This is a normal query.
At the moment, i dont know why do you get a mysql error.
This is the orginal query

PHP Code:

SHOW TABLE STATUS
         FROM $dbname
         LIKE 'pm' 


PcFreak

Well I am and when I run that query in mysql I still get the same error. So it is something in the query because I check all the pm tables to make sure there wasn't any bad with them.