MySQL cuvanje

Problem(error/warning): Evo ovako koji je moj problem, kada hocu nesto da setam ili kada izadjem sa servera on nista ne sacuva, a uradio sam cuvanje kod OnPlayerDisconnect, ali nista se ne desava.
Kada setam admina bilo koji level, nece da update u bazi taj level niti da sacuva, kada setam novac isto nece da update niti da sacuva, isto tako i kada zelim da promenim ime nece da update niti da saciva, plus kada se registrujem iznova sa drugim imenom on opet kreira user_id '0'.
Dio skripte:

stock sql_user_update_disc(playerid)
{
	new playersip;
    GetPlayerIp(playerid, playersip, sizeof(playersip));
    new query, datum; new year, month, day, hour, minute, second;
	gettime(hour, minute, second);
	format(datum, sizeof(datum), "%02d/%02d/%d - %d/%d/%d", day, month, year, hour, minute, second);
	strmid(PlayerInfo, datum, 0, strlen(datum), 64);
    mysql_format(sqlBase, query, sizeof(query), "UPDATE `users` SET `isonline` = '0', `novac` = '%d', `level` = '%d', `exp` = '%d', `user_ip` = '%e'",
		PlayerInfo, PlayerInfo, PlayerInfo, playersip);
	mysql_format(sqlBase, query, sizeof(query), "%s, `zatvor` = '%d', `zatvorvreme` = '%d', `plataminuti` = '%d', `last_login` = NOW() WHERE `user_id` = '%d' LIMIT 1",
		query, PlayerInfo, PlayerInfo, PlayerInfo, PlayerInfo, PlayerInfo);
	mysql_pquery(sqlBase, query, "", "");
	return 1;
}

Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): [ code ]vaš odgovor[ /code ]
Slika/video ingame problema(obavezno ako je ingame problem): //

nmz ni sačuvati kad mu za user_id daješ PlayerInfo

dsquared wrote on January 17, 2019, 12:51 pm:

nmz ni sačuvati kad mu za user_id daješ PlayerInfo

To sam ispravio, ali opet on ne updejtuje kada mu ja setam nesto i kada god se opet registrujem sa novim imenom on opet postavlja user_id '0'.

Slika: https://imgur.com/a/9EKrw5t

jesi stavio AUTO_INCREMENT u bazi? i daj kreiranje i učitavanje igrača

i provjeri mysql logove da li ti baca nešto

dsquared wrote on January 17, 2019, 12:59 pm:

jesi stavio AUTO_INCREMENT u bazi? i daj kreiranje i učitavanje igrača

i provjeri mysql logove da li ti baca nešto

Sto je zanimljivo ni ne baca nista u logovima, AUTO_INCREMENT nisam stavio.

