ابو ليلى
10-11-2016, 04:00 AM
اولا سلام عليكوم
ثانيا النهاردة انا بضور ع سيستم جوب يدى ريورد مع الجولد لقيت السيتم دة وجربتو وشغال100% معاية
قلت لازم انزلو هنا عشان كولو يستفيد
اولا لازم تكريت التيبل دة
USE [SRO_VT_LOG] GO /****** Object: Table [dbo].[RoyalCoinLogHunters] Script Date: 8.5.2015 14:47:55 ******/ SET
ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RoyalCoinLogHunters]( [CharID] [int] NULL, [Amount] [int] NULL, [EventTime] [smalldatetime] NULL ) ON [PRIMARY] GO
ثانيا
هتكريت البروسيد دة
USE [SRO_VT_LOG] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_RoyalAutoCoinGranting] @CharID INT as Declare @JobType tinyint = (Select JobType from SRO_VT_SHARD.dbo._Chartrijob where CharID = @CharID) , @amount int , @elixiramount int , @dividerhunter bigint = 18500000 , @dividertrader bigint = 8000000 , @Dividercontrthiefs bigint = 60500000 , @dividerthiefs bigint = 30000000 , @dividerhunterex bigint = 8000000 , @dividertraderex bigint = 3000000 , @dividerthiefsex tinyint = 8000000 , @Charname varchar(30) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID) , @contribution int = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) , @kills int; If (@JobType = 1 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividertrader,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end -- Hunter If (@JobType = 3 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividerhunter,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end --Now for thiefs If (@JobType = 2 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividerthiefs,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end
تمام
لو عاوز تغير الريود من هنا والكمية برضو د
if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE())
هتغير ال كود دة لى اللى انتة عاوزو وبدل 5 دى الكمية اللى انتة عاوزها
'ITEM_ETC_SD_TOKEN_04', 5,0
ثانيا النهاردة انا بضور ع سيستم جوب يدى ريورد مع الجولد لقيت السيتم دة وجربتو وشغال100% معاية
قلت لازم انزلو هنا عشان كولو يستفيد
اولا لازم تكريت التيبل دة
USE [SRO_VT_LOG] GO /****** Object: Table [dbo].[RoyalCoinLogHunters] Script Date: 8.5.2015 14:47:55 ******/ SET
ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RoyalCoinLogHunters]( [CharID] [int] NULL, [Amount] [int] NULL, [EventTime] [smalldatetime] NULL ) ON [PRIMARY] GO
ثانيا
هتكريت البروسيد دة
USE [SRO_VT_LOG] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_RoyalAutoCoinGranting] @CharID INT as Declare @JobType tinyint = (Select JobType from SRO_VT_SHARD.dbo._Chartrijob where CharID = @CharID) , @amount int , @elixiramount int , @dividerhunter bigint = 18500000 , @dividertrader bigint = 8000000 , @Dividercontrthiefs bigint = 60500000 , @dividerthiefs bigint = 30000000 , @dividerhunterex bigint = 8000000 , @dividertraderex bigint = 3000000 , @dividerthiefsex tinyint = 8000000 , @Charname varchar(30) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID) , @contribution int = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) , @kills int; If (@JobType = 1 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividertrader,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end -- Hunter If (@JobType = 3 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividerhunter,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end --Now for thiefs If (@JobType = 2 ) begin set @contribution = (select Contribution from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID) set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._CharNameList where CharID = @CharID) Set @Amount = (select ROUND(@contribution/@Dividerthiefs,0)) if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE()) End end
تمام
لو عاوز تغير الريود من هنا والكمية برضو د
if @amount >=1 begin Exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_ETC_SD_TOKEN_04', 5,0 Insert Into SRO_VT_LOG.dbo.RoyalCoinLogHunters (CharID,Amount,EventTime) Values (@CharID,@amount,GETDATE())
هتغير ال كود دة لى اللى انتة عاوزو وبدل 5 دى الكمية اللى انتة عاوزها
'ITEM_ETC_SD_TOKEN_04', 5,0