Making your Server 100% complete

Guide on how to make your MU server 100% complete-

Table of Contents:
I. Experience
II. Drop Rate
III. Monster HP
IV. Guilds
IVa.Guild create/destroy
V. SQL and SQL Scripts
VI. Websites
VII. Shops


I. Experience and Drop Rate:

first, ask yourself a couple of questions-
1. What amount of experience makes a good, longlasting server?
2. What amount of experience would my players like?
3. I have a high/low experience rate, do i want a high/low drop rate?
4. i have a low drop rate, should i have BB on or off?

----------------------------------------------------------------------------------------------------------------------------
those are only a few questions mind you :P

ok here we go.

to change the experience rate of your server, you first must think about those questions, then, depending on where you extracted your server files, go to C:\ or D:\muserver\data\commonserver.cfg

in this document, youll find a lot of options to edit your server, right now we are only focusing on experience and drop rate.

this probably all just looks like a lot of mumbo-jumbo, and it kinda is :P
but to find things easier use the search function (ctrl+f)

search for this in your commonserver.cfg-

AddExperience

it should come to a line that looks like this-

AddExperience = XXX ; How much experience is added to each killed monster

XXX= amount of experience, change this number to anything you would like, but remember the highest is 9999 ;)

II. Drop Rate:

just like with experience, think of those questions, and go to your commonserver.cfg

use search again (ctrl+f)

serach for this-

ItemDropPer

a line will show up looking like this-

ItemDropPer = xx ; % of Item drops

xx being 1-99

for more money and less items, make it less
and for more items and less money, make it more.

III. Monster Health

ask yourself yet another question-

1. I have high/low experience, do i want the monsters to have high/low health

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

staying with the commonserver theme :P

use search AGAIN (you better make friends with this, youll use it a lot)

search for-

MonsterHp

youll get a line like this-

MonsterHp = xx ; Hp of monster [0 = 100% hp] , 80 = monster with less 80% of hp ( meaning 20% )

seems easy enough right? WRONG.

if you want monsters to have 100% health, make the number 0.

and if you want it to have like, 5% health, make it 95

you get the idea right?


IV. Guilds

no questions :P

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

commonserver still :D

search (ctrl+f) again

search for-

GuildCreateLevel

you get a line like this-

GuildCreateLevel = xxx ; Minimum level required to create a guld ( Between 1 and 350 )

well, pretty self explanitory

the default is 100, which is a good nmber, so i recommend it :P

IVa. Guild Create and Guild Destroy

this piece is right underneath GuildCreateLevel so no searching, but if you REALLY want to

search this-

GuildCreate

youll get this-

GuildCreate = 1 ; Allow creation of guilds ( 1=On / 0=Off )

again, pretty self explanitory, so i wont explain it
id keep it on 1 or people will complain :P

V. SQL and scripts-

open the SQL query analyzer, and copy tese scripts into the text box thing and hit excecute(or f5 i think)
after that, just exit and dont save, then youll have these features. (feel free to edit these at your own will)

Auto Reset-

DW:

Code:

---

UPDATE Character
SET clevel = 1, Experience = 0, 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);

---

DK:

Code:

---

UPDATE Character
SET clevel = 1, Experience = 0, 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);

---

ELF:

Code:

---

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 350 * (Reset + 1), Money = Money - (50000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, 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 = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

---

MG:

Code:

---

UPDATE Character
SET clevel = 1, Experience = 0, 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) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

---

DL (99+):

Code:

---

UPDATE Character
SET clevel = 1, Experience = 0, 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 = 64) AND (clevel >= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);

---

Automatic backup:

Code:

---

--trunkating
BACKUP LOG muonline WITH NO_LOG

USE [Muonline]
GO
--shrinking
DBCC SHRINKDATABASE(N'Muonline')

Declare @dateBackup Varchar(100)
Set @dateBackup = 'C:\MuOnlineBackups\muonline_' +
Convert(varchar, datepart( year , Getdate() )) + '-'+
Convert( varchar , datepart( month , Getdate() ) ) + '-'+
Convert( varchar, datepart( day , Getdate() ) ) + '.bak'
--saving backup with name and date.
BACKUP DATABASE [Muonline] TO DISK = @dateBackup WITH NOFORMAT, NOINIT, NAME = N'Muonline-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

---

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'

---

Zen Bug Fix:

Code:

---

UPDATE Character
Set Money=('2000000000')
WHERE Money<0

---

Auto PK reset:

Code:

---

Update Character
SET PkLevel = ('0'), PkTime = ('0'), Pk Count = ('0')
Where PkLevel>2

---

and thats it for SQL :D

VI. Websites-

ill provide a link to a good website that i think is the best:
http://***************/index.php?dir=...=MuWeb_0.4.rar
or
http://***************/index.php?dir=...4_with_md5.rar

as you can see, thats muweb .4 with and without MD5

now for the webservers

AppServ: http://***************/index.php?dir=...in32-2.5.1.rar
EasyPHP: http://***************/index.php?dir=...p1-8_setup.rar

i wont tell you how to set these up, you can find guides on RZ
----------------------------------------------------------------------------------------------------------------

