[Release] Dekaron real A9 Server files

[Somniferum]

Thank you very much! Server side done, time to suck with the client :)
Have a nice day!

[Zajt007]

Still having problems. Going to re-restore my databases, re-run my queries & see how that goes. I'll be back if I have any more problems.

[Somniferum]

I'm really sorry for begging help again, but I'm really out of ideas atm. Normal Server vs. client(the rising one included in this guide/release) This for me looks like the Client not even trying to communicate. I type account pw *instant disconnected* I type something which does not exist for sure, same (In only get wrong ID msg when I leave empty the fields.)
Nothing shows up in dbmon. When I change the port to something else (from 7880 to 7882) its starts to send packets? but no response then response time exceeded msg.
channellist.csv client/data/share:

Group,Channel Index,IP,Port,Name,Chaotic
0,0,127.0.0.1,50005,Insomnia,0

channellist.csv server/share:

Group,Channel Index,IP,Port,Name,Chaotic
0,0,127.0.0.1,50005,Insomnia,0

Loginlist.csv server:

Group,LoginServer Index,IP,Port,Charactercount,Description0,0,127.0.0.1,7880,7,Test

Loginlist.csv client:

Group,LoginServer Index,IP,Port,Charactercount,Description0,0,127.0.0.1,7880,7,Test

Dekaron normal server config:

;; DEKARON TEST
;
DEKARON_PORT = 50005
;
SESSION_COUNT = 1
;
SESSION_NO1_IP = 127.0.0.1
SESSION_NO1_PORT = 10001
SESSION_NO1_FLAG = 1
SESSION_NO1_INDEX = 20
SESSION_NO1_WORLD = 1
;
CAST_COUNT = 1
CAST_NO1_IP = 127.0.0.1
CAST_NO1_PORT = 7882
CAST_NO1_FLAG = 1
CAST_NO1_INDEX = 20
CAST_NO1_WORLD = 1
;
AISERVER_COUNT = 1
AI_SERVER_NO1_IP = 127.0.0.1
AI_SERVER_NO1_PORT = 7886
AI_SERVER_NO1_FLAG = 1
AI_SERVER_NO1_INDEX = 20
AI_SERVER_NO1_WORLD = 1
AI_SERVER_NO1_CHANNEL = 1
;
BILLING_COUNT = 1
BILLING_NO1_IP = 127.0.0.1
BILLING_NO1_PORT = 20000
BILLING_NO1_FLAG = 1
BILLING_NO1_INDEX = 10
;
MESSENGER_COUNT = 1
MESSENGER_NO1_IP = 127.0.0.1
MESSENGER_NO1_PORT = 7883
MESSENGER_NO1_WORLD = 1
;
STORE_SERVER_IP = 127.0.0.1
STORE_SERVER_PORT = 7885
STORE_SERVER_FLAG = 1
;
GATE_SERVER_IP = 127.0.0.1
GATE_SERVER_PORT = 9286
GATE_FLAG = 1
;
LOCATION_SERVER_IP = 127.0.0.1
LOCATION_SERVER_PORT = 9271
LOCATION_SERVER_FLAG = 1
;
LOBBY_SERVER_IP = 127.0.0.1
LOBBY_SERVER_PORT = 30000
LOBBY_SERVER_FLAG = 1
;
ACCOUNTGATE_COUNT = 1
ACCOUNTGATE_NO1_IP = 127.0.0.1
ACCOUNTGATE_NO1_PORT = 25000
ACCOUNTGATE_NO1_FLAG = 1
ACCOUNTGATE_NO1_INDEX = 20
;
ACCOUNT_IP = 127.0.0.1
ACCOUNT_PORT = 26000
ACCOUNT_FLAG = 0
;
MAX_PLAYER = 700
MAX_PC = 500
;
WORLD_INDEX = 1
CHANNEL_INDEX = 1
;
INSPECTCYCLE_TIME = 180
VERIFYWAIT_TIME = 60
;
PCZET_SETTING = 0
CONTENTS_TYPE = NORMAL
;
PARTY_RECRUIT = 1

login server config

