Hi again! 😃
I don't have any kind of an error but i do have this
So as you can see the banreason and the banpoints are the same. What i actually want is for the banreason to be like 'No-Demo' and not the number, a name or something.
Here is the script, if anyone could help wuld much appreciated.
<?php
require_once('auth.php');
echo "<head>";
echo "<title>Admin / Crew page - My Profile</title>";
echo "<link href=\"loginmodule.css\" rel=\"stylesheet\" type=\"text/css\" />";
echo "</head>";
echo "<body>";
echo "<h1>My Profile </h1>";
$dbconn = mysql_connect( "localhost", "users_site", "password");
mysql_select_db("realwars_site", $dbconn);
if (isset($_POST['action']) && $_POST['action'] == 'submitted') {
$id = $_POST["id"];
$id3 = $_SESSION['SESS_MEMBER_ID'];
$query3 = mysql_query("SELECT banpoints,nickname FROM site_user WHERE userID='$id3'");
while ($list3 = mysql_fetch_object($query3)) {
$nickname255 = $list3->nickname;
$query = mysql_query("SELECT banpoints FROM site_user WHERE userID='$id'");
while ($list = mysql_fetch_object($query)) {
$bp = $list->banpoints;
$position= $_POST["position"];
$level = $_POST["level"];
$datum = $_POST["datum"];
$level2 = $_POST["level2"];
$email = $_POST["email"];
$addbp = $bp + $_POST["addbp"];
$ban2 = $_POST["banreason"];
$date = date("Y-m-d H:i:s");
$reason = $_POST["reason"];
$ban = $bp + $_POST["banreason"];
mysql_query("UPDATE site_user SET banpoints='".$ban."' WHERE userID='".$id."'") or die (mysql_error());
mysql_query("INSERT INTO banpoints (date,user_id,banpoints,admin,reason) VALUES ('$date','$id','$ban2','$nickname255','$ban2')") or die (mysql_error());
echo "You added <b>$addbp2</b>.<br><br><a href=\"usersm2.php\">Go Back</a>";
}
}
}else{
$id3 = $_SESSION['SESS_MEMBER_ID'];
$query2 = mysql_query("SELECT isstaff5,isstaff4,isstaff,isstaff2,isstaff3 FROM site_user WHERE userID='$id3'");
while ($list2 = mysql_fetch_object($query2)) {
$isstaff = "$list2->isstaff";
$isstaff2 = "$list2->isstaff2";
$isstaff3 = "$list2->isstaff3";
$isstaff4 = "$list2->isstaff4";
$isstaff5 = "$list2->isstaff5";
if ( $isstaff5 == '1' OR $isstaff2 == '1') {
require('header.php');
require('acmenu.php');
echo "<table cellpadding=\"0\" cellspacing=\"0\">";
echo "<tr>";
echo "<form method=\"post\">";
echo "<tr>";
echo "<td><br>User ID:</td>";
echo "<td><br><select name=\"id\">";
echo "<option value=\"MNG\" SELECTED>Select a user ID</option>";
$query2 = mysql_query("SELECT * FROM site_user ORDER BY userID ASC");
while ($list2 = mysql_fetch_object($query2)) {
$id = "$list2->userID";
$nickname = "$list2->nickname";
echo "<option value=\"".$id."\">".$id." ( ".$nickname." )</option>";
}
echo "</tr>";
echo "<td>Ban Reason:</td>";
echo "<td><select name=\"banreason\">";
echo "<option value=\"MNG\" SELECTED>Select a reason</option>";
$nickname2 = "$list2->nickname";
echo "<option value=\"15\" name=\"AFK\">AFK </option>";
echo "<option value=\"40\" name=\"No-Demo\">No-Demo</option>";
echo "<option value=\"100\" name=\"Cheater\">Cheater</option>";
echo "</table>";
echo "<br>";
echo "<input type=\"hidden\" name=\"action\" value=\"submitted\"><input type=\"submit\" name=\"submit\" value=\" Submit \">";
echo "</form>";
}
}
}
?>
