http://oldforums.eq2classic.com/

Freeport

http://oldforums.eq2classic.com/viewtopic.php?t=4483

Page 1 of 1

Freeport

Posted: Fri Jun 01, 2018 9:57 pm
by 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 Duplicate spawns have been removed.
One crazy spawnscript for movement (in progress)
Working Doors (minis housing doors) (needs double checked)

East Freeport

Posted: Sun Jun 03, 2018 3:48 pm
by 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)

Re: North Freeport

Posted: Tue Jun 05, 2018 12:19 am
by 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.

South Freeport

Posted: Tue Jun 05, 2018 9:49 pm
by 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.

West Freeport

Posted: Wed Jun 13, 2018 9:02 am
by 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)
All times are UTC-07:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited