Global class Item Adjustments?

[Mariomario]

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

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.

[Maceblade]

Wow thanks Wrath thats awesome!

[Mariomario]

You're welcome. Remember while testing always use SELECT * FROM before using UPDATE to ensure you are targeting the accurate items, spells, npcs etc etc you actually want modified. Believe me when I say it saves from unneeded headaches.

[Maze_EQ]

Look at that, I knew it was going to be able to be done, the only problem is, you have to figure out which combinations go where, some knight items also include warriors, zerkers, possibly even rangers. It's just a matter of figuring it out, but if you're doing custom work, where the items are just strictly knights, this would work perfectly