Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

FIELD SERVER: (CID 101, GID 0) Drop & Save Character error?

Newbie Spellweaver
Joined
Jul 25, 2018
Messages
62
Reaction score
2
(CID 101, GID 0) Drop & Save CharacterDB:UPDATE ChaInfo SET ChaBright=1, ChaLevel=1, ChaMoney=0, ChaDex=0, ChaIntel=0, ChaSchool=0, ChaHair=0, ChaFace=0, ChaLiving=0, ChaStrong=0, ChaPower=0, ChaSpirit=0, ChaStrength=0, ChaStRemain=10, ChaAttackP=0, ChaDefenseP=0, ChaFightA=5, ChaShootA=2, ChaExp=0, ChaSkillPoint=10, ChaHP=220, ChaMP=5, ChaSP=10, ChaPK=0, ChaStartMap=2, ChaStartGate=6, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=2, ChaSavePosX=170.752228, ChaSavePosY=10.021001, ChaSavePosZ=-2091.655273, ChaReturnMap=-1, ChaReturnPosX=0.000000, ChaReturnPosY=0.000000, ChaReturnPosZ=0.000000, ChaGuName='', ChaReExp=0, ChaSpMID =65535, ChaSpSID =65535, ChaPkWin =0, ChaPkLoss =0,ChaVotePoint=0, ChaPremiumPoint=0, ChaContributionPoint=0, WHERE ChaNum=1DB:42000, NativeError:156, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'WHERE'.


everytime i reconnect? its always rollback when i started! new character is always like this?

any help?
 
Skilled Illusionist
Joined
May 25, 2014
Messages
354
Reaction score
29
(CID 101, GID 0) Drop & Save CharacterDB:UPDATE ChaInfo SET ChaBright=1, ChaLevel=1, ChaMoney=0, ChaDex=0, ChaIntel=0, ChaSchool=0, ChaHair=0, ChaFace=0, ChaLiving=0, ChaStrong=0, ChaPower=0, ChaSpirit=0, ChaStrength=0, ChaStRemain=10, ChaAttackP=0, ChaDefenseP=0, ChaFightA=5, ChaShootA=2, ChaExp=0, ChaSkillPoint=10, ChaHP=220, ChaMP=5, ChaSP=10, ChaPK=0, ChaStartMap=2, ChaStartGate=6, ChaPosX=0.000000, ChaPosY=0.000000, ChaPosZ=0.000000, ChaSaveMap=2, ChaSavePosX=170.752228, ChaSavePosY=10.021001, ChaSavePosZ=-2091.655273, ChaReturnMap=-1, ChaReturnPosX=0.000000, ChaReturnPosY=0.000000, ChaReturnPosZ=0.000000, ChaGuName='', ChaReExp=0, ChaSpMID =65535, ChaSpSID =65535, ChaPkWin =0, ChaPkLoss =0,ChaVotePoint=0, ChaPremiumPoint=0, ChaContributionPoint=0, WHERE ChaNum=1
The comma after
ChaContributionPoint=0 must be removed
 
Upvote 0
Back
Top