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

11-28-2007, 01:46 AM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
Merged into PEQ thank you!
|

11-28-2007, 02:28 AM
|
Discordant
|
|
Join Date: May 2004
Posts: 290
|
|
Cave, you don't have to say 'Thank you' each time.
Thank you for letting me use the PEQ DB. 
|

11-28-2007, 03:43 AM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
I think the input from Cavedude is nice, this way I know he sees the fixes.
|

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);
|
 |
|
 |
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 06:33 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |