Verry many usefull scripts For Your Mu Online Server !

Also Add one for deleting inventories it will be great !

Added.

very usefull...thx...

Code:

---

UPDATE Character
SET Strength = 32767
WHERE Strength <= 0 OR Strength > 32767
 
UPDATE Character
SET Dexterity = 32767
WHERE Dexterity <= 0 OR Dexterity > 32767
 
UPDATE Character
SET Vitality = 32767
WHERE Vitality <= 0 OR Vitality > 32767
 
UPDATE Character
SET Energy = 32767
WHERE Energy <= 0 OR Energy > 32767

---

Small Update for <=0
:)

can you give query to delete poison skill from skill of all DWs ? thanks

Alot of HEX.... I dont have mu items hex generator... Some time later.

I have backup script & delete Empty accounts do you need it ?:construct

can someone send me a privete msg on how to creat my own mu online privete server. thank's.

9319797 - send a private message.

its look nice :)

Have someone script to list acc with excelent items + all options ? :)

Could you post code for inventory check in sql reset system?

I know check for sql 2000, but it is not working in 2005, so I need this code for 2005, could u help me?

Quote:

---

Originally Posted by SkyLinE27

Have someone script to list acc with excelent items + all options ? :)

---

Use Items Finder. (You can find it in Releases section).

I need script delete all points please.
Tks and sorry for my bad english.

which points do you mean?

nothing new, its easy

Quote:

---

Originally Posted by Jahte

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 ? :)

Very Good And Usefull Script's!

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

Added.

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

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

how can i use this scripts ???

anyone give me a guide!!
plzz

great job dude

So useful ^.^

Good post :D