Ban list na web

Message

Neopry · #1 Příspěvekod **Neopry** » 12 kvě 2012, 18:51

Ahoj,
Koukal jse do topicu Návody, zkoušel jsem to podle nich ale nejde mi to .. potřeboval bych aby se mi na webu ukazovaly bany, bud spatne pisu MySQL udaje nebo nwm ... prosim pomuzete mi nekdo ?
Díky predem

#2 Příspěvekod **Vojko** » 12 kvě 2012, 18:53

Skopíruj sem obsah banlist.php a configu na servery.
Samozrejme vymaž heslo.

Neopry · #3 Příspěvekod **Neopry** » 12 kvě 2012, 19:00

Kód: Vybrat vše

<!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 = "zulu.fakaheda.eu";
   $dbuser = "gs_37465_1";
   $dbpass = "*****";
   $dbname = "gs_37465_1";
   
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>

Neopry · #4 Příspěvekod **Neopry** » 12 kvě 2012, 19:01

Config na servery (asi)

Kód: Vybrat vše

#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: MySQL
mysql-database: 'jdbc:mysql://localhost:3306/minecraft'
mysql-user: 'gs_37465_1'
mysql-password: '******'
#Change these if you want to load or create different databases#
#First load will create these databases#
mysql-table: banlist
mysql-table-ip: banlistip
#SQLite Information#
sqlite-dbname: banlist
#parameters#
auto-complete: true
#Command Checks#
useFine: true
#Max allowable fine#
#If Zero then no max will be placed#
maxFineAmt: 0
#Disable command usage on muted#
muteVanilla: true
#Max Warnings#
enableMaxWarn: false
maxWarnings: 5
#Default labels#
defAdminName: 'server'
defReason: 'not sure'
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
lockdown: false
#Enabling dupePolicy will disallow duplicate IP connections#
dupePolicy: false
#Messages#
messages:
  banMsgFailed: '&4%victim% &7is already banned!'
  unbanMsg: '&7Successfully unbanned &4%victim%&7!'
  unbanMsgBroadcast: '&4%victim% &7was unbanned by &3%admin%&7!'
  unbanMsgFailed: '&4%victim% &7is already unbanned!'
  kickAllMsg: '%admin% kicked everyone. Reason: %reason%!'
  kickMsgVictim: 'You have been kicked by %admin%. Reason: %reason%!'
  kickMsgBroadcast: '&4%victim% &7was kicked by &3%admin%&7. Reason: &4%reason%!'
  kickMsgFailed: '&7Kick failed: &7%victim% &7isn''t online.'
  banMsgVictim: 'You have been banned by %admin%. Reason: %reason%!'
  banMsgBroadcast: '&4%victim% &7was banned by &3%admin%&7. Reason: &4%reason%!'
  permbanMsgVictim: 'You have been permabanned by %admin%. Reason: %reason%!'
  permbanMsgBroadcast: '&4%victim% &7has been permabanned by &3%admin%&7. Reason: &4%reason%!'
  tempbanMsgVictim: 'You have been temp. banned by %admin%. Reason: %reason%!'
  tempbanMsgBroadcast: '&4%victim% &7was temp. banned by &3%admin%&7. Reason: &4%reason%!'
  LoginTempban: '&7You are banned until &4%time%&7! Reason: &4%reason%!'
  LoginBan: '%admin% banned you from this server! Reason: %reason%!'
  LoginIPBan: 'Your IP is banned!'
  fineMsgVictim: 'You have been fined by %admin% in the amount of %amt%!'
  fineMsgBroadcast: '&4%victim% &7was fined by &3%admin%&7 in the amount of &4%amt%!'
  emptyMsgVictim: '&3%admin% has cleared your inventory!'
  emptyMsgBroadcast: '&3%admin% has cleared the inventory of &4%victim%!'
  starveMsgVictim: '&7You are now starving!'
  starveMsgBroadcast: '&4%victim% is now starving!'
  fspawnMsgVictim: '&7You have been sent to spawn!'
  fspawnMsgBroadcast: '&4%victim% &7is now at spawn!'
  jailMsgVictim: '&7You have been jailed by &3%admin%&7. Reason: &4%reason%!'
  jailMsgRelease: '&4%victim% &7was released from jail by &3%admin%&7!'
  jailMsgBroadcast: '&4%victim% &7was jailed by &3%admin%&7. Reason: &4%reason%!'
  warnMsgVictim: '&7You have been warned by &3%admin%&7. Reason: &4%reason%!'
  warnMsgBroadcast: '&4%victim% &7was warned by &3%admin%&7. Reason: &4%reason%!'
  lockMsgLogin: 'Server is under a lockdown, Try again later! Sorry.'
  DupeIPKick: 'Duplicate IP addresses disabled.'
  jailCmdMsg: 'You cannot use commands while jailed!'
  jailChatMsg: 'Your cry falls on deaf ears.'
  jailPlaceMsg: 'You cannot place blocks while you are jailed!'
  jailBreakMsg: 'You cannot break blocks while you are jailed!'
  tempjailMsgVictim: 'You have been temp. jailed by %admin%. Reason: %reason%!'
  tempjailMsgBroadcast: '&4%victim% &7was temp. jailed by &3%admin%&7. Reason: &4%reason%!'
  tempipbanMsgVictim: 'You have been temp. ipbanned by %admin%. Reason: %reason%!'
  tempipbanMsgBroadcast: '&4%victim% &7was temp. ipbanned by &3%admin%&7. Reason: &4%reason%!'
  muteChatMsg: 'You have been muted!'
  unmuteMsgVictim: 'You have been unmuted.'
  unmuteMsg: 'You have unmuted %victim%.'
