الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**HB#** · 18-10-2017, 12:52 AM

دا نورك

**H I T L E R** · 24-10-2017, 09:49 AM

عاااش يا باشاا وربناا كويس !

**HB#** · 26-10-2017, 09:43 AM

تسلملي

Mohamed Hitler معجب بهذا

**SkyZ** · 27-10-2017, 01:16 AM

tab ana 3aiz srzor_gameserver Dg12 ysht8l 3lih al nzam dah

**HB#** · 27-10-2017, 03:10 AM

هوا انا معرفش ال DG12 بس على ما اظن ال srZor_GameServer دا هينفعك .. عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] .. شغال 100% لان دا ال انا شغال بيه وعامل السيستم عليه

**renomustdie** · 29-10-2017, 11:16 PM

في مشكله عندي ال ريوارد شغال تمام مافيش مشاكل بس لحظت حاجه

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

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

مش عارف دي مشكله عندي ولا من السيستم

**HB#** · 30-10-2017, 01:16 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة 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