Ïðîáëåìà ñ mysql

[Hawkins]

PHP Code:

stock OnPlayerUpdateEx1(playerid)
{
    if(GetPVarInt(playerid, "IsAuthed") > 0)
    {
        new query[1500], str[100];
        strcat(query, "UPDATE players SET ");
        format(str, sizeof(str), "`Cars`=%d,`Posc_x`=%f,`Posc_y`='%f',`Posc_z`='%f',`Posc_a`='%f',`Color1`='%d',`Color2`='%d' WHERE name = '%s'", PlayerInfo[playerid][pCar], PlayerInfo[playerid][Posc_x], PlayerInfo[playerid][Posc_y], PlayerInfo[playerid][Posc_z], PlayerInfo[playerid][Posc_a], PlayerInfo[playerid][pColor1], PlayerInfo[playerid][pColor2], getpl(playerid)); strcat(query, str);
        if(!mysql_query(query)) mysql_debug(1), mysql_query(query), mysql_debug(0);
    }
} 


Ïðè äèñêîííåêòå çíà÷åíèÿ â òàáëèöå íå îáíîâëÿþòñÿ.  ÷åì ïðîáëåìà?

[eakwarp]

Çà÷åì òàê èçâðàùàòüñÿ ñ çàïðîñîì? Îäíèì ôîðìàòîì ðåëèãèÿ îáîéòèñü íå ïîçâîëÿëà?

Ïî÷åìó òàêîé ðàçíîøåðñòíûé çàïðîñ?
Òóò òàê `Posc_x`=%f
à òóò òàê `Posc_z`='%f'

×òî ïèøåò äåáàã, ðàç óæ òàê èçâðàòèëèñü ñ íèì.

?

[eakwarp]

È êðîìå:
new query[1500], str[100];

Ïåðâûé ìàññèâ ñëèøêîì áîëüøîé, âòîðîé ñëèøêîì ìàëåíüêèé.

Äàæå çàïðîñ áåç äàííûõ â ôîðìàòå çàíèìàåò 110 ñèìâîëîâ, ñ äàííûìè âñå 200. ×òî âàì ìåøàëî îãðàíè÷èòñÿ îäíèì ìàññèâîì íà 255 ñèìâîëîâ è îäíèì ôîðìàòîì - óìà íå ïðèëîæó.

[Hawkins]

[14:24:40] CMySQLHandler::Query(UPDATE players SET `Cars`=422,`Posc_x`=0.000000,`Posc_y`='0.000000',` Posc_z`='0.000000',`Posc_a`='0.000000',`Color1`=') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1)

Âîò ÷òî ïèøåò

[Stepashka]

È åù¸ êîå ÷òî:

if(!mysql_query(query)) mysql_debug(1), mysql_query(query), mysql_debug(0);

Íå ïèøèòå âû òàê, ýòî íå ïðàâèëüíî!

[Stepashka]

Ïðîáëåìà ñ äëèíîé ñòðîê, çàïðîñ îòðåçàåòñÿ íà ñåðåäèíå.

[Hawkins]

Óâåëè÷èë str ïîáîëüøå. Òåïåðü âñ¸ íîðì. Ñïàñèáî çà îòâåò