classicdb/database — pull request #686 by Zingzah (2014-12-21 12:09:13+00:00)
Title: Gizelton Caravan Update

This is a first pass to upgrading the current Gizelton Caravan event in Desolace. I have looked on many cores and can't find a working version of this on any at the moment. I have used a few sources as well as personal experience in configuring the bahaviour of the caravan at various stages. The sources are
http://www.wowwiki.com/Gizelton_Caravan
http://www.wowwiki.com/Quest:Gizelton_Caravan
https://www.youtube.com/watch?v=VtOREFq5fDQ
https://www.youtube.com/watch?v=VtOREFq5fDQ
http://www.wowhead.com/npc=11625/cork-gizelton#comments
http://www.wowhead.com/npc=12246#comments
http://www.wowhead.com/npc=12245#comments
http://www.wowwiki.com/Schematic:_Accurate_Scope
http://www.wowwiki.com/Schematic:_Ice_Deflector
http://www.wowwiki.com/Goblin_Jumper_Cables
![super_seller](https://cloud.githubusercontent.com/assets/5461014/5518045/22ce052a-8966-11e4-9be8-652ac08f3ef4.jpg)
![super_seller2](https://cloud.githubusercontent.com/assets/5461014/5518046/22d00e06-8966-11e4-8c13-cd1b2ae629f3.jpg)

Currently the caravan travels endlessly between Kormek's Hut and the southern crossroads where the paths to Feralas, Shadowprey Village and Mannoroc Coven meet. At Kormek's Hut the Vendor-tron 1000 is spawned continously as is the Super-seller 680 at the southern stop. Both Cork and Rigger have available, at all times, the "Bodyguards for Hire" and "Gizelton Caravan" quests which when accepted, do nothing.
So the changes listed below will achieve the following:

1. Set the movement type of both vendor-tron 1000 (12245) and Super-seller 680(12246) to stationary.

2. Adjust the waypoints at both ends of the journey to coincide more accurately with the stopping points for both ends.

3. As mentioned in the wowwiki entry for the Gizelton Caravan quest, the caravan's usual movement is running and during the escort for each quest it slows to walking speed.

4. Configuring the Vendor-tron and Super-seller to spawn only during the stopping times of the caravan at either end and then despawn once the caravan has departed.

5. Set stopping points for both Bodyguards for Hire and Gizelton Caravan quests where the caravan waits for quest acceptance and set the relevent advertising zone-wide yell for these quests.

6. Move both waypoints for Cork and Rigger Gizelton from the creature_movement table to the creature_movement_template table as these are unique npcs.

7. Configure the quest for each npc to only be available at the respective waiting points.

8. To remove items from the Super-seller that should not be available from this vendor.ie Accurate Scope, Goblin Jumper Cables and Ice Deflector schematics

9. Waiting times at northern and southern stops is 10 mins. Departing emotes are said 10 seconds prior. Waiting times at quest acceptance stops is 5 mins.

There are a few issues this upgrade does not address and include:

1. The escort script for both quests needs to completed. I wasn't sure if db scripts could achieve this or whether it needs to be done through SD2.

2. The current core prevents the caravan from completing the journey autonomously without player proximity. However comments listed above (wowhead entries) indicate the caravan behaving differently in proximity to players than out of range. Having read a recent post in the forums about active objects/npcs, this might be a solution to this issue.

3. I haven't been able to remove the quest option from Cork or Rigger when they are the northern or southern stopping points. This needs to be achieved as the respective quests should only be available at the advertised points along the route.

4. This is a general issue not specific to the caravan but I have noticed npcs can't be healed or buffed in many escort quests. The youtube videos above clearly show this should be possible.

Database Changes
Cork Gizelton (template entry 12245 guid 28714)
Rigger Gizelton (template entry 12246 guid 28728)
Gizelton Caravan Kodo (template entry 11564 guid 27290 (front) 27289 (back))
Vendor-tron 1000 (template entry 12245)
Super-seller 680 (template entry 12246)
creature_movement

Please only consider the last commit [852] - Gizelton Caravan the others are dry runs I haven't work out how to get rid of from my local repo.