Scarlet Blade Server files + Client + DB

[ashlay]

No idea where to find the client, but maybe we can sync the server and the client.

You must be registered to see links

i tried to use the server dfs files on the client but some files have version check maybe with a tool to convert dfs files we can fix it.

 

[geralex88]

@ashlay i read all logs, there are many error with missing proc in database, Maybe its not this problem
I try with GM character and the same issue



@ashlay you know where we can get this client?

I try repair our client

Is there a list of what stored procedures are missing?

 

[ashlay]

Is there a list of what stored procedures are missing?

missing
usp_NAchieveCompleteSelect
usp_NAchieveCompleteInsert
usp_NAchieveDataSelect
usp_NAchieveDataUpdate
usp_NAchieveTitleSelect
usp_NAchieveTitleUpdate
usp_NAchieveInit
usp_Tool_EventScheduleInsert
usp_Tool_EventHappyTimeInsert
usp_Wanted_Select
usp_Wanted_Reward

need to update
usp_ZoneUseCoupon

All procedures for the log server may be missing i'm not checked all yet.

usp_NSearchAccountListLog_2013_04_19
usp_NSearchCharacListLog_2013_04_20
usp_NSearchConnectCountUserLog
usp_NSearchItemListLog_2013_04_20
usp_NSearchCharacItemListLog_2013_04_20
usp_NSearchPostListLog_2013_04_20
usp_NSearchAccountLog_2013_04_20
usp_NSearchCharacterLog_2013_04_20
usp_NSearchCharacterLogByID_2013_04_20
usp_NSearchCharacItemLog_2013_04_20
usp_NSearchCharacPostLog_2013_04_20
usp_NSearchAccountHistory
usp_NSearchCharacHistory
usp_NSearchItemLog
usp_NSearchItemLogHistory
usp_NSearchCharacPostLogByID
usp_NSearchPostLog
usp_NSearchPostLogItemHistory
usp_NSearchStrengthenLog
usp_NSearchRandomOptionLog
usp_NSearchTradeLog
usp_NSearchTradeLogHistory
usp_NSearchConvertLog
usp_NSearchGambleLog
usp_NSearchRealmWarfareLog
usp_NSearchWorldStoreLog
usp_NSearchCharacPetLog
usp_NSearchCharacGuildLog
usp_NSearchGuildLog_2013_04_20
usp_NSearchGuildLogByID_2013_04_20
usp_NSearchCharacSkillLog
usp_NGameDB_SearchAccountInfo
usp_NGameDB_SearchCharacterList
usp_NGameDB_SearchCharacterInfo
usp_NGameDB_SearchCharacItemList
usp_NGameDB_InitAccountSecPWD
usp_NGameDB_ChangeAccountStatus
usp_NGameDB_LiftCharacterSeal
usp_NGameDB_CharacChatBlock
usp_NGameDB_ChangeSkillPoint
usp_NGameDB_ChangeLastMapCode
usp_NGameDB_ChangeLastPositionX
usp_NGameDB_ChangeLastPositionY
usp_NGameDB_ChangeLastPositionZ
usp_NGameDB_SendPostItem
usp_NGameDB_CharacItemDelete
usp_NGameDB_CharMoneyEdit
usp_NGameDB_SendPostItemNew
usp_NStatsConnectionLog
usp_NStatsItemLog
usp_NStatsGoldLog
usp_NStatsLevelLog
usp_NGameDB_ChangeName
usp_NConnectLogin
usp_NConnectLogout
usp_NAccountHistoryLog
usp_NConnectIn_2013_03_11
usp_NConnectOut
usp_NMoneyLog
usp_NExpLog
usp_NMapLog
usp_NSkillLog
usp_NQuestLog
usp_NPostLog
usp_NPetLog
usp_NItemLog
usp_NConsignmentSaleLog
usp_NStrengthenLog
usp_NRandomOption
usp_NGuildLog
usp_NGradeLog
usp_NConvertLog
usp_NGambleLog
usp_NRealmWarfareLog
usp_NTradeLog
usp_NCCULog

 

[zoran8844]

Tool for export SB/QB gfpk files:

You must be registered to see links

QuickBMS and Queens Blade Script for extracting Scarlet Blade or Queens Blade gfpk files. Script is for the QB gfpk files but it also seems to work on the SB files as well. Can be used to extract sounds, textures, gui images and xml files from SB gfpk files.

