Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Scarlet Blade Server files + Client + DB

Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
The database is not complete for the server.
Lacks tables as well as stored procedures.


DB:QueensAccount

Procedure/View Missing object
usp_NAccountItemListbyAccount Tbl_DBErrors
usp_NAccountItemInsert Tbl_DBErrors
usp_NAccountItemDelete Tbl_DBErrors
usp_NAccountItemInsertByWeb Tbl_DBErrors

DataBase: QueensGame

Procedure/View Missing object
sp_upgraddiagrams dtproperties
usp_NCharNameChange GuildInfo
usp_NCastleUpdate tbl_Guild
usp_NFieldSpotUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_GuildMember
usp_NArenaCharUpdate tbl_GuildMember
usp_NRankBaselineDataUpdateItem tbl_RankUpdateItemInfo
usp_NInsertSkill tbl_Skill_100310

And used external link server, example -> [usp_NRankBaselineDataUpdate] -> OPENQUERY -> FROM QB_MIDDLE_DB

Example:
Code:
/****** Object:  Table [dbo].[tbl_DBErrors]    Script Date: 05.12.2021 15:54:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DBErrors](
	[Num] [bigint] IDENTITY(1,1) NOT NULL,
	[ErrorNumber] [int] NULL,
	[ErrorSeverity] [int] NULL,
	[ErrorState] [int] NULL,
	[ErrorProcedure] [nvarchar](126) NULL,
	[ErrorLine] [int] NULL,
	[ErrorMessage] [nvarchar](4000) NULL,
	[RegDate] [datetime] NOT NULL,
 CONSTRAINT [PK_tbl_DBErrors] PRIMARY KEY CLUSTERED 
(
	[Num] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'순번' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'Num'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 번호' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorNumber'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 심각도' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorSeverity'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 상태 번호' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorState'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류가 발생한 저장 프로시저 또는 트리거의 이름' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorProcedure'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류를 발생시킨 루틴 내의 줄 번호' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorLine'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 메시지' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'ErrorMessage'
GO

EXEC sys.sp_addextendedproperty  [USER=1333344765]name[/USER]=N'MS_Description', @value=N'저장 시간' ,  [USER=501312]level[/USER]0type=N'SCHEMA'  [USER=501312]level[/USER]0name=N'dbo',  [USER=501312]level[/USER]1type=N'TABLE'  [USER=501312]level[/USER]1name=N'tbl_DBErrors',  [USER=501312]level[/USER]2type=N'COLUMN'  [USER=501312]level[/USER]2name=N'RegDate'
GO
 
Last edited:
Custom Title Activated
Member
Joined
Dec 20, 2005
Messages
2,046
Reaction score
117
Hope there's more lights for this game. Wonder the official servers are still around lol

PS: looks like some smarts people got the private server running
Probably based off from this servers files or some new sources.
 
Last edited:
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
Hello :)

There are any news about this project ?

Anyone has EN client ?

Thanks
 
Last edited:
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
I tried use api (from last link) with vendetta client, but not working, the client can call api, but the return from api with key to client do nothing, only open new tab from navigator.

Anyone had succes with api ? and how it work ?
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
After installing server and BDD and configure all, server start. Now I dont have client, if anyone have it can you help me and give me client ?


Now :
- I try with Vendeta client, I create bat file with param, and client connect to login server, but without auth code, login server disconnect me.
- Now i work on api for get this code
 
Last edited:
Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
Do you have a working link to the server?
In the current link there is only a database, a client and utilities, there is no server.
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
Try this its server that I use now :

 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
Sorry try this :





I am sad, i cant connect client to Login server :( always error with authcode and auth client



I have only "Incorrect ID or Password" on client :(

The api return auth code but this code never work. if i don't use it, the game propose create pass with 6 numbers, and after "Mother disconnect you"

If you have idea ?
 
Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
Sorry try this :





I am sad, i cant connect client to Login server :( always error with authcode and auth client



I have only "Incorrect ID or Password" on client :(

The api return auth code but this code never work. if i don't use it, the game propose create pass with 6 numbers, and after "Mother disconnect you"

If you have idea ?

I checked this server, I do not start CacheServer and LoginServer

Log CacheServer:
[09:54:52][INFO][cServiceSvr::serviceMain] ====== Starting Cache Server ======
[09:54:52][INFO][cIocpSvr::Init] Succeed in Initializing cIocpSvr

and Close

Log LoginServer
INFO[0x00006518][2022-07-28 09:55:57,996][CApplication::InitDatabase]Error : START DATABASE()
INFO[0x00006518][2022-07-28 09:55:57,999][CApplication::StartApplication]Error : Initialize()

Used SQL 2008 R2

Therefore, I can not yet check the connection of the client to the server.
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
On SQL server do you activate TCP/IP protocoles?
On all config.xml do you change IP values ?



All <network IP="127.0.0.1"
all <LoginServer IP="127.0.0.1"
All <GameLogServer IP="127.0.0.1"

There are few error in config from Billingserver about number ports i can help you when you will start this server
 
Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
On SQL server do you activate TCP/IP protocoles?
On all config.xml do you change IP values ?



All <network IP="127.0.0.1"
all <LoginServer IP="127.0.0.1"
All <GameLogServer IP="127.0.0.1"

There are few error in config from Billingserver about number ports i can help you when you will start this server

Yes, my billing config:

<?xml version="1.0" encoding="UTF-8"?>
<BillingServerConfig>
<System AutoRun="0" />
<Network IP="127.0.0.1" Port="10008" IPForServer="127.0.0.1" PortForServer="20008" />
<Billing IP="127.0.0.1" Port="27108" />
<GameLogServer IP="127.0.0.1" PortForServer="20007" />
<WebMall WebMall = 0 Host = "127.0.0.1" Protocol = "https" />
</BillingServerConfig>

and Login config:

<?xml version="1.0" encoding="UTF-8"?>
<LoginServerConfig>
<System
AutoRun = 0
></System>
<Network
IP = "127.0.0.1"
Port = 10001
IPForServer = "127.0.0.1"
PortForServer = 20001
></Network>
<Database
IP = "localhost,1433"
Name = "QueensAccount"
ID = ""
Pwd = ""
></Database>
<AccountDB
IP = "localhost,1433"
Name = "QueensAccount"
ID = ""
Pwd = ""
></AccountDB>
<GameLogServer
IP = "127.0.0.1"
Port = 20007
PortForServer = 20007
></GameLogServer>
<PCBangServer
Enable = 0
IP = "127.0.0.1"
Port = 30001
></PCBangServer>
<UserCounting
Enable = 0
></UserCounting>
<CheckSuperUserIP
Enable = 0
></CheckSuperUserIP>
<Client
Version = 31
></Client>
<WebLogin
WebLogin = 0
Host = "api.test.aeriagames.com"
Protocol = "https"
SecretKey = "ac502f28735083da9fbf401c00f86c40"
></WebLogin>
</LoginServerConfig>
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
Your loginserver connect to databse?



For billing server can you show me config from ZoneServer ?
 
Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
Your loginserver connect to databse?



For billing server can you show me config from ZoneServer ?

Your loginserver connect to databse? - No

Config ZoneServer:

<?xml version="1.0" encoding="ansi"?>
<ZoneServerConfig>
<!-- 시스템 설정값 AutoStart(0:대기,1:자동시작) -->
<System AutoRun="0" HitCountNum="10"/>
<!-- 네트웍 설정값 -->
<Network IP="127.0.0.1" Port="10003" IPForServer="127.0.0.1" PortForServer="20003" />

<!-- 데이터베이스 설정값 -->
<Database
IP = "127.0.0.1"
Name = "QueensGame"
ID = ""
Pwd = ""
></Database>

<!-- 월드서버 설정값 -->
<WorldServer IP="127.0.0.1" Port="10002" PortForServer="20002" />
<!-- 접속 게임로그 서버 설정값 -->
<GameLogServer IP="127.0.0.1" Port="20007" PortForServer="20007" />
<BillingServer IP="127.0.0.1" PortForServer="20008" />

<!-- 캐쉬서버 설정 -->
<CacheServer IP="127.0.0.1" Port="20004" PortForServer="20004" />

<!-- 존 설절값 -->
<Zone Index="1" MapPath="map" DFSPath="..\\dfs" MapConfig="MapConfig.xml" />

<Game PCDamage="2.3" DamageAggro="10000" HPAggro="5000" SPAggro="5000" />
</ZoneServerConfig>
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
In SQL server is it ok this ?
ouma - Scarlet Blade Server files + Client + DB - RaGEZONE Forums




I have small progress with api, i had bad config when loginserver call api, i am working on this



in your config.xml change this : <BillingServer IP="127.0.0.1" PortForServer="20008" />
to
<BillingServer IP="127.0.0.1" Port="10008" PortForServer="20008" />
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
First you need LoginServer call database after other server will work more easy
 
Experienced Elementalist
Joined
Jan 11, 2010
Messages
244
Reaction score
43
Dragona loginserver works successfully, scarletblade does not work, while it looks like an error in the application itself, and not in connecting to the database

ouma - Scarlet Blade Server files + Client + DB - RaGEZONE Forums
 
Initiate Mage
Joined
Jun 20, 2022
Messages
92
Reaction score
17
Yesssssssssssssssssssss
After finsh config api works :) and i connecte to game and play :)



I will teste game in weekend for see if any issue, now what i see after fews quests, no issue with item, game is stable, i see in puzzle that lvl max seem 44



I need work for launcher, because now i use bat, but i must change authcode for start



For your sql server do you use sql authentificate?
 
Back
Top