item db

[ksmith]

Originally Posted by Edgar1898

How would that allow you to determine whether a class can use a weapon if more than 1 class can use it at a time?

If that wasn't directed at my example, ignore this.

mysql> SELECT id,classes,name FROM items WHERE classes & 128 LIMIT 10;
+-------+---------+----------------------------+
| id    | classes | name                       |
+-------+---------+----------------------------+
| 35008 |     128 | Intricate Wooden Figurine  |
| 10154 |     128 | Unicorn Horn               |
| 10176 |     128 | Lute of the Gypsy Princess |
| 10219 |   15488 | Rokyls Channelling Crystal |
| 10653 |   16861 | Black Basalt Band          |
|  1094 |   16777 | Dirk of the Traitor        |
| 10945 |   16861 | Ring of Algae              |
| 10946 |   16861 | Ring of Nobility           |
| 11015 |     128 | Tear Shaped Ring           |
| 11103 |     151 | Bracers of Earthen Energy  |
+-------+---------+----------------------------+