[M.HADAD]

المشاركة الأصلية كتبت بواسطة Dev. iLegend عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Procedure [dbo].[_Add_UniqueLog] at the end of procedure add these lines

كود PHP:

  IF (@Type = 2)
   Begin
    IF (Select LatestRegion From [SRO_VT_SHARD].[dbo].[_Char] Where CharName16 = @Killer) = 'Event RegionID'
     Begin
      Declare @RewardCodeName Varchar(128) , @RewardCount Int
      SELECT
      @RewardCodeName =
      CASE
        WHEN @CodeName = 'MOB_CH_TIGERWOMAN'        THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_EU_KERBEROS'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_AM_IVY'                THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_OA_URUCHI'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_KK_ISYUTARU'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_TK_BONELORD'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_RM_TAHOMET'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_YUNO'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_THE_EARTH1'    THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_DARK_DOG'        THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_JUPITER'        THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_BABILION'        THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_JUPITER_BAAL'            THEN 'ITEM_ETC_ARENA_COIN'
        WHEN @CodeName = 'MOB_TQ_WHITESNAKE'        THEN 'ITEM_ETC_ARENA_COIN'
      END ,
      @RewardCount =
      CASE 
        WHEN @CodeName = 'MOB_CH_TIGERWOMAN'        THEN '5'
        WHEN @CodeName = 'MOB_EU_KERBEROS'            THEN '6'
        WHEN @CodeName = 'MOB_AM_IVY'                THEN '7'
        WHEN @CodeName = 'MOB_OA_URUCHI'            THEN '8'
        WHEN @CodeName = 'MOB_KK_ISYUTARU'            THEN '9'
        WHEN @CodeName = 'MOB_TK_BONELORD'            THEN '10'
        WHEN @CodeName = 'MOB_RM_TAHOMET'            THEN '10'
        WHEN @CodeName = 'MOB_JUPITER_YUNO'            THEN '15'
        WHEN @CodeName = 'MOB_JUPITER_THE_EARTH1'    THEN '15'
        WHEN @CodeName = 'MOB_JUPITER_DARK_DOG'        THEN '17'
        WHEN @CodeName = 'MOB_JUPITER_JUPITER'        THEN '20'
        WHEN @CodeName = 'MOB_JUPITER_BABILION'        THEN '23'
        WHEN @CodeName = 'MOB_JUPITER_BAAL'            THEN '25'
        WHEN @CodeName = 'MOB_TQ_WHITESNAKE'        THEN '50'
      END
      IF @RewardCodeName Is Not Null and @RewardCount Is Not Null
       Begin
        Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Killer,@RewardCodeName,@RewardCount,0
       End
     End
   End 


you have to edit 'Event RegionID' and ('RewardCodeName' , 'RewardCount') for each unique codename before execute

الله عليك يا كبير كدا ولعت
جاررى التجربة