EastKarana: Sir Morgan's Armor: Sir Morgan

[gatorman]

Thanks!

I have worked on this guy a little more because he needs to 'clear the way' and he wasn't doing that before...:

Also, I changed the waypoints again, by adding more so that when Sir Morgan aggros something, he doesn't skip halfway across the zone trying to reach the next waypoint.

One other thing to note: There seems to be a few bad spawn group entries in East Karanas. There are several a_bandit 's on the trail which have erroneous coordinates (z = 32352522).. I removed the spawn groups from my database: 673, 674, 7189, 7191

#Allow Sir Morgan to attack mobs
UPDATE `npc_types` SET npc_aggro = '1' where `id` = '15045';
#Assign factions for Sir Morgan to attack
INSERT into `npc_faction_entries` VALUES (69,366,0,-1); #KOS
INSERT into `npc_faction_entries` VALUES (69,367,0,-1); #KOS_animal
INSERT into `npc_faction_entries` VALUES (69,394,0,-1); #Noob mobs
INSERT into `npc_faction_entries` VALUES (69,16437,0,-1); #EK Bandits
#These waypoints are better for Sir Morgan
REPLACE into `grid_entries` VALUES (115,15,1,202,-14,4,1,45);
REPLACE into `grid_entries` VALUES (115,15,2,139,-9,4,195,0);
REPLACE into `grid_entries` VALUES (115,15,3,46.6,-2.6,3.8,195,0);
REPLACE into `grid_entries` VALUES (115,15,4,-39.5,3.7,3.8,195,0);
REPLACE into `grid_entries` VALUES (115,15,5,-27.5,-104.7,3.8,123.6,0);
REPLACE into `grid_entries` VALUES (115,15,6,-17.9,-191.7,3.8,123.6,0);
REPLACE into `grid_entries` VALUES (115,15,7,-35.3,-300,3.8,134.5,0);
REPLACE into `grid_entries` VALUES (115,15,8,-102.6,-359.6,3.8,162.6,0);
REPLACE into `grid_entries` VALUES (115,15,9,-179.3,-427.4,3.8,162.6,0);
REPLACE into `grid_entries` VALUES (115,15,10,-237.8,-479.2,5.6,162.6,0);
REPLACE into `grid_entries` VALUES (115,15,11,-329,-559.8,17.6,162.6,0);
REPLACE into `grid_entries` VALUES (115,15,12,-405.9,-627.8,27.7,162.6,0);
REPLACE into `grid_entries` VALUES (115,15,13,-535.9,-632.5,29.8,190.6,0);
REPLACE into `grid_entries` VALUES (115,15,14,-673.5,-637.6,44.8,190.6,0);
REPLACE into `grid_entries` VALUES (115,15,15,-827,-635.5,66.4,192.6,0);
REPLACE into `grid_entries` VALUES (115,15,16,-1071,-632,60,192,0);
REPLACE into `grid_entries` VALUES (115,15,17,-1244,-630,55,192,0);
REPLACE into `grid_entries` VALUES (115,15,18,-1433,-628,34,192,0);
REPLACE into `grid_entries` VALUES (115,15,19,-1537,-626,16,192,0);
REPLACE into `grid_entries` VALUES (115,15,20,-1659,-521,8,221,0);
REPLACE into `grid_entries` VALUES (115,15,21,-1796,-403,3.8,221,0);
REPLACE into `grid_entries` VALUES (115,15,22,-1909,-305,3.8,221,0);
REPLACE into `grid_entries` VALUES (115,15,23,-2074,-309.9,3.8,191.3,0);
REPLACE into `grid_entries` VALUES (115,15,24,-2219,-309.9,3.8,192,0);
REPLACE into `grid_entries` VALUES (115,15,25,-2376.7,-306,3.8,193.4,0);
REPLACE into `grid_entries` VALUES (115,15,26,-2547,-301.9,3.8,193.4,0);
REPLACE into `grid_entries` VALUES (115,15,27,-2726,-328.4,3.8,186.1,0);
REPLACE into `grid_entries` VALUES (115,15,28,-2893,-353,3.8,186,30);

[Angelox]

Often, I'll use REPLACE when I want to delete an entry and put in new data for the same entry - just have to be careful because it's a terminal action, and doesn't ask you if you're sure you want to.
Always good to back up often when your doing DB work. I have tons of old back ups everywhere.

[cavedude]

Committed the quest and sql queries, and corrected the broken spawns.