Julia guild ranking fix

[xlmansox]

-- SQL Manager 2008 for SQL Server 3.4.0.7 
-- --------------------------------------- 
-- Host      : TEST-SVR\SQLEXPRESS 
-- Database  : RANKING_DBF 
-- Version   : Microsoft SQL Server  10.0.1600.22 


CREATE DATABASE [RANKING_DBF] 
ON PRIMARY 
  ( NAME = [RANKING_DBF_Data], 
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\RANKING_DBF.MDF', 
    SIZE = 10048 KB, 
    MAXSIZE = UNLIMITED, 
    FILEGROWTH = 100 MB ) 
LOG ON 
  ( NAME = [RANKING_DBF_Log], 
    FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\RANKING_DBF_1.LDF', 
    SIZE = 10048 KB, 
    MAXSIZE = 10000 MB, 
    FILEGROWTH = 10 MB ) 
COLLATE Latin1_General_BIN 
GO 

USE [RANKING_DBF] 
GO 

-- 
-- Definition for table RANKING_TBL :  
-- 

CREATE TABLE [dbo].[RANKING_TBL] ( 
  [m_dwLogo] int NOT NULL, 
  [m_szGuild] varchar(255) COLLATE Latin1_General_BIN NOT NULL, 
  [m_szName] varchar(255) COLLATE Latin1_General_BIN NOT NULL, 
  [m_nWin] int NOT NULL, 
  [m_nLose] int NOT NULL, 
  [m_nSurrender] int NOT NULL, 
  [m_AvgLevel] float NOT NULL, 
  [m_nWinPoint] int NOT NULL, 
  [Gu] char(2) COLLATE Latin1_General_BIN CONSTRAINT [DF__GUILDSRANKIN__Gu__0519C6AF] DEFAULT 'R1' NULL, 
  [serverindex] char(2) COLLATE Latin1_General_BIN CONSTRAINT [DF__GUILDSRAN__serve__060DEAE8] DEFAULT '01' NULL, 
  [s_date] char(10) COLLATE Latin1_General_BIN NULL, 
  [m_idGuild] char(6) COLLATE Latin1_General_BIN NULL, 
  [m_MaximumUnity] float NULL, 
  [CreateTime] datetime NULL, 
  [m_nGuildGold] int NULL, 
  [m_nPlayTime] int NULL 
) 
ON [PRIMARY] 
GO 

-- 
-- Definition for stored procedure RANKING_STR :  
-- 
GO 
CREATE       PROC [dbo].RANKING_STR 
@Gu                CHAR(2) = 'R1', 
@iserverindex    CHAR(2) = '01' 
AS 
set nocount on 
DECLARE @currDate char(10),@om_nCount INT,@of_nCount INT                 
SET @currDate = CONVERT(CHAR(8),GETDATE(),112)  
                           + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)  

IF EXISTS(SELECT * FROM RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex) 
BEGIN 
    DELETE RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex 
END 

BEGIN 
INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R1',s_date = @currDate,-- m_Title = '????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
        AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority ='F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nWinPoint DESC,m_nWin DESC 



--R2 : ??? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R2',s_date = @currDate,--m_Title = '???', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
       AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nWin DESC,CreateTime 

--R3 : ??? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 

                m_szGuild, 

                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R3',s_date = @currDate,-- m_Title = '???', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
       AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nLose DESC,m_nSurrender DESC 

--R4 : ????? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R4',s_date = @currDate,-- m_Title = '?????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
       AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nSurrender DESC,m_nLose DESC 

--R5 : ????? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R5',s_date = @currDate,-- m_Title = '?????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
       AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_MaximumUnity DESC,CreateTime 

--R6 : ???? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R6',s_date = @currDate,-- m_Title = '????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),                 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
          AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nGuildGold DESC,CreateTime 

--R7 : ???? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R7',s_date = @currDate,-- m_Title = '????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0), 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
       AND A.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_AvgLevel DESC,CreateTime 

--R8 : ????? 

INSERT RANKING_DBF.dbo.RANKING_TBL 
        ( 
                Gu,    s_date, 
                serverindex, 
                m_dwLogo, 
                m_idGuild, 
                m_szGuild, 
                m_szName, 
                m_nWin, 
                m_nLose, 
                m_nSurrender, 
                m_MaximumUnity, 
                m_AvgLevel, 
                m_nGuildGold, 
                m_nWinPoint, 
                m_nPlayTime, 
                CreateTime 
        ) 
