[Guide] How to make a mu server 90% full

01.Download Microsoft SQL Server 2000: http://download.microsoft.com/downlo...73/SQLEVAL.exe
02.Afther you Downloaded "Microsoft SQL Server 2000", Extrackt It In "C:\Program Files\Microsoft SQL Server"or where you want
Server''
03.Run "setup.exe"
04.Klick "Next"
05.Click "Next"
06.Click "Next"
07.Click "Next"
08.Click ''Yes''
09.Click "Next"
10.Click "Next"
11.Click "Next"
12.Click "Use the Local System account"
13.If U Want A Password On U "sa" Login, Click "Mixed Mode" And Type Twice The Same Password
And Click "Next".If U Dont Want A Password On U "sa" Login, Just Click "Next"
14.Click Next
15.Click Finish
And thats how you have to instal teh server!!!


01. Click On "Start" >"Programs" >"Microsoft SQL Server" >"Service Manager"
And then you Will See Server "your COMPUTER NAME" And Services "SQL Server" Then Click Start/Continue
Let It Start Automatic then Click "Auto-start service when OS starts"
02.Then Click On ""Start >Programs>Microsoft SQL Server>Enterprise Manager"
03.Then you Will See This "Console Root"
"SQL Server Group"
"(local) (Windows NT)"
Then you must Click On "(local) (Windows NT)" > "Databases", Right Click On "Databases" And Click
New Database... "Name:" "MuOnline" And Click "OK"
04.Then you Will See "From device" Click "Select Devices" >"Add" Then Click On "..." Click"D:
\MuServer\MuOnline BACKUp: And Double Click On "MuOnline"
05.Click "OK"
06.Click "OK"
07.Then Click "Options" And If U Did That Click On "Force restore over existing database"
08.Then you Should See This:
"Logical file name" "Move to physical file name"
MuOnline_dat "C:\MuServer\MuOnline_data.mdf"
MuOnline_log "C:\MuServer\MuOnline_log.ldf"
09.Click "OK"
10.Now U Finishd "Restoring" The "MuOnline" "Database"
11.Now Exit "Enterprise Manager"

now for the Ranking

01.Then Click On ""Start >Programs>Microsoft SQL Server>Enterprise Manager"
02.Then you Will See This "Console Root"
"SQL Server Group"
"(local) (Windows NT)"
Then you must Click On "(local) (Windows NT)" > "Databases", Right Click On "Databases" And Click
New Database... "Name:" "Ranking" And Click "OK"
03.Then you Will See "From device" Click "Select Devices" >"Add" Then Click On "..." Click"D:
\MuServer\MuOnline BACKUp: And Double Click On "Ranking"
04.Click "OK"
05.Click "OK"
06.Then Click "Options" And If U Did That Click On "Force restore over existing database"
07.Then you Should See This:
"Logical file name" "Move to physical file name"
MuOnline_dat "C:\MuServer\Ranking_data.mdf"
MuOnline_log "C:\MuServer\Ranking_log.ldf"
08.Click "OK"
9.Now U Finishd "Restoring" The "Ranking" "Database"
10.Now Exit "Enterprise Manager"

The next step will be to extract the MuServer folder from the RAR and copy the folder in it to the D: drive,
make sure it dont have double folders like D:/MuServer/MuServer , it should only have D:/MuServer/ .
Open this files using Notepad, and edit where it says "127.0.0.1" to your global IP

D:\MuServer\CS\Connectserverlist.dat
D:\MuServer\CS\data\Connectserverlist.dat
D:\MuServer\CS\data\ServerInfo.dat
D:\MuServer\CS\data\ServerList.dat
In this files search for: 127.0.0.1 using CTRL+F. Then change it to your local IP you can find your local ip like this:
Click Start>Run>and type cmd. When u get to cmd you will type this "ipconfig". And you wil see your local ip.
D:\MuServer\data\commonserver.cfg
D:\MuServer\data\IpList.dat
D:\MuServer\data\lang\chs\commonloc.dat [change the ip's in all lang folder's]
edit these shortcuts ips,(for noobs ....rightclik>properties>and you wil see the ip's
D:/MuServer/Links/4.ink
D:/MuServer/Links/8.ink


Now run the links from1 to 8 amd be hay now you have MU ONline server




NOw the extras
you can add things like lvl 1000 items+15 and more
now for the options+15

Adding+15+28 items
Open ur gameserver with Hex editor..
find for 83 fa 0b 7e 09 66 c7 85 78 ff and replace with 83 fa 0f 7e 09 66 c7 85 78 ff
find for 83 fa 0b 7e 09 66 c7 85 5c ff and replace with 83 fa 0f 7e 09 66 c7 85 5c ff
Now those +15 items wont turn back to +0 after relogin in

+28% option
find for 00 00 75 26 8b 85 4c and replace with 000090908b854c
find for 33 c0 8a 44 0a 47 83 e0 40 83 f8 40 75 04 c6 45 da 04 and
replace with 8A 44 11 47 C0 E8 04 24 04 08 45 DA 90 90 90 90 90 90
find for 75 1c 8b 4d 08 33 d2 and replace with 90 90 8b 4d 08 33 d2
find for 83 F9 04 7D 50 and replace with 83 F9 07 7D 50
Ok, now you can add ur items till +28 with jol
for other thing you may use Extreme mu editor ver.0.60 http://forum.ragezone.com/releases/r...-a-117462.html
now the auto reset script
open enterprice maneger and click on "New Job"
name it "Auto reset" then click on "steps" make "new"
then on "database" select "MuOnline"
on command paste this
do not paste this
Notes:
AutoReset Lvl=350
Additional Points(Per Reset)=350
Reset Cost=50Millions (Each Reset)
Reset Limit=50Resets if ypu want to change the resets change thiS (Reset < 50) how many rests you want to have the server;)
Stats=Goes Back To Normal
Character:AutoWarp to Lorencia/Noria
Character MagicSpellList=Will Be Cleared
Character Inventory=Will Be Cleared
+Additional Pk Clear (Each Character)
paste this
1)DarkWizard/SoulMaster Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)),
Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30,
Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (50000000))
AND (ConnectStat = 0) AND (Reset < 50);


2)DarkKnight/BladeKnight Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)),
Money = Money - (50000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10,
Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (Money >=
(50000000)) AND (ConnectStat = 0) AND (Reset < 50);

3)Elf/MuseElf Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)),
Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15,
Inventory = NULL, MagicList = NULL, MapNumber = 3, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >=
(50000000)) AND (ConnectStat = 0) AND (Reset < 50);

4)MG Code:
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)),
Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26,
Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 350) AND (Money >=
(50000000)) AND (ConnectStat = 0) AND (Reset < 50);

for evry one of these codes make new jobs!!!dont put all these codes in one job!!!!
now click on "schedules" make new schedule
let the name be "Auto reset" click on change then set job to be daily
then set "occurs at evry 1 min.and then click "ok" twice and the "aply" and ok agen
now you are rady
if you have 1GB ram or les you have to do this
My Computer>proarties>Advanced in the preformance box click on settings then advanced>change
then click on custum size set ibital size to be 800 and maximum to be over 2000 if you want make it 4000
then click set>ok>ok>ok and reboot