[Guide] How to Setup Mir3 GSP Files

ratatatatatata

Install SQLServer 2014, once setup wizard tells you to select services, select the sqlserver and sql manager for manage the DB properly (this is needed to restore DB, etc).

Once installed NOT need to setup any ODBC. Normally. (Experts)

Open your SQL Management studio.

Restore DB (Steps):
Expand the Database Folder of the manager, right click to them and select "Restore Data Base", in the new window open,
select "Device", and then click to "..." to select the Backup file to restore.

In the new window, press Add, and then in the next dialog select the backup from your custom location.
(Note, if you dont find any backup file put the file extension in the dialog to *.* to see everything)

Once accepted and return to first window you see the name of the backup, if correct, click the Files page in the left of this window,
check for the output directory if exists, if ok, then press "accept" and the sql try to restore them to the name specified.

Make these steps for both Database. (Account and Game)

--

Once restores Both files, account and game DB, if no see on db list of your sql, press F5 or refresh button to see the DBs restored.



Files part:

Copy the content of the Mud3GSP full server to some place, normally called "mud3", if you chose C:\mud3\ or another place, if you want to put to a little dedi put to another unit to prevent fragmentation...

OK, the files you will see inside your mud3 folder is:
- Server_Job_ItemGen.exe -> MainServer, called EiServer.
- Other files...
- Folders:
-> Envir -> Here are normally all the npc scripts, etc
-> Gate1 -> Rungate1 -> the final gate you connected while gaming. Sometimes have 1, anothers 2, depending of the size of the server. For balancing...
-> Gate2 -> Rungate2... the same, another gate.
(Note: In this files these gates are configured to ports 7201 and 7202, remember this for setup the files) And if you want to make visible outside to put the server online for every one the gates, the IP to 0.0.0.0 only for the service IP, not for the internal conection IP.

Example for the rungate ini file:
[Server]
Title=GameGate 7201
GameSvrIP=127.0.0.1
GameSvrPort=5010
GateIP=0.0.0.0
GatePort=7201
GateIndex=1
MaxUser=200

and the others like this, be carefull with the other settings to not broken gates

Continuing with files, go to setup folder:
- Search this part in the config.ini file:

SqlDBLoc=(local)
SqlDBID=sa
SqlDBPassword=123456
SqlDBDSN=Game
DBAddr=127.0.0.1

ok, once here, i explain the settings:
SqlDBLoc -> SQLNAME or SQL IP, if the sql are in the same computer like the mir3 server leave to "(local)"
SqlDBID -> here put normally the user has rights to access the SQL.
SqlDBPassword -> logically the password of your sql user
SqlDBDSN -> here your GameDB Name, in the backup is "Game".
DBAddr -> the IP of the located DBServer, if all are local, leave to 127.0.0.1

If you take a look at this file, you see anothers 127.0.0.1... this is if you have your files local leave in that config.

Save the ini file.

OK, go next. Go back to mud3 folder.
You will see a folder named "网关" in this files, if you want rename it to "mir3server" for comodity and prevent problems of your windows for the language for launching the exes, etc

Inside this go to DBServer, open DBSERVERINFO.INI, search for:
PATH=d:\mud3\Envir\Mir3Res.dat

and put your path, if using C:\mud3 normally are C:\mud3\envir\Mir3Res.Dat

Mir3Res.Dat -> provably you are asking about this file... its the main DB of the server and its protected. Here are Items, Mobs, Respawns, NPC list, GM Commands, etc...

46401380

是个架设文档吗？72？？有没有中文的

lidipfa

什么跟什么啊

azhj2000

不错不错不错不错不错不错不错不错不错不错不错不错不错不错不错不错不错不错

wzd2008

谢谢了!感谢!

ratatatatatata

Common issues:

Problem 1:
I put my id and the password, then shows me the servr list (in this case GSP), once i select the server GSP the server kick off me and
in the logbox of loginserver show something of "onselectserver() NULL"

Check:
Open SQL management, go to table Account, goto expandablefolder Programing, expand Storage procedures and check for:
msp3_serverinfo_select, right click, edit or modify. check for the SP are like this, provably the start of the SP shows
USE
[ACCOUNTNAME]
GO

