Freeport

[Cynnar]

North Freeport

• Spawns
  • Mass Pop
  • Jabantiz (Cleanup)
  • Cynnar (Cleanup)
• Scripts

Spawns

• Octavius Syntrail <Arcane Transcription> (1440204) Missing merchants list
• Gadko <Vassi's Assistant> (1440017) Missing merchants list

Quests
- Done
- Needs work
- Not started

• Dismal Tidings
• The Mouth of Evil
• Shipment for Jabir
• Gathering Brittle Bones
• Message for Anessa
• The Mariner's Rhyme
• Hazrulin's Research
• Note for Lusius

Events

• There Goes the Neighborhood
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1440096, 1440104, 1440108, 1440098, 1440106, 1440097, 1440115, 1440105);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1440096, 1440104, 1440108, 1440098, 1440106, 1440097, 1440115, 1440105));
    

• Nights of the Dead
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1440074, 1440393, 1440390, 1440389, 1440397);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1440074, 1440393, 1440390, 1440389, 1440397));
    

Notes

• Post on lore

Duplicate spawns have been removed.
One crazy spawnscript for movement (in progress)
Working Doors (minis housing doors) (needs double checked)

[Cynnar]

East Freeport

• Spawns
  • Mass Pop
  • Cynnar (Cleanup)
• Scripts

Spawns

Quests
- Done
- Needs work
- Not started

• Message for Boomba
• Message for Mallius
• Sewer Problem: A Gnome Solution
• Typhoeus's Blackmail
• Cold Forged Armor - Part I
• Cold Forged Armor - Part II
• Cold Forged Armor - Part III
• Cold Forged Armor - Part IV
• Cold Forged Armor - Part V
• Cold Forged Armor - Part VI
• Dalal's Message
• Delivery to the Crossroads
• Free the Decaying Darkfathoms
• Kill the Giantslayers
• Message for Sergius
• Putting Zombies To Rest

Events

• Frostfell
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1280275, 1280311, 1280276, 1280284, 1280249, 1280268, 1280259, 1280263, 1280264, 1280256, 1280245, 1280261, 1280251, 1280298, 1280260, 1280246, 1280269, 1280278, 1280266, 1280265, 1280279, 1280273, 1280277, 1280281, 1280283, 1280247, 1280293, 1280286, 1280296, 1280297, 1280285, 1280272, 1280282, 1280258, 1280280, 1280274, 1280257, 1280252, 1280270, 1280253, 1280250, 1280254, 1280262, 1280255, 1280267, 1280248);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1280275, 1280311, 1280276, 1280284, 1280249, 1280268, 1280259, 1280263, 1280264, 1280256, 1280245, 1280261, 1280251, 1280298, 1280260, 1280246, 1280269, 1280278, 1280266, 1280265, 1280279, 1280273, 1280277, 1280281, 1280283, 1280247, 1280293, 1280286, 1280296, 1280297, 1280285, 1280272, 1280282, 1280258, 1280280, 1280274, 1280257, 1280252, 1280270, 1280253, 1280250, 1280254, 1280262, 1280255, 1280267, 1280248);
    

• Nights of the Dead
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1280302, 1280300, 1280304, 1280301, 1280309, 1280308, 1280307, 1280305, 1280306, 1280303, 1280065, 1280066, 1280064);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1280302, 1280300, 1280304, 1280301, 1280309, 1280308, 1280307, 1280305, 1280306, 1280303, 1280065, 1280066, 1280064);
    

• There Goes the Neighborhood
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1280084, 1280122, 1280106, 1280086, 1280105, 1280121, 1280082, 1280099, 1280101, 1280077, 1280078, 1280100);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1280084, 1280122, 1280106, 1280086, 1280105, 1280121, 1280082, 1280099, 1280101, 1280077, 1280078, 1280100);
    

• Clockwork Herald XV1.03 <Tinkerfest>
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1280076);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1280076);
    

Notes

Duplicate spawns removed (minus ones used to mark paths)
Doors working (Minus housing) (needs double checked)

[Cynnar]

With the help of [mention]Jabantiz[/mention] and [mention]smash[/mention] I have the lifts working. Big thanks to you both for the help.

[Cynnar]

South Freeport

• Spawns
  • Mass Pop
  • Cynnar (Cleanup)
• Scripts

Spawns

• Seafury Buccaneer on the boat are missing merchants list

Quests
- Done
- Needs work
- Not started

Events