SESSION_COUNT = 1;
SESSION_NO1_IP = 127.0.0.1
SESSION_NO1_PORT = 10001
SESSION_NO1_FLAG = 1
SESSION_NO1_INDEX = 20
;
MAX_COUNT_CHARACTER = 12
MANAGER_CHARACTER_CREATE = 1
CHARACTER_COPY = 0
;
ACCOUNT_COUNT = 1
ACCOUNT_NO1_IP = 127.0.0.1
ACCOUNT_NO1_PORT = 20000
ACCOUNT_NO1_INDEX = 245
;
ACCOUNT_GATE_COUNT = 1
SERVER_NAME = Insomnia
ACCOUNT_GATE_NO1_IP = 127.0.0.1
ACCOUNT_GATE_NO1_PORT = 25000
ACCOUNT_GATE_NO1_FLAG = 1
ACCOUNT_GATE_NO1_INDEX = 20
;
ACCOUNT_GATE_NO2_IP = 127.0.0.1
ACCOUNT_GATE_NO2_PORT = 26000
ACCOUNT_GATE_NO2_FLAG = 0
ACCOUNT_GATE_NO2_INDEX = 245
LOGIN_PORT = 7880
;
LOCATION_COUNT = 1
LOCATION_NO1_IP = 127.0.0.1
LOCATION_NO1_PORT = 9271
LOCATION_NO1_FLAG = 1
LOCATION_NO1_INDEX = 20
;
; UserID Format
; DEFAULT : no change
; LOWER : change to lowercase
; UPPER : change to uppercase
;
Korea = LOWER
Korea_CP = DEFAULT
Japan_Netmarble = DEFAULT
Japan_GameChu = LOWER
USA_Acclaim = DEFAULT
LOG_PATH = ..\LogFile\
;
OPENING = 0
;
; [WEB_SERVICE = 1] [LOCAL_TEST = 2] [TEST = 3] [REAL = 4]
SERVER_TYPE = 2
;
LOAD_TABLE = ServerMove.csv
;
SERVER_REMOVAL = 0

Any idea whats wrong?



Note: I had b4 FTH : fault tolerant heap shim... messages at each client startup. but I removed AcXtrnal.dlls same result tho.

Thank you! :/

[firas724]

Hi, I have a problem restoring the databases in bot SQL server manager 2008 and 2012 , please help. It says it cannot proccess this media family in upper versions of SQL servers, but int the 2000 version it says that there is a version difference ( I think the one from here is v661 and the one from 2000 is v591)

EDIT: NVM Solved it :)

[firas724]

My Session Server and Dekaron Server seem to be crashing at this point, I believe it is a share problem, if you guys think that too, then can someone tell me how to fix it?

[darkshadow]

My Session Server and Dekaron Server seem to be crashing at this point, I believe it is a share problem, if you guys think that too, then can someone tell me how to fix it?

How many ram you have?
minimum ram its 4GB
but bether when you have 8GB

And one more thing: Increase pagefile or slow some space on HDD C:\ this partitin must have 12~16GB free space.

[miencattim]

Is this is lock like fake ? :)

sasuke have used the old db previous version on sql 2000 so I said that's not Real A9

- - - Updated - - -

My Session Server and Dekaron Server seem to be crashing at this point, I believe it is a share problem, if you guys think that too, then can someone tell me how to fix it?

Window x64 ok

[darkshadow]

If you dont know how setup server don't do this

And this is real A9

[Luis Logan]

Hello guys, im luigi, im italian and i have 26 years old.
im fan of dekaron, if anyone can help me to get working dbs link and update would be great.
my skype is luiswillkillu TIA

[Luis Logan]

guys i really need help, i have installed sql 2008 all ok, but in my db folder i have only account, cash, char, ranking, dkrstoredb and dkrmanagedb.

there is no billing and others db shared on the pictures on the first post.

any1 can explane for me how to setup directorys and folders please?

[dottiein]

Can you help me with my the database or can you give me working database that is compatible with Sql server 2008 ! Cause i was trying to restore the database on my sql server it has error msg which that the database are not compatible with my sql 2008.

#Repectpost

[Somniferum]

Can you help me with my the database or can you give me working database that is compatible with Sql server 2008 ! Cause i was trying to restore the database on my sql server it has error msg which that the database are not compatible with my sql 2008.

#Repectpost

You need mssql not mysql :) Go on microsoft.com and search for mssql 2008 express.

[hectormousa]

the link for the working database is broken re upload please anyone and for the update server files link

[Zajt007]

Can you give a bigger picture or save the log, picture is very small to see.

Edit: nvm, did you declare siege in databases?

