Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-20-2008, 06:21 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

well this is rather wide area quetsion, but if you do nto want to use George tools, then you need to use somthign liek this:

SELECT id,name, damage, delay FROM peq.items where name like '%rusty%' and itemtype=0;

this will show you all rusty 1 hand slashing weapons

Item type list:


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
Reply With Quote
 

Thread Tools
Display Modes

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:18 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