Problem(error/warning): ÄŒuvanje podataka
Dio skripte:
public OnPlayerDisconnect(playerid, reason)
{
Corrupt_Check[playerid]++;
if(IsPlayerConnected(playerid))
{
new DB_Query[500];
mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `PLAYERS` SET `SCORE` = '%d', `CASH` = '%d', `KILLS` = '%d', `DEATHS` = '%d', `SKIN` = '%d', `ADMIN` = '%d' WHERE `ID` = '%d' LIMIT 1",
pInfo[playerid][Score], pInfo[playerid][Cash], pInfo[playerid][Kills], pInfo[playerid][Deaths], pInfo[playerid][Skin], pInfo[playerid][Admin], pInfo[playerid][ID]);
mysql_tquery(Database, DB_Query);
}
if(cache_is_valid(pInfo[playerid][Player_Cache]))
{
cache_delete(pInfo[playerid][Player_Cache]);
pInfo[playerid][Player_Cache] = MYSQL_INVALID_CACHE;
}
pInfo[playerid][LoggedIn] = false;
print("OnPlayerDisconnect has been called.");
return 1;
}
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema(obavezno ako je ingame problem): Jednostavno ne Äuva podatke nakon registracije, kao Å¡to su admin level, novac, skin, score. Moram otići relog i sve postaviti iznova kako bi saÄuvalo
(https://i.imgur.com/k4yLhgL.png)
Ne znam oko mySQL-a , zanima me zasto radis u njemu ako ga ne poznajes ?
#NoHate
#Offtopic na neki nacin xD
Nije poblem u samom mysqlu, nego u necem drugom, inace ne bi uopste upisivalo vrednosti ;)
Citat: Pawno poslato Januar 18, 2019, 23:07:25 POSLE PODNE
Nije poblem u samom mysqlu, nego u necem drugom, inace ne bi uopste upisivalo vrednosti ;)
Samo napred , ne znam ti ja ovo , neka je sa srecom!
Mozda Xunder zna , pitaj njega 8)
Gde si upisao SALT ?
Ima li išta u mysql logu? To je prvo što se pogleda..
A i najbolje ti je kod ovakvih stvari,umjesto da razbijaÅ¡ glavu,jer može biti najsitnija pogreÅ¡ka(npr može biti da krivo uÄitavaÅ¡ vrijednost IDa(bubam)) jednostavno dodati ispod mysql querya
[pawn]printf(DB_Query);[/pawn]
i onda pokušati pozvati taj upit preko phpmyadmina
Evo poÄelo je errore da izbacuje
[20:52:59] [plugins/mysql] cache_set_active: invalid cache id '0'
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_get_value_name_int: no active cache
[20:52:59] [plugins/mysql] cache_delete: invalid cache id '0'
(https://i.imgur.com/LorkF6M.png)
(https://i.imgur.com/0NcuPA7.png)