- Joined
- Jul 29, 2003
- Messages
- 936
- Reaction score
- 0
Setting up the files (offline):
Server Name: ktest
Server IP: 127.0.0.1
Server Directory: C:/mirserver
1.) Download
2.) Extract the files wherever you like (normally C:/mirserver)
3.) Check the following files to make sure they have the correct IP (127.0.0.1), the correct directories (C:/mirserver/…), and the correct server name (ktest):
/DBServer/!addrtable.txt
/DBServer/!serverinfo.txt
/DBServer/dbsrc.ini
/LoginGate/Config.ini
/LoginSrv/!addrtable.txt
/LoginSrv/!serveraddr.txt
/LoginSrv/!UserLimit.txt
/LoginSrv/Logsrv.ini
/LogServer/LogData.ini
/M2Server/!runaddr.txt
/M2Server/!servertable.txt
/M2Server/!Setup.txt
/RunGate/Config.ini
/SelGate/Config.ini
4.) Download SQL Server 2000 -
5.) Install SQL using Authentication mode, and set a password you can remember (ID will be sa)
6.) Once your SQL Server is running open Enterprise Manager and go into your SQL databases, there should already be ‘master’, ‘model’, ‘msdb’, ‘Northwind’, ‘pubs’, ‘tempdb’.
7.) Right click somewhere in the Database window, highlight over ‘All Tasks’ and click ‘Restore Database’.
8.) Check the box that says ‘From Device’ and click the button saying ‘Select Devices’ then ‘Add’ button.
9.) On the File Name box click the button saying ‘…’ and select lom2_chardb.bak from \DBServer. Then press OK a few times until the database restores.
10.) Edit the database tables as you like, i.e. GMs etc.
11.) Change the following files so they have the same information as your new SQL database:
/DBServer/dbsrc.ini
/DBServer/!Setup.txt
Make sure ‘UseSQL’ is set to TRUE, ‘SQLHOST’ is set to (local), ‘SQLUsername’ will be sa, ‘SQLPassword’ will be whatever password you set in the install, ‘SQLDatabase’ should be lom2_chardb unless you changed it, and ‘SQLType’ should be mssql, if you want to change to MySQL later on then change that to mysql.
12.) Download
13.) Delete the following tables from your SQL database:
Tbl_GUARD
TBL_MAGIC
TBL_MAPINFO
TBL_MERCHANT
TBL_MONGEN
TBL_MONSTER
TBL_MOVEMAPEVENT
TBL_NPC
TBL_STARTPOINT
TBL_STDITEMS
14.) Right click in your tables window, highlight ‘All tasks’ and select Import Data. When it asks where to import from select "Microsoft Access" from the drop down list and click the browse button and find /M2server/Envir/Data.mdb, leave the username and password field blank. When it asks where to import data to keep it as SQL, username will be sa and password is whatever you made it.
15.) Then you will get a list of tables, select all of the ones you just deleted except instead of TBL_MONGEN select TBL_MONGENORIGINAL and rename it to TBL_MONGEN (Then you will have full mongen, not my test mongen)
Then connect to the server and see how it goes
If i missed anything out in this little guide post it here and I will get it added asap.
Server Name: ktest
Server IP: 127.0.0.1
Server Directory: C:/mirserver
1.) Download
You must be registered to see links
2.) Extract the files wherever you like (normally C:/mirserver)
3.) Check the following files to make sure they have the correct IP (127.0.0.1), the correct directories (C:/mirserver/…), and the correct server name (ktest):
/DBServer/!addrtable.txt
/DBServer/!serverinfo.txt
/DBServer/dbsrc.ini
/LoginGate/Config.ini
/LoginSrv/!addrtable.txt
/LoginSrv/!serveraddr.txt
/LoginSrv/!UserLimit.txt
/LoginSrv/Logsrv.ini
/LogServer/LogData.ini
/M2Server/!runaddr.txt
/M2Server/!servertable.txt
/M2Server/!Setup.txt
/RunGate/Config.ini
/SelGate/Config.ini
4.) Download SQL Server 2000 -
You must be registered to see links
5.) Install SQL using Authentication mode, and set a password you can remember (ID will be sa)
6.) Once your SQL Server is running open Enterprise Manager and go into your SQL databases, there should already be ‘master’, ‘model’, ‘msdb’, ‘Northwind’, ‘pubs’, ‘tempdb’.
7.) Right click somewhere in the Database window, highlight over ‘All Tasks’ and click ‘Restore Database’.
8.) Check the box that says ‘From Device’ and click the button saying ‘Select Devices’ then ‘Add’ button.
9.) On the File Name box click the button saying ‘…’ and select lom2_chardb.bak from \DBServer. Then press OK a few times until the database restores.
10.) Edit the database tables as you like, i.e. GMs etc.
11.) Change the following files so they have the same information as your new SQL database:
/DBServer/dbsrc.ini
/DBServer/!Setup.txt
Make sure ‘UseSQL’ is set to TRUE, ‘SQLHOST’ is set to (local), ‘SQLUsername’ will be sa, ‘SQLPassword’ will be whatever password you set in the install, ‘SQLDatabase’ should be lom2_chardb unless you changed it, and ‘SQLType’ should be mssql, if you want to change to MySQL later on then change that to mysql.
12.) Download
You must be registered to see links
and extract and overwrite everything except the configuration files you edited earlier in step 3.13.) Delete the following tables from your SQL database:
Tbl_GUARD
TBL_MAGIC
TBL_MAPINFO
TBL_MERCHANT
TBL_MONGEN
TBL_MONSTER
TBL_MOVEMAPEVENT
TBL_NPC
TBL_STARTPOINT
TBL_STDITEMS
14.) Right click in your tables window, highlight ‘All tasks’ and select Import Data. When it asks where to import from select "Microsoft Access" from the drop down list and click the browse button and find /M2server/Envir/Data.mdb, leave the username and password field blank. When it asks where to import data to keep it as SQL, username will be sa and password is whatever you made it.
15.) Then you will get a list of tables, select all of the ones you just deleted except instead of TBL_MONGEN select TBL_MONGENORIGINAL and rename it to TBL_MONGEN (Then you will have full mongen, not my test mongen)
Then connect to the server and see how it goes
If i missed anything out in this little guide post it here and I will get it added asap.
Last edited by a moderator: