Verry many usefull scripts For Your Mu Online Server !

good work!

Quote:

---

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

thx i needed.

Olbasis, it's possible.



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

Quote:

---

Originally Posted by Jahte

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?

What you mean ? Like

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

????

Quote:

---

Originally Posted by Jahte

What you mean ? Like

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

????

---

don't work

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

Try thise

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.

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

Quote:

---

Originally Posted by Jahte

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

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?]

Take it my script for autofix stats.

Code:

---

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)

---

Quote:

---

Originally Posted by 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?]

---

hm I test this script:poster_ss

Quote:

---

Originally Posted by K2NetworK

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

Nothing important 2/10

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

Quote:

---

Originally Posted by Jahte

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

Thanks for Personal ID disable code :kisss:

Good Work, Thx

Quote:

---

Originally Posted by Jahte

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

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.

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

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

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

good job man !
very usefull
10/10