08.05.2014, 13:33
PHP код:
stock LoginPlayer(playerid)
{
new query[126];
format(query, sizeof(query), "SELECT * FROM playerdata WHERE Name = '%s'", GetName(playerid));
mysql_query(query);
printf("Debug 1:%s", query); // Like this
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(query, "ID"); PlayerInfo[playerid][ID] = strval(query);
mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
mysql_fetch_field_row(query, "AdminLevel"); PlayerInfo[playerid][AdminLevel] = strval(query);
mysql_fetch_field_row(query, "PlayerPos");
sscanf(query, "fff", PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
mysql_fetch_field_row(query, "Cash"); PlayerInfo[playerid][Cash] = strval(query);
}
GivePlayerMoney(playerid, PlayerInfo[playerid][Cash]);
SetSpawnInfo(playerid, 0, 299, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
SetPlayerPos(playerid, PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);
}
PHP код:
format(query, sizeof(query), "SELECT * FROM playerdata WHERE `Name` = '%s'", GetName(playerid));