Announcement

Collapse
No announcement yet.

How to create a Mu Server

Collapse

728x90 top

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • hopzone
    started a topic How to create a Mu Server

    How to create a Mu Server

    (This guide does not include IIS and registration page and router help)

    Stuff needed

    1. MSSQL
    2. 0.97 server files (do a google search)
    3. 0.97 client patch (do a google search)

    If you want the 0.96y FULL client, proceed to this link

    http://www.muchina.com/download/full.htm

    -----

    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,memb__pwd,memb_name,sno__numb ,post_code,addr_info,addr_deta,tel__numb,mail_addr ,phon_numb,fpas_ques,fpas_answ,job__code,appl_days ,modi_days,out__days,true_days,mail_chek,bloc_code ,ctl1_code)
    VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t[email protected] ','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,memb___id,memb_name ,memb_guid,sno__numb,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,memb__pwd,memb_name,sno__numb ,post_code,addr_info,addr_deta,tel__numb,mail_addr ,phon_numb,fpas_ques,fpas_answ,job__code,appl_days ,modi_days,out__days,true_days,mail_chek,bloc_code ,ctl1_code)
    VALUES ('1','$login','$password','$nick', '1','1234','11111','personalid','12343','email','t [email protected] ','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,memb___id,memb_name ,memb_guid,sno__numb,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

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

    this tutorial is not created by me , it`s taken from a google search .

  • 19871986
    replied
    When you restore database to sql you are choose for where add to DB_MUOnline.bak

    Leave a comment:


  • alexu1000
    replied
    Thank you!

    Leave a comment:


  • niksan1
    replied
    where can i find BACK Up files.... because i can't find DB_MUOnline.bak
    pla tell me where is it?

    Leave a comment:


  • Grim-Reaper
    replied
    Very good and very helpful. 10/10

    Leave a comment:


  • kalahar
    replied
    thanks a lot for this !!

    Leave a comment:


  • systemous
    replied
    goood guide!

    Leave a comment:


  • Kirka
    replied
    or ragezone u can find all that :P

    Leave a comment:


  • rhakiztha
    replied
    please help me!! how to create my own MU server,

    where can i find mu client to edit it and how to have ur own website, please

    Leave a comment:


  • Jongikz
    replied
    where can i find mutoolz?

    Leave a comment:


  • alexsha
    replied
    gg

    nice guide

    Leave a comment:


  • fcv2005
    replied
    Administrator

    cool guide

    Leave a comment:


  • GuilTy
    replied
    Nice guide

    Leave a comment:


  • Sartigan
    replied
    ty a lot!!!!

    Leave a comment:


  • Tarlach
    replied
    cool !

    Leave a comment:

728x90 bottom

Collapse
Working...
X