Julia guild ranking fix

xlmansox · Jul 16, 2015

PHP:

-- 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

PHP:

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', [USER=841155]New[/USER]_cmptlevel=90 
GO 
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 
begin 
EXEC [MANAGE_DBF].[dbo].[sp_fulltext_database] [USER=842662]Action[/USER] = '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 [USER=2000137629]statement[/USER] = 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

xlmansox - Julia guild ranking fix - RaGEZONE Forums

asheashia · Nov 20, 2022

Will this work on v19?

Lodelight · Nov 20, 2022

asheashia said:
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.

Welcome!

Julia guild ranking fix

xlmansox

Experienced Elementalist

asheashia

Newbie Spellweaver

Lodelight

Inactive

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor