Quest mode tut (WITH PICTURES)

[A.T.H.K]

Ok so first of we start by saying

Credited to Buga and the LegacyGamers Administrative Team

Ok so start up SMSE (Server Management Stuido Express)

Connect to the database

Drop down the Database list and the GunzDB list by pressing the + signs so that they are all collapsed like so :

Now collapse Tables and Dbo.Character Right click on Columns like so

Press New Column and follow what i have :

Now press the little x and make sure you save it :

Ok so onto the Query now here is the code

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

Copy that and copy what is in this picture :

Now that is all setup you'll have to allow it on the Matchserver goto your Match server directory where ever you put it "C:\GunzServer\MatchServer" for me now go in and open up SERVER.INI make sure you MODE looks like mine delete the little ; infront of it :

Close and save that

Now to allow the Quest mode in certain or all Channels edit the CHANNELRULE.XML file this picture shows how to allow the Quest mode in the First room you enter once you login:

Have fun

[FIX] ok this fix is so new accounts can create a Character without getting the E-1 error message Credited to VDrag0n. So here goes

Collapse the GunDB , Programmability then Stored Procedures like so:

Now right click dbo.spInsertChar and press modify like this :

Ok so thats done a window to the right of it will pop up:

And DELETE all the text like it shows in that picture ^ .

and PASTE this in it

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER 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,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null)
END

 

[monkeyeed]

u have to wait its lagging it happens sumtime

 

[CheifBandit]

Uh it stays like that all the time...Do I just let me load?

 

[Avunari]

Very nice guide, Good job.