Verry many usefull scripts For Your Mu Online Server !

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

[K2NetworK]

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

Try thise

^_^ nice but don't work)but work this:

SET Strength=('32766'), Dexterity=('32766'), Vitality=('32766'), Energy=('32766')
WHERE Name=('Your_Nick')
thx for help

[foveros]

Add also this script for auto reset :

UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

[People if the max level of a server is 1000 can we change the 349 to 999?]

[boro05]

Take it my script for autofix stats.

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Dexterity < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Vitality < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Strength < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Energy < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Leadership < 0) AND (ConnectStat = 0)

[K2NetworK]

Add also this script for auto reset :

UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

[People if the max level of a server is 1000 can we change the 349 to 999?]

hm I test this script:poster_ss

[DarkerLT]

hm I test this script:poster_ss

OMG Im laughing my ass off :DDDDDDDDDDDDDDDDD
Can u use Logic?
UPDATE=Update, not create new, but update!
SET=Set something values to Values in next Syntax
WHERE=Where the thing is that or like that
cLevel=Character's level
and so on guyz.. it's very very simple. its JUST LOGIC..

[DADE_pk]

Nothing important 2/10

[Jahte]

DarkerLT, but if you need many scripts to use at once ? Faster will be do Ctrl+C Ctrl+v :D

[DarkerLT]

DarkerLT, but if you need many scripts to use at once ? Faster will be do Ctrl+C Ctrl+v :D

Yes, of course :D c'mon add new stuff to ur thread..
Who cares if it's stolen.. anyway it will be the same script..

[Shatter]

Thanks for Personal ID disable code :kisss:

[CrystaLize]

Good Work, Thx

[lordcraft]

---------------------

Thise delete all there resets (DONT USE IT LIKE JOB).

UPDATE Character
SET Resets=('0')
WHERE Resets>0

------------------------

Thise one will delete all the level up points.

UPDATE Character
SET LevelUpPoints=('0')
WHERE LevelUpPoints>0


------------------------

whay i can use delete all reset i JOB ?
how modify delete level up points? i need somebody tell me how modify this script, just i want delete not all stats but half.

please help. thx.

[Krims]

Good Work! :)
muserver beginners will be happy!
9/10

[Jaky99999999999]

I want to delete all Dark Horse from Inventroy and Vault Can you give me a script please.
Thanks

[Jahte]

If u wold give me hex of dark horse i will make script...

[FCV2005]

good job man !
very usefull
10/10