[Release]Trickster

Alright, we got some forums up, thanks to bitblaster
 
I think you should focus on the RaGEZONE forums as it saves people having to go back and fourth for information.
 
Well, it's for people who want patchs, i'll put em on here and on those forums.
The patch wil be released tommarow due to lack on Internet i have..my ISP is being a butthole.
This will translate in-game messages.
2 New Npcs
3 new Items
 
Trickster server setting(renew)
Code:
Trickster server setting
----------------------


change your computer name:TR_ACCOUNTDB ## IMPORTANT!! ##

---------------------------------------------

Extract and Create Log directory 

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

---------------------------------------------

MS SQL Server2000 setup

setup option
securitymode:Windows & SQL Login
sa userpass:(DO NOT BLANK!!) ## IMPORTANT!! ##

---------------------------------------------

SQL server setting

create & recovery DB
gmg_account <- gmg_account(file)
Trickster <- trickster_bak(file)


edit sql server account ## IMPORTANT!! ##

Database -> gmg_account User:fls_login-> delete
security -> Login -> New Login User

Name:fls_login
Pass:eoqkrajrwk0813
authentication:SQL Server
defaultDB:gmg_account
DBaccess:gmg_account
DBrole:public & fls_role


edit table ## IMPORTANT!! ##
gmg_account -> tbl_parm_server
MajorIp&MinorIp(masterserver IP)

gmg_account - >tbl_area
area_name(Server name)

gmg_account -> tbl_world
world_name(World name)


add game account
gmg_account -> tbl_account

---------------------------------------------

edit gmg_account_fls.dsn&gmg_account_parm.dsn

[ODBC]
DRIVER=SQL Server
UID=fls_login
Network=DBMSSOCN
WSID=TO-SH1-01FLS01
APP=Microsoft Open Database Connectivity
SERVER=(SQL SERVER IP),1433(defaultport) ## IMPORTANT!! ##
PWD=eoqkrajrwk0813

---------------------------------------------
FirstLoginSvr.ini is empty. do not edit it ## IMPORTANT!! ##
---------------------------------------------
edit MasterServer.ini

ServerGroup = 0

UserServer = 1
CharServer = 1
ItemServer = 1

TableDSNName = Trickster_master
TableDSNUser = sa
TableDSNPassword = (sa userpass)

DB = tricksterdb:Trickster_master:sa:(sa userpass):dbname

UserDBName = tricksterdb
CharDBName = tricksterdb
ItemDBName = tricksterdb
WarehouseDBName = tricksterdb
QuestDBName = tricksterdb
NeoWarehouseDBName= tricksterdb
PurWarehouseDBName= tricksterdb
PaidItemDBName = tricksterdb
MyCampDBName = tricksterdb

UserCountDelay = 3000
MaxClient = 10
Port = 16646
LogLevel = 1
LogFile = c:\log\master.log

[world 0]
ID = lserver1:1111(ServerID:Pass)
ID = sserver1:1111(ServerID:Pass)
ID = gserver1:1111(ServerID:Pass)

ServerPart=1

zone 1 = gserver1 ;eZoneId_Square
zone 2 = gserver1 ;eZoneId_Relics,
zone 3 = gserver1 ;eZoneId_Beach,
.
.(zone 1-130 = gserver1)
.
zone 128 = gserver1 
zone 129 = gserver1 
zone 130 = gserver1 

---------------------------------------------
edit SystemServer.ini

MaxClient = 3500
Port = 13336(SystemServer default)
Encode = 1

MasterServerURL = (MasterServerIP)
MasterServerPort = 16646(MasterServer default)
MasterServerID = sserver1:1111(MasterServer.ini [world 0]Section)
.
.
.
ReportDSNName = trickster_system
ReportDSNUser = sa
ReportDSNPassword = (sa userpass)

---------------------------------------------
edit LoginServer.ini

