How to add clan war (Script)

USE [GunzDB]
GO
/****** Object:  Table [dbo].[Clans]    Script Date: 03/09/2007 21:02:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Clans](
    [CLID] [int] IDENTITY(1,1) NOT NULL,
    [Level] [int] NULL,
    [Name] [varchar](50)  NULL,
    [ClanMaster] [varchar](50)  NULL,
    [EmblemUrl] [varchar](50)  NULL,
    [TotalPoint] [int] NULL,
    [Point] [int] NULL,
    [Wins] [int] NULL,
    [Losses] [int] NULL,
    [MemberCount] [int] NULL,
    [Ranking] [int] NULL,
    [EmblemChecksum] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

USE [GunzDB]
GO
/****** Object:  Table [dbo].[WinTheClanGame]    Script Date: 03/09/2007 21:07:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WinTheClanGame](
    [ClanOne] [int] NULL,
    [ClanTwo] [int] NULL,
    [IsDraw] [int] NULL,
    [ClanOnePoint] [int] NULL,
    [ClanTwoPoint] [int] NULL,
    [ClanOneName] [nvarchar](max)  NULL,
    [ClanTwoName] [nvarchar](max)  NULL,
    [ClanOneScore] [int] NULL,
    [ClanTwoScore] [int] NULL,
    [Unknown] [int] NULL,
    [Unknown2] [int] NULL,
    [ClanOneMembers] [nvarchar](max)  NULL,
    [ClanTwoMembers] [nvarchar](max)  NULL
) ON [PRIMARY]

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spAddClanMember]    Script Date: 03/09/2007 21:10:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spAddClanMember]
    @nCLID INT,
    @nCID INT,
    @nLevel INT
AS
    DECLARE @nName varchar(50)
    SELECT @nName = Name FROM Clans WHERE CLID = @nCLID
    UPDATE Character SET ClanName = @nName, CLID = @nCLID, ClanGrade = @nLevel WHERE CID = @nCID

    DECLARE @nCount INT
    SELECT @nCount = MemberCount From Clans WHERE CLID = @nCLID
    UPDATE Clans SET MemberCount = @nCount+1 WHERE CLID = @nCLID

    SELECT 1 Ret

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spCreateClan]
    @nClanName varchar(50),
    @nMaster varchar(50),
    @nUser1 INT,
    @nUser2 INT,
    @nUser3 INT,
    @nUser4 INT
AS
    INSERT INTO Clans (Name,ClanMaster,TotalPoint,Point,Wins,Losses,MemberCount,Ranking)
    VALUES(@nClanName,@nMaster,1000,1000,0,0,5,0)

    UPDATE Character SET ClanName = @nClanName
    WHERE CID = @nMaster OR CID = @nUser1 OR CID = @nUser2 OR CID = @nUser3 OR CID = @nUser4
   
    DECLARE @nV INT
    SELECT @nV = CLID FROM Clans WHERE Name = @nClanName
    UPDATE Character SET CLID = @nV
    WHERE CID = @nMaster OR CID = @nUser1 OR CID = @nUser2 OR CID = @nUser3 OR CID = @nUser4
   
    UPDATE Character SET ClanGrade = 1 WHERE CID = @nMaster

    SELECT 1 Ret,CLID FROM Clans WHERE Name = @nClanName

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCharClan]
    @nCID INT
AS
    SELECT CLID FROM Character WHERE CID = @nCID

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetClanInfo]
    @nCLID INT
AS
    SET NOCOUNT ON;
    SELECT CLID, Level, Name, ClanMaster, TotalPoint, Point, Wins, Losses, MemberCount, Ranking, EmblemUrl, EmblemChecksum FROM Clans WHERE CLID=@nCLID
    --SELECT EmblemChecksum FROM Clans WHERE CLID=@nCLID

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCLIDFromClanName]
    @nClanName varchar(50)
AS
    SELECT CLID FROM Clans WHERE Name = @nClanName

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMember]
    @nCLID INT,
    @nCID INT
AS
    UPDATE Character SET ClanName = NULL, CLID = NULL, ClanGrade = 0 WHERE CID = @nCID

    DECLARE @nCount INT
    SELECT @nCount = MemberCount From Clans WHERE CLID = @nCLID
    UPDATE Clans SET MemberCount = @nCount-1 WHERE CLID = @nCLID

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMemberFromCharName]
    @nCLID INT,
    @nCID INT,
    @nCharName nchar(10)
AS
    UPDATE Character SET ClanName = NULL, CLID = NULL, ClanGrade = 0 WHERE CID = @nCID

    DECLARE @nCount INT
    SELECT @nCount = MemberCount From Clans WHERE CLID = @nCLID
    UPDATE Clans SET MemberCount = @nCount-1 WHERE CLID = @nCLID
   
    SELECT 1 Ret

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spUpdateCharClanContPoint]
    @nCLID INT,
    @nCID INT,
    @nContPoint INT
AS
BEGIN
    UPDATE Character SET ClanContPoint = @nContPoint WHERE CID = @nCID
END

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spUpdateClanGrade]
    @nCLID INT,
    @nCID INT,
    @nLEVEL INT
AS

    UPDATE Character SET ClanGrade = @nLEVEL WHERE CID = @nCID

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spWinTheClanGame]
    @nClanOne INT,
    @nClanTwo INT,
    @nIsDraw INT,
    @nClanOnePoint INT,
    @nClanTwoPoint INT,
    @nClanOneName nvarchar(MAX),
    @nClanTwoName nvarchar(MAX),
    @nClanOneScore INT,
    @nClanTwoScore INT,
    @nJ INT,
    @nK INT,
    @nClanOneMembers nvarchar(MAX),
    @nClanTwoMembers nvarchar(MAX)
AS
    INSERT INTO WinTheClanGame VALUES(@nClanOne,@nClanTwo,@nIsDraw,@nClanOnePoint,@nClanTwoPoint,@nClanOneName,@nClanTwoName,@nClanOneScore,@nClanTwoScore,@nJ,@nK,@nClanOneMembers,@nClanTwoMembers)
    DECLARE @nPoints INT
    SELECT @nPoints = Point FROM Clans WHERE CLID = @nClanOne
    DECLARE @nWins INT
    SELECT @nWins = Wins FROM Clans WHERE CLID = @nClanOne
    UPDATE Clans SET Point = @nPoints + 1, Wins = @nWins+1 WHERE CLID = @nClanOne
    SELECT @nPoints = Point FROM Clans WHERE CLID = @nClanTwo
    DECLARE @nLosses INT
    SELECT @nLosses = Losses FROM Clans WHERE CLID = @nClanTwo
    UPDATE Clans SET Point = @nPoints + 1, Losses = @nLosses+1 WHERE CLID = @nClanTwo