[DOWNLOAD] Client and Server - Page 2 - RaGEZONE

itadakimasu · 10-22-2008

Thanks Rhinehart, I hope someone would find a way to translate the cTO to English.. Or work someone would continue working on the server files (since they're obviously incomplete [no exp rate change, drilling, etc.]).

silversade · 10-25-2008

A simple yes or no question? Can this be used with microsoft sql server 2008, or only 2000?

PS: Thanks for this awsome trickster server because this is the only decent one ive seen in a while :D Good Job

-Silver-

Rhinehart · 10-25-2008

I dunno, I just provided the permanant mirror, really. We'll have to see if someone tries it, then posts their answer.

Weinberger · 11-25-2008

Is there any n00b, step-by-step guide for this?

I'm really unexperienced and all instructions seem like commands to me
Extract! Create! Delete!

and I don't even know how to... xD

For example:
How do I create a log directory? I don't even know what that is haha, I'ma Google it ._.
Even if I create it, what do I do with all this??:

C:\log
C:\Trickster
C:\Trickster\FirstLoginServer ## rar name: first.rar
C:\Trickster\GameServer ## rar name: gameservero.rar
C:\Trickster\LoginServer ## rar name: login.rar
C:\Trickster\MasterServer ## rar name: db.rar

It seems just like words to me (run, move, sit, jump; but don't tell you how, where, what to, etc...)

I just can't understand what to do, I need more explanation to do it

Please help me, I really want to try this out.

vazabisong · 02-15-2009

link not work.
please up new link.

Rhinehart · 02-15-2009

Originally Posted by vazabisong

link not work.
please up new link.

My mirror still works. Just read the last post on page 1. Or click here if you're too lazy to do that.

maokoung1 · 02-24-2009

Thank you So much ^^

cappu · 03-26-2009

Oh it's good game for me:]
thank you

platipus · 04-11-2009

can we not change our computer name or is it totally required...
by the way I think you're doing great with this and hopefully it functions atleast.

Has anyone actually got it to work besides the thread starter?

tinkle · 04-26-2009

Darkco Darko or something like that.... got a server up and running one time... I play tested on it... .lol it felt like it was only me + him ... but alas there's like 0 servers these days... It'd be nice if a skilled server host would pick these up... chinese or not I would be a player ^^;;

tinkle · 04-26-2009

OK :)

Made it to login but can't seem to go past that... Maybe I edited the exe wrong
Not sure... but since most haven't made it this far I guess this is as far as I'll get today...

Because I see this being bombed with "OMG!!!!!! How did you get past FirstLoginServerW.exe ?!?!?!?!?!?!?!" Question's I'll go ahead and tell you

[ODBC]
DRIVER=SQL Server
UID=fls_login
PWD=eoqkrajrwk0813
DATABASE=gmg_account
WSID=TR_ACCOUNTDB
APP=Microsoft Open Database Connectivity
SERVER=192.168.1.26 <- No "IMPORTANT!!!! 1433" statement given in the guide...

Also I set in the database in gmg_account param_serv or w/e the Major and Minor ip's to be 192.168.1.26

I tried countless times to use my "WAN IP" but for some reason it would never work.

Good luck everyone let's get those trickster servers up! :)

tinkle · 04-30-2009

-- TM LEVEL ??
CREATE procedure uspt_char_status_update_tm_level
@char_uid int
, @tm_level_p smallint
, @tm_level_m smallint
, @tm_level_s smallint
, @tm_level_c smallint
as
set nocount on
set lock_timeout 10000

declare @error_pl int
, @error_ml int
, @error_sl int
, @error_cl int
declare @error_pe int
, @error_me int
, @error_se int
, @error_ce int
, @error int

set @error_pl = 0
set @error_ml = 0
set @error_sl = 0
set @error_cl = 0
set @error_pe = 0
set @error_me = 0
set @error_se = 0
set @error_ce = 0
set @error = 0

begin tran -------------------------->

if (@tm_level_p > -1)
begin
update char_status
set tm_level_p = @tm_level_p
where uid = @char_uid

set @error_pl = @@error

update char_state
set tm_exp_p = 0
where uid = @char_uid

set @error_pe = @@error
end
----------------------------------
if (@tm_level_m > -1)
begin
update char_status
set tm_level_m = @tm_level_m
where uid = @char_uid

set @error_ml = @@error

update char_state
set tm_exp_m = 0
where uid = @char_uid

set @error_me = @@error
end
----------------------------------
if (@tm_level_s > -1)
begin
update char_status
set tm_level_s = @tm_level_s
where uid = @char_uid

set @error_sl = @@error

update char_state
set tm_exp_s = 0
where uid = @char_uid

set @error_se = @@error
end
----------------------------------
if (@tm_level_c > -1)
begin
update char_status
set tm_level_c = @tm_level_c
where uid = @char_uid

set @error_cl = @@error

update char_state
set tm_exp_c = 0
where uid = @char_uid

set @error_ce = @@error
end
----------------------------------

set @error = @error_pl + @error_pe
+ @error_ml + @error_me
+ @error_sl + @error_se
+ @error_cl + @error_ce

if (@error = 0)
begin
commit tran
return 0
end
else
begin
if (@@trancount > 0)
rollback tran
return @error
end

GO

- ??? LEVEL ??
CREATE PROCEDURE uspt_char_status_update_char_level
@char_uid int
, @new_level smallint
as
set nocount on
set lock_timeout 10000

declare @error int
set @error = 0

BEGIN TRAN ----------------------------->

update char_status
set ap_pts = (@new_level-1) * C.pts_p,
ac_pts = (@new_level-1) * C.pts_p,
dx_pts = (@new_level-1) * C.pts_p,
max_mp_pts = (@new_level-1) * C.pts_m,
ma_pts = (@new_level-1) * C.pts_m,
md_pts = (@new_level-1) * C.pts_m,
max_wt_pts = (@new_level-1) * C.pts_s,
da_pts = (@new_level-1) * C.pts_s,
lk_pts = (@new_level-1) * C.pts_s,
max_hp_pts = (@new_level-1) * C.pts_c,
dp_pts = (@new_level-1) * C.pts_c,
hv_pts = (@new_level-1) * C.pts_c,
attr_pts = (@new_level-1) * 4,
[level] = @new_level
from char_status as CS
inner join char_attr as C on C.uid = CS.uid
where CS.uid = @char_uid

if (@@error = 0 and @@rowcount = 1)
begin
update char_state
set [exp] = 0
where uid = @char_uid

if (@@error <> 0 or @@rowcount = 0)
set @error = 1003
end
else
set @error = 1004

if (@error = 0)
set @error = dbo.fn_GetCharStatusCheck (@char_uid)

if (@error = 0)
begin
commit tran
return 0
end
else
begin
if (@@trancount > 0)
rollback tran
return @error
end

GO

These is commands darkco mentioned earlier as his thoughts for the "EXP/TM" rate...
I don't know much about Stored Procedures.... I never even looked at them really till I started fooling with this server... I have the backup's fully decrypted save one SP ... Which I don't know WHY it won't decrypt but I think it has to do with 'permission' to that command.

Now i'm curious about the GM Commands I saw a post earlier asking about them... I'll try to update this post however with what I find....

And would someone mind posting ONE thing to this thread so that I know it's being read? I mean I see the views go up... but no one says anything! I don't care what language you use.... Google does most translations half-assed so I can get the 'gist' of what you're saying!

Thanks for reading though!!
:)

