how to fix this server problem

[Purpleyouko]

Great news. Congrats on that.

[SolarisJ]

hmm i have a problem now lol,

this is my current code under startup.cpp/loadskilldata()

MYSQL_RES *result = DB->QStore("SELECT id,'level',sp,'type','range',target,power,duration,mp, success,weapon,class,rskills,lskills,buff1,buffv11,buffv12, buff2,buffv21,buffv22,buff3,buffv31,buffv3 2,clevel,aoe,aoeradius,script,value1 FROM skills_data order by id");

*note: buffv3 2 is supposed to be together without the space

I've added the brackets for special words in SQL such as level, type and range.. is there anything else I have to do? Im getting the same error as the above mentioned =\

[djcyber]

MYSQL_RES *result = DB->QStore("SELECT id,'level',sp,'type','range',target,power,duration ,mp,

Change the .level remove the ' on 'level' and 'type' and recompile it and it should work fine after that and use the new compiled Worldserver.exe and shoudl start up and the one 'range' is good dont remove that one

[djcyber]

MYSQL_RES *result = DB->QStore("SELECT id,'level',sp,'type','range',target,power,duration ,mp,

Should look like this

MYSQL_RES *result = DB->QStore("SELECT id,level,sp,type,'range',target,power,duration ,mp,

[SolarisJ]

Thanks dudes, great help it has been xD fixed it and got the server running smoothly =)