Job Point System

[gedso01]

شباب محتاج سيستم trader يكون ب ال point . كل هنا الموجودين بيدوك gold coin و sliver كده
وشكرااا

[Cru3L1337]

اتفضل حضرتك الsystem دا بيديلك Job Points وكمان لية Limits طبعا انت بتقدر تغيرها لاي حاجة انت عايزها

يلا نبدا

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  StoredProcedure [dbo].[_AddCoinUnique]    Script Date: 03/25/2017 22:43:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_AddCoinUnique]

    @Char varchar(30),
    @Point int

as

Declare @JID int;

SET @JID = (
            SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
            JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
            WHERE chart.CharName16 = @Char
            );
            
    IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
        BEGIN
            INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
        END
            
    UPDATE SK_Silk
    SET silk_gift = silk_gift + (@Point)
    WHERE JID = @JID

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[JobLog]    Script Date: 03/25/2017 22:59:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JobLog](
	[CharName] [varchar](50) NOT NULL,
	[Amount] [int] NULL,
	[Limited] [int] NULL,
	[Date] [datetime] NULL,
	[TotalAmount] [int] NULL,
 CONSTRAINT [PK_JobLog] PRIMARY KEY CLUSTERED 
(
	[CharName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

وهنضيف دي في AddLogChar

declare @contribution int;
declare @coinWinfortra int;
declare @coinWinforthi int;
declare @coinWinforhun int;
declare @dividerfortra int;
declare @dividerforthi int;
declare @dividerforhun int;
declare @charname16 varchar(16);
declare @JobType int;
declare @total int;

set @dividerfortra = 2700000;
set @dividerforthi = 9000000;
set @dividerforhun = 3000000;

if(@EventID = 9 or @EventID = 4 or @EventID = 6 or @EventID = 11) --Teleport or log out/in
	begin
		set @charname16 = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] where CharID = @CharID);
		set @contribution = (SELECT Contribution FROM [SRO_VT_SHARD].[dbo].[_CharTriJob] WHERE CharID = @CharID);
		set @coinWinfortra = ROUND( @contribution / @dividerfortra,0);
		set @coinWinforthi = ROUND (@contribution / @dividerforthi,0);
		set @coinWinforhun = ROUND (@contribution / @dividerforhun,0);
		set @JobType = (SELECT JobType FROM [SRO_VT_SHARD].[dbo].[_CharTrijob] Where CharID = @CharID);
		set @total = (select TotalAmount from JobLog where CharName = @charname16) + (select Amount from JobLog where CharName = @charname16);
		
		if(@coinWinfortra != 0 and @JobType = 1)
			begin
				if (@coinWinfortra > 5)
					begin 
						set @coinWinfortra = 5
					end
					
				if exists (select @charname16 from [SRO_VT_SHARDLOG].[dbo].[JobLog])
					begin
						if ((select Amount from JobLog where CharName = @charname16) >= 200)
							begin
								UPDATE JobLog SET Limited = 1 WHERE CharName = @charname16
							end
						else
							begin
								UPDATE [SRO_VT_SHARDLOG].[dbo].[JobLog] SET Amount = Amount + @coinWinfortra, Date = GETDATE(), TotalAmount = @total where CharName = @charname16
								exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinfortra;	 
							end
						end
					else 
						begin
							INSERT INTO [SRO_VT_SHARDLOG].[dbo].[JobLog] VALUES (@charname16, @coinWinfortra, 0, GETDATE(), @total)
							exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinfortra;
						end
					end --end trader coin

		if(@coinWinforthi != 0 and @JobType = 2)
			begin
				if (@coinWinforthi > 5)
					begin 
						set @coinWinforthi = 5
					end
					
				if exists (select @charname16 from [SRO_VT_SHARDLOG].[dbo].[JobLog])
					begin
						if ((select Amount from JobLog where CharName = @charname16) >= 200)
							begin
								UPDATE JobLog SET Limited = 1 WHERE CharName = @charname16
							end
						else
							begin
								UPDATE [SRO_VT_SHARDLOG].[dbo].[JobLog] SET Amount = Amount + @coinWinforthi, Date = GETDATE(), TotalAmount = @total where CharName = @charname16
								exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinforthi; 
							end
						end
					else 
						begin
							INSERT INTO [SRO_VT_SHARDLOG].[dbo].[JobLog] VALUES (@charname16, @coinWinforthi, 0, GETDATE(), @total)
							exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinforthi;
						end
					end --end thief coin

		if(@coinWinforhun != 0 and @JobType = 3)
			begin
				if (@coinWinforhun > 5)
					begin 
						set @coinWinforhun = 5
					end
					
				if exists (select @charname16 from [SRO_VT_SHARDLOG].[dbo].[JobLog])
					begin
						if ((select Amount from JobLog where CharName = @charname16) >= 200)
							begin
								UPDATE JobLog SET Limited = 1 WHERE CharName = @charname16
							end
						else
							begin
								UPDATE [SRO_VT_SHARDLOG].[dbo].[JobLog] SET Amount = Amount + @coinWinforhun, Date = GETDATE(), TotalAmount =  @total where CharName = @charname16
								exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinforhun; 
							end
						end
					else 
						begin
							INSERT INTO [SRO_VT_SHARDLOG].[dbo].[JobLog] VALUES (@charname16, @coinWinforhun, 0, GETDATE(), @total)
							exec [SRO_VT_ACCOUNT].[dbo].[_AddCoin] @CharID, @coinWinforhun;
						end
					end --end hunter coin
					if (@JobType != 0)
						begin
					UPDATE [SRO_VT_SHARD].[dbo].[_CharTriJob] set Contribution = 0 WHERE CharID = @CharID;
					end
			end --end coin reward
	
if (@EventID = 4)
	BEGIN
		if not exists (select CharName from JobLog where CharName = @charname16)
			BEGIN
				INSERT INTO JobLog VALUES(@charname16, 0, 0, GETDATE(), 0)
			END 
		ELSE
			BEGIN
				UPDATE JobLog SET Date = GETDATE() where CharName = @charname16
			END
		END

بعدها الtrigger الي هيعملك الreset كل اسبوع

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  Trigger [dbo].[TR_COINREWARD_JOB]    Script Date: 03/25/2017 23:06:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[TR_COINREWARD_JOB] ON [dbo].[JobLog] AFTER UPDATE
AS
BEGIN 

declare @cleared int
	
	if ((SELECT DATENAME(dw,GETDATE())) = 'Sunday' and @cleared = NULL or @cleared = 0)
		begin
			TRUNCATE TABLE JobLog
			set @cleared = 1
		end

	if ((SELECT DATENAME(dw,GETDATE())) = 'Monday' AND @cleared = 1)
		begin
			set @cleared = 0
		end
	end

Limit دلوقتي بقي عاوز تعدل ال
هتلاقية في السطر دا

if ((select Amount from JobLog where CharName = @charname16) >= 200)
							begin
								UPDATE JobLog SET Limited = 1 WHERE CharName = @charname16
							end

عاوز تغير ال Gift Silk reward
بالمناسبة هو هنا معمول 5 فقط

set @coinWinforhun = 5

[RAMBO]

##