Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 14:55

  • 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,411
[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!
You must register and activate your account in order to view images.

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: 91
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,411
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: 91
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 +2. The time now is 14:55.


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

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