leave that, go down and look at that:
-----------------------------------------------------
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[msp3_serverinfo_select]

AS
SELECT * FROM TBL_SERVERINFO
--------------------------------------------------
need to be like this. then go to TBL_SERVERINFO and check for the ServerName are GSP (In this case )

next step

the same operation to the SP msp3_selectgateips_select

the first part leave that and find for that look like this:

---------------------------------
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[msp3_selectgateips_select]
@FLD_NAME nvarchar(20) =''

AS
SELECT FLD_NAME,FLD_IP,FLD_PORT,FLD_GAMETYPE FROM TBL_selectgateips
WHERE
FLD_NAME = @FLD_NAME
----------------------------------
next go to table TBL_selectgateips and edit them to check if everything match,

FLD_NAME / IP / PORT
SERVERNAME YOURIP PORT

Original:
GSP 127.0.0.1 7100 MIR3


Problem 2:
Client not work fine on Win10.

Use:
In some newer computers with windows 10 not run fine or runs slow, you can use this GFX emulator to launch the exe emulating another old GFX, instructions inside main app form.
- Download Link
I Hope this fixes the problem.




Normally with this tips the errors are fixed.

The common create character and delete character error are known, can be fixed inside game db, and search for storage procedure, the name explain what is every sp.
With this files when you create a character throws a error but the character is created if you go back.



Other Day more and better,
if someone can make screens for the process for help another put here and i put to the manual, i cant put screens because mine shows in spanish and a lot of people doesnt understand
And if someone have another fix or something i missed put here and i put to the guide for everyone.

Good gaming!

best regards,
cya ;)

ratatatatatata

ok, search more inside this file, look at this:
[GAME_DB_CONN_INFO]
SERVER=(local)
DB=Game
ID=sa
PW=123456

You remember something? yes, the same configuration, sql ip or local, gamedb name, sql id for the sqluser to access and the password.
(Note: if you want to put playable to anyone, search in this file for PUBLIC_IP_01=127.0.0.1 and PUBLIC_IP_02=127.0.0.1 "logically change the IP 127.0.0.1 for your external IP ;)")

Save file, go back in folder and open LoginServer, then open LoginServer.ini and search for the next info:
[ACCOUNT_DB_CONN_INFO]
SERVER=(local)
DB=account
ID=sa
PW=aass

Ough! I remember something about this! but take attention to ONE thing, the "DB" is another, in this case, is the account db name. The rest of this sqlconfig like the other config files, server,id and pass....

Ok, the main files are ok, turn to SQL Management, open it!

and go to DB Account or what ever you named it , right click to TBL_SELECTGATEIPS, edit first 200 rows..

once here, if you only want to test leave the IP to 127.0.0.1, if no put to your WAN IP or commonly named internet IP.

Example of the content of the table:
ServerName / IP / Port / ServiceName (DONT TOUCH)
GSP
127.0.0.1        7100        MIR3

Go to Table TBL_PUBIPS in the same DB and open to edit in the same way.

check if are the IP 127.0.0.1, leave at that if your server are all local files, if your loginserver are located in another machine put here the IP.

OK, once finished go to your Game DB our what ever you named it, expand, and search for table TBL_ServerGate, once here, edit in the same way.

Here you can put your local IP 127.0.0.1 or our external IP to put online, this is for eiserver knows external IP for rungate.

table show like this:
1
127.0.0.1        7201
1        127.0.0.1        7202

And i think configuration are finished (if i dont miss some info due memory lags xD)

Note: for initial tests, to discard another fails i suggest to put all to 127.0.0.1 and test in the same computer.

Works in Windows 7 and upper fine. The Client have some problems in win10 due gfx drivers or some protection programs like firewalls, etc


Client:

In client remember to patch them and put the IP, server name and port in the ini file client have.



The opening of the server,

I suggest to open in this order, but you can use what you want only check all are conected properly.

1 LoginServer / 2 DBServer / gate Login / SelChr Gate (gate30) / eiserver / rungate1....rungate2....

Note: I dont use the fake billing server but if you want to open you are free to use and start first, and you prevent to the dbserver telling again and again billingate blah blah....