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, 04:03 AM
angelow
Fire Beetle
 
Join Date: Dec 2005
Posts: 15
Default only one problem so far

When I attempt to type in text it will not take it.... opening the file for editing tells me i have an incompatible version of excel. I have Microsoft Excel Viewer 2003. I am sure its something stupid that I am doing.... if you could just let me know what that was.

Was wondering if the version of excell i downloaded is a viewer and wont let me edit? or is it the year that is wrong? Thanks in advance.
Reply With Quote
  #2  
Old 01-06-2006, 06:53 AM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

That "Excel is required" thing is kinda a deal breaker for me. I don't have Excel on my computer at all. In fact, I don't any microsoft office programs on my computer!

I use OpenOffice.Org for all my document and spreadsheet needs.

I realize that doing so at this point would most likely require a major overhaul of your code, but you should look into using an embedded MySQL database engine or something like SQLite instead of Excel to store your data.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #3  
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
  #4  
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
  #5  
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
  #6  
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
  #7  
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
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 11:32 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