MU: GUIA PARA CREAR UN SERVIDOR DE MUONLINE

Setting up SQL

Run SQL Setup
Select "SQL Server 2000 Components"

1. Click "Install Database Server"

2. Click Next

3. Click dot in Local Computer and Next

4. Click dot in "Create a new instance of SQL Server,or install Client Tools" and next

5. Put name and company Click Next

6. Click Yes to Agreement

7. Click dot in Server and Client Tools and Next

8. Click tick in Default at top and Click Next

9. Click dot in Typical Click Next

10. Click dot in "Use the same account for each service.Auto start SQL Server Service"

11. Click dot in "Use the Local System account" Click Next

12. Click dot in "Windows Authenticatication Mode." Click Next

13. Click Next and install

When installed reboot so server starts.

Restoring Database

1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager) and go to Databases.

2. Create a new database, name it MuOnline.

3. After that, right click on muonline database then click "Restore Database".

4. Click on "From Device" and then click on "Select Devices".

5. Click Add and then choose the destination of the backups to Restore into muonline.

6. Press OK 3 times to continue, then press the Options tab.

7. Tick "Force restore over existing database", check that the database files point below D:\MuServer\DB\ directory

8. Press OK to import the database.

9. Create another database, name it Ranking and restore the tables from Ranking database files, make sure the database files point below D:\MuServer\DB\ directory.
   Do the same for the exdb database.

( IF YOU DON'T HAVE THE EXDB .BAK, THEN DON'T BOTHER DOING THE DATABASE FOR IT. )

Adding Accounts

1. Open SQL Analyzer ( Start-> Programs -> MSSQL -> SQL Analyzer)

2. Choose MuOnline

3. Add this:

INSERT INTO MEMB_INFO (memb_guid,memb_id,membpwd,memb_name,snonumb ,post_code,addr_info,addr_deta,telnumb,mail_addr ,phon_numb,fpas_ques,fpas_answ,jobcode,appl_days ,modi_days,outdays,true_days,mail_chek,bloc_code ,ctl1_code)
VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t est@test.com','question','answer','1','2004-1-1','2004-1-1','2004-1-1','2004-1-1','1','0','1')

INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,membid,memb_name ,memb_guid,snonumb,Bill_Section,Bill_value,Bill Hour,Surplus_Point,Surplus_Minute,Increase_Days )
VALUES ('2005','1',1234,'$login','$nick',1,'7','6','3','6 ','6','2004-1-1 10:36:00','0' )

Change the values $login, $nick, $password to your desired one.
(IT IS 4 LINES IN TOTAL IN THE QUERY, 2 LINE FOR EACH)

System DSN

1. Start Data Sources (ODBC) (Start -> Programs -> Administrative Tools -> Data Sources (ODBC)), go to System DSN tab then click Add.

2. Select the SQL Server driver(bottom) and click Finish. Choose MuOnline for Name and your SQL Server for Server.

3. Change the default database to muonline and click Next then Finish and OK.

4. Create also 3 more System DSN links named MuOnlineJoinDB, USELOG, Event that use muonline as the default database.

5. Create 1 System DSN named Ranking that use Ranking as the default database.

Editing IP Address and Setting up Server Files

1. Type ipconfig /all in command prompt to check your ip.

2. Change all the ip addresses (127.0.0.1) found in config files to your ip address.
   IP Addresses can be found in the following files:

D:\MuServer\CS\Connectserverlist.dat
D:\MuServer\CS\data\Connectserverlist.dat
D:\MuServer\CS\data\ServerList.dat
D:\MuServer\data\commonserver.cfg
D:\MuServer\data\IpList.dat
*D:\MuServer\data\lang\eng\commonloc.cfg
*D:\MuServer\data\lang\kor\commonloc.cfg
*D:\MuServer\data\lang\tai\commonloc.cfg
*D:\MuServer\data\lang\chi\commonloc.cfg

(*may not apply to all)

3. Change the IP Addresses found in 5.lnk* and 9.lnk* files below D:\MuServer\Links folder(right click on them and select properties) to your own. (*links may defer.)

4. Edit D:\MuServer\MU2003_EVENT_SERVER\DATA\svconfig.ini and change "mu2003_dsn = DEVILSQURE_RANKING" to "mu2003_dsn = Ranking" and edit also D:\MuServer\RankingServer\svconfig.ini changing "odbc_dsn=DEVILSQURE_RANKING" to "odbc_dsn=Ranking"

Connecting to your Server

There are 2 ways as to how you can connect to your Server:

1. Edit your partition in your client files.

2. make a shortcut from your "Main.exe"

right click it and select properties

in "Target:" put all below including the "

and change the 123.456.7.8 for the ip u want to join

and run the shortcut

"C:\Program Files\Webzen\Mu\main.exe" connect /u123.456.7.8 /p44405

Hope this can help anyone new to private servers and it's setup process.

ADD-ON

If anyone is having this error:

Server: Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'MEMB_INFO' when IDENTITY_INSERT is set to OFF.
Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_VI_CURR_INFO'. Cannot insert duplicate key in object 'VI_CURR_INFO'.
The statement has been terminated.

Do this:

add SET IDENTITY_INSERT MEMB_INFO ON at the top like this:

SET IDENTITY_INSERT MEMB_INFO ON
INSERT INTO MEMB_INFO (memb_guid,memb_id,membpwd,memb_name,snonumb ,post_code,addr_info,addr_deta,telnumb,mail_addr ,phon_numb,fpas_ques,fpas_answ,jobcode,appl_days ,modi_days,outdays,true_days,mail_chek,bloc_code ,ctl1_code)
VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t est@test.com','question','answer','1','2004-1-1','2004-1-1','2004-1-1','2004-1-1','1','0','1')

INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,membid,memb_name ,memb_guid,snonumb,Bill_Section,Bill_value,Bill Hour,Surplus_Point,Surplus_Minute,Increase_Days )
VALUES ('2005','1',1234,'$login','$nick',1,'7','6','3','6 ','6','2004-1-1 10:36:00','0' )

for VI_CURR_INFO, go to the table of VI_CURR_INFO, right click, select design table, remove the key sign and everything shall work fine

PS: REMOVE THE "$" FROM THE $LOGIN, $PW, $NICK YOU HAVE EDITED/CHANGED

Please do not PM me unless neccessary.
perlitas

:S

Os que solo te llega la neurona para aprender esas 2 comibnaciones de teclas?. Podias haber puesto los links y nos habriamos quedado mejor. Solo espero que algun administrador vea tu otro mensaje a ver si te echan de una vez.

NUEVOS SERVERS DARKCOVA

SERVER NORMAL DARKCOVA

ip: normal.darkcova.com
port: 44405
exp: 35
drop: 65
capacidad (de momento): 3 servers de 200 usuarios cada uno
bless bug: off

SERVER FAST DARKCOVA

ip: fast.darkcova.com
port: 44405
exp: 1000
drop: 80
capacidad (de momento): 3 servers de 200 usuarios cada uno
bless bug: on

PAGINA WEB: www.darkcova.com
DUDAS Y QUEJAS: webmaster@darkcova.com

Todos los mundos, casi todos los eventos activados mas propios del server
Todos los items son accesibles de una forma o de otra, solo esperar a eventos

Los servidores darkcova pertenecen a SGSI S.L.

copyright Flyky

darcova fast exp 1000 drop 80 http://www.darkcova.com/ para mi el mejor fast que existe

Jove Server o Muluxe: http://mu.hbluxe.com a este le falta ser fast porque tiene muy poca exp Exp & Drops: 25% & 50%

tienes la guia arriba y está muy clara.

KIERO CREAR UN SERVER ALguien me puede AYUDAR????????????????? k me agregue alexfgines@hotmail.com

NA QUE NO SABEN LEER

QUE ES LO QUE NO SABES , INGLES?

HOMBRE SI QUIERES TAMBIEN TE LO TRADUZO.

SI ES FACILISIMO HOMBRE, SIGUE LOS PASOS YA YA ESTA.

Y SI NO PREGUNTAS EN WWW.DARKCOVA.COM , O EN WWW.MUONLINE.COM

ASI DE ŽFACIL.

SALUDINES

NUEVOS SERVERS DARKCOVA

SERVER NORMAL DARKCOVA

ip: normal.darkcova.com
port: 44405
exp: 35
drop: 65
capacidad (de momento): 3 servers de 200 usuarios cada uno
bless bug: off

SERVER FAST DARKCOVA

ip: fast.darkcova.com
port: 44405
exp: 1000
drop: 80
capacidad (de momento): 3 servers de 200 usuarios cada uno
bless bug: on

PAGINA WEB: www.darkcova.com
DUDAS Y QUEJAS: webmaster@darkcova.com

Todos los mundos, casi todos los eventos activados mas propios del server
Todos los items son accesibles de una forma o de otra, solo esperar a eventos

Los servidores darkcova pertenecen a SGSI S.L.

con esto es muy facil

solo teneis que seguir los pasos

saludines

perli ya me he creado el servidor con la 0.98 c pero con experiencia normal

ayudame a aumentar la exp

y te digo donde se conecta para que lo pruebes

gracias

Gracias por esta estupenda guia.

Muack