<?php
ob_start("ob_gzhandler");

$mangosdbhost = 'xx.xx.xx.xx';
$mangosdbuser = 'xxx';
$mangosdbpass = 'yyy';
$dbchar = 'zzz';

echo '<style>td {font-size:12px;border:1px solid black;font-family:Arial, Helvetica, sans-serif;}</style><table cellspacing="2" cellpadding="3"><tr><td>guID</td><td>Imie</td><td>Rasa / Klasa</td><td>Spell bonus dmg</td><td>Spell bonus heal</td><td>Spell heal/dmg roznica</td><td>Melee AP</td><td>Ranged AP</td><td>Melee crit %</td><td>Ranged crit %</td><td>Spell crit %</td></tr>';

if(mysql_connect($mangosdbhost, $mangosdbuser, $mangosdbpass) and mysql_select_db($dbchar)) {

function przelicz($a) {
$a = unpack("f", pack("L", $a));
$a = round($a[1], 2);
return $a;
}

function rasa($a) {
switch($a) {
case '1': {$b = 'Human';break;}
case '2': {$b = 'Orc';;break;}
case '3': {$b = 'Dwarf';break;}
case '4': {$b = 'Night Elf';break;}
case '5': {$b = 'Forsaken';break;}
case '6': {$b = 'Tauren';break;}
case '7': {$b = 'Gnome';break;}
case '8': {$b = 'Troll';break;}
case '10': {$b = 'Blood Elf';break;}
case '11': {$b = 'Draenei';break;}
default: {echo 'Race error.';exit();break;}
} return $b;
}

function klasa($a) {
switch($a) {
case '1': {$b = 'Warrior';break;}
case '2': {$b = 'Paladin';break;}
case '3': {$b = 'Hunter';break;}
case '4': {$b = 'Rogue';break;}
case '5': {$b = 'Priest';break;}
case '6': {$b = 'Death Knight';break;}
case '7': {$b = 'Shaman';break;}
case '8': {$b = 'Mage';break;}
case '9': {$b = 'Warlock';break;}
case '11': {$b = 'Druid';break;}
default: {echo 'Class error.';exit();break;}
} return $b;
}

function spell($a,$b) {

if($a > $b) {
$c = $a-$b;
} elseif($a < $b) {
$c = $b-$a;
} else {
$c = '0';
}

if($c > 600) {
$c = '<b style="color:red;">'.$c.'</b>';
} elseif($c > 450) {
$c = '<b style="color:orange;">'.$c.'</b>';
}

return $c;
}

$dane = mysql_query("SELECT `guid`, `name`, `race`, `class`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1174), ' ', -1) AS UNSIGNED) AS `spellbonusdmg`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1193), ' ', -1) AS UNSIGNED) AS `spellbonusheal`, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 124), ' ', -1) AS UNSIGNED)+CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 125), ' ', -1) AS UNSIGNED)) AS `meleeAP`, (CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 127), ' ', -1) AS UNSIGNED)+CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 128), ' ', -1) AS UNSIGNED)) AS `rangedAP`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1030), ' ', -1) AS UNSIGNED) AS `critmelee`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1031), ' ', -1) AS UNSIGNED) AS `critranged`, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1035), ' ', -1) AS UNSIGNED) AS `critspell` FROM `characters` WHERE `logout_time` > '1254358800' ORDER BY `spellbonusdmg` DESC") or die('Blad query');

while($rekord = mysql_fetch_array($dane)) {
$rekord['kto'] = rasa($rekord['race']).' '.klasa($rekord['class']);
$rekord['critmelee'] = przelicz($rekord['critmelee']);
$rekord['critranged'] = przelicz($rekord['critranged']);
$rekord['critspell'] = przelicz($rekord['critspell']);
$rekord['spellroznica'] = spell($rekord['spellbonusheal'],$rekord['spellbonusdmg']);
echo '<tr><td>'.$rekord['guid'].'</td><td>'.$rekord['name'].'</td><td>'.$rekord['kto'].'</td><td>'.$rekord['spellbonusdmg'].'</td><td>'.$rekord['spellbonusheal'].'</td><td>'.$rekord['spellroznica'].'</td><td>'.$rekord['meleeAP'].'</td><td>'.$rekord['rangedAP'].'</td><td>'.$rekord['critmelee'].'</td><td>'.$rekord['critranged'].'</td><td>'.$rekord['critspell'].'</td></tr>';
ob_flush();flush();
} unset($rekord,$dane);

mysql_close();
} else {echo '<td colspan = "10">Brak polaczenia z baza.</td>';}

echo '</table>';

?>