[WooTFTW]

Quote:

Originally Posted by Emmet_ pawn Код: new string[666]; format(string, sizeof(string), "SELECT X, Y, Z, A, Health, Armour, Money, Skin, kills, deaths, house, interior, virtualworld, bank, business, faction, factionrank, "); strcat(query, string); format(string, sizeof(string), "factionsalary, addictlevel, addictedfrom, addictstage, government, marijuana_skill, job, playercontract, playerpaycheck, playerpaychecktime, playerhoursonline, weapon_skill, fishing_skill, ArrestTime, vehicle, seat, mechanic_skill, "); strcat(query, string); format(string, sizeof(string), "playerLanguage, medicine_skill, hospital, renthouse, garage, restraunt, club FROM characters WHERE id = %i LIMIT 1", PlayerInfo[playerid][id]); strcat(query, string);

wtf i was thinking? This works too.

pawn Код:

format(query, sizeof(query), "SELECT X, Y, Z, A, Health, Armour, Money, Skin, kills, \
    deaths, house, interior, virtualworld, bank, business, faction, factionrank, \
    factionsalary, addictlevel, addictedfrom, addictstage, government, marijuana_skill, \
    job, playercontract, playerpaycheck, playerpaychecktime, playerhoursonline, \
    weapon_skill, fishing_skill, ArrestTime, vehicle, seat, mechanic_skill, \
    playerLanguage, medicine_skill, hospital, renthouse, garage, restraunt, \
    club FROM characters WHERE id = %i LIMIT 1",
    PlayerInfo[playerid][id]);
    mysql_query(query, THREAD_LOADSTATS, playerid);

EDIT:

pawn Код:

format(query, sizeof(query), "SELECT * FROM characters WHERE id = %i LIMIT 1", PlayerInfo[playerid][id]);
mysql_query(query, THREAD_LOADSTATS, playerid);

I'll use this instead.