Cách Làm Server Gunz Có Quest

hongphuc1281441 · 1/9/08

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 minh

lam 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

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

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,

Mã:

 [int] NOT NULL,
[Time] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KillLog](
[KillerID] [int] NULL,
[KilledID] [int] NULL
) ON [PRIMARY]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spClearAllEquipedItem]
@nCharID INT
AS
DELETE FROM Items
WHERE CID = @nCharID
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spGetIPCountryCode]
AS
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryList]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[spGetIPtoCountryCode]
AS
BEGIN
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode
END
GO

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

***** TẢI CÁC PHẦN MỀM SAU**************
MsSQL 2005 Express Edition
Code:
http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en
[COLOR="Red"]MsSQL Server Managment Studio [/COLOR]và tìm [COLOR="red"] msxml6 [/COLOR]tải về lun

Code:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en
.NET Framework 2.0 
Code:
http://www.microsoft.com/downloads/details.aspx?familyid=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en
*********CÁCH LÀM**********************
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)
*************config web nhw vầy mới đuoc nè**********
 
<!-------------------------------------
            GunZ Web Evolution
                   0.2
	       By OmOiYuMe
        [email protected]
      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 = "[COLOR="Red"]MAYCHU\SQLEXPRESS[/COLOR]";
$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);
?>
****LUU Ý************
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 [COLOR="SeaGreen"]xampp-win32-1.6.6a-installer [/COLOR] để làm web khỏi đăng kí

Suolrock · 1/9/08

bạn ơi làm thử trên cái SQL 2000 đi mình đang sài cái đó và đang cài Mu nữa:102:

hongphuc1281441 · 3/9/08

Mu van chay duoc tren SQL 2005 ma. minh chay Au, Mu, Gunz, Vo Lam tren SQL 2005 dc mà. mình chỉ cho bạn lam MU bằng SQL 2005 nha ( Chay nhanh hon sql 2000 rat nhiu)

hongphuc1281441 · 3/9/08

Bạn đang chạy Mu bằng SQL 2000 thi wa dễ, bạn chỉ cần gỡ bỏ SQL 2000 ra và cài vào SQL 2005 y huong dãn trên.
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
sau đó nhấp vào connect
- Nhấp Phải vào Datbases chọn attach.... chọn dường dẫn đến: MU2003_EVENT_DATA.mdf,ranking_Data.MDF,muonline_Data.MDF của bạn đó. thế là xong.
Bạn chỉnh (ODBC) lại như vầy nè: ODBC Ranking bạn nhấp đôi vào nó va past dòng vừa copy vào muc server chọn Finish và tuong tự cho các OBDC khác. thế là xong ra chạy binh thường nhân vật trong games vẫn tồn tại ko mất đồ ko mất cấp.
Mình lúc trước cũng sài sql 2000 và chuyển qua sql 2005 bạn làm thư xem.
luu ý: Những cái bạn attach trên sql 2005 bạn đừng nên xóa vì no đỗng nghĩa với việc xóa dư liệu database trên đĩa của mình lun đóa, copy data thương xuyên lại để dành khi có sự cố.

hongphuc1281441 · 4/9/08

mình ko có đoạn query để kích hoạt quét trên sql 2000 nên không thể làm bằng sql 2000 dc. minh dang tìm đaọn query đó nè. có ai pro tìm giúp mình đi

hongphuc1281441 · 4/9/08

anh Dưong cho Ý kiến đi, anh nghiên cứu sữa lai SQL 2000 dc ko

Suolrock · 5/9/08

hongphuc1281441 nói:
anh Dưong cho Ý kiến đi, anh nghiên cứu sữa lai SQL 2000 dc ko

Dù sao cũng cảm ơn bạn đã nhiệt tình giúp mình, nhưng cái Mu mình đang sài làm lâu lắm,vì nếu mà xóa cái SQL 2000 thì tất cả các dữ liệu của Mu mất hết ý mình nói là phần acc đó, làm biếng add lại lắm và dạo này mắc học rồi nên không có thời gian, nếu bạn kiếm dc cái code gì đó trên SQL2000 thì tốt biết mấy, nhưng dù sao cũng cảm ơn bạn nha...:15:

hongphuc1281441 · 5/9/08

có cần phẩi vậy kô, bạn chỉ cần ko cho sql 2000 chạy rồi copy mấy file dữ liệu trong database lại là đâu có mất acc. xóa sql 2000 rồi cài cái 2005 lại rồi bạn attach la xong ko cần restor database

hlxuyen2000 · 21/12/08

bạn ơi mình chơi được rùi nhưng bằng tài khoảng admin có sẵn,minh download xampp-win32-1.6.6a-installer về rùi nhưng không biết dùng làm sao bạn chỉ mình với

dhnguyen · 26/12/08

ê ông anh ơi xem lại bảo kỹ dùm cái tôi thấy sau khi kết nối database .... rồi ấn F5 nó báo lỗi lằng nhằng ra à.
mới lại cái PHP của ông không chạy được đâu có báo dòng lỗi và lập nick cũng không được à báo "có lỗi xảy ra, xin đăng ký lại" cái này như củ anh
Dương thì vẫn chơi được nhưng của ông thì chịu,

hongphuc1281441 · 14/1/09

xin lỗi các bạn nha lâu wá mình ko len nen ko bit co nhieu cau hoi nhu vậy. đê minh nghien cứu lại ròi huóng dãn cho

hongphuc1281441 · 21/1/09

hlxuyen2000 nói:
bạn ơi mình chơi được rùi nhưng bằng tài khoảng admin có sẵn,minh download xampp-win32-1.6.6a-installer về rùi nhưng không biết dùng làm sao bạn chỉ mình với

Tải xampp-win32-1.6.6a-installer về rồi cài vào ổ đĩa c:\,ban giải nén web về rồi chỉnh sửa theo hướng dẫn, rồi sao đó bạn copy web và pass vào C:\xampp\htdocs. ok the là xong. truy cập web bình thường, coi chừng bị đụng lộn với web asp đó. nếu ko rành thì xài 1 loại thôi nha. nêu có thì gỡ mọi cài đặt của web asp ra.

hongphuc1281441 · 21/1/09

minh úp lên cho các ban db sql 2005 tải về lam khỏi đánh mã code gi cho no mất công

You must be registered for see links

các bạn tải về làm

a1shoot · 24/4/11

mình làm thử sever gunz online
ngoài mang vào được gunz , tao phòng được nhưng khi vào phòng thì đúng im không đánh
sever va cliet đã cài net framework 3.5
pro nào biết xin chỉ mình với

Cách Làm Server Gunz Có Quest

hongphuc1281441

New member

Suolrock

New member

hongphuc1281441

New member

hongphuc1281441

New member

hongphuc1281441

New member

hongphuc1281441

New member

Suolrock

New member

hongphuc1281441

New member

hlxuyen2000

New member

dhnguyen

New member

hongphuc1281441

New member

hongphuc1281441

New member

hongphuc1281441

New member

a1shoot

New member