this is what you want to have in a website-
1. Registration
2. Reset (lvl and pk)
3. stats adder
4. link to the forum
5. player warp
6. admin cp
7. cutenews :D

make sure your website name is easy to remember so players can get there easily :)

VII. Shops-

hmm..questions.

1. I have a high/low experience server, should i have pro/noob shops?
2. Should i have BB on or off?
3. Should my prices be high or low?

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

think of these questions and youll have great shops :D

here is a link to a shop editor:

Mu_Shop_1.1_BETA.zip - FileFront.com

to turn on BB, when you put bless in shops, maker its dyrability 255 :)

also, make sure your GM shop is out of reach of normal players, 6 119 119 is always a good spot for the shop ;)




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

Credits: ThePumpkinKing, if you see this guide here without my name in it, tell me and ill beat them up

this is all i could think of for now, you can add your own portion and ill add it to the first post(ill also credit you for it)

thanks for reading

Nice, this will help many ppl who make the first time a server :)

Good Work dude

Do this guide stuport router users? and do you got any good suggyestions of good server files?

your guide is a lil messy, try to CODE all the scrpts that you have posted

Why do i keep getting this messege when im trying to ompen mu shop?
http://i169.photobucket.com/albums/u...hitmuhsops.jpg

Translation: It's imposibole to idetefy teh program corekt (0xc0000135). klick here to clsoe the progrogram

another question: What is best muweb .4 with MD5 or whoute?

Quote:

---

Originally Posted by liselotte

your guide is a lil messy, try to CODE all the scrpts that you have posted

---

i wrote it in notepad :P

but i suppose i could fix it :P

btw, the muweb thing depends on if your version supports muweb + MD5 :P

fixed the guide, its a little easier to read now ;)

Quote:

---

Originally Posted by Coltage

Why do i keep getting this messege when im trying to ompen mu shop?

Translation: It's imposibole to idetefy teh program corekt (0xc0000135). klick here to clsoe the progrogram

another question: What is best muweb .4 with MD5 or whoute?

---

you need to install .Net FrameWork 2.0. go to microsoft web and download it

Quote:

---

Originally Posted by liselotte

you need to install .Net FrameWork 2.0. go to microsoft web and download it

---

what he said :P

ill get a link in a minute

EDIT: here it is :D http://www.microsoft.com/downloads/d...displaylang=en

I have the newest micrsoft net framework of 2.0 with all the updates and i still cant get the beta to work can you xplain y plz

Quote:

---

Originally Posted by ThePumpkinKing

what he said :P

ill get a link in a minute

EDIT: here it is :D http://www.microsoft.com/downloads/d...displaylang=en

---

those autoresets dont keep stats?

Zen Bug Fix:
Code:

UPDATE Character
Set Money=('2000000000')
WHERE Money<1

:D:D:D:D

nice zen bug fix.. i create new character, wait for sql and i got 2kkk on my char?.. well thx:D

Quote:

---

Originally Posted by demon60

those autoresets dont keep stats?

---

it doesn't... try to undertand query.. it's so easy :ninja:

That code

UPDATE Character
Set Money=('2000000000')
WHERE Money<1

is wrong, I've tested it, and if u create char with 0 zen, code will ocurr and u will receive 2000000000 zen

code have to be like this

UPDATE Character
Set Money=('2000000000')
WHERE Money<0

Quote:

---

Originally Posted by SHANG

That code

UPDATE Character
Set Money=('2000000000')
WHERE Money<1

is wrong, I've tested it, and if u create char with 0 zen, code will ocurr and u will receive 2000000000 zen

code have to be like this

UPDATE Character
Set Money=('2000000000')
WHERE Money<0

---

it does work, but good eye, i fixed it

i get this error when i add the autoreset code in sql query

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Character'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'MEMB_STAT'.

Plss help me how i can get an account to my server 97d+99. I maid the server it is succses but the my problem is how i can REGISTER in my server and get an account plss help me or give me a guide to have an account tnx......

Quote:

---

Originally Posted by khemson

Plss help me how i can get an account to my server 97d+99. I maid the server it is succses but the my problem is how i can REGISTER in my server and get an account plss help me or give me a guide to have an account tnx......

---

Easiest method would be to use an MUeditor... search around the forum. You should be able to get a download link for the utility. Good luck.

Need a little help:
1. how can i set Blood Castle drop, i dont want chaos jewl.
2. how can i change GM Box drop?
3. how can i set white wizzard drop, i want him to drop bless or soul.
4. how can i set drop rate for marlon quest (ring of honor) and all other quests?

this is 2 years old but some of it still applys keep that in mind

Quote:

---

Originally Posted by Coltage

Do this guide stuport router users? and do you got any good suggyestions of good server files?

---

:blink::blink::blink::blink::blink::blink:

this is just server configing lol, if u want season 2 use MMT season 2 files, if u want season 3 or season 4 files, use oski or lucianobar files xD. i cant spell his name ffs lol

khemson I can help you anything or advertising your site for free by contacting to my Skype: nectarcr0p your problem I know how you can do that to your server ;)