stock mysql_load(playerid)
{
new
Float:pos[3],
fetch[16],
query[256],
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" );
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]);
//--
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_fetch_field_row( fetch,"lytis" ); playerData[playerid][lytis] = strval(fetch);
//--
mysql_free_result();
printf("LOAD: [%s]", PlayerName(playerid));
return 1;
}