13.01.2012, 18:37
You forgot the WHERE clause in your SELECT query, also you are trying to retrieve the row BEFORE the query and you are not storing the result 
And here there is no need of using mysql_free_result since you don't store anything 

pawn Код:
stock LoadPlayerInfo(iPlayer)
{
new
Query[700];
format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s';", pName(iPlayer));
mysql_query(Query);
mysql_store_result();
if(mysql_fetch_row(Query))
{
sscanf(Query, "e<p<|>s[24]s[35]dddddfffddd>", Player[iPlayer]); // Remember to update this if you add more info...
GivePlayerMoney(iPlayer, Player[iPlayer][pMoney]);
SetPlayerScore(iPlayer, Player[iPlayer][pLevel]);
SetSpawnInfo(iPlayer, 0, Player[iPlayer][pSkin], Player[iPlayer][pLastX], Player[iPlayer][pLastY], Player[iPlayer][pLastZ], 90, 0, 0, 0, 0, 0, 0);
}
mysql_free_result();
return 1;
}

pawn Код:
stock SavePInfo(playerid)
{
if(GetPVarInt(playerid, "LoggedIN") == 1)
{
new Float:x, Float:y, Float: z;
GetPlayerPos(playerid, x, y, z);
new
Query[600];
format(Query, sizeof(Query), "UPDATE `playerinfo` SET `kills` = %d, `deaths` = %d, `money` = %d, `AdminLevel` = %d, `Skin` = %d, `Last Pos X` = %f, `Last Pos Y` = %f, `Last Pos Z` = %f, `Interior` = %d, `DonatorLevel` = %d, `Level` = %d WHERE `user` = '%s'",
Player[playerid][pKills],
Player[playerid][pDeaths],
GetPlayerMoney(playerid),
Player[playerid][pAdminLevel],
GetPlayerSkin(playerid),
x,
y,
z,
GetPlayerInterior(playerid),
Player[playerid][pDonatorLevel],
GetPlayerScore(playerid),
pName(playerid));
mysql_query(Query);
return 1;
}
else return 0;
}