RYL 1 guild bug 2011 fix

[HeX999]

Open your winner1 database, expand the tables and look for dbo.guildinfo, right click and press design and change the default binding with dates of 2010-12-31 to 2020-10-20

than
Create a trigger at dbo.TblGuildMember add this code AND HIT execute.

USE [winner1]
GO
/****** Object:  Trigger [dbo].[updateDateNdSolve]    Script Date: 11/28/2011 02:00:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
    -- =============================================
    -- Author: <HeX , blood-shad-e,RYLU>
    -- Create date: <Create Date,,>
    -- Description: <Description,,>
    -- =============================================
    
CREATE TRIGGER [dbo].[updateDateNdSolve]
ON [dbo].[TblGuildMember]
INSTEAD of UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

declare @nCID int
declare @prev smalldatetime
declare @New smalldatetime
declare @Pos int
set @Pos = (select nPosition from inserted)
set @nCID = (select nCID from inserted)
set @New = (select tLeaveGuildTime from inserted)
if @Pos = 4
UPDATE TblGuildMember SET nPosition = @Pos, tLeaveGuildTime = @New where nCID = @nCID
else
UPDATE TblGuildMember SET nPosition = @Pos, tLeaveGuildTime = CAST('2020-10-20 00:00:00' as smalldatetime) where nCID = @nCID
END

[MentaL]

[maryjane25]

Open your winner1 database, expand the tables and look for dbo.guildinfo, right click and press design and change the default binding with dates of 2010-12-31 to 2020-10-20

than
Create a trigger at dbo.TblGuildMember add this code AND HIT execute.

USE [winner1]
GO
/****** Object:  Trigger [dbo].[updateDateNdSolve]    Script Date: 11/28/2011 02:00:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
    -- =============================================
    -- Author: <HeX , blood-shad-e,RYLU>
    -- Create date: <Create Date,,>
    -- Description: <Description,,>
    -- =============================================
    
CREATE TRIGGER [dbo].[updateDateNdSolve]
ON [dbo].[TblGuildMember]
INSTEAD of UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

declare @nCID int
declare @prev smalldatetime
declare @new smalldatetime
declare @Pos int
set @Pos = (select nPosition from inserted)
set @nCID = (select nCID from inserted)
set @new = (select tLeaveGuildTime from inserted)
if @Pos = 4
UPDATE TblGuildMember SET nPosition = @Pos, tLeaveGuildTime = @new where nCID = @nCID
else
UPDATE TblGuildMember SET nPosition = @Pos, tLeaveGuildTime = CAST('2020-10-20 00:00:00' as smalldatetime) where nCID = @nCID
END

This table for SQL2000 ? if SQL 2005 how to add it. Please advise.