• Frostfell
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1660141, 1660175, 1660176, 1660145, 1660168, 1660158, 1660215, 1660155, 1660162, 1660163, 1660154, 1660184, 1660169, 1660160, 1660147, 1660200, 1660159, 1660142, 1660170, 1660178, 1660166, 1660165, 1660164, 1660179, 1660152, 1660177, 1660181, 1660182, 1660143, 1660195, 1660188, 1660187, 1660183, 1660198, 1660199, 1660185, 1660214, 1660173, 1660157, 1660153, 1660174, 1660156, 1660186, 1660167, 1660172, 1660144, 1660151, 1660161, 1660150, 1660171, 1660146, 1660149, 1660148);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1660141, 1660175, 1660176, 1660145, 1660168, 1660158, 1660215, 1660155, 1660162, 1660163, 1660154, 1660184, 1660169, 1660160, 1660147, 1660200, 1660159, 1660142, 1660170, 1660178, 1660166, 1660165, 1660164, 1660179, 1660152, 1660177, 1660181, 1660182, 1660143, 1660195, 1660188, 1660187, 1660183, 1660198, 1660199, 1660185, 1660214, 1660173, 1660157, 1660153, 1660174, 1660156, 1660186, 1660167, 1660172, 1660144, 1660151, 1660161, 1660150, 1660171, 1660146, 1660149, 1660148);
    

• Nights of the Dead
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1660044, 1660204,1660202, 1660206, 1660203, 1660211, 1660213, 1660210, 1660209, 1660207, 1660208, 1660205, 1660042, 1660000, 1660001);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1660044, 1660204,1660202, 1660206, 1660203, 1660211, 1660213, 1660210, 1660209, 1660207, 1660208, 1660205, 1660042, 1660000, 1660001);
    

• There Goes the Neighborhood
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1660067, 1660082, 1660076, 1660073, 1660049, 1660071, 1660072, 1660058, 1660051, 1660055, 1660066, 1660059, 1660056, );
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (000000);
    

Notes

• There Goes the Neighborhood will only turn on and off the Thexian's and Dreadnaught's. Not Freeport Spawns.

[Cynnar]

West Freeport

• Spawns
  • Mass Pop
  • Jabantiz (Cleanup)
  • Cynnar (Cleanup)
• Scripts

Spawns

Quests
- Done
- Needs work
- Not started

• The Head of Marius
• Collecting for the Militia
• Vengeance For Caius
• Coalition Cleanup
• Coalition Cleanup Continued
• Mysterious Delivery
• Trials of the Soldier

Events

• Frostfell
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1680312, 1680337, 1680355, 1680328, 1680315, 1680326, 1680332, 1680333, 1680325, 1680359, 1680330, 1680317, 1680375, 1680329, 1680318, 1680338, 1680347, 1680335, 1680334, 1680348, 1680342, 1680346, 1680350, 1680324, 1680353, 1680354, 1680313, 1680371, 1680361, 1680360, 1680376, 1680378, 1680357, 1680403, 1680321, 1680352, 1680349, 1680343, 1680327, 1680319, 1680323, 1680316, 1680320, 1680331, 1680339, 1680322, 1680314, 1680358, 1680004, 1680005, 1680006, 1680345, 1680029, 1680377, 1680340);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1680312, 1680337, 1680355, 1680328, 1680315, 1680326, 1680332, 1680333, 1680325, 1680359, 1680330, 1680317, 1680375, 1680329, 1680318, 1680338, 1680347, 1680335, 1680334, 1680348, 1680342, 1680346, 1680350, 1680324, 1680353, 1680354, 1680313, 1680371, 1680361, 1680360, 1680376, 1680378, 1680357, 1680403, 1680321, 1680352, 1680349, 1680343, 1680327, 1680319, 1680323, 1680316, 1680320, 1680331, 1680339, 1680322, 1680314, 1680358, 1680004, 1680005, 1680006, 1680345, 1680029, 1680377, 1680340);
    

• Nights of the Dead
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1680095, 1680098, 1680392, 1680390, 1680394, 1680391, 1680398, 1680406, 1680400, 1680397, 1680395, 1680396, 1680405, 1680393, 1680404, 1680245, 1680111, 1680102, 1680110, 1680106, 1680115, 1680103, 1680099, 1680107, 1680100, 1680097, 1680096, 1680242, 1680462, 1680105, 1680380);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1680095, 1680098, 1680392, 1680390, 1680394, 1680391, 1680398, 1680406, 1680400, 1680397, 1680395, 1680396, 1680405, 1680393, 1680404, 1680245, 1680111, 1680102, 1680110, 1680106, 1680115, 1680103, 1680099, 1680107, 1680100, 1680097, 1680096, 1680242, 1680462, 1680105, 1680380);
    

• Bristlebane Day
  • Turn off

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 0 WHERE id in (1680265, 1680263, 1680264);
    

  • Turn on

    Code: Select all

    UPDATE spawn_location_entry SET spawnpercentage = 100 WHERE id in (1680265, 1680263, 1680264);
    

Notes

Duplicate spawns removed (minus ones used to mark paths)