MasterServer = MstSvr:(MasterServerIP):16646(defaultport)
SystemServerURLForClient = (SystemServerIP)
SystemServerURL = (SystemServerIP)
SystemServerPort = 13336(defaultport)

ServerWorld = world1(MasterServer.ini [world 0]Section)
ServerID = lserver1(MasterServer.ini [world 0]Section)

---------------------------------------------
edit GameServer.ini

GameServerUrl = (GameserverIP)
GameServerPort = 22006(defaultport)

MaxClient = 2000

MasterServerUrl = (MasterServerIP)
MasterServerPort = 16646

ID = gserver1(MasterServer.ini [world 0]Section)
Password = 1111(MasterServer.ini [world 0]Section)

---------------------------------------------
edit ODBC ## IMPORTANT!! ##

[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

---------------------------------------------
Execute

1st.FirstLoginSvrW.EXE
2nd.MasterServer.exe
3rd.SystemServer.exe
4th.LoginServer.exe
5th.GameServerRelease.exe
---------------------------------------------
edit client
0.8.2.66(China)
rename Trickster.bin->Trickster.EXE
open Trickster.EXE(hex editor)
search "61.152.107.140"
change to your FirstLoginServerIP## IMPORTANT!! ##

Game account(default)
ID:gm000,gm001,gm002-gm010
Pass:111111

Would you translate My Engrish? :s

hi, and thanks for guide for this game,
now, i follow this guide, and some problem are fixed,
but last link gameserverrelease.exe show error:

2006-08-14 20:32:29, MasterServer : 192.168.0.101 : 16646
2006-08-14 20:32:29, GameServer : 192.168.0.101:22006, 192.168.0.101:22006, Max client : 2000
2006-08-14 20:32:29, NetworkManager::oceanHandleError - Server starting...
2006-08-14 20:32:44, NetworkManager::oceanHandleError - Server ready
2006-08-14 20:32:44, m_Ocean Ready
2006-08-14 20:32:44, Connected to master server
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\maps01_9.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\maps02.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_dg02a.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_uw04.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_dg03c.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_dg01f.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_fd07c.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_dg03e.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_fd07a.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_sq00.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_fd07b.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_sq09.md3
2006-08-14 20:34:10, MapInfoMgr::LoadMap : data\map\map_sq09_13.md3
2006-08-14 20:34:12, ZoneManager::BuildWorld
2006-08-14 20:34:12, Zone::LoadMap : data\map\map_sq00.md3
2006-08-14 20:34:12, ZoneMapAttr::Init - zone 1,
 
is this your ip? 192.168.0.101

hi Darkco, its my local machine ip, i have a local network, think my server now run, not sure, because i dont to connect in my server, i downloaded this client 20041201_toclient050.zip, its post here, change de trickster.bin to trickster.exe, and use the HEx tool to change ip to 192.168.0.101, but dont connect :(, my server look as all pics in the page 2 ,

my logs:
Code:
[B]system_20060815_061611.log[/B]

2006-08-15 06:16:11  Log open
2006-08-15 06:16:18  ERROR  PROC - Server starting...
2006-08-15 06:16:18  ERROR  PROC - Server ready
2006-08-15 06:16:18  End Ready...

2006-08-15 06:16:18  Start  Server...
2006-08-15 06:16:18  ERROR  PROC - Server resume
2006-08-15 06:16:18  Success    Connect To   MasterServer...
2006-08-15 06:16:18  -------------------------------------------
2006-08-15 06:16:18    M [O]  L [-]  S_0 [-]  S_1 [-]  S_2 [-] 
2006-08-15 06:16:18  -------------------------------------------
2006-08-15 06:16:18  Trickster Master Server ver 0.65

2006-08-15 06:16:18  REPORT TABLE start...
2006-08-15 06:16:18  REPORT TABLE ready 
2006-08-15 06:16:18  DBAGENT Query - 1 : exec usp_select_cardbattle_rank20_wincount
2006-08-15 06:16:18  DBAGENT Query - 2 : exec usp_select_cardbattle_rank20_winpoint...

...2006-08-15 06:16:20  DBAGENT Result - 58
2006-08-15 06:16:20  DBAGENT Result - 59
2006-08-15 06:17:43  USER CONNECTED index - 0
2006-08-15 06:35:39  MASTERSERVER PROXY     ALREADY HAVE [BASIC] RANK   :-) 
2006-08-15 06:35:40  DBAGENT Query - 60 : exec usp_status_rankbytype 1,1,-1
2006-08-15 06:35:40  DBAGENT Query - 61 : exec usp_skill_rankbytype 1...

...2006-08-15 06:36:08  DBAGENT Query - 218 : exec usp_status_rankbytype 12,12,3
2006-08-15 06:36:08  DBAGENT Result - 218
2006-08-15 06:36:08  DBAGENT Query - 219 : exec usp_status_rankbytype 12,-1,-1
2006-08-15 06:36:08  DBAGENT Result - 219
2006-08-15 06:36:08     StatusRank::QueryByCount Done! I(156), Rem(13), Mod(0), Fst(1), Sec(-1)
2006-08-15 06:45:26  MASTERSERVER PROXY     ALREADY HAVE [BASIC] RANK   :-) 
2006-08-15 06:45:27  DBAGENT Query - 220 : exec usp_status_rankbytype 1,1,-1...

