الموضوع: Release Unique Reward System
عرض مشاركة واحدة
قديم 30-10-2017, 01:16 AM   #22

HB#
عضو فعال



الصورة الرمزية HB#


• الانـتـسـاب » Jul 2017
• رقـم العـضـويـة » 133179
• المشـــاركـات » 472
• الـدولـة » Daquhlia - Mansoura
• الـهـوايـة »
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 10
HB# صـاعـد

HB# غير متواجد حالياً

617  


إرسال رسالة عبر Yahoo إلى HB#

افتراضي رد: Release Unique Reward System


اقتباس:
المشاركة الأصلية كتبت بواسطة renomustdie عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
في مشكله عندي ال ريوارد شغال تمام مافيش مشاكل بس لحظت حاجه

اكونت معاه 1000 سلك مثلا وقتل يونك واليونك ده ريورد بتاعو مثلا 300 سلك

لما يعمل تيليبورت المفروض يكون معاه 1300 ال بحصل ان ال 1000 سلك تتحذف خالص ويلاقي 300 سلك ولو قتل يونك ريورد بتاعو 40 سلك
هايحذف ال 300 وتبقي 40

مش عارف دي مشكله عندي ولا من السيستم
تسلم على الملاحظه .. من عندي انا دي مخدش بالي من حاجه بسيطه كدا .. تم التعديل على الموضوع .. اعمل دي لو انت srZor :

كود:
USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Trigger [dbo].[UniqueRewardSystem]    Script Date: 9/23/2017 11:26:25 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- AUTHOR : #HB
-- Don't copy it for yourself
-- =============================================


