EQEmulator Forums - Grobb fixes

Page 1 of 2

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Grobb fixes (https://www.eqemulator.org/forums/showthread.php?t=23918)

Theeper

11-23-2007 04:41 PM

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.

cavedude

11-27-2007 07:37 AM

Commited thank you! I'm excited to see the finished product.

Theeper

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';

Theeper

11-27-2007 04:18 PM

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.

Code:

-- 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

11-28-2007 01:46 AM

Merged into PEQ thank you!

Theeper

11-28-2007 02:28 AM

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

Thank you for letting me use the PEQ DB. :)

Angelox

11-28-2007 03:43 AM

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

sfisque

11-28-2007 04:35 AM

Quote:

Originally Posted by Angelox (Post 140648)

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

11-28-2007 11:01 AM

LOL Sfisque.

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

cavedude

11-29-2007 05:06 AM

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 ;)

Theeper

12-06-2007 04:23 PM

Here is a couple NPC's I missed and the spiders and mosquitos. This will add 9 spiders. There is a couple more that should spawn, but I haven't got them all figured out yet. These include grid ID's which I will post next.

Code:

-- move Exterminator Filrog back to Grobb

UPDATE spawn2 SET zone = 'grobb', x = '-219.6', y = '618.8', z = '-24.5', heading = '167.5' WHERE id = 333776;

-- Basher Sutok

UPDATE spawn2 SET x = '-73.6', y = '145.8', z = '4.7', heading = '255.3' WHERE id = 300476;

-- Basher Nagkuma

UPDATE spawn2 SET x = '-220.9' , y = '439.6' , z = '22.4' , heading = '255.5' WHERE spawngroupID = '52011';

-- create 'a jungle hatchling' spawns in grobb

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-362.3','674.5','-5.3','64.4','320','0','1','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-643.2','606.5','11.6','251.1','320','0','2','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-159.3','447.1','-8.4','234.5','320','0','3','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-284.2','209.8','1.6','26.4','320','0','4','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-94.7','317.5','1.6','199.9','320','0','5','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-329.9','674.2','-8.4','71.6','320','0','6','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-560.9','418.3','11.1','1.4','320','0','7','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-289.7','488.4','-8.4','194.4','320','0','8','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52095','grobb','-171.6','495.9','-9.0','102.6','320','0','9','0','0','1');

INSERT INTO spawngroup VALUES (52095,'spawn23889',0);

INSERT INTO spawnentry VALUES (52095,50300,100);

-- fix the spiders appearance

UPDATE npc_types SET race = '440', gender = '2', size = '4' WHERE id = '50300';

-- a domesticatd bleeder spawn

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52096','grobb','-136.3','244.8','8.7','8.0','320','0','0','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52096','grobb','-133.9','305.8','4.7','69.4','320','0','0','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52096','grobb','-34.2','318.3','4.7','161.8','320','0','10','0','0','1');

INSERT INTO spawn2 (spawngroupID,zone,x,y,z,heading,respawntime,variance,pathgrid,timeleft,_condition,cond_value) VALUES ('52096','grobb','-50.8','132.4','4.7','117,4','320','0','0','0','0','1');

INSERT INTO spawngroup VALUES (52096,'spawn23891',0);

INSERT INTO spawnentry VALUES (52096,50311,100);

Theeper

12-06-2007 04:28 PM

Here are the grids for the 9 spiders.

Code:

-- spider grid 1

