[SOLVED]warning 213: tag mismatch for sql syntaxes (format, tquery)

[SOLVED]warning 213: tag mismatch for sql syntaxes (format, tquery) - 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: [SOLVED]warning 213: tag mismatch for sql syntaxes (format, tquery) (/showthread.php?tid=655779)

[SOLVED]warning 213: tag mismatch for sql syntaxes (format, tquery) - Sibuscus - 29.06.2018

This is most of hte lines from where I get a warning

Код:

mysql_format(g_Sql, query, sizeof(query), "UPDATE `accounts` SET `Cash` = %d WHERE `ID` = %d", PlayerInfo[playerid][Cash], PlayerInfo[playerid][ID]);
mysql_tquery(g_Sql, query, "", "");
mysql_format(g_Sql, query, sizeof(query), "UPDATE `accounts` SET `isBanned` = 1 WHERE `Name` = '%e'", Banned);


g_Sql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);

//I also have it here:
mysql_close(g_Sql);

mysql_format(g_Sql, query, sizeof(query), "SELECT `ID`, `Password` FROM `accounts` WHERE `Name` = '%e' LIMIT 1", PlayerName);
mysql_tquery(g_Sql, query, "OnAccountCheck", "i", playerid);

So, i have warning everywhere there's tquery and/or format for mysql.

I have it defined like this:

Код:

new MYSQL:g_Sql;

Here's how my tables look

I have at least 40 warnings. Everything is working fine, but I want my compiler output to be clean.

Re: warning 213: tag mismatch for sql syntaxes (format, tquery) - Verc - 29.06.2018

I'm not that expert,but shouldn't it be 'MySQL' instead of MYSQL?

Re: warning 213: tag mismatch for sql syntaxes (format, tquery) - Sibuscus - 29.06.2018

Quote:

Originally Posted by Verc

I'm not that expert,but shouldn't it be 'MySQL' instead of MYSQL?

Yup, that worked, lol, I spent 1 hour checking my tables in phpadmin, correcting code, and it was this crap, lol THanks, +rep