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

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2002, 11:19 PM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default 5 digit item texture database editor :o)

Who wants to be the first to release one?
Reply With Quote
  #2  
Old 06-10-2002, 12:39 AM
Kaiyodo
Hill Giant
 
Join Date: Jan 2002
Location: Midlands,UK
Posts: 149
Default

Not me, unless someone can work out how you can fit 5 digits into 4 spaces

There's space for 6 characters the item structure, but the first two are taken up by the letters 'IT' on all items as far as I know.

If anyone's got more info though, speak up!

K.
Reply With Quote
  #3  
Old 06-10-2002, 12:47 AM
bot403
Sarnak
 
Join Date: May 2002
Posts: 52
Default

why not patch the servercode to work with an expanded column and ask for it as a featurerequest in the next release?
__________________
-------------------------
ServerOP- Botworld
-------------------------
Reply With Quote
  #4  
Old 06-10-2002, 05:05 AM
Kaiyodo
Hill Giant
 
Join Date: Jan 2002
Location: Midlands,UK
Posts: 149
Default

Unfortunately the item_struct is stored in the DB as a BLOB, and changing the size of it by adding a couple of extra bytes to accomodate a few more characters would mean all of the items had to be recreated.

In addition to that, the binary data format would then be different from the one EQ uses, and that'd break a whole lotta stuff.

K.
Reply With Quote
  #5  
Old 06-10-2002, 08:52 AM
bot403
Sarnak
 
Join Date: May 2002
Posts: 52
Default

oh, lol, suuure, make it sound obvious that i missed that. THanks :p
__________________
-------------------------
ServerOP- Botworld
-------------------------
Reply With Quote
  #6  
Old 06-10-2002, 10:08 AM
Baron Sprite's Avatar
Baron Sprite
Dragon
 
Join Date: Jan 2002
Posts: 708
Default

Auto-Add IT I say..... :p
__________________
Waking up in the morgue is pretty harsh, but it beats being dead.
Begun, this irc stat war has.
Reply With Quote
  #7  
Old 06-10-2002, 11:48 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

erm... Isn't the data that begins with IT for item TYPE The texture is stored elsewhere. But I think it is still just 2 bytes of data.

Ahh... You mean the visual model. NM
__________________
Please read the forum rules and look at reacent messages before posting.
Reply With Quote
  #8  
Old 06-10-2002, 02:48 PM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default

Hmmm..
Reply With Quote
  #9  
Old 06-12-2002, 12:56 PM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default

Bleh
Reply With Quote
  #10  
Old 06-12-2002, 07:29 PM
Baron Sprite's Avatar
Baron Sprite
Dragon
 
Join Date: Jan 2002
Posts: 708
Default

offer women money power and fame.
__________________
Waking up in the morgue is pretty harsh, but it beats being dead.
Begun, this irc stat war has.
Reply With Quote
  #11  
Old 06-13-2002, 10:23 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

I noticed that the HQ item DB uses those codes. The version I looked at seemed to use the new packet structure, and it had that data as 30 bytes not 6. It also did not have the "flag" section Is that flag sections use known, or is it just junk that we though was for something?
__________________
Please read the forum rules and look at reacent messages before posting.
Reply With Quote
  #12  
Old 06-14-2002, 12:59 PM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default

Har, Har..
Reply With Quote
  #13  
Old 06-15-2002, 12:54 AM
Kaiyodo
Hill Giant
 
Join Date: Jan 2002
Location: Midlands,UK
Posts: 149
Default

I'm going out on a limb here and assuming Lurker's right about the idfile field being 30 chars long

Just updated my editor to handle up to 30 characters for the visuals .. http://www.geocities.com/kaiyodouk/

I've fixed a couple of major bugs in it too. One would cause the changing of values to affect other values (a bug caused 4 bytes to be written for every number size), another would cause a failed upload to the database if you'd selected the item from the search page rather than the item list. Oh, and the password field is now ***'d out

I'm not sure if someone's already done this, but I can easily get hold of a list of all of the possible IT values (they're not all numbers, e.g. IT1K15GLOVE). I've been messing about with .wld files for a model viewer I'm writing and found all of the weapon model entries. I'm not going to attempt to describe what they all look like, but I can generate a list of all the possible ones if that would be of any use.

K.
Reply With Quote
  #14  
Old 06-15-2002, 01:07 AM
Ariak
Dragon
 
Join Date: Mar 2002
Posts: 633
Default

Good Job.
Reply With Quote
  #15  
Old 06-15-2002, 11:00 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

Kaiyodo, Yea that is the way that HQ was listing the ID portion, and they had the 10000+ series ID's in their item DB. Ariak have you made some items and tried them in game yet?
__________________
Please read the forum rules and look at reacent messages before posting.
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 06:02 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