| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | Development::GeorgeS's Tools A forum just for GeorgeS's tools | 
    
    
   
   
   
   
   
   
   
   
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-08-2009, 03:34 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Oct 2005 
					Location: michigain 
					
					
						Posts: 260
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-10-2009, 10:39 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		As mentioned in another post, 
 
Fixed the program to handle the latest schema 
 
Everquest Item Editor and Character Inventory Editor 
- 14.4.0 - Added support for items table SVN schema 292 i.e change all columns from `augslotxunk` to `augslotxvisible` 
 
 
Finally, it's done, but please let me know if there are other issues. 
 
Another source of crashes occur when a null is in a field when one cannot exist, and that will make the program crash. There is no fix for this. Make sure your tables are ok - especially if you update often. I rarely update the items table, except for the schema. 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-12-2009, 02:43 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2008 
					Location: aaaaaaaaaaa 
					
					
						Posts: 8
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		heh georges i also found out that when say i take 1 item and i decide to copy it 3 times to edit it the first and third copy work but the second when i go to edit pops up with an error saying you cannot edit an item that doesnt yet exist lol but i figured it was just something wrong with my item so i went into navicat to check it and everything was fine so tried again and same error but if i rename the item in navicat everything works it wasnt really a problem but just figured you might of wanted to know about it    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-12-2009, 03:24 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		George, with the latest updates to DB schema your Spawn Editor no longer works - it requres that you remove the timeleft field from it. 
Also, still trying hard to get your attention here:
 http://www.eqemulator.net/forums/showthread.php?t=26667
thanks =)  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2009, 02:29 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		The spawn editor standalone is depreciated several months ago. It 
is now incorporated into the NPC loot editor. 
 
The item editor appears to work with the current schema ver 292. 
I did find a bug in the copy routine, and it should be fixed now. 
 
Please DL ver. 14.4.1 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2009, 02:56 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		ah george but unless I am missing soemthign there are 2 major issue with "build" in spawn editor: 
 
 I have to keep running npc editor just to use the spawn editor  
 
and what is most important 
 
I can only pull up spawn editor info on the mob I have selected - which is totaly no good - I can no longer search and browse entire ZONES or lists of spawns with it. WHich effecticly kills the spawn editor for me as a tool of any purpose. I cannot delete spawns entries with it anymore, I cannot add spawn data into entries which curently do nto exist and so on. 
 
In other words the build-in spawn editor is nearly totaly useless for prety much anything. 
 
Old editor has 100 times more power than the build in version. Could you please consider bringing the standalone up to date? The build-in just doesn't cut it :( 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2009, 04:14 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		The tool is now integrated and has been for a long time. However, I did recode the module to be more stand alone. 
 
NPC and Loot Editor 
 
08.21.17 - SpawnEditor is re-coded for a more stand-alone mode 
 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2009, 09:41 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		ah George - this is MUCH better now - I can once again  browse all zones and all spawn groups. ( I will play around with it to ake sure that we not missing any of the usefull fetaures old editor had) 
thanks!    
BTW, I beive that old editor colors were somewhat better for the eyes (blueish background and black text)  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-17-2009, 07:51 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Oct 2008 
					Location: AZ 
					
					
						Posts: 58
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Thank You!!!
			 
			 
			
		
		
		
		GeorgeS, 
 
Thank you for updating your NPC editor tool, I can once again use the spawn and grid editor. I was having extreme difficulty have mobs path in a zone with zero grids. Your tools are a huge help. Thanks again!!! 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-17-2009, 06:50 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		George, found a SIGNIFICANT error in the Spawn Editor 
 
First of all Spaw Editor should be updated to include editing of Roamboxes. 
 
Roamboxes data are part of spawngroup table, the old spawngroup table looked like this: 
 
id, name 
 
the current spawngroup table looks like this: 
 
id, name, spawn_limit, dist, max_x, min_x, max_y, min_y, delay 
 
these new collumsn are the data needed for the Roamboxes. 
 
the significnat error in the editor rigth now that whenever you SAVE a spawngroup it sets all these fields to 0! (destroying all my Roambox data in the process) 
 
So: 
1) the setting to 0 needs to corected 
and 
2) the spawneditor could use this expansion and have this fields added to the editor for editing in the window where you have spawngroups list 
 
thanks! 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-17-2009, 06:55 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  ChaosSlayer
					 
				 
				George, found a SIGNIFICANT error in the Spawn Editor 
 
First of all Spaw Editor should be updated to include editing of Roamboxes. 
			
		 | 
	 
	 
 Sorry to go off-topic, but did you get roamboxes to work?  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-17-2009, 06:58 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  cavedude
					 
				 
				Sorry to go off-topic, but did you get roamboxes to work? 
			
		 | 
	 
	 
 well apparenty it was the George editor that kept killing the data I been enterign last night =) 
I am trying this right now and will report back in about 10 min if Roamboxes actualy working.  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-17-2009, 07:10 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2007 
					
					
					
						Posts: 1,032
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		YAY! I happy to report that mobs are now rampaging across the land in random order and wreacking havoc at will! 
Now if Geroge fixes this unfortunate error in the editor - we going to be all set    
PS> God I am so glad I won't have to do grid pathing for West Karana by hand!!!    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2009, 01:19 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		No problemo, I will get on this friday and should have this resolved by evening. 
 
I should be able to add the feature in. 
 
I'll have this as my top priority 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2009, 11:46 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Modified it so it won't overwrite your data. I'll start work on the roambox features - that will take a bit longer. 
 
NPC and Loot Editor 
 
08.21.17 - SpawnEditor is modifed so it does not overwrite "existing" roamboxe data. This is the first of two parts. The second part will support creation of roamboxes 
 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	
		
	
		 
		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 02:12 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |