fetch bool MySQL r7 - Printable Version

fetch bool MySQL r7 - 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)
+--- Thread: fetch bool MySQL r7 (/showthread.php?tid=399329)

fetch bool MySQL r7 - gilpenner - 13.12.2012

Hey guys, I need some help, I'm trying to fetch boolean using MySQL r7.
Is it possible?

Btw, I searched and I asked on BlueG topic and I didn't find any answer.

Re: fetch bool MySQL r7 - ReneG - 13.12.2012

Don't know if it's possible, but you can just use 1 or 0 with a tinyint as the data type.

Re: fetch bool MySQL r7 - gilpenner - 13.12.2012

The point is, I'm using y_cmd, and I want to give a permission to someone use this command.

Command_SetPlayerNamed("command", playerid, true);

how should I do that using MySQL?

Re: fetch bool MySQL r7 - ReneG - 14.12.2012

pawn Код:

new content[2];

cache_get_row(0, 0, content);

if(strval(content)) {
    Command_SetPlayerNamed("command", playerid, true);
}

Re: fetch bool MySQL r7 - Vince - 14.12.2012

1 is true and 0 is false. I don't see the problem. If it complains about tag mismatch, then override the tag with bool:.