Mir2 2.3 Server Files

wazz · Jul 24, 2006

dapoldi said:
@Wazz

you're using an incorrect client.exe .. or.. you're using a server.exe mental posted before.. encryption error, use the right files (no client.exe for mental's exe found as of yet..)

Cheers m8

- I thought I had already tried a different m2server since I got the error but I guess I didn't.

Nightwolf · Jul 25, 2006

ok completed the other npc scripts for guild territorys dream pouch npc and the both Stairs

Onuris · Jul 26, 2006

Ok i've readed this all thread about 5 times and didn't helped me

Elvin · Jul 26, 2006

did u edit the sqlmir2.reg and then run it .
also edit the !DBSql and !DBSetup.txt files .
(1)!DBSetup
; BDE Alias Name
ALIAS NAME=SqlMir2DB
; GOLD NAME DIFFERENT COUNTRY
GOLDNAME=Gold
; Name or IP
SERVER NAME=(local)
; Resource DataBase Name
DATABASE NAME=LOM2Res
; DB Owner's User Name
USER NAME=username here
; Password
PASSWORD=password here
;Tabel Names
TABLE_STDITEMS=RES_STDITEMS
TABLE_MONSTER=RES_MONSTER
TABLE_MOBITEM=RES_MOBITEM
TABLE_MAGIC=RES_MAGIC

only change user and pass..
(2)!DBSQL
server name=Provider=SQLOLEDB.1;Password=User Password;Persist Security Info=True;User ID=User id;Initial Catalog=LOM2Market;Data Source=127.0.0.1

only change server name id and password
also ID and Password = sqlserver ID and password ie Sa and whatever u used when u installed.
(3)sqlmir2.reg
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"

[HKEY_LOCAL_MACHINE\SOFTWARE\LegendOfMir2007\DatabaseSvr]
"NAME"="ServerNAME"
"ODBC_DSN"="LOM2Game"
"ODBC_ID"="ID"
"ODBC_PW"="Pass"
"ODBC_DSN2"="LOM2Account"
"ODBC_ID2"="ID"
"ODBC_PW2"="Pass"
"LS_ADDR"="127.0.0.1"
"MF_FILEPATH"="D:\\SqlMir2\\Mir200\\Envir"
"LS_CPORT"=dword:000015e0
"GS_BPORT"=dword:00001770
"RG_BPORT"=dword:000013ec

[HKEY_LOCAL_MACHINE\SOFTWARE\LegendOfMir2007\LoginSvr]
"ODBC_DSN"="LOM2Account"
"ODBC_ID"="ID"
"ODBC_PW"="Pass"
"ODBC_DSN_PC"="LOM2Manage"
"ODBC_ID_PC"="ID"
"ODBC_PW_PC"="Pas"
"CS_BPORT"=dword:00000bb8
"GS_BPORT"=dword:000015e0
"LG_BPORT"=dword:0000157c
edit required fields ..

try all this it may help

peppe · Jul 26, 2006

if these files work properly at the end like taken off demo i am willing to host add [email protected] ty.

DivX:) · Jul 26, 2006

I've been away from the mir scene for awhile, so go gentle on me.. I'm trying to restore the database files and get the same error as Tasha.

Tasha said:
or can someone help me to restore the db's

i get a error saying "Too many backup devices specified for backup or restore; only 64 are allowed.RESTORE DATABASE is terminating abnormally."

Damian said "you need the SQL2000 DB" where can I get this file?

Elvin · Jul 27, 2006

if you get the demo2007 files and not latestmir2 files from milos post you should have a db to restore. lok for LOM2007Demo(SQL2000) in this whole post.
maybe its on xsoffee's site

you get that error trying to restore sql2005 data on sql 2000 btw

DivX:) · Jul 27, 2006

Thanks Elvin, I got the DB's restored now. Could somebody tell me what you put in the !DBSETUP.txt