...2006-08-15 06:47:11  DBAGENT Query - 379 : exec usp_status_rankbytype 12,-1,-1
2006-08-15 06:47:12  DBAGENT Result - 379
2006-08-15 06:47:12     StatusRank::QueryByCount Done! I(156), Rem(13), Mod(0), Fst(1), Sec(-1)
2006-08-15 07:25:13  MASTERSERVER PROXY     ALREADY HAVE [BASIC] RANK   :-) 
2006-08-15 07:25:13  DBAGENT Query - 380 : exec usp_status_rankbytype 1,1,-1...

...2006-08-15 07:25:54  DBAGENT Query - 539 : exec usp_status_rankbytype 12,-1,-1
2006-08-15 07:25:54  DBAGENT Result - 539
2006-08-15 07:25:54     StatusRank::QueryByCount Done! I(156), Rem(13), Mod(0), Fst(1), Sec(-1)...


[B]master_20060815_061603.log[/B]

2006-08-15 06:16:05  Starting network device...
2006-08-15 06:16:05  Server starting...
2006-08-15 06:16:05  Server ready
2006-08-15 06:16:05  Server ready

2006-08-15 06:16:05  Trickster Master Server ver 0.66

2006-08-15 06:16:05  Server resume
2006-08-15 06:16:18  User connected: index: 0
2006-08-15 06:16:18  MCMD_SVR_LOGIN_ACK_OK: index: 0, id: sserver1, world:0, ip:192.168.0.101:13336, 192.168.0.101:13336
2006-08-15 06:16:20  SUPERVISOR   START BASIC RANK : Island: 0, Socket: 0
2006-08-15 06:16:20  SUPERVISOR   BASIC RANK  OK: Island: 0, Socket: 0
2006-08-15 06:17:42  User connected: index: 1
2006-08-15 06:17:42  MCMD_SVR_LOGIN_ACK_OK: index: 1, id: lserver1, world:0, ip:192.168.0.101:10006, 192.168.0.101:10006
2006-08-15 06:17:42  Refresh User Login State...
2006-08-15 06:17:50  cUserStore::RefreshUserLoginState(1):Done...
2006-08-15 06:20:19  User connected: index: 2
2006-08-15 06:21:27  MCMD_SVR_LOGIN_ACK_OK: index: 2, id: gserver1, world:0, ip:192.168.0.101:22006, 192.168.0.101:22006
2006-08-15 06:22:47  WSARecv() failed with error in ClientT 10054
2006-08-15 06:22:47  SUPERVISOR::HANDLE LOGOUT - GAME : IslandNum: 0, socketIdx: 2
2006-08-15 06:22:47  User disconnected: index: 2 - ID: gserver1
2006-08-15 06:31:21  User connected: index: 2
2006-08-15 06:31:57  MCMD_SVR_LOGIN_ACK_OK: index: 2, id: gserver1, world:0, ip:192.168.0.101:22006, 192.168.0.101:22006
2006-08-15 06:35:55  SUPERVISOR   START [MORE] RANK: Island: 0, Socket: 0
2006-08-15 06:36:03  SUPERVISOR   BASIC RANK  OK: Island: 0, Socket: 0
2006-08-15 06:36:09  SUPERVISOR   BASIC RANK  OK: Island: 0, Socket: 0
2006-08-15 06:36:09  SUPERVISOR   [MORE] RANK OK: Island: 0, Socket: 0
2006-08-15 06:36:31  WSARecv() failed with error in ClientT 10054
2006-08-15 06:36:31  SUPERVISOR::HANDLE LOGOUT - GAME : IslandNum: 0, socketIdx: 2
2006-08-15 06:36:31  User disconnected: index: 2 - ID: gserver1


