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