Set all items to be gnome usable?

[gnode]

How would I go about setting all items to be gnome usable? That way I can turn any class into a gnome and they would work.

The race field in the items table seems a bit odd to me (and class for that matter). I was expecting to see a column per race y/n, but I guess thats not how it works here...


Or even better maybe, just race all if that is easier.

[gnode]

Well, I answered my 2nd question. Just set all races to 65535.

Is there no trick to make everything gnome usable though? I would rather do that if possible...

[steve]

You mean add Gnome to every item's existing race list? No.

You could set everything Gnome only or ALL like you suggested above.

[pfyon]

Looks like the race entry uses individual bits in a 16 bit number to set which races can use it. If you could find an item that is gnome only already, then I think I can give you a query to allow add gnome to every item.

[AndMetal]

It's a bitmask.

Here's an excerpt from the Wiki:

races

* What race or races can use the item. Rememeber to add up the results.
o 0 = None
o 1 = Human
o 2 = Barbarian
o 4 = Erudite
o 8 = ELF
o 16 = HIE
o 32 = Dark Elf
o 64 = HEF
o 128 = Dwarf
o 256 = Troll
o 512 = Ogre
o 1024 = HFL
o 2048 = Gnome
o 4096 = Iksar
o 8192 = Vah Shir
o 16384 = Froglok
o 32768 = Shroud
* These are combined values, but with special meaning:
o 32767 = Any/All
o 65535 = Usually a container

So, using the bitwise operator AND (&), running this query will make all items usable by Gnomes:

UPDATE items SET races = races & 2048

[ChaosSlayerZ]

where is the drakkin btw?

[GeorgeS]

BTW the bitwise operations are a godsend for cases like this.


GeorgeS

[trevius]

Originally Posted by ChaosSlayerZ

where is the drakkin btw?

From races.h

#define human_1			1
#define barbarian_1		2
#define erudite_1		4
#define woodelf_1		8
#define highelf_1		16
#define darkelf_1		32
#define halfelf_1		64
#define dwarf_1			128
#define troll_1			256
#define ogre_1			512
#define halfling_1		1024
#define gnome_1			2048
#define iksar_1			4096
#define vahshir_1		8192
#define rall_1			16384 //froglok?
#define drakkin_1		32768

Drakkin is now 32768, and I am not sure what shroud would be, but guessing 65535ish.

[gnode]

WARNING:
UPDATE items SET races = races & 2048

Makes all items gnome only (or in many cases bugs them to not have a race listed). It does not add gnome to all items.

What I am trying to do is add gnome to all items.

Maybe George can make an feature for eqitems to add a race to all items?

[realityincarnate]

To add to the race list instead of replace it, you want to use a bitwise OR, not AND.

UPDATE items SET races = races | 2048

[GeorgeS]

Originally Posted by gnode

WARNING:
UPDATE items SET races = races & 2048

Makes all items gnome only (or in many cases bugs them to not have a race listed). It does not add gnome to all items.

What I am trying to do is add gnome to all items.

Maybe George can make an feature for eqitems to add a race to all items?

Actually I am thinking of adding this, perhaps to a new tool that does mass alterations of this sort...

GeorgeS