Also I need to do further studies and see if I can make this to go across the net... Right now I just have it set up 'locally'... I'd also appreciate an experienced admins... so as to perhaps guide me in setting up a mini-web page... I'm unsure about the whole net sharing though... I'm really sure that ADSL (3 mbps down / 256kb Up) is REALLY insufficient for a host... But my line of works get's me access to Free PC's/Laptops so I could have the spare HW to host :c ...

Kind regards
Tinkle

shutterzv2 · 05-01-2009

hello guys...maybe im not good in making private server...but i notice some private server change only the patch and the connection and connect to their own server...maybe i can help^_^VV

TheLaughingMan · 05-01-2009

Found this in libconfig.dat near the end of the file. I was never able to use any of them though..

Code:

<ROW>
			<Name><![CDATA[Help_Speed]]></Name>
			<String><![CDATA[/speed [speed值]:GM人物移动速度，范围1-4]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_TeleportSelfToChr]]></Name>
			<String><![CDATA[/tel[人物ID:GM人物向该人物移动]]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_TeleportChrToChr]]></Name>
			<String><![CDATA[/tel[人物1][人物2]人物1向人物2移动]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_TeleportSelfToZone]]></Name>
			<String><![CDATA[/tel 区域 区域ID:GM的人物向特定区域移动]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_TeleportChrToZone]]></Name>
			<String><![CDATA[/tel地区[人物id]区域ID:将特定的人物向此区域移动]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_Immortal]]></Name>
			<String><![CDATA[/警告on/off/on/open：GM人物将警告状态开之后关掉]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_Invisible]]></Name>
			<String><![CDATA[/透明on/off/on/open:将GMcharacter透明状态开后关]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_Notice]]></Name>
			<String><![CDATA[/通知[score次数]通知内容:通知全体]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_KickNoNotice]]></Name>
			<String><![CDATA[/kick[人物ID]:无理由直接KICK]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_KickWithNotice]]></Name>
			<String><![CDATA[/kick[人物ID]KICK理由:将原因告知玩家5秒钟后将其踢下线]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockChr]]></Name>
			<String><![CDATA[/block[人物ID][Block天数]Block原因:将原因留置玩家留言板]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockChat]]></Name>
			<String><![CDATA[/禁止聊天[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockMove]]></Name>
			<String><![CDATA[/禁止移动[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockTrade]]></Name>
			<String><![CDATA[/禁止交易[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockChatList]]></Name>
			<String><![CDATA[/禁止聊天list:每个系统服务器''禁止实时聊天''看被禁止玩家list]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockMoveList]]></Name>
			<String><![CDATA[/禁止移动list:每个系统服务器''禁止实时移动''看被禁止玩家list]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_BlockTradeList]]></Name>
			<String><![CDATA[/禁止交易list:每个系统服务器'禁止实时交易'看被禁止玩家list]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_Memo]]></Name>
			<String><![CDATA[/留言 [人物ID] "内容(35字)" : 以运营者的名字传达到朋友留言]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_MoveNotice]]></Name>
			<String><![CDATA[/移动通知 "内容"]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>
		<ROW>
			<Name><![CDATA[Help_Color]]></Name>
			<String><![CDATA[/彩色 on/off/on/off : GM说话<->一般说话]]></String>
			<Type>0</Type>
			<Comment><![CDATA[ ]]></Comment>
		</ROW>

tinkle · 05-01-2009

Oi!!! Thanks a bunch dude! :)
I'll give 'em a try~

