• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Verry many usefull scripts For Your Mu Online Server !

Newbie Spellweaver
Joined
Dec 8, 2006
Messages
24
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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.
 
Joined
May 12, 2005
Messages
249
Reaction score
8
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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.
PHP:
|id      |Charname|blah|blah|blah|blah|blah|blah|blah|Resets
 ABCD | ABCDE    |      |      |     |      |      | 10     |
Edit resets to whatever you want.
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Something else needed ?
 
Newbie Spellweaver
Joined
Nov 22, 2007
Messages
53
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Ok ))
 
Newbie Spellweaver
Joined
May 1, 2006
Messages
66
Reaction score
8
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Also Add one for deleting inventories it will be great !
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Added.
 
Newbie Spellweaver
Joined
Feb 27, 2008
Messages
5
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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
:)
 
Junior Spellweaver
Joined
Sep 12, 2006
Messages
136
Reaction score
1
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

can you give query to delete poison skill from skill of all DWs ? thanks
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Alot of HEX.... I dont have mu items hex generator... Some time later.
 
Newbie Spellweaver
Joined
Dec 24, 2007
Messages
10
Reaction score
0
[Release] Verry many usefull scripts For Your Mu Online Server !

I have backup script & delete Empty accounts do you need it ?:construct
 
Initiate Mage
Joined
Mar 23, 2008
Messages
1
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

can someone send me a privete msg on how to creat my own mu online privete server. thank's.
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

9319797 - send a private message.
 
Initiate Mage
Joined
Aug 18, 2007
Messages
3
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

its look nice :)
 
Newbie Spellweaver
Joined
Mar 23, 2007
Messages
91
Reaction score
7
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

Have someone script to list acc with excelent items + all options ? :)
 
Newbie Spellweaver
Joined
Jun 8, 2006
Messages
27
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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?
 
Junior Spellweaver
Joined
Aug 14, 2007
Messages
131
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

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


Use Items Finder. (You can find it in Releases section).
 
Junior Spellweaver
Joined
Apr 14, 2007
Messages
111
Reaction score
2
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

I need script delete all points please.
Tks and sorry for my bad english.
 
Newbie Spellweaver
Joined
Jun 8, 2006
Messages
27
Reaction score
0
Re: [Release] Verry many usefull scripts For Your Mu Online Server !

which points do you mean?
 
Back
Top