Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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>";
- ?>
Add Comment
Please, Sign In to add comment