Weapon damage

This forum is for problems that arise with the Database Schema as it is developed, or questions you have regarding how to utilize the database.

Moderator: Team Members

Forum rules
Make sure your questions are detailed, intelligent, and relating to the default EQ2Emulator Database Schema.

Questions about how to build your own custom server content will not be addressed here.
Post Reply
bolly
Retired
Posts: 389
Joined: Mon Sep 21, 2009 3:03 pm
Location: Leeds, UK

Weapon damage

Post by bolly » Thu Sep 24, 2009 10:46 pm

Hey all,

got the item editor on the way and am just wondering about some weapons, i'm mostly sorted apart from the damage report reporting as crushing damage so I just wanted to check i got this right:

* Step 1: Create the item in the items table
INSERT INTO items (name,item_type,icon,skill_id_req,slots) VALUES ('A dagger','Weapon',47,418532101,1);
Find a skill_id_req by SELECT id,name FROM skills WHERE name LIKE '%Slashing%';

* Step 2: Assign an appearance in the appearance table
INSERT INTO item_appearances (item_id,equip_type) VALUES (7,7415);
Find an appearance (equip_type) by SELECT appearance_id, name FROM appearances WHERE name LIKE '%dagger%'

* Step 3: Assign weapon information in the weapons table
INSERT INTO item_details_weapon (item_id, wield_style,damage_type,damage_low1, damage_high1,delay, damage_rating) VALUES (7,2,0,10,30,30,1);

Damage Types
SLASH 0
CRUSH 1
PIERCE 2
HEAT 3
COLD 4
MAGIC 5
MENTAL 6
DIVINE 7
DISEASE 8
POISON 9
DROWN 10
FALLING 11
PAIN 12

Wield Styles:
Dual 1
Single 2
Two Handed 3

* Reload your items
/reload items

All is good apart from it's showing the kill as crushing, what am i missing?

Cheers!

Bolly

bolly
Retired
Posts: 389
Joined: Mon Sep 21, 2009 3:03 pm
Location: Leeds, UK

Re: Weapon damage

Post by bolly » Fri Sep 25, 2009 8:20 am

I updated from svn this morning and logged in game to find this was ok so thumbs up - i'll pop the details on the wiki

bolly
Retired
Posts: 389
Joined: Mon Sep 21, 2009 3:03 pm
Location: Leeds, UK

Re: Weapon damage

Post by bolly » Fri Sep 25, 2009 8:36 pm

aww christ it's doing it again, musta missed something, will take it out of the wiki temporarily as to not seed wrong info

Stage 3 on interface feedback so it makes sense, will keep a close eye on:

http://www.eq2emulator.net/phpBB3/viewt ... ?f=6&t=942

from now on :-)

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests