$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);