![[USELESS-RELEASE] KT Quest Information Viewers](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/useless-release-kt-quest-information-viewers_ltr.gif){kind=small}
Code:
-------||X||Script by:||XXXXXXXXXX||------- -------||X||iSmokeDrow||XXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXX||DON'T TOUCH!||XXXXX||------- -------||XX||BELOW THIS LINE!||XXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXXX||------- DECLARE @ID INT, /* <--- Quest ID */ @LEVEL_LIMIT INT, /* <--- Quest Level Limit */ @TIME_LIMIT INT, /* <--- Quest Time Limit */ @CLASS_LIMIT NVARCHAR(MAX), /* <--- Quest Class Limit */ @RACE_LIMIT NVARCHAR(MAX), /* <--- Quest Race Limit*/ @START_NPC_ID1 INT, /* <--- Quest Starting NPC ID */ @START_NPC_TITLE1 NVARCHAR(MAX), /* <--- Quest Starting NPC Title */ @START_NPC_NAME1 NVARCHAR(MAX), /* <--- Quest Starting NPC Name */ @START_NPC_ID2 INT, /* <--- Quest Starting NPC ID */ @START_NPC_TITLE2 NVARCHAR(MAX), /* <--- Quest Starting NPC Title */ @START_NPC_NAME2 NVARCHAR(MAX), /* <--- Quest Starting NPC Name */ @START_NPC_ID3 INT, /* <--- Quest Starting NPC ID */ @START_NPC_TITLE3 NVARCHAR(MAX), /* <--- Quest Starting NPC Title */ @START_NPC_NAME3 NVARCHAR(MAX), /* <--- Quest Starting NPC Name */ @END_NPC_ID INT, /* <--- Quest Ending NPC ID*/ @END_NPC_TITLE NVARCHAR(MAX), /* <--- Quest Ending NPC Title */ @END_NPC_NAME NVARCHAR(MAX), /* <--- Quest Ending NPC Name */ @LUA_NAME1 NVARCHAR(MAX), /* <--- Quest NPC LUA 1st NPC */ @LUA_NAME2 NVARCHAR(MAX), /* <--- Quest NPC LUA 2nd NPC*/ @LUA_NAME3 NVARCHAR(MAX), /* <--- Quest NPC LUA 3rd NPC*/ @LUA_NAME4 NVARCHAR(MAX), /* <--- Quest END NPC LUA*/ @NAME NVARCHAR(MAX), /* <--- Quest Name */ @NAME_VAL INT, /* <--- Quest Search Related */ @NAME_REP NVARCHAR(MAX), /* <--- Quest Name Replacement Variable*/ @QNAME_ID INT, /* <--- Quest NAME ID [[FOR TP]] */ @TYPE NVARCHAR(MAX), /* <--- Quest Mission Type */ @KIND1_1 NVARCHAR(MAX), /* <--- Quest Kind: Start - START_NPC_ID1 */ @KIND1_2 NVARCHAR(MAX), /* <--- Quest Kind: Start - START_NPC_ID2 */ @KIND1_3 NVARCHAR(MAX), /* <--- Quest Kind: Start - START_NPC_ID3 */ @KIND2 NVARCHAR(MAX), /* <--- Quest Kind: Progress - ???? */ @KIND3 NVARCHAR(MAX), /* <--- Quest Kind: End - END_NPC_ID */ @START_DESC_ID1 INT, /* <--- Quest Starting Description ID 1*/ @START_DESC1 NVARCHAR(MAX), /* <--- Quest Description */ @START_DESC_ID2 INT, /* <--- Quest Starting Description ID 2*/ @START_DESC2 NVARCHAR(MAX), /* <--- Quest Description */ @START_DESC_ID3 INT, /* <--- Quest Starting Description ID 3*/ @START_DESC3 NVARCHAR(MAX), /* <--- Quest Description */ @END_DESC_ID INT, /* <--- Quest Ending Description ID*/ @END_DESC NVARCHAR(MAX), /* <--- Quest Ending Description*/ @REQ1_ID INT, /* <--- Quest Requirement/Objective 1 ID */ @REQ1_NAME NVARCHAR(MAX), /* <--- Quest Requirement/Objective 1 NAME */ @REQ1_AMT INT, /* <--- Quest Requirement/Objective 1 AMOUNT */ @REQ2_ID INT, /* <--- Quest Requirement/Objective 2 ID */ @REQ2_NAME NVARCHAR(MAX), /* <--- Quest Requirement/Objective 2 NAME */ @REQ2_AMT INT, /* <--- Quest Requirement/Objective 2 AMOUNT */ @REQ3_ID INT, /* <--- Quest Requirement/Objective 3 ID */ @REQ3_NAME NVARCHAR(MAX), /* <--- Quest Requirement/Objective 3 NAME */ @REQ3_AMT INT, /* <--- Quest Requirement/Objective 3 AMOUNT */ @REQ4_ID INT, /* <--- Quest Requirement/Objective 4 ID */ @REQ4_NAME NVARCHAR(MAX), /* <--- Quest Requirement/Objective 4 NAME */ @REQ4_AMT INT, /* <--- Quest Requirement/Objective 4 AMOUNT */ @REQ5_ID INT, /* <--- Quest Requirement/Objective 5 ID */ @REQ5_NAME NVARCHAR(MAX), /* <--- Quest Requirement/Objective 5 NAME */ @REQ5_AMT INT, /* <--- Quest Requirement/Objective 5 AMOUNT */ @BASIC_REW_ID INT, /* <--- Quest Basic Reward ID*/ @BASIC_REW_NAME NVARCHAR(MAX), /* <--- Quest Basic Reward NAME*/ @BASIC_REW_AMT INT, /* <--- Quest Basic Reward AMOUNT*/ @BASIC_REW_ICON NVARCHAR(MAX), /* <--- Quest Basic Reward ICON*/ @OPT1_REW_ID INT, /* <--- Quest Optional Reward ID*/ @OPT1_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional Reward NAME*/ @OPT1_REW_AMT INT, /* <--- Quest Optional Reward AMOUNT*/ @OPT1_REW_ICON NVARCHAR(MAX), /* <--- Quest Optional Reward ICON*/ @OPT2_REW_ID INT, /* <--- Quest Optional 2 Reward ID*/ @OPT2_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional 2 Reward NAME*/ @OPT2_REW_AMT INT, /* <--- Quest Optional 2 Reward AMOUNT*/ @OPT2_REW_ICON NVARCHAR(MAX), /* <--- Quest Optional 2 Reward ICON*/ @OPT3_REW_ID INT, /* <--- Quest Optional 3 Reward ID*/ @OPT3_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional 3 Reward NAME*/ @OPT3_REW_AMT INT, /* <--- Quest Optional 3 Reward AMOUNT*/ @OPT3_REW_ICON NVARCHAR(MAX), /* <--- Quest Optional 3 Reward ICON*/ @OPT4_REW_ID INT, /* <--- Quest Optional 4 Reward ID*/ @OPT4_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional 4 Reward NAME*/ @OPT4_REW_AMT INT, /* <--- Quest Optional 4 Reward AMOUNT*/ @OPT4_REW_ICON NVARCHAR(MAX), /* <--- Quest Optional 4 Reward ICON*/ @OPT5_REW_ID INT, /* <--- Quest Optional 5 Reward ID*/ @OPT5_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional 5 Reward NAME*/ @OPT5_REW_AMT INT, /* <--- Quest Optional 5 Reward AMOUNT*/ @OPT5_REW_ICON NVARCHAR(MAX), /* <--- Quest Optional 5 Reward ICON*/ @OPT6_REW_ID INT, /* <--- Quest Optional 6 Reward ID*/ @OPT6_REW_NAME NVARCHAR(MAX), /* <--- Quest Optional 6 Reward NAME*/ @OPT6_REW_AMT INT, /* <--- Quest Optional 6 Reward AMOUNT*/ @OPT6_REW_ICON NVARCHAR(MAX) /* <--- Quest Optional 6 Reward ICON*/ -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| DEFINE SERVER NAME (FOR ARCADIA) ||-- USE reborn_world /*<--- !!!!YOU MUST GIVE ME THE NAME OF YOUR ARCADIA DATABASE!*/ -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| DEFINE QUEST NAME ||-- /*=================================================== How To Configure Search Parameters: ==================================================== For example: ============ --SET @NAME = '%%' SET @ID = '1008' ------------------------ This configuration will search the quest by ID! ------------------------ SET @NAME = '%Sistina%' --SET @ID = '' This configureation will search the quest by name! =====================================================*/ --SET @NAME = '%%' /* <---- You MUST set ME or @ID (Uncomment me to search by name)*/ SET @ID = '1007' /* <---- You MUST set ME OR @NAME (Comment me to search by name [[UNCOMENT @NAME]]) */ /*TIP: You can execute me by pressing F5 or or Right-Click > Execute!*/ /*TIP: Make sure you set your Arcadia Database name! */ --============================================ -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- -------||XXXXXXXXX DO! XXXXXXXXX||------- -------||XXXXXXXXX NOT! XXXXXXXXX||------- -------||XXXXXXXXX EDIT! XXXXXXXX||------- -------||XXXXXXXX BELOW! XXXXXXXX||------- -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select Starting Parameter Values Based on Input || SET @NAME_VAL = (SELECT TOP (1) qres.id FROM QuestResource qres INNER JOIN StringResource sres ON sres.code = qres.text_id_quest WHERE sres.value LIKE @NAME) SET @NAME_REP = (SELECT TOP (1) sres.value FROM QuestResource qres INNER JOIN StringResource sres ON sres.code = qres.text_id_quest WHERE sres.value LIKE @NAME OR qres.id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Set Starting Parameter Values Based on Input ||-- IF @NAME_VAL IS NULL /* <--- If no NAME VALUE has been selected*/ SET @ID = @ID /* <--- Set QUEST ID to USER-INPUT ID*/ SET @NAME = @NAME_REP /* <--- Set QUEST NAME BY USER-INPUT ID*/ SET @QNAME_ID = (SELECT text_id_quest FROM reborn_world.dbo.QuestResource WHERE id = @ID) IF @NAME_VAL IS NOT NULL /* <--- If NAME VALUE has been selected*/ SET @ID = @NAME_VAL /* <--- Set QUEST ID by NAME REFERENCE*/ SET @NAME = @NAME_REP /* <--- Set QUEST NAME by NAME REFERENCE*/ SET @QNAME_ID = (SELECT text_id_quest FROM reborn_world.dbo.QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select Quest Type Parameter Value ||-- SET @TYPE = (SELECT type FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Converting Quest Type to String ||-- IF @TYPE = '100' SET @TYPE = 'MISC' IF @TYPE = '101' SET @TYPE = 'KILL_TOTAL' IF @TYPE = '102' SET @TYPE = 'KILL_INDIVIDUAL' IF @TYPE = '103' SET @TYPE = 'COLLECT' IF @TYPE = '106' SET @TYPE = 'HUNT_ITEM' IF @TYPE = '107' SET @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' IF @TYPE = '201' SET @TYPE = 'LEARN_SKILL' IF @TYPE = '301' SET @TYPE = 'UPGRADE_ITEM' IF @TYPE = '401' SET @TYPE = 'CONTACT' IF @TYPE = '501' SET @TYPE = 'JOB_LEVEL' IF @TYPE = '601' SET @TYPE = 'PARAMETER' IF @TYPE = '901' SET @TYPE = 'RANDOM_KILL_INDIVIDUAL' IF @TYPE = '902' SET @TYPE = 'RANDOM_COLLECT' -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting NPC Parameter Values (1) ||-- SET @START_NPC_ID1 = (SELECT TOP (1) npc_id FROM QuestLinkResource WHERE quest_id = @ID AND flag_start = 1) SET @START_NPC_TITLE1 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.text_id WHERE nres.id = @START_NPC_ID1) SET @START_NPC_NAME1 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.name_text_id WHERE nres.id = @START_NPC_ID1) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select LUA Name 1st NPC ||-- SET @LUA_NAME1 = (SELECT contact_script FROM NpcResource WHERE id = @START_NPC_id1) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting NPC Parameter Values (2) ||-- SET @START_NPC_ID2 = (SELECT TOP (1) npc_id FROM QuestLinkResource WHERE quest_id = @ID AND flag_start = 1 AND npc_id != @START_NPC_ID1) SET @START_NPC_TITLE2 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.text_id WHERE nres.id = @START_NPC_ID2) SET @START_NPC_NAME2 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.name_text_id WHERE nres.id = @START_NPC_ID2) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select LUA Name 2nd NPC ||-- SET @LUA_NAME2 = (SELECT contact_script FROM NpcResource WHERE id = @START_NPC_id2) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting NPC Parameter Values (3) ||-- SET @START_NPC_ID3 = (SELECT TOP (1) npc_id FROM QuestLinkResource WHERE quest_id = @ID AND flag_start = 1 AND npc_id != @START_NPC_ID1 AND npc_id != @START_NPC_ID2) SET @START_NPC_TITLE3 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.text_id WHERE nres.id = @START_NPC_ID3) SET @START_NPC_NAME3 = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.name_text_id WHERE nres.id = @START_NPC_ID3) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select LUA Name 3rd NPC ||-- SET @LUA_NAME3 = (SELECT contact_script FROM NpcResource WHERE id = @START_NPC_id3) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting NPC Parameter Values END ||-- SET @END_NPC_ID = (SELECT npc_id FROM QuestLinkResource WHERE quest_id = @ID AND flag_end = 1) SET @END_NPC_TITLE= (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.text_id WHERE nres.id = @END_NPC_ID) SET @END_NPC_NAME = (SELECT sres.value FROM NPCResource nres LEFT JOIN StringResource sres ON sres.code = nres.name_text_id WHERE nres.id = @END_NPC_ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Select LUA Name 3rd NPC ||-- SET @LUA_NAME4 = (SELECT contact_script FROM NpcResource WHERE id = @END_NPC_ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Kind Values ||-- SET @KIND1_1 = (SELECT flag_start FROM QuestLinkResource WHERE quest_id = @ID AND npc_id = @START_NPC_ID1 AND flag_start = 1) SET @KIND1_2 = (SELECT flag_start FROM QuestLinkResource WHERE quest_id = @ID AND npc_id = @START_NPC_ID2 AND flag_start = 1) SET @KIND1_3 = (SELECT flag_start FROM QuestLinkResource WHERE quest_id = @ID AND npc_id = @START_NPC_ID3 AND flag_start = 1) SET @KIND2 = (SELECT TOP (1) flag_progress FROM QuestLinkResource WHERE quest_id = @ID AND flag_progress = 1) SET @KIND3 = (SELECT flag_end FROM QuestLinkResource WHERE quest_id = @ID AND npc_id = @END_NPC_ID AND flag_end = 1) IF @KIND1_1 = 1 SET @KIND1_1 = 'START' IF @KIND1_2 = 1 SET @KIND1_2 = 'START' IF @KIND1_3 = 1 SET @KIND1_3 = 'START' IF @KIND3 = 1 SET @KIND3 = 'END' -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Description Values (1)||-- SET @START_DESC_ID1 = (SELECT text_id_start FROM QuestLinkResource WHERE npc_id = @START_NPC_ID1 AND quest_id = @ID) SET @START_DESC1 = (SELECT value FROM StringResource WHERE code = @START_DESC_ID1) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Description Values (2)||-- SET @START_DESC_ID2 = (SELECT text_id_start FROM QuestLinkResource WHERE npc_id = @START_NPC_ID2 AND quest_id = @ID) SET @START_DESC2 = (SELECT value FROM StringResource WHERE code = @START_DESC_ID2) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Description Values (3)||-- SET @START_DESC_ID3 = (SELECT text_id_start FROM QuestLinkResource WHERE npc_id = @START_NPC_ID3 AND quest_id = @ID) SET @START_DESC3 = (SELECT value FROM StringResource WHERE code = @START_DESC_ID3) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting END Quest Description Values||-- SET @END_DESC_ID = (SELECT text_id_end FROM QuestLinkResource WHERE npc_id = @END_NPC_ID AND quest_id = @ID) SET @END_DESC = (SELECT value FROM StringResource WHERE code = @END_DESC_ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Requirement Values (Objective 1)||-- SET @REQ1_ID = (SELECT value1 FROM QuestResource WHERE id = @ID) IF @TYPE = 'KILL_TOTAL' or @TYPE = 'KILL_INDIVIDUAL' or @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' SET @REQ1_NAME = (SELECT sres.value FROM MonsterResource mres INNER JOIN StringResource sres ON sres.code = mres.name_id WHERE mres.id = @REQ1_ID) SET @REQ1_AMT = (SELECT value2 FROM QuestResource WHERE id = @ID) IF @TYPE = 'COLLECT' or @TYPE = 'HUNT_ITEM' or @TYPE = 'RANDOM_COLLECT' SET @REQ1_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @REQ1_ID) SET @REQ1_AMT = (SELECT value2 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Requirement Values (Objective 2)||-- SET @REQ2_ID = (SELECT value3 FROM QuestResource WHERE id = @ID) IF @TYPE = 'KILL_TOTAL' or @TYPE = 'KILL_INDIVIDUAL' or @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' SET @REQ2_NAME = (SELECT sres.value FROM MonsterResource mres INNER JOIN StringResource sres ON sres.code = mres.name_id WHERE mres.id = @REQ1_ID) SET @REQ2_AMT = (SELECT value4 FROM QuestResource WHERE id = @ID) IF @TYPE = 'COLLECT' or @TYPE = 'HUNT_ITEM' or @TYPE = 'RANDOM_COLLECT' SET @REQ2_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @REQ1_ID) SET @REQ2_AMT = (SELECT value4 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Requirement Values (Objective 3)||-- SET @REQ3_ID = (SELECT value5 FROM QuestResource WHERE id = @ID) IF @TYPE = 'KILL_TOTAL' or @TYPE = 'KILL_INDIVIDUAL' or @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' SET @REQ3_NAME = (SELECT sres.value FROM MonsterResource mres INNER JOIN StringResource sres ON sres.code = mres.name_id WHERE mres.id = @REQ1_ID) SET @REQ3_AMT = (SELECT value6 FROM QuestResource WHERE id = @ID) IF @TYPE = 'COLLECT' or @TYPE = 'HUNT_ITEM' or @TYPE = 'RANDOM_COLLECT' SET @REQ3_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @REQ1_ID) SET @REQ3_AMT = (SELECT value6 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Requirement Values (Objective 4)||-- SET @REQ4_ID = (SELECT value7 FROM QuestResource WHERE id = @ID) IF @TYPE = 'KILL_TOTAL' or @TYPE = 'KILL_INDIVIDUAL' or @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' SET @REQ4_NAME = (SELECT sres.value FROM MonsterResource mres INNER JOIN StringResource sres ON sres.code = mres.name_id WHERE mres.id = @REQ1_ID) SET @REQ4_AMT = (SELECT value8 FROM QuestResource WHERE id = @ID) IF @TYPE = 'COLLECT' or @TYPE = 'HUNT_ITEM' or @TYPE = 'RANDOM_COLLECT' SET @REQ4_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @REQ1_ID) SET @REQ4_AMT = (SELECT value8 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Requirement Values (Objective 5)||-- SET @REQ5_ID = (SELECT value9 FROM QuestResource WHERE id = @ID) IF @TYPE = 'KILL_TOTAL' or @TYPE = 'KILL_INDIVIDUAL' or @TYPE = 'HUNT_ITEM_FROM_ANY_MONSTERS' SET @REQ5_NAME = (SELECT sres.value FROM MonsterResource mres INNER JOIN StringResource sres ON sres.code = mres.name_id WHERE mres.id = @REQ1_ID) SET @REQ5_AMT = (SELECT value10 FROM QuestResource WHERE id = @ID) IF @TYPE = 'COLLECT' or @TYPE = 'HUNT_ITEM' or @TYPE = 'RANDOM_COLLECT' SET @REQ5_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @REQ1_ID) SET @REQ5_AMT = (SELECT value10 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Quest Base Reward Values||-- SET @BASIC_REW_ID = (SELECT default_reward_id FROM QuestResource WHERE id = @ID) SET @BASIC_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @BASIC_REW_ID) SET @BASIC_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @BASIC_REW_ID) SET @BASIC_REW_AMT = (SELECT default_reward_quantity FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 1 Reward Values||-- SET @OPT1_REW_ID = (SELECT optional_reward_id1 FROM QuestResource WHERE id = @ID) SET @OPT1_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT1_REW_ID) SET @OPT1_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT1_REW_ID) SET @OPT1_REW_AMT = (SELECT optional_reward_quantity1 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 2 Reward Values||-- SET @OPT2_REW_ID = (SELECT optional_reward_id2 FROM QuestResource WHERE id = @ID) SET @OPT2_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT2_REW_ID) SET @OPT2_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT2_REW_ID) SET @OPT2_REW_AMT = (SELECT optional_reward_quantity2 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 3 Reward Values||-- SET @OPT3_REW_ID = (SELECT optional_reward_id3 FROM QuestResource WHERE id = @ID) SET @OPT3_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT3_REW_ID) SET @OPT3_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT3_REW_ID) SET @OPT3_REW_AMT = (SELECT optional_reward_quantity3 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 4 Reward Values||-- SET @OPT4_REW_ID = (SELECT optional_reward_id4 FROM QuestResource WHERE id = @ID) SET @OPT4_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT4_REW_ID) SET @OPT4_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT4_REW_ID) SET @OPT4_REW_AMT = (SELECT optional_reward_quantity4 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 5 Reward Values||-- SET @OPT5_REW_ID = (SELECT optional_reward_id5 FROM QuestResource WHERE id = @ID) SET @OPT5_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT5_REW_ID) SET @OPT5_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT5_REW_ID) SET @OPT5_REW_AMT = (SELECT optional_reward_quantity5 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting Optional 6 Reward Values||-- SET @OPT6_REW_ID = (SELECT optional_reward_id6 FROM QuestResource WHERE id = @ID) SET @OPT6_REW_NAME = (SELECT sres.value FROM ItemResource ires INNER JOIN StringResource sres ON sres.code = ires.name_id WHERE ires.id = @OPT6_REW_ID) SET @OPT6_REW_ICON = (SELECT icon_file_name FROM ItemResource WHERE id = @OPT4_REW_ID) SET @OPT6_REW_AMT = (SELECT optional_reward_quantity6 FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting @TIME/@CLASS Limit Values||-- SET @TIME_LIMIT = (SELECT time_limit FROM QuestResource WHERE id = @ID) IF EXISTS(SELECT * FROM QuestResource WHERE limit_asura = 1 AND limit_deva = 1 AND limit_gaia = 1 AND id = @ID) SET @RACE_LIMIT = 'ALL' IF EXISTS(SELECT * FROM QuestResource WHERE limit_asura = 1 AND limit_deva = 0 AND limit_Gaia = 0 AND id = @ID) SET @RACE_LIMIT = 'ASURA' IF EXISTS(SELECT * FROM QuestResource WHERE limit_asura = 0 AND limit_deva = 1 AND limit_Gaia = 0 AND id = @ID) SET @RACE_LIMIT = 'DEVA' IF EXISTS(SELECT * FROM QuestResource WHERE limit_asura = 0 AND limit_deva = 0 AND limit_Gaia = 1 AND id = @ID) SET @RACE_LIMIT = 'GAIA' -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Selecting @RACE/@LEVEL Limit Values||-- IF EXISTS(SELECT * FROM QuestResource WHERE limit_fighter = 1 AND limit_magician = 1 AND limit_hunter = 1 AND limit_summoner = 1 AND id = @ID) SET @CLASS_LIMIT = 'ALL' IF EXISTS(SELECT * FROM QuestResource WHERE limit_fighter = 1 AND limit_magician = 0 AND limit_hunter = 0 AND limit_summoner = 0 AND id = @ID) SET @CLASS_LIMIT = 'FIGHTER' IF EXISTS(SELECT * FROM QuestResource WHERE limit_fighter = 0 AND limit_magician = 1 AND limit_hunter = 0 AND limit_summoner = 0 AND id = @ID) SET @CLASS_LIMIT = 'MAGE' IF EXISTS(SELECT * FROM QuestResource WHERE limit_fighter = 0 AND limit_magician = 0 AND limit_hunter = 1 AND limit_summoner = 0 AND id = @ID) SET @CLASS_LIMIT = 'HUNTER' IF EXISTS(SELECT * FROM QuestResource WHERE limit_fighter = 0 AND limit_magician = 0 AND limit_hunter = 0 AND limit_summoner = 1 AND id = @ID) SET @CLASS_LIMIT = 'SUMMONER' SET @LEVEL_LIMIT = (SELECT limit_level FROM QuestResource WHERE id = @ID) -------||XXXXXXXXXXXXXXXXXXXXXXXX||------- --|| Begin Triggering DYNAMIC SELECTION||-- IF @KIND1_1 = 'START' SELECT @ID as "ID", @TYPE as "OBJECTIVE TYPE", @KIND1_1 as "NPC TYPE", @START_NPC_ID1 as "START NPC ID", @START_NPC_TITLE1 + ' ' + @START_NPC_NAME1 as "NPC NAME", @LUA_NAME1 as "NPC LUA", @RACE_LIMIT as "RACE REQ", @CLASS_LIMIT as "CLASS REQ", @QNAME_ID as "QUEST NAME ID", @NAME as "QUEST NAME", @START_DESC_ID1 as "DESC ID", @START_DESC1 as "DESCRIPTION", @TIME_LIMIT as "TIME LIMIT", @LEVEL_LIMIT as "LEVEL LIMIT", @REQ1_ID as "OBJ ID", @REQ1_NAME as "OBJECTIVE", @REQ1_AMT as "OBJ AMT", @REQ2_ID as "OBJ ID 2", @REQ2_NAME as "OBJECTIVE 2", @REQ2_AMT as "OBJ AMT 2", @REQ3_ID as "OBJ ID 3", @REQ3_NAME as "OBJECTIVE 3", @REQ3_AMT as "OBJ AMT 3", @REQ4_ID as "OBJ ID 4", @REQ4_NAME as "OBJECTIVE 4", @REQ4_AMT as "OBJ AMT 4", @REQ5_ID as "OBJ ID 5", @REQ5_NAME as "OBJECTIVE 5", @REQ5_AMT as "OBJ AMT 5" IF @KIND1_2 = 'START' SELECT @ID as "ID", @TYPE as "OBJECTIVE TYPE", @KIND1_2 as "NPC TYPE", @START_NPC_ID2 as "START NPC ID2", @START_NPC_TITLE2 + ' ' + @START_NPC_NAME2 as "NPC NAME 2", @LUA_NAME2 as "NPC LUA2", @RACE_LIMIT as "RACE REQ", @CLASS_LIMIT as "CLASS REQ", @QNAME_ID as "QUEST NAME ID", @NAME as "QUEST NAME", @START_DESC_ID2 as "DESC ID 2", @START_DESC2 as "DESCRIPTION 2", @TIME_LIMIT as "TIME LIMIT", @LEVEL_LIMIT as "LEVEL LIMIT", @REQ1_ID as "OBJ ID", @REQ1_NAME as "OBJECTIVE", @REQ1_AMT as "OBJ AMT", @REQ2_ID as "OBJ ID 2", @REQ2_NAME as "OBJECTIVE 2", @REQ2_AMT as "OBJ AMT 2", @REQ3_ID as "OBJ ID 3", @REQ3_NAME as "OBJECTIVE 3", @REQ3_AMT as "OBJ AMT 3", @REQ4_ID as "OBJ ID 4", @REQ4_NAME as "OBJECTIVE 4", @REQ4_AMT as "OBJ AMT 4", @REQ5_ID as "OBJ ID 5", @REQ5_NAME as "OBJECTIVE 5", @REQ5_AMT as "OBJ AMT 5" IF @KIND1_3 = 'START' SELECT @ID as "ID", @TYPE as "OBJECTIVE TYPE", @KIND1_3 as "NPC TYPE", @START_NPC_ID3 as "START NPC ID3", @START_NPC_TITLE3 + ' ' + @START_NPC_NAME3 as "NPC NAME 3", @LUA_NAME3 as "NPC LUA3", @RACE_LIMIT as "RACE REQ", @CLASS_LIMIT as "CLASS REQ", @QNAME_ID as "QUEST NAME ID", @NAME as "QUEST NAME", @START_DESC_ID3 as "DESC ID 3", @START_DESC3 as "DESCRIPTION 3", @TIME_LIMIT as "TIME LIMIT", @LEVEL_LIMIT as "LEVEL LIMIT", @REQ1_ID as "OBJ ID", @REQ1_NAME as "OBJECTIVE", @REQ1_AMT as "OBJ AMT", @REQ2_ID as "OBJ ID 2", @REQ2_NAME as "OBJECTIVE 2", @REQ2_AMT as "OBJ AMT 2", @REQ3_ID as "OBJ ID 3", @REQ3_NAME as "OBJECTIVE 3", @REQ3_AMT as "OBJ AMT 3", @REQ4_ID as "OBJ ID 4", @REQ4_NAME as "OBJECTIVE 4", @REQ4_AMT as "OBJ AMT 4", @REQ5_ID as "OBJ ID 5", @REQ5_NAME as "OBJECTIVE 5", @REQ5_AMT as "OBJ AMT 5" IF @KIND2 = 'PROGRESS' SELECT @ID as "ID", @TYPE as "OBJECTIVE TYPE" IF @KIND3 = 'END' SELECT @ID as "ID", @TYPE as "OBJECTIVE TYPE", @KIND3 as "NPC TYPE", @END_NPC_ID as "END NPC ID", @END_NPC_TITLE + ' ' + @END_NPC_NAME as "END NPC NAME", @LUA_NAME4 as "END NPC LUA", @RACE_LIMIT as "RACE REQ", @CLASS_LIMIT as "CLASS REQ", @QNAME_ID as "QUEST NAME ID", @NAME as "QUEST NAME", @END_DESC_ID as "END DESC ID", @END_DESC as "END DESCRIPTION", @BASIC_REW_ID as "DEF REWARD ID", @BASIC_REW_NAME as "DEF REWARD NAME", @BASIC_REW_ICON as "DEF REWARD ICON", @BASIC_REW_AMT as "DEF REWARD AMOUNT", @OPT1_REW_ID as "OPT REWARD ID", @OPT1_REW_NAME as "OPT REWARD NAME", @OPT1_REW_ICON as "OPT REWARD ICON", @OPT1_REW_AMT as "OPT REWARD AMOUNT", @OPT2_REW_ID as "OPT 2 REWARD ID", @OPT2_REW_NAME as "OPT 2 REWARD NAME", @OPT2_REW_ICON as "OPT 2 REWARD ICON", @OPT2_REW_AMT as "OPT 2 REWARD AMOUNT", @OPT3_REW_ID as "OPT 3 REWARD ID", @OPT3_REW_NAME as "OPT 3 REWARD NAME", @OPT3_REW_ICON as "OPT 3 REWARD ICON", @OPT3_REW_AMT as "OPT 3 REWARD AMOUNT", @OPT4_REW_ID as "OPT 4 REWARD ID", @OPT4_REW_NAME as "OPT 4 REWARD NAME", @OPT4_REW_ICON as "OPT 4 REWARD ICON", @OPT4_REW_AMT as "OPT 4 REWARD AMOUNT", @OPT5_REW_ID as "OPT 5 REWARD ID", @OPT5_REW_NAME as "OPT 5 REWARD NAME", @OPT5_REW_ICON as "OPT 5 REWARD ICON", @OPT5_REW_AMT as "OPT 5 REWARD AMOUNT", @OPT6_REW_ID as "OPT REWARD ID", @OPT6_REW_NAME as "OPT REWARD NAME", @OPT6_REW_ICON as "OPT REWARD ICON", @OPT6_REW_AMT as "OPT REWARD AMOUNT"
Typical Results:
SCREENSHOT: --UPDATED!
Can't figure out how to use it? Don't ask me.
P.S.
KT does not like really broad search terms. E.G. just typing in '%witch%' will not net you the results you want. If at first you don't succeed try narrowing your search term to '%supporting the witch%'
