09.11.2015, 22:11
i tried it like that and it doesnt insert the values now at all the bans table is empty eventhough i ban my self..
THATS MY MYSQL LOG
EDIT: I FIXED IT!
pawn Код:
[01:09:25] [DEBUG] mysql_format - connection: 1, len: 240, format: "INSERT INTO `bans` (`Name`, `Reason`, `BannedBy`, `IP`, `Status`) VALUES ('%s', '%s', '%s','%s', '%s', '1')"
[01:09:25] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `bans` (`Name`, `Reason`, `BannedBy`, `IP`, `Status`", callback: "(null)", format: "(null)"
[01:09:25] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:09:26] [DEBUG] mysql_format - connection: 1, len: 340, format: "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f,`Score` =%d, `Banned` =%d, `Cuffed` =%d, ..."
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 318.277 milliseconds
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:09:26] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Ґ', '1')' at line 1
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[01:09:26] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=5, `VIP`=0, `Money`=0, `posX`=965.8", callback: "(null)", format: "(null)"
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 79.348 milliseconds
[01:09:26] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
EDIT: I FIXED IT!