I'm not sure how the "GM Account" stuff works exactly

Cos they're all over the place and one area requires an IP... but i'm not sure as to which ones to edit and not so... I'll do some Crazy experimentation now that I got the commands... once again Thanks a bunch :)

Cleaned it up a little bit for readability

Credits to TheLaughingMan for posting them

Code:

			[Help Speed]
			[/speed [speed值]:GM人物移动速度，范围1-4]
		
			[Help TeleportSelfToChr]
			[/tel[人物ID:GM人物向该人物移动]
		
			[Help TeleportChrToChr]
			[/tel[人物1][人物2]
		
			[Help TeleportSelfToZone]
			[/tel 区域 区域ID:GM的人物向特定区域移动]
		
			[Help TeleportChrToZone]
			[/tel地区[人物id]区域ID:将特定的人物向此区域移动]
		
			[Help Immortal]
			[/警告on/off/on/open：GM人物将警告状态开之后关掉]
		
			[Help Invisible]
			[/透明on/off/on/open:将GMcharacter透明状态开后关]
		
			[Help Notice]
			[/通知[score次数]通知内容:通知全体]
		
			[Help KickNoNotice]
			[/kick[人物ID]:无理由直接KICK]
			
			[Help KickWithNotice]
			[/kick[人物ID]KICK理由:将原因告知玩家5秒钟后将其踢下线]
			
			[Help BlockChr]
			[/block[人物ID][Block天数]Block原因:将原因留置玩家留言板]
		
			[Help BlockChat]
			[/禁止聊天[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]
			
			[HelpBlockMove]]>
			[/禁止移动[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]
			
			[Help BlockTrade]
			[/禁止交易[人物ID][n分](day):0分(取消)-1(永久禁止:基本值15日)]
			
			[Help BlockChatList]
			[/禁止聊天list:每个系统服务器''禁止实时聊天''看被禁止玩家list]
			
			[Help BlockMoveList]
			[/禁止移动list:每个系统服务器''禁止实时移动''看被禁止玩家list]
			
			[Help BlockTradeList]
			[/禁止交易list:每个系统服务器'禁止实时交易'看被禁止玩家list]
		        
                        [Help Memo]
			[/留言 [人物ID] "内容(35字)" : 以运营者的名字传达到朋友留言]
			
			[Help MoveNotice]
			[/移动通知 "内容"]
			
			[Help Color]
			[/彩色 on/off/on/off : GM说话<->一般说话]

and the google engrish translation is as follows

Code:

[Help Speed]
[/ speed [speed value]: GM figures the speed, range 1-4]

[Help TeleportSelfToChr]
[/ Tel [Person ID: GM figures the figure for mobile]

[Help TeleportChrToChr]
[/ Tel [figure 1] [figure 2]

[Help TeleportSelfToZone]
[/ tel regional ID: GM characters to specific regional mobile]

[Help TeleportChrToZone]
[/ tel region [figure id] regional ID: figures specific to this area Mobile]

[Help Immortal]
[/ Warning on / off / on / open: GM characters will be switched off after warning the state to open]

[Help Invisible]
[/ Transparency on / off / on / open: the state will be open and transparent GMcharacter clearance]

[Help Notice]
[/ Notice [score the number of] notification: notify all]

[Help KickNoNotice]
[/ Kick [character ID]: no reason to direct KICK]

[Help KickWithNotice]
[/ kick [character ID] KICK reasons: the reasons for this player will be after 5 seconds to play offline]

[Help BlockChr]
[/ block [character ID] [Block number of days] Block reasons: the reasons for detention will be player message board]

[Help BlockChat]
[/ Prohibited chat [Person ID] [n points] (day): 0 points (cancel) -1 (a permanent ban on: the basic value of 15)]

[HelpBlockMove]]>
[/ Ban on mobile [Person ID] [n points] (day): 0 points (cancel) -1 (a permanent ban on: the basic value of 15)]

[Help BlockTrade]
[/ Prohibited transactions [Person ID] [n points] (day): 0 points (cancel) -1 (a permanent ban on: the basic value of 15)]

[Help BlockChatList]
[/ Prohibit the chat list: each system in real-time chat server''''to see the prohibition of banned player list]

[Help BlockMoveList]
[/ Prohibition of mobile list: for each server in real-time mobile''''to see the prohibition of banned player list]

[Help BlockTradeList]
[/ Prohibited transactions list: each system server 'prohibited transactions in real-time' to see players banned list]

                         [Help Memo]
[/ Message [Person ID] "content (35 words)": The name of the operator to convey messages to a friend]

[Help MoveNotice]
[/ Mobile notification "content"]

[Help Color]
[/ Color on / off / on / off: GM talk <-> general words]

However I'm guessing that the commands need to be done in chinese on some of them that were translated

TheLaughingMan · 05-01-2009

hehe let me know if you get one to work

prince9010 · 05-16-2009

where 2 download SQL Server 2000?

nolas · 07-13-2009

2009-07-13 23:32:57, 20053:Cannot connect to DB.[ParmDB(08001:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL ServerSQL Server does not exist or can not access.)]
2009-07-13 23:32:57, 20053:Cannot connect to DB.

help me... plz..

Andermat · 07-14-2009

Check your ODBC settings. I think that you didn't write correctly something there

pepsi05 · 07-18-2009

where do I find this part :
---------------------------------------------
edit ODBC

[Login&SystemServer]
System DSN
DatasourceName:trickster_system
Server:(SQL SERVER IP)
LoguinID:sa
Pass:(sa userpass)
defaultDB:Trickster

[MasterServer]
System DSN
DatasourceName:Trickster_master
Server:(SQL SERVER IP)
LoguinID:sa
Pass:(sa userpass)
defaultDB:Trickster

flamecross · 08-06-2009

I can't download please help.

Trickster ServFiles
MegaUpload
=============================
SQL Server 2000
Microsoft Link
=============================
Trickster Client
MegaUpload - Recommended

jotos190232 · 08-08-2009

Thank for server

bblagent · 08-10-2009

wow nice.i getting back again

aimishua · 08-13-2009

asdfasdfadsfasf

thestar111 · 08-13-2009

tank you