|
|
• الانـتـسـاب » Aug 2012
|
|
• رقـم العـضـويـة » 104757
|
|
• المشـــاركـات » 426
|
|
• الـدولـة » مصر
|
|
• الـهـوايـة » Private Server Edit
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 30
|
|
|
|
رد: طريقه جديدة للسيلك ومفيدة
اقتباس:
المشاركة الأصلية كتبت بواسطة gotsha
كل عام وانتم بخير بعيد الاضحى المبارك
كود:
If (@TargetCharName like 'BOT' and @Message like '50 point')
begin
if @point >=50 and @level >= '95'
update SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own=silk_own+20 where JID=@JID
begin
update SRO_VT_ACCOUNT.dbo.SK_Silk set silk_point=silk_point-50 where JID=@JID
end
begin
INSERT INTO SRO_VT_SHARD.dbo._Notification (Type,Content,Executor,Target,Notified) values (3,'Your request has been updated successfully, 50 silk added as gift!','BOT1',@SenderCharName,0)
end
begin
if @point <50 and @level >= '95'
INSERT INTO SRO_VT_SHARD.dbo._Notification (Type,Content,Executor,Target,Notified) values (3,'Sorry, you cant use this service because you not have 50 point','BOT1',@SenderCharName,0)
end
end


دلوقتى مفضلش غير كود وهو انك ازاى تخلى البوينت تيجى من اليونكات عامه فى ناس معاها الكود وفى ناس لا فانا هنزله لاى حد عشان يبقى الموضوع كامل:
كود:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Trigger [dbo].[_AutoGrantSilkFromUniques] Script Date: 22/09/2015 02:05:54 م ******/
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

|
الله ينور فكره جميله
بس فين الـDeclare بتاع @Point & @Level
و ALTER الـفى الـ Trigger خليها Create
|