pomoc Po odhlášení se vypne mod

[Stellet 7]

Zdravím, když se odhlásí někdo ze serveru tak se prostě vypne mod...

Než se někdo odpojí tak jdou příkazy a když se odpojí tak nejdou.

 

OnPlayerDisconnect:

public OnPlayerDisconnect(playerid, reason)
{
	new nick[MAX_PLAYER_NAME]; GetPlayerName(playerid, nick, sizeof(nick));
	for(new i=0; i<sizeof(Vozidlo); i++)
	{
	    if(Vozidlo[i][id_x]==0)continue;
	    if(strcmp(Vozidlo[i][majitel], nick, true)) continue;
	    GetVehiclePos(Vozidlo[i][id_x], Vozidlo[i][c_x],  Vozidlo[i][c_y],  Vozidlo[i][c_z]);
	    GetVehicleZAngle(Vozidlo[i][id_x], Vozidlo[i][c_a]);
	    GetVehicleColor(Vozidlo[i][id_x], Vozidlo[i][colora], Vozidlo[i][colorb]);
	    new query[300];
	    format(query, sizeof(query), "UPDATE vozidla SET x='%f', y='%f', z='%f', a='%f', spz='%s', barvaa='%i', barvab='%i', clvm='%i' WHERE id='%i'",
			Vozidlo[i][c_x],
			Vozidlo[i][c_y],
			Vozidlo[i][c_z],
			Vozidlo[i][c_a],
			Vozidlo[i][spz],
			Vozidlo[i][colora],
			Vozidlo[i][colorb],
			Vozidlo[i][clvm],
			Vozidlo[i][db_id]);
		mysql_function_query(dbhandle, query, false, "", "");
	    DestroyVehicle(Vozidlo[i][id_x]);
	    Vozidlo[i][id_x]=0;
	}
	uloz_hrace(playerid);
	reset_hrace(playerid);
	KillTimer(Ulozeni[playerid]);
	return 1;
}

uloz_hrace:

uloz_hrace(playerid)
{
	if(Player[playerid][prihlasen] == 0) return 1;
	new query[4000], jmeno[MAX_PLAYER_NAME];
	GetPlayerName(playerid, jmeno, sizeof(jmeno));
	GetPlayerPos(playerid, Player[playerid][posx], Player[playerid][posy], Player[playerid][posz]);
	format(query, sizeof(query),
	"UPDATE user SET admin='%i', money='%i', PosX='%f', PosY='%f', PosZ='%f', frakce='%i', rank='%i', lvm='%i', vek='%i', pohlavi='%i', kamos='%s', rasa='%i', skill='%i', skin='%i', bpenize='%d', fnick='%s' WHERE username='%s'",
		Player[playerid][Admin],
		GetPlayerMoney(playerid),
		Player[playerid][posx],
		Player[playerid][posy],
		Player[playerid][posz],
		Player[playerid][frakce],
		Player[playerid][rank],
		Player[playerid][lvm],
		Player[playerid][Vek],
		Player[playerid][Pohlavi],
		Player[playerid][Kamos],
		Player[playerid][Rasa],
		Player[playerid][Skill],
		Player[playerid][Skin],
		Player[playerid][BankPenize],
		Player[playerid][ForumNick],
		jmeno);
	mysql_function_query(dbhandle, query, false, "", "");
	printf("Hrac %s ulozen.", RJmeno(playerid));
	return 1;
}

reset_hrace:

reset_hrace(playerid)
{
	new str[100];
	format(str, sizeof(str), "-");
	
	Player[playerid][prihlasen] = 0;
	Player[playerid][Admin] = 0;
	Player[playerid][ID] = 0;
	Player[playerid][frakce] = 0;
	Player[playerid][rank] = 0;
	Player[playerid][lvm] = 0;
	Player[playerid][Platba] = 0;
	Player[playerid][posx] = 0.0;
	Player[playerid][posy] = 0.0;
	Player[playerid][posz] = 0.0;
	Player[playerid][Hide] = 0;
	Player[playerid][Duty] = 0;
	Player[playerid][Spot] = 0;
	Player[playerid][Vek] = 0;
	Player[playerid][Pohlavi] = 0;
	Player[playerid][Kamos] = str;
	Player[playerid][Rasa] = 0;
	Player[playerid][Skill] = 0;
	Player[playerid][BankPenize] = 0;
	return 1;
}

Problém je že jak mám printf v uloz_hrace tak to ani do konzole nic nenapíše a vůbec netuším proč..

Za všechny rady moc děkuji.

 

Edit: Teď jsem se koukl do mysql_log.txt a je tam:

[ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id='1'' at line 1