POMOZTE +karma

Message

Machete · #1 Příspěvekod **Machete** » 28 bře 2012, 20:11

prosim pomozte mam problem s MYSQL banlistom vsetko som urobil co je tam napisane ale nejde to

IP: 93.91.250.114:37344

PROBLEM KED ZAPNEM NA STRANKE BANLIST PHP
Warning: mysql_connect(): Access denied for user 'gs_37344_1'@'srv61.endora.cz' (using password: YES) in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 17 Warning: mysql_select_db(): Access denied for user 'zakaznik'@'srv61.endora.cz' (using password: NO) in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 18 Warning: mysql_select_db(): A link to the server could not be established in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 18 Warning: mysql_query(): Access denied for user 'zakaznik'@'srv61.endora.cz' (using password: NO) in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 20 Warning: mysql_query(): A link to the server could not be established in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 20 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/users/lllscorpionlll/uranus.4fan.cz/web/banlist.php on line 35

#2 Příspěvekod **Vojko** » 28 bře 2012, 20:13

Skopíruj sem obsah banlist.php a configu ...

Machete · #3 Příspěvekod **Machete** » 28 bře 2012, 20:16

BANLIST.PHP

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 = "localhost";
   $dbuser = "gs_37344_1";
   $dbpass = "****";
   $dbname = "gs_37344_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>

AAA
CONFIG

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/gs_37344_1'
mysql-user: 'gs_37344_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
useJail: true
useLockdown: true
useStarve: true
useForceRespawn: true
useEmpty: true
usePermaban: true
useWarn: true
useRules: true
#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:
  banMsgFailed: '&c%victim% &8is already banned!'
  unbanMsg: '&8Successfully unbanned &c%victim%&8!'
  unbanMsgBroadcast: '&c%victim% &8was unbanned by &9%admin%&8!'
  unbanMsgFailed: '&c%victim% &8is already unbanned!'
  kickAllMsg: '%admin% kicked everyone. Reason: %reason%!'
  kickMsgVictim: 'You have been kicked by %admin%. Reason: %reason%!'
  kickMsgBroadcast: '&c%victim% &8was kicked by &9%admin%&8. Reason: &c%reason%!'
  kickMsgFailed: '&8Kick failed: &8%victim% &8isn''t online.'
  banMsgVictim: 'You have been banned by %admin%. Reason: %reason%!'
  banMsgBroadcast: '&c%victim% &8was banned by &9%admin%&8. Reason: &c%reason%!'
  permbanMsgVictim: 'You have been permabanned by %admin%. Reason: %reason%!'
  permbanMsgBroadcast: '&c%victim% &8has been permabanned by &9%admin%&8. Reason: &c%reason%!'
  tempbanMsgVictim: 'You have been temp. banned by %admin%. Reason: %reason%!'
  tempbanMsgBroadcast: '&c%victim% &8was temp. banned by &9%admin%&8. Reason: &c%reason%!'
  LoginTempban: '&8You are banned until &c%time%&8! Reason: &c%reason%!'
  LoginBan: '&8You are banned from this server! Reason: &c%reason%!'
  LoginIPBan: 'Your IP is banned!'
  fineMsgVictim: 'You have been fined by %admin% in the amount of %amt%!'
  fineMsgBroadcast: '&c%victim% &8was fined by &9%admin%&8 in the amount of &c%amt%!'
  emptyMsgVictim: '&9%admin% has cleared your inventory!'
  emptyMsgBroadcast: '&9%admin% has cleared the inventory of &c%victim%!'
  starveMsgVictim: '&8You are now starving!'
  starveMsgBroadcast: '&c%victim% is now starving!'
  fspawnMsgVictim: '&8You have been sent to spawn!'
  fspawnMsgBroadcast: '&c%victim% &8is now at spawn!'
  jailMsgVictim: '&8You have been jailed by &9%admin%&8. Reason: &c%reason%!'
  jailMsgRelease: '&c%victim% &8was released from jail by &9%admin%&8!'
  jailMsgBroadcast: '&c%victim% &8was jailed by &9%admin%&8. Reason: &c%reason%!'
  warnMsgVictim: '&8You have been warned by &9%admin%&8. Reason: &c%reason%!'
  warnMsgBroadcast: '&c%victim% &8was warned by &9%admin%&8. Reason: &c%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!'
  muteChatMsg: 'You have been muted!'
  unmuteMsgVictim: 'You have been unmuted.'
  unmuteMsg: 'You have unmuted %victim%.'
  
  ruleMsg: '&9The Servers Rules Are As Follows!'
#Adjust as you see fit or set ingame.#
rules:
  one:
  two:
  three:
  four:
  five:
  six:
  seven:
  eight:
  nine:
  ten:
#Do Not Change Values Below#
jail:
  x: 0
  y: 0
  z: 0
  yaw: 0
  pitch: 0

#4 Příspěvekod **Vojko** » 28 bře 2012, 20:19

Kód: Vybrat vše

$server = "localhost";

Ziadny localhost, ale umiestnenie serveru (napr. xray.fakaheda.eu)
Na miesto xray si doplň názov serveru, na ktorej tvoj server fachá

Machete · #5 Příspěvekod **Machete** » 28 bře 2012, 20:30

?? mam tam svoj server ale stale to nejde ?

ten isty error mam tam... mozem to tu napisat ci je to jak heslo ?

#6 Příspěvekod **Vojko** » 28 bře 2012, 20:34

Skopíruj sem teraz banlist.php

Machete · #7 Příspěvekod **Machete** » 28 bře 2012, 20:35

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 = "echo.fakaheda.eu";
   $dbuser = "gs_37344_1";
   $dbpass = "********";
   $dbname = "gs_37344_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>

Machete · #8 Příspěvekod **Machete** » 28 bře 2012, 20:55

prosiim pekne vas pomozte ten banlist by pomohol prosiim :cry:

#9 Příspěvekod **Vojko** » 28 bře 2012, 22:23

V MySQL sa tabulky vytvorili ?

Machete · #10 Příspěvekod **Machete** » 29 bře 2012, 14:21

ano vytvorili sa banlistip a banlist

FakaHeda.eu Fórum

POMOZTE +karma

POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Re: POMOZTE +karma

Kdo je online