// the following script was authored by Tilo "Cnegurozka" Peter
and modified by Robin "Eisbaer" Grajeda. 

// script reads from mysql database and writes to html page, to be
used in conjunction with 1st script that read from log files

//script should be named makestats-b61.php, remove space in opening
php statement on line 2
 
< ?php
//draw_stats("52");
draw_stats("61");
//draw_stats("71");
//draw_stats("11");

function draw_stats($version)
{
	$headbg = "949cce";
	$userbg = "949cce";

	$sql_db = "cs_61stats";
	$sql_user = "root";
	$sql_host = "127.0.0.1:3306";
	$sql_pass = "essentrix6903";
	$sqltable_players = "player";
	$sqltable_maps = "maps";
	$sqltable_weapons = "weapons";
	$sqltable_kills = "kills";
	$sqltable_wpn_types = "wpn_types";

	mysql_connect($sql_host,$sql_user,$sql_pass);
	@mysql_select_db($sql_db) or die("Unable to select database");
	
	echo "

		< body bgcolor=bdc6de>		
		< br>
		< map name=\"menu\">
        < area shape=\"rect\" coords=\"0,1,98,27\"    href=\"http://eisbaer.essentrix.net/right.html\" target=\"right\">
        < area shape=\"rect\" coords=\"99,1,192,27\"  href=\"http://eisbaer.essentrix.net/news.html\" target=\"right\">
        < area shape=\"rect\" coords=\"193,1,288,27\" href=\"http://eisbaer.essentrix.net/servers.html\" target=\"right\">
        < area shape=\"rect\" coords=\"289,1,382,27\" href=\"http://eisbaer.essentrix.net/install.html\" target=\"right\">
        < area shape=\"rect\" coords=\"383,1,476,27\" href=\"http://eisbaer.essentrix.net/maps.html\" target=\"right\">
        < area shape=\"rect\" coords=\"477,1,570,27\" href=\"http://eisbaer.essentrix.net/files.html\" target=\"right\">
        < area shape=\"rect\" coords=\"571,1,664,27\" href=\"http://eisbaer.essentrix.net/about.html\" target=\"right\">
        < area shape=\"rect\" coords=\"665,1,762,27\" href=\"http://eisbaer.essentrix.net/contact.html\" target=\"right\">
        < img vspace=0 hspace=0 border=0 width=762 height=28 src=\"images/image_map.jpg\" usemap=\"#menu\">

		< table>
		< tr bgcolor=\"#bdc6de\">
		< td width=755>
		< font color=\"#bdc6de\" size=1>oldschool counter-strike, old school counter-strike, oldschool cs, 
		retro-cs, retro counter-strike, langames.net, hl downgrader, classic cs, setup counterstrike beta, 
		betas
		
		

		< table>
		< tr bgcolor=\"#bdc6de\">
		< td width=755>< img src=\"images/stats_x.jpg\">
		
	
		< font color=\"#bdc6de\" size=1>beta counter-strike, counter-strike beta, counter-strike beta 6, 
		setup counter-strike beta 6.1, counter-strike betas, cs beta, cs betas, beta 5.2, beta 3.1, 
		beta 1.1, cs, counter-strike beta 5.2, counter-strike beta 3.1 setup half-life linux server, 
		setup counter-strike linux server, half-life 1016, half-life 3016, dedicated server, valve, won2, hlds
		
		
		< table>
		< tr bgcolor=\"949cce\">
		< td width=757>< b> PLAYER STATS CS BETA 6.1     
		

		< br>
		
		< table border=\"0\" width=\"100%\" bordercolor=\"#949cce\" bgcolor=\"#bdc6de\" cellspacing=\"2\" cellpadding=\"0\">	
		< tr>
		< th bgcolor=\"949cce\">Player Name
		< th bgcolor=\"949cce\">Kills
		< th bgcolor=\"949cce\">Deaths
		< th bgcolor=\"949cce\">Kills/Deaths < br> Ratio
		< th bgcolor=\"949cce\">Part of total kills
		
	";

	$query = "SELECT * FROM $sqltable_players ORDER BY ct_kills DESC, ct_deaths DESC, ratio DESC";
	$result = mysql_query($query);
	$num = mysql_numrows($result);
	$i = 0;
	$total_kills = 0;
	$graybg = true;

	while ($i < $num)
	{
		$id = mysql_result($result,$i,"id");
		$uid= mysql_result($result,$i,"uid");
		$name = mysql_result($result,$i,"name");
		$nick = mysql_result($result,$i,"nick");
		$ct_kills = mysql_result($result,$i,"ct_kills");
		$ct_deaths = mysql_result($result,$i,"ct_deaths");
		$ratio = mysql_result($result,$i,"ratio");
		$kills_part = mysql_result($result,$i,"kills_part");
		$total_kills = $total_kills + $ct_kills;

		if ($kills_part >= 0)
		{
			if ($graybg)
			{
				echo "< tr bgcolor=#$userbg>";
				$graybg = false;
			} else
			{
				echo "< tr>";
				$graybg = true;
			}

			echo "
				< td bgcolor=\"949cce\">$name
				< td bgcolor=\"949cce\">$ct_kills
				< td bgcolor=\"949cce\">$ct_deaths
				< td bgcolor=\"949cce\">$ratio
				< td bgcolor=\"949cce\">$kills_part%
				
			";
		}

		$i++;

	}

	echo "
		< table>
		< br>
		< tr bgcolor=\"949cce\">
		< td width=757>< b>Total kills: $total_kills
		
	
		< table>
		< br>
		< tr bgcolor=\"949cce\">
		< td width=757>< b> WEAPON STATS FOR CS BETA 6.1     
		

		< br>

		< table border=\"0\" width=\"100%\" bordercolor=\"#bdc6de\" bgcolor=\"#bdc6de\" cellspacing=\"2\" cellpadding=\"0\">	
		< tr>
		< th bgcolor=\"949cce\">Weapon Name
		< th bgcolor=\"949cce\">Kills/< br>Weapon
		< th bgcolor=\"949cce\">Part of total kills
		
	";

	$query = "SELECT * FROM $sqltable_weapons ORDER BY ct_kills DESC";
	$result = mysql_query($query);
	$num = mysql_numrows($result);
	$i = 0;
	$graybg = true;

	while ($i < $num)
	{
		$id = mysql_result($result,$i,"id");
		$name = mysql_result($result,$i,"name");
		$ct_kills = mysql_result($result,$i,"ct_kills");
		$kills_part = mysql_result($result,$i,"kills_part");

		if ($graybg)
		{
			echo "< tr bgcolor=#$userbg>";
			$graybg = false;
		} else
		{
			echo "< tr>";
			$graybg = true;
		}

		echo "
			< td bgcolor=\"949cce\">$name
	       		< td bgcolor=\"949cce\">$ct_kills
			< td bgcolor=\"949cce\">$kills_part%
			
		";

		$i++;
	}
	echo " 
	
	< br>
	
	< table>
	< tr bgcolor=\"949cce\">
	< td width=757> © 2013  
	< a href=\"http://eisbaer.essentrix.net\">BACK TO SITE   	
	
	< br>";

}
?>