01.04.2015, 12:22
Hello BlueG.
Some kind of issue here...
SA-MP server 0.3z R4 with MySQL R39-3, running on Debian x64.
As you see, I've added 2 debugging messages.
They sends:
But, if I exec the same Query (just copy it from chat log) in phpmyadmin, it will return 10, not 0.

Here is a point: I'm adding some symbols from Russian alphabet in my Query (`Nick` = 'Эраст_Фандорин'), but it works just fine with phpmyadmin.
UPD: works fine without Russian symbols...can you fix it, please?
Some kind of issue here...
SA-MP server 0.3z R4 with MySQL R39-3, running on Debian x64.
PHP Code:
//In some public
new qwery[300];
format(qwery, sizeof(qwery), "SELECT `lvl` FROM `admins` WHERE BINARY `Nick` = '%s'", GN(playerid));
mysql_function_query(MySQL, qwery, true, "OnAdminQueryFinished", "i", playerid);
SendClientMessage(playerid, -1, qwery);
PHP Code:
public OnAdminQueryFinished(playerid)
{
new lvl = cache_get_row_int(0,0);
SendMes(playerid, -1, "%i", lvl);
if(lvl > 0)
{
//Don't exec
}
else
{
//exec
}
return 0;
}
They sends:
Code:
[15:09:17] SELECT `lvl` FROM `admins` WHERE BINARY `Nick` = 'Эраст_Фандорин' [15:09:17] 0

Here is a point: I'm adding some symbols from Russian alphabet in my Query (`Nick` = 'Эраст_Фандорин'), but it works just fine with phpmyadmin.
UPD: works fine without Russian symbols...can you fix it, please?

