View Single Post
  #6  
Old 04-09-2013, 12:20 AM
Mariomario
Hill Giant
 
Join Date: Jul 2004
Posts: 143
Default

Maze is correct. The 'classes' attribute uses numeric values, not names.

You can even go as far as limiting to item type in case you wanted to reduce 1H items less than say 2H.

http://www.eqemulator.net/wiki/wikka...temIDReference

Code:
UPDATE items SET delay = delay * .80 WHERE (classes = 4 || classes = 16 || classes = 20) AND (itemtype = 0 || itemtype = 2);
This would reduce the delay of both 1H Slash and 1H Blunt weapons that are only useable by only Paladins, only Shadowknights and both Paladins and Shadowknights. You can modify this using the numeric values from both the wiki page Maze linked and the itemtypes page found above.

I hope this is helpful and you achieve what you're looking for.
__________________
Wrath - Lead Admin and Owner of Enlightened Dark: Ascension

Enlightened Dark: Ascension
Reply With Quote