Grobb fixes

[Theeper]

Here is the last major fix for Grobb. 99% of the mobs are in place with this one. I haven't finished the pathing Bashers, spiders or mosquitos yet. Will post them when I am done. Sorry these are so sloppy, but I can't think of a better way to do them.

-- Okun
UPDATE npc_types SET lastname = 'Blacksmithing Supplies' WHERE id = '52044';
-- Bring Ungia back home and clean up her IDs
UPDATE spawn2 SET zone = 'grobb', x = '-446.3', y = '684.4', z = '-5.3', heading = '96.0' , spawngroupID = '52088' WHERE id = '333808';
UPDATE npc_types SET id = '52096' WHERE id = '40036';
UPDATE spawngroup SET id = '52088', name = 'spawn23882' WHERE id = '40050';
UPDATE spawnentry SET spawngroupID = '52088', npcID = '52096' WHERE npcID = '40036';
-- Rohga
UPDATE npc_types SET class = '24', gender = '0' WHERE id = '52051';
UPDATE spawn2 SET heading = '243.4' WHERE id = '309720';
-- Bring Kugaran back home and clean up his IDs
UPDATE spawn2 SET zone = 'grobb', x = '-640.4', y = '578.1', z = '14.7', heading = '255.4' , spawngroupID = '52089' WHERE id = '333848';
UPDATE npc_types SET id = '52097' WHERE id = '40075';
UPDATE spawngroup SET id = '52089', name = 'spawn23883' WHERE id = '40090';
UPDATE spawnentry SET spawngroupID = '52089', npcID = '52097' WHERE npcID = '40075';
-- Kramf
UPDATE npc_types SET lastname = 'Shadowknight Spells' WHERE id = '52043';
-- Trusk
UPDATE npc_types SET lastname = 'Shadowknight Spells' WHERE id = '52061';
-- Crikt
UPDATE npc_types SET lastname = 'Shadowknight Spells' WHERE id = '52027';
-- Treskar
UPDATE npc_types SET class = '24' WHERE id = '52060';
UPDATE spawn2 SET heading = '42.9' WHERE id = '311930';
-- Hulkulk
UPDATE spawn2 SET heading = '63.3' WHERE id = '306261';
-- Vergad
UPDATE spawn2 SET heading = '18.3' WHERE id = '312196';
-- Gluku
UPDATE spawn2 SET heading = '216.6' WHERE id = '304473';
UPDATE npc_types SET gender = '1', lastname = 'Weapons' WHERE id = '52029';
-- Create new NPC Blorgok Gkapbron
INSERT INTO npc_types VALUES (52098, 'Blorgok_Gkapbron', '', 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 (52090,'spawn23884',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52090,52098,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52090','grobb','102.6','219.4','-5.3','59.9','2200','0','0','0','0','0');
-- Create new NPC Gemcrafter Tessu
INSERT INTO npc_types VALUES (52099, 'Gemcrafter_Tessu', 'Melee Augments', 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 (52091,'spawn23885',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52091,52099,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52091','grobb','159.9','219.6','6.7','64.0','2200','0','0','0','0','0');
-- Luruk
UPDATE spawn2 SET heading = '192.0' WHERE id = '300456';
-- Daboo
UPDATE spawn2 SET heading = '187.6' WHERE id = '300465';
-- Bring Grigdor back home and clean up his IDs - NPCID: 40071 SGID: 40086
UPDATE spawn2 SET zone = 'grobb', x = '75.1', y = '211.2', z = '-5.3', heading = '41.0' , spawngroupID = '52092' WHERE id = '333844';
UPDATE npc_types SET id = '52100' WHERE id = '40071';
UPDATE spawngroup SET id = '52092', name = 'spawn23886' WHERE id = '40086';
UPDATE spawnentry SET spawngroupID = '52092', npcID = '52100' WHERE npcID = '40071';
-- Ootok
UPDATE npc_types SET gender = '1', lastname = 'General Supplies' WHERE id = '52045';
-- Bring Zignal Luk back home and clean up his IDs - NPCID: 40005 SGID: 40017
UPDATE spawn2 SET zone = 'grobb', x = '-85.0', y = '168.0', z = '4.7', heading = '75.3' , spawngroupID = '52093' WHERE id = '333777';
UPDATE npc_types SET id = '52101' WHERE id = '40005';
UPDATE spawngroup SET id = '52093', name = 'spawn23887' WHERE id = '40017';
UPDATE spawnentry SET spawngroupID = '52093', npcID = '52101' WHERE npcID = '40005';
-- Basher Kankuk
UPDATE spawn2 SET heading = '15.6' WHERE id = '300463';
-- Basher Razbaz
UPDATE spawn2 SET x = '86.7', y = '76.7', z = '4.7', heading = '163.0' WHERE id = '300470';
-- Priest of Discord
UPDATE spawn2 SET x = '-14.5', y = '28.5', z = '4.7', heading = '82.1' WHERE id = '309326';
-- Create new NPC Artisan Zermak
INSERT INTO npc_types VALUES (52102, 'Artisan_Zermak', 'Trade Skill Quests', 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 (52094,'spawn23888',0);
INSERT INTO spawnentry (spawngroupID,npcID,chance) VALUES (52094,52102,100);
INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52094','grobb','-345.9','101.2','8.8','239.4','2200','0','0','0','0','0');
-- Remove Sanfik, I don't think he's in game anymore
DELETE FROM spawn2 WHERE spawngroupID = '52052';
DELETE FROM spawnentry WHERE spawngroupID = '52052';
DELETE FROM spawngroup WHERE id = '52052';

[cavedude]

Merged into PEQ thank you!

[Theeper]

Cave, you don't have to say 'Thank you' each time.

Thank you for letting me use the PEQ DB.

[Angelox]

I think the input from Cavedude is nice, this way I know he sees the fixes.

[sfisque]

Originally Posted by Angelox

I think the input from Cavedude is nice, this way I know he sees the fixes.

aye. a "thanks" post from cavedude is like jesus' face on your toast. even if you're not a christian, you get a sense that someone "up there" is smiling

== sfisque

[Theeper]

LOL Sfisque.

It is nice to know the work is being used though.

[cavedude]

That's one of the reasons why I try to respond. I don't want people to think their work goes unnoticed. I just have to start getting better at replying to threads for work I can't use though, and explaining why

The other reason is for my own benefit. I get pulled in many directions with PEQ and my memory isn't what it used to be, so I try to leave little notes for myself so I don't backtrack