1. Run "QuickBMS.exe" and load the "Queens Blade Script.txt" file
2. Select the SB gfpk file that you want to unpack
3. Select the folder in which you want to unpack the selected gfpk file

CREDITS: Script by chrrox

You must be registered to see links

 

[Neg035]

Ok after many try, the client from Vendetta can sell or buy things, and this action is saved : this is good news

BUT

with this client no item can be show (item are present after save, when restart game with SB2.Exe).

Maybe its more easy to repair server with Vendetta client....



I try buy in auction there is issue too, only way will be repair server for work with vendetta client i think



I try buy in auction there is issue too, only way will be repair server for work with vendetta client i think

 

[geralex88]

Stored procedures will have to be restored manually using a profiler. I'll try to see how it turns out to start the server.
There is nothing similar even in Dragona.

 

[Neg035]

@ashlay after analyse client, i Think the SB2.exe need different file in data repository, maybe do you other file ? not from vendetta

 

[ashlay]

@ashlay after analyse client, i Think the SB2.exe need different file in data repository, maybe do you other file ? not from vendetta

I have 2013 and 2015 clients, both crash on npc buy/sell.

 

[Neg035]

@ashlay can you give me this 2 clients plz for test ?

 

[ashlay]

@ashlay can you give me this 2 clients plz for test ?

You must be registered to see links

 

[Neg035]

Super thanks



With vendetta client we can do more action, but only issue with item, that we can't see

 

[xlw00tlx]

so setup sql server,import the baks,then put the api in wamp and it should work?

 

[geralex88]

Correct start of the Login server?

Try and not working connect^

 

[Neg035]

@geralex88 what is your config.xml from login server ? and what client you use?

 

[geralex88]

@geralex88 what is your config.xml from login server ? and what client you use?

The config is classic, the api secret code from the database has been changed, the client uses Vendetta + other exe, as recommended here

Start client:

SB2.exe /connectip:127.0.0.1 /connectport:10001 /clientauthcode: 51afabb2019bdb96862f8ad0a2dcc614ab8493c6 /clientauthid: d4e4d71b1aff496e9bedd45bf97eb9ebd63f8dfa646fbd90c1

API:

LoginConfig:

<?xml version="1.0" encoding="ansi"?>
<LoginServerConfig>
<!-- 시스템 설정값 AutoStart(0:대기,1:자동시작) -->
<System
AutoRun = 1
></System>
<!-- 네트웍 설정값 -->
<Network
IP = "127.0.0.1"
Port = 10001
IPForServer = "127.0.0.1"
PortForServer = 20001
></Network>
<!-- 데이터베이스 설정값 -->
<Database
IP = "localhost"
Name = "QueensAccount"
ID = "queens_db_login"
Pwd = "queens_db_pass"
></Database>
<!-- 계정 데이터베이스 설정값 -->
<AccountDB
IP = "localhost"
Name = "QueensAccount"
ID = "queens_db_login"
Pwd = "queens_db_pass"
></AccountDB>
<!-- 접속 게임로그 서버 설정값 -->
<GameLogServer
IP = "127.0.0.1"
Port = 20007
PortForServer = 20007
></GameLogServer>
<!-- 접속 PC방 빌링 서버 설정값 -->
<PCBangServer
Enable = 0
IP = "127.0.0.1"
IP_ = "127.0.0.1"
Port = 7520
></PCBangServer>
<WebLogin
WebLogin = 1
Host = "192.168.1.74"
Protocol = "http"
SecretKey = "41447a2d3b3f3e75bee90e645ae8fdfe41f84a721e99a80f36"
></WebLogin>
<!-- 클라이언트 버전 설정값 -->
<!--<Client
Version = 31
></Client>-->
</LoginServerConfig>

 

[Neg035]

There is space here in your bat ? clientauthcode:-5

 

[geralex88]

And SQL setting:

There is space here in your bat ? clientauthcode:-5

Yes there is. Otherwise, the client simply closes if you remove the space.



I'll try to install a web server (wamp), because now they use IIS + PHP

 

[Neg035]

if true remote it



I prefere Wamp becaue 0 setup and wamp add IP in your Host automatic



I prefere Wamp becaue 0 setup and wamp add IP in your Host automatic



what client do you use for SQLserver ?

 

[geralex88]

Installing wampserver didn't help.

MySQL - used SQLyog
MSSQL - MSSMS

 

[Neg035]

Can you try to have your api in local ? 127.0.0.1