API tools faq
paste
Guest User

QUEST- POI Template - Turn In.sql

a guest
Jan 2nd, 2025
30
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.29 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. -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START --
  13. -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START -- SINGLE START --
  14.  
  15. -- POI SINGLE (SINGLE OBJECTIVE)
  16. SET @POI_Single_id := 1; -- Use 0 for SINGLE OBJECTIVE
  17. SET @POI_Single_ObjectiveIndex := -1; -- Use -1 SINGLE OBJECTIVE
  18. SET @POI_Single_MapID := 981; -- 981 = Kingdom. 982 = Event Island, 983 = Nightmare of Egorius
  19. SET @POI_Single_WorldMapAreaId := 6516; -- AreaID of the POI location
  20.  
  21. -- POI SINGLE POINT */
  22. SET @POI_Single_Point_Idx1 := 1; -- Use 1 for Single Point (DONT CHANGE, USE MULTIPLE)
  23. SET @POI_Single_Point_Idx2 := 1; -- Use 1 for Single Point (DONT CHANGE, USE MULTIPLE)
  24. SET @POI_Single_Point_X := 14028; -- The X position of the question mark on the map.
  25. SET @POI_Single_Point_Y := 5592; -- The Y position of the question mark on the map.
  26.  
  27. -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END --
  28. -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END -- SINGLE END --
  29.  
  30. -- OTHER CRAP
  31. SET @POI_Single_Floor := 0; -- Keep as 0 (Unused)
  32. SET @POI_Single_Priority := 0; -- Keep as 0 (Unused)
  33. SET @POI_Single_Flags := 1; -- Keep as 1 (Unused)
  34. SET @VerifiedBuild := 0; -- Client Number Added default 12340
  35.  
  36. -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END --
  37. -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END --
  38. -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END --
  39. -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END -- DATA FOR CREATION END --
  40.  
  41. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  42. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  43. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  44.  
  45. -- POI SINGLE
  46. -- (`QuestID`, `id`, `ObjectiveIndex`, `MapID`, `WorldMapAreaId`, `Floor`, `Priority`, `Flags`, `VerifiedBuild`
  47. INSERT INTO `quest_poi`
  48. VALUES
  49. (@QuestID, @POI_Single_id, @POI_Single_ObjectiveIndex, @POI_Single_MapID, @POI_Single_WorldMapAreaId, @POI_Single_Floor, @POI_Single_Priority, @POI_Single_Flags, @VerifiedBuild);
  50.  
  51. -- POINT SINGLE POINT
  52. -- (`QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `VerifiedBuild`)
  53. INSERT INTO `quest_poi_points`
  54. VALUES
  55. (@QuestID, @POI_Single_Point_Idx1, @POI_Single_Point_Idx2, @POI_Single_Point_X, @POI_Single_Point_Y, @VerifiedBuild);
  56.  
  57. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  58. -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES -- QUERIES --
  59. -- 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!