Printable View
Hello,
Guide TalesRunner Setup + DbFiles+Tools
Windows 8.1 Pro :P
the ip to all Tables is 127.0.0.1
Part 1:
http://www.youtube.com/watch?v=tB44u...ature=youtu.be
Part 2:
http://www.youtube.com/watch?v=J_9cwebhw7s&feature=youtu.be
Files Donwload Here!
Launcher For Tester
Enjoin!!!
Credits to PHPRap Db settings.
Credits Files to KillerStefan.
Client Credits To me :P
what's new? =) with DB ?Quote:
Server Files by kevin3584
Probably includes the rank fix he's implementedQuote:
Originally Posted by Nyamochka
kevin, I allow you to give me your server files and DB =DD
server contains a lot of bugs (I took your client) and run Korean client me do not feel like)))
I'm working on it ...
then upload a video and add Item to Database, and other settings.Quote:
Originally Posted by Nyamochka
Wow Thanks Kevin Teran
I hope in the future there will be guides on how to add new content to the client and the server. (and how to translate client)
I added everything from .txt on the client to the database, but apparently this is not the..
by the way how to add yourself GP points?
Help Plz
Ok i UnderStandQuote:
<SQLError Package="korea_2012_02_02"><Error>Cannot resolve the collation conflict between "Korean_Wansung_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.</Error><Assembly>korea_2012_02_02</Assembly><Package>Package1.resx</Package><Batch>Batch6674</Batch><SQL>
/*****************************************************************************
Name:
Desc:
Return-values:
Parameters:
Input
----------------------------
Output
----------------------------
Auth:
Date:
Version:
******************************************************************************
Change History
******************************************************************************
Date: 2009-10-13
----------------------------
Author: Jeon
----------------------------
Description:
----------------------------
컨텐츠 동작방식 설정정보(SettingContentsOption)를 기존 서버셋팅정보(tblServerSettingInfo)와
함께 로딩
******************************************************************************/
CREATE PROCEDURE [dbo].[usp_getServerSettingInfo] AS
SET NOCOUNT ON
EXEC dbo.usp_LogTranCount @@procid
-- 임시 테이블 생성
declare @resultTable table
(
seq int identity ( 1, 1) not null primary key,
fdKey varchar(50) collate database_default,
fdValue varchar(255) collate database_default,
fdOnlyServerSetting bit
)
declare @NowTime datetime;
-- 현재 시간을 얻는다.
set @NowTime = getdate();
-- tblServerSettingInfo테이블의 내용을 임시 테이블에 복사한다.
insert into @resultTable
select fdKey, fdValue, fdOnlyServerSetting
from tblServerSettingInfo
union
select fdKey, fdValue, fdOnlyServerSetting
from SettingContentsOption
-- 스케쥴러 테이블에서 임시테이블에 있는 동일한 키의 값을 임시테이블에 오버라이드 한다.
update @resultTable
set fdValue = t2.fdValue
from @resultTable as t1 left outer join
tblServerSettingScheduler as t2 on
t1.fdKey = t2.fdKey
where t2.fdValue is not null and
@NowTime >= t2.fdStartTime and
@NowTime <= t2.fdEndTime;
select KeyName = fdKey, Value = fdValue , OnlyServerSetting = fdOnlyServerSetting
from @resultTable;
</SQL></SQLError>
Sorry :D:
About time someone posted this. Thank you!
I think I'm having too much fun http://i830.photobucket.com/albums/z...ps4cd3070a.jpg
Wow New TalesRunner e.e
Nice...Quote:
Originally Posted by mcaso123
http://rghost.ru/48164727/image.pngguys, how to add content (maps, items, etc.) to the server ? =)
http://tau.rghost.ru/48164710/image.png
I've been given some insight on it.Quote:
Originally Posted by Nyamochka
It's done through the login codes in tr4, and database modification in AvatarDescATR stuff.
when buying the item, nothing happens = (Quote:
Originally Posted by mcaso123
tblavataritemdescattr
tblavataritemdesc
tblavataritemdesctrduciendo
etc.
all this I have tried to write into the database
Add the item ids in tblavataritemdesc with correct info.
Well what physically adds then to the game?Quote:
Originally Posted by Megaponder
http://rghost.ru/48166207/image.png
oh yeah!!! =D
Code:tblavataritemdesc
tblavataritemdescattr
tblavataritemdescex
tblavataritemsetattr
tblavataritemsetdesc
Mind if we swap contact info?Quote:
Originally Posted by Nyamochka
My Server TalesRunner
http://img38.imageshack.us/img38/7492/tso0.JPG
of course. I answered you in pmQuote:
Originally Posted by mcaso123
hey bro name FB? Nyamochka
It does but the game must have the files.Quote:
Originally Posted by mcaso123
Well, if you don't get what I mean, if the item's missing from either the db or the game files, it's not available and I was guessing that Nyamochka already had the game files
I used Aeon's version and bought something new. Error was something about the server.
Quote:
Originally Posted by Megaponder
yes and Nyamochka Using My TalesRunner CLient....
this is temporary =)Quote:
Originally Posted by Kevin Teran
Kevin Is work In Windows 7 ?Quote:
Originally Posted by Kevin Teran
Yes, it does.Quote:
Originally Posted by AngelLol
Yes. XP,Vista,Win Server 08, Win Server 12,Win 7 , Win 8, Win 8.1Quote:
Originally Posted by AngelLol
and i think all Windows Os
Can you help me what wrong with it
http://s11.postimg.org/4kzhczpo3/WTF.png
Go look at KillerStefan's tutorial. It's there somewhereQuote:
Originally Posted by apiwat13tung
Where ? Please can you send me a link?
Sql misconfigurationQuote:
Originally Posted by apiwat13tung
What's the password of sa user? i can't find it ><
And I've another problem, When I trying to launch AgentServer or RoomServer its opens but I can't see it but, I can see it in the Task Manager..
You set the sa password by yourself just like creating a new account and once you've configured the database and the setting.ini files it will show.Quote:
Originally Posted by Symbo
Where can i set the pass? Security>Logins>sa and then change her? if yea so i did it and its not saves it ><Quote:
Originally Posted by Megaponder
I'm changing and its back to the old one..
Yeah you can change the sa password from there.Quote:
Originally Posted by Symbo
I tried, but its always back for the old one..Quote:
Originally Posted by Megaponder
If you know which one is the old one, then use it.Quote:
Originally Posted by Symbo
If you don't know just make another server
This is the point, Its like the password automatically installed when i installed the sql..Quote:
Originally Posted by Megaponder
And what do you mean when you're saying make another server? Re-install the SQL and install the DB again?
Then you have to reinstall it.Quote:
Originally Posted by Symbo
And yes, reinstall the SQL and install the DB again but you don't need to reinstall the management thing.
Refer to my guide for help
http://forum.ragezone.com/f814/whole...-guide-952430/
Is there something in the sql server installer that puts this password? I don't want to stuck on this little thing again ><Quote:
Originally Posted by Megaponder
EDIT: nvm found it in your guide, Thanks, I'll update you! :3
@Symbo:
http://i1257.photobucket.com/albums/...Untitled-1.png
aLso: there is onLy 1 explanation on why agentserver and roomserver do not show up, its because the ip you have in either
1. agentserver's, roomserver's settings.ini
or
2. sqL dbi.tblCM_ServerListAgentSvr tabLe
are not the same
http://puu.sh/4auza.png
this is what fucking megaponder does on my serv
Omg I want dis ><Quote:
Originally Posted by mcaso123
Quote:
Originally Posted by mcaso123
Easyyy.....
Teach me master!Quote:
Originally Posted by Kevin Teran
You just wasted a post to say something that was obviously easy is easyQuote:
Originally Posted by Kevin Teran
Help me please im stuck at 68% when im using db_install_korean
Kevin i need your help...
i opened the server but i need now open ports and i open but only who in my rauter can open the server...
and i want all ppls can open my server..
what to do? :S
my tv if u can help please sended private messege.
Use Hamachi/no-ip or a VPSQuote:
Originally Posted by Gil Sameah
Any errors? If so take a picture. If not it's probably glitchedQuote:
Originally Posted by apiwat13tung
Quote:
Originally Posted by Megaponder
ppls hate hamachi :S
but i want to do no-ip can u just give me guide ?
There's no guide. You have to ask someone that is experienced with no-ipQuote:
Originally Posted by Gil Sameah
http://up387.siz.co.il/up2/iet3wyqn2oj3.pngQuote:
Originally Posted by Megaponder
If you've got it configured you just need to execute an sql script and put your IP in the tablesQuote:
Originally Posted by Gil Sameah
Can you help me ? i got this problem :(
http://s11.postimg.org/4kzhczpo3/WTF.png[/QUOTE]
Quote:
Originally Posted by Gil Sameah
to hide your IP? if for fucione you through a router you need to open the ports to the Local IP where your server Example: 192.168.1.101
Thanx, but i need take my ip from "whatismyip.com"?Quote:
Originally Posted by Kevin Teran
and can u help me to do it please? i'll give u credit if u want..
my skype " belong15 "
tbh sometimes I think you're retarded.Quote:
Originally Posted by Gil Sameah
There's guides.
i dont have any Projects :/
And we should care why?Quote:
Originally Posted by Karim Mostafa
Also be wary this person has been ripping other servers for his files, including phoenix (stealing stolen files, what a shame), so don't help him out unless you want him to steal your shit in the process.
Iam Only test it (work or no) and phoenix have many bugs in maps and items. and if u Dont need help me, ok as u likeQuote:
Originally Posted by mcaso123
No shit, because you ripped files but not the DB. It's not phoenix thats bugged, its your idiocy.Quote:
Originally Posted by Karim Mostafa
iam playing phoenix. phoenix Have many bugs in map Like ( all Co-op and new maps he download it) and chat is bugQuote:
Originally Posted by mcaso123
You have to download all new maps you stupid idiot....Quote:
Originally Posted by Karim Mostafa
Just got back from probation and still being rude? Guess the trolls will keep on trolling. :lol:Quote:
Originally Posted by mcaso123
I wouldn't recommend using Phoenix files anyway .Why not just start fresh!?
It's not trolling when you're stating the obvious.Quote:
Originally Posted by Coolkidbloo
I've been back for over 3 weeks, and was gone for one, where have you been?
could u plz send me the link of the my sql and what is the steps before this videos . eg what did u do exactly in mysql and what u downloaded plz fast reply
Its called google or megaponders thread.Quote:
Originally Posted by moktar22
Pretty fucking easy.
Download Microsoft® SQL Server® 2012 Evaluation from Official Microsoft Download CenterQuote:
Originally Posted by moktar22
Make sure you also install management studio.Quote:
Originally Posted by Kevin Teran
"network-related or instance-specific error occurred while establishing a connection to sql server . the server was no found or was not accessible" how to solve this prop
copying and pasting that sentence on a release thread is not how you fix it thats for sure.Quote:
Originally Posted by moktar22
with what faggotQuote:
Originally Posted by tee697
How to edit ???????
agentserver and roomserver not run.
I successful to open communityagentserver, communitysessionserver, loadbalanceserver, relayserver, but it get some error of roomserver,
the error log is:
2013/09/15 14:36:34 - usp_startRoomServer error : [Microsoft][ODBC SQL Server Driver][SQL Server]cannot find proper server
2013/09/15 14:36:34 - !!!!!! Can't get room servernum
Also, I can use agentserver.exe, I open and It haven't display the interface but it show the process in the task manager,
I have set the ODBC before, what's wrong for me?
I think kevin forgot a part inside his tutorial.Quote:
Originally Posted by ctyjason
Run this query (change database with whatever your database's name is)(Run this in SQL Server Management Studio. Connect to your DB and click "New query")
For the agentserver part, you need to configure your IP addresses properly.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();
share file database .MDF of you,please!i will convert db SQL server to MySQL,use MySQL more than easy
You can also use Navicat, which is also very easy if you prefer not to use MSSQL, but you would have to set it up there first.Quote:
Originally Posted by lorent
I actually kind of prefer to use Navicat, I've just used it before in the past and it loads alot faster, but If I do any big edits its usually through the managment studio.
Attachment 138852
I convert it complete ^^
Keep in mind you have to press "commit to database" to apply any changes when you're using navicat.Quote:
Originally Posted by lorent
^^ Can you share me your client is work with server?I've run the server (not bug such as video guide), but my client error can not connect to server!thank you :)Quote:
Originally Posted by mcaso123
How To Open DDS File ?
Also look on my thread for that.Quote:
Originally Posted by Momo Stranger
Basically just use irfanview with all plugins installed.
macaso123,How to remove x-trap?thank you!
So far I have no xtrap bypass, there's some settings about it in serversettinginfo table but I haven't cared enough to screw with it. If you get an xtrap error when starting, make sure you run it as administrator
Sent from my iPhone using Tapatalk - now Free
I don't have a client for this, mind linking me(for give me if this was explained else were, i tend to make stupid mistakes sometimes.)
@Buni and @lorent Clients included within the torrent I posted on the files+tools thread.Quote:
Originally Posted by TalesRunnerBuni
Your signature is kinda fitting for this instance XDQuote:
Originally Posted by mcaso123
Ty.
I put it when someone saked me for haru and veras db config when there is no public db config for them yet, and then I realized it'd be a great signature :PQuote:
Originally Posted by TalesRunnerBuni
link dowload work with server ^^
I can't buy item in shop and kevin3584 too ~~
I don't recommenced downloading kevins files... even though he uses them fine there's many people who keep getting alot of errors from it, just use the original source (which I have in mega)Quote:
Originally Posted by lorent
Also if you use those files, they're edited
The torrent is kinda dead :<
stuck at 60%
Ill turn on my seeding as soon as I get home, make sure to lower yout seeding rate to increase the dl rateQuote:
Originally Posted by TalesRunnerBuni
Quote:
Originally Posted by mcaso123
Thank you much. Does it matter what client i use? says the english one is "for unpacking"
TBH I know next to nothing about Pserver stuff. The only experience i have with a pserver was playing with flyff server files back in i think vsersion 11? So I have literally no idea what i'm doing...
Yes, it does matter what client you use.Quote:
Originally Posted by TalesRunnerBuni
The client works like this.
In its hex, it defines file location (ex: tr4/script/stringtable.txt) of alot of things that are necessary.
These include maps, item lists, startup commands, charecter stats, and of course a different hash.
Unless you have those source edit files if you're using an edited client, you wont be able to use it. But using a different client/files with a different DB basically causes alot of un-needed problems.
So i would just use the client from the tor and then the serverfiles from this: Server Files: (credit KillerStefan, Amit Asaf): https://mega.co.nz/#!fNJgkTSL!OC6Kx1...ZxoYpq_sHibRUoQuote:
Originally Posted by mcaso123
I'll probably have this question answered by the videos so forgive me, Will i need to use programs like Navicat/MySql?
Also, thank you for helping with all of this. It is in my eyes a great service and a very admirable idea to help capture and provide these files to preserve video game history.
I fee like videogames are an artwork that gets used and tossed away, with no mind to keep its past works alive, like we do with music, books, paintings, ect. So to me seeing people work for tireless hours to no only get these things working but provide help for others...
Console Emulator makers, PServer makers, You have a lot of my highest respect. -is hopelessly artsy-
Could someone post the DB.bak, I am not able to use this "db_install_korea_2012_02_02"
Yes, thats how it works.Quote:
Originally Posted by TalesRunnerBuni
You can use Navicat/MySQL but you would have to set it up in MSSQL and then use SQL Connection in Navicat Premium.
Its no problem, I'm really here to help. If you want to have my skype is mcaso123, I'm on most of the time and I'm willing to answer questions as long as someone isn't rude.
I believe that help should be public to anyone, because people have been anticipating to make servers of this game for quite a while, and now that the files and tutorials are out, people have a chance. But with all the bugs and glitches stopping people, its a real set back. I would hate to be waiting a couple of days just to fix one error.
Different versions and the way they work need to be documented so we know just to use what works and not try any edgy stuff, which helps save errors.
