Mysql not loading
#4

PHP код:
stock LoginPlayer(playerid)
{
    new 
query[126];
    
format(querysizeof(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(playeridPlayerInfo[playerid][Cash]);
    
SetSpawnInfo(playerid0299PlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2], 0000000);
    
SpawnPlayer(playerid);
    
SetPlayerPos(playeridPlayerInfo[playerid][Position][0], PlayerInfo[playerid][Position][1], PlayerInfo[playerid][Position][2]);

Btw, try this:
PHP код:
format(querysizeof(query), "SELECT * FROM playerdata WHERE `Name` = '%s'"GetName(playerid)); 
Reply


Messages In This Thread
Mysql not loading - by Blademaster680 - 08.05.2014, 12:40
Re: Mysql not loading - by ikbenremco - 08.05.2014, 13:19
Re: Mysql not loading - by Blademaster680 - 08.05.2014, 13:29
Re: Mysql not loading - by ikbenremco - 08.05.2014, 13:33

Forum Jump:


Users browsing this thread: 1 Guest(s)