[B]dl111_20060815061710.log[/B]

2006-08-15 06:17:10,  Loading configuration from file:
  C:\Trickster\loginserver\LoginServer.ini
2006-08-15 06:17:10,  Loaded

2006-08-15 06:17:10,  Starting network device...
2006-08-15 06:17:10,  Server starting...
2006-08-15 06:17:41,  Server ready
2006-08-15 06:17:41,  Started

2006-08-15 06:17:41,  Loging on Master Servers...
2006-08-15 06:17:50,  Logged on

2006-08-15 06:17:50,  Loging on System Server...
2006-08-15 06:17:50,  Logged on

2006-08-15 06:17:50,  Trickster Login Server ver 1.61

2006-08-15 06:17:50,  Server resume


[B]dg111_20060815072357.log[/B]

2006-08-15 07:23:57,  MasterServer : 192.168.0.101 : 16646
2006-08-15 07:23:57,  GameServer : 192.168.0.101:22006, 192.168.0.101:22006, Max client : 2000
2006-08-15 07:23:57,  NetworkManager::oceanHandleError - Server starting...
2006-08-15 07:23:57,  NetworkManager::oceanHandleError - Server ready
2006-08-15 07:23:57,  m_Ocean Ready
2006-08-15 07:23:57,  Connected to master server
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\maps01_9.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\maps02.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_dg02a.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_uw04.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_dg03c.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_dg01f.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_fd07c.md3
2006-08-15 07:25:09,  MapInfoMgr::LoadMap : data\map\map_dg03e.md3
2006-08-15 07:25:10,  MapInfoMgr::LoadMap : data\map\map_fd07a.md3
2006-08-15 07:25:10,  MapInfoMgr::LoadMap : data\map\map_sq00.md3
2006-08-15 07:25:10,  MapInfoMgr::LoadMap : data\map\map_fd07b.md3
2006-08-15 07:25:10,  MapInfoMgr::LoadMap : data\map\map_sq09.md3
2006-08-15 07:25:10,  MapInfoMgr::LoadMap : data\map\map_sq09_13.md3
2006-08-15 07:25:12,  ZoneManager::BuildWorld
2006-08-15 07:25:12,  Zone::LoadMap : data\map\map_sq00.md3........

.......ZoneMapAttr::Init - zone 110,ÂÞÈüËþµÄÃØÊÒ,data\map\map_sq09_13.md3 : no grount attr.
2006-08-15 07:27:26,  110,ÂÞÈüËþµÄÃØÊÒ,data\map\map_sq09_13.md3 - unblocked/total tile = 3395/7680 : 44.21
2006-08-15 07:27:26,                    ÂÞÈüËþµÄÃØÊÒ : data\map\map_sq09_13.md3 loaded as id:110, type:5
2006-08-15 07:27:42,  ZoneManager::BuildWorld - done
2006-08-15 07:27:43,  NetworkManager::oceanHandleError - Server resume
2006-08-15 07:27:43,  Server started.


