Announcement

Collapse
No announcement yet.

How to create a Mu Server

Collapse

728x90 top

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

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

  • #2
    nice guide

    Comment


    • #3
      ...

      very useful

      Comment


      • #4
        nice guide

        Comment


        • #5
          Thank you!

          Comment


          • #6
            cool tutorial

            Comment


            • #7
              cool !

              Comment


              • #8
                ty a lot!!!!

                Comment


                • #9
                  Nice guide

                  Comment


                  • #10
                    Administrator

                    cool guide

                    Comment


                    • #11
                      gg

                      nice guide

                      Comment


                      • #12
                        where can i find mutoolz?

                        Comment


                        • #13
                          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

                          Comment


                          • #14
                            or ragezone u can find all that :P

                            Comment


                            • #15
                              goood guide!

                              Comment

                              728x90 bottom

                              Collapse
                              Working...
                              X