21.09.2015, 19:03
Hi. I'm trying to solve this problem since two days, but without result.
Let's describe it: At login, details from table are setted by id. For example, if my ID is 1, my money, level, adminlvl, etc are setted to 1. Is anyone who can help me?
![](http://s15.postimg.org/91mqr1nor/144285947075548.jpg)
Let's describe it: At login, details from table are setted by id. For example, if my ID is 1, my money, level, adminlvl, etc are setted to 1. Is anyone who can help me?
![](http://s15.postimg.org/91mqr1nor/144285947075548.jpg)
PHP код:
new query[128];
format(query, sizeof(query),"SELECT * FROM User WHERE Nume = '%s'",GetName(playerid));
mysql_query(query);
mysql_store_result();
/*if(mysql_num_rows())
if(mysql_fetch_row_format(query,"|"))*/
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_row_format(query, "Id"); PlayerInfo[playerid][pSQID] = strval(query);
mysql_fetch_row_format(PlayerInfo[playerid][Nume], "Nume");
mysql_fetch_row_format(PlayerInfo[playerid][Pass], "Parola");
mysql_fetch_row_format(query, "Level"); PlayerInfo[playerid][Level] = strval(query); SetPlayerScore(playerid,PlayerInfo[playerid][Level]);
mysql_fetch_row_format(query, "Bani"); PlayerInfo[playerid][BaniReali] = strval(query); GivePlayerMoney(playerid, PlayerInfo[playerid][BaniReali]);
mysql_fetch_row_format(query, "AdminLevel"); PlayerInfo[playerid][Adminlevel] = strval(query);
mysql_fetch_row_format(query, "SetSpawn"); PlayerInfo[playerid][SetSpawn] = strval(query);
mysql_fetch_row_format(query, "Spovedit"); PlayerInfo[playerid][SpovImp] = strval(query);
}