Verry many usefull scripts For Your Mu Online Server !

[Sylv3R69]

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

nothing new, its easy

 

[pizzavesel]

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

Incorect connected users shown on the web fix. (First Take Server Offline !) (If your server is offline maybe there is connected users shown on the web, it will fix that).

UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0

at me worked licke this not whit Connect_Stat but licke this ConnectStat


UPDATE MEMB_STAT
SET ConnectStat='0'
WHERE ConnectStat>0

sry for bad english


o & can you make a script for the (z-y) webshop (savoy's webshop)for voting on credits ? or to give a sum of credits over time ?

 

[AleXaNdeR-GM]

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

Very Good And Usefull Script's!

 

[NezuL]

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

Hmm a good release , although most of the people know the scripts ... 10/10

 

[Jahte]

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

Added.

 

[koolsMagic]

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

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

 

[Tyerial]

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

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

 

[koolsMagic]

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

how can i use this scripts ???

anyone give me a guide!!
plzz

 

[Fant0ma]

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

great job dude

 

[N00BWAR]

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

So useful ^.^

Good post

 

[K2NetworK]

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

good work!

 

[olbasis]

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

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

It

 

[georgegeorge]

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

thx i needed.

 

[Jahte]

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

Olbasis, it's possible.



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

 

[K2NetworK]

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

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]

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

What you mean ? Like

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

????

 

[K2NetworK]

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

What you mean ? Like

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

????

don't work

 

[Jahte]

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

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

Try thise

 

[olbasis]

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

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]

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

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