Global class Item Adjustments?

[Maceblade]

I dont know if this is even possible, but I want to reduce the delay of knight ONLY useable weapons and berserker knight only useable weapons.

I know its rather limiting and possibly not even doable, but I dont want to reduce the delay of weapons that any other class can use...

For instance, I dont want a 1hs's delay reduced that a warrior and pally can both use, or a 2 hs that a zerker pally sk and war can use... Is this possible?

UPDATE items SET delay = delay * .5 WHERE class = paladin and class = shadowknight

Im pretty sure that would do exactly what I dont want to happen... Is there a way to do what im asking without having to change them one by one?

[Maze_EQ]

pretty sure you'd break something.

http://www.eqemulator.net/wiki/wikka.php?wakka=ClassList

Classes are not calculated by names, but by numeric values. Read the link and fix your query to what you need.

Hint: Paladin + SK = 22....


but this is a task, because you're going to have to isolate all other classes.

[Maceblade]

lol yea youre probably right... ill just do them 1 by 1 everytime I add something. Thanks Maze

[Maze_EQ]

actually sk+pal=20.


try and do a select * from items where classes = 22


if you want zerker/pal/shd i guess use 32788

[Klor_Warbringer]

Something like this?
UPDATE `items` SET `delay` = `delay` * .5 WHERE `classes` = 20;

[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.php?wakka=ItemIDReference

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