INSERT INTO grid (id, zoneid, type, type2) VALUES ('1','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','1','-362.3','674.5','-8.4','64.4','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','2','-329.9','674.2','-8.4','71.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','3','-248.5','647.2','-28.4','111.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','4','-219.7','556.3','-24.4','99.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','5','-171.6','495.9','-9.0','102.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','6','-150.5','466.3','-8.4','82.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','7','-95.7','439.0','-5.4','116.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','8','-79.0','380.4','4.6','112.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','9','-54.8','296.9','0.7','117.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','10','-67.9','136.5','0.7','93.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','11','7.8','72.7','0.7','92.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('1','52','12','-1.5','-92.8','0.7','131.0','0');

-- spider grid 2

INSERT INTO grid (id, zoneid, type, type2) VALUES ('2','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','1','-643.2','606.5','11.6','251.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','2','-642.2','629.1','11.6','0.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','3','-638.8','654.5','1.6','30.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','4','-597.7','676.4','1.6','64.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','5','-539.1','675.7','-8.4','64.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','6','-331.5','668.0','-8.4','66.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','7','-261.5','654.4','-28.1','95.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','8','-218.5','560.0','-24.4','166.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','9','-249.8','530.0','-14.4','157.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','10','-271.2','502.5','-8.4','155.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','11','-309.0','477.7','1.2','171.0','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','12','-349.0','454.7','3.0','148.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','13','-385.6','388.7','1.6','194.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','14','-474.9','422.1','1.6','2.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','15','-474.6','453.8','-8.4','13.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','16','-445.2','531.8','-8.4','239.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('2','52','17','-477.4','611.5','-8.3','240.8','0');

-- spider grid 3

INSERT INTO grid (id, zoneid, type, type2) VALUES ('3','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','1','-159.3','447.1','-8.4','234.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','2','-184.3','480.5','-8.4','197.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','3','-289.7','488.4','-8.4','194.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','4','-309.3','476.4','1.4','17.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','5','-348.4','459.0','2.7','140.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','6','-383.8','388.7','1.6','166.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','7','-460.0','330.1','1.6','126.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','8','-459.9','288.5','10.8','191.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('3','52','9','-485.6','291.0','11.6','191.6','0');

-- spider grid 4

INSERT INTO grid (id, zoneid, type, type2) VALUES ('4','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','1','-284.2','209.8','1.6','26.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','2','-221.0','266.9','3.6','61.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','3','-180.8','269.7','14.0','59.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','4','-144.3','273.2','8.5','55.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','5','-65.9','300.5','1.6','125.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','6','-60.2','171.4','1.6','128.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','7','-70.0','134.5','1.6','79.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('4','52','8','-44.3','125.5','1.6','100.9','0');

Theeper

12-06-2007 04:29 PM

Code:

-- spider grid 5

INSERT INTO grid (id, zoneid, type, type2) VALUES ('5','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('5','52','1','-94.7','317.5','1.6','199.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('5','52','2','-65.9','300.5','1.6','125.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('5','52','3','-60.2','171.4','1.6','128.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('5','52','4','-70.0','134.5','1.6','79.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('5','52','5','-44.3','125.5','1.6','100.9','0');

-- Spider grid 6

INSERT INTO grid (id, zoneid, type, type2) VALUES ('6','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','1','-329.9','674.2','-8.4','71.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','2','-248.5','647.2','-28.4','111.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','3','-219.7','556.3','-24.4','99.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','4','-171.6','495.9','-9.0','102.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','5','-150.5','466.3','-8.4','82.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','6','-95.7','439.0','-5.4','116.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','7','-79.0','380.4','4.6','112.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('6','52','8','-54.8','296.9','0.7','117.9','0');

-- Spider grid 7

INSERT INTO grid (id, zoneid, type, type2) VALUES ('7','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','1','-560.9','418.3','11.1','1.4','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','2','-553.4','387.5','11.0','245.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','3','-519.4','386.0','10.7','199.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','4','-498.7','381.3','1.0','201.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','5','-474.9','422.1','1.6','2.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','6','-474.6','453.8','-8.4','13.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','7','-445.2','531.8','-8.4','239.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('7','52','8','-477.4','611.5','-8.3','240.8','0');

-- Spider grid 8

INSERT INTO grid (id, zoneid, type, type2) VALUES ('8','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','1','-289.7','488.4','-8.4','194.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','2','-309.3','476.4','1.4','17.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','3','-348.4','459.0','2.7','140.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','4','-383.8','388.7','1.6','166.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','5','-460.0','330.1','1.6','126.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('8','52','6','-459.9','288.5','10.8','191.8','0');

-- Spider grid 9

INSERT INTO grid (id, zoneid, type, type2) VALUES ('9','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','1','-171.6','495.9','-9.0','102.6','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','2','-150.5','466.3','-8.4','82.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','3','-95.7','439.0','-5.4','116.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','4','-79.0','380.4','4.6','112.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','5','-54.8','296.9','0.7','117.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('9','52','6','-67.9','136.5','0.7','93.4','0');

Theeper

12-06-2007 04:30 PM

Here is the grid for the one mosquito that seems to move.

Code:

-- grid for a domesticated bleeder

INSERT INTO grid (id, zoneid, type, type2) VALUES ('10','52','0','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','1','-34.2','318.3','4.7','161.8','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','2','-104.5','282.9','5.2','157.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','3','-129.9','264.9','8.0','128.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','4','-130.0','245.1','8.0','19.9','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','5','-140.6','269.8','9.1','191.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','6','-150.7','269.6','14.7','192.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','7','-181.1','269.7','17.0','192.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','8','-210.0','268.7','12.7','169.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','9','-222.2','260.9','6.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','10','-264.4','233.4','4.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','11','-283.9','211.7','4.7','30.3','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','12','-264.4','233.4','4.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','13','-222.2','260.9','6.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','14','-210.0','268.7','12.7','169.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','15','-181.1','269.7','17.0','192.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','16','-150.7','269.6','14.7','192.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','17','-140.6','269.8','9.1','191.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','18','-128.1','298.1','4.7','49.6','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('10','52','19','-111.6','283.8','6.0','50.9','0');

Theeper

12-06-2007 04:33 PM

Here is a couple basher grids. The one guy has 34 waypoints. I am not sure if that's too much or not. It seems to work fine for me though. There's still a couple bashers that aren't in the zone yet.

Code:

-- grid for Basher Avisk

UPDATE spawn2 SET pathgrid = 11 WHERE spawngroupID = 52002;

INSERT INTO grid (id, zoneid, type, type2) VALUES ('11','52','0','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','1','-50.0','262.0','3.1','124.0','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','2','-41.9','280.8','4.7','63.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','3','39.0','280.2','2.7','64.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','4','66.4','250.8','0.2','96.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','5','78.0','238.2','-5.2','90.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','6','98.7','235.7','-5.3','185.8','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','7','78.0','238.2','-5.2','90.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','8','66.4','250.8','0.2','96.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','9','39.0','280.2','2.7','64.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','10','-41.9','280.8','4.7','63.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','11','-80.7','290.3','4.7','183.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','12','-140.6','269.8','9.1','191.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','13','-150.7','269.6','14.7','192.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','14','-181.1','269.7','17.0','192.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','15','-210.0','268.7','12.7','169.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','16','-222.2','260.9','6.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','17','-264.4','233.4','4.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','18','-283.9','211.7','4.7','30.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','19','-305.4','180.6','8.7','26.3','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','20','-264.4','233.4','4.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','21','-222.2','260.9','6.7','168.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','22','-210.0','268.7','12.7','169.5','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','23','-181.1','269.7','17.0','192.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','24','-150.7','269.6','14.7','192.8','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','25','-140.6','269.8','9.1','191.1','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','26','-58.9','301.0','4.7','242.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','27','-77.6','377.0','4.7','246.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','28','-80.4','401.0','0.6','245.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','29','-97.8','446.5','-3.4','197.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','30','-167.5','468.9','-5.3','210.5','20');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','31','-97.8','446.5','-3.4','197.6','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','32','-80.4','401.0','0.6','245.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','33','-77.6','377.0','4.7','246.9','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('11','52','34','-58.9','301.0','4.7','242.9','0');



-- grid for Basher Sutok

UPDATE spawn2 SET pathgrid = 12 WHERE spawngroupID = 52017;

INSERT INTO grid (id, zoneid, type, type2) VALUES ('12','52','3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','1','-73.6','145.8','4.8','255.3','45');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','2','-49.2','217.2','4.8','232.0','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','3','-65.8','233.1','4.8','253.1','90');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','4','-49.2','217.2','4.8','232.0','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','5','-73.6','145.8','4.8','255.3','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','6','13.1','69.3','4.8','127.4','0');

INSERT INTO grid_entries (gridid, zoneid, number, x, y, z, heading, pause) VALUES ('12','52','7','9.2','38.1','4.8','132,4','90');

All times are GMT -4. The time now is 07:37 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page