Guest User

Untitled

a guest
Oct 7th, 2018
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 2.73 KB | None | 0 0
  1. stock MySQL_Save(playerid)
  2. {
  3.     if( online[playerid] )
  4.     {
  5.         new
  6.             Float: pos[3], // 0,1,2 - pozicija;
  7.             Query[512];
  8.  
  9.         printf("Išsaugomas %s", GetPlayerNameEx(playerid));
  10.  
  11.         GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
  12.         format( Query,sizeof( Query ),"UPDATE `zaidejai` SET x = '%f', y = '%f', z = '%f' WHERE vardas = '%s'",\
  13.         pos[0], pos[1], pos[2], GetPlayerNameEx( playerid ));
  14.         mysql_query( Query );
  15.  
  16.  
  17.         playerData[playerid][pSkin] = GetPlayerSkin(playerid);
  18.         playerData[playerid][pPinigai] = GetPlayerMoney(playerid);
  19.         playerData[playerid][pPatirtis] = GetPlayerScore(playerid);
  20.  
  21.         format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', prazaide = '%i' WHERE vardas = '%s'",\
  22.         playerData[playerid][pSkin], playerData[playerid][pPinigai], playerData[playerid][pPatirtis], playerData[playerid][pPrazaide],GetPlayerNameEx(playerid));
  23.         mysql_query( Query );
  24.  
  25.         new Float:HP, Float:ARM;
  26.         GetPlayerArmour(playerid, ARM);
  27.         GetPlayerHealth(playerid, HP);
  28.         format(Query, sizeof(Query), "UPDATE `zaidejai` SET hp = '%f', armour = '%f' WHERE vardas = '%s'",\
  29.         HP,ARM, GetPlayerNameEx(playerid));
  30.         mysql_query(Query);
  31.     }
  32.     return 1;
  33. }
  34.  
  35. //=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  36. stock MySQL_Load(playerid)
  37. {
  38.     new
  39.         Float: pos[3], // 0,1,2 - pozicija;
  40.         fetch[16],
  41.         Query[256];
  42.  
  43.     format(Query, sizeof(Query), "SELECT * FROM `zaidejai` WHERE vardas = '%s'", GetPlayerNameEx(playerid));
  44.     mysql_query(Query);
  45.     mysql_store_result();
  46.     mysql_retrieve_row();
  47.  
  48.     mysql_fetch_field_row( fetch, "x" );
  49.     pos[0] = floatstr(fetch);
  50.     mysql_fetch_field_row( fetch, "y" );
  51.     pos[1] = floatstr(fetch);
  52.     mysql_fetch_field_row( fetch, "z" );
  53.     pos[2] = floatstr(fetch);
  54.  
  55.     SetPlayerPos( playerid, pos[0], pos[1], pos[2] + 0.75);
  56.  
  57.     mysql_fetch_field_row( fetch,"skin" );          playerData[playerid][pSkin] = strval(fetch);    SetPlayerSkin(playerid, playerData[playerid][pSkin]);
  58.     mysql_fetch_field_row( fetch,"pinigai" );       playerData[playerid][pPinigai] = strval(fetch); GivePlayerMoney(playerid, playerData[playerid][pPinigai]);
  59.     mysql_fetch_field_row( fetch,"patirtis" );      playerData[playerid][pPatirtis] = strval(fetch);    SetPlayerScore(playerid, playerData[playerid][pPatirtis]);
  60.     mysql_fetch_field_row( fetch,"prazaide" );      playerData[playerid][pPrazaide] = strval(fetch);
  61.  
  62.     new Float: HP,
  63.         Float: ARM;
  64.  
  65.     mysql_fetch_field_row( fetch,"hp" );            HP = floatstr( fetch );     SetPlayerHealth( playerid, HP);
  66.     mysql_fetch_field_row( fetch,"armour" );        ARM = floatstr( fetch );    SetPlayerArmour( playerid, ARM);
  67.    
  68.  
  69.     mysql_free_result();
  70.  
  71.     printf("Pakrautas žaidėjas. [%s]", GetPlayerNameEx(playerid));
  72.  
  73.     return 1;
  74. }
Advertisement
Add Comment
Please, Sign In to add comment