Загрузка:
PHP код:
new wa[100];
cache_get_field_content(0, "pWeapons", wa, mysql_connect_id, 50);
sscanf(wa, "p<|>iiiiiiiiiiiii", pInfo[playerid][pWeapons][0], pInfo[playerid][pWeapons][1], pInfo[playerid][pWeapons][2], pInfo[playerid][pWeapons][3], pInfo[playerid][pWeapons][4],
pInfo[playerid][pWeapons][5], pInfo[playerid][pWeapons][6], pInfo[playerid][pWeapons][7], pInfo[playerid][pWeapons][8], pInfo[playerid][pWeapons][9], pInfo[playerid][pWeapons][10], pInfo[playerid][pWeapons][11],
pInfo[playerid][pWeapons][12]);
cache_get_field_content(0, "pAmmo", wa, mysql_connect_id, 50);
sscanf(wa, "p<|>iiiiiiiiiiiii", pInfo[playerid][pAmmo][0], pInfo[playerid][pAmmo][1], pInfo[playerid][pAmmo][2], pInfo[playerid][pAmmo][3], pInfo[playerid][pAmmo][4], pInfo[playerid][pAmmo][5], pInfo[playerid][pAmmo][6],
pInfo[playerid][pAmmo][7], pInfo[playerid][pAmmo][8],pInfo[playerid][pAmmo][9], pInfo[playerid][pAmmo][10], pInfo[playerid][pAmmo][11], pInfo[playerid][pAmmo][12]);
Сохранение:
PHP код:
static str[] = "UPDATE `accounts` SET `pWeapons` = '%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d', `pAmmo` = '%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d|%d' WHERE `pID` = '%d'";
new query[sizeof str+100+(-13*4)+(-2+11)];
for(new i = 0; i < 13; i++) GetPlayerWeaponData(playerid, i, pInfo[playerid][pWeapons][i], pInfo[playerid][pAmmo][i]);
mysql_format(mysql_connect_id, query, sizeof query, str, pInfo[playerid][pWeapons][0], pInfo[playerid][pWeapons][1], pInfo[playerid][pWeapons][2], pInfo[playerid][pWeapons][3], pInfo[playerid][pWeapons][4],
pInfo[playerid][pWeapons][5], pInfo[playerid][pWeapons][6], pInfo[playerid][pWeapons][7], pInfo[playerid][pWeapons][8], pInfo[playerid][pWeapons][9], pInfo[playerid][pWeapons][10], pInfo[playerid][pWeapons][11],
pInfo[playerid][pWeapons][12], pInfo[playerid][pAmmo][0], pInfo[playerid][pAmmo][1], pInfo[playerid][pAmmo][2], pInfo[playerid][pAmmo][3], pInfo[playerid][pAmmo][4], pInfo[playerid][pAmmo][5], pInfo[playerid][pAmmo][6],
pInfo[playerid][pAmmo][7], pInfo[playerid][pAmmo][8],pInfo[playerid][pAmmo][9], pInfo[playerid][pAmmo][10], pInfo[playerid][pAmmo][11], pInfo[playerid][pAmmo][12], pInfo[playerid][pID]);
mysql_function_query(mysql_connect_id, query, false, "", "");