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

[Smitty]

You know spammers. Where there's a will...

I went through my logs and this is relatively new - a week or so for me. I went through the entire database fields domain & referrers and checked and dumped all entries. Now I'll watch for a while. But I am keeping that page 'restricted - That is I edited the template as I said above so where there are typically the stats it just says disabled due to URL spam bots. I assume it's really a person doing this rather than a script or bot but you never know.

[Trosun]

My stats still doesn't track googlebot.

I've changed the functions_statistik.php as Onkel Tom spesified in post #332

[Smitty]

Thankis for the tip!

[Takamine334]

Wish someone could answer my question

[PcFreak]

Originally Posted by Takamine334

Wish someone could answer my question

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

====================================================================
add the following code at the end of the template in the last line!:
====================================================================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

PcFreak

[eXtremeTim]

You really should learn to use left joins. Im using them right now to start to clean up the amt of queries in the arcade addon first since it was using 92. So far I have cut 92 down to 52. thats 4 queries per game you have listed that have now been cut out. I now have gotten the arcade addon page down to 16 queries no matter how many games you list be it 1 or a 100. Trust me I tested it. Im going to go through and see about doing the rest of this hack and see what I can get it down to.

If the author doesnt mind. I will post my current modified file for everyone.


This is when listing 10 games on the page.

When using inner joins it generates the page in the following time.
Page generated in 0.18413091 seconds (41.08% PHP - 58.92% MySQL) with 16 queries

Now using left joins it generates the page in the following time.
Page generated in 0.28608704 seconds (26.56% PHP - 73.44% MySQL) with 16 queries

Only problem with the inner join is that you can only use the conditionals when running mysql 3.23.17

I can release both versions thats no problem.


High Stress Load Test
Original Code set to display 1000 games:
Page generated in 2.45838499 seconds (26.88% PHP - 73.12% MySQL) with 3164 queries

Optimized Code Using inner join's displaying 1000 games:
Page generated in 0.50021791 seconds (78.25% PHP - 21.75% MySQL) with 16 queries

Optimized Code Using left join's displaying 1000 games:
Page generated in 0.67386508 seconds (68.22% PHP - 31.78% MySQL) with 16 queries

[PcFreak]

Originally Posted by eXtremeTim

You really should learn to use left joins.

Jepp.
Can you post or quote the optimized code, please?
Or better..., you release both versions with the code you used.

I am still learning php

PcFreak

[eXtremeTim]

Heres the fixed version of the statistics file. Use the inner join version first and if it does not work for you then please use the left join. There shouldn't be any problems with table prefix's in the code but if there are let me know so that I can fix them. You can see my demo here of this file working. I will see about what I can do to the other pages latter on. http://www.extremechatforums.com/forums/statistik.php

[Takamine334]

Originally Posted by PcFreak

Step 7)
=========
Now let's activate the statistics and count of visitors

Open Template "phpinclude_start" in your AdminCP

====================================================================
add the following code at the end of the template in the last line!:
====================================================================

//## vB Statistics by PcFreak Start ##

include("./statistik_counter.php");

// ## vB Statistics by PcFreak End ##

PcFreak

:up:

[Mark.B]

Originally Posted by eXtremeTim

Heres the fixed version of the statistics file. Use the inner join version first and if it does not work for you then please use the left join. There shouldn't be any problems with table prefix's in the code but if there are let me know so that I can fix them. You can see my demo here of this file working. I will see about what I can do to the other pages latter on. http://www.extremechatforums.com/forums/statistik.php

Using these I am finding the game's mini-image doesn't show up, it isn't pulling the right info as the image properties don't show a gif name. (As opposed to it being a filepath error).

[eXtremeTim]

Oh yes I fogot I made a template change also. Let me get the template for you as well. When I changed the query's it changed the variable for the miniimage.

[eXtremeTim]

Replace statistic_arcade_bit with the following html

<tr> 
	<td class="$bgclass"><div align="center"><img src="images/arcade/$letzte_spiele[miniimage]" alt="$spielname" width="20" height="20" border="0" /></div></td> 
	<td class="$bgclass"><div align="center"><a href="arcade.php?do=play&amp;gameid=$spielid">$spielname</a></div></td>
	<td class="$bgclass"><div align="center"><a href="member.php?u=$spielerid">$spielername</a></div></td>
	<td class="$bgclass"><div align="center">$spiel_beendet</div></td>
	<td class="$bgclass"><div align="center">$spielkommentar</div></td>
	<td class="$bgclass"><div align="center">$spieleergebnis</div></td>
	<td class="$bgclass"><div align="center"><strong><a href="member.php?u=$highscorerid">$highsorename</a></strong><br />
	  with <strong>$highscore</strong> Points</div></td>
</tr>

[PcFreak]

95% of my new vBulletin Boardstatistic Version 3 is finished.

Here some futures:

The new Boardstatistc Version 3

Detect vistor countries: 257
Detect Browserlanguages: 119
Detect Referer and Shortreferer (Domains)
Detect 17 different searchengines and log the keywords
Detect 291 Spider, Crawler and Searchrobots (work with the database of robots)
Detect Browser Plug Ins, resolutions, color depth, java and much more.
Show you all about the board (Topposters, most popular thread, threads without answers and many, many more)
Show all about the database (for example: show the attachment traffic and more)
More than 20 PopUps witch show more information
Found more about countries with Wikipedia (I have include a search function to the Wikimedia database)
Detect more then 50 different browser, more then 40 different os?s, WebService, and more then 20 WAP Browser
Make a systemcheck with the new Statistic (Show you all, what we can detect about your system)

a Live Demo your found here:

http://at-lantis.de/statistic.php

Now my little problem:
English is not my mother language. It?s very hard for me to translate this statistic in English.
The statistic is work with phrases. (will be imported in xml format).
All phrases are finished (not the phrases for the admincp).
Is there anybody whose want help me to translate them from german into other languages?

Would be really nicely


PcFreak

[Smitty]

Now you're gettng me excited! Will all the icons you have in your demo be part of it?

Great job!

[PcFreak]

Originally Posted by Smitty

Now you're gettng me excited! Will all the icons you have in your demo be part of it?

Great job!

Surely.
All icons are freeware.
I found the most of them here: http://www.iconarchive.com/

PcFreak