SA-MP Forums Archive
[Ajuda] O que to fazendo errado MYSQL? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] O que to fazendo errado MYSQL? (/showthread.php?tid=562962)


O que to fazendo errado MYSQL? - maikons - 12.02.2015

Devo ta cabaзando, mt tempo sem mexer, o que to fazendo de errado?

Код:
(4301 -- 4303) : warning 213: tag mismatch
(4301 -- 4304) : warning 213: tag mismatch
(4301 -- 4305) : warning 213: tag mismatch
(4301 -- 4306) : warning 213: tag mismatch
(4301 -- 4307) : warning 213: tag mismatch
(4301 -- 4308) : warning 213: tag mismatch
(4301 -- 4309) : warning 213: tag mismatch
format(query, sizeof(query), "UPDATE `factions` SET facname = %d, HQposX = %f, HQposY = %f, HQposZ = %f, spaz = %d, uzi = %d, ak = %d, WHERE ID = %d"

4301

Код:
stock SalvarFactions() {
	for(new factionid; factionid < MAX_FACTIONS; factionid++) {
		new query[1030];
        format(query, sizeof(query), "UPDATE `factions` SET facname = %d, HQposX = %f, HQposY = %f, HQposZ = %f, spaz = %d, uzi = %d, ak = %d, WHERE ID = %d"
        ,
            HouseInfo[factionid][facname],
            HouseInfo[factionid][HQposX],
            HouseInfo[factionid][HQposY],
            HouseInfo[factionid][HQposZ],
            HouseInfo[factionid][spaz],
            HouseInfo[factionid][uzi],
			HouseInfo[factionid][ak],
            HouseInfo[factionid][ID]);
        mysql_query(ConnectMYSQL, query);
	}
}


Re: O que to fazendo errado MYSQL? - n0minal - 13.02.2015

Verifica o enum e a especificaзгo das variбveis:

%f = Float:variavel
%d = variavel
%s = variavel[quantidade_de_caracteres]

Re: O que to fazendo errado MYSQL? - Bruno_Cyra - 13.02.2015

Sу pra constar, isso nгo й erro de mysql, isso й erro de pawn