; BDE Alias Name
ALIAS NAME= ?? // whats this all about please.

Nightwolf · Jul 27, 2006

DivX:) said:
Thanks Elvin, I got the DB's restored now. Could somebody tell me what you put in the !DBSETUP.txt

; BDE Alias Name
ALIAS NAME= ?? // whats this all about please.

!DBSETUP.txt

; BDE Alias Name
ALIAS NAME=SqlMir2DB
; GOLD NAME DIFFERENT COUNTRY
GOLDNAME=Gold
; Name or IP
SERVER NAME=(Local)
; Resource DataBase Name
DATABASE NAME=LOM2Res
; DB Owner's User Name
USER NAME=SQLUSERNAME HERE
; Password
PASSWORD=SQLPASSWORD HERE
;Tabel Names
TABLE_STDITEMS=RES_STDITEMS
TABLE_MONSTER=RES_MONSTER
TABLE_MOBITEM=RES_MOBITEM
TABLE_MAGIC=RES_MAGIC

!DBSql.txt

SERVERNAMEHERE=Provider=SQLOLEDB.1;Password=SQLPASS;Persist Security Info=True;User ID=SQLUSER;Initial Catalog=LOM2Market; Data Source=(Local)

Elvin · Jul 27, 2006

Nightwolf said:
!DBSETUP.txt

; BDE Alias Name
ALIAS NAME=SqlMir2DB
; GOLD NAME DIFFERENT COUNTRY
GOLDNAME=Gold
; Name or IP
SERVER NAME=(Local)
; Resource DataBase Name
DATABASE NAME=LOM2Res
; DB Owner's User Name
USER NAME=SQLUSERNAME HERE
; Password
PASSWORD=SQLPASSWORD HERE
;Tabel Names
TABLE_STDITEMS=RES_STDITEMS
TABLE_MONSTER=RES_MONSTER
TABLE_MOBITEM=RES_MOBITEM
TABLE_MAGIC=RES_MAGIC

!DBSql.txt

SERVERNAMEHERE=Provider=SQLOLEDB.1;Password=SQLPASS;Persist Security Info=True;User ID=SQLUSER;Initial Catalog=LOM2Market; Data Source=(Local)

lol i believe i posted that above hehehe

Onuris · Jul 27, 2006

Elvin said:
did u edit the sqlmir2.reg and then run it .
also edit the !DBSql and !DBSetup.txt files .
(1)!DBSetup
; BDE Alias Name
ALIAS NAME=SqlMir2DB
; GOLD NAME DIFFERENT COUNTRY
GOLDNAME=Gold
; Name or IP
SERVER NAME=(local)
; Resource DataBase Name
DATABASE NAME=LOM2Res
; DB Owner's User Name
USER NAME=username here
; Password
PASSWORD=password here
;Tabel Names
TABLE_STDITEMS=RES_STDITEMS
TABLE_MONSTER=RES_MONSTER
TABLE_MOBITEM=RES_MOBITEM
TABLE_MAGIC=RES_MAGIC

only change user and pass..
(2)!DBSQL
server name=Provider=SQLOLEDB.1;Password=User Password;Persist Security Info=True;User ID=User id;Initial Catalog=LOM2Market;Data Source=127.0.0.1

only change server name id and password
also ID and Password = sqlserver ID and password ie Sa and whatever u used when u installed.
(3)sqlmir2.reg
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"

[HKEY_LOCAL_MACHINE\SOFTWARE\LegendOfMir2007\DatabaseSvr]
"NAME"="ServerNAME"
"ODBC_DSN"="LOM2Game"
"ODBC_ID"="ID"
"ODBC_PW"="Pass"
"ODBC_DSN2"="LOM2Account"
"ODBC_ID2"="ID"
"ODBC_PW2"="Pass"
"LS_ADDR"="127.0.0.1"
"MF_FILEPATH"="D:\\SqlMir2\\Mir200\\Envir"
"LS_CPORT"=dword:000015e0
"GS_BPORT"=dword:00001770
"RG_BPORT"=dword:000013ec

