الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=289)
-   -   Release Unique Reward System (https://silkroad4arab.com/vb/showthread.php?t=619370)

HB# 18-10-2017 12:52 AM

رد: Release Unique Reward System
 
دا نورك :character38:

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

رد: Release Unique Reward System
 
عاااش يا باشاا وربناا كويس ! :arf2:

HB# 26-10-2017 09:43 AM

رد: Release Unique Reward System
 
تسلملي :wave::wave:

SkyZ 27-10-2017 01:16 AM

رد: Release Unique Reward System
 
tab ana 3aiz srzor_gameserver Dg12 ysht8l 3lih al nzam dah

HB# 27-10-2017 03:10 AM

رد: Release Unique Reward System
 
هوا انا معرفش ال DG12 بس على ما اظن ال srZor_GameServer دا هينفعك .. هنا .. شغال 100% لان دا ال انا شغال بيه وعامل السيستم عليه :hammer2:

renomustdie 29-10-2017 11:16 PM

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

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

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

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

HB# 30-10-2017 01:16 AM

رد: Release Unique Reward System
 
اقتباس:

المشاركة الأصلية كتبت بواسطة renomustdie (المشاركة 5332683)
في مشكله عندي ال ريوارد شغال تمام مافيش مشاكل بس لحظت حاجه

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

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

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

تسلم على الملاحظه .. من عندي انا دي مخدش بالي من حاجه بسيطه كدا .. :sleeping: :busted_cop: تم التعديل على الموضوع .. اعمل دي لو انت 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


renomustdie 30-10-2017 04:06 PM

رد: Release Unique Reward System
 
عاش ياحب جاري التجربه بس سيستم ده جامد جدا بيلخص شغل كتير لنظام اليونكات

HB# 31-10-2017 08:18 AM

رد: Release Unique Reward System
 
ولا يهمك .. انا فالخدمه :mf_boobies:

Kabloz™ 28-11-2017 01:17 AM

رد: Release Unique Reward System
 
الله ينور مجهود رائع :munch_h4h:

The_Reason 03-12-2017 03:25 AM

رد: Release Unique Reward System
 
تسلم ايدك :lulu12:

HB# 03-12-2017 05:27 PM

رد: Release Unique Reward System
 
نوروتوا اشباب :biggrin2:

.Gamer. 05-12-2017 04:04 AM

رد: Release Unique Reward System
 
الله ينور استمر

HB# 07-12-2017 01:01 PM

رد: Release Unique Reward System
 
تسلملي :mf_nun:

TheBold 11-12-2017 03:55 PM

رد: Release Unique Reward System
 
تسلم يا كبير


الساعة الآن 01:03 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.