- Joined
- Feb 13, 2007
- Messages
- 10
- Reaction score
- 0
PHP:
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spSelectCharQuestItemInfoByCID]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'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
'and im using this channel rule
PHP:
<?xml version="1.0" encoding="UTF-8" ?>
<!--
GAMETYPE_DEATHMATCH_SOLO =0
GAMETYPE_DEATHMATCH_TEAM =1
GAMETYPE_GLADIATOR_SOLO =2
GAMETYPE_GLADIATOR_TEAM =3
GAMETYPE_ASSASSINATE =4
GAMETYPE_TRAINING =5
GAMETYPE_SURVIVAL =6
GAMETYPE_QUEST =7
GAMETYPE_BERSERKER =8
-->
<XML id="channelrule">
<CHANNELRULE id="0" name="novice">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Dungeon 2"/>
<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="Stairway"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
<CHANNELRULE id="1" name="rookie">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Dungeon 2"/>
<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="Stairway"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
<CHANNELRULE id="2" name="mastery">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Dungeon 2"/>
<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="Stairway"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
<CHANNELRULE id="3" name="newbie">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Dungeon 2"/>
<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="Stairway"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
<CHANNELRULE id="4" name="elite">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Dungeon 2"/>
<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="Stairway"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
</XML>and this is my sacrifice table
PHP:
<?xml version="1.0" encoding="UTF-8" ?>
<XML xmlns="http://tempuri.org/zitem.xsd" id="sacrificeTable">
<ITEM map="" ql="1" default_item_id="0" special_item_id1="0" special_item_id2="0" significant_npc="" sdc="1" ScenarioID="0" />
<ITEM map="" ql="1" default_item_id="0" special_item_id1="200008" special_item_id2="0" significant_npc="goblin chief" sdc="1" ScenarioID="0" />
<ITEM map="" ql="2" default_item_id="200001" special_item_id1="0" special_item_id2="0" significant_npc="" sdc="1" ScenarioID="0" />
<ITEM map="" ql="2" default_item_id="0" special_item_id1="200024" special_item_id2="0" significant_npc="palmpoa commander" sdc="1" ScenarioID="0" />
<ITEM map="" ql="2" default_item_id="0" special_item_id1="200018" special_item_id2="0" significant_npc="goblin king" sdc="1" ScenarioID="0" />
<ITEM map="" ql="2" default_item_id="0" special_item_id1="200022" special_item_id2="0" significant_npc="palmpow" sdc="1" ScenarioID="0" />
<ITEM map="" ql="3" default_item_id="200002" special_item_id1="0" special_item_id2="0" significant_npc="" sdc="1" ScenarioID="0" />
<ITEM map="" ql="3" default_item_id="0" special_item_id1="200025" special_item_id2="200027" significant_npc="cursed palmow" sdc="1" ScenarioID="0" />
<ITEM map="" ql="4" default_item_id="200003" special_item_id1="0" special_item_id2="0" significant_npc="" sdc="1" ScenarioID="0" />
<ITEM map="" ql="5" default_item_id="200004" special_item_id1="0" special_item_id2="0" significant_npc="" sdc="1" ScenarioID="0" />
</XML>i see quest mode but when i click on it , it changes to previous mode again.
+ i dont have quest items... i didnt edit them yet.
