Newbie Spellweaver
- Joined
- Oct 6, 2012
- Messages
- 31
- Reaction score
- 1
does anyone know why this happens?
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!USE [MiDB]
GO
/****** Object: StoredProcedure [dbo].[spUpdateGunzSystem] Script Date: 3/18/2021 6:23:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spUpdateGunzSystem]
AS
BEGIN
SET NOCOUNT ON;
/* Delete ClanMember where DeleteFlag = 2 */
DELETE FROM ClanMember WHERE CLID=(SELECT CLID FROM Clan WHERE DeleteFlag=2);
/* Update Clan where DeleteFlag = 2 */
UPDATE Clan SET Name=NULL, DeleteFlag=1, DeleteName=Name WHERE DeleteFlag=2;
/* Update Character Ranking */
EXECUTE spFetchTotalRanking;
/* Update DTTime Stamp¦ */
IF NOT EXISTS(SELECT * FROM DTTimeStamp WHERE TimeStamp=(CONVERT( CHAR(8), GETDATE(), 112))) BEGIN
EXECUTE spDTInsertDTTimeStamp 0;
END
EXECUTE spDTFetchDTRanking;
END