Dont quiet understand

[Phpfr3ak]

$sql = "UPDATE players SET is_banned = 1 WHERE id = $id";
mysql_query($sql);

 

Sorry really not all that great i want to also ban MASTERPLAYERID i assumed it would be;

 

$sql = "UPDATE players SET is_banned = 1 WHERE id = $id AND WHERE MASTERPLAYERID = $MASTERPLAYERID";
mysql_query($sql);

 

But its not could someone inform me how to pull this off, Thanks.

[jcbones]

Really vague there.  We don't know what MASTERPLAYERID is, where it is stored, or how it is populated.  If you ban a player in the players table, and the database is normalized, then you should have no problem enforcing the ban anywhere in the script.

[AyKay47]

place this in your script to debug the query..

 

$sql = "UPDATE players SET is_banned = 1 WHERE id = $id AND WHERE MASTERPLAYERID = $MASTERPLAYERID";
mysql_query($sql) or die(mysql_error());

[jcbones]

2 where's in a query will fail.

[Phpfr3ak]

sorry for being so vague MASTERPLAYERID is in the player table, its basically used to control more than one account without having to use a password that works fine, the ban works as is just using;

 

$sql = "UPDATE players SET is_banned = 1 WHERE id = $id";
mysql_query($sql) or die(mysql_error());

 

But id also like it to ban everyone with thesame MASTERPLAYERID as well as the id that im banning. hope this makes more sense?

[AyKay47]

jcbones is right, I missed that, your syntax is wrong.. change to this..

 

$sql = "UPDATE players SET is_banned = 1 WHERE id = $id AND MASTERPLAYERID = $MASTERPLAYERID";

 

note case-sensitivity..

[jcbones]

I would remove the id=$id part, and just ban on the masterplayerid, that way, every account would be banned, and not just one row.

[Phpfr3ak]

Thanks guys, done jcbones worked great thanks alot!

[AyKay47]

Didn't fully understand the question. Glad you figured it out