Hi !
In my language, some item_name have a single quote, so when i create offline shop, if item has a single quote in name query failed...
because for search shop system, i need to store item_name in offline_shop_item, and all item with single quote failed, someone have a solution for this ????
mysql_query error: 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
DirectQuery: AsyncSQL::DirectQuery : mysql_query error: 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 'Z?taros',41,0,0,0,1,2000,2,80,15,10,16,10,24,10)' at line 1
query: INSERT INTO offline_shop_item (id,owner_id,pos,count,price,vnum,item_name,mapIndex,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4) VALUES (10000223,26,8,1,100000000,16109,'Z?taros',41,0,0,0,1,2000,2,80,15,10,16,10,24,10)
real name of this item : Z'taros
thanks advance...