Guest User

Untitled

a guest
Jul 3rd, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.00 KB | None | 0 0
  1. <?php
  2.  
  3. //SQL
  4.  
  5.    $server = "IP";
  6.    $dbuser = "username";
  7.    $dbpass = "password";
  8.    $dbname = "datbasename";
  9.    
  10. mysql_connect($server, $dbuser, $dbpass);
  11. mysql_select_db($dbname);
  12.  
  13. $result = mysql_query("SELECT * FROM bans ORDER BY time DESC");
  14. //adjust the table
  15. echo "<table width=70% border=1 cellpadding=5 cellspacing=0>";
  16.  
  17. echo "<tr style=\"font-weight:bold\">
  18. <td>Player</td>
  19. <td>Banned By</td>
  20. <td>Reason</td>
  21. <td>Time of ban</td>
  22. <td>Time of unban</td>
  23. <td>Proof</td>
  24. </tr>";
  25.  
  26. while($row = mysql_fetch_assoc($result)){
  27.  
  28. if($col == "#eeeeee"){
  29. $col = "#ffffff";
  30. }else{
  31. $col = "#eeeeee";
  32. }
  33. echo "<tr bgcolor=$col>";
  34.  
  35. echo "<td>".$row['name']."</td>";
  36. echo "<td>".$row['by']."</td>";
  37. echo "<td>".$row['reason']."</td>";
  38. echo "<td>".date("d M, Y g:ia",$row['time'])."</td>";
  39. if($row['temptime'] == "0"){
  40. echo "<td>∞</td>";
  41. }else{
  42. echo "<td>".date("d M, Y g:ia",$row['temptime'])."</td>";
  43. }
  44. //Some kind of input box?? (For the Proof)
  45. echo "</tr>";
  46. }
  47.  
  48. echo"</table>"
  49.  
  50. ?>
Add Comment
Please, Sign In to add comment