14.05.2015, 08:13
Hi, im create the Actor System using Mysql Database, everything is ok when im add Animations System.
Server-Log
Server-Log
Quote:
|
[15:15:48] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1) [15:15:48] [MySQL] Check mysql_log.txt to review the query that threw the error. [15:15:48] Dumping query from 2015/5/14 (15:15:4  Description: 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 ' `OwnName`=, `Name`=, `Vw`=0, `Int`=0, `CurentLib`=ATTRACTORS, `CurentAim`=STEPS' at line 1 (index 0). Query: [15:15:48] UPDATE `actor` SET `acID`=1, `OwnID`=0,`BizID`=0,`PosX`=-2003.606811, `PosY` =329.781555, `PosZ`=35.015621, `PosA`=0.000000, `Model`=1, `Health`=0, `Invu`=0, `GioiThieu`=, `OwnName`=, `Name`=, `Vw`=0, `Int`=0, `CurentLib`=ATTRACTORS, `CurentAim`=STEPSIT_LOOP, `CurentIdx`=0, `Speed`=4.000000, `Loop`=0, `LockX`=0, `LockY`=0, `Freeze`=0, `Time`=0, WHERE `ID`=2 |
PHP код:
stock SaveActor(id)
{
new string[512];
printf("Luu thong tin diem nhan viec ID: %d", id);
format(string, sizeof(string), "UPDATE `actor` SET \
`acID`=%d, \
`OwnID`=%d,\
`BizID`=%d,\
`PosX`=%f, \
`PosY` =%f, \
`PosZ`=%f, \
`PosA`=%f, \
`Model`=%d, \
`Health`=%d, \
`Invu`=%d, \
`GioiThieu`=%s, \
`OwnName`=%s, \
`Name`=%s, \
`Vw`=%d, \
`Int`=%d, \
`CurentLib`=%s, \
`CurentAim`=%s, \
`CurentIdx`=%d, \
`Speed`=%f, \
`Loop`=%d, \
`LockX`=%d, \
`LockY`=%d, \
`Freeze`=%d, \
`Time`=%d, \
WHERE `ID`=%d",
ACInfo[id][acID],
ACInfo[id][acOwnID],
ACInfo[id][acBizID],
ACInfo[id][acPosX],
ACInfo[id][acPosY],
ACInfo[id][acPosZ],
ACInfo[id][acPosA],
ACInfo[id][acModel],
ACInfo[id][acHealth],
ACInfo[id][acInvu],
g_mysql_ReturnEscaped(ACInfo[id][acDes], MainPipeline),
g_mysql_ReturnEscaped(ACInfo[id][acOwnName], MainPipeline),
g_mysql_ReturnEscaped(ACInfo[id][acName], MainPipeline),
ACInfo[id][acVW],
ACInfo[id][acInt],
g_mysql_ReturnEscaped(ACInfo[id][acCurentLib], MainPipeline),
g_mysql_ReturnEscaped(ACInfo[id][acCurentAim], MainPipeline),
ACInfo[id][acCurentIdx],
ACInfo[id][ac_Speed],
ACInfo[id][ac_Loop],
ACInfo[id][ac_LockX],
ACInfo[id][ac_LockY],
ACInfo[id][ac_Freeze],
ACInfo[id][ac_Time],
id+1
); // Array starts from zero, MySQL starts at 1 (this is why we are adding one).
mysql_function_query(MainPipeline, string, false, "OnQueryFinish", "i", SENDDATA_THREAD);
}
stock g_mysql_ReturnEscaped(unEscapedString[], connectionHandle)
{
new EscapedString[256];
mysql_real_escape_string(unEscapedString, EscapedString, connectionHandle);
return EscapedString;
}
