Verry many usefull scripts For Your Mu Online Server !

[Jahte]

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

 

[dyablows]

You got 2 make a procedure in ur sql

thx , i just updated my db.

 

[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:

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

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

ciao!

 

[raymondalmeda]

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!

 

[raymondalmeda]

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

 

[Nissin]

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

 

[achov]

niceee )) 10/10

 

[crystian]

Hello guys,

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

 

[mytzu]

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

 

[aecrimch]

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

if you are using TT here it is:

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