Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2006, 11:02 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default 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.
Reply With Quote
  #2  
Old 01-07-2006, 06:13 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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
Reply With Quote
  #3  
Old 01-07-2006, 09:43 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default 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
Reply With Quote
  #4  
Old 01-07-2006, 11:24 AM
Krugus
Sarnak
 
Join Date: Dec 2005
Location: the Void
Posts: 40
Wink 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
Reply With Quote
  #5  
Old 01-11-2006, 03:51 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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
Reply With Quote
  #6  
Old 01-11-2006, 08:46 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default

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.
Reply With Quote
  #7  
Old 01-11-2006, 09:11 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

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..
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:53 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3