[MySQL] Updating Player's Ban Information
#3

Alright, here's my Debug result Tyler12 It does say Successfully executed. but for some reason it doesn't set the variable to 1 in phpmyadmin

pawn Код:
[18:18:35] >> mysql_query( Connection handle: 1 )

[18:18:35] CMySQLHandler::Query(UPDATE `bans` SET  `Banned` = 1 WHERE Username = 'pds2012';) - Successfully executed.

[18:18:35] >> mysql_real_escape_string( Connection handle: 1 )

[18:18:35] CMySQLHandler::EscapeString(... test ... ,,, \ --[[); - Escaped 24 characters to ... test ... ,,, \\ --[[.

[18:18:35] >> mysql_query( Connection handle: 1 )

[18:18:35] CMySQLHandler::Query(INSERT INTO `bans` (Username, IpAdress, Reason, BannedBy) VALUES ('pds2012', 'pds2012', '... test ... ,,, \\ --[[', 'pds2012')) - Successfully executed.

[18:18:35] >> mysql_query( Connection handle: 1 )
MySQL Structure ( Image )


PS: I also tried removing ; at the last, but no. it still don't work
Reply


Messages In This Thread
Banning Player and inserting the Banned row [MySQL] - by Patrick - 27.09.2013, 16:58
Re: [MySQL] Updating Player's Ban Information - by tyler12 - 27.09.2013, 17:09
Re: [MySQL] Updating Player's Ban Information - by Patrick - 27.09.2013, 17:16
Re: [MySQL] Updating Player's Ban Information - by x96664 - 27.09.2013, 19:16
Banning Player and inserting the Banned row [MySQL] - by Patrick - 27.09.2013, 19:19

Forum Jump:


Users browsing this thread: 2 Guest(s)