Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock mysql_save(playerid)
- {
- if(online[playerid])
- {
- new
- Float:coord[3],
- query[512],
- Float:HP,
- Float:ARMOUR;
- printf("SAVE : [%s]", PlayerName(playerid));
- //--
- GetPlayerPos(playerid, coord[0], coord[1], coord[2]);
- format(query, sizeof(query), "UPDATE `players` SET x = '%f', y = '%f', z = '%f' WHERE Vardas = '%s'" ,\
- coord[0], coord[1], coord[2]);
- mysql_query(query);
- //--
- playerData[playerid][skin] = GetPlayerSkin(playerid);
- playerData[playerid][moneyPocket] = GetPlayerMoney(playerid);
- playerData[playerid][xp] = GetPlayerScore(playerid);
- GetPlayerHealth(playerid, HP);
- GetPlayerArmour(playerid, ARMOUR);
- //--
- format(query, sizeof(query), "UPDATE `players` SET skin = '%i', moneyPocket = '%i', patirtis = '%i' WHERE Vardas = '%s'",\
- playerData[playerid][skin], playerData[moneyPocket], playerData[playerid][xp], PlayerName(playerid));
- mysql_query(query);
- //--
- format(query, sizeof(query), "UPDATE `players` SET hp = '%f', armour = '%f' WHERE Vardas = '%s'",\
- HP, ARMOUR, PlayerName(playerid));
- mysql_query(query);
- }
- return 1;
- }
- stock mysql_load(playerid)
- {
- if(online[playerid])
- {
- new
- Float:coord[3],
- query[512],
- fetch[16],
- Float:HP,
- Float:ARMOUR;
- format(query, sizeof(query), "SELECT * FROM `players` WHERE Vardas = '%s'", PlayerName(playerid));
- mysql_query(query);
- mysql_store_result();
- mysql_retrieve_row();
- //--
- mysql_fetch_field_row( fetch, "x" );
- coord[0] = floatstr(fetch);
- mysql_fetch_field_row( fetch, "y" );
- coord[1] = floatstr(fetch);
- mysql_fetch_field_row( fetch, "z" );
- coord[2] = floatstr(fetch);
- SetPlayerPos(playerid, coord[0], coord[1], coord[2] + 0.75);
- mysql_fetch_field_row(fetch,"skin"); playerData[playerid][skin] = strval(fetch); SetPlayerSkin(playerid, playerData[playerid][skin]);
- mysql_fetch_field_row(fetch,"moneyPocket"); playerData[playerid][moneyPocket] = strval(fetch); GivePlayerMoney(playerid, playerData[playerid][moneyPocket]);
- mysql_fetch_field_row(fetch,"patirtis"); playerData[playerid][xp] = strval(fetch); SetPlayerScore(playerid, playerData[playerid][xp]);
- mysql_fetch_field_row(fetch,"hp"); HP = floatstr(fetch); SetPlayerHealth(playerid, HP);
- mysql_fetch_field_row(fetch,"armour"); ARMOUR = floatstr(fetch); SetPlayerArmour(playerid, ARMOUR);
- //--
- mysql_free_result();
- //--
- printf("[LOAD]: [%s]", PlayerName(playerid));
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment