Server file uncomplete?

Results 1 to 7 of 7
  1. #1
    Enthusiast kiposonic is offline
    MemberRank
    Dec 2012 Join Date
    32Posts

    Server file uncomplete?

    Hello guys,

    I was wondering why heal skill effect didn't work in my server. After my reacher I didn't found the effect files for heal.
    So it's the server who it's uncomplete or we have to enable heal ?


  2. #2
    Member descool is offline
    MemberRank
    Sep 2010 Join Date
    MalaysiaLocation
    85Posts

    Re: Server file uncomplete?

    i don know,so far so good now only DP not function,gift not function only at shop but function good at mail send gift with attachment.
    on9 atm,
    dragon-saga-v.2.png

  3. #3
    Novice windpalmee is offline
    MemberRank
    Apr 2011 Join Date
    2Posts

    Re: Server file uncomplete?

    I have the same problem too! I looked everywhere in the database and found something wrong with the data in [DR2_Def].[dbo].[TB_DefSkillAbil_Player], some values ought not to be 0. For example you may execute the following query.

    Code:
    SELECT *
      FROM [DR2_Def].[dbo].[TB_DefSkillAbil_Player]
      where skillabilid>=102002401 and skillabilid<=102002410
      GO
    The skillabilid corresponds with "Slow Heal" and you will see the result:
    Code:
    SkillAbilID	Memo	Type01	Value01
    102002407	슬로우 힐	7002	0
    102002408	슬로우 힐	7002	0
    102002409	슬로우 힐	7002	0
    102002410	슬로우 힐	7002	0
    102002401	슬로우 힐	7002	0
    102002402	슬로우 힐	7002	0
    102002403	슬로우 힐	7002	0
    102002404	슬로우 힐	7002	0
    102002405	슬로우 힐	7002	0
    102002406	슬로우 힐	7002	0
    Type01 = 7002 means AT_E_MAX_HP, ie the recovery amount of total HP.
    The correct values should be
    Code:
    102002401	슬로우 힐	7002	100
    102002402	슬로우 힐	7002	200
    102002403	슬로우 힐	7002	300
    102002404	슬로우 힐	7002	400
    102002405	슬로우 힐	7002	500
    102002406	슬로우 힐	7002	550
    102002407	슬로우 힐	7002	600
    102002408	슬로우 힐	7002	650
    102002409	슬로우 힐	7002	700
    102002410	슬로우 힐	7002	750
    You can get the data from 0.15.12 database by the same name. However there are some difference between both. When editing you should beware.
    I haven't fully figured out which values are faulty. It's possible that values of other player skills besides healing are wrong.
    I'm still working on solving the problem and that's all I know so far.

  4. #4
    Novice windpalmee is offline
    MemberRank
    Apr 2011 Join Date
    2Posts

    Re: Server file uncomplete?

    I've worked out how to repair skills related to heal. Here's the code. However I'm not sure if other skills have wrong values. If so then a big project to change it.

    Code:
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000,[Value02] = 60 WHERE [SkillAbilID] = 102000501
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1400,[Value02] = 80 WHERE [SkillAbilID] = 102000502
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1800,[Value02] = 100 WHERE [SkillAbilID] = 102000503
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 2200,[Value02] = 120 WHERE [SkillAbilID] = 102000504
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 2600,[Value02] = 140 WHERE [SkillAbilID] = 102000505
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 3000,[Value02] = 160 WHERE [SkillAbilID] = 102000506
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 3400,[Value02] = 180 WHERE [SkillAbilID] = 102000507
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 3800,[Value02] = 200 WHERE [SkillAbilID] = 102000508
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 4200,[Value02] = 220 WHERE [SkillAbilID] = 102000509
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 4600,[Value02] = 240 WHERE [SkillAbilID] = 102000510
    
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 100 WHERE [SkillAbilID] = 102002401
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 200 WHERE [SkillAbilID] = 102002402
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 300 WHERE [SkillAbilID] = 102002403
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 400 WHERE [SkillAbilID] = 102002404
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 500 WHERE [SkillAbilID] = 102002405
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 550 WHERE [SkillAbilID] = 102002406
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 600 WHERE [SkillAbilID] = 102002407
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 650 WHERE [SkillAbilID] = 102002408
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 700 WHERE [SkillAbilID] = 102002409
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 750 WHERE [SkillAbilID] = 102002410
    
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 5000 WHERE [SkillAbilID] = 107000301
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 5500 WHERE [SkillAbilID] = 107000302
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6000 WHERE [SkillAbilID] = 107000303
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6500 WHERE [SkillAbilID] = 107000304
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7000 WHERE [SkillAbilID] = 107000305
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7500 WHERE [SkillAbilID] = 107000306
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 8000 WHERE [SkillAbilID] = 107000307
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 8500 WHERE [SkillAbilID] = 107000308
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 9000 WHERE [SkillAbilID] = 107000309
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 9500 WHERE [SkillAbilID] = 107000310
    
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 3000 WHERE [SkillAbilID] = 107000401
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 3500 WHERE [SkillAbilID] = 107000402
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 4000 WHERE [SkillAbilID] = 107000403
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 4500 WHERE [SkillAbilID] = 107000404
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 5000 WHERE [SkillAbilID] = 107000405
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 5500 WHERE [SkillAbilID] = 107000406
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6000 WHERE [SkillAbilID] = 107000407
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6500 WHERE [SkillAbilID] = 107000408
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7000 WHERE [SkillAbilID] = 107000409
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7500 WHERE [SkillAbilID] = 107000410
    
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 5500 WHERE [SkillAbilID] = 109001601
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6000 WHERE [SkillAbilID] = 109001602
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 6500 WHERE [SkillAbilID] = 109001603
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7000 WHERE [SkillAbilID] = 109001604
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 7500 WHERE [SkillAbilID] = 109001605
    
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000401 WHERE [SkillAbilID] = 109002801
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000402 WHERE [SkillAbilID] = 109002802
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000403 WHERE [SkillAbilID] = 109002803
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000404 WHERE [SkillAbilID] = 109002804
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000405 WHERE [SkillAbilID] = 109002805
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000406 WHERE [SkillAbilID] = 109002806
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000407 WHERE [SkillAbilID] = 109002807
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000408 WHERE [SkillAbilID] = 109002808
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000409 WHERE [SkillAbilID] = 109002809
    UPDATE [DR2_Def].[dbo].[TB_DefSkillAbil_Player] SET [Value01] = 1000410 WHERE [SkillAbilID] = 109002810

  5. #5
    Enthusiast kiposonic is offline
    MemberRank
    Dec 2012 Join Date
    32Posts

    Re: Server file uncomplete?

    Woah, nice job i'll try it! And really thanks to share it.

  6. #6
    Member descool is offline
    MemberRank
    Sep 2010 Join Date
    MalaysiaLocation
    85Posts

    Re: Server file uncomplete?

    to fix the errer runtime visual c++ mission map, change this type01 :

    102002401 슬로우 힐 7002 100
    102002402 슬로우 힐 7002 200
    102002403 슬로우 힐 7002 300
    102002404 슬로우 힐 7002 400
    102002405 슬로우 힐 7002 500
    102002406 슬로우 힐 7002 550
    102002407 슬로우 힐 7002 600
    102002408 슬로우 힐 7002 650
    102002409 슬로우 힐 7002 700
    102002410 슬로우 힐 7002 750

    change: 7002 to 0 = it mean disable/off skill
    102002401 슬로우 힐 0 100
    102002402 슬로우 힐 0 200
    102002403 슬로우 힐 0 300
    102002404 슬로우 힐 0 400
    102002405 슬로우 힐 0 500
    102002406 슬로우 힐 0 550
    102002407 슬로우 힐 0 600
    102002408 슬로우 힐 0 650
    102002409 슬로우 힐 0 700
    102002410 슬로우 힐 0 750

  7. #7
    Member nixia12 is offline
    MemberRank
    Mar 2014 Join Date
    50Posts

    Re: Server file uncomplete?

    yahooo...i found here. my brother have same problem too..i will tell him to bookmark this thread..:D



Advertisement