ALTER TRIGGER [dbo].[UniqueRewardSystem] 
ON  [dbo].[srZor_uniques]
after  insert  
as
/********************************* System Start ********************************/
----------- # Main Declares
declare @MobName varchar(max)
declare @CharName varchar(max)
declare @tableMobName varchar(max)
declare @tableItem1CodeName varchar(max)
declare @tableItem1Count int
declare @tableItem1OptLevel int
declare @tableItem2CodeName varchar(max)
declare @tableItem2Count int
declare @tableItem2OptLevel int
declare @tableItem3CodeName varchar(max)
declare @tableItem3Count int
declare @tableItem3OptLevel int
declare @table_silk_own int
declare @table_silk_gift int
declare @table_silk_point int
declare @table_gold_amount int
declare @table_unique_message varchar(max)
declare @table_unique_message2 varchar(max)
declare @table_unique_global varchar(max)
declare @table_unique_global2 varchar(max)
declare @table_unique_notice varchar(max)
declare @table_unique_notice2 varchar(max)
declare @table_hwan_level int
declare @CharID int
declare @CharJID int
declare @CharSilkCheck int
select @MobName = MobName,@CharName = CharName from srZor_uniques
----------- # Declares END
----------- # Sets Begin
Set @TableMobName = (select UniqueCodeName from _UQRewardConfig where UniqueCodeName = @MobName)
Set @tableItem1CodeName = (select ItemCodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem1Count = (select ItemCount from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem1OptLevel = (select ItemOptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @tableItem2CodeName = (select Item2CodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem2Count = (select Item2Count from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem2OptLevel = (select Item2OptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @tableItem3CodeName = (select Item3CodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem3Count = (select Item3Count from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem3OptLevel = (select Item3OptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @table_silk_own = (select silk_own from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_silk_gift = (select silk_gift from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_silk_point = (select silk_point from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_gold_amount = (select Gold from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_message = (select [Private Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_message2 = (select [Private Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_global = (select [Global Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_global2 = (select [Global Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_notice = (select [Notice Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_notice2 = (select [Notice Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_hwan_level = (Select HwanLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @CharID = (Select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @CharName)
Set @CharJID = (Select UserJID from [SRO_VT_SHARD].dbo._User where CharID = @CharID)
Set @CharSilkCheck = (select count(JID) from SK_Silk where JID = @CharJID)
----------- # Sets END
-- IF Condition
IF (@MobName = @tableMobName)
begin
IF @CharSilkCheck != '0'
begin
UPDATE SK_Silk set silk_own = silk_own + @table_silk_own , silk_gift = silk_gift + @table_silk_gift , silk_point = silk_point + @table_silk_point
end
IF @CharSilkCheck = '0'
begin
INSERT INTO SK_Silk (JID,silk_own,silk_gift,silk_point) values (@CharJID,'0','0','0')
UPDATE SK_Silk set silk_own = silk_own + @table_silk_own , silk_gift = silk_gift + @table_silk_gift , silk_point = silk_point + @table_silk_point where JID = @CharJID
end
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem1CodeName,@tableItem1Count,@tableItem1OptLevel
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem2CodeName,@tableItem2Count,@tableItem2OptLevel
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem3CodeName,@tableItem3Count,@tableItem3OptLevel
UPDATE [SRO_VT_SHARD].dbo._Char set RemainGold = RemainGold + @table_gold_amount
IF @table_hwan_level != '-100'
begin
UPDATE [SRO_VT_SHARD].dbo._Char set HwanLevel = @table_hwan_level
end
IF @table_unique_message != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,@table_unique_message,Getdate())
end
IF @table_unique_message2 != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,@table_unique_message2,Getdate())
end
IF @table_unique_global != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Message,Date) Values (1,'Global',@CharName + ', '+@table_unique_global,Getdate())
end
IF @table_unique_global2 != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Date) Values (1,'Global',@CharName + ', '+@table_unique_global2,Getdate())
end
IF @table_unique_notice != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Message,Date) Values (1,'Notice',@CharName + ', '+@table_unique_notice,Getdate())
end
IF @table_unique_notice != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Date) Values (1,'Notice',@CharName + ', '+@table_unique_notice2,Getdate())
end
end
ودي لو انت Evangelion :

كود:
USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Trigger [dbo].[UniqueRewardSystem]    Script Date: 9/23/2017 11:26:25 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- AUTHOR : #HB
-- Don't copy it for yourself
-- =============================================


ALTER TRIGGER [dbo].[UniqueRewardSystem] 
ON  [dbo].[Evangelion_uniques]
after  insert  
as
/********************************* System Start ********************************/
----------- # Main Declares
declare @MobName varchar(max)
declare @CharName varchar(max)
declare @tableMobName varchar(max)
declare @tableItem1CodeName varchar(max)
declare @tableItem1Count int
declare @tableItem1OptLevel int
declare @tableItem2CodeName varchar(max)
declare @tableItem2Count int
declare @tableItem2OptLevel int
declare @tableItem3CodeName varchar(max)
declare @tableItem3Count int
declare @tableItem3OptLevel int
declare @table_silk_own int
declare @table_silk_gift int
declare @table_silk_point int
declare @table_gold_amount int
declare @table_unique_message varchar(max)
declare @table_unique_message2 varchar(max)
declare @table_unique_global varchar(max)
declare @table_unique_global2 varchar(max)
declare @table_unique_notice varchar(max)
declare @table_unique_notice2 varchar(max)
declare @table_hwan_level int
declare @CharID int
declare @CharJID int
declare @CharSilkCheck int
select @MobName = MobName,@CharName = CharName from srZor_uniques
----------- # Declares END
----------- # Sets Begin
Set @TableMobName = (select UniqueCodeName from _UQRewardConfig where UniqueCodeName = @MobName)
Set @tableItem1CodeName = (select ItemCodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem1Count = (select ItemCount from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem1OptLevel = (select ItemOptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @tableItem2CodeName = (select Item2CodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem2Count = (select Item2Count from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem2OptLevel = (select Item2OptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @tableItem3CodeName = (select Item3CodeName from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem3Count = (select Item3Count from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @tableItem3OptLevel = (select Item3OptLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)

Set @table_silk_own = (select silk_own from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_silk_gift = (select silk_gift from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_silk_point = (select silk_point from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_gold_amount = (select Gold from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_message = (select [Private Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_message2 = (select [Private Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_global = (select [Global Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_global2 = (select [Global Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_notice = (select [Notice Chat] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_unique_notice2 = (select [Notice Chat2] from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @table_hwan_level = (Select HwanLevel from _UQRewardConfig where UniqueCodeName = @tableMobName)
Set @CharID = (Select CharID from [SRO_VT_SHARD].dbo._Char where CharName16 = @CharName)
Set @CharJID = (Select UserJID from [SRO_VT_SHARD].dbo._User where CharID = @CharID)
Set @CharSilkCheck = (select count(JID) from SK_Silk where JID = @CharJID)
----------- # Sets END
-- IF Condition
IF (@MobName = @tableMobName)
begin
IF @CharSilkCheck != '0'
begin
UPDATE SK_Silk set silk_own = silk_own + @table_silk_own , silk_gift = silk_gift + @table_silk_gift , silk_point = silk_point + @table_silk_point
end
IF @CharSilkCheck = '0'
begin
INSERT INTO SK_Silk (JID,silk_own,silk_gift,silk_point) values (@CharJID,'0','0','0')
UPDATE SK_Silk set silk_own = silk_own + @table_silk_own , silk_gift = silk_gift + @table_silk_gift , silk_point = silk_point + @table_silk_point where JID = @CharJID
end
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem1CodeName,@tableItem1Count,@tableItem1OptLevel
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem2CodeName,@tableItem2Count,@tableItem2OptLevel
exec [SRO_VT_SHARD].dbo._ADD_ITEM_EXTERN @CharName,@tableItem3CodeName,@tableItem3Count,@tableItem3OptLevel
UPDATE [SRO_VT_SHARD].dbo._Char set RemainGold = RemainGold + @table_gold_amount
IF @table_hwan_level != '-100'
begin
UPDATE [SRO_VT_SHARD].dbo._Char set HwanLevel = @table_hwan_level
end
IF @table_unique_message != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,@table_unique_message,Getdate())
end
IF @table_unique_message2 != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,@table_unique_message2,Getdate())
end
IF @table_unique_global != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Message,Date) Values (1,'Global',@CharName + ', '+@table_unique_global,Getdate())
end
IF @table_unique_global2 != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Date) Values (1,'Global',@CharName + ', '+@table_unique_global2,Getdate())
end
IF @table_unique_notice != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Message,Date) Values (1,'Notice',@CharName + ', '+@table_unique_notice,Getdate())
end
IF @table_unique_notice != 'NULL'
begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Date) Values (1,'Notice',@CharName + ', '+@table_unique_notice2,Getdate())
end
end


توقيع HB# :
Unknown language

رد مع اقتباس