| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | Development::GeorgeS's Tools A forum just for GeorgeS's tools | 
    
    
   
   
   
   
   
   
   
   
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-04-2006, 07:30 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Updated Tool - EqItems Item Editor
			 
			 
			
		
		
		
		Finished this mamoth work today, and it runs stably. 
What is this program? 
 EQITEMS does several things - 
 
        -Search for items in the database by search criteria 
        -Edit any item by a variety of parameters 
        -Create new items by modifying pre-existing items as templates 
        -Load any character on your server to view and edit equipped (worn only) items.
 
Well try it out, let me know if it crashes and what the circumstances were.
 
download link -  http://wizardportal.dyndns.org/eqemu...ml/eqitems.zip
old help file link -  http://wizardportal.dyndns.org/eqemu...p/Eqitems.html
links to main site
 http://wizardportal.dyndns.org/eqemu/eq.html
GeorgeS  
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
		
						  
				
				Last edited by GeorgeS; 09-21-2008 at 08:14 PM..
				
				
			
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-05-2006, 01:41 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Some databases do not include DBversion info in field varname in Table variables. Download new version - that should fix any errors during start-up. 
 
Everquest Item Editor and Character Inventory Editor 9.506 , Latest 9/5/06 
-Fixed startup error due to some databases missing DBversion in field varname  
 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-17-2006, 02:23 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jun 2005 
					
					
					
						Posts: 286
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Link isn't working to download, server down maybe? 
		
	
		
		
		
		
		
		
			
				__________________ 
				-Croup (the rogue) 
Creator of Pandemic (PvP-Racewars)
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-17-2006, 04:04 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Yes, windows rebooted the machine after an update. 
Thanks for letting me know 
 
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-17-2006, 07:22 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jun 2005 
					
					
					
						Posts: 286
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Thank you sir. Much appreciate that you made this tool. 
		
	
		
		
		
		
		
		
			
				__________________ 
				-Croup (the rogue) 
Creator of Pandemic (PvP-Racewars)
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-17-2006, 07:54 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jun 2005 
					
					
					
						Posts: 286
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Hrmm, I can't get it workin for the life of me. I run register_ocx. I edit the db.ini setting to: 
host=192.168.1.101 
user=moydock 
password=********* 
database=eq 
everquest_folder=null 
 
and i get that same message every time i try to launch, "MYSQL connection FAILED! Did you edit db.ini?", any idea? I also tried launching it on the server using localhost as the host. 
		
	
		
		
		
		
		
		
			
				__________________ 
				-Croup (the rogue) 
Creator of Pandemic (PvP-Racewars)
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				04-18-2008, 11:25 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2008 
					
					
					
						Posts: 67
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		not sure if this is possible, but is there a way to put in the option to pull up a merchants inventory in the item editor, so that we can maniulate their inventory prices and stats without having to look up each item..if this is possible, it would be a good addition i think...thanks 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				04-22-2008, 07:08 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Not sure I understand - you mean editing 'price'? along with merchants inventory in a table like editing format? 
Only price can be edited because it's a heck of a programing effort to make it so merchants are loaded. 
  
I'm working on adding more features to all the tools, so everyone will benefit with greater results. 
  
Some features are prioritized, others have to wait. 
  
GeorgeS 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				04-22-2008, 02:50 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2008 
					
					
					
						Posts: 67
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		I meant the same way you can load characters and see their inventory and you can manipulate the items on the actual character...if there was a way to load merchants to do the same thing..but I do see that you said that would be very involved to do...just was a thought, I didnt know the difficulty in such a task..sorry 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				04-22-2008, 05:52 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Aug 2006 
					Location: USA 
					
					
						Posts: 5,946
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		He has a tool for merchants already.  They list all items that the merchants have for sale.  Though, I do think it would be nice if there was a way to actually look at the item stats directly in that tool.  Or if you could even just adjust the price from there, that would be pretty cool as well.  I don't sell much special stuff on my server, but I know that some custom servers have tons of loot that is purchasable.  I am sure they would like to have access to change price directly in the merchant tool if it was possible. 
 
To me, the stuff with merchants is pretty well ironed out already.  I don't use them much anyway, but I am sure some servers do. 
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				04-22-2008, 11:32 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Feb 2008 
					
					
					
						Posts: 67
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		yes, i use the merchant tool all the time to add stuff to my custom merchants and it is an awesome tool...I never even thought about adding price and stat manipulation to that tool...that would be awesome too. Dont get me wrong George, I would be lost without your tools, I was just trying to make a little suggestion. Thanks! 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				08-20-2009, 06:50 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Mar 2009 
					Location: Ottawa 
					
					
						Posts: 495
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		My PEQ db didn't come with spells (unless I missed an sql file). I had to take the one from my SoF install and import it using the perl import_spells script. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				08-20-2009, 07:36 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	Quote: 
	
	
		
			
				
					Originally Posted by  pfyon
					 
				 
				My PEQ db didn't come with spells (unless I missed an sql file). I had to take the one from my SoF install and import it using the perl import_spells script. 
			
		 | 
	 
	 
 spells_new is included in the .gz file on SVN...  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-15-2009, 10:46 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jul 2003 
					
					
					
						Posts: 68
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Odd request but here goes   
I usually work remotely with EQItems and the background of your wonderful tool is a real graphic it seems. Means it is transfered over the slow internet connection.
 
Do you think it is possible to release a version without a background graphic, just a usual 'windows' looking app?  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				09-15-2009, 10:56 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jul 2003 
					
					
					
						Posts: 68
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		To clear it up: I use this tool over RDC (no admin rights on this PC but RDC is open, hence this odd request) 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	
		
	
		 
		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 01:00 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |