NICE!
GJ, ale mel bych par vylepseni... napriklad se mi nelibi ta tabulka a spousteni nejakeho *.bat
Tady je kod, co "by mel fachat" (moc jsem netestoval ) bez te tabulky; generuje staty rovnou z db
<?php
$host="localhost"; //adresa k MySQL serveru
$name="root"; //pristupove jmeno
$pass=""; //heslo
$db="mangos"; //nazev databaze MaNGOSu
$img_base = "img/"; //slozka s obrazky
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1250">
<LINK id=bnetstyle href="style.css" type=text/css rel=stylesheet>
<title>
Statistika postav
</title></head>
<body>
<br><br><br><br><center>
<?php
$bgart="#252525";
$bgart2="#000000";
// Race value is index in ChrRaces.dbc
define ('RACE_HUMAN', 1);
define ('RACE_ORC', 2);
define ('RACE_DWARF', 3);
define ('RACE_NIGHTELF', 4);
// if it needs be to official, it's actually SCOURGE acording to the story/.dbc
define ('RACE_UNDEAD_PLAYER', 5);
define ('RACE_TAUREN', 6);
define ('RACE_GNOME', 7);
define ('RACE_TROLL', 8);
define ('MAX_RACES', 9);
// officially, this exists but was never taken into use.. neutral faction which could
// learn some skills/spells from horde/alliance. maybe it'll be of some use later on.
define ('RACE_GOBLIN', 9);
// Class value is index in ChrClasses.dbc
define ('CLASS_WARRIOR', 1);
define ('CLASS_PALADIN', 2);
define ('CLASS_HUNTER', 3);
define ('CLASS_ROGUE', 4);
define ('CLASS_PRIEST', 5);
//unused define ('CLASS_UNK1', 6);
define ('CLASS_SHAMAN', 7);
define ('CLASS_MAGE', 8);
define ('CLASS_WARLOCK', 9);
//unused define ('CLASS_UNK2', 10);
define ('CLASS_DRUID', 11);
define ('MAX_CLASSES', 12);
$race = array();
$class = array();
//konec premennych
$link = mysql_connect($host,$name,$pass)
or die('Could not connect: ' . mysql_error());
//echo 'Connected successfully';
mysql_select_db($db, $link) || die('Could not select database');
$sql = "SELECT `race`, COUNT( * ) AS r_c FROM `character` GROUP BY `race`;";
$res = mysql_query($sql, $link);
$res || die('Query failed: ' . mysql_error() );
//check if table isn't empty (only this time)
if ( mysql_num_rows($res) == 0 )
{
echo "No rows found, nothing to print so am exiting";
exit;
}
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) $race[$row['race']] = $row['r_c'];
$sql = "SELECT `class`, COUNT( * ) AS c_c FROM `character` GROUP BY `class`;";
$res = mysql_query($sql, $link);
$res || die('Query failed: ' . mysql_error() );
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) $class[$row['class']] = $row[c_c];
//matika
$aliance = $race[RACE_HUMAN] + $race[RACE_DWARF] + $race[RACE_GNOME] + $race[RACE_NIGHTELF];
$horda = $race[RACE_ORC] + $race[RACE_UNDEAD_PLAYER] + $race[RACE_TAUREN] + $race[RACE_TROLL];
$postav = $aliance + $horda;
$ali_p = round($aliance / $postav,4)*100;
$hor_p = round($horda / $postav,4)*100;
$huma = round($race[RACE_HUMAN] / $aliance,4)*100;
$dwaf = round($race[RACE_DWARF] / $aliance,4)*100;
$gnom = round($race[RACE_GNOME] / $aliance,4)*100;
$elf = round($race[RACE_NIGHTELF] / $aliance,4)*100;
$orc = round($race[RACE_ORC] / $horda,4)*100;
$taur = round($race[RACE_TAUREN] / $horda,4)*100;
$unde = round($race[RACE_UNDEAD_PLAYER] / $horda,4)*100;
$trol = round($race[RACE_TROLL] / $horda,4)*100;
$warr = round($class[CLASS_WARRIOR] / $postav,4)*100;
$pala = round($class[CLASS_PALADIN] / $postav,4)*100;
$hunt = round($class[CLASS_HUNTER] / $postav,4)*100;
$roug = round($class[CLASS_ROGUE] / $postav,4)*100;
$prie = round($class[CLASS_PRIEST] / $postav,4)*100;
$sham = round($class[CLASS_SHAMAN] / $postav,4)*100;
$mage = round($class[CLASS_MAGE] / $postav,4)*100;
$warl = round($class[CLASS_WARLOCK] / $postav,4)*100;
$drui = round($class[CLASS_DRUID] / $postav,4)*100;
echo "<font class=\"title\">Statistika postav (celkem $postav)</font><br><br><br>";
//aliance
echo "<table width=\"450\" border=\"0\" rowspan=\"1\" colspan=\"2\"><tr><td>
<table width=\"90%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"left\" bgcolor=\"black\" ID=\"ramecek\"><tr><td>
<table width=\"100%\" cellspacing=\"2\" cellpadding=\"1\" class=\"stat_tab\">
<tr><td colspan=\"4\" class=\"hlavicka\">Aliance</td></tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/1-0.gif\"></td><td class=\"kategorie\"> Human</td>
<td class=\"cislo\">{$race[RACE_HUMAN]}</td><td class=\"cislo\">$huma%</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/3-0.gif\"></td><td class=\"kategorie\"> Dwaft</td>
<td class=\"cislo\">{$race[RACE_DWARF]}</td><td class=\"cislo\">$dwaf%</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/7-0.gif\"></td><td class=\"kategorie\"> Gnome</td>
<td class=\"cislo\">{$race[RACE_GNOME]}</td><td class=\"cislo\">$gnom%</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/4-0.gif\"></td><td class=\"kategorie\"> Elf</td>
<td class=\"cislo\">{$race[RACE_NIGHTELF]}</td><td class=\"cislo\">$elf%</tr>
<tr bgcolor=\"$bgart\" height=\"40\"><td bgcolor=\"$bgart2\"></td><td><font class=\"celkem\"> CELKEM </td>
<td class=\"procenta\">$aliance</td><td class=\"procenta\">$ali_p%</tr></table>
</td></tr></table></td>";
//horda
echo "<td>
<table width=\"90%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" align=\"right\" bgcolor=\"black\" ID=\"ramecek\"><tr><td>
<table width=\"100%\" cellspacing=\"2\" cellpadding=\"1\" class=\"stat_tab\">
<tr><td colspan=\"4\" class=\"hlavicka\">Horda</td></tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/2-0.gif\"></td><td class=\"kategorie\"> Orc</td>
<td class=\"cislo\">{$race[RACE_ORC]}</td><td class=\"cislo\">$orc%</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/6-0.gif\"></td><td class=\"kategorie\"> Tauren</td>
<td class=\"cislo\">{$race[RACE_TAUREN]}</td><td class=\"cislo\">$taur%</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/5-0.gif\"></td><td class=\"kategorie\"> Undead</td>
<td class=\"cislo\">{$race[RACE_UNDEAD_PLAYER]}</td><td class=\"cislo\">$unde%</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/8-0.gif\"></td><td class=\"kategorie\"> Troll</td>
<td class=\"cislo\">{$race[RACE_TROLL]}</td><td class=\"cislo\">$trol%</tr>
<tr bgcolor=\"$bgart\" height=\"40\"><td bgcolor=\"$bgart2\"></td><td><font class=\"celkem\"> CELKEM </td>
<td class=\"procenta\">$horda</td><td class=\"procenta\">$hor_p%</tr></table>
</td></tr></table>
</td></tr></table>";
//povolani
echo "<table style=\"margin-top:50px\" align=\"center\" width=\"200\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\" align=\"left\" bgcolor=\"black\" ID=\"ramecek\"><tr><td>
<table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"1\" class=\"stat_tab\">
<tr bgcolor=\"$bgart1\"><td colspan=\"4\" class=\"hlavicka\">Povolání</td></tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/1.gif\"></td><td class=\"kategorie\"> Warrior</td>
<td class=\"cislo\">{$class[CLASS_WARRIOR]}</td><td class=\"cislo\">$warr%</td>
</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/2.gif\"></td><td class=\"kategorie\"> Paladin</td>
<td class=\"cislo\">{$class[CLASS_PALADIN]}</td><td class=\"cislo\">$pala%</td>
</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/3.gif\"></td><td class=\"kategorie\"> Hunter</td>
<td class=\"cislo\">{$class[CLASS_HUNTER]}</td><td class=\"cislo\">$hunt%</td>
</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/4.gif\"></td><td class=\"kategorie\"> Rogue</td>
<td class=\"cislo\">{$class[CLASS_ROGUE]}</td><td class=\"cislo\">$roug%</td>
</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/5.gif\"></td><td class=\"kategorie\"> Priest</td>
<td class=\"cislo\">{$class[CLASS_PRIEST]}</td><td class=\"cislo\">$prie%</td>
</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/7.gif\"></td><td class=\"kategorie\"> Shaman </td>
<td class=\"cislo\">{$class[CLASS_SHAMAN]}</td><td class=\"cislo\">$sham%</td>
</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/8.gif\"></td><td class=\"kategorie\"> Mage</td>
<td class=\"cislo\">{$class[CLASS_MAGE]}</td><td class=\"cislo\">$mage%</td>
</tr>
<tr bgcolor=\"$bgart1\"><td><img src=\"$img_base/9.gif\"></td><td class=\"kategorie\"> Warlock</td>
<td class=\"cislo\">{$class[CLASS_WARLOCK]}</td><td class=\"cislo\">$warl%</td>
</tr>
<tr bgcolor=\"$bgart\"><td><img src=\"$img_base/11.gif\"></td><td class=\"kategorie\"> Druid</td>
<td class=\"cislo\">{$class[CLASS_DRUID]}</td><td class=\"cislo\">$drui%</td>
</tr></table>
</td></tr></table>";
?>
</body>
</html>