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 05-23-2007, 04:16 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default How does client tell betwen 1h and 2h weapons?

God i hope this is right forum for such questions, since nothing realy fits the category directly.

anyway, how does client/server EXACTLY knows what type of weapon you using?

First i thought this was assigned skill based.
For exmaple:

2handed sword uses 2HS skill. even if you assing Secondary slot to the item you still need both hands free to hold it.
So this is simple.

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 =)
Reply With Quote
  #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
  #3  
Old 05-23-2007, 06:53 PM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

Thank you for answering

I think I got it

The 2handed spears use ItemType 35
I just haven't seen it before, cuase there is no such skill as 2 handed piercing and I guess its hardcoded that 1hp and 2hp both use the same skill

I was hoping I could get rid of 2hs and 2hb the same way, and split weapon skills difirently, like all Swords, all Axes etc.
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 08:54 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3