![[Release]Guild Ranking](https://www.elitepvpers.com/forum/iconimages/flyff-pserver-guides-releases/release-guild-ranking_ltr.gif){kind=small}
[Fix]Guild Ranking Juria
PHP Code:
-- 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 Code:
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', @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [MANAGE_DBF].[dbo].[sp_fulltext_database] @action = '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 @statement = 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
enjoy.
