Untitled

    <!DOCTYPE html>

    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <link rel="stylesheet" type="text/css" href="style.css"/>
    <title>MultiCraft.Minecraft.Is</title>
    </head>

    <body>
        <div id="page">
        <div id="header">

                <ul>
                    <li><a href="/index.html">Heim</a></li>
                    <li><a href="/bannlistinn.php">Bannlistinn</a></li>
                </ul>
            </div>
			</div>

                    </body>


<?php
       $server = "localhost";
       $dbuser = "root";
       $dbpass = "123";
       $dbname = "minecraft";

    mysql_connect($server, $dbuser, $dbpass);
    mysql_select_db($dbname);

    $result = mysql_query("SELECT * FROM sandkassinn_bans WHERE hide!='1'");
	$rows = mysql_num_rows($result);

    echo "<table width=70% border=2 cellpadding=7 cellspacing=7>";

    echo "<tr style=\"font-weight:bold\">
    <td>Spilari</td>
    <td>Ástæða</td>
    <td>Admin</td>
    <td>Tegund</td>
    <td>Lok bans</td>
    </tr>";

    while($row = mysql_fetch_assoc($result)){

            $type = $row['type'];
			$reason2 = $row['reason'];
			$user = $row['banned'];
			$xray2 = $row['xray'];

            if ($type == "tempban")
            {
                    $tegund = 'Tímabundið';
            }

            elseif ($type == "permaban")

            {
                    $tegund = 'Óendanlegt';
            }

			if ($reason2 == "x-ray" && $xray2 != "1" || $reason2 == "x-ray!"  && $xray2 != "1" || $reason2 == "xray"  && $xray2 != "1" || $reason2 == "xray!" && $xray2 != "1" )
			{
				$xrayquery = "INSERT INTO xray (name) VALUES ('$user')";
				$xrayquery2 = "UPDATE sandkassinn_bans SET xray=1 WHERE banned = '$user'";
				mysql_query($xrayquery2);
				mysql_query($xrayquery);
			}

			$queryxray = "SELECT * FROM xray WHERE name='$user'";
			$xrayrows = mysql_query($queryxray);
			$xrayamount = mysql_num_rows($xrayrows);

			if ($xrayamount > 1)
			{
				echo "asdf";
				$user = $row['banned'];
				$hideother = "UPDATE sandkassinn_bans SET hide='1' WHERE banned='$user'";
				mysql_query($hideother);
				$removexray = "DELETE FROM xray WHERE user='$user";
				mysql_query($removexray);
				$timeban = time();
				$permaban = "INSERT INTO sandkassinn_bans (id,banned,type,reason,executor,date_executed,date_expire,x-ray,hide) VALUES ('1','$user','permaban','X-Ray','Console','$timeban','Óendanlegt X-Ray Bann','1','0')";
				mysql_query($permaban);
			}


    $time1 = $row['date_expire'];
    $time2 = time();
    $username = $row['banned'];

    if ($time1 < $time2)
    {
		$sethide = "UPDATE sandkassinn_bans SET hide='1' WHERE banned='$user'";
		mysql_query($sethide);
    }

    else
	{
    echo '<tr bgcolor=$col>';

    $timeexecuted = $row['date_expire'];
    $time_done = date("d-m-Y H:i", $timeexecuted);

    echo "<td><font color='#A00000'>".$row['banned']."</td></font>";
    echo "<td><font color='#A00000'>".$row['reason']."</td></font>";
    echo "<td><font color='#A00000'>".$row['executor']."</td></font>";
    echo "<td><font color='#A00000'>".$tegund."</td></font>";
    echo "<td><font color='#A00000'>".$time_done."</td></font>";
	}
    }

	echo "<font size=8>Spilaðar bannaðir: $rows</font>";

	?>