SELECT TOP 20 Gu = 'R8',s_date = @currDate,-- m_Title = '????', 
                serverindex = MAX(A.serverindex), 
                m_dwLogo = MAX(A.m_dwLogo), 
                B.m_idGuild, 
                m_szGuild = MAX(A.m_szGuild), 
                m_szName = MAX(C.m_szName), 
                m_nWin = MAX(A.m_nWin), 
                m_nLose = MAX(A.m_nLose)+    MAX(A.m_nSurrender), 
                m_nSurrender = MAX(A.m_nSurrender), 
                m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))), 
                m_AvgLevel = ISNULL(AVG(E.m_nLevel),0), 
                m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0), 
                m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0), 
                m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0), 
                CreateTime = MAX(A.CreateTime) 
    FROM CHARACTER_01_DBF.dbo.GUILD_TBL A,CHARACTER_01_DBF.dbo.GUILD_MEMBER_TBL B,CHARACTER_01_DBF.dbo.CHARACTER_TBL C,ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_01_DBF.dbo.CHARACTER_TBL E 
  WHERE A.m_idGuild = B.m_idGuild 
          AND C.serverindex = E.serverindex 
        AND C.m_idPlayer =  E.m_idPlayer 
       AND B.m_nMemberLv = 0 
       AND B.m_idPlayer = C.m_idPlayer 
        AND A.serverindex = B.serverindex 
        AND B.serverindex = C.serverindex 
        AND C.serverindex = @iserverindex 
        /* AND D.m_chLoginAuthority = 'F' */ 
        AND C.account = D.account 
  GROUP BY B.m_idGuild 
ORDER BY m_nPlayTime DESC,CreateTime 
END 

BEGIN 
    SET NOCOUNT ON; 
    SELECT * FROM dbo.RANKING_TBL 
    WHERE    Gu = @Gu 
        AND serverindex = @iserverindex 
END 
GO 

USE [master] 
GO 
/****** Object:  Database [MANAGE_DBF]    Script Date: 02/10/2010 04:29:59 ******/ 
CREATE DATABASE [MANAGE_DBF] ON  PRIMARY  
( NAME = N'MANAGE_DBF_Data', FILENAME = N'd:\DBdata\MANAGE_DBF_Data.MDF' , SIZE = 100MB , MAXSIZE = UNLIMITED, FILEGROWTH = 10MB ) 
 LOG ON  
( NAME = N'MANAGE_DBF_Log', FILENAME = N'd:\DBLogData\MANAGE_DBF_Log.LDF' , SIZE = 20MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10MB ) 
GO 
EXEC dbo.sp_dbcmptlevel @dbname=N'MANAGE_DBF', [MENTION=841155]New[/MENTION]_cmptlevel=90 
GO 
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 
begin 
EXEC [MANAGE_DBF].[dbo].[sp_fulltext_database] [MENTION=842662]Action[/MENTION] = 'enable' 
end 
GO 
ALTER DATABASE [MANAGE_DBF] SET ANSI_NULL_DEFAULT OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET ANSI_NULLS OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET ANSI_PADDING OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET ANSI_WARNINGS OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET ARITHABORT OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET AUTO_CLOSE OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET AUTO_CREATE_STATISTICS ON  
GO 
ALTER DATABASE [MANAGE_DBF] SET AUTO_SHRINK OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET AUTO_UPDATE_STATISTICS ON  
GO 
ALTER DATABASE [MANAGE_DBF] SET CURSOR_CLOSE_ON_COMMIT OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET CURSOR_DEFAULT  GLOBAL  
GO 
ALTER DATABASE [MANAGE_DBF] SET CONCAT_NULL_YIELDS_NULL OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET NUMERIC_ROUNDABORT OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET QUOTED_IDENTIFIER OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET RECURSIVE_TRIGGERS OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET  ENABLE_BROKER  
GO 
ALTER DATABASE [MANAGE_DBF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET DATE_CORRELATION_OPTIMIZATION OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET TRUSTWORTHY OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET ALLOW_SNAPSHOT_ISOLATION OFF  
GO 
ALTER DATABASE [MANAGE_DBF] SET PARAMETERIZATION SIMPLE  
GO 
ALTER DATABASE [MANAGE_DBF] SET  READ_WRITE  
GO 
ALTER DATABASE [MANAGE_DBF] SET RECOVERY SIMPLE  
GO 
ALTER DATABASE [MANAGE_DBF] SET  MULTI_USER  
GO 
ALTER DATABASE [MANAGE_DBF] SET PAGE_VERIFY TORN_PAGE_DETECTION   
GO 
ALTER DATABASE [MANAGE_DBF] SET DB_CHAINING OFF  
go 
USE [MANAGE_DBF] 
GO 
/****** Object:  View [dbo].[viwCharacter]    Script Date: 02/10/2010 04:29:39 ******/ 
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[viwCharacter]')) 
DROP VIEW [dbo].[viwCharacter] 
GO 
/****** Object:  View [dbo].[viwCharacter]    Script Date: 02/10/2010 04:29:39 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[viwCharacter]')) 
EXEC dbo.sp_executesql [MENTION=2000137629]statement[/MENTION] = N'CREATE view [dbo].[viwCharacter] 
as 
select m_idPlayer, serverindex, m_szName, account, m_nLevel, m_nJob, m_dwSex, CreateTime, isblock, '''' as ''deldate'', playerslot from CHARACTER_01_DBF.dbo.CHARACTER_TBL 
union all 
select m_idPlayer, serverindex, m_szName, account, m_nLevel, m_nJob, 9, CreateTime, ''E'', deldate, 9 from CHARACTER_01_DBF.dbo.CHARACTER_TBL_DEL' 
GO 

DNS : manage = manage_dbf

gm command = /GuildRanking

[MentaL]

[asheashia]

Will this work on v19?

[Ketchup]

Will this work on v19?

Guild ranking is completely disabled and removed from my sources, you would have to add it back.

It may work for other sources though.