Microsoft SQL Server 2008 R2 Express Edition with Management Studio
Hamachi (Or if you've done this kind of thing before, you can use anything you like)
Server files (TalesRuner.rar)
Game files
OPTIONAL:
I've dug out a small part of the installation process. http://forum.ragezone.com/f111/tales...ml#post6870429 Btw it's in the attachment if you don't know.
Okay there are no other questions other than anything related about installing the database and the programs not showing up. I want better questions to roam around, so I'm going to just put down HOW TO INSTALL SQL SERVER
Go to this webpage, http://www.microsoft.com/en-us/downl....aspx?id=30438, and download
SQLEXPR_x86_ENU.exe and SQLManagementStudio_x86_ENU.exe.
In the installation, you should see a page like this
Set the named instance to anything memorizable and click next.
After that, click on Collation and make the Database Engine say
Under "Customize" it should look like this.
Then click next.
In the next page, check mixed mode and enter a password
And if you want to be sure, you can click "Add current user" too. (Windows authentication is quite nice to use because you don't have to connect to your db while entering a password :'D
Okay now just finish up the installation and you're done with the SQL Server.
Now install SQLManagementStudio_x86_ENU.exe. It's just the management studio so you don't have to do any configurations. Just install it. And then continue to the next step
Continuing, after the installation, run SQL Server Management Studio and connect to it. You can use Windows Authentication or SQL Server Authentication both is fine.
After connecting, it should show something like this in the left tab http://puu.sh/42L9j.png
Right click databases and click new database and follow the mini guide I gave you earlier. (In the 02 install db folder) Halfway during the mini guide, you'll notice another program is executed. Somewhere in the server files there will be a file named db_install_korea_2012_02_02.exe. Execute it and it will open up the program. Follow the guide again and it will install the database for you. When it's done it should have a small window saying "Package executed successfully" or something close to that(I think it auto closes. dunno.). If it didn't then you probably did the installation/db creation wrong
After that, you will now have to edit some tables.
In the SQL Server Management Studio program, open up the "Databases" tab, open up the database you included, and then open up "Tables". There will be a lot of tables showing up but don't fret. It's quite easy to find because it's listed in alphabetical form. The tables to change are (adding dbo if you find that I don't make sense) And if you don't know how to change the tables, right click the table and click "Edit top 200 rows".
dbo.tblCM_ServerListAgentSvr
dbo.tblCM_ServerListSessionSvr
dbo.tblServerListAgentSvr
dbo.tblServerListRoomSvr
Put your Hamachi IP address on all the tables that originally had IP addresses in them but
READ THIS FIRST
In dbo.tblServerListRoomSvr the ports all must be 9152. Take note there's a sneaky one that's 9153
In dbo.tblServerListAgentSvr do not, I repeat, do not change the fdBillingServerIPs unless you know what are you doing.
EDIT: Forgot to put this.
Execute this query:
Code:
USE [database] GO /****** Object: StoredProcedure [dbo].[usp_startRoomServer] Script Date: 03/03/2012 21:40:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /***************************************************************************** Name: Desc: Return-values: Parameters: Input ---------------------------- Output ---------------------------- Auth: Date: Version: ****************************************************************************** Change History ****************************************************************************** Date: 2011.11.23 ---------------------------- Author: Kim SangUk ---------------------------- Description: 룸 서버가 켜질때 유저의 팜 리스트 정보의 룸 서버 번호와, 룸 핸들 값을 초기화 한다 ---------------------------- ****************************************************************************** Date: 2012.01.31 ---------------------------- Author: Kim SangUk ---------------------------- Description: 각 서버별 팜 캐시 최대치 추가 ---------------------------- ******************************************************************************/ ALTER PROCEDURE [dbo].[usp_startRoomServer] @ip varchar(20), @port int AS SET NOCOUNT ON EXEC dbo.usp_LogTranCount @@procid declare @ROOmservernum int; declare @farmCacheMax int; declare @limitroomCount int; select @ROOmservernum = fdNum, @farmCacheMax = fdFarmCacheMax, @limitroomCount = fdLimitRoomCount from tblServerListRoomSvr with (nolock) where fdServerIP = @ip and fdServerPort = @port; update tblServerListRoomSvr set fdStartServerDateTime = getdate() where fdServerIP = @ip and fdServerPort = @port; update tblUserFarmList set fdRoomServerNum = 0, fdRoomHandle = 0, fdCacheRoomServerNum = 0 where fdRoomServerNum = @ROOmservernum if @ROOmservernum is null begin raiserror('cannot find proper server', 16, 1); return; end else select servernum = @ROOmservernum, farmCacheMax = @farmCacheMax, limitRoomCount = @limitroomCount, dbtime = getdate();
When you're done, there should be no errors.
Continuing, search "Set up ODBC data sources" in Windows and add select SQL Server. Put any name, description is optional, for most cases ODBC won't detect your server name so just go into SQL Server Management Studio and copy it into Server Name.
After that, it'll ask you about log in info select http://puu.sh/42MeY.png (dunno about the other) and for anyone using another language, it's the second option. Put in the login ID as "sa" and the password as whatever password you used when you installed the server. After that, check "Change the default database to" and change it to the Tales Runner database. Then just click next on the rest of the stuff and if you want to be sure, you can click "Test data source". It'll say it's successful if it is.
Now that you're done with ODBC, time to go to the server files.
You will want to extract the following from TalesRunner.zip:
Contents of 2012-02-26_1_korea.zip in the folder "ServerFiles"
"CheckProcess.exe" of TRServerController.zip in the folder "Editores"
When you're done, delete dbsetting.ini and run AgentServer.exe
It'll say it can't find dbsetting.ini and after you press "OK" it'll show a tiny form.
In connection name, put in your ODBC name into it.
In ID, put in "sa"
In password put in your sql password
Once you're done we will now proceed to editing the setting files.
In the Agentserver's setting.ini, change every IP to your Hamachi IP and change "none" from Loadbalanceip to your Hamachi IP also.
Change the IP inside the setting.ini file of communitysessionserver and roomserver to your Hamachi IP too.
After that, you're done.
Now starting the programs.
Open up checkprocess.exe first. And then the rest.
If one of the programs is not showing, you did something wrong and you have to close it with your task manager.
Click "refresh" in checkprocess.exe. If everything goes okay, it will show a green color on all places. If something's wrong it will show a red color on a box. Ignore the bottom text box. It's not important.
When everything goes okay, check these 3 things in agentserver.exe http://puu.sh/42NhQ.png
And then make a .BAT file with this (you need to edit it a bit)
Code:
"(Location of trgame.exe)" -elevated:t -userid:(User ID) -userpass:(Password) -p:1 -pp:talesrunner/patch/ -ps:(IP) -zone:(IP):9500 -zoneID:1 -zoneName:USA -- gpotato
After that run it as an administrator and it should work.
Bug fixes
1. Execute MSDTC.
2. Delete 54 servers from both of the tables (tblServerListRoomSvr and tblServerListAgentSvr)
3. http://forum.ragezone.com/f814/usp_logout-fix-957762/
Execute the query.