Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:09

  • Please register to post and access all features, it's quick, easy and FREE!

 

[USELESS-RELEASE] KT Quest Information Viewers

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,417
[USELESS-RELEASE] KT Quest Information Viewers

Here is another useless release!

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"
CODE UPDATED!!!! Now you can search by name or by id, just read the built-in instructions

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%'



ismokedrow is offline  
Thanks
10 Users
Old   #2
 
elite*gold: 0
Join Date: Aug 2012
Posts: 312
Received Thanks: 252
Nice script


gr4ph0s is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Aug 2011
Posts: 161
Received Thanks: 36
Thank you and nice script .
gruce is offline  
Old   #4
 
elite*gold: 0
Join Date: Aug 2011
Posts: 92
Received Thanks: 9
thank you Ismoke but I have Problem lock here


ssagar is offline  
Old   #5
 
elite*gold: 0
Join Date: Jun 2012
Posts: 49
Received Thanks: 48
nice ...
can i make my own Quest ?
rakanomar is offline  
Old   #6
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,417
Yes @ Rakanomar you can make a new quest with a quest viewer. -eyeroll-

@ssagar: Seem's to be ******** about your stringres

Original Post Updated!
- Script Updated [Several New Info's Added]
- Added configurable search parameters
- Added new screenshot!
- Organized several info's
ismokedrow is offline  
Thanks
1 User
Old   #7
 
elite*gold: 0
Join Date: Aug 2011
Posts: 92
Received Thanks: 9
Quote:
Originally Posted by ismokedrow View Post
Yes @ Rakanomar you can make a new quest with a quest viewer. -eyeroll-

@ssagar: Seem's to be ******** about your stringres

Original Post Updated!
- Script Updated [Several New Info's Added]
- Added configurable search parameters
- Added new screenshot!
- Organized several info's
thaaanx man Is worked!!!
ssagar is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
Thanks Drow


eziorav is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
D9 quest information error
i used 9Disciple and got the epi shen mo on my EC 12 in D9 and now it says wrong quest onformation please contact a GM if problem continues and wont...
0 Replies - 9Dragons
useless threads in release sections
More and more the people loose overview in the release sections because of unnecessary questions and senseless stuff. Although the sections are...
1 Replies - Cabal Main - Discussions / Questions
[Useless-Release] Camera Zoom
Just, camera zoom. If someone can do a dll for this (able to change the value in game), it will be good! (I'll ask someone...). The default value is...
14 Replies - S4 League Hacks, Bots, Cheats & Exploits
3 First lucky viewers will get a free account on GC PH!
Closing soon
34 Replies - Grand Chase Philippines
Release Working system.mrs hack | 16 player factory, no sunlight, useless quest items
Just extract the system.mrs file into ur gunz folder and replace the old one. http://rapidshare.com/files/149906855/system.rar.html
1 Replies - GunZ



All times are GMT +1. The time now is 15:09.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.