<?php
/**
 * Created by JetBrains PhpStorm.
 * User: marce
 * Date: 29-04-2016
 * Time: 13:57
 * To change this template use File | Settings | File Templates.
 */

function ok($val) {
    is_numeric($val)?$x=$val:$y=0;
    return $x;
}

error_reporting(0);
/**
 * Created by JetBrains PhpStorm.
 * User: marce
 * Date: 10-02-2016
 * Time: 14:17
 * To change this template use File | Settings | File Templates.
 */

$gameid = $_GET['id'];
$ebotid = $_GET['ebot'];

if ($gameid == 0) exit;
if ($ebotid == 0) exit;

$servername = "localhost";
$username = "root";
$password = "Marcelo9";

$connectlocal = mysql_connect($servername, $username, $password) or die("Could not connect. " . mysql_error());
mysql_select_db('matchticker', $connectlocal);

$queryebot = "SELECT * FROM `ebot` WHERE `id`=".$ebotid;

$r = mysql_query($queryebot);

if ( $r !== false && mysql_num_rows($r) > 0 )  {
    while ( $a = mysql_fetch_assoc($r)) {
        $servername_ebot = $a['ip_sql'];
        $username_ebot = $a['username_sql'];
        $password_ebot = $a['password_sql'];
        $database_ebot = $a['database_sql'];
        $log_url = $a['logs_url'];
    }
}

mysql_close($connectlocal);

$servername = $servername_ebot;
$username = $username_ebot;
$password = $password_ebot;

$connectstats = mysql_connect($servername, $username, $password) or die("Could not connect. " . mysql_error());
mysql_select_db($database_ebot, $connectstats);

$q_kills = mysql_query("SELECT * FROM `player_kill` WHERE `match_id`='".$gameid."' ORDER by `created_at` DESC");

if ( $q_kills !== false && mysql_num_rows($q_kills) > 0 )  {
while ( $a = mysql_fetch_assoc($q_kills)) {
$round_num = -1;
if($a['round_id'] == $roundnum){
    ?>
    <table>
        <tr>
            <td style="<?php
            if($a['killer_team'] == "CT") { echo "color: blue;"; }
            if($a['killer_team'] == "TERRORIST"){ echo "color: red;"; }
            ?>">
                <?php echo substr($a['killer_name'], 0,15); ?>
            </td>
            <td><img src="img_armas/<?php echo $a['weapon']; ?>.png"></td>
            <td>
                <?php if($a['headshot'] == 0){
                }
                else {
                    ?><img src="img_armas/headshot.png"><?php
                }
                ?>
            </td>
            <td style="<?php
            if($a['killed_team'] == "CT") { echo "color: blue;"; }
            if($a['killed_team'] == "TERRORIST"){ echo "color: red;"; }
            ?>">
                <?php echo substr($a['killed_name'], 0,15); ?>
            </td>
            <?php $roundnum = $a['round_id'];?>
        </tr>
    </table>
<?php
}
if($a['round_id'] !== $roundnum){
 ?><br>
    <table>
        <tr colspan="4">
           <?php
               $round_lessone = $a['round_id'];
            $q_score = mysql_query("SELECT * FROM `round_summary` WHERE `match_id`='".$gameid."' AND `round_id`='".$round_lessone."'");
            $b = mysql_fetch_assoc($q_score);

               $score_a = $b['score_a'];
               $score_b = $b['score_b'];

               switch($score_a){
                   case ($score_a > $score_b):
                       $score_a = "<font color='green'>" . $score_a . "</font>";
                       $score_b = "<font color='red'>" . $score_b . "</font>";
                       break;
                   case ($score_a < $score_b):
                       $score_a = "<font color='red'>" . $score_a . "</font>";
                       $score_b = "<font color='green'>" . $score_b . "</font>";
                       break;
                   case ($score_a == $score_b):
                       $score_a = "<font color='orange'>" . $score_a . "</font>";
                       $score_b = "<font color='orange'>" . $score_b . "</font>";
                       break;
               }
            ?>Os
               <?php
               if($b['t_win'] == 1){ echo "<span style=\"color: red;\">Terroristas</span>"; } if($b['ct_win'] == 1) { echo "<span style=\"color: blue;\">Contra-Terroristas</span>"; }
               ?> venceram.
           <br><b>
            Ronda <?php echo $a['round_id']; ?> (<?php echo $score_a; ?>:<?php echo $score_b; ?>) terminou.</b>
        </tr>
        <tr style="height: 15px;"></tr>
        <tr>
            <td style="<?php
            if($a['killer_team'] == "CT") { echo "color: blue;"; }
            if($a['killer_team'] == "TERRORIST"){ echo "color: red;"; }
            ?>">
                <?php echo substr($a['killer_name'], 0,15); ?>
            </td>
            <td><img src="img_armas/<?php echo $a['weapon']; ?>.png"></td>
            <td>
                <?php if($a['headshot'] == 0){
                }
                else {
                    ?><img src="img_armas/headshot.png"><?php
                }
                ?>
            </td>
            <td style="<?php
            if($a['killed_team'] == "CT") { echo "color: blue;"; }
            if($a['killed_team'] == "TERRORIST"){ echo "color: red;"; }
            ?>">
                <?php echo substr($a['killed_name'], 0,15); ?>
            </td>
            <?php $roundnum = $a['round_id'];?>
        </tr>
    </table>
<?php
}
}
}
?>
<html>
<head>

</head>
<body>
<?php

?>
</body>
</html>