- Joined
- Aug 23, 2010
- Messages
- 1,544
- Reaction score
- 423
Hello, i found a game from another web. I want to share with Ragezoners ^^
Not Tested!!!
AccountDB Fixed (can use the included tables in gamedb backup, this is for someone need to put separated):
NEW link：
forever
Information and Tutorial
Not Tested!!!
AccountDB Fixed (can use the included tables in gamedb backup, this is for someone need to put separated):
You must be registered to see links
NEW link：
You must be registered to see links
password：his0 forever
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
Information and Tutorial
Code:
SQL:
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...
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:
0 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....
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.
[IMG]https://s32.postimg.org/hz7g82qut/3danalyze.jpg[/IMG]
- Download Link http://www.mediafire.com/download/l1q87t6p86p0w7q/3D+Analyze.rar
I Hope this fixes the problem.
If no another fix can work on some win10 due to dx and driver changes is to change the game.exe compatibility tab under file properties, put to win7 and run as admin.
Update (Works on a lot of win10 computers):
- Win10 trick, go to system admin, graphic device, right click and uninstall, do not install anything, go to Mir and then runs fine now. If no you can try to Press O in game to disable combat text for better performance. Once restarted computer you have the driver put again automatically. To play again simpli redo this trick. (I hope this fix your 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.
Npc:
We confirm mayor part of npc commands from old holley 3.38 works fine, some need to change some [] for "" and other things..
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!
