[gotsha]

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Trigger [dbo].[_AutoGrantSilkFromUniques]    Script Date: 28/08/2016 06:09:32 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Trigger [dbo].[_AutoGrantSilkFromUniques]
on
[dbo].[srZor_uniques]
after insert
as


declare @CharID int
Declare @CharName Varchar(MAX)
Declare @JID int
declare @ID varchar(max)
Declare @MobName Varchar(MAX)
declare @oldtitle int 

--------------
set @CharName = (Select CharName16 From SRO_VT_SHARD.dbo._Char Where CharName16 = (SELECT CharName FROM INSERTED srZor_uniques))
set @JID  = (Select UserJID from SRO_VT_SHARD.dbo._User Where CharID = (Select CharID From SRO_VT_SHARD.dbo._Char Where CharName16 = @CharName))
set @ID = (Select StrUserID From TB_User Where JID = @JID)
set @MobName = (Select MobName From inserted srZor_uniques)
Set @oldtitle =(select hwanlevel from SRO_VT_SHARD.._char where CharName16= (SELECT CharName FROM INSERTED srZor_uniques))
-------------------
IF (@MobName = 'MOB_CH_TIGERWOMAN') 
begin
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '2', @Price = NULL 
end
IF (@MobName = 'MOB_OA_URUCHI') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '4', @Price = NULL 
end
IF (@MobName = 'MOB_KK_ISYUTARU') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '5', @Price = NULL 
end
IF (@MobName = 'MOB_TK_BONELORD') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '8', @Price = NULL 
end
IF (@MobName = 'MOB_AM_IVY') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '3', @Price = NULL 
end
IF (@MobName = 'MOB_EU_KERBEROS') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '2', @Price = NULL 
end
IF (@MobName = 'MOB_RM_TAHOMET') 
begin
EXEC [CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @ID, @PkgID = NULL, @NumSilk = '10', @Price = NULL 
end

هتحط التريجر دة فى sql وتدوس f5 واهم حاجه تكون بتستخدم SrZor وتكون مظبط فيه بيانات sql عشان يسجل اليونكات الى بتتقل فى الداتا بيز