Verry many usefull scripts For Your Mu Online Server !

[Jahte]

Here is some werry helpfull scripts for Mu Online servers.


----------------------
Negative Money Fix :

UPDATE Character
SET Money='2000000000'
WHERE Money<-1

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

Personal ID Code Check "Disabling" :

UPDATE MEMB_INFO
SET sno__numb=('')
WHERE sno__numb>1

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

Starting Money (You starting money by changing ('10000000') to some other value.) :

UPDATE Character
SET Money=('10000000')
WHERE Money<1

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

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

If there is a Dark Lord Then it's will look so :

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
 
UPDATE Character
SET Leadership='32766'
WHERE Leadership<1

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

Auto Clear PK

UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2

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


Starting stats edditing:

UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strenght<18
 
UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16
 
UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16
 
UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16

For versions that have Dark Lord :

UPDATE Character
SET Strength='how mutch starting strenght you wanth'
WHERE Strenght<18
 
UPDATE Character
SET Dexterity='how mutch starting dexterity you wanth'
WHERE Dexterity<16
 
UPDATE Character
SET Vitality='how much starting vitality you wanth'
WHERE Vitality<16
 
UPDATE Character
SET Energy='how much starting energy you wanth'
WHERE Energy<16
 
UPDATE Character
SET Leadership='how much starting command you wanth'
WHERE Leadership<15

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

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

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

Thise script will automaticaly teleports users from "The Place Of Excile" To Lorencia, bar !

UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125')
WHERE MapNumber=('5')

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

Thise one will fix guild score -99 bug.

UPDATE Guild
SET G_Score=('0')
WHERE G_Score<-1

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

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

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

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

Thise one will clear all the vaults.

UPDATE warehouse
SET Items=('')

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

Thise one for deleting all the items from inventories.

UPDATE Character
SET Inventory=('')

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

Thise one will unban all the players.

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode=('1')

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

Thise one will delete all GMs.

UPDATE Character
SET CtlCode=('0')
WHERE CtlCode='32' OR CtlCode='8'

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

Thise one will delete all the level up points.

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

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

Auto Reset

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

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

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

------------------------
Give a NO of starting Level up points to characters.
Edit: 1500 with how much or less do you want.

UPDATE Character
SET LevelUpPoint=('') + 1500
WHERE cLevel<=1 and Resets<=1

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

This one will add free credits for ALL players

Update MEMB_CREDITS
SET credits=credits+100

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

This one will drop MuOnline database (better dont use it ^^)

DROP dbo.MuOnline

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

This one will show you top 100 credited accounts

SELECT TOP 100 FROM MEMB_CREDITS
WHERE credits>0

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

This one will delete all level up points for characters who has max stats

update Character set leveluppoint='0'
where
Strength+Dexterity+Vitality+Energy='131068'
OR
Strength+Dexterity+Vitality+Energy+Leadership='163835'

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








:SniperHea
:sweatdrop



I will make some more usefull scripts later =)


Only this thread will be updated now !

I know many identic scripts like thise, but all thise is writen by my hands, so it can contain mistakes. Please post all my mistekes in this thread.

Updated (06.11.2009)

[MentaL]

[♥ DeYuLeTzU ♥]

ADD [Release] TAG

[Lisko]

10x :) gj

[christoper]

nice but how about for DL Command?

[Xurbus]

Keep updating this one, any new threads will be deleted

[bagadzelna]

Good 10/10

[DestructiO]

UPDATE MEMB_STAT
SET Connec_Stat='0'
WHERE Connect_Stat>0

Isn't that should be like this :

UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0

[Jahte]

Sorry.. i did mistake =)

[szubertxxx]

UPDATE Character
SET Command='32766'
WHERE Command<1

Isn't that should be like this :

UPDATE Character
SET Leadership='32766'
WHERE Leadership<1

And...

UPDATE Character
SET Command='how much starting command you wanth'
WHERE Command<15

UPDATE Character
SET Leadership='how much starting command you wanth'
WHERE Leadership<15

[kirka121]

overloading mssql.. creating lags. half of them are useless imo. but other half is good.

[mafiux]

I need help with the negative score of guild....

[Saint]

The scripts are stoling, but thx anway. :)

[kalojero]

fix codes to very nice :)

[Jahte]

UPDATE Character
SET Command='32766'
WHERE Command<1

Isn't that should be like this :

UPDATE Character
SET Leadership='32766'
WHERE Leadership<1

And...

UPDATE Character
SET Command='how much starting command you wanth'
WHERE Command<15

UPDATE Character
SET Leadership='how much starting command you wanth'
WHERE Leadership<15

I writed "Command" beacose i didn't worked with any newest versions data bases, so i thinked and added "Command" :)

[Jahte]

Something more needed ?

[Jahte]

Guild score -99 fix added =)

[razorrrr]

can you add script that the new charcter(sommoner)will beig for Elbland(map 51)
and fix stat for new chracter
thanks bro

[Jahte]

1. I dont now Character's class code number.
2. I dont now starting coordinats of 51 map.

[razorrrr]

1.Class code is 80 If i'm not wrong
2.map: 51, coord x: 50, coord y: 215
Thanks bro

[Slaer]

nice but how about for DL Command?

Leadership this is Command for DL

[SweetLove8x]

If i want to add resets for character. Can u show me what the code is?
Example:
- Character: ABCDE
- Resets: 10
Now i want to add 3 reset times to him. He will have 13 times of reset.

[magicswe]

If i want to add resets for character. Can u show me what the code is?
Example:
- Character: ABCDE
- Resets: 10
Now i want to add 3 reset times to him. He will have 13 times of reset.

You can do it manually, go to Muonline>Tables, look for Character Right click it then press return all rows Then look for your character ABCDE in the table then go go as much as you can to the right look for the headline "Resets" then scroll down till you find where to edit for your character ABCDE and write there 13 in the column instead of 10 it's going to look like this.

|id      |Charname|blah|blah|blah|blah|blah|blah|blah|Resets
 ABCD | ABCDE    |      |      |     |      |      | 10     | 

Edit resets to whatever you want.

[Jahte]

Something else needed ?

[DarkerLT]

I Like this :
UPDATE Character
SET MapNumber=('0'), MapPosX=('125'), MapPosY=('125')
WHERE MapNumber=('5')
But the thing should be more cool in Triggering.. [Dont mind that SQL lag.]

You should insert:
*Blank Accounts Deleting
*Deleted Accounts Warehouse Deleting
*Guild Members with only One Member or Configurated, and that guild Deleting
*Characters with lvl 1 0rr [untouched] Touches Inventory binary [0xFFFF]
And your thread would be perfect :P
Have a nice day :D

[Jahte]

Ok ))