Release my DM2 (mir 2.3 emu) files

smoochy boys on tour
Status
Not open for further replies.
.ViruS

.ViruS

Banned
Banned
Dedicated Member
Jan 6, 2007
103
0
63
./usr/
My first post in this topic was posted before the "lets allow all binary releases" was posted so yes both projects are at the same level. If you checked we are releasing snippets of our codes to implement for those who want to code towards thier own server so its not fully closed source...

As said this is TDs post so ill leave it be.
 
BLADERUNNER

BLADERUNNER

Dedicated Member
Dedicated Member
Apr 6, 2007
72
0
53
Ok some of use have no idea how to use SQL(aka me) how do i make two new databases infact how do i use it full stop
 
Scorpian

Scorpian

Golden Oldie
Golden Oldie
Jul 8, 2003
728
35
185
Manchester
Firstly make sure you have these installed:
SQL 2005 express: (http://go.microsoft.com/fwlink/?LinkId=65109) remember ID:sa password:whatever
SQL toolkit: (http://go.microsoft.com/fwlink/?LinkId=65111)
DTS (not sure if this is needed): (http://www.microsoft.com/downloads/...-4fc2-a67d-48053b8f9fad/SQLServer2005_DTS.msi)

Open SQL server management studio express, it will ask for you to create or access a database, so create one. Not sure if the backups td made will restore to 2005, but hopefully someone can provide some inserts anyway?
Thats it really, spend some time getting to know your way around itl help in the long run.

DTS is the import/export wizard, not sure if things have changed but it didnt seem to install with SQL so it should with the installer. The app you want is \90\DTS\Binn\DTSWizard.exe so run that to import your data such as mongen etc if you have your own

This version of SQL is free btw, and sorry I am so brief.

And yes I aggree td has done a very good job with these files.
 
wachoo

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
Someone know how can i unlock max lvl from 500 to 65k because naw is set to 500
 
Nightwolf

Nightwolf

Developer
VIP
Jul 16, 2003
2,133
21
285
Manchester, UK
had these files running fine but today i get this

[2007-04-23 19:03:32] SearchViewRange nil PEnvir
[2007-04-23 19:03:32] SearchViewRange nil PEnvir
[2007-04-23 19:03:32] SearchViewRange nil PEnvir
[2007-04-23 19:03:32] Q14091 SendRefMsg nil PEnvir
[2007-04-23 19:03:33] Q1406 SendRefMsg nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] Q1403 SendRefMsg nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:33] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] Q1411 SendRefMsg nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] Q14221 SendRefMsg nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:34] QManage SendRefMsg nil PEnvir
[2007-04-23 19:03:34] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] QFunction SendRefMsg nil PEnvir
[2007-04-23 19:03:35] Q1403 SendRefMsg nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] Q1422 SendRefMsg nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] Q1421 SendRefMsg nil PEnvir
[2007-04-23 19:03:35] QManage SendRefMsg nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:35] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] Q1404 SendRefMsg nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] Q1401 SendRefMsg nil PEnvir
[2007-04-23 19:03:36] QFunction SendRefMsg nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:36] SearchViewRange nil PEnvir
[2007-04-23 19:03:37] Q1404 SendRefMsg nil PEnvir
[2007-04-23 19:03:37] SearchViewRange nil PEnvir
[2007-04-23 19:03:37] RobotManage SendRefMsg nil PEnvir
[2007-04-23 19:03:37] Q1401 SendRefMsg nil PEnvir
 

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,340
90
294
nightwolf did any updates by any chance? :p
that error usualy comes from a bug in the db :p
 

LadyDante

Dedicated Member
Dedicated Member
Jul 26, 2006
54
1
54
oki, well when i go to make an account i prees okay n nothing, ive done everything correctly, ive tryed making 2 bd files 1 called mir2 n 1 called mir23 n every on gates run perfect, but when i come to make account nothing, if anyone can gimmi a little insite on this id be very grateful.

Ive made a char in admin_bd, i have also try chaging the Bak files to mnd (or what it called file) n deleting the nessasry files, but as some1 said if u get an error in m2server delete the files in your BD, well ive got all the mnd files n i havnt deleted them but i get 1 error msg saying "MapQuest.txt : Failure was occurred while reading this file.Code= -14", but my aim atm is to get ingame n find bug n change alot of stuff

so if anyone can help me with this problem i will be very grateful

Thanks The GogLand Team
 

jamiedotco

Dedicated Member
Dedicated Member
Nov 16, 2006
140
0
62
wachoo said:
Ok i checked some forums and i found that solution:
Setting up the files (offline):

1. download the server files from here http://users.telenet.be/thedeath/Mir2/LOMCNM2.rar

2. run the rar file and extract the files to C:/mirserver
3. got to your legend of mir folder
c:/program flies/wemade/legend of mir
right click on the map folder and click copy.
Go to your m2server folder
c:/mirserver/m2server
and paste the map folder into here

