vb3 Statistic Version 1.01

vb3 Statistic

Many people had ask me when i release this hack?

The problem is, my english is bad and its hard for me, write a installations text.
So everyone feel free to help me with the instructions.

A live demo you found:
http://at-lantis.de/statistik.php

OK. Now we come to the hack.

Please make a backup of your database, before installing this hack

This hack will show you an extra side with some Stats.

- show Summary stats
- show the Browser/Os System of the users
- show the countrys (countrys by Hoster and Countries by browserlanguage)
- show the last 10 threads
- show the last 20 top referers
- show spiders and crawlers
- Forum book of records (new)
- Statistic for the last ten days (new)

and many, many other interesting counts

Files to edit
Just one template

New files
4 new php files
6 templates
a lot (but very small) images

Database changes
six new tables

I will try to give support for this hack

BIG UPDATE ( to version 1.01)

Upload a new zipfile 11. June 2004
Reason
I have fix some bugs

The images Bhutan will show now. (If you install the old version you must change in table _statistik_laender under id 31 the flagge_link for Bhutan from images/statistik/flaggen/butan.gif to images/statistik/flaggen/bhutan.gif manuelly)
some templates are optimzed (Thank you obsidian and Zelda King)
I have modified the code for the last 10 threads (thanks go to Mystics from vBulletin Germany)
Now theads just show from the forum ids for all forums user is allowed to view.
fix some other little bugs

PcFreak

New

Statistic Version 2.0 is finish.
I will release the new version later this day.
I give no more support for the Version 1.01.

[insanctus]

Looks interesting, I will click install and try her out.

[bigreefer]

Sorry but i Have many SQL Errors.

one example

SQL-Befehl :  

CREATE TABLE _statistik_zaehler(

Zaehler_f?r varchar( 80 ) NOT NULL default '',
Summe int( 10 ) NOT NULL default '0',
PRIMARY KEY ( Zaehler_f?r ) 
) TYPE = MYISAM COMMENT = 'Zaehler f?r Hits, Besucher, ect...' 

MySQL meldet: 


#1064 - 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 '?r varchar(80) NOT NULL default '',
          Summe int(10) NOT NULL

don?t use ? ? ?

I have change it to "ue" but if I go to http//www.mydomain.de/statistik.php
It shwow me this

Datenbankfehler in vBulletin 3.0.1:

Ungueltige SQL-Abfrage: 
			UPDATE  _statistik_zaehler 
			SET Summe = Summe+1
			WHERE Zaehler_f?r  = 'Anzahl_der_Besucher'
		
mysql error: Unknown column 'Zaehler_f?r' in 'where clause'

mysql error number: 1054

Datum: 07.06.2004 22:21:13
Skript: http://www.celebritymarkt.de/statistik.php
Referer: 
Benutzername: Snatch
IP-Adresse: 213.23.58.187

I have change Zaehler_f?r to Zaehler_fuer in all files. No it runs and Big clicks install

[bigreefer]

I have one more problem,

the statistik line is too long, is there a way to make this short ?
I must scroll very mutch, thas not so good :disappointed:

[PcFreak]

@bigreefer

you have forgot this spell " ;" after ect...'; <-

PHP Code:

CREATE TABLE _statistik_zaehler (
          Zaehler_f?r varchar(80) NOT NULL default '',
          Summe int(10) NOT NULL default '0',
          PRIMARY KEY  (Zaehler_f?r)
        ) TYPE=MyISAM COMMENT='Zaehler f?r Hits, Besucher, ect...'; 


The other problem.
Search in statistik.php for

PHP Code:

    $alle_avantars    =    number_format($alle_avantars['avantar']);                                    //Alle Benutzer mit Avantar 


replace it with

PHP Code:

    $alle_avantars    =    intval($alle_avantars['avantar']);                                    //Alle Benutzer mit Avantar 


and found

PHP Code:

    $alle_profilpics    =    number_format($alle_profilpics['profilpic']);                            //Alle Benutzer mit Profilbild 


replace it with

PHP Code:

    $alle_profilpics    =    intval($alle_profilpics['profilpic']);                            //Alle Benutzer mit Profilbild 


I hope this will help.

PcFreak

[PcFreak]

Some database don´t work with Umlauds (Ä,Ö, Ü) ect.
I had change a little bit code and the querys witch has use umlauts (Zaehler_für is now Zaehler_fuer)
Sorry for this mistake (zip.file is update)

[Logikos]

/me installs!!!

Thanks!!!

[Vivi Ornitier]

where's sms.php????

[Vivi Ornitier]

actually now that i look at the statistik.php code, those changes were already made but it is still stretching the tables.

[PcFreak]

Originally Posted by Vivi Ornitier

actually now that i look at the statistik.php code, those changes were already made but it is still stretching the tables.

Whitch table is stretching ?
I think i can hlep.

PcFreak

PS; Sorry, i mean statistik.php

[templates911]

Is there any way this would work with vB 3.0? I havn't upgraded yet and dont plan to until more changes are made that what was in the last upgrade.