|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc. |

11-28-2007, 04:35 AM
|
Hill Giant
|
|
Join Date: Oct 2006
Posts: 248
|
|
Quote:
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
|

11-28-2007, 11:01 AM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
LOL Sfisque.
It is nice to know the work is being used though.
|

11-29-2007, 05:06 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
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 
|
 |
|
 |

12-06-2007, 04:23 PM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
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);
|
 |
|
 |
 |
|
 |

12-06-2007, 04:28 PM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
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');
|
 |
|
 |
 |
|
 |

12-06-2007, 04:29 PM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
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');
|
 |
|
 |
 |
|
 |

12-06-2007, 04:30 PM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
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');
|
 |
|
 |
Thread Tools |
|
Display Modes |
Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 05:10 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |