Release my DM2 (mir 2.3 emu) files

Status
Not open for further replies.

Fire

Golden Oldie
Golden Oldie
Apr 15, 2003
1,302
1
195
I thought that the SQL database was intrinsically connected to the dbserver for the character saving now?

anyway whats wrong with SQL, install sql and restore the backup...
 

BLADERUNNER

Dedicated Member
Dedicated Member
Apr 6, 2007
72
0
53
now how to get these running (verry basic guide):
- first you install ms sql with mixed authentication mode so you have a login/pass for it
- you need to enter the login/pass in the dbsrc.ini and the !setup.txt file
- you create 2 databases in ms sql (using enterprise manager)
- you recover my mir2_chardb and mir2_datadb files into these 2 db's, chardb is used by dbserver and datadb by m2server so you link each of these in the apropriate(hope i spelled this right :p) setup/ini file

- you'll prob have to edit some ip's like with other mir servers
- you might get errors about missing npc's/maps just delete the related npc's/maps in the ms sql db tables
- you'll have to read updates.doc to get a list of all the edits you have to do to the database, since i dont update my database every release
- you cant combine several different release versions gotta have all server + client exes from same release

hope ths pretty much helps (there are probably better guides outthere but i cant link to other forums :p)

And where would i be able to download ms sql from as ive searched on google and i have no idea wich one to use :S can someone get a link please ?
 

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,340
90
294
just search for sqleval.exe (it's a 120 day evaluation version of ms sql 2k)
as for removing sql from m2server: no i wont :p everyone else uses it so would be stupid to change it besides i like it :p
 

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
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?
 
Last edited:

Fire

Golden Oldie
Golden Oldie
Apr 15, 2003
1,302
1
195
are you trying to login in to the server on the host computer? if all three IP's in mir2.ini are set as 127.0.0.1 then that is where you must be to try and login
 

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
ok now i can login but i have black screen when i choose my charcter and i put startgame(i cant see notice)

Any ideas?
 
Last edited:

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
No errors all are closed and working fine.
More informations:
When i make character and put start game i have black screen.
When i restart server
I dont have character, when i try to create character with same name i have this: NameInUse
But when i created second character i get same prob black screen.

Crazy crap:)
 

Fire

Golden Oldie
Golden Oldie
Apr 15, 2003
1,302
1
195
two things:

check your rungate IP address to make sure its ok
check in the SQL charinfo table to see if your character has been created
 

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
Run Gate Ips are correctly
But maybe u can post me here how i must configure SQL to this files?
Now i have that:
In SQL:
Databases:
all +
lom2_chardb (i have lom2_chardb.bak in DBserver)
lom2_datadb (i have lom2_datadb.bak in DBserver and data.mdb in M2server folder)
But now where in inis i must put lom2_chardb and where lom2_datadb?

I thing that my client is correctly because when i use ip of mir revenge server (server is running correctly)
 

Fire

Golden Oldie
Golden Oldie
Apr 15, 2003
1,302
1
195
have you imported the .bak files into the sql database?

and you can ignore the data.mdb its not used anymore
 

thedeath

LOMCN Developer
Developer
Mar 26, 2003
1,340
90
294
chances are you didnt setup the dbserver correctly so it's not connecting to ms sql or something like that
 

~Shogun~

Dedicated Member
Dedicated Member
Jul 2, 2005
58
0
53
UK
Well LOMCN has just shown that taking files from a project (which was open source) making it closed source and releasing it back to the community that started the project for mega credits is perfectly fine...

Great work staff way to show your awsome members!

Members want to play the files not wait months years because of red tape, get over it and move on the rest of us have, TD has done some good work here for the benefit of the members and he has never denied the contribution others made previously to them.
 

wachoo

Dedicated Member
Dedicated Member
Jul 13, 2006
85
0
53
Anyone can post here how configure SQL? (i can do that but maybe i do something wrong:P)

Thx
 

Dataforce

LOMCN VIP
VIP
Apr 15, 2003
2,080
0
283
Well LOMCN has just shown that taking files from a project (which was open source) making it closed source and releasing it back to the community that started the project for mega credits is perfectly fine...

Great work staff way to show your awsome members!

So I assume levelme is going to be releasing the source to all their dm2 stuff then ?
 

Dataforce

LOMCN VIP
VIP
Apr 15, 2003
2,080
0
283
No, you never intended to and are just trying to pick at others.

the GPL has not changed, the files are still GPL'd and thus this goes against the license on the source. However lomcn has chosen to allow it regardless.
 

Fire

Golden Oldie
Golden Oldie
Apr 15, 2003
1,302
1
195
Theres no need, GPL has been changed so it's fine and dandy.

therefore both projects stand on the same footing, according to the rules. therefore neither project is now in the wrong according to the current rules
(excluding the svn)

but this is TD's release post so stop talking about everything else
 
Status
Not open for further replies.