View Full Version : newbie quest bout db's
EmuGM
06-15-2002, 09:50 AM
Why do the db items start at 1001? And i noticed that the numbers are not incremented, why not? I'm figuring that mysql requires that the item table starts at 1001. And wouldnt it be a bit easier to add new items to the db if they went in order?
Lurker_005
06-15-2002, 10:36 AM
The numbers start at 1001 and are limited to somewhere around 35000 by the eq client. It just won't accept anything outside that range.
Also the numbers you see in sql, are also encoded in the item data, that is why just copying an item and changing it's sql id number gives a bad item in the game. Use an item editor.
The items released with the emu are items collected in game, and use the same item numbers verant uses. Gaps in the numbers are either gaps verant left, or just items that havn't been collected yet.
Baron Sprite
06-15-2002, 12:28 PM
I believe it has to do with the system EQ uses to read numbers in HEX format. That's just my random guess though ;)
EmuGM
06-18-2002, 04:42 PM
Thanks for the info Luker and the insite Baron. It's cleared up some questions and gave me a few ideas. I been lookin through the mysql format and yeah, admin tool is much easier, if only it were more complete...
Baron Sprite
06-18-2002, 04:56 PM
be glad for admin tool, windcatcher r0x0r my b0x0r, use kaiyodo editor with it for total control ^_^
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.