Code: Select all
$row = mysql_fetch_array($r, MYSQL_ASSOC);Code: Select all
Unban </h3> <div class="windowbg" style="padding: 3px;"> <div class="smalltext"> "; $connect = mysql_connect($amxbans_hostname, $amxbans_username, $amxbans_password) or die(mysql_error()); $select = mysql_select_db($amxbans_database, $connect) or die(mysql_error()); $result = mysql_query("SELECT bid FROM amx_bans") or die(mysql_error()); $rows = mysql_num_rows($result); echo "Bans in database: <b><a href=".$amxbans_web." target = _blank>".$rows."</a></b><br> IP address - <b>".$ip."</b><br>"; $r = mysql_query("SELECT * FROM amx_bans WHERE player_ip = '$ip' AND expired = '0' ORDER BY bid DESC"); [b][size=150]$row = mysql_fetch_array($r, MYSQL_ASSOC);[/size][/b] if(!$row) { echo "Status: <b><span style="color:green">Not banned.</span></b><br>"; } else { echo "Status: <b><span style="color:red">You have been banned!</span></b><br>Reason: <b>$row[ban_reason]</b><br><br>"; $connect = mysql_connect($sms_hostname, $sms_username, $sms_password) or die(mysql_error()); $select = mysql_select_db($sms_database, $connect) or die(mysql_error()); $r = mysql_query("SELECT * FROM ebank WHERE `mod` = 'unban' LIMIT 1"); $row = mysql_fetch_array($r, MYSQL_ASSOC); $price[unban]= $row['price']/100; echo "Unban Price: $price[unban]LTL<br><br> <form target=_blank action="gateway/makro/paymakro.php" method="get"> <input type="hidden" name="orderid" value="$ip"> <input type="hidden" name="act" value="unban"> <input type="hidden" name="amount" value="$row[price]" /> <input type="submit" value="Pay now!"></form>"; } }else if($p == "specadmin"){ echo "<title>SPECADMIN order on IP</title> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <meta name="author" content="Skype = boxter7248"> <link rel="stylesheet" type="text/css" href="style.css"> <h3 class="catbg"><span class="left"></span> SPECADMIN order on IP </h3> <div class="windowbg" style="padding: 3px;"> <div class="smalltext"> <font size="1" color="black">"; echo "<center> "; $r = mysql_query("SELECT * FROM sms1 WHERE `mod` = 'specadmin' ORDER BY id"); while ( $row = mysql_fetch_assoc($r) ) { echo "<a href='order.php?p=specadmin&c=".$row['country']."&ingame=$ingame'><img src='img/flags/". str_replace(" ","_", strtolower($row['country'])).".gif'/></a> "; } $r2 = mysql_query("SELECT * FROM sms1 WHERE `mod` = 'specadmin' AND `country` = '$c'"); $row2 = mysql_fetch_array($r2, MYSQL_ASSOC); $r3 = mysql_query("SELECT * FROM amx_amxadmins WHERE `username` = '$ip'"); $row3 = mysql_fetch_array($r3, MYSQL_ASSOC); if(!$row2){ if($row3){ if($row3[access] == "$vip_access"){ echo "<br><br>Your <b>VIP</b> end at <b>$row3[timeleft]</b>"; }else if($row3[access] == "$admin_access"){ echo "<br><br>Your <b>ADMIN</b> end at <b>$row3[timeleft]</b>"; }else if($row3[access] == "$specadmin_access"){ echo "<br><br>Your <b>SPECVIP</b> end at <b>$row3[timeleft]</b>"; } } echo "<br><br>Choose your country to order <b>SPECADMIN</b> on <b>IP</b>."; die; } echo "<br><b>$c</b></center>"; $price = $row2[price]/100; Code: Select all
$r = mysql_query("SELECT * FROM ebank WHERE `mod` = 'unban' LIMIT 1");Code: Select all
ALTER TABLE `ebank` CHANGE `mod` `mod` ENUM( 'vip', 'admin', 'specadmin', 'unban',) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
Code: Select all
ALTER TABLE `ebank` CHANGE `mod` `mod` ENUM( 'vip', 'admin', 'specadmin', 'unban') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULLCode: Select all
$r = mysql_query("SELECT * FROM amx_bans WHERE player_ip = '$ip' "); $row = mysql_fetch_array($r, MYSQL_ASSOC); $r2 = mysql_query("SELECT ban_reason FROM amx_bans WHERE player_ip = '$ip' "); $row2 = mysql_fetch_array($r2, MYSQL_ASSOC); $reason = $row2['ban_reason']; if(!$row) { echo "Status: <b><span style="color:green">Not banned.</span></b><br>"; } else { echo "Status: <b><span style="color:red">You have been banned!</span></b><br>Reason: <b>$reason</b><br><br>";