Verry many usefull scripts For Your Mu Online Server !

Quote:

---

Originally Posted by PunxPhobia

UPDATE Character
SET LevelUpPoint=('') + 1500
WHERE cLevel<=1 and Resets<=1
this script aint working .... i put it in SQL it shows me that i put it coreect but when i make a new char... Nothing :| No start up points

---

You got 2 make a procedure in ur sql

Quote:

---

Originally Posted by Jahte

You got 2 make a procedure in ur sql

---

thx , i just updated my db. :D

Hi guyz

how can i make a script for cashshop
i want give 1cashshop point every 1Minute noline
and disconnect all afk players after 15min

can i make it?:mellow::mellow:

---------- Post added at 12:33 PM ---------- Previous post was at 10:47 AM ----------

Quote:

---

Originally Posted by dartor

Hi guyz

how can i make a script for cashshop
i want give 1cashshop point every 1Minute noline
and disconnect all afk players after 15min

can i make it?:mellow::mellow:

---

i make it and run like this
UPDATE MEMB_INFO
SET cspoints = cspoints + 1
FROM MEMB_INFO JOIN MEMB_STAT ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS
WHERE ConnectStat = 1

and schedule like auto reset :thumbup1:

ciao! :D

Hi!

If I want to add this in my server :

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


where do it put it? SQL of txt file?

Thanks!

And also, what do I do if i wat to remove the script?
Thanks!

Bro where should put that? give some guide so we will know.

niceee :))) 10/10

Hello guys,

can you help me with 1 script for combo ( mu online )
Thank!

One script for reseting Skill Tree of a specific character? Please :D

Quote:

---

Originally Posted by mytzu

One script for reseting Skill Tree of a specific character? Please :D

---

if you are using TT here it is:

Quote:

---

UPDATE Character SET
SCFMasterLevel = 1,
SCFMasterPoints = 1,
SCFMasterSkill = cast(REPLICATE(char(0x00),240) as varbinary(240))
WHERE Name='charname'

---