[Release] Verry many usefull scripts For Your Mu Online Server !

[koolsMagic]

hi guys, im noob.
so where i put this scripts to work ?
thankz

[Tyerial]

can someone tell me a sql query to add credits to all accounts/chars?

[koolsMagic]

how can i use this scripts ???

anyone give me a guide!!
plzz

[Fant0ma]

great job dude

[N00BWAR]

So useful ^.^

Good post :D

[K2NetworK]

good work!

[olbasis]

Auto Stats Fix :



UPDATE Character
SET Strength='32766'
WHERE Strength<1

UPDATE Character
SET Dexterity='32766'
WHERE Dexterity<1

UPDATE Character
SET Vitality='32766'
WHERE Vitality<1

UPDATE Character
SET Energy='32766'
WHERE Energy<1

[b]
It

[georgegeorge]

thx i needed.

[Jahte]

Olbasis, it's possible.



UPDATE Character
SET Strength=('*****'), Agility=('*****'), Vitality=('*****'), Energy=('******')
WHERE Name=('Character name you need')

[K2NetworK]

Olbasis, it's possible.



UPDATE Character
SET Strength=('*****'), Agility=('*****'), Vitality=('*****'), Energy=('******')
WHERE Name=('Character name you need')

thx I test it.65000k stat's can work?

[Jahte]

What you mean ? Like

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Admin')

????

[K2NetworK]

What you mean ? Like

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Admin')

????

don't work

[Jahte]

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Your_Nick')

Try thise

[olbasis]

Thanks for your reply Jahte but i want to know for specific class (Bk/SM/DL/ELF/SuM) not for specific character name , all the blade knight with same stats, all the soul masters with same stats... maybe i didnt explain well at the beginig.

[Jahte]

olbasis, then it's will be like

UPDATE Character
SET Strength=('str'), Dexterity=('agi'), Vitality=('vit'), Energy=('ene')
WHERE CtlCode=('chacters class in Ctlcode'), Strength>str2, Dexterity>agi2, Vitality>vit2, Energy>ene2

Replace "str" with strength u wanth to set, "agi" with agility u wanth to set e.t.c.
Replace "str2", agi2, vit2, ene2 with the number above stats will be changed
Replace "chacters class in Ctlcode" with characters's CTLCode (I think MG=48, BK=1 but i dont reember others.)