Don't load (MYSQL). - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Don't load (MYSQL). (
/showthread.php?tid=350739)
Don't load (MYSQL). -
budelis - 13.06.2012
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
}
Re: Don't load (MYSQL). -
Skylar Grey - 13.06.2012
Did u follow proper instructions on how to create a MySql server? Databases, dumps, could be anything. Best to do it again
Re: Don't load (MYSQL). -
budelis - 13.06.2012
It's work on windows server, but on HOST no.