Grobb fixes
* This is done on a fresh install of PEQ-Ykesha-Beta1
Here is some location fixes to put the proper mobs in place near the bank in Grobb where all the shaman and alchemy vendors are. This will put them all back in a nice circle around the wall just like they're supposed to be.
I created a couple new mobs and moved a couple from other zones. I created a few new npcID's and spawngroups and updated the ID's of the npc's I moved to reflect Grobb's zoneID. Also, I renamed two mobs (Grordoz and Terkoz) to mobs that weren't in the DB. Those two don't seem to be in-game anymore. I left out one mob that's on Live named Mulg, he doesn't seem to do anything and I am not sure he isn't temporary or something.
If you've done any work in this zone, make sure to check these statements before using them. I put comments into each NPC I tweaked, so you can remove any you don't want messed with. I haven't had any problems so far with any of this, but of course back up your DB before using these.
Code:
-- Blergagg
UPDATE spawn2 SET x = '-426.5' , y = '417.6' , z = '4.7' , heading = '147.5' WHERE id = '313867';
UPDATE npc_types SET texture = '1', race = '92', lastname = 'Alchemy Supplies' WHERE name = 'Blergagg';
-- Gargh
UPDATE spawn2 SET x = '-434.8' , y = '423.6' , z = '4.7' , heading = '151.8' WHERE id = '313870';
-- Grabah
UPDATE spawn2 SET x = '-417.3' , y = '413.4' , z = '4.7' , heading = '166.3' WHERE id = '305350';
UPDATE npc_types SET texture = '1', race = '92', lastname = 'Alchemy Supplies' WHERE name = 'Grabah';
-- Cralk
UPDATE spawn2 SET x = '-420.0' , y = '284.0' , z = '4.7' , heading = '239.1' WHERE id = '301491';
UPDATE npc_types SET lastname = 'Shaman Spells', race = '92' WHERE name = 'Cralk';
-- Barsk
UPDATE spawn2 SET x = '-414.2' , y = '300.6' , z = '4.7' , heading = '245.8' WHERE id = '300444';
UPDATE npc_types SET lastname = 'Shaman Spells', race = '92' WHERE name = 'Barsk';
-- Hoart
UPDATE spawn2 SET x = '-405.6' , y = '323.0' , z = '4.7' , heading = '218.1' WHERE id = '306243';
UPDATE npc_types SET lastname = 'Shaman Spells', race = '92' WHERE name = 'Hoart';
-- Tokun
UPDATE spawn2 SET heading = '234.3' WHERE id = '311790';
UPDATE npc_types SET lastname = 'Shaman Spells', race = '92' WHERE name = 'Tokun';
-- Jokca
UPDATE spawn2 SET x = '-458.3' , y = '346.8' , z = '4.7' , heading = '132.0' WHERE id = '306790';
-- Soulbinder Snog
UPDATE spawn2 SET x = '87.7' , y = '62.3' , z = '4.8' , heading = '233.6' WHERE id = '312838';
-- Basher Gamuk
UPDATE spawn2 SET x = '-475.5' , y = '276,1' , z = '14.7' , heading = '4.6' WHERE id = '300458';
-- Carver Cagrek
UPDATE spawn2 SET heading = '69.6' WHERE id = '301164';
-- Change Grordoz to Glubtak. These two NPCs don't seem to be in the game anymore, so turn them into BL spell vendors
UPDATE npc_types SET name = 'Glubtak', lastname = 'Beastlord Spells', race = '92', texture = '1' WHERE name = 'Grordoz';
UPDATE spawn2 SET x = '-446.0' , y = '427.5' , z = '4.7' , heading = '160.0' WHERE id = '313868';
-- Change Terkoz to Tracab
UPDATE npc_types SET name = 'Tracab', lastname = 'Beastlord Spells', race = '92', texture = '1' WHERE name = 'Terkoz';
UPDATE spawn2 SET x = '-393.1' , y = '367.8' , z = '4.7' , heading = '210.0' WHERE id = '313866';
-- Create a new NPC, Behagg - * not sure of the stats, just copied over one of the nearby vendors for this
INSERT INTO spawngroup (id,name,spawn_limit) VALUES (52079,'spawn23873',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52079,52088,100);
INSERT INTO npc_types VALUES (52088, 'Behagg', 'Alchemy Supplies', 40, 92, 41, 1, 3250, 0, 1, 1, 0, 16, 16, 0, 0, 0, 1889, 16, 83, '', 50, 3, 0, 0, 0, 1, 0, 0, 0, 0, 250, 40, 40, 40, 40, 40, 0, 1, 0, 966, 0, 0, -9, 1, 132, 132, 132, 132, 132, 132, 132, 0, 0, 1, 0);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52079','grobb','-406.3','411.2','4.7','144.0','2200','0','0','0','0','0');
-- Create a new NPC, Blergrab - * not sure of the stats, just copied over one of the nearby vendors for this
INSERT INTO spawngroup (id,name,spawn_limit) VALUES (52080,'spawn23874',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52080,52089,100);
INSERT INTO npc_types VALUES (52089, 'Blergrab', 'Alchemy Supplies', 40, 92, 41, 1, 3250, 0, 1, 1, 0, 16, 16, 0, 0, 0, 1889, 16, 83, '', 50, 3, 0, 0, 0, 1, 0, 0, 0, 0, 250, 40, 40, 40, 40, 40, 0, 1, 0, 966, 0, 0, -9, 1, 132, 132, 132, 132, 132, 132, 132, 0, 0, 1, 0);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52080','grobb','-390.9','406.6','4.7','137.6','2200','0','0','0','0','0');
-- Korff - move him back from Oggok and clean up his ID's
UPDATE spawn2 SET zone = 'grobb', x = '-438.0', y = '301.2', z = '4.7', heading = '17.9' , spawngroupID = '52081' WHERE id = '334004';
UPDATE npc_types SET id = '52090', race = '92' WHERE id = '49029';
UPDATE spawngroup SET id = '52081', name = 'spawn23875' WHERE id = '49039';
UPDATE spawnentry SET spawngroupID = '52081', npcID = '52090' WHERE npcID = '49029';
-- Create a new NPC Basher Zazluk - * not sure of the stats, just copied over one of the nearby bashers for this
INSERT INTO spawngroup (id,name,spawn_limit) VALUES (52082,'spawn23876',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52082,52091,100);
INSERT INTO npc_types VALUES (52091, 'Basher_Zazluk', '', 39, 92, 1, 1, 2499, 0, 0, 0, 0, 12, 12, 0, 0, 0, 1290, 16, 81, '', 50, 4, 0, 0, 0, 1, 0, 0, 0, 0, 250, 39, 39, 39, 39, 39, 0, 1, 0, 920, 1, 0, -9, 0, 128, 128, 128, 128, 128, 128, 128, 0, 0, 1, 0);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52082','grobb','-441.0','274.9','14.7','4.5','2200','0','0','0','0','0');
-- Bring Zumzal back home and clean up his IDs
UPDATE spawn2 SET zone = 'grobb', x = '-495.0', y = '329.0', z = '4.7', heading = '55.5' , spawngroupID = '52083' WHERE id = '333794';
UPDATE npc_types SET id = '52092', race = '92' WHERE id = '40022';
UPDATE spawngroup SET id = '52083', name = 'spawn23877' WHERE id = '40036';
UPDATE spawnentry SET spawngroupID = '52083', npcID = '52092' WHERE npcID = '40022';
-- Remove the Skeletons near Carver Cagrek (i don't think they go anywhere in this zone)
DELETE FROM spawn2 WHERE spawngroupID = '52054' || spawngroupID = '52055' || spawngroupID = '52056';
DELETE FROM spawnentry WHERE spawngroupID = '52054' || spawngroupID = '52055' || spawngroupID = '52056';
DELETE FROM spawngroup WHERE id = '52054' || id = '52055' || id = '52056';
I have more of these and some grids and vendor lists, I will export as I get chunks of them done.
|