| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | 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 09:11 PM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |