select id,name,x,y,hp,mp,exp,ap,level,metier,metierlevel,sp,str,con,dex,`int`,hit,actorid,faction,pk,items,deletedate,headmodelid from user where accountid='%d' and deleted=0 order by createdate
改数据库是非常困难的事,而LZ的问题应该只是改客户端程序 改下那个连接字符 select id,name,x,y,hp,mp,exp,ap,level,metier,metierlevel,sp,str,con,dex,`int`,hit,actorid,faction,pk,items,deletedate,headmodelid from user where accountid='%d' and deleted=0 order by createdate
int 改成 unsigned long 而后边的字符要往后移动。hit,actorid,faction,pk,items,deletedate,headmodelid from user where accountid='%d' and deleted=0 order by createdate 要往后移动。