Cần cung cấp link gunz ofline (sever quest)

[Suolrock]

Tìm kiếm rất nhiều mà không thấy sever gunz (quest), bắn một mình không biết bắn với ai nữa, trong forum có ai có link sever gunz (giết quest nha) thì cho mình xin, link của anh dương đưa khơng có quest, chơi có 1 mình buồn, mong mọi người giúp đỡ nha
:63::63::63::63::63::63::63:

Xem thêm chủ đề liên quan:

• Video Hướng Dẫn Làm Gunz !!!! (10/02/2009)
• [Help] Help !!!!!!!!!!!!!!!!!!!! (19/12/2013)
• Private Server GunZ Offline + Video Guilde (24/10/2011)
• Life Gunz cho anh em ketnoitatca (16/12/2012)
• [Help] có cách nào edit server gunz không các bác (07/05/2014)
• [New Hot] Open Sever FireGunz việt nam (11/04/2015)
• Lỗi kia em fix dc rồi em còn lỗi này anh giúp em lần cuối đi anh Tuấn Dương (26/10/2013)
• Ai Làm Cho Mình Sever Gunz Online Với (01/06/2013)
• Vina Gunz Version 11 -- Đẳng cấp Game đối kháng đỉnh cao !! (14/07/2016)
• [Thảo Luận] Tâm huyết GunZ lập team Dev (31/01/2015)

[Pucca9x]

chịu thùi ^^ kakaka

[hongphuc1281441]