4. 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 (test):
/DBServer/!addrtable.txtl
/DBServer/!serverinfo.txtl
l /DBServer/dbsrc.ini
/LoginGate/Config.inil
l /LoginSrv/!addrtable.txt
/LoginSrv/!serveraddr.txtl
l /LoginSrv/!UserLimit.txt
/LoginSrv/Logsrv.inil
l /LogServer/LogData.ini
/M2Server/!runaddr.txtl
l /M2Server/!servertable.txt
/M2Server/!Setup.txtl
l /RunGate/Config.ini
/SelGate/Config.inil

5. Download SQL Server 2000 - XXXX
6. Install SQL using Authentication mode, and set a password mir23

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

8. Right click any where in this window and then click new database.

9.In the box called name, type "mir23" then click ok.

10. Right click somewhere in the Database window, highlight over ‘All Tasks’ and click ‘Restore Database’.

11. Click the option tab, and then tick all 3 boxes, once you done that click back on the general tab.

12. Check the box that says restore as database, click on the arrow and select mir23.

13. The next line down, where it say restore, click "From Device’ and click the button saying ‘Select Devices’ then ‘Add’ button.

14. On the File Name box click the button saying ‘…’ and select lom2_chardb.bak from \DBServer. Then press OK until the database is restore.

15. Too add your self as a GM, right click on the table admin, then select , open table> return all rows.


16. Now go back to your sever folder and open
DBServer/dbsrc.ini
a few lines down you will see SQL type.
The line under that you need to change so it looks like this.

SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=<the password you entered when you setup mssql>

You now need to do the same in

DBServer/!Setup.txt

so it look like this

[SQL]
UseSQL=True
SQLHost=127.0.0.1
SQLUsername=sa
SQLPassword=<the password you entered when you setup mssql>
SQLDatabase=mir2
SQLType=mssql

17. you can now close MSSQL. The go back to ur server folder and run the following exe's. It don’t matter in which order you run them.

m2server/m2sever.exe (run this 1st as it takes the longest to load.
DBserver/dbserver.exe
gamegate/gamegate.exe
logingate/logingate.exe
loginsv/loginsrv.exe
logserver/LogDataServer.exe
selgate.exe

If you get no error in any of these your server is running ok.
16. Go back to your server file folder, then your m2server folder, copy the mir2.exe and paste it in to your legend of mir folder.

18. open your legend of mir folder and then open
mir.ini
change the 3 ip addresses in here to 127.0.0.1 then save this file as
mir2.ini

19. run the mir2.exe and you will be connected to your server.

20. if thats all working and your happy, try downloading the updates from : XXXXX
make sure you read the update document before doing any thing.

21. any problems with the files before the update, feel free to post here


In this solution i need to create only 1DB
mir23 ---> lom2_chardb.bak
in ur solution is one more DataDB
Why?

When i make everything like this and when i run server all gates are connected but i saw in client "connection closed" when i use other client mir2.exe and mir2.ini (i change all ips to my) i cant create account i saw nothing (nothing happened). Maybe i cant create account becasue i dont have second database in SQL (DataDB)???? Can u help me?
Click to expand...

My guide thanks for the credits ^^
 
koni

koni

V.I.P
VIP
Mar 14, 2006
1,111
1
185
Southampton UK
Nightwolf said:
using the latest db i think and all latest exes
Click to expand...

that error is caused by not updating the sql fields as said in the updates.doc you need to add to the tbl_merchant showx, showy, showflag read the updates.doc please it will get rid of all the errors.


@ladydante
read this thread it will solve your problems, next time use the search button
http://www.lomcn.co.uk/forum/showthread.php?t=50243
 
Last edited:
Nightwolf

Nightwolf

Developer
VIP
Jul 16, 2003
2,133
21
285
Manchester, UK
TD can you make it so all Ore drops are a random puri instead of just puri10 as thats how it is on the official server just thought I would point it out as fox mobs drop plat with different puris and also giftboxes etc..
 

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,340
90
294
nightwolf i remember making ores drop random puri not sure if i did it for all ores but well i know i did it :p
 
Robert

Robert

Actual Jesus
VIP
Jan 1, 1970
4,606
62
104
Yes.
Can anyone post a Database which is fully updated. Im not after your items but im struggling with sql.

Thanks
 
jasper

jasper

Golden Oldie
Golden Oldie
Sep 10, 2005
890
3
125
yes lol,, "do as i say" syndrome, the data in there may not be acurate, ie dooways, npc locations, mob spawns, (but they are usually a personal preference), but new fields and type are correct, u will probs get an error on mapquest, if you dont already know, delete the line in mapquest.txt with the ghoul on map d4221, then next one would be nps/merchant missing for 'GA' something or other, somebody has posted the scripts somewhere, or delete them from the db, up to you.
 
daydie

daydie

Banned
Banned
Golden Oldie
Aug 26, 2004
635
0
123
thedeath or any1 who has old release of his files.


i have his old 1z here and they have sorce in, can i use these to edit my current ? and make not use taht DB server.
 
Status
Not open for further replies.
Top Bottom