Problema intalnita (descriere): Salut. Am si eu o problema cu MySQL-ul, am si eu mai exact un server de trucking, si la finalul cursei am pus sa dea o anumita suma de bani, si nu inteleg de ce nu se updateaza in baza de date pretul nou. Daca am banii pe 0 si fac prima cursa imi seteaza banii adica 100000$, iar daca o mai fac pe a doua nu mai seteaza nimic, ramane la 100000$ Ero(area / rile) / warning-(ul / urile):
In debug_log afiseaza urmatoarele:
[20:55:40] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `Money`='100000' WHERE `Name`='KaLLoS'...
[20:55:40] [DEBUG] ProcessQueryThread() - Query was successful.
[20:55:40] [DEBUG] ProcessQueryThread() - Data caching enabled.
[20:55:40] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[20:55:40] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[20:55:40] [WARNING] CMySQLHandler::StoreResult() - No data to store.
Liniile de cod / sursa / script-ul:
forward UnLoading(playerid);
public UnLoading(playerid)
{
minfo[playerid][CheckpointID] = 0;
TogglePlayerControllable(playerid, 1);
format(s, sizeof(s), "{C10000}Info: {FFFFFF}Ai primit {3BB80D}${FFFFFF}%d pentru ca ai terminat misiunea.", P_DATA[playerid][pMoney]);
SendClientMessage(playerid, -1, s);//sa imi intre banii in cont !
GivePlayerMoney(playerid, P_DATA[playerid][pMoney]);
new string[560],name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
format(string, sizeof(string), "UPDATE `users` SET `Money`='%d' WHERE `Name`='%s'", P_DATA[playerid][pMoney], name);
mysql_function_query(1,string,true,"","");
OnPlayerFinishMission(playerid);
mysql_store_result();
#if defined USE_RACE_CHECKPOINT
DisablePlayerRaceCheckpoint(playerid);
#else
DisablePlayerCheckpoint(playerid);
#endif
return 1;
}Imagini / Video (optional): - Ati incercat sa rezolvati singur?: Da, cu multe metode, dar nu am reusit nimic.