API tools faq
paste
Guest User

QUEST- POI Template - Area Objective.sql

a guest
Jan 2nd, 2025
26
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.56 KB | None | 0 0
raw download clone embed print report
  1. /* POI TEMPLATE MADE BY CABLEGUY
  2. SINGLE POI IS FOR QUEST HAND IN, MULTIPLE IS FOR POI AREAS */
  3.  
  4. -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START --
  5. -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START --
  6. -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START --
  7. -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START -- DATA FOR CREATION START --
  8.  
  9. -- NEEDED DATA
  10. SET @QuestID := 310011; -- The quest ID. This column is the Primary Key for the Table. Each quest ID must be unique!
  11.  
  12. -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START --
  13. -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START --
  14.  
  15. SET @POI_Multiple_id := 0; -- Use 1 for Multiple Points (DONT CHANGE USE SINGLE)
  16. SET @POI_Multiple_ObjectiveIndex := 0; -- Use 4 for Multiple Points (DONT CHANGE USE SINGLE)
  17. SET @POI_Multiple_MapID := 981; -- 981 = Kingdom. 982 = Event Island, 983 = Nightmare of Egorius
  18. SET @POI_Multiple_WorldMapAreaId := 6505; -- AreaID of the POI location
  19.  
  20. SET @POI_Multiple_1_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  21. SET @POI_Multiple_1_Idx2 := 0; -- Use Point Number -1
  22. SET @POI_Multiple_1_X := 4952; -- The X position of the question mark on the map.
  23. SET @POI_Multiple_1_Y := 1905; -- The Y position of the question mark on the map.
  24.  
  25. SET @POI_Multiple_2_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  26. SET @POI_Multiple_2_Idx2 := 1; -- Use Point Number -1
  27. SET @POI_Multiple_2_X := 4961; -- The X position of the question mark on the map.
  28. SET @POI_Multiple_2_Y := 1808; -- The Y position of the question mark on the map.
  29.  
  30. SET @POI_Multiple_3_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  31. SET @POI_Multiple_3_Idx2 := 2; -- Use Point Number -1
  32. SET @POI_Multiple_3_X := 4972; -- The X position of the question mark on the map.
  33. SET @POI_Multiple_3_Y := 1752; -- The Y position of the question mark on the map.
  34.  
  35. SET @POI_Multiple_4_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  36. SET @POI_Multiple_4_Idx2 := 3; -- Use Point Number -1
  37. SET @POI_Multiple_4_X := 4707; -- The X position of the question mark on the map.
  38. SET @POI_Multiple_4_Y := 1855; -- The Y position of the question mark on the map.
  39.  
  40. SET @POI_Multiple_5_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  41. SET @POI_Multiple_5_Idx2 := 4; -- Use Point Number -1
  42. SET @POI_Multiple_5_X := 3580; -- The X position of the question mark on the map.
  43. SET @POI_Multiple_5_Y := 2332; -- The Y position of the question mark on the map.
  44.  
  45. SET @POI_Multiple_6_Idx1 := 0; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  46. SET @POI_Multiple_6_Idx2 := 5; -- Use Point Number -1
  47. SET @POI_Multiple_6_X := 3648; -- The X position of the question mark on the map.
  48. SET @POI_Multiple_6_Y := 2360; -- The Y position of the question mark on the map.
  49.  
  50. SET @POI_Multiple_7_Idx1 := 1; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  51. SET @POI_Multiple_7_Idx2 := 6; -- Use Point Number -1
  52. SET @POI_Multiple_7_X := 3693; -- The X position of the question mark on the map.
  53. SET @POI_Multiple_7_Y := 2452; -- The Y position of the question mark on the map.
  54.  
  55. SET @POI_Multiple_8_Idx1 := 1; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  56. SET @POI_Multiple_8_Idx2 := 7; -- Use Point Number -1
  57. SET @POI_Multiple_8_X := 3630; -- The X position of the question mark on the map.
  58. SET @POI_Multiple_8_Y := 2440; -- The Y position of the question mark on the map.
  59.  
  60. SET @POI_Multiple_9_Idx1 := 1; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  61. SET @POI_Multiple_9_Idx2 := 8; -- Use Point Number -1
  62. SET @POI_Multiple_9_X := 3559; -- The X position of the question mark on the map.
  63. SET @POI_Multiple_9_Y := 2396; -- The Y position of the question mark on the map.
  64.  
  65. SET @POI_Multiple_10_Idx1 := 1; -- Use 0 for Multiple Points (DONT CHANGE USE SINGLE)
  66. SET @POI_Multiple_10_Idx2 := 9; -- Use Point Number -1
  67. SET @POI_Multiple_10_X := 3558; -- The X position of the question mark on the map.
  68. SET @POI_Multiple_10_Y := 2358; -- The Y position of the question mark on the map.
  69. /* DiSaBlE CoMmEnT (REMOVE ME IF NEEDED)
  70. DiSaBlE CoMmEnT (REMOVE ME IF NEEDED) */
  71.  
  72. -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END --
  73. -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END --
  74.  
  75. -- OTHER CRAP
  76. SET @POI_Multiple_Floor := 0; -- Keep as 0 (Unused)
  77. SET @POI_Multiple_Priority := 0; -- Keep as 0 (Unused)
  78. SET @POI_Multiple_Flags := 1; -- Keep as 1 (Unused)
  79. SET @VerifiedBuild := 0; -- Client Number Added default 12340
  80.  
  81. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  82. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  83. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  84.  
  85. -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START --
  86. -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START -- MULTIPLE START --
  87.  
  88. -- POI MULTIPLE
  89.  
  90. INSERT INTO `quest_poi`
  91. VALUES
  92. (@QuestID, @POI_Multiple_id, @POI_Multiple_ObjectiveIndex, @POI_Multiple_MapID, @POI_Multiple_WorldMapAreaId, @POI_Multiple_Floor, @POI_Multiple_Priority, @POI_Multiple_Flags, @VerifiedBuild);
  93.  
  94. INSERT INTO `quest_poi_points`
  95. VALUES
  96. (@QuestID, @POI_Multiple_1_Idx1, @POI_Multiple_1_Idx2, @POI_Multiple_1_X, @POI_Multiple_1_Y, @VerifiedBuild);
  97.  
  98. INSERT INTO `quest_poi_points`
  99. VALUES
  100. (@QuestID, @POI_Multiple_2_Idx1, @POI_Multiple_2_Idx2, @POI_Multiple_2_X, @POI_Multiple_2_Y, @VerifiedBuild);
  101.  
  102. INSERT INTO `quest_poi_points`
  103. VALUES
  104. (@QuestID, @POI_Multiple_3_Idx1, @POI_Multiple_3_Idx2, @POI_Multiple_3_X, @POI_Multiple_3_Y, @VerifiedBuild);
  105.  
  106. INSERT INTO `quest_poi_points`
  107. VALUES
  108. (@QuestID, @POI_Multiple_4_Idx1, @POI_Multiple_4_Idx2, @POI_Multiple_4_X, @POI_Multiple_4_Y, @VerifiedBuild);
  109.  
  110. INSERT INTO `quest_poi_points`
  111. VALUES
  112. (@QuestID, @POI_Multiple_5_Idx1, @POI_Multiple_5_Idx2, @POI_Multiple_5_X, @POI_Multiple_5_Y, @VerifiedBuild);
  113.  
  114. INSERT INTO `quest_poi_points`
  115. VALUES
  116. (@QuestID, @POI_Multiple_6_Idx1, @POI_Multiple_6_Idx2, @POI_Multiple_6_X, @POI_Multiple_6_Y, @VerifiedBuild);
  117.  
  118. INSERT INTO `quest_poi_points`
  119. VALUES
  120. (@QuestID, @POI_Multiple_7_Idx1, @POI_Multiple_7_Idx2, @POI_Multiple_7_X, @POI_Multiple_7_Y, @VerifiedBuild);
  121.  
  122. INSERT INTO `quest_poi_points`
  123. VALUES
  124. (@QuestID, @POI_Multiple_8_Idx1, @POI_Multiple_8_Idx2, @POI_Multiple_8_X, @POI_Multiple_8_Y, @VerifiedBuild);
  125.  
  126. INSERT INTO `quest_poi_points`
  127. VALUES
  128. (@QuestID, @POI_Multiple_9_Idx1, @POI_Multiple_9_Idx2, @POI_Multiple_9_X, @POI_Multiple_9_Y, @VerifiedBuild);
  129.  
  130. INSERT INTO `quest_poi_points`
  131. VALUES
  132. (@QuestID, @POI_Multiple_10_Idx1, @POI_Multiple_10_Idx2, @POI_Multiple_10_X, @POI_Multiple_10_Y, @VerifiedBuild);
  133. /* DiSaBlE CoMmEnT (REMOVE ME IF NEEDED)
  134. DiSaBlE CoMmEnT (REMOVE ME IF NEEDED) */
  135.  
  136. -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END --
  137. -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END -- MULTIPLE END --
  138.  
  139.  
  140. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  141. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  142. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!