-
Last of the OsRose Devs
Re: how to fix this server problem
Great news. Congrats on that.
-
Enthusiast
Re: how to fix this server problem
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 =\
-
Proficient Member
Re: how to fix this server problem
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
-
Proficient Member
Re: how to fix this server problem
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,
-
Enthusiast
Re: how to fix this server problem
Thanks dudes, great help it has been xD fixed it and got the server running smoothly =)