Mysql Help. -
pawn Код:
stock LoginPlayer(playerid, password[])
{
new query[128], pname[MAX_PLAYER_NAME], field[5][32], data[256];
GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
format(query, sizeof(query), "SELECT Name, Money, PlayerX, PlayerY, PlayerZ FROM accounts WHERE Name = '%s' AND Password = '%s'", pname, password);
mysql_query(query);
mysql_store_result();
if (mysql_fetch_row(data))
{
split(data, field, '|');
PlayerInfo[playerid][pName] = strval(field[0]);
PlayerInfo[playerid][pMoney] = strval(field[1]);
PlayerInfo[playerid][pPos_x] = floatstr(field[2]);
PlayerInfo[playerid][pPos_y] = floatstr(field[3]);
PlayerInfo[playerid][pPos_z] = floatstr(field[4]);
}
GivePlayerMoney(playerid, PlayerInfo[playerid][pName]);
SetSpawnInfo(playerid, 0, 294, PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 0,0,0,0,0,0,0);
return SpawnPlayer(playerid);
}
When it comes to load, it doesn't load well, it spawns me at blue berry (where cords are 0.0) and money is reset to 0.
Re: Mysql Help. -
Re: Mysql Help. -
Under OnGameModeInit and post the mysql log file that will be generated into your server directory.