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
  #16  
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
  #17  
Old 01-07-2006, 06:13 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
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
  #18  
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
  #19  
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
  #20  
Old 01-11-2006, 03:51 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
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
  #21  
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
  #22  
Old 01-11-2006, 09:11 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
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
  #23  
Old 01-11-2006, 09:25 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default

Thanks looking forward to it =)
Reply With Quote
  #24  
Old 01-11-2006, 06:36 PM
jimbabwe
Hill Giant
 
Join Date: Aug 2005
Posts: 107
Default 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
Reply With Quote
  #25  
Old 01-12-2006, 11:47 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default

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.
Reply With Quote
  #26  
Old 01-12-2006, 02:41 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

Yes, I uploaded the update already. Same link

Let me know if the spacebar selection works...


GeorgeS
Reply With Quote
  #27  
Old 01-13-2006, 10:45 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Unhappy 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.

=(
Reply With Quote
  #28  
Old 01-14-2006, 05:59 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

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
Reply With Quote
  #29  
Old 04-18-2006, 05:13 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default 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
Reply With Quote
  #30  
Old 04-19-2006, 03:09 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default .

Quote:
Originally Posted by GeorgeS
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.
__________________
hosting Eqemu/Runuo/wow Emulators.

www.cheaterz.info
Reply With Quote
Reply


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 02:32 AM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3