hossamahmedmju
21-09-2016, 04:18 AM
سلام عليكم
يا جماعه مع كامل احترامي للاستاز رامي انا لقيت الكود دا نشرو وقال ان انتا المفروض بيشتغل علي Vsro multi tool
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
وكمان قال ان المفروض هنعدل علي Event RegionID' and ('RewardCodeName' , 'RewardCount') فانا مش عارف ايه دا الي هنعدل عليه انا شغال ع Vsro Multi tool بس معملتش اي حاجه غير اني ضفت الكود في البروسيد ومش عارف اتحرك ياريت حد يشرح السيستم كلو وجزاكم الله كل خير
يا جماعه مع كامل احترامي للاستاز رامي انا لقيت الكود دا نشرو وقال ان انتا المفروض بيشتغل علي Vsro multi tool
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
وكمان قال ان المفروض هنعدل علي Event RegionID' and ('RewardCodeName' , 'RewardCount') فانا مش عارف ايه دا الي هنعدل عليه انا شغال ع Vsro Multi tool بس معملتش اي حاجه غير اني ضفت الكود في البروسيد ومش عارف اتحرك ياريت حد يشرح السيستم كلو وجزاكم الله كل خير