#Do Not Change Values Below#
jail:
  x: 0
  y: 0
  z: 0
  yaw: 0
  pitch: 0

#5 Příspěvekod **Mysteria** » 12 kvě 2012, 19:11

A adresa, kde máš ten banlist umístěnej, aby bylo vidět, co ti to píše za chybu?

#6 Příspěvekod **Vojko** » 12 kvě 2012, 19:12

Toto máš zle ...
Na miesto minecraft tam daj gs_37465_1

Kód: Vybrat vše

mysql-database: 'jdbc:mysql://localhost:3306/gs_37465_1'

Neopry · #7 Příspěvekod **Neopry** » 13 kvě 2012, 09:19

Warning: mysql_connect(): Access denied for user 'gs_37465_1'@'srv61.endora.cz' (using password: YES) in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 17 Warning: mysql_select_db(): Access denied for user 'zakaznik'@'srv61.endora.cz' (using password: NO) in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 18 Warning: mysql_select_db(): A link to the server could not be established in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 18 Warning: mysql_query(): Access denied for user 'zakaznik'@'srv61.endora.cz' (using password: NO) in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 20 Warning: mysql_query(): A link to the server could not be established in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 20 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/users/123kekeee123/nobrain.6f.sk/web/banlist.php on line 35

Toto mi to pise

http://www.nobrain.6f.sk/banlist.php

LavorekCZ · #8 Příspěvekod **LavorekCZ** » 13 kvě 2012, 09:49

Vojko píše:Toto máš zle ...
Na miesto minecraft tam daj gs_37465_1

Kód: Vybrat vše
mysql-database: 'jdbc:mysql://localhost:3306/gs_37465_1'

Neopry · #9 Příspěvekod **Neopry** » 13 kvě 2012, 09:54

MySQL uz jde ale nejde to nwm proc ... http://www.nobrain.6f.sk/BanList

Kód: Vybrat vše

Database: MySQL
mysql-database: 'jdbc:mysql://localhost:3306/gs_37465_1'
mysql-user: 'gs_37465_1'
mysql-password: '******'

#10 Příspěvekod **Mysteria** » 13 kvě 2012, 10:53

Protože jako asi všem, co mají webhosting od Endory se ti to připojuje místo k MySQL Fakahedy někam na jejich vlastní - 'zakaznik'@'srv61.endora.cz'.

FakaHeda.eu Fórum

Ban list na web

Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Re: Ban list na web

Kdo je online