Quest Procedure and Table

Credits to Vicio for repairing Black Screen, and me for the tutorial

Hi I know that too many people has problems with Quest, Here i have the Solution.

First You need to add a Field at Character TABLE.
The Column you have to ADD is QuestItemInfo and is VARCHAR (MAX)

How to add the table:
Go to the SQL SERVER MANAGEMENT STUDIO.
Connect to the server
Expand your DB
Expand at tables,
Right Click at Columns
And select New Column
So there you have to put the name (QuestItemInfo), then the type of data: varchar (MAX) , and then you check the box that says Allow NULL data.
You are done with the Field

Then you need to Install this procedure:

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

---

How to install:
Go to Procedures and Right Click there and select New Query, there u paste this code and click at Execute.

So there you have Quest Activated at the DB.

Then to activate Quest at the server:
-Go to MatchServer Folder and open server.ini
-There if you see ;MODE="test" you have to remove the ;
-If you don't see MODE="test", add it to the file

Then you have to make Quest mode shown at the client, so at matchserver folder you edit channelrule.xml and you add
<GAMETYPE id="7" />
To all the Rules.

There you will have Quest Working

Thank me, any question ask here, i don't accept PMs

Tyvm!!!!!!!!!!!

Wow ty man imma add this right now.

Ohh..

I missed that at config.ini of MatchServer you have to activate

Mode="test".

If it's there but with a ; first, like ;MODE="test", remove the ; and save

Ok I think I'm stupid but I expanded al the things and i can find New Field and
how do you mean like

First You need to add a Field at Character TABLE.
The Column you have to ADD is QuestItemInfo and is VARCHAR (MAX)

So just add a new char? called QuestItemInfo? can you give a pic plz?

You add a new COLUMN, not a new character.

dude.. it doesnt work.. after i select my character.. my screen goes black ;) please help me with this one

Like this?

http://i26.photobucket.com/albums/c1...naamloos-1.png

Ok, here you have the pictures

Something more?

emisand I feel so noob T_T but I can't find New Field

I didnt get where i should put 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

---

Please shot picture of how to put or where

I don't Know how it's in English, it could be New Column, idk

Check if you get New Column like in the picture

Emisand make a picture where you mean New Field.

Msg 207, Level 16, State 1, Procedure spSelectCharQuestItemInfoByCID, Line 9
Invalid column name 'QuestItemInfo'.

that c omes up ? what do i do

[QUOTE=emisand;1855649]Ok, here you have the pictures

Something more?