[CodingArt]

Entгo, fiz uma query que estб gerando um erro estranho no log.

Cуdigo:

PHP код:

mysql_format(mysql,
    query,
    sizeof(query),
    "UPDATE `players` SET \
    `pmoney` = %d \
    `pskin` = %d \
    `pgender` = %d \
    `pposx` = %f \
    `pposy` = %f \
    `pposz` = %f \
    `pposa` = %f \
    `pinterior` = %d \
    `pvirtualworld` = %d \
    `pstaff` = %d \
    `plastip` = %e \
    WHERE `pid` = '%d'",
    pInfo[playerid][pMoney],
    pInfo[playerid][pSkin],
    pInfo[playerid][pGender],
    pInfo[playerid][pPosX],
    pInfo[playerid][pPosY],
    pInfo[playerid][pPosZ],
    pInfo[playerid][pPosA],
    pInfo[playerid][pInterior],
    pInfo[playerid][pVirtualWorld],
    pInfo[playerid][pStaff],
    pInfo[playerid][pLastIP],
    pInfo[playerid][pUID]
    );
    mysql_tquery(mysql, query); 


Erro que gerou no log:

Код HTML:

[12:05:11] [plugins/mysql] error #1064 while executing query "UPDATE `players` SET `pmoney` = 5500 `pskin` = 60 `pgender` = 1 `pposx` = 0.000000 `pposy` = 0.000000 `pposz` = 0.000000 `pposa` = 0.000000 `pinterior` = 0 `pvirtualworld` = 0 `pstaff` = 4 `plastip` = 127.0.0.1 WHERE `pid` = '1'": 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 '`pskin` = 60 `pgender` = 1 `pposx` = 0.000000 `pposy` = 0.000000 `pposz` = 0.000' at line 1