Executing query problem
#1

Hello guys
Im using latest R36-2 of BlueG mysql plugin when I am selecting name from DB it not working when I use %e placeholder for escaped string, but when I use %s it works: Here is mysql debug

Here you can see it executed query successfuly, it got player name and stored it to %s placeholder

mysql_tquery - connection: 1, query: "SELECT * FROM `Users` WHERE `Name` = 'Sanios' LIMIT 1", callback: "OnAccountCheck", format: "i"

Here you can see it didnt execute query successfuly, it didnt got player name. Here im using %e to escape string

mysql_tquery - connection: 1, query: "SELECT * FROM `Users` WHERE `Name` = 'e' LIMIT 1", callback: "OnAccountCheck", format: "i"
Reply
#2

Did you use mysql_format?

I had the same problem and I used the normal format instead of mysql_format.
My names were all "e"s instead of the real names.

The normal format function doesn't recognise "%e" and turns it into "e".
Reply
#3

Yeah, that was it. Already solved it maddinator helped

But thanks.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)