[budelis]

Hello everybody, can tell where is problem?

Код:

[15:58:29] CMySQLHandler::Query(SELECT Moneys,Kills,Deaths,Level,Exp,Admin,Vip FROM players WHERE Name = 'lllooo') - Successfully executed.
[15:58:29] >> mysql_store_result( Connection handle: 1 )
[15:58:29] CMySQLHandler::StoreResult() - Result was stored.
[15:58:29] >> mysql_fetch_row_format( Connection handle: 1 )
[15:58:29] CMySQLHandler::FetchRow() - Return: 49500|0|5|1|0|0|0
[15:58:29] >> mysql_fetch_field_row( Connection handle: 1 )
[15:58:29] CMySQLHandler::FetchField("Moneys") - 49500
[15:58:29] >> mysql_fetch_field_row( Connection handle: 1 )

How you see load just money:

Код:

[15:58:29] CMySQLHandler::FetchField("Moneys") - 49500
[15:58:29] >> mysql_fetch_field_row( Connection handle: 1 )

Where is Kills,Deaths,Levels and other?

Here is my loading:

Код:

stock LoadPlayerData(playerid)
{
new Query[ 200 ],savingstring[ 20];
format(Query,sizeof(Query),"SELECT Moneys,Kills,Deaths,Level,Exp,Admin,Vip FROM players WHERE Name = '%s'",GetPlayerNameEx(playerid));
mysql_query(Query);
mysql_store_result();
while(mysql_fetch_row_format(Query,"|"))
{
mysql_fetch_field_row( savingstring, "Moneys"); GivePlayerMoneyA(playerid, strval(savingstring));
mysql_fetch_field_row( savingstring, "Kills"); PlayerData[ playerid ][ Kills] = strval(savingstring);
mysql_fetch_field_row( savingstring, "Deaths"); PlayerData[ playerid ][ Deaths] = strval(savingstring);
mysql_fetch_field_row( savingstring, "Level"); PlayerData[ playerid ][ Level ] = strval(savingstring);
mysql_fetch_field_row( savingstring, "Exp"); SetPlayerScore( playerid, strval(savingstring));
mysql_fetch_field_row( savingstring, "Admin"); PlayerData[ playerid ][ Admin ] = strval(savingstring);
mysql_fetch_field_row( savingstring, "Vip"); PlayerData[ playerid ][ Vip ] = strval(savingstring);
}
mysql_free_result(); //We must always free a stored result
}

[Skylar Grey]

Did u follow proper instructions on how to create a MySql server? Databases, dumps, could be anything. Best to do it again

[budelis]

It's work on windows server, but on HOST no.