| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database.  Post partial/complete databases for spawns, items, etc. | 
    
    
   
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-06-2006, 11:02 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Argh
			 
			 
			
		
		
		
		Ok, so i have the whole program up and running, which btw is fantastic.  I can not however properly do step 2 of the tutorial.  I do not ever get the loottable-id opened.  I can only see the top bag.... cant create more bags.... im sure its a simple thing.  If some one could just tell me what I have to do to get that small window to the left of the bag viewer (so that I can choose what bag im viewing) i would be set. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-07-2006, 06:13 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		The 2 windows you want (to display the details) are activated by double-clicking. Select a row in one of the two windows and double click to open show the pop-ups. 
 
...new lootdropid's are created by clicking on the button 'add new lootable id' 
and this new # will appear in the sheet in cells between merchant_id and  regen_rate cells. Click on the loottable id and the contents should appear in the two windows.  
 
GeorgeS 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-07-2006, 09:43 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Hmm
			 
			 
			
		
		
		
		Ok, I can see the right of the two tables, always could.  I can double click that and get the pop up menu, always could.  Nothing i do will bring up the left table however.  The one that allows me to select what "bag" I am looking in for the monster.  I have tried double clicking, entering, or just spazzing on the loot table id # (i realize that is the number that tells it what "bags" to include) but I can not ever get that smaller blue window to open.  It is just a yellow background. 
 
I am using excel 2003 on windows XP 
 
Thanks 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-07-2006, 11:24 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Sarnak 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					Location: the Void 
					
					
						Posts: 40
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Very nice.
			 
			 
			
		
		
		
		Nice tool Mr G.   
Very helpful indeed!  Thanks   
Feature Request:
 
If possible, the ability to take out spawns by selecting one and have it moved out into a new spawntable.
 
Just an Idea    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-11-2006, 03:51 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		If you single click on any 'bag' or lootdropid row - do you get the contents to show up in the right window?  
 
If you cannot get that left window to pop up a menu, then I think the issue must be with the winXP Excel versions compatibility. 
 
Anyway, what I will do today is find a fix for this issue so it works on your PC. 
This should be a relatively easy fix 
 
Mr.G 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-11-2006, 08:46 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Thanks a ton, I love your program, just cant get that left window to appear.... so it is most likely the compatability issue. 
 
 
Looking forward to the fix. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-11-2006, 09:11 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		edit - Uploaded the newest version. 
Ok, I fixed it so you can bring the pop-up by clicking once on any 'bag'/ lootdrop row and then pressing the spacebar - that brings up the pop-up menu. I will upload this later today after work ~ 6pm PST
 
Fixed some other minor misc errors as well...
 
..not sure if you know, but I also have a selective eq-database backup/restore tool (.exe) and a utility (.exe) 
that allows you to search the ITEMS table and identify items by class and type, etc...
 
It will also identify which NPC drops the item/s
 
get it here
 http://66.159.225.58/uwe/eqitems.zip
I am compiling a help for this utility.
 
Later 
Mr.G  
		
	
		
		
		
		
		
		
		
		
		
		
						  
				
				Last edited by GeorgeS; 01-11-2006 at 10:20 PM..
				
				
			
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-11-2006, 09:25 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Thanks looking forward to it  =) 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-11-2006, 06:36 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Hill Giant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Aug 2005 
					
					
					
						Posts: 107
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				but
			 
			 
			
		
		
		
		The program is workign wonderfully, I think i've found a small bug though.  I start it up, and just hit search and let it search for hill.  Then if i go down the list and click on each of the entries that show up once, the loot_table window gets smaller and smaller every time.  Otherwise excellent work, I love it a bunch. 
 
edit: oh yeah, i'm running excel 2k3 version 11.6 
		
	
		
		
		
		
		
		
		
		
		
		
						  
				
				Last edited by jimbabwe; 01-12-2006 at 02:41 AM..
				Reason: additional info
				
			
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-12-2006, 11:47 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Did you get a chance to fix that problem I was having george?  AKA if i redownload your program will it have the spacebar fix? or are you going to link a fix when you have time.  Thanks in advance. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-12-2006, 02:41 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Yes, I uploaded the update already. Same link 
 
Let me know if the spacebar selection works... 
 
 
GeorgeS 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-13-2006, 10:45 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2005 
					
					
					
						Posts: 15
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Man, this program hates on me  =)
			 
			 
			
		
		
		
		Ok, I am having the same problem an earlier poster had now that I have redownloaded the program.  When I click on the left window for items it continues to get smaller and smalelr untill it is a just a 1 dimensional line that I can not ineteract with.....  So yes you fixed the one problem, but now it goes so small I can not interact with it after about 10 uses. 
 
=( 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				01-14-2006, 05:59 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Forum Guide 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2003 
					Location: California 
					
					
						Posts: 1,474
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Newest version should have the shrinking window issue solved. Let me know 
if it still does this. I changed the window properties to resemble the right panel and the shrink appears to be gone. I never had the shrinking window on my version of XL (Win2K) but the window did flicker in an odd way. 
 
You can now download this latest release... 
 
 
 
Mr.G 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
	
		
	
	
	
		
		
		
			
			 
			
				04-19-2006, 03:09 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Dragon 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2003 
					Location: Earth 
					
					
						Posts: 818
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				.
			 
			 
			
		
		
		
		
	Quote: 
	
	
		| 
			
				 
					Originally Posted by GeorgeS
					
				 
				
			
		 | 
	 
	 
 Great work, 
It's very easy to use and setup. 
I use 0.7.0 but im sure it won't take much to fix it up.  
		
	
		
		
		
		
		
		
			
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	| Thread Tools | 
	
 
	| 
	
	
	
	 | 
	
 
	| Display Modes | 
	
 
	
	
	
	
		  Linear 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 02:01 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |