request please

[yaabnel5wl]

i want any system Automatic Reward Unqiues Kill

Mean:-any one kill Unqiue Wins Reward

[Eslam Galull]

yaabnel5wl dont post here , you should post in
Private SRO Ask the Experts

[where_love2003]

Originally Posted by its.soul

yaabnel5wl dont post here , you should post in
Private SRO Ask the Experts

hhhhhhhhhhhhhhhhhhhhhh

[Tommy.]

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 


[BourBon*]

You Should Post In

[Aaron*]

ya abn el 5wl post your request/problem in private sro ask the experts and we will help you

[Omnipotent1337]

Originally Posted by Flowushy

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

[Crue*]

Originally Posted by Omnipotent1337

Where Code Reward

[Bocc1337]

i think he wanted coin for reward

[Omnipotent1337]

ok i want reward coin what i do ?