Quest Procedure and Table

[XepToX - Xoz0r]

I didnt get where i should put the

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

Press New Query button -_-

[XepToX - Xoz0r]

[quote=emisand;1855674]There it's Posted

[Sezrma]

Ok i did everything but it doesnt show up in channels?
I heard about something like config in matchserver but i dont have any config file in my matchserver folder O.o

[emisand]

Config Channelrule.xml at Matchserver folder..

Use like this config:

	<CHANNELRULE id="0" name="novice">
		<MAP name="Mansion"/>
		<MAP name="Prison"/>
		<MAP name="Prison II"/>
		<MAP name="Station"/>
		<MAP name="Battle Arena"/>
		<MAP name="Town"/>
		<MAP name="Snow_Town"/>
		<MAP name="Ruin"/>
		<MAP name="Dungeon"/>
		<MAP name="Castle"/>
		<MAP name="Island"/>
		<MAP name="Garden"/>
		<MAP name="Factory"/>
		<MAP name="Port"/>
		<MAP name="Lost Shrine"/>
		<MAP name="Stairway"/>
		<MAP name="Hall"/>
		<MAP name="Catacomb"/>
		<MAP name="Shower Room"/>
		
        <GAMETYPE id="0" />
        <GAMETYPE id="1" />
        <GAMETYPE id="2" />
        <GAMETYPE id="3" />
        <GAMETYPE id="4" />
        <GAMETYPE id="5" />
        <GAMETYPE id="6" />
        <GAMETYPE id="7" />
        <GAMETYPE id="8" />
	</CHANNELRULE>

[LeeStrong]

The above method of making the 'quest' option visible did not work, Thanks anywhey.

[Ulti]

What is this?

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

[LeeStrong]

Did you do the right capitals when creating the column?

[Sezrma]

I've done everything you've said and i still dont see quest mode..

[Bryan1]

Thx emisand I got it working.

[MackInTosh]

....

[Sezrma]

Same here.. >_<

[vDrag0n]

You need to edit your spInsertChar, read my thread for some more info.

[MackInTosh]

....

[vDrag0n]

http://forum.ragezone.com/gunz-onlin...en-205957.html

[Gunner54]

what do you mean "NULL on the last ARG" their is no ARG in InsertChar