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.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-23-2007, 05:57 PM
vales
Discordant
 
Join Date: May 2006
Posts: 458
Default

Quote:
Originally Posted by ChaosSlayer
HOWEVER, when it come to Piercing... there is no such thing as 2HP!
And as we know those spears and daggers come both as 1h and 2h, and they both have same skill assigned to them... so how does it work so client/server KNOWS that this specific spear is 2handed?
thanks =)
Possibly by itemtype. Itemtype 2 = piercing. You can use this list to make your own items.

Here's a list.
Code:
0 = 1HS
1 = 2HS
2 = piercing
3 = 1HB
4 = 2HB
5 = Archery
6 = Unused
7 = Throwing
8 = Unused
9 = Unused
10 = Defence (Armor)
11 = Involves Tradeskills (Not sure how)
12 = Lock Picking
13 = Unused
14 = Food (Right Click to use)
15 = Drink (Right Click to use)
16 = Unused
17 = Common Inventory Item
18 = Bind Wound
19 = Thrown Casting Items (Explosive potions etc)
20 = Spells / Song Sheets
21 = Potions
22 = Unused
23 = Wind Instruments
24 = Stringed Instruments
25 = Brass Instruments
26 = Drum Instruments
27 = Ammo (In most cases, Arrows)
28 = Unused
29 = Jewlery Items (As far as I can tell)
30 = Unused
31 = Unused
32 = Ussally Readable Books and Scrolls
33 = Keys
34 = Odd Items (Not sure what they are for)
35 = 2H Pierce
36 = Fishing Poles
37 = Fishing Bait
38 = Alcoholic Beverages
39 = More Keys
40 = Compasses
41 = Unused
42 = Poisens
43 = Unused
44 = Unused
45 = H2H (Hand to Hand)
46 = Unused
47 = Unused
48 = Unused
49 = Unused
50 = Unused
51 = Unused
52 = Charms
53 = Dyes
54 = Augments
55 = Augment Solvents
56 = Augment Distillers
And also, I'm almost 100% positive it's matching up the itemtype from the database with the client. That's why when we used to source in the 13th Floor database, we'd usually have to wait for them to fix the SQL file on some items before we could use it. Client says okay, but server says no - basically.

I don't remember which file it was, so I can't say. I recall there was a discussion about it a long time ago.

I find all of my info on the wikki, btw.
Reply With Quote
 


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