09.02.2016, 16:05
That is such a odd way to do it, use print(query); check if it actually working that way.
If you are using format at all, then dont use strcat.
or do like this
also in your mysql_query, you use query, while in strcat you use qstr.
If you are using format at all, then dont use strcat.
or do like this
pawn Код:
new string[64],query[1024];
strcat(query, "UPDATE `players` SET ");
format(string,sizeof(string),"`Admin` = '%d', ",PlayerInfo[playerid][pAdmin]); strcat(query,string);
format(string,sizeof(string),"`VIP` = '%d', ",PlayerInfo[playerid][pVip]); strcat(query,string);
format(string,sizeof(string),"`Weather` = '%d' WHERE `Account_ID` = '%d'",PlayerInfo[playerid][Account_ID]); strcat(query,string);
mysql_query(mysql, query);