Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock MySQL_Save(playerid)
- {
- if( online[playerid] )
- {
- new
- Float: pos[3], // 0,1,2 - pozicija;
- Query[512];
- printf("Išsaugomas %s", GetPlayerNameEx(playerid));
- GetPlayerPos(playerid,pos[0],pos[1],pos[2]);
- format( Query,sizeof( Query ),"UPDATE `zaidejai` SET x = '%f', y = '%f', z = '%f' WHERE vardas = '%s'",\
- pos[0], pos[1], pos[2], GetPlayerNameEx( playerid ));
- mysql_query( Query );
- playerData[playerid][pSkin] = GetPlayerSkin(playerid);
- playerData[playerid][pPinigai] = GetPlayerMoney(playerid);
- playerData[playerid][pPatirtis] = GetPlayerScore(playerid);
- format( Query, sizeof(Query),"UPDATE `zaidejai` SET skin = '%i', pinigai = '%i', patirtis = '%i', prazaide = '%i' WHERE vardas = '%s'",\
- playerData[playerid][pSkin], playerData[playerid][pPinigai], playerData[playerid][pPatirtis], playerData[playerid][pPrazaide],GetPlayerNameEx(playerid));
- mysql_query( Query );
- new Float:HP, Float:ARM;
- GetPlayerArmour(playerid, ARM);
- GetPlayerHealth(playerid, HP);
- format(Query, sizeof(Query), "UPDATE `zaidejai` SET hp = '%f', armour = '%f' WHERE vardas = '%s'",\
- HP,ARM, GetPlayerNameEx(playerid));
- mysql_query(Query);
- }
- return 1;
- }
- //=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- stock MySQL_Load(playerid)
- {
- new
- Float: pos[3], // 0,1,2 - pozicija;
- fetch[16],
- Query[256];
- format(Query, sizeof(Query), "SELECT * FROM `zaidejai` WHERE vardas = '%s'", GetPlayerNameEx(playerid));
- mysql_query(Query);
- mysql_store_result();
- mysql_retrieve_row();
- mysql_fetch_field_row( fetch, "x" );
- pos[0] = floatstr(fetch);
- mysql_fetch_field_row( fetch, "y" );
- pos[1] = floatstr(fetch);
- mysql_fetch_field_row( fetch, "z" );
- pos[2] = floatstr(fetch);
- SetPlayerPos( playerid, pos[0], pos[1], pos[2] + 0.75);
- mysql_fetch_field_row( fetch,"skin" ); playerData[playerid][pSkin] = strval(fetch); SetPlayerSkin(playerid, playerData[playerid][pSkin]);
- mysql_fetch_field_row( fetch,"pinigai" ); playerData[playerid][pPinigai] = strval(fetch); GivePlayerMoney(playerid, playerData[playerid][pPinigai]);
- mysql_fetch_field_row( fetch,"patirtis" ); playerData[playerid][pPatirtis] = strval(fetch); SetPlayerScore(playerid, playerData[playerid][pPatirtis]);
- mysql_fetch_field_row( fetch,"prazaide" ); playerData[playerid][pPrazaide] = strval(fetch);
- new Float: HP,
- Float: ARM;
- mysql_fetch_field_row( fetch,"hp" ); HP = floatstr( fetch ); SetPlayerHealth( playerid, HP);
- mysql_fetch_field_row( fetch,"armour" ); ARM = floatstr( fetch ); SetPlayerArmour( playerid, ARM);
- mysql_free_result();
- printf("Pakrautas žaidėjas. [%s]", GetPlayerNameEx(playerid));
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment