SCRIPTS SQL basics of basic

[Sphoon]

Hello those who are just in new in Mu Online and doesnt know about querries or other commands in SQL
i will leave you some commands that are useful mostly in louis files and i leave also explaination of the commands.

Código

delete from CustomQuest = (restart custom quest and players will go quest again from quest 1)
delete from CustomNpcQuest = (restart all custom NPC quest and go quest again from quest 1)
update CashShopData set WCoinC=WCoinC+100 (add wcoins to user e.g 100)
update CashShopData set WCoinP=WCoinP+100 (add wcoinp to user e.g 100)
update CashShopData set GoblinPoint=GoblinPoint+100
update MEMB_INFO set Accountlevel=0 (delete all vip in all accounts)
update MEMB_INFO set Accountlevel=1 (give vip to all accounts so on and so forth
delete from Character = (delete all characters in the server)

i hope this will help those who really dont know about SQL and its commands