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...
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...