DECLARE @v_siege_no char(10) 
DECLARE  @GuiLd_code varchar(10) 
DECLARE  @GuiLd_name varchar(30)
DECLARE @v_strDate varchar(10)
DECLARE @v_regdate varchar(10)
DECLARE @v_strChannel varchar(2)
DECLARE @i_bychannel tinyint 
DECLARE @o_dwDungeonRegistTime varbinary(4)
DECLARE @o_DeadFrontTimeInfo varbinary(1000)
DECLARE @o_sp_rtn int
DECLARE @o_dwRegistTimeStart varbinary(4)
DECLARE @o_dwRegistTimeEnd varbinary(4)
DECLARE @o_dwTaxRegistTime varbinary(4)
declare @o_dwStartTime varbinary(4)
declare @o_dwRegistTime varbinary(4)
DECLARE @v_strDate1 varchar(10)
DECLARE @i_GetDate datetime
DECLARE @v_siege_start_date varchar(14)
DECLARE @v_siege_start_time varbinary(4)
set @i_GetDate=getdate()
---DEFAULT-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Once Week every Sunday-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Every 3 Days-//SELECT @v_siege_start_date= CONVERT(VARCHAR(10),GetDate()+3,112)+'210000'

--//Set the line below with which one you want above after you do, delete above lines and query it
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
SELECT @v_siege_start_time = SUBSTRING(@v_siege_start_date,4,1) * 100000000
+ SUBSTRING(@v_siege_start_date,5,2) * 1000000
+ SUBSTRING(@v_siege_start_date,7,2) * 10000
+ SUBSTRING(@v_siege_start_date,9,2) * 100
+ SUBSTRING(@v_siege_start_date,11,2)

SET  @GuiLd_code = '001'
SET  @GuiLd_name = 'SIEGEWAR'
SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001'
--INSERT 
--INTO GUILD_INFO(guild_code, guild_name, guild_Level, bystate, bychannel)
--VALUES   @GuiLd_code,  @GuiLd_name, 3, 1, 1)
--INSERT 
--INTO SIEGE_INFO(SIEGE_NO, CHANNEL_NO, GUILD_CODE, GUILD_NAME, 
--DWSTARTTIME, BYREGISTTIMEFLAG, DEFENDER_INFO, SIEGE_TAG)
--VALUES (@v_siege_no, 1,  @GuiLd_code,  @GuiLd_name,@v_siege_start_time, 1, 0X0000, 'Y')

EXEC SP_SIEGE_START_TIME_U  @GuiLd_code,1,0x01,@v_siege_start_time output,@o_dwRegistTime output,@o_sp_rtn output

set @v_strDate1=dbo.FN_BinDateToDateTime(@v_siege_start_time)

declare @P1 varchar(13)
set @P1=NULL
declare @P2 varchar(33)
set @P2=NULL
declare @P3 varchar(25)
set @P3=NULL
declare @P4 varbinary(4)
set @P4=NULL
declare @P5 varbinary(4)
set @P5=NULL
declare @P6 varbinary(4)
set @P6=NULL
declare @P7 varbinary(4)
set @P7=NULL
declare @P8 varbinary(4)
set @P8=NULL
declare @P9 varbinary(4)
set @P9=NULL
declare @P10 varbinary(4)
set @P10=NULL
declare @P11 varbinary(2)
set @P11=NULL
declare @P12 varbinary(2)
set @P12=NULL
declare @P13 varbinary(2)
set @P13=NULL
declare @P14 int
set @P14=NULL
declare @P15 int
set @P15=NULL
declare @P16 varbinary(4)
set @P16=NULL
declare @P17 varbinary(996)
set @P17=NULL
declare @P18 varbinary(996)
set @P18=NULL
declare @P19 varbinary(1000)
set @P19=NULL
declare @P20 int
set @P20=NULL
exec SP_SIEGE_INFO_R 1, @P1 output, @P2 output, @P3 output, @P4 output, @P5 output, @P6 output, @P7 output, @P8 output, @P9 output, @P10 output, @P11 output, @P12 output, @P13 output, @P14 output, @P15 output, @P16 output, @P17 output, @P18 output, @P19 output, @P20 output
select @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1

That's not the issue I don't think, that query didn't even execute properly & I don't think there's anything wrong with my databases, but I wouldn't know at this point. Any one else have this problem? Any other ideas?

[Matthew Conway]

Willing to pay someone 75-150 bucks through Paypal to help me setup a private test server. PM me or email me at matthewdeath2089@gmail.com, thanks!

- - - Updated - - -

Willing to pay someone 75-150 bucks through Paypal to help me setup a private test server. PM me or email me at matthewdeath2089@gmail.com, thanks!

Or add me on Skype, Ravenhacker97