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.

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

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

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 :)

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

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.

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

Thanks looking forward to it =)

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

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.

Yes, I uploaded the update already. Same link

Let me know if the spacebar selection works...


GeorgeS

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.

=(

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

Link update
 

FYI - the links to download are

Help is here
http://66.159.225.58/eqemu/excel_eq/excel.html

Utility is here
http://66.159.225.58/eqemu/excel_eq/eq_database.zip

A very good guidebook

http://66.159.225.58/eqemu/EQEmu_Guidebook13.zip

I am working on getting this properly working with 0.6.6, but most
things do work.
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.