| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | EQEmu Operations Center Web development tools | 
    
    
   
   
   
   
   
   
   
   
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				10-01-2013, 05:55 AM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				EoC: NPC Editor (BETA)
			 
			 
			
		
		
		
		This is something that I had wanted to get to because editing NPC's in a zone on mass scale is probably one of the most time consuming tasks there could be. 
I spent a few hours putting this tool together and it is Georges-style inspired.
 
All I use for editing is Mysql CLI and the EoC, I encourage anyone to use it because it is super fast and convenient. Let me know if anyone has feedback or questions.
 Features:- Extremely Responsive and fast for updates
 
- Search by Zone and Version
 
- Search additionally by NPC name
 
- Mass edit a column based on NPC selection
 
- Mass edit a column with a random value specified from minimum and maximum values
 
- Instant saving
 
- It's super
 
 
  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				10-16-2013, 10:19 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		looking good! 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-06-2014, 02:44 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Aug 2005 
					
					
					
						Posts: 34
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		This is looking pretty good however I was wondering if at all these are possible: 
Sort ascending/descending by column 
Search based on other quantifiers than name (mainly race and level)
 
I feel like these would give the mass edit a lot more power
 
Less important:  
resizing width capability 
setting fields to hidden
 
Just some heuristics   
Thanks  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
 
    | 
   | 
    | 
  
 
	
		
		
		
			
			 
			
				02-10-2015, 05:13 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				
			 
			 
			
		
		
		
		OK, it's been quite a while since I've updated this thread apparently. 
I've made it one of my forefront tasks to get a fully-fledged NPC Editor suite in EoC. Pushed an update this morning, here's some screens. The only thing not working atm is the loot stuff at the top, plan to finish fleshing out those tonight if I don't fall asleep from staying up too late.
 
You can expect to see this get mature real fast though.
 
Implemented: - Table sorting
 
- Mass field edit and propogation
 
- NPC Deleting
 
- NPC Full Page Editing
 
 
Changes live here:  http://eoc.akkadius.com/EOC2/index.php?M=NPC2
You can expect to see:
 - Quick View Information and Loot at top
 
- Copy NPC
 
- Spell List Editor
 
- Merchant Editor
 
- Special Attacks Editor
 
- Grid Editor
 
- Field Based Filtering (Search)
 
- When double clicking a cell in the grid view, it will create a temporary input for intelligent inputs such as if you were to click a race field, it would create a race dropdown of choices, or special attacks field would pop up an intelligent selector
 
- More to come
 
 
 
  
		
	
		
		
		
		
		
		
		
		
		
	
		
			
			
			
			
				 
			
			
			
			
			
			
				
			
			
			
		 
		
	
	
	 | 
 
 
 
    | 
   | 
    | 
  
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-10-2015, 06:04 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Dragon 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Aug 2012 
					Location: Hershey, PA 
					
					
						Posts: 499
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Simply Rocking. (now that I've found the scheme) 
		
	
		
		
		
		
		
		
		
		
		
		
						  
				
				Last edited by ghanja; 02-10-2015 at 06:07 PM..
				Reason: No longer relevant (never was actually)
				
			
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-10-2015, 06:05 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  ghanja
					 
				 
				Akka, are there themes/styles to EoC, or can they be implemented if not?  Perhaps I'm the minority, though, there's just too much white-space for my eyes.  Those screenshots from 2013 with the grey background is easier to look at.  Functionality wise, you've got this downright rocking, thank you. 
			
		 | 
	 
	 
 Top right has a Dark Theme option. I use it when I'm developing and I have red eyes.  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-11-2015, 09:29 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2009 
					Location: Mentor 
					
					
						Posts: 58
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Thanks so much for your work on this, Akka! 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-12-2015, 09:01 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Hill Giant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2013 
					
					
					
						Posts: 247
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		hell yes, this kicks ass 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2015, 08:53 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Oct 2013 
					
					
					
						Posts: 3
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Thank You for this awesome set of tools. I'd like to make a recommendation. If at all possible can we get the d_melee_textures 1 and 2 field added to the npc full page edit? A visual weapon selection like on your item editor would be great, but even just a basic input box would help. It's kind of a pain to have to close out the window to edit an npc's weapons. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2015, 01:04 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  ratmanAK
					 
				 
				Thank You for this awesome set of tools. I'd like to make a recommendation. If at all possible can we get the d_melee_textures 1 and 2 field added to the npc full page edit? A visual weapon selection like on your item editor would be great, but even just a basic input box would help. It's kind of a pain to have to close out the window to edit an npc's weapons. 
			
		 | 
	 
	 
 
Yes, I have some updates to push here soon that are quite nice to this editor. Stay tuned.
 
I had visual in the full page editor until someone decided to change the field names  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2015, 04:58 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		These are not released, but should be able to push them today. 
Special Attacks/Abilities Editor:
 
Smart grid editor:- When you hover over a cell normally, it will create a simple input field. But when you double click a field, if there is an intelligent editor or select dropdown available, it will create it in the cell for easier understanding what what values mean for ease of editing
 
 
  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2015, 07:55 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		The above changes are now live on EOC. 
Enjoy    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-20-2015, 08:07 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		The NPC table data now automatically sizes itself to the browser resolution that you have. This is also updated. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-25-2015, 07:00 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Hill Giant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2013 
					
					
					
						Posts: 247
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Have used it multiple times over the past week.  The mass field editor is very nice, and it cuts down a lot of time. Changed 4 custom zones in about 10 minutes, compared to spending time crawling the DB. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-25-2015, 07:19 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Administrator 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2009 
					Location: MN 
					
					
						Posts: 2,072
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  epilz
					 
				 
				Have used it multiple times over the past week.  The mass field editor is very nice, and it cuts down a lot of time. Changed 4 custom zones in about 10 minutes, compared to spending time crawling the DB. 
			
		 | 
	 
	 
 That's awesome to hear  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	
		
	
		 
		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 03:59 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |