[dominik523]

I've tried with strcat and it's still crashing.

pawn Код:

format(query, sizeof(query), "UPDATE `businesses` SET `Type`='%d', `Owner`='%e', `Name`='%e', `Locked`='%d', `X`='%.2f', ",\
        BizInfo[i][Type], BizInfo[i][Owner], BizInfo[i][Name], BizInfo[i][Locked], BizInfo[i][Position][0]);
        new string[128];
        format(string, sizeof(string), "`Y`='%.2f', `Z`='%.2f', `Price`='%d' WHERE `ID`='%d'",\
        BizInfo[i][Position][1], BizInfo[i][Position][2], BizInfo[i][Price], BizInfo[i][ID]);
        
        strcat(query, string);
        mysql_tquery(mysql, query, "", "");

EDIT: I tried to update only one field with only one query, and it's still crashing.

pawn Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `businesses` SET `Type`='%d' WHERE `ID`='%d'",\
        BizInfo[i][Type], BizInfo[i][ID]);
        mysql_tquery(mysql, query, "", "");