name and value

millan

Note: i posted this in the database which was the wrong subforum to post in

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("users_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>";
}
}
}
?>

djjjozsi

$_POST["banreason"] should be a string, and $bp would calculated from this value.

<?php
$banpoints = array( 
    "A" => 45,
    "AA" => 100 );
$reason = $_POST["reason"];
echo "You have selected: $reason  ,   WHERE banpoint is:" . $banpoints[$reason];

?>

banpoints should hold the usersID and evry ban resons and points in sepeare rows. If you query down the point, you can use COUNT() to get the bad points.

millan

djjjozsi;10944147 wrote:
$_POST["banreason"] should be a string, and $bp would calculated from this value.
<?php
$banpoints = array( 
    "A" => 45,
    "AA" => 100 );
$reason = $_POST["reason"];
echo "You have selected: $reason  ,   WHERE banpoint is:" . $banpoints[$reason];

?>
banpoints should hold the usersID and evry ban resons and points in sepeare rows. If you query down the point, you can use COUNT() to get the bad points.

Can you give me an example for the COUNT() where exactly to add the usersID?

djjjozsi

for example:
You have the users table:
userid , username, userlevel

You have banpoints table:
banpoint_id , userid , banreason, banpoint, admin_id, ban_date_time

My user id is 1.
If i select a user with an ID: 7 to add two knd of a ban point,
the banpoint table holds it in two separate rows:

banpoint_id , userid , banreason, banpoint, admin_id
1 ,  7 , 'AAA' , 40 , 1 
2 ,  7 , 'BBB' , 50 , 1

Now select * from the users table and count all the banpoints for each users.

select users.userid ,users.username, COUNT(banpoint.banpoint) AS banp FROM users
LEFT JOIN banpoint ON banpoint.userid  = users.userid 
GROUP BY users.userid , users.username

millan

djjjozsi;10944168 wrote:
for example:
You have the users table:
userid , username, userlevel
You have banpoints table:
banpoint_id , userid , banreason, banpoint, admin_id, ban_date_time
My user id is 1.
If i select a user with an ID: 7 to add two knd of a ban point,
the banpoint table holds it in two separate rows:
banpoint_id , userid , banreason, banpoint, admin_id
1 ,  7 , 'AAA' , 40 , 1 
2 ,  7 , 'BBB' , 50 , 1 
Now select * from the users table and count all the banpoints for each users.
select users.userid ,users.username, COUNT(banpoint.banpoint) AS banp FROM users
LEFT JOIN banpoint ON banpoint.userid  = users.userid 
GROUP BY users.userid , users.username

Huh ok, can you tell me where exactly i should put all this?

djjjozsi

millan;10944183 wrote:
Huh ok, can you tell me where exactly i should put all this?

Try to change the example query to you needs. You have a normalized database,
now you just need to calculate the ban points from the banpoints table.

One change should make here:
reason in the banpoints table. Save here the ban reason text and not the ban poin value.

millan

djjjozsi;10944191 wrote:
Try to change the example query to you needs. You have a normalized database,
now you just need to calculate the ban points from the banpoints table.

One change should make here:
reason in the banpoints table. Save here the ban reason text and not the ban poin value.

Really sorry for bugin you like this, but can you enter all this in the script i posted and post it in php code here :/.

djjjozsi

put this on the top of your page in php block:

$options_reason = array( "AFK" => 15,
    "No-Demo" => 40,
    "Cheater" => 100 
    );

Then change your listbox where you selecte the reason:

        echo "<td><select name=\"banreason\">";
        echo "<option value=\"MNG\" SELECTED>Select a reason</option>";
        $nickname2 = $list2->nickname;

    foreach( $options_reason AS $key => $value )
    {
        $selected = isset( $_POST["banreason"] )AND $_POST["banreason"] == $key ? ' selected="selected"':'';
        echo "<option value=\"$key\"$selected>$key</option>";
    } 
    echo "</select><td></tr>";

Before you write into the ban reason and other info into the database,
you can get the reason and the point like this:

        $banpoint = $options_reason[$_POST["banreason"]];
        $reason = $_POST["banreason"];

Save these info into the banpoints table.

millan

Ain't workin

<?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>";

$options_reason = array( "AFK" => 15,
    "No-Demo" => 40,
    "Cheater" => 100
    );

$dbconn = mysql_connect( "localhost", "realwars_site", "3O5pqwS7");
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";
$banpoint = $options_reason[$_POST["banreason"]];
$reason = $_POST["banreason"];
echo "<option value=\"".$id."\">".$id." ( ".$nickname." )</option>";
}
echo "</tr>";
echo "<td><select name=\"banreason\">";
echo "<option value=\"MNG\" SELECTED>Select a reason</option>";
$nickname2 = $list2->nickname;

foreach( $options_reason AS $key => $value )
{
    $selected = isset( $_POST["banreason"] )AND $_POST["banreason"] == $key ? ' selected="selected"':'';
    echo "<option value=\"$key\"$selected>$key</option>";
}
echo "</select><td></tr>";
$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>";
}
}
}
?>

This is what i get