Dobrý den, potreboval by som vedet ako hodím banlist na web ktorý mám cez wordpress. Jedinú vec ktorú som skúsil bola tá, že som vytvoril novú stránku a hodil som tam
Spoiler: zobrazit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Ultra Banlist</title>
</head>
<body>
<h1>Ultra Banlist</h1>
<?php
// change these things
$server = "localhost";
$dbuser = "root";
$dbpass = "root";
$dbname = "database";
mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname);
$result = mysql_query("SELECT * FROM banlist ORDER BY id DESC");
//This will display the most recent by id edit this query how you see fit. Limit, Order, ect.
echo "<table width=100% border=1 cellpadding=3 cellspacing=0>";
echo "<tr style=\"font-weight:bold\">
<td>Type</td>
<td>Name</td>
<td>Reason</td>
<td>Admin/Mod</td>
<td>Time</td>
<td>TimeTempBan</td>
<td>id</td>
</tr>";
while($row = mysql_fetch_assoc($result)){
if($col == "#eeeeee"){
$col = "#ffffff";
}else{
$col = "#eeeeee";
}
echo "<tr bgcolor=$col>";
if($row['type'] == "5"){
echo "<td>Unban</td>";
}else{
if($row['type'] == "3"){
echo "<td>Kick</td>";
}else{
if($row['type'] == "2"){
echo "<td>Warn</td>";
}else{
if($row['type'] == "0"){
echo "<td>Banned</td>";
}else{
if($row['type'] == "1"){
echo "<td>IPBanned</td>";
}else{
if($row['type'] == "4"){
echo "<td>Fine</td>";
}else{
if($row['type'] == "6"){
echo "<td>Jailed</td>";
}else{
if($row['type'] == "9"){
echo "<td>Perma</td>";
}else{
echo "<td>Unknown</td>";
//Holy Epic If Statement Batman!
}
}
}
}
}
}
}
}
echo "<td>".$row['name']."</td>";
echo "<td>".$row['reason']."</td>";
echo "<td>".$row['admin']."</td>";
//Convert Epoch Time to Standard format
$datetime = date("F j, Y, g:i a", $row['time']);
echo "<td>$datetime</td>";
$dateconvert = date("F j, Y, g:i a", $row['temptime']);
if($row['temptime'] == "0"){
echo "<td>None</td>";
}else{
echo "<td>$dateconvert</td>";
}
echo "<td>".$row['id']."</td>";
echo "</tr>";
}
echo"</table>";
?>
</div>
Ban database provided by UltraBans.
</body></html>
<html>
<head>
<title>Ultra Banlist</title>
</head>
<body>
<h1>Ultra Banlist</h1>
<?php
// change these things
$server = "localhost";
$dbuser = "root";
$dbpass = "root";
$dbname = "database";
mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname);
$result = mysql_query("SELECT * FROM banlist ORDER BY id DESC");
//This will display the most recent by id edit this query how you see fit. Limit, Order, ect.
echo "<table width=100% border=1 cellpadding=3 cellspacing=0>";
echo "<tr style=\"font-weight:bold\">
<td>Type</td>
<td>Name</td>
<td>Reason</td>
<td>Admin/Mod</td>
<td>Time</td>
<td>TimeTempBan</td>
<td>id</td>
</tr>";
while($row = mysql_fetch_assoc($result)){
if($col == "#eeeeee"){
$col = "#ffffff";
}else{
$col = "#eeeeee";
}
echo "<tr bgcolor=$col>";
if($row['type'] == "5"){
echo "<td>Unban</td>";
}else{
if($row['type'] == "3"){
echo "<td>Kick</td>";
}else{
if($row['type'] == "2"){
echo "<td>Warn</td>";
}else{
if($row['type'] == "0"){
echo "<td>Banned</td>";
}else{
if($row['type'] == "1"){
echo "<td>IPBanned</td>";
}else{
if($row['type'] == "4"){
echo "<td>Fine</td>";
}else{
if($row['type'] == "6"){
echo "<td>Jailed</td>";
}else{
if($row['type'] == "9"){
echo "<td>Perma</td>";
}else{
echo "<td>Unknown</td>";
//Holy Epic If Statement Batman!
}
}
}
}
}
}
}
}
echo "<td>".$row['name']."</td>";
echo "<td>".$row['reason']."</td>";
echo "<td>".$row['admin']."</td>";
//Convert Epoch Time to Standard format
$datetime = date("F j, Y, g:i a", $row['time']);
echo "<td>$datetime</td>";
$dateconvert = date("F j, Y, g:i a", $row['temptime']);
if($row['temptime'] == "0"){
echo "<td>None</td>";
}else{
echo "<td>$dateconvert</td>";
}
echo "<td>".$row['id']."</td>";
echo "</tr>";
}
echo"</table>";
?>
</div>
Ban database provided by UltraBans.
</body></html>
