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!

sql if else doesnt work...

Junior Spellweaver
Joined
Mar 14, 2018
Messages
159
Reaction score
13
hey guys i wanted to change an if else in an existing sql procedure (from a game) but i cant get it to work and i dont know why...

this is the old code (works)



------------------

this is the code when i made 1 change (doesnt work as you can see in the error)



------------------

here i added begin and end into the if and else if + made all the changes that i want too. i can save the code but when i go into the game and create a char to execute the code, the spawnid, body, pants, hand and foot from the IF work but i get the wdir from the ELSE IF (845) but i need it from the IF (439)....
i really dont know why the code is "mixing" things...

 
Elite Diviner
Joined
Aug 15, 2008
Messages
489
Reaction score
43
You could try using BEGIN TRY to catch any errors. See this for example.
 
Last edited:
Junior Spellweaver
Joined
Mar 14, 2018
Messages
159
Reaction score
13
ok nvm i found the problem after watching over the code again today for 10minutes xD
 
Back
Top