MySQL | Does not return the correct value

MySQL | Does not return the correct value - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL | Does not return the correct value (/showthread.php?tid=266629)

MySQL | Does not return the correct value - EviLpRo - 05.07.2011

hello !

here the code:

pawn Код:

SendClientMessage(playerid,c_green,".дъзбшъ магойп бдцмзд");
        format(String,256,"SELECT `AdminLevel` FROM `Users` WHERE `Nick`='%s'",GetName(playerid));
        mysql_query(String);
        mysql_store_result();
        if(mysql_retrieve_row()) Player[playerid][AdminLevel] = mysql_fetch_int();
        mysql_free_result();

this not return the correct value.
this return 0.
please help (:

Re: MySQL | Does not return the correct value - Ozz - 05.07.2011

ey pal you have logges .. ?

Re: MySQL | Does not return the correct value - EviLpRo - 05.07.2011

I did not understand the question..

Re: MySQL | Does not return the correct value - playbox12 - 05.07.2011

He means logs, put

pawn Код:

mysql_debug(1);

under OnGameModeInit();

Then run the code, open mysql_log.txt and you see what has wen't wrong.

Re: MySQL | Does not return the correct value - EviLpRo - 05.07.2011

And ? what next ?