Grobb fixes

Theeper · #3 11-27-2007, 02:49 PM

Here is some more location fixes for Grobb. Again, I added a couple NPC's and moved some back from Neriak. One more of these and I think I will have the whole zone in place.

Code:

-- Basher Banzuk
UPDATE spawn2 SET x = '-409.0' , y = '449.6' , z = '-5.3' , heading = '224.1' WHERE id = '300455';
-- Raztara
UPDATE spawn2 SET x = '-392.1' , y = '439.7' , z = '-5.3' , heading = '246.4' WHERE id = '309576';
UPDATE npc_types SET lastname = 'Alchemy Supplies' WHERE id = '52049';
-- Uzak
UPDATE npc_types SET gender = '1', lastname = 'Jewelcrafting Supplies' WHERE id = '52063';
-- Basher Bugak
UPDATE spawn2 SET x = '-490.9' , y = '602.4' , z = '-5.3' , heading = '15.5' WHERE id = '300457';
-- Rasrok the Blotched
UPDATE spawn2 SET x = '-569.5' , y = '612,4' , z = '-5.3' , heading = '60.8' WHERE id = '313865';
-- Chamt
UPDATE spawn2 SET x = '-429.2' , y = '17.2' , z = '54.7' , heading = '240.6' WHERE id = '301218';
UPDATE npc_types SET lastname = 'Shaman Spells' WHERE id = '52025';
-- Urako
UPDATE npc_types SET gender = '1' WHERE id = '52062';
-- Basher Glaum
UPDATE spawn2 SET x = '-434.9' , y = '-15.5' , z = '74.7' , heading = '254.5' WHERE id = '300460';
-- Gargunk
UPDATE spawn2 SET x = '-416.4' , y = '-4.9' , z = '74.7' , heading = '222.6' WHERE id = '313864';
-- Basher Stizik
UPDATE spawn2 SET x = '-542.7' , y = '436.2' , z = '14.7' , heading = '156.9' WHERE id = '300475';
-- Basher Gobzin
UPDATE spawn2 SET x = '-544.1' , y = '467.0' , z = '14.7' , heading = '159.1' WHERE id = '300461';
-- Zazhar
UPDATE npc_types SET lastname = 'Fishing Supplies' WHERE id = '52067';
-- Garklog
UPDATE spawn2 SET x = '-207.0' , y = '502.5' , z = '-5.3' , heading = '163.8' WHERE id = '313869';
UPDATE npc_types SET lastname = 'Baking Supplies' WHERE id = '52075';
-- Bimuk
UPDATE spawn2 SET x = '-220.2' , y = '517.2' , z = '-5.3' , heading = '126.0' WHERE id = '300578';
UPDATE npc_types SET lastname = 'General Supplies' WHERE id = '52022';
-- Iskopa
UPDATE spawn2 SET x = '-235.7' , y = '508.9' , z = '-5.3' , heading = '91.3' WHERE id = '306692';
UPDATE npc_types SET lastname = 'Armor' WHERE id = '52037';
-- Rezslog
UPDATE spawn2 SET heading = '29.8' WHERE id = '309638';
UPDATE npc_types SET lastname = 'Jewlcrafting Supplies' WHERE id = '52050';
-- Vynugga
UPDATE npc_types SET lastname = 'Pottery Supplies' WHERE id = '52069';
-- Hartok
UPDATE npc_types SET lastname = 'Weapons' WHERE id = '52033';
-- Tangiz
UPDATE npc_types SET lastname = 'Weapons' WHERE id = '52058';
-- Jarlok
UPDATE spawn2 SET z = '-5.2', heading = '69.1' WHERE id = '306753';
UPDATE npc_types SET lastname = 'Armor' WHERE id = '52038';
-- Spawn NPC Beztopi
INSERT INTO spawngroup (id,name,spawn_limit) VALUES (52084,'spawn23878',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52084,52021,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52084','grobb','-235.8','361.9','-5.3','24.5','2200','0','0','0','0','0');
UPDATE npc_types SET lastname = 'Armor' WHERE id = '52021';
-- Create new NPC Bukton
INSERT INTO npc_types VALUES (52093, 'Bukton', 'Armor', 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 spawngroup (id,name,spawn_limit) VALUES (52085,'spawn23879',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52085,52093,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52085','grobb','-194.6','364.5','-5.3','221.9','2200','0','0','0','0','0');
-- Move Grallvek (The Town Crier) back
UPDATE spawn2 SET zone = 'grobb', x = '-91.8', y = '387.4', z = '3.5', heading = '81.5' WHERE id = '333843';
-- Hergor
UPDATE spawn2 SET heading = '73.9' WHERE id = '306182';
UPDATE npc_types SET lastname = 'Warrior Guildmaster' WHERE id = '52034';
-- Kragia
UPDATE spawn2 SET heading = '3.5' WHERE id = '307242';
UPDATE npc_types SET class = '20' WHERE id = '52042';
-- Ranjor
UPDATE spawn2 SET heading = '124.9' WHERE id = '309495';
-- Create new NPC Chopper Brenga
INSERT INTO npc_types VALUES (52094, 'Chopper_Brenga', 'Baking 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 spawngroup (id,name,spawn_limit) VALUES (52086,'spawn23880',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52086,52094,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52086','grobb','-170.6','224.5','4.7','177.5','2200','0','0','0','0','0');
-- Bring Goldush 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 = '52087' WHERE id = '333846';
UPDATE npc_types SET id = '52095', race = '92' WHERE id = '40073';
UPDATE spawngroup SET id = '52087', name = 'spawn23881' WHERE id = '40088';
UPDATE spawnentry SET spawngroupID = '52087', npcID = '52095' WHERE npcID = '40073';
-- Gartonka
UPDATE spawn2 SET heading = '149.0' WHERE id = '304058';
UPDATE npc_types SET lastname = 'Baking Supplies' WHERE id = '52028';
-- Wista
UPDATE spawn2 SET heading = '59.9' WHERE id = '312494';
-- Graztak
UPDATE npc_types SET lastname = 'Satchels' WHERE id = '52031';
-- Basher Rakguk
UPDATE spawn2 SET heading = '181.0' WHERE id = '300469';
-- Kagbek
UPDATE spawn2 SET heading = '254.3' WHERE id = '306853';
UPDATE npc_types SET lastname = 'General Supplies' WHERE id = '52040';
-- Gralok
UPDATE npc_types SET class = '20' WHERE id = '52032';