Item SQL Search
 

I wanted to see if anyone can help me in building an sql statement for searching items such as weapons, armor, bags, so on. All i really need to know is what the where clause would be like select * from items where ???? i can not find any column in the items table that determines what these items are.

I think GeorgeS has an item Editor on his site, might help explain what they do or are.

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

The list
 

So this list will return the item type stated beside them such as 0 = and so on.

well =0 means you gona see all the 1hslashers
if you put =10 you gona see all the armor
etc

Perfect
 

That information was great, I have been able to build a working SQL model from it and have also been able to write most of the code for my application using it. now my next step is to get some information on the spells files i tried using the wiki however the slots just did not line up when i took two spells side by side in excel and compared them to the information from the wiki.