Talesrunner - Whole server creation guide.

You will need:
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();
Change the word "database" to the name of your database. Right click and click execute.
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
Dunno if you can leave -ps blank. Anyway, do not change the port in -zone.
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.

Files + Tools ...ETC


Server Files:https://mega.co.nz/#!fNJgkTSL!OC6Kx1...ZxoYpq_sHibRUo

English Version (For unpacking): http://patch.talesrunner.winnerhub.c...08_v1457_1.exe 


Unpacker : https://mega.co.nz/#!eRIQAZBA!CkXuBG...fs6UvbC4F2Vuww
To run the unpacker, open up the PROGENV file and press the second button. Now when you cilck on PKG files they will extract into a folder inside of your pkg folder. 

How to unpack newer PKG Files with the old unpacker: http://www.youtube.com/watch?v=pTP6W...ature=youtu.be

HTML Launcherhttp://forum.ragezone.com/f813/tales...uncher-956777/
Notes: This is basically a way to launch trgame.exe through a website. It's very simple, don't expect too much.

How to fix the Invalid Hash Errorhttp://forum.ragezone.com/f814/fully...65/index4.html 
Notes: This fixes an error most people have with their loadbalance server not detecting the hashes put into hash.ini. This has been a critical error for a very long time and it's one of the most helpful tips ever given in the TR section. Proven working on 2 servers.

Notes: You do not need a packer to put an unpacker to use, I`ve put a tutorial on how this works on youtube which you can find on this thread. PNGs are also incorrectly named, they are DDS files, not png. 

Video tutorial on how to open them: 





How to change the color: http://forum.ragezone.com/f814/chang...-color-954218/ 
TR Python Tools: To be posted soon (Credit OPTeam for sending)
Game Patch Archive: http://116.122.38.84/Talesrunner/
Simple TR Launcher: http://forum.ragezone.com/f813/c-sou...uncher-936808/ 
Notes: This is quite simple, has a login button, link to a page, etc. VB source. Tutorial on how to use it is in the thread.

Advanced TR Launcher: http://forum.ragezone.com/f813/vb-so...auncher-949945 
Notes: This has configurable settings that includes but is not limited too changing startup quality and starting in windows mode. VB 2012 Ultimate source.

Simple TR Website (Top 10 rank code):http://forum.ragezone.com/f814/basic...nection-959124
Notes: Written with PHP and works for MSSQL
DB and SQL Setup Guide (posted by phprap): http://forum.ragezone.com/attachment...r-db-guide.rar
Item IDs: http://forum.ragezone.com/f813/tales...umbers-953913/ 
How to add maps: http://forum.ragezone.com/f814/add-m...1/#post7759939

Other Guides or releases :
Modify TR Files (hex editing the client): http://forum.ragezone.com/f814/apply...d-files-936111 
GM Manager: http://forum.ragezone.com/f813/share...on-1-a-954500/
How to change and add hash:
How to gift people: http://forum.ragezone.com/f814/gift-...7/#post7748606 
How to make GM accounts: http://forum.ragezone.com/f814/make-...0/#post7757252 
How to change starting money and disable unlimited GP: http://forum.ragezone.com/f814/chang...ted-gp-937455/ 
How to edit TR/EXP rate: http://forum.ragezone.com/f814/chang...2/#post7748627 
How to change capsules: http://www.youtube.com/watch?v=UEtfg...ature=youtu.be 
Bypass X-trap DLL: https://mega.co.nz/#!yU8hAQCa!5UlMkg...RiRka7Ut0luCQA
How to fix rankings: http://forum.ragezone.com/f813/fixed...im3584-945586/ 
How to fix friends: http://www.youtube.com/watch?v=qnnCBzwxoUY 





Talesrunner Package Files Unpacker



Download Talesrunner Package Unpacker !