Guest User

Untitled

a guest
Jun 10th, 2015
299
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 2.56 KB | None | 0 0
  1. stock mysql_save(playerid)
  2. {
  3.     if(online[playerid])
  4.     {
  5.         new
  6.             Float:coord[3],
  7.             query[512],
  8.             Float:HP,
  9.             Float:ARMOUR;
  10.         printf("SAVE : [%s]", PlayerName(playerid));
  11.         //--
  12.         GetPlayerPos(playerid, coord[0], coord[1], coord[2]);
  13.         format(query, sizeof(query), "UPDATE `players` SET x = '%f', y = '%f', z = '%f' WHERE Vardas = '%s'" ,\
  14.         coord[0], coord[1], coord[2]);
  15.         mysql_query(query);
  16.         //--
  17.         playerData[playerid][skin] = GetPlayerSkin(playerid);
  18.         playerData[playerid][moneyPocket] = GetPlayerMoney(playerid);
  19.         playerData[playerid][xp] = GetPlayerScore(playerid);
  20.         GetPlayerHealth(playerid, HP);
  21.         GetPlayerArmour(playerid, ARMOUR);
  22.         //--
  23.         format(query, sizeof(query), "UPDATE `players` SET skin = '%i', moneyPocket = '%i', patirtis = '%i' WHERE Vardas = '%s'",\
  24.         playerData[playerid][skin], playerData[moneyPocket], playerData[playerid][xp], PlayerName(playerid));
  25.         mysql_query(query);
  26.         //--
  27.         format(query, sizeof(query), "UPDATE `players` SET hp = '%f', armour = '%f' WHERE Vardas = '%s'",\
  28.         HP, ARMOUR, PlayerName(playerid));
  29.         mysql_query(query);
  30.     }
  31.     return 1;
  32. }
  33.  
  34. stock mysql_load(playerid)
  35. {
  36.     if(online[playerid])
  37.     {
  38.         new
  39.             Float:coord[3],
  40.             query[512],
  41.             fetch[16],
  42.             Float:HP,
  43.             Float:ARMOUR;
  44.         format(query, sizeof(query), "SELECT * FROM `players` WHERE Vardas = '%s'", PlayerName(playerid));
  45.         mysql_query(query);
  46.         mysql_store_result();
  47.         mysql_retrieve_row();
  48.         //--
  49.         mysql_fetch_field_row( fetch, "x" );
  50.         coord[0] = floatstr(fetch);
  51.         mysql_fetch_field_row( fetch, "y" );
  52.         coord[1] = floatstr(fetch);
  53.         mysql_fetch_field_row( fetch, "z" );
  54.         coord[2] = floatstr(fetch);
  55.         SetPlayerPos(playerid, coord[0], coord[1], coord[2] + 0.75);
  56.         mysql_fetch_field_row(fetch,"skin");          playerData[playerid][skin] = strval(fetch);        SetPlayerSkin(playerid, playerData[playerid][skin]);
  57.         mysql_fetch_field_row(fetch,"moneyPocket");   playerData[playerid][moneyPocket] = strval(fetch); GivePlayerMoney(playerid, playerData[playerid][moneyPocket]);
  58.         mysql_fetch_field_row(fetch,"patirtis");      playerData[playerid][xp] = strval(fetch);          SetPlayerScore(playerid, playerData[playerid][xp]);
  59.         mysql_fetch_field_row(fetch,"hp");            HP = floatstr(fetch);                              SetPlayerHealth(playerid, HP);
  60.         mysql_fetch_field_row(fetch,"armour");        ARMOUR = floatstr(fetch);                          SetPlayerArmour(playerid, ARMOUR);
  61.         //--
  62.         mysql_free_result();
  63.         //--
  64.         printf("[LOAD]: [%s]", PlayerName(playerid));
  65.     }
  66.     return 1;
  67. }
Advertisement
Add Comment
Please, Sign In to add comment