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

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.
Reply
#2

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

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)