amx logs -> sql [Orpheu]

<?
session_start();
if( $_SESSION['level'] == NULL || !$_SESSION['loggedin']==true) {
    header("Location: index.php");
    exit();
}

//require_once("include/db.config.inc.php");
require_once("include/access.inc.php");

if ( !has_access("amxadmins_view") )
{

    header("Location:index.php");
    exit();
}


$host = 'localhost';
$login = '';
$password = '';
$db = '';
$table = 'amx_logs';

$conn = mysql_connect($host, $login, $password);

?>
<center>
<table width=90% align=center><tr bgcolor=#CCCCCC>
<td bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?serv=Lite&type=<?echo (htmlspecialchars($_GET[type]));?>'"><center><a href="logs2.php?serv=Lite">Lite</a>       </center> </td>
<td bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?serv=DM&type=<?echo (htmlspecialchars($_GET[type]));?>'"><center><a href="logs2.php?serv=DM">DM</a>           </center></td>
<td bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?serv=GG&type=<?echo (htmlspecialchars($_GET[type]));?>'"><center><a href="logs2.php?serv=GG">GG</a>           </center></td>
<td bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?serv=War3FT&type=<?echo (htmlspecialchars($_GET[type]));?>'"><center><a href="logs2.php?serv=War3FT">War3FT</a>   </center></td>
</tr>
</table>
<table width=90%><tr>



<td width=5% bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?<?
    
    if(isset($_GET[serv]))
    {
     echo "serv=". htmlspecialchars($_GET[serv])."&";
    }
    if(isset($_GET[type]))
    {
     echo "type=". htmlspecialchars($_GET[type])."&";
    }
    if(intval($_GET[page]) > 1)
    {
     echo "page=".(intval($_GET[page]) - 1);
    }
  
?>'" >
<center><font size=900><</font> </center>

</td>


<td>
<?

if ($conn)
{
    if (mysql_select_db($db))
    {
        
        $serv = mysql_real_escape_string($_GET[serv]);
        $count = intval($_GET[page])*50;

        if(isset($_GET[type]))
        {
            $type = intval($_GET[type]);
            if($type==2 or type == 3)
            {
                $query = "SELECT * FROM ".$table." WHERE (`type` = 2 OR `type` = 3)";
            }
            else
            {
                $query = "SELECT * FROM ".$table." WHERE `type` = ".$type;
            }
            if(isset($_GET[serv]))
            {
                $query.= " AND `server` LIKE '".$serv."'";
            }
        }
        else
        {
            if(isset($_GET[serv]))
            {
                $query= "SELECT * FROM ".$table." WHERE `server` LIKE '".$serv."'";
            }
            else
            {
                $query = "SELECT * FROM ".$table;
            }
        }
        


        $query.=  " ORDER BY `time` DESC, `count` ASC";

        $result = mysql_query($query." LIMIT ".$count.",30 ");
        
        if (!$result) {
            die('Invalid query: ' . mysql_error());
        }
        
        echo '<center><table order = 0 cellpadding = 3 cellspacing = 3 width=98%>';
        echo "<tr bgcolor=#EEEEEE>
        <td width=5% >Сервер</td>
        <td width=6%>Время</td>";
        
        echo '<td  width=9% bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor=\'#BBFFBB\'" onMouseOut="this.style.backgroundColor=\'#DDDDDD\'" ';
        echo 'onclick="location.href=\'logs2.php?';
        if(isset($_GET[serv]))
        {
            echo "serv=". htmlspecialchars($_GET[serv])."&";
        }
        if(intval($_GET[type])==2)
        {
            echo "type=4";
        }
        else
        {
            if(intval($_GET[type])!=4)
            {
                echo "type=". (intval($_GET[type])+1);
            }
        }
        
        echo "'";
        echo '">';
        if(isset($_GET[type]))
        {
            if($_GET[type]==0) echo '<center><b> COMMANDS </b> </center></td>';
            if($_GET[type]==1) echo '<center><b> SV LOGS </b> </center></td>';
            if($_GET[type]==2) echo '<center><b> CHAT </b> </center></td>';
            if($_GET[type]==3) echo '<center><b> CHAT </b> </center></td>';
            if($_GET[type]==4) echo '<center><b> AMXX LOGS </b> </center></td>';
        }
        else
        {
            echo '<center><b> ALL </b> </center></td>';
        }
        echo "<td  width=5% >Team</td>";
        echo "<td  width=75% >Лог</td></tr>";
        
        $i = $count;
        while($row=mysql_fetch_array($result))
        {
            $time = date("d.m - H:i:s", $row['time']);
            if($i%2)
            {
                    $col = "#EFEFEF";
            }
            else
            {
                $col = "#FEFEFE";
            }
            $team = $row[team];
            if($team=="[UN]") {$teamcolor = "#DDDDDD";}
            if($team=="[TT]") {$teamcolor = "#FFDDDD";}
            if($team=="[CT]") {$teamcolor = "#DDDDFF";}
          
            if(stripos($row[cmd], "error")!=FALSE and stripos($row[log], "error") != stripos($row[log], "terror") +1 ) {$col = "#FE0000";}
            if($row[type]==2 or $row[type]==3) {$lgcol = "#EFEFAF";} else {$lgcol = $col;}
            if(($row[name] == "SERVER")) {$plcol = "#DEDEFE";} else {$plcol = $col;}
            if(($row[name] == "fresh_bans.amxx")) {$plcol = "#FFDEDE";} else {$plcol = $plcol;}
            if(($row[name] == "aim_detector.amxx")) {$plcol = "#FFCECE";} else {$plcol = $plcol;}
            if(($row[name] == "alias_detector.amxx")) {$plcol = "#FFCECE";} else {$plcol = $plcol;}
            
            echo "<tr bgcolor=".$col."><td>".htmlspecialchars($row[server])."</td>";
            echo "<td>".$time."</td>";
            echo "<td bgcolor=".$plcol.">".htmlspecialchars($row[name])."</td>";
            echo "<td bgcolor=".$teamcolor."><center>".$team."</center></td>";
            echo "<td bgcolor=".$lgcol.">".htmlspecialchars($row[cmd])."</td></tr>";
            
        }
        echo '</table></center>';
    }
}

mysql_close($conn);

?>

</td>
<td width=5% bgcolor=#DDDDDD onMouseOver="this.style.backgroundColor='#FFDDDD'" onMouseOut="this.style.backgroundColor='#DDDDDD'" onclick="location.href='logs2.php?<?
    
    if(isset($_GET[serv]))
    {
     echo "serv=". htmlspecialchars($_GET[serv])."&";
    }
    if(isset($_GET[type]))
    {
     echo "type=". htmlspecialchars($_GET[type])."&";
    }
         echo "page=".(intval($_GET[page]) + 1);
?>'" >
<center><font size=900>></font> </center>
</td></tr></table>

</center>