quiTzor
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
News
Documentation
Posts posted by quiTzor
-
-
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.
Problema MySQL
in Arhivă probleme
Posted
@SoNNy.sys Iti multumesc , am rezolvat!