function sql_LoadPlayer(playerid)
{
	static rows;
	cache_get_row_count(rows);
	if(rows)
	{
	    cache_get_value_name_int(0, "user_id", PlayerInfo);
	    cache_get_value_name_int(0, "novac", PlayerInfo);
	    cache_get_value_name_int(0, "admin", PlayerInfo);
	    cache_get_value_name_int(0, "ubistva", PlayerInfo);
	    cache_get_value_name_int(0, "smrti", PlayerInfo);
	    cache_get_value_name_int(0, "skin", PlayerInfo);
	    cache_get_value_name_int(0, "godine", PlayerInfo);
	    cache_get_value_name_int(0, "drzava", PlayerInfo);
	    cache_get_value_name_int(0, "pol", PlayerInfo);
	    cache_get_value_name(0, "email", PlayerInfo, EMAIL_STRING);
	    cache_get_value_name_int(0, "spawn", PlayerInfo);
	    cache_get_value_name_int(0, "tutorial", PlayerInfo);
	    cache_get_value_name_int(0, "gm_level", PlayerInfo);
	    cache_get_value_name_int(0, "mutiran", PlayerInfo);
	    cache_get_value_name_int(0, "zatvor", PlayerInfo);
	    cache_get_value_name_int(0, "zatvorvreme", PlayerInfo);
	    cache_get_value_name_int(0, "warn", PlayerInfo);
	    cache_get_value_name_int(0, "level", PlayerInfo);
	    cache_get_value_name_int(0, "exp", PlayerInfo);
	    cache_get_value_name_int(0, "satiigre", PlayerInfo);
	    cache_get_value_name_int(0, "plataminuti", PlayerInfo);
	    cache_get_value_name_int(0, "novacbanka", PlayerInfo);
	    cache_get_value_name_int(0, "zlato", PlayerInfo);
	    cache_get_value_name_int(0, "promoter", PlayerInfo);
	    cache_get_value_name_int(0, "posao", PlayerInfo);
	    cache_get_value_name_int(0, "ugovor", PlayerInfo);
	    cache_get_value_name(0, "last_login", PlayerInfo, 64);
	    cache_get_value_name(0, "reg_date", PlayerInfo, 64);
	    cache_get_value_name_int(0, "registrovan", PlayerInfo);
	    //----------------------------------------------------------------------
    	new datum; new year, month, day;
		getdate(year, month, day);
		new hour, minute, second;
		gettime(hour, minute, second);
		format(datum, sizeof(datum), "%02d/%02d/%d - %d/%d/%d", day, month, year, hour, minute, second);
		strmid(PlayerInfo, datum, 0, strlen(datum), 64);
	    if(PlayerInfo == 0)
		{
			SCM(playerid, -1, ""col_tblue"Tutorial: "col_bela"Niste procitali uvodni deo, sada ce vam biti prikazano !");
			TogglePlayerControllable(playerid, 0);
			TutorialTimer = SetTimerEx("CitaTutorial", 3000, 0, "ii", playerid, 1);
		  	SetPlayerInterior(playerid, 0);
		  	SetPlayerPos(playerid, 1418.9274,-919.0040,36.0469);
		  	TogglePlayerControllable(playerid, 0);
			SetPlayerCameraPos(playerid, 1347.42, -950.93, 51.25);
			SetPlayerCameraLookAt(playerid, 1350.76, -947.21, 50.94);
			return 1;
		}
		else
		{
		    UlogovanProvera = 1;
			SetCameraBehindPlayer(playerid);
			m_SetSpawnInfo(playerid);
			SpawnPlayer(playerid);
			TogglePlayerSpectating(playerid, 0);
			SetPlayerVirtualWorld(playerid, 0);
			KreirajRegTD(playerid, 4);
			return 1;
		}
	}
	return 1;
}

stock sql_create_account(playerid)
{
	new query, playersip;
	strmid(PlayerInfo, PlayerInfo, 0, strlen(PlayerInfo), 64);
	GetPlayerIp(playerid, playersip, sizeof(playersip));
	mysql_format(sqlBase, query, sizeof(query),
		"INSERT INTO `users` (pname, isonline, password, pol, godine, novac, level, skin, spawn, user_ip, registrovan, drzava, email, last_login, reg_date) \
			VALUES('%e', '1', '%e', '%d', '%d', '%d', '%d', '%d', '%d', '%e', '%d', '%d', '%e',  NOW(), NOW())",
		GetName(playerid), PlayerInfo, PlayerInfo, PlayerInfo,
        PlayerInfo, PlayerInfo, PlayerInfo, PlayerInfo,
        playersip, PlayerInfo, PlayerInfo, PlayerInfo,
        PlayerInfo, PlayerInfo);
	mysql_pquery(sqlBase, query, "OnAccountRegister", "i", playerid);
	return 1;
}

Kreiranje i load mi se čini ok sve, http://prntscr.com/m8f4y7 jel ti ovako izgleda?

Pa moraš staviti auto_inc da ti automatski postavlja sql idove inače će ti sve pomješati kao što sada radi hahaha

dsquared wrote on January 17, 2019, 1:08 pm:

Kreiranje i load mi se čini ok sve, http://prntscr.com/m8f4y7 jel ti ovako izgleda?

Ovako mn izgleda: https://imgur.com/a/2PMUYn3

Kako da postavim to u bazi AUTO_INCREMENT

Nije preporucljivo da cuvas podatke na opd, jer ako ti server padne nece ti nista sacuvati. Updejtuj podatke pri promenama radi sigurnosti.

Koju verziju SQL-a koristiš, isto tako pokaži nam kako kreiraš tablu.

Chuffy wrote on January 17, 2019, 1:26 pm:

Koju verziju SQL-a koristiš, isto tako pokaži nam kako kreiraš tablu.

Sve sada lepo radi, ali opet on ne cuva, niti nece da updejtuje user-a, stoji onako kako je kreirao kada sam se registrovao i to je to, kada setam nesto ili na loginu kada se spawnam stavi sql_user_update_int(playerid, "isonline", 1); ono stoji u bazi isonline 0.