[BigGroter]

pawn Код:

GetPlayerName(playerid, pName, sizeof(pName));
format(szQuery, sizeof(szQuery), "UPDATE `Houses` SET `Owner` = '%s' AND `Owned` = %d WHERE `hID` = %d", pName, 1, hInfo[i][hID]);
            mysql_function_query(dbHandle, szQuery, false, "thread_InsertHouse", "d", "playeird");

This prints owner as "0", same with "Owned", both 0's. Why?
Owner is a varchar(24) or something like that.

[NoahF]

Maybe this is the problem? "playeird"

[BigGroter]

That's not it, however, thank you for pointing it out.

[fordawinzz]

pawn Код:

GetPlayerName(playerid, pName, sizeof(pName));
format(szQuery, sizeof(szQuery), "UPDATE `Houses` SET `Owner` = '%s',`Owned` = 1 WHERE `hID` = %d", pName, hInfo[i][hID]);
mysql_function_query(dbHandle, szQuery, false, "", "");