Các bạn ơi sau một thời gian tìm hiểu minh đã kích quest dc từ cái server cua anh Duong roi
sau day la huong dan cua minhlam bang SQL 2005 nha các bạn)
các bạn tải cái link của anh Duong về vào thư mục db xóa tất cả chừa file GunzDB2k lại và nhấp phải vào nó chọn edit sau do thay toàn bọ bàng doạn code sau:
USE [GunzDB]
GO
/****** Object: Table [dbo].[Items] Script Date: 03/10/2007 01:36:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Items](
[CID] [int] NULL,
[ItemID] [int] NULL,
[CIID] [int] IDENTITY(1,1) NOT NULL,
[RentPeriodRemainder] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Locator] Script Date: 03/10/2007 01:36:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Locator](
[ID] [int] NOT NULL,
[Players] [int] NOT NULL,
[IP] [varchar](50) NOT NULL,
[Port] [int] NOT NULL,
[Code] [int] NOT NULL,
[Time] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Accounts] Script Date: 03/10/2007 01:33:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Accounts](
[AID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](50) NOT NULL,
[Password] [varchar](50) NOT NULL,
[UGradeID] [int] NULL CONSTRAINT [DF_Accounts_UGradeID] DEFAULT ((1))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[MPLVL] Script Date: 03/10/2007 01:36:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MPLVL](
[AID] [int] NULL,
[CharacterName] [varchar](50) NULL,
[AccountName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[CharMakingLog] Script Date: 03/10/2007 01:34:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CharMakingLog](
[AID] [int] NULL,
[CharName] [varchar](32) NULL,
[Type] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Clans] Script Date: 03/10/2007 01:35:26 ******/
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] NOT NULL,
[Name] [varchar](50) NOT NULL,
[ClanMaster] [varchar](10) NOT NULL,
[EmblemURL] [varchar](100) NULL,
[TotalPoint] [int] NOT NULL,
[Point] [int] NOT NULL,
[Wins] [int] NOT NULL,
[Losses] [int] NOT NULL,
[MemberCount] [int] NOT NULL,
[Ranking] [int] NOT NULL,
[EmblemChecksum] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[LocatorLog] Script Date: 03/10/2007 01:36:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LocatorLog](
[IP] [int] NOT NULL,
[Port] [int] NOT NULL,
[Count] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[spGetCharList] Script Date: 03/10/2007 01:32:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Mythical
-- Create date: Dec 25, 2006
-- Description: Merry XMAS!
-- =============================================
CREATE PROCEDURE [dbo].[spGetCharList]
-- Add the parameters for the stored procedure here
@nAID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT Level,CharNum,Name
FROM Character
WHERE AID = @nAID
END
GO
/****** Object: StoredProcedure [dbo].[spUpdateEquipItem] Script Date: 03/10/2007 01:33:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateEquipItem]
@nCID INT,
@parts INT,
@nCIID INT,
@nItemID INT
AS
BEGIN
SET NOCOUNT ON;

IF @parts = 0
UPDATE Character
SET head_itemid = @nItemID,
head_slot = @nCIID
WHERE CID = @nCID

IF @parts = 1
UPDATE Character
SET chest_itemid = @nItemID,
chest_slot = @nCIID
WHERE CID = @nCID

IF @parts = 2
UPDATE Character
SET hands_itemid = @nItemID,
hands_slot = @nCIID
WHERE CID = @nCID

IF @parts = 3
UPDATE Character
SET legs_itemid = @nItemID,
legs_slot = @nCIID
WHERE CID = @nCID

IF @parts = 4
UPDATE Character
SET feet_itemid = @nItemID,
feet_slot = @nCIID
WHERE CID = @nCID

IF @parts = 5
UPDATE Character
SET fingerl_itemid = @nItemID,
fingerl_slot = @nCIID
WHERE CID = @nCID

IF @parts = 6
UPDATE Character
SET fingerr_itemid = @nItemID,
fingerr_slot = @nCIID
WHERE CID = @nCID

IF @parts = 7
UPDATE Character
SET melee_itemid = @nItemID,
melee_slot = @nCIID
WHERE CID = @nCID

IF @parts = 8
UPDATE Character
SET primary_itemid = @nItemID,
primary_slot = @nCIID
WHERE CID = @nCID

IF @parts = 9
UPDATE Character
SET secondary_itemid = @nItemID,
secondary_slot = @nCIID
WHERE CID = @nCID

IF @parts = 10
UPDATE Character
SET custom1_itemid = @nItemID,
custom1_slot = @nCIID
WHERE CID = @nCID

IF @parts = 11
UPDATE Character
SET custom2_itemid = @nItemID,
custom2_slot = @nCIID
WHERE CID = @nCID

Select 1 Ret
END
GO
/****** Object: StoredProcedure [dbo].[spGetAccountCharInfo] Script Date: 03/10/2007 01:32:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetAccountCharInfo]
@nAID INT,
@nCharIndex INT
AS
BEGIN
SET NOCOUNT ON;

SELECT custom2_itemid, custom1_itemid, secondary_itemid, primary_itemid, melee_itemid, fingerr_itemid, fingerl_itemid, feet_itemid, legs_itemid, hands_itemid, chest_itemid, head_itemid, BP, XP, Face, Hair, Sex, Level, CharNum, ClanName, Name
FROM Character
WHERE AID = @nAID AND CharIndex = @nCharIndex
END
GO
/****** Object: StoredProcedure [dbo].[spDeleteChar] Script Date: 03/10/2007 01:32:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spDeleteChar]
@nAID INT,
@nCharIndex INT,
@szCharName nvarchar(32)
AS
BEGIN
SET NOCOUNT ON;

DECLARE @Ret INT
SELECT @Ret =
COUNT
FROM Character
WHERE Name = @szCharName AND CharIndex = @nCharIndex AND AID = @nAID

IF @Ret != 0
DELETE
FROM Character
WHERE Name = @szCharName AND CharIndex = @nCharIndex AND AID = @nAID

SELECT @Ret Ret

END
GO
/****** Object: StoredProcedure [dbo].[spGetCharInfoByCharNum] Script Date: 03/10/2007 01:32:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetCharInfoByCharNum]
@nAID INT,
@nCharIndex INT
AS
BEGIN
SET NOCOUNT ON;

SELECT custom2_slot,custom1_slot,secondary_slot,primary_s lot,melee_slot,fingerl_slot,fingerr_slot,feet_slot ,legs_slot,hands_slot,chest_slot,head_slot,ClanCon tPoint,ClanGrade,ClanName,CLID,PlayTime,DeathCount ,KillCount,CharNum,WR,ER,CR,FR,AP,HP,BP,XP,Face,Ha ir,Sex,Level,Name,CID
FROM Character
WHERE AID = @nAID AND CharIndex = @nCharIndex
END
GO
/****** Object: StoredProcedure [dbo].[spUpdateCharLevel] Script Date: 03/10/2007 01:33:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharLevel]
@nLevel INT,
@nCID INT
AS
BEGIN
SET NOCOUNT ON;

UPDATE Character
SET Level = @nLevel
WHERE CID = @nCID
END
GO
/****** Object: StoredProcedure [dbo].[spUpdateCharBP] Script Date: 03/10/2007 01:33:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharBP]
@nBP INT,
@nCID INT
AS
BEGIN
SET NOCOUNT ON;

UPDATE Character
SET BP = @nBP
WHERE CID = @nCID
END
GO
/****** Object: StoredProcedure [dbo].[spUpdateCharPlayTime] Script Date: 03/10/2007 01:33:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharPlayTime]
@nPlayTime INT,
@nCID INT
AS
UPDATE Character
SET PlayTime = @nPlayTime
WHERE CID = @nCID
GO
/****** Object: StoredProcedure [dbo].[spGetFriendList] Script Date: 03/10/2007 01:32:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetFriendList]
@CID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT Name, Favorite, FriendCID
FROM Friend
WHERE CID = @CID
END
GO
/****** Object: StoredProcedure [dbo].[spAddFriend] Script Date: 03/10/2007 01:32:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spAddFriend]
@nCID INT,
@nFriendCID INT,
@nFavorite INT
AS
BEGIN
DECLARE @Ret INT
SELECT @Ret = COUNT
FROM Friend
WHERE CID = @nCID AND FriendCID = @nFriendCID

DECLARE @nName NVARCHAR(4000)
SELECT @nFriendCID = CID, @nName = Name
FROM Character
WHERE CID = @nFriendCID

IF @Ret = 0
INSERT INTO Friend
VALUES(@nCID,@nFriendCID,@nFavorite,@nName)

SELECT @Ret Ret

END
GO
/****** Object: StoredProcedure [dbo].[spRemoveFriend] Script Date: 03/10/2007 01:32:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spRemoveFriend]
@nCID INT,
@nFriendCID INT
AS
DELETE
FROM Friend
WHERE CID = @nCID AND FriendCID = @nFriendCID
GO
/****** Object: StoredProcedure [dbo].[spUpdateServerStatus] Script Date: 03/10/2007 01:33:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateServerStatus]
@CurrPlayer INT,
@ServerID INT
AS
UPDATE ServerStatus
SET CurrPlayer = @CurrPlayer
WHERE ServerID = @ServerID
GO
/****** Object: Table [dbo].[InsertServerLog] Script Date: 03/10/2007 01:36:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InsertServerLog](
[ID1] [varchar](50) NOT NULL,
[ID2] [varchar](50) NOT NULL,
[ID3] [varchar](50) NOT NULL,
[ID4] [varchar](50) NOT NULL,
[ID5] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Friend] Script Date: 03/10/2007 01:35:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Friend](
[CID] [int] NULL,
[FriendCID] [int] NULL,
[Favorite] [int] NULL,
[Name] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[spCreateClan] Script Date: 03/10/2007 01:32:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spCreateClan]
@zClanName varchar(15),
@nMasterCID int,
@nMember1CID int,
@nMember2CID int,
@nMember3CID int,
@nMember4CID int
AS
--Get the name of the clan.
DECLARE @nNameofMaster varchar(10)
SELECT @nNameofMaster = Name FROM Character WHERE CID = @nMasterCID
--Add the clan to the database.
INSERT INTO Clans
VALUES(0,LTRIM(RTRIM(@zClanName)),@nNameofMaster,N ULL,0,0,0,0,5,0,NULL)
--Request the clan id.
DECLARE @nV INT
SELECT @nV = CLID FROM Clans WHERE Name = LTRIM(RTRIM(@zClanName))
--Update the ClanMaster And all 4 members to be in the crew.
UPDATE Character SET ClanName = LTRIM(RTRIM(@zClanName)), CLID = @nV WHERE CID = @nMasterCID OR CID = @nMember1CID OR CID = @nMember2CID OR CID = @nMember3CID OR CID = @nMember4CID
--Update the ClanMaster to be the ClanMaster in the database.
UPDATE Character SET ClanGrade = 1 WHERE CID = @nMasterCID
BEGIN
SET NOCOUNT ON;
--Request the clanid i guess for the server?
DECLARE @nCLID int
SELECT @nCLID = CLID
FROM Clans
WHERE Name = LTRIM(RTRIM(@zClanName))
SELECT @nCLID Ret, @nCLID NewCLID
END
GO
/****** Object: StoredProcedure [dbo].[spGetCharClan] Script Date: 03/10/2007 01:32:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCharClan]
@nCID INT
AS
SELECT CLID From Character WHERE CID = @nCID
GO
/****** Object: Table [dbo].[InsertGameLog] Script Date: 03/10/2007 01:35:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InsertGameLog](
[Game] [varchar](32) NULL,
[Map] [varchar](32) NULL,
[GameType] [varchar](32) NULL,
[Rounds] [varchar](32) NULL,
[How Many Rounds Played] [varchar](32) NULL,
[TotalUsers] [varchar](32) NULL,
[Users] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[spGetClanInfo] Script Date: 03/10/2007 01:32:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetClanInfo]
@CLID INT
AS
DECLARE @CLANLEVEL INT
DECLARE @CLANNAME VARCHAR(20)
DECLARE @CLANMASTER VARCHAR(20)
DECLARE @EMBLEMURL VARCHAR(20)
DECLARE @TOTALPOINT INT
DECLARE @POINT INT
DECLARE @WINS INT
DECLARE @LOSSES INT
DECLARE @MEMBERCOUNT INT
DECLARE @RANKING INT
DECLARE @EMBLEMCHECKSUM VARCHAR(20)
SELECT @CLID = CLID, @CLANLEVEL=LEVEL, @CLANNAME="NAME", @CLANMASTER="CLANMASTER", @EMBLEMURL="EMBLEMURL", @TOTALPOINT=TOTALPOINT, @POINT=POINT, @WINS = WINS, @LOSSES = LOSSES, @MEMBERCOUNT = MEMBERCOUNT, @RANKING = RANKING, @EMBLEMCHECKSUM = EMBLEMCHECKSUM FROM CLANS WHERE CLID = @CLID
BEGIN
SELECT @CLID CLID, 1 Level, @CLANMASTER ClanMaster, '' EmblemURL, @TOTALPOINT TotalPoint , @POINT Point, @WINS Wins, @LOSSES Losses, @MEMBERCOUNT MemberCount, @RANKING Ranking, '@EMBLEMCHECKSUM' EmblemCheckSum
END
GO
/****** Object: StoredProcedure [dbo].[spGetCLIDFromClanName] Script Date: 03/10/2007 01:32:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetCLIDFromClanName]
@nClanName varchar(10)
AS
SELECT CLID From Clans WHERE Name = @nClanName
GO
/****** Object: StoredProcedure [dbo].[spUpdateClanGrade] Script Date: 03/10/2007 01:33:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spUpdateClanGrade]
@nCLID INT,
@nCID INT,
@nLEVEL INT
AS

UPDATE Character SET ClanGrade = @nLEVEL WHERE CID = @nCID
GO
/****** Object: Table [dbo].[PlayerLog] Script Date: 03/10/2007 01:36:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PlayerLog](
[CID] [int] NULL,
[PlayTime] [int] NULL,
[KillCount] [int] NULL,
[DeathCount] [int] NULL,
[EXPEarned] [int] NULL,
[TotalEXP] [int] NULL
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[spTeam4WinTheGame] Script Date: 03/10/2007 01:33:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spTeam4WinTheGame]
@nCLID INT,
@nTID INT,
@nUser1 INT,
@nUser2 INT,
@nUser3 INT,
@nUser4 INT
AS

--UPDATE Clans SET Wins = Wins+1 WHERE CLID = @nCLID
GO
/****** Object: StoredProcedure [dbo].[spInsertCharMakingLog] Script Date: 03/10/2007 01:32:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertCharMakingLog]
@nAID INT,
@nCharName varchar(32),
@nType varchar(32)
AS
--Add new log infomation to db.
INSERT INTO CharMakingLog VALUES(@nAID,@nCharName,@nType)
GO
/****** Object: Table [dbo].[KillLog] Script Date: 03/10/2007 01:36:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KillLog](
[KillerID] [int] NULL,
[KilledID] [int] NULL
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[spUpdateCharClanContPoint] Script Date: 03/10/2007 01:33:11 ******/
SET ANSI_NULLS ON
GO
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
GO
/****** Object: Table [dbo].[LevelUpLog] Script Date: 03/10/2007 01:36:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LevelUpLog](
[A] [int] NULL,
[B] [int] NULL,
[C] [int] NULL,
[D] [int] NULL,
[E] [int] NULL,
[F] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[ConnLog] Script Date: 03/10/2007 01:35:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConnLog](
[AID] [int] NULL,
[IPString1] [int] NULL,
[IPString2] [int] NULL,
[IPString3] [int] NULL,
[IPString4] [int] NULL,
[Alert] [nchar](32) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[LadderTeam] Script Date: 03/10/2007 01:36:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LadderTeam](
[TID] [int] IDENTITY(1,1) NOT NULL,
[CLID] [int] NOT NULL,
[User1] [int] NOT NULL,
[User2] [int] NOT NULL,
[User3] [int] NULL,
[User4] [int] NULL
) ON [PRIMARY]
GO
/****** Object: StoredProcedure [dbo].[spSelectCharQuestItemInfoByCID] Script Date: 03/10/2007 01:33:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectCharQuestItemInfoByCID]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

SELECT QuestItemInfo FROM Character Where CID = @nCID

END
GO
/****** Object: Table [dbo].[ClanLog] Script Date: 03/10/2007 01:35:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ClanLog](
[WinnerCLID] [int] NULL,
[LoserCLID] [int] NULL,
[IsDrawGame] [int] NULL,
[WinnerPoint] [int] NULL,
[LoserPoint] [int] NULL,
[WinnerClanName] [varchar](max) NULL,
[LoserClanName] [varchar](max) NULL,
[RoundWins] [int] NULL,
[RoundLosses] [int] NULL,
[MapID] [int] NULL,
[GameType] [int] NULL,
[WinnerMembers] [varchar](max) NULL,
[LoserMembers] [varchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[spGetCharInfoByAID] Script Date: 03/10/2007 01:32:34 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetCharInfoByAID]
@nAID INT
AS
BEGIN
SELECT custom2_slot,custom1_slot,secondary_slot,primary_s lot,melee_slot,fingerl_slot,fingerr_slot,feet_slot ,legs_slot,hands_slot,chest_slot,head_slot,ClanCon tPoint,ClanGrade,ClanName,CLID,PlayTime,DeathCount ,KillCount,CharNum,WR,ER,CR,FR,AP,HP,BP,XP,Face,Ha ir,Sex,Level,Name,CID
FROM Character
WITH (nolock)
WHERE AID = @nAID
END
GO
/****** Object: Table [dbo].[ConnectionLog] Script Date: 03/10/2007 01:35:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ConnectionLog](
[AccountName] [varchar](50) NULL,
[Date] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ItemPurchaseLog] Script Date: 03/10/2007 01:36:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ItemPurchaseLog](
[A] [int] NULL,
[B] [int] NULL,
[C] [int] NULL,
[D] [int] NULL,
[E] [nchar](32) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[CountryCode] Script Date: 03/10/2007 01:35:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CountryCode](
[IPFrom] [varchar](50) NULL,
[IPTo] [varchar](50) NULL,
[CountryCode3] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[LocatorStatus] Script Date: 03/10/2007 01:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LocatorStatus](
[LocatorID] [int] NULL,
[IP] [nvarchar](4000) NOT NULL,
[Port] [int] NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](4000) NULL,
[SendUDP] [varchar](4000) NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[spSelectAccountItem] Script Date: 03/10/2007 01:33:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectAccountItem]
@AID INT
AS
BEGIN

SELECT RentPeriodRemainder,AIID,ItemID
FROM
AccountItems
WHERE AID = @AID
END
GO
/****** Object: Table [dbo].[Character] Script Date: 03/10/2007 01:34:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[AID] [int] NULL,
[Name] [varchar](10) NULL,
[CharIndex] [int] NULL,
[Level] [int] NULL,
[Sex] [int] NULL,
[Costume] [int] NULL,
[Face] [int] NULL,
[Hair] [int] NULL,
[ClanName] [varchar](16) NULL,
[XP] [int] NULL,
[BP] [money] NULL,
[head_itemid] [int] NULL,
[chest_itemid] [int] NULL,
[hands_itemid] [int] NULL,
[legs_itemid] [int] NULL,
[feet_itemid] [int] NULL,
[fingerl_itemid] [int] NULL,
[fingerr_itemid] [int] NULL,
[melee_itemid] [int] NULL,
[primary_itemid] [int] NULL,
[secondary_itemid] [int] NULL,
[custom1_itemid] [int] NULL,
[custom2_itemid] [int] NULL,
[CharNum] [int] NULL,
[CID] [int] IDENTITY(1,1) NOT NULL,
[HP] [int] NULL,
[AP] [int] NULL,
[FR] [int] NULL,
[CR] [int] NULL,
[ER] [int] NULL,
[WR] [int] NULL,
[KillCount] [int] NULL,
[DeathCount] [int] NULL,
[PlayTime] [int] NULL,
[CLID] [int] NULL,
[ClanGrade] [int] NULL,
[ClanContPoint] [int] NULL,
[head_slot] [int] NULL,
[chest_slot] [int] NULL,
[hands_slot] [int] NULL,
[legs_slot] [int] NULL,
[feet_slot] [int] NULL,
[fingerl_slot] [int] NULL,
[fingerr_slot] [int] NULL,
[melee_slot] [int] NULL,
[primary_slot] [int] NULL,
[secondary_slot] [int] NULL,
[custom1_slot] [int] NULL,
[custom2_slot] [int] NULL,
[QuestItemInfo] [nvarchar](max) NULL,
[LastActive] [datetime] NULL,
[LevelTime] [datetime] NULL,
[PLvlCount] [int] NOT NULL CONSTRAINT [DF_Character_PLvlCount] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[BanTable] Script Date: 03/10/2007 01:33:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BanTable](
[AID] [int] NULL,
[AccountName] [varchar](50) NULL,
[CharacterName] [varchar](50) NULL,
[Reason] [varchar](50) NULL,
[Admin] [varchar](50) NULL,
[Action] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[AccountItems] Script Date: 03/10/2007 01:33:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AccountItems](
[AID] [int] NULL,
[ItemID] [int] NULL,
[AIID] [int] IDENTITY(1,1) NOT NULL,
[RentPeriodRemainder] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[BlockCountryCode] Script Date: 03/10/2007 01:33:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BlockCountryCode](
[IPFrom] [varchar](4000) NULL,
[IPTo] [varchar](4000) NULL,
[CountryCode3] [varchar](4000) NULL,
[RoutingURL] [varchar](4000) NULL,
[IsBlock] [int] NULL,
[Comment] [varchar](4000) NULL,
[code] [varchar](4000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ServerStatus] Script Date: 03/10/2007 01:37:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
[ServerID] [int] NULL,
[ServerName] [nvarchar](32) NULL,
[PlayerCount] [int] NULL,
[MaxPlayer] [int] NULL,
[CurrPlayer] [int] NULL,
[Time] [datetime] NULL,
[IP] [varchar](50) NULL,
[Port] [int] NULL,
[Opened] [varchar](50) NULL,
[StatusTime] [int] NULL,
[UpdateTime] [int] NULL,
[RecvUDP] [varchar](max) NULL,
[SendUDP] [varchar](max) NULL,
[BlockUDP] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[QuestGameLog] Script Date: 03/10/2007 01:37:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QuestGameLog](
[StageName] [varchar](max) NULL,
[ScenarioID] [int] NULL,
[MasterCID] [int] NULL,
[Player1] [int] NULL,
[Player2] [int] NULL,
[Player3] [int] NULL,
[TotalRewardQItemCount] [int] NULL,
[ElapsedPlayTime] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[spUpdateCharInfoData] Script Date: 03/10/2007 01:33:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateCharInfoData]
@nAddedXP BIGINT,
@nAddedBP BIGINT,
@nAddedKillCount INT,
@nAddedDeathCount INT,
@nCID INT
AS

DECLARE @CurrTime datetime
DECLARE @DATEDIFF INT
DECLARE @OldTime datetime
DECLARE @AID INT
DECLARE @Count INT
DECLARE @AccountName varchar(50)
DECLARE @CharacterName varchar(50)

SET NOCOUNT ON;

-- //BEGIN POWERLEVEL AUTOBAN//

SELECT @OldTime = (SELECT LevelTime FROM Character WHERE CID = @nCID)
SELECT @CurrTime = getdate()
SELECT @DATEDIFF = DATEDIFF(second, @CurrTime, @OldTime)

-- =============================================
-- Author: Mackintosh www.daemonsring.net
-- Description: This piece of code will autoban powerlevelers
-- depending on how fast they kill/die by creating timestamps
-- between deaths.
-- =============================================

-- If player, kills someone within under 2 seconds enter if statement.
IF((abs(@DATEDIFF)) < 5)
BEGIN
UPDATE Character
SET @Count = PlvlCount = PlvlCount+1,
LevelTime = @CurrTime
WHERE CID = @nCID

-- If player has killed 5 people in under 2 seconds, autoban.
IF(@Count > 5)
BEGIN
SELECT @AID=AID FROM Character
WHERE CID = @nCID
SELECT @AccountName=UserID FROM Accounts
WHERE AID=@AID

SELECT @CharacterName=Name FROM Character
WHERE CID=@nCID

INSERT INTO MPLVL (Aid,AccountName,CharacterName)
VALUES(@AID,@AccountName,@CharacterName)
--UPDATE BanTable
--SET AID = @AID,
--AccountName = @AccountName,
--CharacterName = @CharacterName,
--Reason = @Reason,
--Admin = @Admin,
--Action = @Action
END
END
-- //END POWERLEVL AUTOBAN//

ELSE
BEGIN
UPDATE Character
SET XP = XP+@nAddedXP,
BP = BP+@nAddedBP,
KillCount = KillCount+@nAddedKillCount,
DeathCount = DeathCount+@nAddedDeathCount,
PlvlCount = 0,
LevelTime = @CurrTime

WHERE CID = @nCID

END
GO
/****** Object: StoredProcedure [dbo].[spSellBountyItem] Script Date: 03/10/2007 01:33:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSellBountyItem]
@nCID INT,
@nItemID INT,
@nCIID INT,
@nPrice INT,
@nCharBP INT
AS
BEGIN
SET NOCOUNT ON;

DELETE FROM Items
WHERE CID = @nCID AND ItemID = @nItemID

UPDATE Character SET BP = BP + @nPrice
Select 1 Ret
END
GO
/****** Object: StoredProcedure [dbo].[spSelectCharItem] Script Date: 03/10/2007 01:33:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spSelectCharItem]
@CID INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = 108512564.0000
SELECT RentPeriodRemainder,CIID,ItemID
FROM
Items
WHERE CID = @CID
END
GO
/****** Object: StoredProcedure [dbo].[spBuyBountyItem] Script Date: 03/10/2007 01:32:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;

UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID
INSERT INTO Items
VALUES(@nCID,@nItemID,NULL)
SELECT 0 OrderCIID



END
GO
/****** Object: StoredProcedure [dbo].[spBringBackAccountItem] Script Date: 03/10/2007 01:32:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBringBackAccountItem]
-- Add the parameters for the stored procedure here
@nAID INT,
@nCID INT,
@nCIID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

DECLARE @nItemID INT
SELECT @nItemID=ItemID
FROM Items
WHERE CID = @nCID AND CIID = @nCIID

DELETE FROM Items
WHERE CID = @nCID AND CIID = @nCIID AND ItemID = @nItemID

INSERT INTO AccountItems VALUES (@nAID, @nItemID, NULL)

END
GO
/****** Object: StoredProcedure [dbo].[spBringAccountItem] Script Date: 03/10/2007 01:32:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spBringAccountItem]
-- Add the parameters for the stored procedure here
@nAID INT,
@nCID INT,
@nAIID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

DECLARE @nItemID INT
SELECT @nItemID=ItemID
FROM AccountItems
WHERE AID = @nAID AND AIID = @nAIID

DELETE FROM AccountItems
WHERE AID = @nAID AND AIID = @nAIID AND ItemID = @nItemID

INSERT INTO Items VALUES (@nCID, @nItemID, NULL)
SELECT 0 As OrderCIID, @nItemID As ItemID

END
GO
/****** Object: StoredProcedure [dbo].[spInsertCharItem] Script Date: 03/10/2007 01:32:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertCharItem]
@nItemID INT,
@nCID INT,
@nRentPeriodRemainder INT
AS
BEGIN
INSERT INTO Items (CID,ItemID, RentPeriodRemainder) VALUES
(@nCID,@nItemID, @nRentPeriodRemainder)
END
--maybe it just that. we can see there
GO
/****** Object: StoredProcedure [dbo].[spClearAllEquipedItem] Script Date: 03/10/2007 01:32:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spClearAllEquipedItem]
@nCharID INT
AS
DELETE FROM Items
WHERE CID = @nCharID
GO
/****** Object: StoredProcedure [dbo].[spGetLoginInfo] Script Date: 03/10/2007 01:32:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetLoginInfo]
@szAccountName varchar(50)
AS
BEGIN
SET NOCOUNT ON;

SELECT AID, Password
FROM Accounts
WHERE UserID = @szAccountName
END
GO
/****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 03/10/2007 01:32:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetAccountInfo]
@nAID INT
AS
BEGIN
SET NOCOUNT ON;

SELECT AID,UGradeID,UserID
FROM Accounts
WHERE AID = @nAID
END
GO
/****** Object: StoredProcedure [dbo].[spInsertServerLog] Script Date: 03/10/2007 01:32:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertServerLog]
@test int,
@test2 int,
@test3 int,
@test4 int,
@test5 int
AS

INSERT INTO InsertServerLog (ID1,ID2,ID3,ID4,ID5)VALUES(@test,@test2,@test3,@t est4,@test5)
GO
/****** Object: StoredProcedure [dbo].[spInsertGameLog] Script Date: 03/10/2007 01:32:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertGameLog]
@Game varchar(32),
@Map varchar(32),
@GameType varchar(32),
@Rounds varchar(32),
@Users varchar(32),
@TotalUsers varchar(32),
@NickName varchar(32)
AS
INSERT INTO InsertGameLog
VALUES(@Game,@Map,@GameType,@Rounds,@Users,@TotalU sers,@NickName)
GO
/****** Object: StoredProcedure [dbo].[spInsertPlayerLog] Script Date: 03/10/2007 01:32:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertPlayerLog]
@nCID INT,
@nPlayTime INT,
@nKillCount INT,
@nDeathCount INT,
@nEXPEarned INT,
@nTotalEXP INT
AS
BEGIN
INSERT INTO PlayerLog
VALUES(@nCID,@nPlayTime,@nKillCount,@nDeathCount,@ nEXPEarned,@nTotalEXP)
END
GO
/****** Object: StoredProcedure [dbo].[spInsertConnLog] Script Date: 03/10/2007 01:32:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertConnLog]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE INT,
@nF varchar(32)
AS
BEGIN
INSERT INTO ConnLog
VALUES(@nA,@nB,@nC,@nD,@nE,@nF)
END
GO
/****** Object: StoredProcedure [dbo].[spGetLadderTeamMemberByCID] Script Date: 03/10/2007 01:32:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- CALL spGetLadderTeamMemberByCID (%d) // CharID
CREATE PROC [dbo].[spGetLadderTeamMemberByCID]
@nCID INT
AS
BEGIN
SELECT TID From LadderTeam WHERE User1 = @nCID or User2 = @nCID or User3 = @nCID or User4 = @nCID
END
GO
/****** Object: StoredProcedure [dbo].[spGetTeamID4] Script Date: 03/10/2007 01:32:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetTeamID4]
@nUser1 INT,
@nUser2 INT,
@nUser3 INT,
@nUser4 INT
AS
BEGIN
DECLARE @nCLID INT
SELECT @nCLID = CLID From Character WHERE CID = @nUser1
INSERT INTO LadderTeam (CLID, User1, User2, User3, User4) VALUES (@nCLID, @nUser1, @nUser2, @nUser3, @nUser4)
END
GO
/****** Object: StoredProcedure [dbo].[spInsertLevelUpLog] Script Date: 03/10/2007 01:32:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertLevelUpLog]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE INT,
@nF INT
AS
BEGIN
INSERT INTO LevelUpLog
VALUES(@nA,@nB,@nC,@nD,@nE,@nF)
END
GO
/****** Object: StoredProcedure [dbo].[spUpdateLastConnDate] Script Date: 03/10/2007 01:33:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--- CALL spUpdateLastConnDate ('%s', '%s') // AccountName, Date

CREATE PROC [dbo].[spUpdateLastConnDate]
@nAccountName varchar(10),
@nDate INT
AS

INSERT INTO ConnectionLogDate
VALUES(@nAccountName,@nDate)
GO
/****** Object: StoredProcedure [dbo].[spWinTheClanGame] Script Date: 03/10/2007 01:33:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spWinTheClanGame]
@nWinnerCLID INT,
@nLoserCLID INT,
@bIsDrawGame INT,
@nWinnerPoint INT,
@nLoserPoint INT,
@szWinnerClanName varchar(MAX),
@szLoserClanName varchar(MAX),
@nRoundWins INT,
@nRoundLosses INT,
@nMapID INT,
@nGameType int,
@szWinnerMembers varchar(MAX),
@szLoserMembers varchar(MAX)
AS
BEGIN
-- Update Losses/Wins + Points.
UPDATE Clans SET Wins = Wins + 1, TotalPoint = TotalPoint+@nWinnerPoint, Point = @nWinnerPoint WHERE CLID = @nWinnerCLID
UPDATE Clans SET Losses = Losses + 1, TotalPoint = TotalPoint+@nLoserPoint, Point = @nLoserPoint WHERE CLID = @nLoserCLID
-- Insert data into ClanLog.
INSERT INTO ClanLog VALUES(@nWinnerCLID,@nLoserCLID,@bIsDrawGame,@nWin nerPoint,@nLoserPoint,@szWinnerClanName,@szLoserCl anName,@nRoundWins,@nRoundLosses,@nMapID,@nGameTyp e,@szWinnerMembers,@szLoserMembers)
END
GO
/****** Object: StoredProcedure [dbo].[spInsertItemPurchaseLogByBounty] Script Date: 03/10/2007 01:32:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spInsertItemPurchaseLogByBounty]
@nA INT,
@nB INT,
@nC INT,
@nD INT,
@nE varchar(32)
AS
BEGIN
DECLARE @dbLOG INT
SELECT @dbLOG=ServerLog FROM DBSettings
if @dbLOG=1
INSERT INTO ItemPurchaseLog
VALUES (@nA,@nB,@nC,@nD,@nE)
END
GO
/****** Object: StoredProcedure [dbo].[spRemoveClanMemberFromCharName] Script Date: 03/10/2007 01:32:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMemberFromCharName]
@nCLID INT,
@nEvilPersonWhoKickedYou INT,
@nCharName varchar(10)


AS
DECLARE @nU varchar(10)
SELECT @nU = ClanMaster FROM Clans WHERE CLID = @nCLID
-- Check if user aint owner of clan.
IF NOT @nCharName = @nU
BEGIN
-- Remove user from clan.
UPDATE Character SET ClanGrade = 0, ClanName = NULL,CLID = NULL WHERE Name = @nCharName
-- Set clan member count -1
UPDATE Clans SET MemberCount = MemberCount - 1 WHERE CLID = @nCLID
SELECT @nCLID RET
END
GO
/****** Object: StoredProcedure [dbo].[spReserveCloseClan] Script Date: 03/10/2007 01:33:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spReserveCloseClan]
@nCLID INT,
@nClanName varchar(15),
@nMasterCID INT
AS
BEGIN
-- Delete clan from db.
DELETE FROM Clans WHERE CLID = @nCLID
-- Remove clan members.
UPDATE Character SET ClanName = NULL, ClanGrade = 0, CLID = 0 WHERE CLID = @nCLID
END
GO
/****** Object: StoredProcedure [dbo].[spAddClanMember] Script Date: 03/10/2007 01:32:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spAddClanMember]
@nCLID INT,
@nJoinerCID INT,
@nClanGrade INT
AS
--Request the clanname from the database by using the clanid.
DECLARE @nCNAME varchar(15)
SELECT @nCNAME = Name From Clans WHERE CLID = @nCLID
--Update the play to be part of the clan and give him the correct grade/level.
UPDATE Character SET CLID = @nCLID, ClanGrade = @nClanGrade, ClanName = @nCNAME
WHERE CID = @nJoinerCID
--Update the clan to have 1 more member.
UPDATE Clans SET MemberCount = MemberCount + 1
WHERE CLID = @nCLID
--Return the clanid to the server.
SELECT 1 Ret
GO
/****** Object: StoredProcedure [dbo].[spRemoveClanMember] Script Date: 03/10/2007 01:32:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spRemoveClanMember]
@nCLID INT,
@nCID INT
AS
BEGIN
--Set user clan less.
UPDATE Character SET ClanGrade = 0, CLID = NULL, ClanName = NULL WHERE CID = @nCID
--Set clanmember count -1.
UPDATE Clans SET MemberCount = MemberCount - 1 WHERE CLID = @nCLID
--Return clan id to server.
SELECT 1 Ret
END
GO
/****** Object: StoredProcedure [dbo].[spInsertChar] Script Date: 03/10/2007 01:32:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace ,@nHair,NULL,0,99999999,0,0,0,0,0,0,0,0,0,0,0,0,@c nt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,NULL,getdate(),getdate(),0)
END
GO
/****** Object: StoredProcedure [dbo].[spStartUpLocatorStatus] Script Date: 03/10/2007 01:33:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spStartUpLocatorStatus]
@nLocatorID int,
@dwIP nvarchar(4000),
@nPort int,
@nStatusTime varchar(4000)
AS
DELETE FROM LocatorStatus
INSERT INTO LocatorStatus (LocatorID,IP,Port,StatusTime) VALUES (@nLocatorID,@dwIP,@nPort,@nStatusTime)
GO
/****** Object: StoredProcedure [dbo].[spUpdateLocatorStatus] Script Date: 03/10/2007 01:33:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@nLocatorID INT,
@RecvUDP VARCHAR,
@SendUDP VARCHAR,
@BlockUDP INT,
@UpdateTime INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE LocatorStatus
SET RecvUDP = @RecvUDP, SendUDP = @SendUDP, BlockUDP = @BlockUDP, UpdateTime = @UpdateTime
WHERE LocatorID = @nLocatorID
END
GO
/****** Object: StoredProcedure [dbo].[spGetIPCountryCode] Script Date: 03/10/2007 01:32:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetIPCountryCode]
AS
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
GO
/****** Object: StoredProcedure [dbo].[spGetIPtoCountryList] Script Date: 03/10/2007 01:32:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryList]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO
/****** Object: StoredProcedure [dbo].[spGetIPtoCountryCode] Script Date: 03/10/2007 01:32:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryCode]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO
/****** Object: StoredProcedure [dbo].[spInsertQuestGameLog] Script Date: 03/10/2007 01:32:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spInsertQuestGameLog]
@pszStagename varchar(max),
@nScenarioID INT,
@nMasterCID INT,
@nPlayer1 INT,
@nPlayer2 INT,
@nPlayer3 INT,
@nTotalRewardQItemCount INT,
@nElapsedPlayTime INT
AS
BEGIN
INSERT INTO QuestGameLog
(StageName,ScenarioID,MasterCID,Player1,Player2,Pl ayer3,TotalRewardQItemCount,ElapsedPlayTime)VALUES (@pszStagename,@nScenarioID,@nMasterCID,@nPlayer1, @nPlayer2,@nPlayer3,@nTotalRewardQItemCount,@nElap sedPlayTime)
SELECT 0 ORDERQGLID
END
GO

[hongphuc1281441]

tải các phần mềm sau:
MsSQL 2005 Express Edition


Code:

MsSQL Server Managment Studio và tìm msxml6 tải về lun

Code:

.NET Framework 2.0

Code:

Bước 1 :cài MSSQL 2005
luu ý cài .NET Framework 2.0 truóc khi cài SQL
- Chạy Install MsSQL Server 2005 Express Edition cư nhấn nẽt cho tới khi đến bảng Feature Selection
- Nhấn Client Components và chọn Entire Feature will be installed on local hard drive
- Nhấn Next tiếp tục cho đến bảng chọn giữa "SQL Server Authentication" và "Windows Authentication"
- Chọn SQL Server Authentication và nhập mật mà cho sasa
- Cứ tiếp tục nhấn next cho đến khi cài xong
- cài msxml6 nhấn next dến kết thúc
- MsSQL Server Managment Studio thì chỉ cần nhấn Next cho đến khi cài xong

Bước 2 : Tạo DB
- Vào Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express
- Bạn sẽ thấy một bảng kết nối: copy dong sever name lại

- Vào Databases, nhấp phài, chọn New Database:

- Sau đó open file GunzDB2k.sql nhấn f5.
Bước 3 : Tạo ODBC
- Vào Start>Settings>Control Panel>Administrative Tools>Data Sources (ODBC)
- Nhấn Add>SQL Server>Finish
- Trong mục Name nhập GunzDB
- Trong mục Server nhập paste dòng chữ đã copy từ trước vào -> Next -> next
- Nhấn vào nút đầu tiên, ở ô thứ nhất, chọn GunzDB -> Next -> Finish -> OK

* Hướng dẫn cài đặt Quest Mode cho GunZ Offline
_ Kết nối tới DB Server -> GunZDB -> Tables -> Column -> accounts-> Chuột phải vao Column chọn New Column , đánh vào QuestItemInfo
_ Tiếp theo Chuột phải vào GunZDB -> New Query , dán đoạn mã này vào , sau đó nhấn chuột phải -> Excute SQL

CREATE PROCEDURE [dbo].[QuestItemInfo]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

SELECT QuestItemInfo FROM Character Where CID = @nCID
END

Bước 4 : Config Server
- Vào GunzServer\MatchServer\server.ini
- Ở hàng PASSWORD, nhập password của sasa
- Ở hàng FREELOGINIP, nhập IP của bạn -> Save
- tìm dòng ;MODE="test" bỏ dấu ";" di (de chúng ta kích quest)

Bước 5 : Kết nối Client
- Vào \Gunz\config.xml (mở bằng Notepad)
- Hàng IP nhập IP của bạn
- Thế là xong, bạn có thể vào chơi được rồi ở dòng match chọn quest de bắn quest vô tư(bắn ko nỗi đâu ít nhất 3 nguoi cùng bắn mới nỗi)
ý quen config web nhw vầy mới đuoc nè
<!-------------------------------------
GunZ Web Evolution
0.2
By OmOiYuMe

DONT REMOVE THIS CREDIT, RESPECT
MY HARD WORK!
--------------------------------------->
<?php
include "lang/langs.php"; //DONT EDIT THIS! - NO EDITES ESTO!
//General
$srvip = "127.0.0.1";
$srvport = "6000";
$DBHost = '127.0.0.1'; //The host of your DB - Donde esta instalada la DB (I.E: MACHINE\SQL2005)
$mssql_host = "MAYCHU\SQLEXPRESS";
$DBUser = 'sa'; //Your DB User - El Usuario de la DB
$mssql_user = "sa";
$DBPass = 'sasa'; //Your DB Password - El Password de tu DB
$mssql_pass = "sasa";
$DB = 'GunZDB'; //Your GunZ DB - Tu DB de GunZ
$mssql_database = "GunzDb";
$Server = 'SG GunZ'; //Your Server's Name - El Nombre de tu Servidor
$Slogan = "SG Gunz Web Powered by OmOiYuMe's GunZ Web Evolution 0.2"; //Slogan of your server - Eslogan de tu server
$ClientL = 'http://yourclientlink';
$PatchL = 'http://yourpatchlink';
$NoADM = '1'; //Dont show Admin accounts in rankings - No mostrar cuentas Admin en rankings
$RankNu = '10'; //Number of ranks to show in clan and character rankings - Numero de puestos para mostrar en el clan de players y clanes
$Lang = $Por; //Your Language - Tu Idioma ($Eng, $Spa, $Por, $Fre)
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
dong màu đỏ chúng ta copy ở mục server của bảng connect SQL 2005 đó và past vào đó
chúng ta nên dung phần mềm xampp-win32-1.6.6a-installer để làm web khỏi đăng kí
nếu có thắc mắc gì liên hệ minh qua yh: hongphuc141 minh chi cho

[Suolrock]

Có người hồi âm rồi bạn ơi thử làm trên SQL 2000 đi tại mình đang sài cái SQL 2000 mà đang sài Mu nữa ko thể xóa dc giúp với nha

[anhchangnhaque]

Ai chỉ mình cách cài file sql trên SQL Server. Cảm ơn truớc