i dont sure.. is this logs are the correct fuction on the server, maybe somethings wrong... please chek a look, i dont enter in my server thanksss....


EDIT: hi, well, i fix my error, now i can enter in my server :D thanks anyway... now working in the traslation... if someone help me to traslate to Spanish PM, thanks again :D
 
Last edited:
Newest Patch Includes:
Translation for 7 Npcs
Translations for 20 Items!
Translations for In-game Messages
And alot more extras!
 
We should have a compiled guide and list of FAQ's in good time for anybody wishing to start a server.
 
hi, when my server RUN, the CPU usage is 99%, is normal this???
my pc its a Pentium IV 1.8, 1Gb Ram, 40gigas Hdd, MOB Viarama u-8668...
other thing, the FirstLoginSvrW.EXE create log every 1 minute, its could be possible change time, for 10 min for example???

2006-08-16 01:43:48, 10016:System status![Session(Sz:1024,Free:1000),Send(Sz:1000,Free:1000),MultiQool(Free:1000,Busy:0),Memory(Fault:16408,Usage:2002944)]

thanks
 
the problem of login server (CONECTING) to master server

master_20060820_080639.log

2006-08-20 08:06:41 Trickster Master Server ver 0.66

2006-08-20 08:06:41 Server resume
2006-08-20 08:07:16 User connected: index: 0
2006-08-20 08:07:16 MCMD_SVR_LOGIN_ACK_OK: index: 0, id: lserver1, world:0, ip:218.62.120.3:10006, 218.62.120.3:10006
2006-08-20 08:07:25 Query failure: EXEC uspm_accountdb_exec_send_usercount 1, 0
2006-08-20 08:07:27 Table DB reopen failure
2006-08-20 08:07:27 Refresh User Login State...
2006-08-20 08:07:31 Query failure: EXEC uspm_accountdb_exec_send_usercount 1, 0
2006-08-20 08:07:31 Table DB reopen failure
2006-08-20 08:07:31 cUserStore::RefreshUserLoginState(1) failed:[Microsoft][ODBC SQL Server Driver][SQL Server]在 sysservers 中未能找到服务器 'TR_ACCOUNTDB'。请执行 sp_addlinkedserver 以将服务器添加到 sysservers。;
2006-08-20 08:07:31 RefreshUserLoginState failed
2006-08-20 08:07:35 Query failure: EXEC uspm_accountdb_exec_send_usercount 1, 0
2006-08-20 08:07:35 Table DB reopen failure
2006-08-20 08:07:40 Query failure: EXEC uspm_accountdb_exec_send_usercount 1, 0
2006-08-20 08:07:40 Table DB reopen failure
2006-08-20 08:07:43 WSARecv() failed with error in ClientT 10054
2006-08-20 08:07:43 SUPERVISOR::DecideMasterIsland NO MASTER ISLAND!!
2006-08-20 08:07:43 SUPERVISOR::HANDLE LOGOUT - LOGIN : IslandNum: 0, socketIdx: 0
2006-08-20 08:07:43 User disconnected: index: 0 - ID: lserver1

Login.log

2006-08-20 08:06:47, Loading configuration from file:
C:\Trickster\LoginServer\LoginServer.ini
2006-08-20 08:06:47, Loaded

2006-08-20 08:06:50, Starting network device...
2006-08-20 08:06:50, Server starting...
2006-08-20 08:07:16, Server ready
2006-08-20 08:07:16, Started

2006-08-20 08:07:16, Loging on Master Servers...
2006-08-20 08:07:37, Failed to refresh user login state
 
Back