[script] reset quests

[gil_super43]

Hello!
I have recently migrated my DB and now my MuMaker shows me 'UNKNOW' on quest tab for all characters.
I need to change all the characters to '0 - No Quest!' automatically so they can get the Sevina and Marlon quests again.
I need a SQL script to reset it.
Put '0' on the column 'Quests' didnt work.
Using MUEMU x401.

Thanks!

[MentaL]

[Dope Boy One]

[Help]
[Help] prefix it is one reason to make sure that you've seen the rules.Use [Help] prefix always when you wanna create a new Thread on Help Section.
You should be careful and go into specific details when it comes to giving a title to your problem in your post.


Topic sorted but next time please follow the rules.

[getmylife1]

did you mean this?

update Character set Quests=1 where Quests=0

?

[KarLi]

did you mean this?

?

he meant the opposite

update character set quests=0 where quests=1

i think he wants to remove all quests from every player.