Quote:
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.
Code:
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 |
+-------+---------+----------------------------+