$severities[$GLOBALS['SEVERITY_HIGH']] = "#F80000";
$colors[$GLOBALS['SEVERITY_NORMAL']] = "black";
$colors[$GLOBALS['SEVERITY_MEDIUM']] = "black";
$colors[$GLOBALS['SEVERITY_HIGH']] = "yellow";
echo "<BODY style='background-color:{$severities[$row['severity']]}; text-color: {$colors[$row['severity']]};' onload = 'ck_frames();' >";
/* Creates statistics header and details of responding and en-route units 7/29/09 */
$result_dispatched = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `dispatched` IS NOT NULL AND `responding` IS NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_dispatched = mysql_num_rows($result_dispatched);
$result_responding = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `responding` IS NOT NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_responding = mysql_num_rows($result_responding);
$result_on_scene = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `on_scene` IS NOT NULL AND `clear` IS NULL");
$num_rows_on_scene = mysql_num_rows($result_on_scene);
$result_cleared = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `clear` IS NOT NULL");
$num_rows_cleared = mysql_num_rows($result_cleared);
$end_date = is_date($row['problemend']) ? totime($row['problemend']) : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($end_date, totime($row['problemstart']));
// integer values req'd - 3/12/10
$stats = "<B>Severity: {$ticket_severity}, <SPAN STYLE='background-color:white; color:black;'> age: {$elapsed} </SPAN>";
echo $stats;
echo "<BR>Units dispatched: ({$num_rows_dispatched}) ";
while ($row_base = mysql_fetch_array($result_dispatched, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
echo "<BR>Units responding: ({$num_rows_responding}) ";
while ($row_base = mysql_fetch_array($result_responding, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
$timee /= 60;
if ($timee == 0) {
return $min . "m " . $sek . "s";
}
return $timee . "h " . $min . "m " . $sek . "s";
}
// Nick oraz id, level, czas, zabójstwa, zgony
$query = "SELECT * FROM `players` WHERE `name`='" . $player . "'";
$result = mysql_query($query) or die('Nie działa');
while ($result_row = mysql_fetch_row($result)) {
$id = $result_row[0];
$nick = $result_row[1];
$lvl = $result_row[16];
$zab = $result_row[6];
$zgo = $result_row[7];
$czas = totime($result_row[33]);
}
// Pieniądze
$query = "SELECT * FROM `iConomy` WHERE `username`='" . $player . "'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
$kasa = 'biedak';
} else {
while ($result_row = mysql_fetch_row($result)) {
$kasa = $result_row[2];
}
}
//zawód
$query = "SELECT * FROM `jobs` WHERE `username`='" . $player . "'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
$query = "SELECT * FROM `iConomy` ORDER BY `balance` DESC LIMIT 10";
$result = mysql_query($query);
echo "<table id=menubez style='width:400px'><tr><td class=st>Lp.</td><td class=st colspan=2>Nick</td><td class=st>Kasa</td></tr>";
$i = 1;
while ($result_row = mysql_fetch_row($result)) {
echo "<tr><td class=komorka>" . $i . "</td><td class='ramka komorka'><img src='https://minotar.net/avatar/" . $result_row[1] . "/32.png'></td><td class=komorka><a class='link2' href='gracze.php?player=" . $result_row[1] . "'>" . $result_row[1] . "</a></td><td class=komorka>" . $result_row[2] . "</td></tr>";
$i++;
}
echo "</table>";
echo "<h2 class=st2>Czas na serwerze</h2>";
$query = "SELECT * FROM `players` ORDER BY `PLAYTIME` DESC LIMIT 10";
$result = mysql_query($query);
echo "<table id=menubez style='width:400px'><tr><td class=st>Lp.</td><td class=st colspan=2>Nick</td><td class=st>Czas</td></tr>";
$i = 1;
while ($result_row = mysql_fetch_row($result)) {
echo "<tr><td class=komorka>" . $i . "</td><td class='ramka komorka'><img src='https://minotar.net/avatar/" . $result_row[1] . "/32.png'></td><td class=komorka><a class='link2' href='gracze.php?player=" . $result_row[1] . "'>" . $result_row[1] . "</a></td><td class=komorka>" . totime($result_row[33]) . "</td></tr>";
$i++;
}
echo "</table>";
echo "<h2 class=st2>Budowniczy TOP 10</h2>";
$query = "SELECT * FROM `players` ORDER BY `BLOCKCREATE_TOTAL` DESC LIMIT 10";
$result = mysql_query($query);
echo "<table id=menubez style='width:400px'><tr><td class=st>Lp.</td><td class=st colspan=2>Nick</td><td class=st>Postawione</td></tr>";
$i = 1;
while ($result_row = mysql_fetch_row($result)) {
echo "<tr><td class=komorka>" . $i . "</td><td class='ramka komorka'><img src='https://minotar.net/avatar/" . $result_row[1] . "/32.png'></td><td class=komorka><a class='link2' href='gracze.php?player=" . $result_row[1] . "'>" . $result_row[1] . "</a></td><td class=komorka>" . $result_row[10] . "</td></tr>";
$i++;
}
echo "</table>";
echo "<h2 class=st2>Zabójstwa TOP 10</h2>";
$query = "SELECT * FROM `players` ORDER BY `KILLS_TOTAL` DESC LIMIT 10";
print "</SPAN></TD></TR>\n";
// dump($asgn_row['clear']);
if (is_date($asgn_row['clear'])) {
$the_date = $asgn_row['clear'];
$the_vis = "visible";
$the_dis = FALSE;
} else {
$the_date = $now;
$the_vis = "hidden";
$the_dis = TRUE;
}
$chekd = is_date($asgn_row['clear']) ? " CHECKED " : "";
$the_date = is_date($asgn_row['clear']) ? $asgn_row['clear'] : $now;
print "\n<TR CLASS='odd'><TD CLASS='td_label' ALIGN='right'>Clear:</TD>";
print "<TD COLSPAN=3><INPUT NAME='frm_cb' TYPE='radio' onClick = \"document.edit_Form.frm_complete.value=1; enable('clear')\" {$chekd} ><SPAN ID = 'clear' STYLE = 'visibility:" . $the_vis . "'>";
generate_date_dropdown("clear", totime($the_date), $the_dis);
print "</SPAN></TD></TR>\n";
?>
<TR CLASS='even' VALIGN='baseline'><TD CLASS='td_label' ALIGN='right'>As of:</TD>
<TD colspan=2><?php
print format_date($asgn_row['as_of']);
?>
By: <?php
print $asgn_row['user'];
?>
</TD>
</TR>
<!-- <TR CLASS="even" VALIGN="baseline"><TD colspan="99" ALIGN="center">
<br>
<INPUT TYPE="BUTTON" VALUE="Cancel" onClick="history.back();" CLASS = 'btn'>
$i++;
}
echo "</div>";
}
//Pojedyńcza osoba
} else {
$query = "SELECT * FROM players WHERE `name` = '" . addslashes($_GET['player']) . "'";
$result = mysql_query($query);
while ($result_row = mysql_fetch_row($result)) {
echo "<center><div style='width:790px'><h1 class=menu style='font-family:Minecraft; color:#20e1fa'><img style='border-color: rgb(161, 161, 161); box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.2)' src='https://minotar.net/avatar/" . $result_row[1] . "/40.png'> " . $result_row[1] . "</h1>\n\t\t\t<table><tr><td><iframe class=info2 src='./skin/index.php?user="******"' title='" . $result_row[1] . "' width='350px' height='360px'></iframe></td>\n\t\t\t<td> </td>\n\t\t\t<td><h2 class=st2>Info</h2>\n\t\t\t<div class=info>Status: ";
if ($result_row[30] > $result_row[31]) {
echo "<span id='online'>ONLINE</span>";
} else {
echo "<span id='offline'>OFFLINE</span>";
}
echo "<br>\n\t\t\tOstatnio widziany: " . date('d-m-Y H:i:s', $result_row[30]) . "<br>Czas w grze: " . totime($result_row[33]) . "<br>Logowań: " . $result_row[32] . "<br>Średnio: " . totime(round($result_row[33] / $result_row[32])) . "\n\t\t\t<br>Zabójstwa: " . $result_row[6] . "\n\t\t\t<br>Śmierci: " . $result_row[7] . "\n\t\t\t<br>Level: " . $result_row[16] . "\n\t\t\t<br>Enchantowane przedmioty: " . $result_row[12] . "\n\t\t\t<br>Użyte komendy: " . $result_row[26] . "</div>\n\t\t\t<h2 class=st2>Bloki</h2>\n\t\t\t<div class=info>Postawione: " . $result_row[10] . "<br>Zniszczone: " . $result_row[9] . "</div></td></tr></table>\n\t\t\t<table><tr><td><h2 class=st2>Odległości</h2>\n\t\t\t<div class=info>Przebyta ogółem: " . $result_row[17] . "<br>\n\t\t\tSprint: " . $result_row[41] . "<br>\n\t\t\tSkradanie: " . $result_row[40] . "<br>\n\t\t\tWys. upadków: " . $result_row[42] . "<br>\n\t\t\tŁodzią: " . $result_row[5] . "<br>\n\t\t\tMinecart: " . $result_row[3] . "<br>\n\t\t\tŚwinią: " . $result_row[35] . "<br></div>";
$name = $result_row[1];
$id = $result_row[0];
}
//zgony
echo "<h2 class=st2 width:300px;'> Śmierci</h2><div class=info>";
$query = "SELECT * FROM stats WHERE `player_id` = " . $id . " AND `type`='ENV_DEATHS' AND `data` = '3'";
$result = mysql_query($query);
if (mysql_num_rows($result) == 0) {
$dd = 0;
} else {
$dd = mysql_result($result, 0, "value");
}
echo "Upadek: " . $dd . "<br>";
$query = "SELECT * FROM stats WHERE `player_id` = " . $id . " AND `type`='ENV_DEATHS' AND `data` = 2";
$result = mysql_query($query);
