Verry many usefull scripts For Your Mu Online Server !

Here is some werry helpfull scripts for Mu Online servers.


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

Code:

---

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

---

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

Personal ID Code Check "Disabling" :

Code:

---

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

---

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

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

Code:

---

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

---

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

Auto Stats Fix :

Code:

---

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 :

Code:

---

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

Code:

---

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

---

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


Starting stats edditing:

Code:

---

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 :

Code:

---

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

Code:

---

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 !

Code:

---

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

---

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

Thise one will fix guild score -99 bug.

Code:

---

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

---

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

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

Code:

---

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

---

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

Thise one will clear all the vaults.

Code:

---

UPDATE warehouse
SET Items=('')

---

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

Thise one for deleting all the items from inventories.

Code:

---

UPDATE Character
SET Inventory=('')

---

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

Thise one will unban all the players.

Code:

---

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

---

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

Thise one will delete all GMs.

Code:

---

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

---

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

Thise one will delete all the level up points.

Code:

---

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

---

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

Auto Reset

Code:

---

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

---

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

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

Code:

---

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

---

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

Thise one will delete all the level up points.

Code:

---

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.

Code:

---

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

---

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

This one will add free credits for ALL players

Code:

---

Update MEMB_CREDITS
SET credits=credits+100

---

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

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

Code:

---

DROP dbo.MuOnline

---

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

This one will show you top 100 credited accounts

Code:

---

SELECT TOP 100 FROM MEMB_CREDITS
WHERE credits>0

---

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

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

Code:

---

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)

ADD [Release] TAG

10x :) gj

nice but how about for DL Command?

Keep updating this one, any new threads will be deleted

Good 10/10

Quote:

---

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

---

Isn't that should be like this :

Code:

---

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

---

Sorry.. i did mistake =)

Code:

---

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

---

Isn't that should be like this :

Code:

---

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

---

And...

Code:

---

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

---

Code:

---

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

---

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

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

The scripts are stoling, but thx anway. :)

fix codes to very nice :)

Quote:

---

Originally Posted by szubertxxx

Code:

---

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

---

Isn't that should be like this :

Code:

---

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

---

And...

Code:

---

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

---

Code:

---

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

Something more needed ?

Guild score -99 fix added =)

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

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

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

Quote:

---

Originally Posted by christoper

nice but how about for DL Command?

---

Leadership this is Command for DL

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.

Quote:

---

Originally Posted by 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.

---

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

---

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


---

Edit resets to whatever you want.

Something else needed ?

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

Ok ))

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

good work!

Quote:

---

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

---

[b]
It

thx i needed.

Olbasis, it's possible.



UPDATE Character
SET Strength=('*****'), Agility=('*****'), Vitality=('*****'), Energy=('******')
WHERE Name=('Character name you need')

Quote:

---

Originally Posted by Jahte

Olbasis, it's possible.



UPDATE Character
SET Strength=('*****'), Agility=('*****'), Vitality=('*****'), Energy=('******')
WHERE Name=('Character name you need')

---

thx I test it.65000k stat's can work?

What you mean ? Like

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Admin')

????

Quote:

---

Originally Posted by Jahte

What you mean ? Like

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Admin')

????

---

don't work

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Your_Nick')

Try thise

Thanks for your reply Jahte but i want to know for specific class (Bk/SM/DL/ELF/SuM) not for specific character name , all the blade knight with same stats, all the soul masters with same stats... maybe i didnt explain well at the beginig.

olbasis, then it's will be like

UPDATE Character
SET Strength=('str'), Dexterity=('agi'), Vitality=('vit'), Energy=('ene')
WHERE CtlCode=('chacters class in Ctlcode'), Strength>str2, Dexterity>agi2, Vitality>vit2, Energy>ene2

Replace "str" with strength u wanth to set, "agi" with agility u wanth to set e.t.c.
Replace "str2", agi2, vit2, ene2 with the number above stats will be changed
Replace "chacters class in Ctlcode" with characters's CTLCode (I think MG=48, BK=1 but i dont reember others.)

Quote:

---

Originally Posted by Jahte

UPDATE Character
SET Strength=('64000'), Dexterity=('64000'), Vitality=('64000'), Energy=('64000')
WHERE Name=('Your_Nick')

Try thise

---

^_^ nice but don't work)but work this:

SET Strength=('32766'), Dexterity=('32766'), Vitality=('32766'), Energy=('32766')
WHERE Name=('Your_Nick')
thx for help

Add also this script for auto reset :

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

[People if the max level of a server is 1000 can we change the 349 to 999?]

Take it my script for autofix stats.

Code:

---

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Dexterity, Dexterity = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Dexterity < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Vitality, Vitality = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Vitality < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Strength, Strength = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Strength < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Energy, Energy = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Energy < 0) AND (ConnectStat = 0)

