Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

GunZ 1.5 Dual Tournament Sword Icons don't change

Newbie Spellweaver
Joined
Sep 27, 2016
Messages
53
Reaction score
6
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
 
Back
Top