[Release] Verry many usefull scripts For Your Mu Online Server !

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

[_Shotlandetsa_]

Also Add one for deleting inventories it will be great !

[Jahte]

Added.

[serrinha]

very usefull...thx...

[facampro]

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

[AsTy]

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