Jump to content
  • 0

Problema MySQL


quiTzor

Question

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.
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.