15.11.2011, 19:45
just put them into one single long query like:
pawn Код:
new query[800], pname[24];//You have to adjust everything to ur needs ofc ;)
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "UPDATE Table SET field1=%d, field2=%d, field3=%d, field4=%d,",field1[playerid],field2[playerid],field3[playerid],field4[playerid]);
format(query, sizeof(query), "%s field5=%d, field6=%d, field7=%d, field8=%d,",query,field5[playerid],field6[playerid],field7[playerid],field8[playerid]);
format(query, sizeof(query), "%s field9=%d, field10=%d WHERE name='%s'",query,field9[playerid],field10[playerid],pname);
mysql_query(query);