[HKEY_LOCAL_MACHINE\SOFTWARE\LegendOfMir2007\LoginSvr]
"ODBC_DSN"="LOM2Account"
"ODBC_ID"="ID"
"ODBC_PW"="Pass"
"ODBC_DSN_PC"="LOM2Manage"
"ODBC_ID_PC"="ID"
"ODBC_PW_PC"="Pas"
"CS_BPORT"=dword:00000bb8
"GS_BPORT"=dword:000015e0
"LG_BPORT"=dword:0000157c
edit required fields ..

try all this it may help

ye i edited it buy as the AliasName i have HeroDB, if i have to change to sqlmir2db dunno what type of db shal i select? Standard, etc.. .?

**EDIT: fixed. works

**EDIT2: receiveing Royal DBSQL Connection is NULL also when i enter in Mir application, the colors aint right, its like 4 or 8 bit colors lol

Onuris · Jul 28, 2006

K all works but when I press START, after char creating, screen fades to black, then comes back, and no notice screen. Any ideas?

EDIT**: k thats fixed now, but when i enter in-game, the client auto-exits, dunno why
EDIT***: fixed that also
EDIT****: Any1 know how to add data from a *.mdb file to a database?
EDIT*****: fixed

Knight · Jul 28, 2006

Onuris said:
K all works but when I press START, after char creating, screen fades to black, then comes back, and no notice screen. Any ideas?

EDIT**: k thats fixed now, but when i enter in-game, the client auto-exits, dunno why
EDIT***: fixed that also
EDIT****: Any1 know how to add data from a *.mdb file to a database?
EDIT*****: fixed

How did you fix the Select Screen Fading?

- Knight

Elvin · Jul 28, 2006

Knight said:
How did you fix the Select Screen Fading?

- Knight

he got me to do VNC and i helped him with a different set of files.

@onuris
to add the LOM2Res.mdb u need to go to LOM2Res database in enterprise manager
right click on it and choose alltasks then import data.
when window opens choose microsoft access from the drop down list at the top the window will change then u must locate the mdb and from there its plain sailing.. Good Luck

xsoffee · Jul 28, 2006

; BDE Alias Name
ALIAS NAME=SqlMir2DB

It's no use in these file sets.

Onuris · Jul 28, 2006

In DBServer folder, in servertable.txt was 127.0.0.1,192... an ip, i've changed to 127.0.0.1,127.0.0.1 PORTNUMBER

Knight · Jul 28, 2006

Onuris said:
In DBServer folder, in servertable.txt was 127.0.0.1,192... an ip, i've changed to 127.0.0.1,127.0.0.1 PORTNUMBER

Thats all to fix the error? Didnt you have to do anything else?

- Knight

Edit: Hey you fixed it thanks! noticed mine was 127.0.0.1 127.0.0.1:7000 not 127.0.0.1,127.0.0.1:7000

Onuris · Jul 28, 2006

np m8.

2020202002002

Elvin · Jul 28, 2006

xsoffee said:
; BDE Alias Name
ALIAS NAME=SqlMir2DB

It's no use in these file sets.

care to expain what you mean by this because that is what is n my file and i havent changed it to anything else

Knight · Jul 28, 2006

I'm now having the problem using the English Client posted in this thread. After I click "OK" on the notice, it closes the EXE

Mir2 2.3 Server Files

Dedicated Member

Developer

LOMCN Veteran

Attachments

Golden Oldie

LOMCN Veteran

LOMCN Developer

Golden Oldie

LOMCN Developer

Developer

Golden Oldie

LOMCN Veteran

LOMCN Veteran

Dedicated Member

Golden Oldie

Dedicated Member

LOMCN Veteran

Dedicated Member

LOMCN Veteran

Golden Oldie

Dedicated Member