I've added all Taanus Dt time stamp etc Db fixes But my dual tournament icons sword icons don't change how do i fix this?
USE [GunzDB]GO/****** Object: StoredProcedure [dbo].[spDTInsertDTTimeStamp] Script Date: 09/25/2018 15:49:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[spDTInsertDTTimeStamp] @stampType TINYINTAS BEGIN SET NOCOUNT ON; DECLARE @timeStamp CHAR(8); DECLARE @CurtimeStamp CHAR(8); DECLARE @TotalUser INT; DECLARE @RowID INT; IF( @stampType = 0 ) BEGIN -- Daily SELECT @CurtimeStamp = CONVERT( CHAR(8), GETDATE(), 112); END ELSE IF( @stampType = 1 ) BEGIN -- Weekly SELECT @CurtimeStamp = CONVERT( CHAR(8), DATEADD(dd, DATEPART(WEEKDAY, CONVERT(DATETIME, GETDATE()))*(-1)+2, CONVERT(DATETIME, GETDATE())), 112); END ELSE BEGIN RETURN; END SELECT TOP 1 @timeStamp = TimeStamp, @RowID = ID + 1 FROM DTTimeStamp(NOLOCK) ORDER BY TimeStamp DESC; IF( @timeStamp IS NULL ) BEGIN INSERT INTO DTTimeStamp(ID, TimeStamp, Closed) VALUES(1, @CurtimeStamp, 0); RETURN; END IF( @timeStamp != @CurtimeStamp ) BEGIN SELECT @TotalUser = COUNT(ci.CID) FROM DTCharacterInfo ci(NOLOCK) WHERE ci.TimeStamp = @timeStamp; UPDATE DTTimeStamp SET TotalUser = @TotalUser WHERE TimeStamp = @timeStamp; INSERT INTO DTTimeStamp(ID, TimeStamp, Closed) VALUES @RowID, @CurtimeStamp, 0) END END
Reply With Quote
Originally Posted by Slime