UPDATE Character
SET LevelUpPoint = LevelUpPoint + 32767 + Leadership, Leadership = 32767
FROM Character JOIN MEMB_STAT ON (MEMB_STAT.memb___id COLLATE Chinese_PRC_CS_AI = Character.AccountID COLLATE Chinese_PRC_CS_AI)
WHERE (Leadership < 0) AND (ConnectStat = 0)

---

Quote:

---

Originally Posted by foveros

Add also this script for auto reset :

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

[People if the max level of a server is 1000 can we change the 349 to 999?]

---

hm I test this script:poster_ss

Quote:

---

Originally Posted by K2NetworK

hm I test this script:poster_ss

---

OMG Im laughing my ass off :DDDDDDDDDDDDDDDDD
Can u use Logic?
UPDATE=Update, not create new, but update!
SET=Set something values to Values in next Syntax
WHERE=Where the thing is that or like that
cLevel=Character's level
and so on guyz.. it's very very simple. its JUST LOGIC..

Nothing important 2/10

DarkerLT, but if you need many scripts to use at once ? Faster will be do Ctrl+C Ctrl+v :D

Quote:

---

Originally Posted by Jahte

DarkerLT, but if you need many scripts to use at once ? Faster will be do Ctrl+C Ctrl+v :D

---

Yes, of course :D c'mon add new stuff to ur thread..
Who cares if it's stolen.. anyway it will be the same script..

Thanks for Personal ID disable code :kisss:

Good Work, Thx

Quote:

---

Originally Posted by Jahte

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

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


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

---

whay i can use delete all reset i JOB ?
how modify delete level up points? i need somebody tell me how modify this script, just i want delete not all stats but half.

please help. thx.

Good Work! :)
muserver beginners will be happy!
9/10

I want to delete all Dark Horse from Inventroy and Vault Can you give me a script please.
Thanks

If u wold give me hex of dark horse i will make script...

good job man !
very usefull
10/10

Is this here : 0400FF0055034A0000D0000000000000
Maybe i don't know.I have used Server 1.04X (SS3 Ep2)
Thanks

Why don't help me :((
Please.

Hey guys is there a working Script to Fix stats at 64K(Epi 2)?

thanks

Good scripts , thanks

Thanks, it's very usefull.

Somebody know how can i erase an specific item from db using a query?

The problem is that, how to dont delete another items while deleting one specific...

this is perfect, make more scripts :P

Nothing special, but nice...

Any requests ?

Some script to change the name of a char?
Thx

Nice release ! :)

Thx for scripts =) 10/10

Quote:

---

Originally Posted by Jahte

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

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

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

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

---

A lot of these noobie scripts can be changed in the stored procedure to use less CPU. Also, they're very badly written and contain no AND, OR, etc switches to even help regulate what they actually need to target.

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

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

can someone give me a script for new year gifts ?

Can somebody make sript that allow people /post on 1.02Q
sorry for my bad English

i wanna change max point of str,agi,vit,ene,com to 32767. Can you post that script here?

Hi
Is it possible to make a script that makes a char go to a specific Town (Lorencia) after a reset?
Cause now when i reset and relogin i will remain on the map i got maxlevel on but at lvl 1.
I have putted lvl restriction on all maps but it doesn't help
/Roka

roka0338, you shold code it in your website. I mean, when the character makes reset, he also teleports himself to lorencia. (Or just edit "INSERT" values at the resets page, maybe that's a problem also).

sup i'm searching for script that removes caracter's stats to default after reset and gives him +300 Points after each reset...


i mean im starting to play and i have the default stats str 26 agi 16 ... + i have 300 points
now when i got needed lvl for reset i do the reset for character and the stats drop off for default and give me +300 more,and now i have +600 stats points, and on each new reset the stat points rises by +300...

dont click link its spam

it would be possible to have a script to erase all the guilds plz ?

if i write this in QA (Query Analizer)

UPDATE Character
SET Strength='64767'
WHERE Strength<1

UPDATE Character
SET Dexterity='64767'
WHERE Dexterity<1

UPDATE Character
SET Vitality='64767'
WHERE Vitality<1

UPDATE Character
SET Energy='64767'
WHERE Energy<1

characters max stat will be 64767 ??

Quote:

---

Originally Posted by Malevicha

if i write this in QA (Query Analizer)

UPDATE Character
SET Strength='64767'
WHERE Strength<1

UPDATE Character
SET Dexterity='64767'
WHERE Dexterity<1

UPDATE Character
SET Vitality='64767'
WHERE Vitality<1

UPDATE Character
SET Energy='64767'
WHERE Energy<1

characters max stat will be 64767 ??

---

If your GS Support this amount of stats and read it in this way, why not?

i am using MMT Season 2 Official Files and it works or not?