request please

07/02/2015 05:58 yaabnel5wl#1
i want any system Automatic Reward Unqiues Kill

Mean:-any one kill Unqiue Wins Reward
07/02/2015 19:29 Eslam Galull#2
yaabnel5wl dont post here , you should post in
Private SRO Ask the Experts
07/02/2015 20:05 where_love2003#3
Quote:
Originally Posted by its.soul View Post
yaabnel5wl dont post here , you should post in
Private SRO Ask the Experts
hhhhhhhhhhhhhhhhhhhhhh
07/02/2015 22:24 Tommy.#4
here u r
yaabnel5wl
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Trigger [dbo].[_TitansPoints]    Script Date: 02/07/2015 10:21:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Kero
-- Create date: 2015-3-27
-- Description:    Titans unique reward
-- =============================================
ALTER TRIGGER [dbo].[_TitansPoints]
   ON  [dbo].[srZor_uniques]
   AFTER INSERT
AS 
BEGIN
    SET NOCOUNT ON;
SET XACT_ABORT ON;

DECLARE @MobCodename VARCHAR(500)
        ,@Charname VARCHAR(200)
        ,@CharID INT
        ,@JID INT
            SELECT @MobCodeName = 
                                (
                                SELECT MobName
                                FROM inserted srZor_uniques
                                )
                    ,@Charname =
                                (
                                SELECT CharName
                                FROM inserted srZor_uniques
                                )
            SELECT @CharID =    (
                                SELECT CharID
                                FROM SRO_VT_SHARD.._Char
                                WHERE CharName16 = @Charname
                                )
            SELECT @JID =    (
                            SELECT UserJID
                            FROM SRO_VT_SHARD.._User
                            WHERE CharID = @CharID
                            )


    DECLARE @GainPoint INT = CASE
                              WHEN @MobCodename = 'MOB_CH_TIGERWOMAN_L3' THEN '5'
                              WHEN @MobCodename = 'MOB_OA_URUCHI_L3' THEN '7'
                              WHEN @MobCodename = 'MOB_KK_ISYUTARU_L3' THEN '9'
                              WHEN @MobCodename = 'MOB_TK_BONELORD_L3' THEN '12'
                              WHEN @MobCodename = 'MOB_RM_TAHOMET_L3' THEN '15'
                              WHEN @MobCodename = 'MOB_EU_KERBEROS_L3' THEN '5'
                              WHEN @MobCodename = 'MOB_AM_IVY_L3' THEN '7'
                              WHEN @MobCodename = 'MOB_TQ_BLACKSNAKE_L3' THEN '20'
                              WHEN @MobCodename = 'MOB_RM_ROC' THEN '150'
                              WHEN @MobCodename = 'MOB_CH_TIGERWOMAN' THEN '10'
                              WHEN @MobCodename = 'MOB_OA_URUCHI' THEN '14'
                              WHEN @MobCodename = 'MOB_KK_ISYUTARU' THEN '18'
                              WHEN @MobCodename = 'MOB_TK_BONELORD' THEN '24'
                              WHEN @MobCodename = 'MOB_RM_TAHOMET' THEN '30'
                              WHEN @MobCodename = 'MOB_EU_KERBEROS' THEN '10'
                              WHEN @MobCodename = 'MOB_AM_IVY' THEN '14'
                              ELSE '0' 
                          END
                        UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own += 1 where JID = @JID
                    --EXEC HILBILED..[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = '1', @PkgID = NULL, @NumSilk = @GainPoint, @Price = 99

   
END 
07/03/2015 00:35 BourBon*#5
You Should Post In [Only registered and activated users can see links. Click Here To Register...]
07/03/2015 08:25 Aaron*#6
ya abn el 5wl post your request/problem in private sro ask the experts and we will help you
07/03/2015 20:41 Omnipotent1337#7
Quote:
Originally Posted by Flowushy View Post
here u r
yaabnel5wl
PHP Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Trigger [dbo].[_TitansPoints]    Script Date: 02/07/2015 10:21:55 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Kero
-- Create date: 2015-3-27
-- Description:    Titans unique reward
-- =============================================
ALTER TRIGGER [dbo].[_TitansPoints]
   ON  [dbo].[srZor_uniques]
   AFTER INSERT
AS 
BEGIN
    SET NOCOUNT ON;
SET XACT_ABORT ON;

DECLARE @MobCodename VARCHAR(500)
        ,@Charname VARCHAR(200)
        ,@CharID INT
        ,@JID INT
            SELECT @MobCodeName = 
                                (
                                SELECT MobName
                                FROM inserted srZor_uniques
                                )
                    ,@Charname =
                                (
                                SELECT CharName
                                FROM inserted srZor_uniques
                                )
            SELECT @CharID =    (
                                SELECT CharID
                                FROM SRO_VT_SHARD.._Char
                                WHERE CharName16 = @Charname
                                )
            SELECT @JID =    (
                            SELECT UserJID
                            FROM SRO_VT_SHARD.._User
                            WHERE CharID = @CharID
                            )


    DECLARE @GainPoint INT = CASE
                              WHEN @MobCodename = 'MOB_CH_TIGERWOMAN_L3' THEN '5'
                              WHEN @MobCodename = 'MOB_OA_URUCHI_L3' THEN '7'
                              WHEN @MobCodename = 'MOB_KK_ISYUTARU_L3' THEN '9'
                              WHEN @MobCodename = 'MOB_TK_BONELORD_L3' THEN '12'
                              WHEN @MobCodename = 'MOB_RM_TAHOMET_L3' THEN '15'
                              WHEN @MobCodename = 'MOB_EU_KERBEROS_L3' THEN '5'
                              WHEN @MobCodename = 'MOB_AM_IVY_L3' THEN '7'
                              WHEN @MobCodename = 'MOB_TQ_BLACKSNAKE_L3' THEN '20'
                              WHEN @MobCodename = 'MOB_RM_ROC' THEN '150'
                              WHEN @MobCodename = 'MOB_CH_TIGERWOMAN' THEN '10'
                              WHEN @MobCodename = 'MOB_OA_URUCHI' THEN '14'
                              WHEN @MobCodename = 'MOB_KK_ISYUTARU' THEN '18'
                              WHEN @MobCodename = 'MOB_TK_BONELORD' THEN '24'
                              WHEN @MobCodename = 'MOB_RM_TAHOMET' THEN '30'
                              WHEN @MobCodename = 'MOB_EU_KERBEROS' THEN '10'
                              WHEN @MobCodename = 'MOB_AM_IVY' THEN '14'
                              ELSE '0' 
                          END
                        UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own += 1 where JID = @JID
                    --EXEC HILBILED..[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = '1', @PkgID = NULL, @NumSilk = @GainPoint, @Price = 99

   
END 
Where Code Reward
07/03/2015 23:08 Crue*#8
Quote:
Originally Posted by Omnipotent1337 View Post
Where Code Reward

[Only registered and activated users can see links. Click Here To Register...]
07/04/2015 03:13 Bocc1337#9
i think he wanted coin for reward
07/04/2015 04:29 Omnipotent1337#10
ok i want reward coin what i do ?