13.06.2012, 17:33
Hello everybody, can tell where is problem?
How you see load just money:
Where is Kills,Deaths,Levels and other?
Here is my loading:
Код:
[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 )
Код:
[15:58:29] CMySQLHandler::FetchField("Moneys") - 49500 [15:58:29] >> mysql_fetch_field_row( Connection handle: 1 )
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 }