MartenBroadcloak
Displaced Tuluki
It's not a shit post if you spell check (tm)
Posts: 370
|
Post by MartenBroadcloak on Oct 31, 2018 8:34:53 GMT -5
With statz and buffs and all that. If has anything like this PM plz.
ps I'm totally Nyr and everyone knows it. Do it or I'll ban you and the next six generations of your offspring will subsequently be banned.
|
|
|
|
Post by sessizlik on Nov 7, 2018 1:15:02 GMT -5
With statz and buffs and all that. If has anything like this PM plz. ps I'm totally Nyr and everyone knows it. Do it or I'll ban you and the next six generations of your offspring will subsequently be banned. a steel double-axe: wooden haft (from thick branches of baobab) + ingot of iron (from ore of iron x 3) |
|
|
|
Post by blooddread on Nov 15, 2018 17:30:19 GMT -5
Same. I realize I'm a lurker, but I'd be interested in something similar.
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 16, 2018 11:22:59 GMT -5
This is some very old (2000'ish). Haven't played with this in awhile so let me know if it is useful then I can look at weapons/armor. Otherwise, back to doing my own thing - I don't play arm anymore.
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, o_type, val0, val1, val2, cost from objects where o_type = 28;
+----------+----------------------------------------+--------+------+------+------+------+
| obj_vnum | sdesc | o_type | val0 | val1 | val2 | cost |
+----------+----------------------------------------+--------+------+------+------+------+
| 10 | an immortal bow | 28 | 3 | 1 | 0 | 0 |
| 96 | a dark-stained yypr longbow | 28 | 2 | 12 | 0 | 85 |*
| 97 | a dark-stained yypr shortbow | 28 | 1 | 9 | 0 | 60 |
| 2205 | an elvish longbow | 28 | 2 | 10 | 0 | 87 |
| 4715 | a carved horn bow | 28 | 2 | 14 | 0 | 120 |
| 6099 | a duskhorn and yypr recurve bow | 28 | 2 | 10 | 0 | 75 |
| 6666 | a thuja-wood recurve bow | 28 | 2 | 12 | 0 | 140 |
| 14311 | a small heavy bone crossbow | 28 | 1 | 19 | 1 | 68 |
| 14400 | a long sinewy sling | 28 | 3 | 1 | 1 | 8 |* 13 coins
| 14756 | a black, red-etched longbow | 28 | 2 | 14 | 0 | 1500 |
| 14831 | a maroon, baobab longbow | 28 | 3 | 13 | 0 | 102 |
| 16103 | a wooden longbow | 28 | 2 | 10 | 0 | 0 |
| 19252 | a wooden recurve bow | 28 | 3 | 23 | 0 | 400 |* 1430 coins
| 20028 | an elvish longbow | 28 | 2 | 10 | 0 | 400 |
| 20112 | an ash longbow | 28 | 2 | 12 | 0 | 150 |
| 21257 | a serpent-carved elvish longbow | 28 | 1 | 8 | 0 | 1000 |
| 21304 | a very fine elven longbow | 28 | 2 | 12 | 0 | 300 |
| 21305 | an elven maar shortbow | 28 | 1 | 7 | 0 | 170 |
| 21316 | an agafari elvish longbow | 28 | 2 | 11 | 0 | 600 |* 1180 coins
| 21318 | an elvish maar shortbow | 28 | 1 | 8 | 0 | 240 |
| 21320 | a finely-made elvish longbow | 28 | 2 | 10 | 0 | 700 |
| 22913 | a bone shortbow | 28 | 2 | 10 | 0 | 70 |
| 23600 | a wooden selfbow | 28 | 3 | 15 | 0 | 30 |
| 24022 | a maroon baobab longbow | 28 | 2 | 13 | 0 | 102 |* 449 coins
| 24045 | a maroon baobab shortbow | 28 | 1 | 9 | 0 | 50 |
| 25110 | a spike-tipped agafari shortbow | 28 | 1 | 10 | 0 | 98 |
| 25114 | a bone-handled baobab shortbow | 28 | 1 | 9 | 0 | 105 |
| 39006 | an agafari shortbow | 28 | 1 | 9 | 0 | 21 |
| 39033 | a slender wooden blowgun | 28 | 2 | 6 | 1 | 80 |
| 44027 | a plain agafari longbow | 28 | 2 | 13 | 0 | 80 |
| 45480 | a pale wooden bow | 28 | 2 | 12 | 0 | 86 |
| 46802 | a 120mm cannon | 28 | 3 | 24 | 0 | 0 |
| 50387 | a slender, dark-stained wooden blowgun | 28 | 3 | 10 | 1 | 80 |
| 56222 | a thornwood bow | 28 | 2 | 15 | 0 | 300 |
| 64095 | a heavy wooden crossbow | 28 | 2 | 14 | 1 | 88 |
| 64103 | a maar shortbow | 28 | 1 | 9 | 0 | 69 |
| 64104 | a duskhorn bow | 28 | 2 | 15 | 0 | 131 |
| 64105 | a light agafari crossbow | 28 | 2 | 11 | 1 | 75 |
| 64106 | a heavy baobab crossbow | 28 | 2 | 13 | 1 | 135 |
| 64107 | a maar hand-crossbow | 28 | 1 | 8 | 1 | 256 |
| 64517 | a duskhorn recurve bow | 28 | 2 | 12 | 0 | 201 |
| 70205 | a yypr shortbow | 28 | 1 | 9 | 0 | 50 |* 113
+----------+----------------------------------------+--------+------+------+------+------+
42 rows in set (0.01 sec)
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, o_type, val0, val1, val2, dam_num_dice, dam_dice_size, dam_plus from objects where o_type = 5 AND sdesc like '% arrow%';
+----------+-------------------------------------+--------+------+------+------+--------------+---------------+----------+
| obj_vnum | sdesc | o_type | val0 | val1 | val2 | dam_num_dice | dam_dice_size | dam_plus |
+----------+-------------------------------------+--------+------+------+------+--------------+---------------+----------+
| 11 | an immortal arrow | 5 | 0 | 5 | 5 | 0 | 0 | 0 |
| 98 | a grey-fletched arrow | 5 | 0 | 1 | 5 | 0 | 1 | 0 |
| 6397 | a glass-headed sheaf arrow | 5 | 0 | 1 | 7 | 0 | 1 | 0 |
| 16101 | a white-fletched arrow | 5 | 0 | 1 | 1 | 0 | 0 | 0 |
| 16102 | a white-fletched arrow | 5 | 0 | 1 | 1 | 0 | 0 | 0 |
| 20029 | a flint-tipped arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 21317 | a flint-tipped arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 21343 | a black and red fletched arrow | 5 | 0 | 1 | 7 | 0 | 0 | 0 |
| 22005 | a black arrow | 5 | -3 | 1 | 6 | 0 | 0 | 0 |
| 23601 | a flint-tipped arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 24041 | a slender baobab arrow | 5 | 0 | 1 | 5 | 0 | 0 | 0 |
| 25111 | a black-fletched bone-tipped arrow | 5 | -1 | 1 | 5 | 0 | 0 | 0 |
| 39007 | a bone-tipped arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 44028 | a short agafari arrow | 5 | 0 | 1 | 5 | 0 | 1 | 0 |
| 45481 | a barbed arrow | 5 | 0 | 1 | 8 | 0 | 0 | 0 |
| 45482 | a flint headed arrow | 5 | -2 | 1 | 6 | 0 | 0 | 0 |
| 50932 | a stone-tipped bone arrow | 5 | -1 | 1 | 3 | 0 | 1 | 0 |
| 56223 | a long thornwood arrow | 5 | 0 | 1 | 4 | 0 | 0 | 0 |
| 64110 | a slender wooden flight arrow | 5 | 0 | 1 | 5 | 0 | 0 | 0 |
| 64111 | an obsidian-headed sheaf arrow | 5 | 0 | 1 | 8 | 0 | 0 | 0 |
| 64112 | a slender glass-tipped flight arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 65502 | a small, yellow-feathered arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 65503 | a black-fletched arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 70207 | a black-fletched arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
| 70299 | a barbed, black arrow | 5 | 0 | 1 | 6 | 0 | 0 | 0 |
+----------+-------------------------------------+--------+------+------+------+--------------+---------------+----------+
25 rows in set (0.01 sec)
The o_type = 28 are bows. The ones with the * beside them were in game last time I played (grepped some old play logs). I know some of those are not 3 room bows so these have been changed over the years. So what good is this old data? Look at the 2016 code dump (mostly in other.c - cmd_shoot and ocreate.c): val0 is the range - this one is obvious, number of rooms. val1 is the strength (code comment says 1-25 but can only be 1-24 due to <25). Used for who can use the bow and damage bonus: /* I changed this to give reasonably strength'd people the ability to
* shoot most bows -Hal */
if (!bow->obj_flags.value[2]
&& bow->obj_flags.value[1] > (GET_STR(ch) + 3)) {
send_to_char("You are not strong enough to use this bow.\n\r", ch);
return;
} val2 is a flag bow/crossbow type (loads the arrows/bolts differently) Of these the strength is the only number used for damage calculation: /* strength bonus, limited str */
if (GET_STR(ch) > bow->obj_flags.value[1] + 1)
dam += str_app[bow->obj_flags.value[1]].todam; In constants.c, you can see what a bow might be adding to the damage (first column): {0, 117, 4}, /* 12 */
{0, 120, 6},
{0, 125, 9},
{1, 140, 12}, /* 15 */
{1, 155, 18},
{2, 170, 24},
{3, 195, 32}, /* 18 */
{4, 230, 40},
{5, 290, 48},
{6, 380, 56}, /* 21 */The arrow also determines the damage but it is random: /* calculate damage */
if (arrow->obj_flags.type == ITEM_WEAPON) {
dam =
dice(arrow->obj_flags.value[1],
arrow->obj_flags.value[2]) + arrow->obj_flags.value[0];
} else { /* not a weapon -Morg 3/12/03 */
dam = dice(1, 2);
} But it doesn't use the regular weapon damage fields. dice(number, size) uses val1, val2 From the old object files they are maxxed at 5 to 8 damage. The val0 is only used as a penalty(?) this doesn't make sense to me. Data might be bad or the code was changed at some point. Either way, this is a random number so you might hit for 1 or hit for the max damage. Another addition to damage is your skill. It is fixed damage + a random crit hit chance that doubles damage: /* skill bonus */
if (ch->skills[SKILL_ARCHERY]) {
dam += ch->skills[SKILL_ARCHERY]->learned / 7;
if (number(0, 500) <= ch->skills[SKILL_ARCHERY]->learned)
dam *= 2;
} At 50 dam would be 50/7 = 7 so more than the strength bonus for most bows and about the max damage for an arrow. At 80 dam would be 80/7 = 11 which is the single biggest contributor to damage.
Takeaway - max strength bow + high skill is more important than the arrow.
|
|
MartenBroadcloak
Displaced Tuluki
It's not a shit post if you spell check (tm)
Posts: 370
|
Post by MartenBroadcloak on Nov 16, 2018 11:35:51 GMT -5
this is interesting. Lololo 120mm cannon what?
Yeah tho if you have melee weapons and armor that'd be super cool to look at.
fist bump
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 16, 2018 12:50:58 GMT -5
The old arm areas have some imm only playboxes with weird stuff. Examples:
MariaDB [ARMAG_TEST]> select name, sdesc, o_type from objects where name like '%dildo%';
+------------------------------------+-----------------------------------------------+--------+
| name | sdesc | o_type |
+------------------------------------+-----------------------------------------------+--------+
| mask dark red dildo | a dark red mask | 31 |
| dildo smurf blue little | a little blue smurf dildo | 5 |
| sodomizer staff sword dildo-tipped | a dildo-tipped staff entitled 'The Sodomizer' | 5 |
| dildo miniature furry | a miniature, furry dildo | 12 |
+------------------------------------+-----------------------------------------------+--------+
I'll have a look at the weapons. |
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 16, 2018 14:00:17 GMT -5
Quick and dirty - the weapons I have. I am missing the affects attached to weapons. Did not load those into the db (I'll play with that later).
Weapons o_type 5
val3 is weapon type (adds 300 when loaded)
val1 is number of dice
val2 is size of dice
val0 is +/- to roll
combat.c : function hit
dam = dice(wp_pri->obj_flags.value[1], wp_pri->obj_flags.value[2])
+ wp_pri->obj_flags.value[0];
constants.c has the weapon types
no pike, trident, polearm, razor or knife in the data I have so that must have been created later.
BLUDGEON
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 1;
+----------+------------------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+------------------------------------------+-------------+------+------+------+------+
| 177 | a carved, hardwood quarterstaff | 1024 | 0 | 1 | 6 | 1 |
| 200 | A large steel mace | 0 | 2 | 3 | 2 | 1 |
| 1110 | a worn wooden staff | 73728 | -1 | 1 | 6 | 1 |
| 1126 | a bone mace | 0 | -1 | 1 | 8 | 1 |
| 1129 | a heavy wooden maul | 8192 | 1 | 1 | 8 | 1 |
| 1141 | a stone-headed warhammer | 0 | 0 | 3 | 3 | 1 |
| 1150 | a huge stone-headed hammer | 8192 | 1 | 1 | 10 | 1 |
| 1165 | a bone-spiked mace | 0 | 0 | 2 | 4 | 1 |
| 2034 | a feces-stained stone shovel | 0 | 0 | 1 | 4 | 1 |
| 2112 | a polished, darkwood cane | 0 | -1 | 1 | 4 | 1 |
| 2202 | a thick, twisted staff | 73728 | -1 | 1 | 6 | 1 |
| 2411 | a weighted quarterstaff | 73728 | 0 | 2 | 4 | 1 |
| 2454 | a huge stone hammer | 8192 | 0 | 1 | 10 | 1 |
| 2456 | a gnarled wooden staff | 0 | 0 | 1 | 6 | 1 |
| 2463 | a heavy stone staff | 256 | 0 | 1 | 8 | 1 |
| 2565 | an iron-shod staff | 0 | 1 | 1 | 6 | 1 |
| 2566 | a dragon-tipped staff | 0 | 0 | 1 | 5 | 1 |
| 2800 | a twisted, blackwood staff | 0 | 2 | 1 | 4 | 1 |
| 3059 | a padded agafari crutch | 0 | -1 | 1 | 5 | 1 |
| 4115 | a stone sledgehammer | 8192 | 0 | 2 | 4 | 1 |
| 6021 | a large wooden spoon | 0 | 0 | 1 | 3 | 1 |
| 6034 | a smooth bone club | 0 | 0 | 1 | 6 | 1 |
| 6053 | a light wooden sparring club | 0 | 0 | 1 | 3 | 1 |
| 6174 | a one-handed fighting stick | 0 | -1 | 1 | 8 | 1 |
| 6175 | a long wooden fighting stick | 8192 | -1 | 2 | 6 | 1 |
| 6327 | an immense, dark wooden club | 8192 | -1 | 2 | 6 | 1 |
| 6366 | a worn, stuffed gwoshi | 3072 | 0 | 1 | 1 | 1 |
| 6388 | a buka-ja sparring stick | 0 | 0 | 1 | 3 | 1 |
| 6389 | a buka-jal sparring staff | 8192 | 0 | 1 | 4 | 1 |
| 6677 | a branched wooden fighting-stick | 0 | -1 | 1 | 8 | 1 |
| 6731 | a small tamping hammer | 0 | 0 | 1 | 4 | 1 |
| 10106 | a iron hammer | 0 | 0 | 1 | 10 | 1 |
| 13161 | a gnarled staff | 0 | 0 | 1 | 6 | 1 |
| 13501 | a broom | 0 | 0 | 1 | 2 | 1 |
| 14101 | a blackened metal mace | 0 | 1 | 2 | 4 | 1 |
| 14401 | a small round stone | 2098176 | 0 | 1 | 4 | 1 |
| 14701 | a slender, wooden rod | 0 | -1 | 1 | 5 | 1 |
| 14702 | a leather, spike-covered cestus | 0 | -1 | 2 | 3 | 1 |
| 14704 | a studded, short-handled mace | 0 | -1 | 1 | 8 | 1 |
| 14741 | a rune-carved, stone hammer | 0 | 0 | 2 | 4 | 1 |
| 14759 | a viscious-looking, wooden club | 0 | -1 | 2 | 4 | 1 |
| 14768 | a black cane with an azure opal | 0 | -1 | 1 | 4 | 1 |
| 14787 | a blackened, obsidian-spiked mace | 0 | -1 | 2 | 4 | 1 |
| 14803 | a silver-encrusted, wooden staff | 0 | -1 | 1 | 6 | 1 |
| 14863 | an oddly-shaped rock | 1024 | 0 | 1 | 1 | 1 |
| 14897 | a blue rock | 0 | 1 | 1 | 5 | 1 |
| 14999 | the Immortal's paddle | 0 | 20 | 50 | 50 | 1 |
| 19034 | a smooth walking stick | 0 | -1 | 1 | 4 | 1 |
| 20024 | a stone-edged wooden club | 0 | 0 | 1 | 7 | 1 |
| 20037 | a heavy wooden hammer | 0 | 1 | 1 | 6 | 1 |
| 20042 | a long-handled steel warhammer | 0 | 0 | 1 | 6 | 1 |
| 20046 | a worn agafari staff | 73728 | 0 | 1 | 6 | 1 |
| 20057 | a staff of office | 16 | 0 | 1 | 4 | 1 |
| 20084 | a long-handled stone hammer | 0 | 0 | 3 | 3 | 1 |
| 20111 | A chipped bone club | 0 | -1 | 1 | 6 | 1 |
| 20934 | a stone-headed wooden lotilus | 8192 | 0 | 2 | 3 | 1 |
| 20935 | a bone-pommeled agafari cane | 0 | -1 | 1 | 3 | 1 |
| 20942 | a studded wooden cudgel | 0 | -1 | 1 | 6 | 1 |
| 21018 | a worn wooden staff | 8192 | -1 | 1 | 6 | 1 |
| 21021 | a carved wooden warclub | 0 | -1 | 1 | 8 | 1 |
| 21260 | a tall, carved staff | 8192 | -1 | 1 | 6 | 1 |
| 22020 | a large femur | 0 | -1 | 2 | 6 | 1 |
| 22021 | a two-pronged stick | 4196352 | 1 | 1 | 3 | 1 |
| 22025 | a wooden bola | 3072 | 0 | 1 | 8 | 1 |
| 22916 | a wooden practice sword | 0 | 0 | 1 | 1 | 1 |
| 24042 | a thick baobab club | 0 | -1 | 2 | 4 | 1 |
| 25102 | a brittle, blackened femur | 0 | -2 | 1 | 4 | 1 |
| 25107 | a serrated bone club | 0 | -1 | 1 | 6 | 1 |
| 25116 | a grass-stringed stone flail | 8192 | -1 | 1 | 7 | 1 |
| 28303 | a bone challenge marker | 1024 | 0 | 1 | 1 | 1 |
| 29722 | a stout wooden staff | 0 | 0 | 2 | 2 | 1 |
| 34004 | a stone mining pick | 8192 | 0 | 1 | 5 | 1 |
| 34005 | a stone stalagmite | 8192 | 0 | 2 | 5 | 1 |
| 35050 | a heavy wooden Cluebat | 0 | 0 | 1 | 1 | 1 |
| 37002 | a large wooden cudgel | 8192 | 2 | 3 | 4 | 1 |
| 37657 | a bleached bone quarterstaff | 8192 | 1 | 2 | 3 | 1 |
| 37658 | a spiked bone club | 0 | 1 | 3 | 3 | 1 |
| 37660 | a bone mace | 0 | 1 | 2 | 2 | 1 |
| 39040 | a small round stone | 1024 | 0 | 1 | 3 | 1 |
| 45006 | a tassled throw-pillow | 134144 | -1 | 1 | 1 | 1 |
| 45105 | a short, tassled staff | 0 | 1 | 2 | 2 | 1 |
| 45202 | a light composite staff | 0 | -1 | 1 | 6 | 1 |
| 45489 | a long two-handed staff | 73728 | 0 | 2 | 6 | 1 |
| 45490 | a short wooden staff | 0 | 1 | 1 | 6 | 1 |
| 45553 | an ornately carved staff | 0 | 0 | 1 | 6 | 1 |
| 49024 | a slim black staff | 256 | 0 | 3 | 2 | 1 |
| 50094 | a massive, spiked club | 0 | 0 | 2 | 6 | 1 |
| 50096 | a long-handled steel hammer | 0 | 1 | 2 | 4 | 1 |
| 50118 | a weighted sap | 0 | 0 | 1 | 6 | 1 |
| 50925 | a stone-headed bone lotilus | 8192 | -1 | 2 | 3 | 1 |
| 54300 | a thin hardwood club | 0 | 0 | 1 | 8 | 1 |
| 56214 | a long stone staff | 0 | 2 | 3 | 6 | 1 |
| 56402 | a carved baobab walking staff | 0 | 0 | 1 | 4 | 1 |
| 56503 | a short, heavy jawbone | 0 | 0 | 1 | 3 | 1 |
| 56517 | a short, heavy legbone | 0 | 0 | 2 | 3 | 1 |
| 58005 | a long, obsidian-tipped staff | 8192 | -1 | 1 | 6 | 1 |
| 58051 | a one-handed, obsidian-studded bone mace | 0 | -1 | 1 | 8 | 1 |
| 58073 | an aluminum fnord-bat of Justice | 0 | 5 | 10 | 23 | 1 |
| 58163 | a long handled, stone warhammer | 0 | 0 | 3 | 3 | 1 |
| 58366 | a carved agafari cane | 0 | 0 | 2 | 3 | 1 |
| 63002 | a light obsidian quarterstaff | 0 | 0 | 1 | 6 | 1 |
| 63007 | a massive spiked cudgel | 0 | 0 | 2 | 6 | 1 |
| 63008 | a double Salik | 0 | 0 | 2 | 3 | 1 |
| 63016 | a smith's hammer | 0 | 1 | 1 | 6 | 1 |
| 63033 | a long ashwood staff | 0 | 1 | 2 | 3 | 1 |
| 63044 | a dark staff of Ka'arax | 1 | 1 | 3 | 3 | 1 |
| 63053 | a crude iron flail | 0 | 1 | 2 | 4 | 1 |
| 64004 | a spiked wooden club | 0 | -1 | 1 | 6 | 1 |
| 64009 | a ridged bone club | 0 | -1 | 2 | 4 | 1 |
| 64014 | a hardwood short-staff | 1024 | 0 | 1 | 6 | 1 |
| 64049 | a huge bone club | 8192 | -1 | 2 | 6 | 1 |
| 64543 | a heavy earthenware mug | 0 | -2 | 1 | 4 | 1 |
| 65523 | a wooden flute | 0 | 0 | 1 | 4 | 1 |
| 65941 | a small rock | 3072 | 2 | 1 | 4 | 1 |
| 66101 | a crude wooden club | 0 | -1 | 1 | 8 | 1 |
| 66102 | a stone club | 73728 | 1 | 1 | 12 | 1 |
| 70192 | a feathered, stone-headed warclub | 0 | 0 | 3 | 3 | 1 |
| 70219 | a gigantic wooden club | 8192 | 0 | 2 | 7 | 1 |
+----------+------------------------------------------+-------------+------+------+------+------+
118 rows in set (0.01 sec)
PIERCE
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 2;
+----------+-----------------------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+-----------------------------------------------+-------------+------+------+------+------+
| 11 | an immortal arrow | 512 | 0 | 5 | 5 | 2 |
| 98 | a grey-fletched arrow | 512 | 0 | 1 | 5 | 2 |
| 1101 | a wooden shortsword | 0 | -2 | 1 | 6 | 2 |
| 1102 | an obsidian shortsword | 0 | -1 | 1 | 6 | 2 |
| 1107 | an obsidian-tipped spear | 68608 | 0 | 1 | 6 | 2 |
| 1123 | a long, obsidian-headed spear | 65536 | -1 | 1 | 8 | 2 |
| 1132 | a bone-tipped spear | 67584 | -1 | 1 | 6 | 2 |
| 1135 | a bone shortsword | 0 | -1 | 1 | 6 | 2 |
| 1147 | a bone longsword | 0 | -1 | 1 | 8 | 2 |
| 1148 | an obsidian throwing knife | 1024 | -1 | 1 | 4 | 2 |
| 1159 | a slim bone rapier | 0 | -1 | 1 | 7 | 2 |
| 1162 | a long bone-tipped pike | 73728 | -1 | 1 | 12 | 2 |
| 2404 | a steel stabbing sword | 0 | 0 | 1 | 8 | 2 |
| 2470 | a steel pike | 73728 | 0 | 1 | 10 | 2 |
| 2510 | an ebony-hilted steel rapier | 0 | 0 | 1 | 8 | 2 |
| 2834 | an ivory-hilted bone dirk | 0 | -1 | 1 | 5 | 2 |
| 2838 | a blood-red bone longsword | 0 | -1 | 1 | 8 | 2 |
| 2842 | a carved bone halfsword | 0 | -1 | 1 | 6 | 2 |
| 2898 | a short steel spear | 1024 | 0 | 1 | 7 | 2 |
| 4224 | An erdlu-claw hammer-pick | 0 | -1 | 1 | 9 | 2 |
| 6044 | An ornately-handled bone longknife | 0 | 0 | 1 | 6 | 2 |
| 6177 | a short obsidian stiletto | 0 | 0 | 1 | 4 | 2 |
| 6183 | a short, duskhorn-tipped fighting-stick | 0 | 0 | 1 | 1 | 2 |
| 6184 | a long, duskhorn-tipped fighting staff | 8192 | 0 | 1 | 10 | 2 |
| 6186 | an obsidian-bladed kris dagger | 0 | 0 | 1 | 4 | 2 |
| 6189 | a heavy, bone-bladed kris dagger | 0 | -1 | 1 | 6 | 2 |
| 6358 | a chisel-pointed obsidian carving knife | 0 | 0 | 1 | 2 | 2 |
| 6386 | a slender wooden sparring sword | 0 | 0 | 1 | 3 | 2 |
| 6393 | a buka-bri sparring stick | 0 | 0 | 1 | 3 | 2 |
| 6394 | a buka-bril sparring staff | 8192 | 0 | 1 | 4 | 2 |
| 6396 | a slender wooden sparring dagger | 0 | 0 | 1 | 2 | 2 |
| 6397 | a glass-headed sheaf arrow | 512 | 0 | 1 | 7 | 2 |
| 13605 | a nicked wooden shortsword | 8192 | -1 | 1 | 1 | 2 |
| 14008 | an old, cracked obsidian longsword | 0 | -1 | 1 | 8 | 2 |
| 14753 | a barb-headed, wooden longspear | 1024 | -1 | 1 | 9 | 2 |
| 14754 | a barbed, obsidian-tipped spear | 3072 | -1 | 1 | 8 | 2 |
| 14861 | a thin-bladed, bone spear | 0 | -1 | 1 | 8 | 2 |
| 15100 | an obsidian headed spear | 0 | 0 | 1 | 6 | 2 |
| 16101 | a white-fletched arrow | 512 | 0 | 1 | 1 | 2 |
| 16102 | a white-fletched arrow | 512 | 0 | 1 | 1 | 2 |
| 18902 | a bone-tipped spear | 0 | 0 | 1 | 1 | 2 |
| 19006 | a cruelly spiked arena bracer | 0 | -1 | 1 | 4 | 2 |
| 19065 | a long curved dagger | 0 | 0 | 1 | 5 | 2 |
| 19082 | a steel shortsword | 0 | 1 | 1 | 6 | 2 |
| 20018 | a long steel-headed spear | 2048 | 0 | 1 | 8 | 2 |
| 20029 | a flint-tipped arrow | 512 | 0 | 1 | 6 | 2 |
| 20031 | a jagged bone pickaxe | 0 | -1 | 1 | 8 | 2 |
| 20032 | an obsidian-headed pike | 8192 | -1 | 1 | 10 | 2 |
| 20100 | a long agafari spear | 2048 | -1 | 1 | 6 | 2 |
| 20300 | a spiked green crystal | 0 | 1 | 1 | 7 | 2 |
| 20744 | a long agafari spear | 0 | 0 | 1 | 6 | 2 |
| 20900 | a wooden dagger | 0 | 0 | 1 | 4 | 2 |
| 20923 | a shik-beak dirk | 0 | -1 | 1 | 5 | 2 |
| 20979 | a bone-hilted obsidian drusus sword | 0 | -1 | 1 | 7 | 2 |
| 21006 | an obsidian headed spear | 65536 | -1 | 1 | 6 | 2 |
| 21007 | a bone spiked sunstar | 1024 | 0 | 1 | 4 | 2 |
| 21022 | an obsidian shortsword | 0 | -1 | 1 | 6 | 2 |
| 21052 | a heavy stone mining pick | 8192 | -1 | 1 | 6 | 2 |
| 21086 | a small wooden spear | 0 | 1 | 1 | 1 | 2 |
| 21314 | a carru-antler spear | 0 | 1 | 1 | 6 | 2 |
| 21317 | a flint-tipped arrow | 512 | 0 | 1 | 6 | 2 |
| 21343 | a black and red fletched arrow | 512 | 0 | 1 | 7 | 2 |
| 21344 | a bone, leaf-headed spear | 0 | -1 | 1 | 8 | 2 |
| 22005 | a black arrow | 1048576 | -3 | 1 | 6 | 2 |
| 23018 | A piece of carru antler | 0 | -1 | 1 | 4 | 2 |
| 23601 | a flint-tipped arrow | 512 | 0 | 1 | 6 | 2 |
| 24036 | a long, sharp-bladed gythka | 8192 | -1 | 2 | 5 | 2 |
| 24037 | a heavy steel-tipped spear | 0 | 0 | 1 | 8 | 2 |
| 24041 | a slender baobab arrow | 69120 | 0 | 1 | 5 | 2 |
| 24100 | a long bone-headed spear | 3072 | -1 | 2 | 4 | 2 |
| 25108 | a curved obsidian shortblade | 0 | -1 | 1 | 6 | 2 |
| 25111 | a black-fletched bone-tipped arrow | 2560 | -1 | 1 | 5 | 2 |
| 25610 | a dildo-tipped staff entitled 'The Sodomizer' | 0 | 0 | 20 | 20 | 2 |
| 28284 | a wooden-shafted lucren hammer | 8192 | -1 | 1 | 10 | 2 |
| 29701 | a sharp steel battle claw | 0 | 1 | 1 | 4 | 2 |
| 29721 | a stout wooden spear | 0 | 0 | 1 | 6 | 2 |
| 35409 | a silver-handled black slavers whip | 1048576 | -1 | 2 | 3 | 2 |
| 36801 | a giant-sized stone spear | 0 | -2 | 3 | 6 | 2 |
| 37655 | a bone man-catcher | 8192 | 1 | 2 | 4 | 2 |
| 37656 | a bone-tipped spear | 2048 | 1 | 1 | 4 | 2 |
| 39001 | a slender wooden spear | 2048 | -2 | 1 | 6 | 2 |
| 39007 | a bone-tipped arrow | 1051136 | 0 | 1 | 6 | 2 |
| 44028 | a short agafari arrow | 512 | 0 | 1 | 5 | 2 |
| 45481 | a barbed arrow | 512 | 0 | 1 | 8 | 2 |
| 45482 | a flint headed arrow | 512 | -2 | 1 | 6 | 2 |
| 46803 | a 120mm shell | 512 | 0 | 50 | 20 | 2 |
| 49501 | an obsidian spear | 0 | -1 | 1 | 6 | 2 |
| 49678 | a bone longsword | 0 | -1 | 1 | 8 | 2 |
| 50025 | a gythka spear | 73728 | -1 | 1 | 6 | 2 |
| 50154 | a thin throwing knife | 2048 | -1 | 1 | 3 | 2 |
| 50291 | a bone kirisigi dagger | 0 | -1 | 1 | 5 | 2 |
| 50395 | a star-shaped shard of obsidian | 1024 | 1 | 1 | 4 | 2 |
| 50924 | a long obsidian-headed partisan | 73728 | -1 | 1 | 11 | 2 |
| 50932 | a stone-tipped bone arrow | 512 | -1 | 1 | 3 | 2 |
| 50933 | a stone-tipped bone bolt | 2097152 | -1 | 1 | 3 | 2 |
| 52920 | a steel leaf-headed short spear | 0 | 0 | 1 | 6 | 2 |
| 54301 | a long, thin spear | 3072 | -2 | 2 | 4 | 2 |
| 56223 | a long thornwood arrow | 1536 | 0 | 1 | 4 | 2 |
| 58012 | a long, parrying blade | 0 | -1 | 1 | 3 | 2 |
| 58014 | a slender, silver-handled longsword | 0 | -1 | 1 | 8 | 2 |
| 58028 | a silver-crested, slim bone rapier | 0 | -1 | 1 | 7 | 2 |
| 58152 | a silver-set, bone rapier | 0 | -1 | 1 | 7 | 2 |
| 58165 | a glossy black bone dragon's pick | 0 | -1 | 1 | 4 | 2 |
| 64001 | a jagged bone spear | 0 | -1 | 1 | 7 | 2 |
| 64108 | a long elvish dagger | 0 | -1 | 1 | 4 | 2 |
| 64110 | a slender wooden flight arrow | 512 | 0 | 1 | 5 | 2 |
| 64111 | an obsidian-headed sheaf arrow | 512 | 0 | 1 | 8 | 2 |
| 64112 | a slender glass-tipped flight arrow | 512 | 0 | 1 | 6 | 2 |
| 64113 | a glass-tipped wooden bolt | 2097152 | 0 | 1 | 7 | 2 |
| 64522 | a barbed bone spear | 3072 | -1 | 1 | 7 | 2 |
| 66104 | a wooden spear | 75776 | -1 | 1 | 8 | 2 |
| 66105 | a narrow bone dagger | 0 | -1 | 1 | 4 | 2 |
| 70100 | an obsidian-tipped spear | 0 | -1 | 1 | 6 | 2 |
| 70104 | a white bone spear | 1024 | -1 | 1 | 5 | 2 |
| 70207 | a black-fletched arrow | 2560 | 0 | 1 | 6 | 2 |
| 70210 | a long bone blade | 0 | -1 | 1 | 6 | 2 |
| 72957 | a black-hilted bone knife | 0 | 0 | 1 | 4 | 2 |
| 74014 | a bone V'lenka | 0 | -1 | 1 | 6 | 2 |
| 75003 | a mining pick | 0 | 1 | 1 | 4 | 2 |
| 75013 | an ornate onyx staff | 1048577 | 1 | 1 | 6 | 2 |
| 75018 | a wavy dagger | 1048576 | 0 | 1 | 4 | 2 |
+----------+-----------------------------------------------+-------------+------+------+------+------+
121 rows in set (0.01 sec)
STAB
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 3;
+----------+-------------------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+-------------------------------------------+-------------+------+------+------+------+
| 1 | a pile of dung | 0 | 2 | 2 | 5 | 3 |
| 700 | <--> Named Demon Components <--> | 66 | 4 | 3 | 6 | 3 |
| 710 | a thin-bladed copper sword | 0 | 0 | 1 | 6 | 3 |
| 1100 | a hardwood dagger | 0 | -2 | 1 | 4 | 3 |
| 1104 | an obsidian dagger | 0 | -1 | 1 | 4 | 3 |
| 1120 | a katar punch dagger | 0 | -1 | 1 | 4 | 3 |
| 1168 | a bone dagger | 0 | -1 | 1 | 4 | 3 |
| 1175 | a bone-handled, red-iron longknife | 3072 | 2 | 2 | 4 | 3 |
| 2005 | A serrated blade | 0 | 0 | 1 | 5 | 3 |
| 2014 | a black-hilted, iron halfsword | 0 | 0 | 1 | 6 | 3 |
| 2015 | a black quartz ken-tar knife | 1048576 | -1 | 1 | 7 | 3 |
| 2018 | an erdlu claw | 0 | -1 | 1 | 4 | 3 |
| 2023 | A huge, crimson greatsword | 8192 | 4 | 2 | 6 | 3 |
| 2102 | a jeweled iron dagger | 0 | 0 | 1 | 4 | 3 |
| 2120 | a small onyx knife | 0 | -1 | 1 | 6 | 3 |
| 2126 | a dark-crystal longknife | 0 | 0 | 1 | 2 | 3 |
| 2156 | a lightweight, basket-hilted bone rapier | 0 | -1 | 1 | 7 | 3 |
| 2221 | a long, black dirk | 0 | -1 | 1 | 5 | 3 |
| 2357 | a steel halfsword | 0 | 0 | 1 | 6 | 3 |
| 2542 | an old, steel mallet | 0 | 1 | 1 | 6 | 3 |
| 2544 | a small carving knife | 0 | 0 | 1 | 4 | 3 |
| 2751 | a black steel half-sword | 0 | 0 | 1 | 6 | 3 |
| 2831 | a carru horn knife | 0 | -1 | 1 | 3 | 3 |
| 3015 | a long, ivory hair-needle | 0 | 0 | 1 | 2 | 3 |
| 4112 | a stone-headed shovel | 8192 | 0 | 1 | 4 | 3 |
| 4223 | a bone-hilted obsidian dagger | 0 | -1 | 1 | 4 | 3 |
| 6003 | a thin bone stiletto | 0 | -1 | 1 | 4 | 3 |
| 6015 | a small silver knife | 64 | 1 | 1 | 4 | 3 |
| 6018 | a light wooden sparring dagger | 0 | -1 | 1 | 3 | 3 |
| 6036 | a slim bladed bronze shortsword | 0 | 1 | 1 | 6 | 3 |
| 6070 | a jagged bone poniard | 0 | 0 | 1 | 3 | 3 |
| 6071 | a small carving knife | 0 | 0 | 1 | 4 | 3 |
| 6074 | an ivory hilted longblade | 0 | -1 | 1 | 8 | 3 |
| 6139 | a pair of bone-bladed shears | 0 | 0 | 1 | 1 | 3 |
| 6185 | a slender bone skinning-knife | 0 | -1 | 1 | 4 | 3 |
| 6330 | a slim, bone backblade | 1024 | -1 | 1 | 6 | 3 |
| 6331 | a slim, bone longknife | 0 | -1 | 1 | 6 | 3 |
| 6357 | a very small obsidian carving knife | 0 | 0 | 1 | 2 | 3 |
| 6668 | a carved, erdlu-claw hook | 0 | -1 | 1 | 3 | 3 |
| 6901 | a rotten kalan fruit | 2048 | 0 | 1 | 1 | 3 |
| 7604 | a twisted bone knife | 0 | -1 | 1 | 4 | 3 |
| 7704 | a tiny steel dagger | 0 | 0 | 1 | 4 | 3 |
| 10002 | a twisted dagger | 0 | 0 | 1 | 7 | 3 |
| 14300 | a twisted obsidian knife | 0 | -1 | 2 | 3 | 3 |
| 14312 | a small thorn dart | 1024 | 0 | 1 | 4 | 3 |
| 14711 | an ivory-hilted, runed obsidian halfsword | 0 | -1 | 1 | 6 | 3 |
| 14780 | a black-handled throwing-longknife | 3072 | -1 | 1 | 5 | 3 |
| 14862 | a bone-handled, serrated longknife | 1024 | -1 | 1 | 4 | 3 |
| 14898 | a big red hat | 0 | 0 | 1 | 1 | 3 |
| 17018 | a dark, twisted dagger | 80 | 1 | 1 | 4 | 3 |
| 19010 | a two-handed broadsword | 8192 | 0 | 3 | 5 | 3 |
| 19111 | a mithril mining pick | 0 | 0 | 4 | 3 | 3 |
| 19140 | an iron-tipped spear | 0 | 0 | 3 | 3 | 3 |
| 19146 | a blood-stained mace | 65 | 0 | 5 | 5 | 3 |
| 19185 | an ophidian staff | 0 | 0 | 1 | 20 | 3 |
| 19201 | a clawed sceptre | 65 | 0 | 2 | 8 | 3 |
| 19223 | a very light but sharp spear | 0 | 0 | 3 | 3 | 3 |
| 19359 | a long Ilbarsi knife | 64 | 0 | 5 | 3 | 3 |
| 19401 | a battered iron long sword | 0 | 0 | 1 | 7 | 3 |
| 19407 | a broken short sword | 0 | 0 | 2 | 3 | 3 |
| 19707 | a bone halfsword | 0 | 0 | 2 | 3 | 3 |
| 19800 | a jagged sword | 0 | 0 | 4 | 4 | 3 |
| 19999 | a Chaos dagger | 3072 | 0 | 50 | 50 | 3 |
| 20027 | a flint dagger | 0 | 0 | 1 | 4 | 3 |
| 20041 | a bone halfsword | 0 | 0 | 1 | 5 | 3 |
| 20044 | a curved bone knife | 1024 | 0 | 1 | 4 | 3 |
| 20081 | a throwing knife | 3072 | -1 | 1 | 4 | 3 |
| 20939 | a yellowed bone skinning knife | 0 | -1 | 1 | 3 | 3 |
| 20977 | a black bone halfblade | 0 | -1 | 1 | 7 | 3 |
| 21097 | a bone needle and fibrous thread | 0 | 0 | 1 | 1 | 3 |
| 21219 | a long bone needle | 2097152 | 0 | 1 | 3 | 3 |
| 21302 | a fine steel dirk | 0 | 0 | 1 | 6 | 3 |
| 21319 | a bone-hilted, carru-antler longknife | 0 | 2 | 1 | 3 | 3 |
| 21335 | a durrit-claw skinning knife | 0 | 0 | 1 | 3 | 3 |
| 21336 | a dujat-tooth longknife | 0 | -1 | 1 | 5 | 3 |
| 21905 | a double-bladed anakore-claw knife | 0 | -1 | 1 | 4 | 3 |
| 22024 | a carved dagger | 0 | 0 | 1 | 4 | 3 |
| 22907 | a short stabbing spear | 0 | 0 | 1 | 5 | 3 |
| 22908 | a short straight blade | 0 | 0 | 1 | 5 | 3 |
| 22909 | a ceremonial dagger | 0 | 1 | 1 | 4 | 3 |
| 23004 | a crude stone knife | 0 | 0 | 1 | 4 | 3 |
| 23013 | a twisted steel knife | 0 | 0 | 1 | 6 | 3 |
| 23021 | a barbed stinger | 0 | 0 | 1 | 4 | 3 |
| 24011 | a notched bone knife | 0 | -1 | 1 | 5 | 3 |
| 24038 | a thin iron knife | 0 | 0 | 1 | 5 | 3 |
| 25105 | a curving chitin longknife | 0 | -1 | 1 | 5 | 3 |
| 25106 | a bone-headed agafari smallspear | 1024 | -1 | 1 | 5 | 3 |
| 25112 | an ebony-headed hammer | 8272 | 0 | 2 | 4 | 3 |
| 25113 | a curved bone halfblade | 0 | 0 | 1 | 5 | 3 |
| 25166 | a curved obsidian skinning knife | 0 | -1 | 1 | 3 | 3 |
| 25608 | a little blue smurf dildo | 0 | 0 | 15 | 15 | 3 |
| 28012 | a bone-bladed impaler | 73728 | 0 | 3 | 4 | 3 |
| 28015 | an ornate, bone dagger | 0 | -1 | 1 | 1 | 3 |
| 28016 | a wooden warhammer | 0 | 2 | 4 | 1 | 3 |
| 28022 | a silver-inlaid bronze halfsword | 128 | -2 | 1 | 7 | 3 |
| 29001 | a bone hammer | 0 | 0 | 2 | 4 | 3 |
| 29003 | a giant's club | 0 | 0 | 2 | 8 | 3 |
| 29703 | a ceremonial dagger | 0 | 0 | 1 | 4 | 3 |
| 30001 | a prismatic sword | 1089 | 0 | 3 | 4 | 3 |
| 30002 | a grimey two-bladed sword | 0 | 0 | 1 | 12 | 3 |
| 30008 | a giants leg bone | 0 | 0 | 1 | 6 | 3 |
| 30009 | a large stone club | 0 | 1 | 1 | 12 | 3 |
| 30010 | Grom's axe | 0 | 0 | 3 | 10 | 3 |
| 30019 | An ethereal sword | 2 | 0 | 1 | 5 | 3 |
| 30034 | a thorn dirk | 0 | 0 | 1 | 5 | 3 |
| 30300 | the serrated scimitar | 512 | 0 | 3 | 3 | 3 |
| 30500 | A short obsidian sword | 0 | 0 | 1 | 6 | 3 |
| 30712 | a large talon | 0 | 0 | 1 | 6 | 3 |
| 30999 | A bolt of lightning | 0 | 0 | 3 | 8 | 3 |
| 33103 | a glass dagger | 0 | 0 | 1 | 1 | 3 |
| 33105 | a glass-tipped spear | 0 | 0 | 1 | 1 | 3 |
| 35410 | a black-handled silver stiletto | 0 | 0 | 2 | 2 | 3 |
| 36988 | a steel broadsword | 0 | 1 | 1 | 8 | 3 |
| 37005 | a dragon headed dagger | 0 | 0 | 1 | 1 | 3 |
| 37010 | a sand dagger | 0 | 1 | 2 | 2 | 3 |
| 37101 | a steel dagger | 0 | 0 | 1 | 5 | 3 |
| 37661 | a carru-fang knife | 0 | -1 | 1 | 4 | 3 |
| 37663 | a glass dagger | 0 | 0 | 1 | 3 | 3 |
| 39002 | a long flint knife | 0 | -1 | 1 | 5 | 3 |
| 39005 | a bone ken-tar knife | 1049600 | -1 | 1 | 7 | 3 |
| 39031 | a slender baobab knife | 4096 | -2 | 1 | 4 | 3 |
| 39032 | a long bone needle | 2097152 | 0 | 1 | 3 | 3 |
| 39136 | a long, thin flint knife | 1024 | -1 | 1 | 4 | 3 |
| 43015 | a forked blade | 0 | 0 | 2 | 4 | 3 |
| 43025 | a glowing knife | 0 | 0 | 3 | 4 | 3 |
| 44004 | a long, tapering thorn | 0 | 0 | 1 | 2 | 3 |
| 45101 | a tassled spear | 0 | 0 | 1 | 8 | 3 |
| 45559 | a long thin stiletto | 0 | 1 | 1 | 6 | 3 |
| 45724 | a long spear | 2048 | 1 | 1 | 6 | 3 |
| 46000 | a short stabbing belt | 0 | 2 | 1 | 1 | 3 |
| 46007 | a rotten kalan fruit | 3072 | 0 | 1 | 1 | 3 |
| 46013 | a small steel dirk | 0 | 0 | 1 | 6 | 3 |
| 46104 | a spongy, blue football | 3072 | 0 | 1 | 1 | 3 |
| 50019 | an obsidian dirk | 1024 | 0 | 1 | 4 | 3 |
| 50057 | an anakore claw knife | 0 | -1 | 1 | 4 | 3 |
| 50088 | a black-hilted knife | 0 | -1 | 1 | 4 | 3 |
| 50129 | a small steel grace blade | 0 | 0 | 1 | 4 | 3 |
| 50151 | a carved bone stiletto | 0 | -1 | 1 | 3 | 3 |
| 50152 | a forked dagger | 1024 | -1 | 2 | 3 | 3 |
| 50314 | a mantis blade | 0 | -1 | 1 | 8 | 3 |
| 50396 | a fire-blackened, bone ken-tar longknife | 1024 | 2 | 1 | 7 | 3 |
| 50901 | a carved bone knife | 0 | 0 | 1 | 6 | 3 |
| 50905 | a skull-hilted obsidian knife | 0 | -1 | 1 | 7 | 3 |
| 50922 | a jagged-edged bone longknife | 0 | -1 | 1 | 4 | 3 |
| 50929 | A black-dyed bone throwing knife | 2048 | -1 | 1 | 4 | 3 |
| 51801 | a blood-stained sword | 0 | 0 | 1 | 1 | 3 |
| 52922 | a skull-hilted knife | 0 | 0 | 1 | 5 | 3 |
| 54002 | a piece of crap | 0 | 0 | 1 | 1 | 3 |
| 54012 | a long hilted poignard | 0 | 0 | 1 | 4 | 3 |
| 54014 | a crude stiletto | 0 | 0 | 1 | 3 | 3 |
| 54302 | a crude knife | 0 | -1 | 1 | 3 | 3 |
| 56002 | <Savak's> knife | 0 | 0 | 1 | 1 | 3 |
| 56203 | a duskhorn dagger | 0 | -1 | 1 | 5 | 3 |
| 58015 | an exquisitely gilded, blood-stained dirk | 1 | -1 | 1 | 5 | 3 |
| 58030 | an ivory-hilted, slender halfsword | 0 | -1 | 1 | 5 | 3 |
| 58040 | a gem-encrusted, bone ken-tar knife | 0 | -1 | 1 | 5 | 3 |
| 58043 | a serrated, dujat-tooth longknife | 0 | -1 | 1 | 5 | 3 |
| 58050 | a silver-etched, blackened longknife | 0 | -1 | 1 | 5 | 3 |
| 58066 | a blackened, steel-headed stabbing spear | 0 | 0 | 2 | 6 | 3 |
| 58130 | a thin, bone-bladed longknife | 0 | -1 | 1 | 4 | 3 |
| 58162 | an antler-hilted, dark quartz dagger | 0 | -1 | 1 | 4 | 3 |
| 58164 | a blackened bone sai | 0 | -1 | 1 | 6 | 3 |
| 58250 | a long, steel claymore | 0 | 5 | 10 | 10 | 3 |
| 58251 | a small skinning knife | 0 | 0 | 3 | 1 | 3 |
| 63027 | a steel elfblade | 0 | 1 | 1 | 4 | 3 |
| 63032 | a very fine steel dirk | 0 | 0 | 1 | 3 | 3 |
| 63048 | a wicked stiletto | 0 | 0 | 1 | 4 | 3 |
| 64005 | an obsidian halfsword | 0 | -1 | 1 | 6 | 3 |
| 64015 | a bone-handled obsidian longknife | 1024 | -1 | 1 | 6 | 3 |
| 64016 | a thin hardwood javelin | 2048 | -2 | 1 | 6 | 3 |
| 64031 | an erdlu claw knife | 0 | -1 | 1 | 4 | 3 |
| 64078 | a red-iron longknife | 1024 | 0 | 1 | 4 | 3 |
| 64087 | a wicked looking dagger | 0 | -2 | 1 | 6 | 3 |
| 64096 | a bone-tipped wooden bolt | 2097152 | 0 | 1 | 6 | 3 |
| 64109 | a chitin skinning knife | 0 | -1 | 1 | 3 | 3 |
| 64144 | a long-bladed dirk | 0 | -1 | 1 | 5 | 3 |
| 64145 | a tapered throwing knife | 2048 | -1 | 1 | 4 | 3 |
| 64154 | a black-hilted bone longknife | 0 | -1 | 1 | 6 | 3 |
| 64555 | a thin bone dagger | 0 | -1 | 1 | 5 | 3 |
| 65502 | a small, yellow-feathered arrow | 1049088 | 0 | 1 | 6 | 3 |
| 65503 | a black-fletched arrow | 512 | 0 | 1 | 6 | 3 |
| 66014 | an obsidian spear | 75776 | -1 | 1 | 8 | 3 |
| 66100 | an obsidian shard | 0 | 0 | 1 | 4 | 3 |
| 66103 | an iron pick | 0 | 1 | 1 | 2 | 3 |
| 67016 | a blackened dagger of mekillot bone | 0 | 0 | 2 | 3 | 3 |
| 67104 | a small, sharp piece of flint | 3072 | -1 | 1 | 4 | 3 |
| 70183 | a sharp obsidian hunting knife | 0 | -1 | 1 | 5 | 3 |
| 70194 | a star-shaped shard of obsidian | 1024 | 0 | 1 | 4 | 3 |
| 70195 | a painted obsidian halfsword | 0 | -1 | 1 | 6 | 3 |
| 70198 | a sharp bone jambiya | 0 | -1 | 1 | 5 | 3 |
| 70226 | a bone-handled steel kris | 0 | 0 | 1 | 6 | 3 |
| 70227 | a steel punch dagger | 0 | 0 | 1 | 4 | 3 |
| 70228 | a black-bladed steel punch dagger | 0 | 0 | 1 | 4 | 3 |
| 70229 | a bone-handed steel punch dagger | 0 | 0 | 1 | 4 | 3 |
| 70299 | a barbed, black arrow | 1049088 | 0 | 1 | 6 | 3 |
| 70301 | a long, sharp stinger | 1049088 | 0 | 1 | 4 | 3 |
| 70329 | a tapering yellow fang | 0 | -2 | 1 | 3 | 3 |
| 72802 | a silver-set, bone-bladed dirk | 0 | 0 | 1 | 4 | 3 |
| 72803 | an ivory-hilted, obsidian-bladed dirk | 0 | 0 | 2 | 2 | 3 |
| 72804 | a wavy-bladed, obsidian dirk | 0 | 4 | 2 | 2 | 3 |
| 72806 | a slender, serpent hilted dagger | 0 | 0 | 1 | 4 | 3 |
| 72923 | a narrow-bladed sword | 0 | 0 | 1 | 1 | 3 |
| 72944 | a fire-blackened anakore-claw knife | 0 | 0 | 2 | 2 | 3 |
| 72951 | a fire-blackened skinning knife | 0 | 0 | 1 | 4 | 3 |
+----------+-------------------------------------------+-------------+------+------+------+------+
204 rows in set (0.01 sec)
CHOP
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 4;
+----------+--------------------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+--------------------------------------------+-------------+------+------+------+------+
| 1156 | a stone-bladed battleaxe | 0 | 0 | 1 | 8 | 4 |
| 1166 | a huge bone-bladed battleaxe | 8192 | -1 | 1 | 10 | 4 |
| 2412 | a very long obsidian poleaxe | 73728 | -1 | 2 | 6 | 4 |
| 2451 | a stone battle axe | 0 | 0 | 1 | 5 | 4 |
| 2509 | a huge, double-bitted axe | 8192 | 1 | 1 | 9 | 4 |
| 4110 | a small hoe | 8192 | 0 | 1 | 3 | 4 |
| 6020 | a light wooden sparring axe | 0 | -1 | 1 | 3 | 4 |
| 6077 | a bone kukri knife | 0 | -1 | 1 | 8 | 4 |
| 6181 | a long, bone bladed axe | 0 | -1 | 1 | 8 | 4 |
| 6392 | a buka-chi sparring axe | 0 | 0 | 1 | 3 | 4 |
| 13201 | an obsidian axe | 8192 | 0 | 2 | 5 | 4 |
| 14124 | a bone-headed gardening hoe | 0 | 0 | 1 | 4 | 4 |
| 14703 | a one-handed, crescent-bladed axe | 0 | -1 | 2 | 4 | 4 |
| 19250 | a double-edged axe | 64 | 0 | 3 | 5 | 4 |
| 20038 | a broad stone chisel | 0 | 0 | 1 | 3 | 4 |
| 20093 | a huge steel bladed axe | 8192 | 0 | 2 | 5 | 4 |
| 20110 | a bone-headed tomahawk | 1024 | -1 | 1 | 6 | 4 |
| 20400 | a bone-bladed halberd | 73728 | -1 | 1 | 10 | 4 |
| 21020 | a bone hatchet | 1024 | -1 | 1 | 6 | 4 |
| 21217 | a heavy bone-handled chitin tomahawk | 1024 | -1 | 1 | 7 | 4 |
| 21218 | a double-bladed dujat-tooth axe | 1024 | -1 | 1 | 8 | 4 |
| 21338 | a toy wooden tomahawk | 0 | -1 | 1 | 1 | 4 |
| 25165 | an one-handed crescent-bladed axe | 0 | -1 | 1 | 7 | 4 |
| 25167 | an obsidian-bladed throwing axe | 3072 | -1 | 1 | 5 | 4 |
| 25702 | a jagged gaj mandible | 8192 | -1 | 1 | 6 | 4 |
| 35389 | a black-hilted bone carrikal | 0 | 0 | 1 | 8 | 4 |
| 36101 | a heavy obsidian axe | 0 | 1 | 2 | 5 | 4 |
| 37502 | a bone hand-axe | 0 | -1 | 2 | 3 | 4 |
| 45723 | a wooden axe | 0 | -3 | 1 | 9 | 4 |
| 49401 | a crude inix-jaw hatchet | 0 | -1 | 1 | 6 | 4 |
| 50014 | a giant double-bladed axe | 8192 | -1 | 2 | 6 | 4 |
| 50289 | an obsidian-bladed battle axe | 0 | -1 | 2 | 4 | 4 |
| 50290 | a crescent-bladed obsidian axe | 0 | -1 | 1 | 7 | 4 |
| 58042 | an emblazoned, dwarven bone-bladed halberd | 8192 | -1 | 2 | 5 | 4 |
| 58044 | a long-handled, bone lumber axe | 8192 | -1 | 1 | 8 | 4 |
| 58611 | a short-handled, throwing axe | 2048 | 0 | 1 | 6 | 4 |
| 63040 | a fine steel halberd | 0 | 0 | 2 | 5 | 4 |
| 64042 | a twin-bladed bone axe | 0 | -1 | 2 | 4 | 4 |
| 64071 | a runed dwarven handaxe | 256 | 0 | 1 | 6 | 4 |
| 70218 | a heavy bone scimitar | 0 | -1 | 2 | 5 | 4 |
| 72805 | a twin-bladed obsidian axe | 0 | -3 | 2 | 5 | 4 |
| 75015 | a well-used lotulis | 0 | 0 | 1 | 8 | 4 |
| 76126 | a rune-carved, stone axe | 0 | 2 | 2 | 6 | 4 |
+----------+--------------------------------------------+-------------+------+------+------+------+
43 rows in set (0.01 sec)
SLASH
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 5;
+----------+---------------------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+---------------------------------------------+-------------+------+------+------+------+
| 176 | a sweeping, black bastard sword | 0 | -1 | 1 | 10 | 5 |
| 212 | a mottled blue steel sword | 0 | 1 | 5 | 2 | 5 |
| 1103 | an obsidian longsword | 0 | -1 | 1 | 8 | 5 |
| 1105 | an obsidian knife | 1024 | -1 | 1 | 4 | 5 |
| 1138 | a bone broadsword | 0 | -1 | 1 | 9 | 5 |
| 1144 | a long bone-bladed glaive | 73728 | -1 | 2 | 6 | 5 |
| 1153 | a bone bastard sword | 0 | -1 | 1 | 10 | 5 |
| 1176 | a bone-handled, red-iron hawkblade | 0 | 3 | 2 | 4 | 5 |
| 2069 | a black bone longsword | 0 | -1 | 2 | 4 | 5 |
| 2084 | a skull-hilted bone scimitar | 16 | 0 | 8 | 1 | 5 |
| 2089 | a red-moon pommeled bone scimitar | 0 | -1 | 1 | 9 | 5 |
| 2101 | an I.O.U. for three million obsidian coins | 0 | 1 | 1 | 8 | 5 |
| 2153 | a serrated steel longknife | 0 | 0 | 1 | 7 | 5 |
| 2225 | a serrated broadsword | 0 | 3 | 2 | 4 | 5 |
| 2354 | a long, iron scythe | 8192 | 0 | 1 | 10 | 5 |
| 2403 | a sharp bone falchion | 0 | -1 | 1 | 9 | 5 |
| 2410 | a cruel obsidian dagger | 0 | -2 | 3 | 2 | 5 |
| 2469 | a bladed staff | 8192 | 0 | 1 | 8 | 5 |
| 2833 | an ivory-hilted bone saber | 0 | -1 | 1 | 8 | 5 |
| 2837 | a carved bone halfsword | 0 | -1 | 1 | 6 | 5 |
| 2847 | a wicked-looking bladed staff | 8192 | -1 | 2 | 4 | 5 |
| 3077 | a black-hilted bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 3078 | a curved, black-hilted shortsword | 0 | 0 | 1 | 6 | 5 |
| 4111 | a long-handled scythe | 8192 | -2 | 2 | 5 | 5 |
| 6002 | a bone tulwar | 8192 | 0 | 2 | 6 | 5 |
| 6019 | a light wooden sparring sword | 0 | 0 | 1 | 3 | 5 |
| 6176 | a bone, bladed staff | 8192 | -1 | 1 | 10 | 5 |
| 6188 | a chitin-bladed fighting stick | 0 | 0 | 1 | 8 | 5 |
| 6354 | a wide-bladed obsidian jambiya | 0 | -1 | 1 | 8 | 5 |
| 6359 | a sharply curved carving knife | 0 | 0 | 1 | 2 | 5 |
| 6385 | a curved wooden sparring sword | 0 | 0 | 1 | 3 | 5 |
| 6390 | a buka-si sparring stick | 0 | 0 | 1 | 3 | 5 |
| 6391 | a buka-sil sparring staff | 8192 | 0 | 1 | 4 | 5 |
| 6395 | a curved wooden sparring dagger | 0 | 0 | 1 | 2 | 5 |
| 6730 | a small carving knife | 0 | -1 | 1 | 2 | 5 |
| 6732 | a serrated bone saw | 0 | -3 | 1 | 1 | 5 |
| 6860 | a long, curved bone knife | 0 | -1 | 1 | 4 | 5 |
| 6861 | a serrated bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 13203 | an ancient obsidian hawkblade | 0 | -1 | 2 | 4 | 5 |
| 14318 | an ankheg-mandible scimitar | 0 | -1 | 1 | 8 | 5 |
| 14700 | an immense, two-handed bone greatsword | 8192 | -1 | 2 | 6 | 5 |
| 14710 | a slender, bone-bladed sabre | 0 | -1 | 1 | 8 | 5 |
| 14715 | a bone-handled, curved obsidian sabre | 0 | -1 | 1 | 8 | 5 |
| 14785 | a moon-pommeled, blackened-bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 14786 | a sun-pommeled, blackened-bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 14860 | a basket-hilted, bone rapier | 0 | -1 | 1 | 7 | 5 |
| 14919 | a longsword made of pure fire | 16842816 | 1 | 2 | 5 | 5 |
| 17025 | a ceremonial obsidian sword | 0 | 0 | 1 | 4 | 5 |
| 17030 | a crystal torus | 4196352 | 0 | 1 | 4 | 5 |
| 18601 | a heavy bladed bone jambiya | 0 | -1 | 1 | 8 | 5 |
| 19500 | a blued-steel falchion | 0 | 0 | 6 | 3 | 5 |
| 19508 | a bone-studded leather bracer | 0 | -1 | 1 | 5 | 5 |
| 20015 | a barbed whip | 0 | 0 | 1 | 4 | 5 |
| 20017 | a worn and rusted blade | 0 | 0 | 1 | 2 | 5 |
| 20026 | a toothed wooden shortsword | 0 | -3 | 1 | 6 | 5 |
| 20033 | a long bone-bladed voulge | 73728 | -1 | 2 | 6 | 5 |
| 20040 | a small carving knife | 0 | 0 | 1 | 2 | 5 |
| 20050 | a bone hawkblade | 0 | -1 | 2 | 4 | 5 |
| 20082 | a grizzkt staff | 73728 | -1 | 2 | 4 | 5 |
| 20109 | a curved bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 20144 | a jagged bone cutlass | 0 | -1 | 1 | 9 | 5 |
| 20150 | an iron hawkblade | 0 | 0 | 2 | 4 | 5 |
| 20156 | a black steel longsword | 1 | 2 | 1 | 8 | 5 |
| 20157 | a khopesh dagger | 0 | 0 | 1 | 4 | 5 |
| 20701 | a huge glass-like sword | 8192 | -3 | 2 | 6 | 5 |
| 21016 | a curved bone knife | 0 | -1 | 1 | 4 | 5 |
| 21017 | a curved steel scimitar | 0 | 1 | 1 | 8 | 5 |
| 23011 | a practice sword | 0 | 0 | 1 | 1 | 5 |
| 24001 | a bone-bladed gythka staff | 73728 | -1 | 2 | 4 | 5 |
| 24035 | a crystal chatkcha | 4197376 | -1 | 2 | 3 | 5 |
| 24039 | a small iron chatkcha | 4197376 | 0 | 1 | 5 | 5 |
| 25103 | an enormous, two-handed obsidian sword | 270416 | 1 | 1 | 12 | 5 |
| 25115 | a bone-bladed leather gloveblade | 65536 | -1 | 1 | 6 | 5 |
| 25168 | an obsidian-bladed, wooden-poled bardiche | 8192 | -1 | 2 | 4 | 5 |
| 25169 | a diamond-hilted silver falchion | 16785760 | 5 | 7 | 5 | 5 |
| 25170 | a ghyrrak-mandible shortsword | 0 | -1 | 1 | 6 | 5 |
| 28010 | an ornate, curved bone scimitar | 0 | 0 | 1 | 5 | 5 |
| 28285 | a kank-mandible shortsword | 0 | -1 | 1 | 6 | 5 |
| 35051 | a long, braided leather whip | 0 | -1 | 2 | 3 | 5 |
| 35103 | a straight, bone longsword | 0 | -1 | 1 | 8 | 5 |
| 35104 | a thick, leather-hilted broadsword | 8192 | -1 | 2 | 7 | 5 |
| 35919 | a jet-black scimitar | 0 | -1 | 1 | 8 | 5 |
| 36999 | a six-foot steel greatsword | 0 | 1 | 2 | 8 | 5 |
| 37000 | a steel shortsword named 'Mortal Slayer' | 0 | 20 | 20 | 20 | 5 |
| 37007 | a steel greatsword named 'Immortal Slayer' | 0 | 40 | 40 | 40 | 5 |
| 37301 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37302 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37303 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37304 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37305 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37306 | a black-bladed sword | 0 | 2 | 3 | 4 | 5 |
| 37651 | a bone chatkcha | 2048 | 0 | 1 | 4 | 5 |
| 37652 | an obsidian naginata | 8192 | 0 | 2 | 6 | 5 |
| 37653 | an obsidian greatsword | 8192 | -2 | 1 | 6 | 5 |
| 37654 | a jagged bone sword | 0 | 0 | 2 | 3 | 5 |
| 37659 | a bone greatsword | 8192 | -1 | 2 | 6 | 5 |
| 37662 | a bone-bladed fauchard | 8192 | -1 | 2 | 5 | 5 |
| 39003 | a sharp bone knife | 0 | -1 | 1 | 4 | 5 |
| 39004 | a bone shortsword | 0 | -1 | 1 | 6 | 5 |
| 39039 | a cilops jaw | 1048576 | -1 | 1 | 4 | 5 |
| 39041 | a chitinous arm-blade | 0 | -1 | 1 | 6 | 5 |
| 43013 | a Scimitar | 0 | 0 | 2 | 4 | 5 |
| 43033 | a giant bone broadsword | 0 | 0 | 4 | 5 | 5 |
| 44042 | a chitin-bladed wrist wrap | 0 | 0 | 1 | 3 | 5 |
| 44048 | a ruby-hilted, curved sword | 0 | 0 | 1 | 8 | 5 |
| 44049 | a curved bone sword | 0 | 0 | 1 | 7 | 5 |
| 45102 | a tassled blade | 8192 | 1 | 1 | 6 | 5 |
| 45554 | a curved sword | 0 | 1 | 1 | 6 | 5 |
| 45635 | a bronze-bladed staff | 8192 | 0 | 1 | 8 | 5 |
| 49403 | an obsidian longsword | 0 | -1 | 1 | 8 | 5 |
| 49507 | a large, blue-bladed dwarven sword | 8192 | 0 | 2 | 6 | 5 |
| 49511 | a bone handled whip | 0 | 0 | 1 | 4 | 5 |
| 50153 | a hooked knife | 0 | -1 | 1 | 3 | 5 |
| 50304 | a wicked-looking hatchet | 0 | 0 | 2 | 4 | 5 |
| 50923 | an obsidian-bladed, bone bardiche | 73728 | -1 | 2 | 4 | 5 |
| 52130 | a braided steel whip | 0 | 0 | 1 | 1 | 5 |
| 52907 | a stark white blade | 0 | 0 | 1 | 8 | 5 |
| 54000 | a black slavers whip | 0 | 0 | 1 | 4 | 5 |
| 58000 | an engraved, broad-hilted bastard sword | 0 | 0 | 2 | 5 | 5 |
| 58001 | a bone-handled, obsidian shortblade | 0 | 0 | 1 | 6 | 5 |
| 58002 | an obsidian, goudra-hilted saber | 0 | 1 | 1 | 6 | 5 |
| 58003 | a wide-bladed, serrated shortsword | 0 | -2 | 1 | 6 | 5 |
| 58006 | an ivory-hilted, bone broadsword | 0 | -1 | 1 | 9 | 5 |
| 58007 | an ivory-hilted, curved bone falchion | 0 | -1 | 1 | 9 | 5 |
| 58009 | a curved, mantis-carved obsidian scimitar | 0 | -2 | 1 | 8 | 5 |
| 58010 | a curved, mantis-carved obsidian shortblade | 0 | -2 | 1 | 6 | 5 |
| 58011 | a long-handled, serrated broadsword | 0 | -1 | 1 | 9 | 5 |
| 58013 | an ornate, khopesh sword | 0 | -1 | 1 | 8 | 5 |
| 58016 | a wicked-edged, bone scimitar | 0 | -1 | 1 | 8 | 5 |
| 58019 | a crimson-jeweled, slender bone scimitar | 0 | 0 | 8 | 1 | 5 |
| 58029 | an ivory-hilted, dark-jeweled scimitar | 0 | -1 | 1 | 8 | 5 |
| 58045 | an ivory-hilted, jaded bone broadsword | 0 | -1 | 1 | 9 | 5 |
| 58046 | a narrow-hilted, jaded khopesh blade | 0 | -1 | 1 | 8 | 5 |
| 58048 | a bronze-handled, wicked-bladed staff | 8192 | -1 | 2 | 6 | 5 |
| 58049 | a mantis-carved, bone bastard sword | 0 | -1 | 1 | 10 | 5 |
| 58052 | a wyvern-hilted, carved bastard sword | 0 | -1 | 1 | 10 | 5 |
| 58094 | an engraved, jet-black scimitar | 0 | -1 | 1 | 8 | 5 |
| 58151 | a bone two-handed sword | 8192 | -1 | 2 | 6 | 5 |
| 63000 | a blackblade | 0 | 0 | 2 | 3 | 5 |
| 63011 | a thin, long blade | 2 | 1 | 2 | 3 | 5 |
| 63017 | a crude scourge | 0 | 0 | 2 | 2 | 5 |
| 63800 | a Broadsword named, 'Sunblight' | 0 | 4 | 4 | 4 | 5 |
| 64007 | a heavy bone greatsword | 8192 | -1 | 2 | 6 | 5 |
| 64077 | a red-iron hawkblade | 0 | 0 | 2 | 4 | 5 |
| 64089 | a cilops jaw | 1048576 | -1 | 1 | 4 | 5 |
| 64092 | a steel longsword | 0 | 1 | 1 | 8 | 5 |
| 64539 | a chitin wrist-razor | 0 | -1 | 1 | 4 | 5 |
| 66106 | a curved obsidian sword | 0 | -1 | 1 | 8 | 5 |
| 67100 | a wicked khopesh longknife | 0 | -1 | 3 | 2 | 5 |
| 67101 | a sheaf-bladed shortspear | 0 | -1 | 2 | 4 | 5 |
| 70208 | a curved sword of bone | 0 | -1 | 1 | 8 | 5 |
| 70212 | a toothed sunback-jaw shortsword | 0 | -1 | 2 | 3 | 5 |
| 70213 | a sharp bone yataghan | 0 | -1 | 1 | 9 | 5 |
| 70216 | a wide bone shortsword | 0 | -1 | 1 | 6 | 5 |
| 72800 | a blackened, mekillot-bone bastard sword | 0 | 0 | 1 | 6 | 5 |
| 72801 | a blackened, jagged-edged scimitar | 0 | -1 | 2 | 3 | 5 |
| 72952 | a hilt-carved bone scimitar | 0 | 0 | 1 | 7 | 5 |
| 74008 | a curved sword of bone | 0 | -1 | 1 | 8 | 5 |
| 75017 | a viscious, steel-plated scourge | 0 | 2 | 1 | 4 | 5 |
+----------+---------------------------------------------+-------------+------+------+------+------+
159 rows in set (0.01 sec)
CLAW
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 6;
+----------+------------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+------------------------------+-------------+------+------+------+------+
| 64575 | a leather cap with bone hook | 0 | -1 | 1 | 6 | 6 |
+----------+------------------------------+-------------+------+------+------+------+
1 row in set (0.01 sec)
WHIP
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 7;
+----------+---------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+---------------------+-------------+------+------+------+------+
| 19141 | an iron warhammer | 0 | 0 | 3 | 2 | 7 |
| 30017 | the pan | 0 | 0 | 1 | 10 | 7 |
| 30033 | the thorny whip | 0 | 0 | 2 | 3 | 7 |
| 30035 | a thorny flail | 0 | 0 | 2 | 4 | 7 |
| 30541 | the battlehammer | 0 | 0 | 2 | 6 | 7 |
| 37350 | a riding crop | 0 | 0 | 1 | 1 | 7 |
| 43000 | A Black Rod | 66 | 0 | 4 | 4 | 7 |
| 43007 | a giant bone club | 0 | 0 | 4 | 5 | 7 |
| 43008 | a steel mace | 0 | 0 | 3 | 4 | 7 |
| 43020 | a lead mace | 8192 | 0 | 2 | 4 | 7 |
| 43029 | a hardwood staff | 0 | 0 | 2 | 5 | 7 |
| 65310 | a carved bone staff | 0 | 0 | 1 | 1 | 7 |
| 74005 | a chitinous whip | 0 | 2 | 2 | 4 | 7 |
+----------+---------------------+-------------+------+------+------+------+
13 rows in set (0.01 sec)
STING
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 9;
+----------+-----------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+-----------------------+-------------+------+------+------+------+
| 25807 | a sharp ghyrrak spine | 1048576 | -1 | 1 | 3 | 9 |
+----------+-----------------------+-------------+------+------+------+------+
1 row in set (0.01 sec)
?
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, extra_flags, val0, val1, val2, val3 from objects where o_type = 5 AND val3 = 11;
+----------+---------------------------+-------------+------+------+------+------+
| obj_vnum | sdesc | extra_flags | val0 | val1 | val2 | val3 |
+----------+---------------------------+-------------+------+------+------+------+
| 19011 | a long steel dagger | 0 | 0 | 3 | 3 | 11 |
| 19100 | a barbed spear | 0 | 0 | 5 | 2 | 11 |
| 19104 | a heavy black mace | 65 | 3 | 3 | 5 | 11 |
| 19110 | a steel mining pick | 0 | 0 | 3 | 4 | 11 |
| 30003 | the pointed bamboo spear | 0 | 0 | 2 | 3 | 11 |
| 30018 | an iron spear | 2 | 0 | 4 | 3 | 11 |
| 30022 | Lestarno's ancient dagger | 0 | 0 | 3 | 8 | 11 |
| 30030 | a sharp stone shard | 0 | 0 | 2 | 2 | 11 |
| 30031 | gloves of withering | 66 | 0 | 1 | 2 | 11 |
| 30601 | A wisp of mist | 2048 | 0 | 2 | 4 | 11 |
| 30700 | Cutlass | 0 | 0 | 10 | 10 | 11 |
| 43011 | a steel dagger | 0 | 0 | 4 | 3 | 11 |
| 43014 | a black dagger | 1 | 0 | 4 | 3 | 11 |
| 43026 | a pointy stick | 0 | 0 | 2 | 2 | 11 |
| 43032 | a bronze dagger | 0 | 0 | 2 | 4 | 11 |
+----------+---------------------------+-------------+------+------+------+------+
15 rows in set (0.01 sec)
These weapons have special scripts attached (I don't have the scripts). Most are imm toys.
MariaDB [ARMAG_TEST]> select o1.obj_vnum, sdesc, val3, o2.special_type, o2.special_command, o2.special_name from objects o1 inner join object_specials o2 where o1.o_type = 5 AND o1.obj_vnum = o2.obj_vnum ;
+----------+-----------------------------------------------+------+--------------+-----------------+-----------------+
| obj_vnum | sdesc | val3 | special_type | special_command | special_name |
+----------+-----------------------------------------------+------+--------------+-----------------+-----------------+
| 14999 | the Immortal's paddle | 1 | dmpl | spank | paddle |
| 20015 | a barbed whip | 5 | dmpl | use | slaver_whip |
| 20093 | a huge steel bladed axe | 4 | dmpl | barter | executioner_axe |
| 24036 | a long, sharp-bladed gythka | 2 | dmpl | pulse | gythka |
| 24037 | a heavy steel-tipped spear | 2 | dmpl | pulse | chaktul_spear |
| 25608 | a little blue smurf dildo | 3 | dmpl | touch | sodomizer |
| 25610 | a dildo-tipped staff entitled 'The Sodomizer' | 2 | dmpl | touch | sodomizer |
| 35409 | a silver-handled black slavers whip | 2 | dmpl | use | slaver_whip |
| 37005 | a dragon headed dagger | 3 | dmpl | barter | altar_knife |
| 37007 | a steel greatsword named 'Immortal Slayer' | 5 | C | kill | immortal_slayer |
| 37009 | a short handled tazar gun | 0 | C | shoot | tazar_gun |
| 37009 | a short handled tazar gun | 0 | C | switch | tazar_gun |
| 54000 | a black slavers whip | 5 | dmpl | use | slaver_whip |
+----------+-----------------------------------------------+------+--------------+-----------------+-----------------+
13 rows in set (0.00 sec)
|
|
jkarr
GDB Superstar
Posts: 2,070
|
Post by jkarr on Nov 16, 2018 14:19:58 GMT -5
been quite a while since ive seen some of these
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 16, 2018 14:32:30 GMT -5
In constants.c:
"Armor points are directly proportional to the amount of damage " "absorbed\n\r"
"by a blow from a weapon on that position. If the armor points value " "is\n\r"
"divisible by ten, the armor will absord points / 10 damage points. If " "it is\n\r"
"in between multiples of ten, the amount will be semi-random. For " "instance,\n\r"
"say a helmet of 44 AP is hit for 10 damage. There will be a 40% " "chance of\n\r"
"the armor absorbing 5 damage points, and a 60% chance of it absorbing " "4.\n\r",
"This value represents the current amount of armor points can get back to if repaired.\n\rIf not repaired frequently enough, this number will go down, making it\n\rpermanently damaged.\n\r",
"This value represents the size of the person who the armor is designed "
"for.\n\r For a chart of sizes see the HELP SIZE help entry.\n\r"
"Setting sizes for shields is irrelevant, since it is not checked.\n\r",
"Max_points is the armor points this object had when it was new.\n\r",
MariaDB [ARMAG_TEST]> select obj_vnum, sdesc, val0 as current_armor_points from objects where o_type = 9;
+----------+-----------------------------------------------------+----------------------+
| obj_vnum | sdesc | current_armor_points |
+----------+-----------------------------------------------------+----------------------+
| 20 | a small pair of black shoes | 2 |
| 21 | a small green shirt | 3 |
| 23 | a small black coat | 4 |
| 60 | a pair of black boots | 10 |
| 100 | a crown of thorns | 0 |
| 101 | a pair of iron spikes | 0 |
| 178 | a pair of black-scaled gloves | 8 |
| 179 | a black-scaled bracer | 10 |
| 201 | Light blue helm | 25 |
| 202 | a pair of battered shell arm greaves | 30 |
| 203 | a battered pair of shell leg greaves | 35 |
| 204 | A dark blue plated girth. | 20 |
| 205 | a pair of light steel mesh gauntlets | 20 |
| 206 | a pair of dusty red leather boots | 30 |
| 207 | a silver lined dark blue cloak | 5 |
| 208 | Dull black bracelet | 5 |
| 209 | Dull back ring | 2 |
| 210 | Bright white ring | 2 |
| 213 | pale blue steel plate | 42 |
| 777 | a long black flowing cape | 2 |
| 1001 | a braxat-hide cap | 10 |
| 1002 | a chainmail helmet | 23 |
| 1003 | a cuirbouilli helmet | 15 |
| 1004 | a chitin helmet | 26 |
| 1005 | an inix-hide helmet | 27 |
| 1006 | a bone helmet | 17 |
| 1007 | a chainmail coif | 30 |
| 1008 | a woven, giant-hair cap | 5 |
| 1009 | a black leather headband | 6 |
| 1011 | a heavy fiber vest | 4 |
| 1012 | a bone breastplate | 23 |
| 1013 | a courbouilli cuirass | 15 |
| 1014 | a brigandine hauberk | 36 |
| 1015 | a braxat-hide jacket | 19 |
| 1016 | a splintmail vest | 30 |
| 1017 | a chainmail hauberk | 33 |
| 1018 | a bronze hauberk | 25 |
| 1019 | a steel breast plate | 40 |
| 1020 | an obsidian breastplate | 25 |
| 1021 | a chitinous breastplate | 26 |
| 1022 | a studded hauberk | 19 |
| 1024 | a pair of braxat-hide pants | 10 |
| 1025 | a set of cuirbouilli leg guards | 17 |
| 1026 | a pair of studded pants | 20 |
| 1027 | a pair of ringmail pants | 23 |
| 1030 | a set of banded leggings | 27 |
| 1031 | a pair of inix-hide pants | 13 |
| 1032 | a pair of chainmail pants | 29 |
| 1038 | a pair of studded sleeves | 20 |
| 1039 | a pair of ringmail sleeves | 22 |
| 1041 | a pair of bronze splintmail sleeves | 21 |
| 1042 | a pair of laminated sleeves | 25 |
| 1043 | a pair of chainmail sleeves | 28 |
| 1044 | a set of bronze vambraces | 28 |
| 1047 | a set of cuirbouilli sleeves | 17 |
| 1050 | a target shield | 45 |
| 1051 | a large round shield | 50 |
| 1052 | a kite shield | 53 |
| 1053 | a hoplite shield | 60 |
| 1054 | a small buckler | 36 |
| 1055 | a square wooden shield | 27 |
| 1061 | a pair of stiff hide boots | 11 |
| 1062 | a pair of sturdy, leather boots | 17 |
| 1064 | a pair of splintmail boots | 27 |
| 1066 | a pair of platemail boots | 36 |
| 1068 | a pair of bronze boots | 29 |
| 1071 | a pair of hide gloves | 5 |
| 1073 | a pair of chainmail mittens | 33 |
| 1075 | a pair of laminated steel gauntlets | 30 |
| 1077 | a pair of steel plate gauntlets | 40 |
| 1084 | an old robe | 3 |
| 1087 | a wool pullover | 0 |
| 1089 | a pair of moth-eaten hose | 0 |
| 1093 | a pair of striped hose | 0 |
| 1094 | a wool skirt | 5 |
| 1098 | a wool tunic | 0 |
| 1202 | a hard leather cap | 13 |
| 1203 | a padded cap | 5 |
| 1204 | a bone helmet | 20 |
| 1512 | a belt of skulls | 12 |
| 1902 | a kank-shell plate | 20 |
| 1903 | a silt horror-shell plate | 30 |
| 2013 | a cuirbouilli girth | 17 |
| 2066 | A blackened spiked bracer | 20 |
| 2067 | a shirt of blackened bone scalemail | 40 |
| 2068 | a pair of blackened scale pants | 30 |
| 2071 | a dark red, tandu-hide vest | 9 |
| 2072 | a cap of dark-red goudra leather | 13 |
| 2074 | a pair of dark-red goudra-leather pants | 13 |
| 2083 | a black leather cape | 13 |
| 2090 | a black leather belt and scabbard | 5 |
| 2091 | a pair of black, tandu-hide sleeves | 5 |
| 2094 | a black-leather skullcap | 13 |
| 2096 | a leather archery brace | 10 |
| 2135 | a pair of blue leather boots | 13 |
| 2137 | a blue leather jacket | 13 |
| 2138 | a pair of blue leather gloves | 13 |
| 2140 | a feathered blue leather hat | 9 |
| 2141 | a pair of black leather knee-high boots | 13 |
| 2142 | some finely-tailored leather breeches | 13 |
| 2143 | a pair of engraved copper armbands | 22 |
| 2152 | a gem studded steel collar | 40 |
| 2162 | a pair of light leather boots | 5 |
| 2178 | a supple pair of black pants | 5 |
| 2406 | a bronze breastplate | 32 |
| 2407 | a pair of bronze greaves | 32 |
| 2452 | a short leather vest | 20 |
| 2453 | a set of rough leather leg-guards | 13 |
| 2455 | a battered tunic | 0 |
| 2457 | a pair of leather gloves | 5 |
| 2462 | a pair of soft leather leggings | 5 |
| 2464 | a pair of coarse pants | 5 |
| 2465 | a heavy cloak | 25 |
| 2467 | a soft leather hood | 5 |
| 2468 | some stiff leather sleeves | 13 |
| 2503 | a black iron half-mask | 8 |
| 2541 | a long, gray apron | 5 |
| 2546 | a long, dark robe | 4 |
| 2555 | a thin, iron collar | 25 |
| 2557 | a thin leather collar | 15 |
| 2560 | a black-horned helmet | 20 |
| 2561 | a thick iron bracer | 28 |
| 2562 | a leather wrist-guard | 15 |
| 2563 | a black iron mask | 10 |
| 2564 | a dwarven shield | 50 |
| 2600 | V---- Turgon's stuff ----V | 13 |
| 2835 | a spiked duskhorn scalemail hauberk | 22 |
| 2836 | a leather shirt branded with the symbol of Jihae | 4 |
| 2839 | an emblazoned wooden shield | 16 |
| 2840 | an emblazoned bone helm | 15 |
| 2841 | a duskhorn bracer with polished bone markings | 15 |
| 2844 | a pair of black leather thigh-high boots | 10 |
| 2975 | a pair of black leather sleeves | 10 |
| 2979 | a pair of gwoshi-hide sleeves | 8 |
| 3076 | a black sandcloth bandana | 10 |
| 3232 | a mesh and leather vest | 5 |
| 3233 | a pair of grey suede ankle boots | 3 |
| 3248 | glossy snakeskin boots | 5 |
| 3251 | a scarlet plumed helmet | 8 |
| 3252 | tooled leather armbands | 5 |
| 3266 | a snakeskin jacket | 3 |
| 3270 | a knee-length, dusty black coat | 3 |
| 3563 | a pair of knee-high black leather riding boots | 5 |
| 4002 | a kank carpace shield | 48 |
| 4202 | a mekillot-hide vest | 16 |
| 4203 | a hardened leather cuirass | 13 |
| 4218 | a scrab-carapace target shield | 50 |
| 4219 | a pair of dusty mekillot-hide boots | 13 |
| 4220 | a scrab-shell helmet | 23 |
| 4221 | a pair of mekillot-leather pants | 13 |
| 4222 | an erdlu hide bracer | 13 |
| 4709 | a stiff hide vest | 12 |
| 4710 | a pair of pants of woven leather | 5 |
| 4711 | sleeves of woven leather | 5 |
| 4712 | a beaded bone cap | 5 |
| 4802 | a pair of mekillot-carapace greaves | 27 |
| 4806 | a siltflyer-scale shirt | 20 |
| 4807 | a mekillot-shell shield | 57 |
| 6118 | laced leather boots | 10 |
| 6123 | a black-scaled leather surmac | 3 |
| 6124 | a pair of black-scaled leather boots | 5 |
| 6126 | fringed leather gloves | 5 |
| 6182 | a pair of supple leather sleeves | 10 |
| 6328 | a black leather and chitin scale vambrace | 12 |
| 6329 | hard black leather boots | 13 |
| 6334 | a black leather and chitin scale vest | 20 |
| 6335 | a set of black leather and chitin scale sleeves | 20 |
| 6336 | a pair of black leather and chitin leggings | 20 |
| 6337 | a black leather and chitin scale coif | 20 |
| 6338 | a black leather and chitin scale gorget | 20 |
| 6339 | a pair of black leather and chitin scaled gauntlets | 22 |
| 6501 | a chitin ribbed gorget | 20 |
| 6502 | a gurth plated helmet | 23 |
| 6503 | A chitin ribbed longvest | 20 |
| 6504 | a pair of chitin ribbed sleeves | 20 |
| 6505 | a pair of chitin ribbed leggings | 20 |
| 6506 | a gurth plated wristguard | 10 |
| 6662 | an oil-darkened leather vest | 15 |
| 6664 | a black-scaled leather longvest | 15 |
| 6667 | oil-darkened leather leggings | 10 |
| 6669 | a black-scaled leather vambrace | 15 |
| 6670 | an oil-darkened leather bracer | 10 |
| 6671 | a pair of black-scaled leather leggings | 15 |
| 6672 | a black-scaled leather gorget | 15 |
| 6673 | an oil-darkened leather collar | 10 |
| 6674 | a pair of black-scaled leather sleeves | 15 |
| 6675 | a pair of oil-darkened leather sleeves | 10 |
| 6678 | a pair of oil-darkened leather gloves | 10 |
| 6720 | a silk and leather skullcap | 13 |
| 6722 | a wide-brimmed, tandu hide hat | 13 |
| 6872 | a brown-orange, scale-hide gorget | 15 |
| 6873 | a brown-orange, scale-hide surmac | 15 |
| 6874 | brown-orange, scale-hide boots | 15 |
| 6875 | a studded, brown-orange bracer | 15 |
| 6876 | brown-orange, scale-hide sleeves | 15 |
| 6877 | brown-orange, scale-hide leggings | 15 |
| 6878 | a brown-orange, scale-hide vest | 15 |
| 7707 | a red leather headband | 26 |
| 10104 | a set of bronze leggings | 32 |
| 10107 | a leather loincloth | 2 |
| 10111 | some bone leg guards | 18 |
| 13503 | a pair of duskhorn scalemail sleeves | 25 |
| 13504 | a pair of studded pants | 20 |
| 13505 | a pair of thick hide boots | 12 |
| 13507 | a duskhorn bracer | 15 |
| 13508 | a duskhorn collar | 26 |
| 13509 | a polished collar of obsidian | 10 |
| 13606 | a heavy wooden tower shield | 90 |
| 13993 | a crimson jakhal-hide jacket | 20 |
| 13994 | a pair of black, jakhal hide pants | 20 |
| 14001 | a black leather cap | 8 |
| 14005 | an old rusted steel helm | 28 |
| 14103 | a pair of brown knee-high boots | 13 |
| 14104 | a pair of black leather leggings | 5 |
| 14302 | a mantis-shell breastplate | 17 |
| 14303 | a pair of stiff hide leggings | 13 |
| 14305 | a black-dyed bone breastplate | 26 |
| 14306 | a black-dyed bone mask | 13 |
| 14307 | a yellow-dyed hide vest | 13 |
| 14712 | a fanged, inix-shell gorget | 20 |
| 14716 | a horned, demon-carved helm | 26 |
| 14717 | an emblazoned, leather surmac | 21 |
| 14727 | a purple collar marked with a silver bar | 26 |
| 14765 | a purple collar marked with a gold bar | 26 |
| 14770 | a pitch black leather halter-top | 5 |
| 14806 | a black leather wrist-wrap | 12 |
| 14823 | a pair of black knee-high leather boots | 10 |
| 14866 | a maroon-scaled wristguard | 20 |
| 14884 | a leather collar with chitinous strips | 20 |
| 16001 | a leather cap | 0 |
| 16002 | an erdlu scale helmet | 0 |
| 16003 | a dented brass helmet | 0 |
| 17005 | a pair of worn leather boots | 12 |
| 17023 | a pair of black armbands | 10 |
| 17031 | a pair of silk pants | 7 |
| 18610 | a ragged-edged hard-leather bracer | 8 |
| 19012 | a pair of Ilsig leather leggings | 20 |
| 19013 | sleeves of Ilsig leather | 20 |
| 19014 | a steel-woven jacket of Ilsig leather | 25 |
| 19033 | a pair of tough leather boots | 11 |
| 19056 | a pair of worn hide boots | 17 |
| 19057 | a pair of leathern pants | 8 |
| 19063 | a pair of short boots | 13 |
| 19101 | a filthy fur | 10 |
| 19102 | an iron helm | 40 |
| 19103 | a long chainmail shirt | 30 |
| 19106 | an iron-studded shield | 30 |
| 19120 | a large Hook Horror plate | 80 |
| 19121 | some Hook Horror plates | 80 |
| 19122 | some Hook Horror plates | 80 |
| 19123 | a Hook Horror skull | 80 |
| 19142 | a black iron helmet | 50 |
| 19143 | a pair of shiny steel greaves | 45 |
| 19144 | a wide iron-studded belt | 12 |
| 19145 | a rune-crossed cuirass | 50 |
| 19180 | an ornamented tunic | 27 |
| 19251 | a shirt of chainmail | 40 |
| 19354 | a pair of thin leather gloves | 5 |
| 19356 | a frayed black piwafwi | 28 |
| 19402 | a studded leather jacket | 25 |
| 19403 | a pair of studded leather pants | 20 |
| 19501 | a black steel plate bearing the symbol of Chaos | 45 |
| 19502 | black steel plate arm guards | 45 |
| 19503 | black plate steel greaves | 45 |
| 19504 | black steel sollerets | 45 |
| 19505 | wicked looking spiked steel gauntlets | 45 |
| 19506 | a horned great helm | 45 |
| 19507 | a plate steel tasse | 45 |
| 19509 | a steel gorget | 40 |
| 19531 | an ornamented saddle | 25 |
| 20012 | a pair of inix leather boots | 13 |
| 20013 | a set of inix shell greaves | 25 |
| 20014 | a veiled, wide-brimmed surmac | 21 |
| 20019 | a polished bone broadhelm | 20 |
| 20020 | a white moon talisman | 5 |
| 20021 | a red moon talisman | 5 |
| 20022 | a pair of duskhorn scalemail sleeves | 22 |
| 20023 | a duskhorn skullcap | 27 |
| 20025 | a wicker target shield | 15 |
| 20034 | some quilted body armor | 5 |
| 20043 | a duskhorn scalemail hauberk | 22 |
| 20051 | a duskhorn bracer | 15 |
| 20053 | an old dusty robe | 4 |
| 20075 | a set of kank-shell pauldrons | 20 |
| 20076 | a pair of baobab arm-plates | 20 |
| 20098 | the jimpek tower | 100 |
| 20102 | a white splintmail vest | 30 |
| 20103 | a pair of braxat-chitin greaves | 27 |
| 20105 | a pair of tied leather vambraces | 30 |
| 20106 | a pair of leather gloves | 20 |
| 20107 | a jakhal-tooth necklace | 12 |
| 20115 | a black leather helmet | 13 |
| 20143 | a pair of carru-hide pants | 13 |
| 20146 | a pair of goudra-leather gloves | 5 |
| 20149 | a goudra-leather wrist-guard | 13 |
| 20151 | a duskhorn collar | 26 |
| 20152 | a pair of inix shell bracers | 28 |
| 20153 | a tandu hide belt | 18 |
| 20155 | an iron ward-ring | 20 |
| 20169 | a pair of spiked duskhorn gauntlets | 20 |
| 20202 | a rusty piece of chainmail | 40 |
| 20683 | a carru-leather belt | 5 |
| 20702 | a steel breast plate of Ruk | 55 |
| 20703 | a dark brown helmet | 50 |
| 20704 | a dark brown bracer | 50 |
| 20902 | a durable shirt of numut wicker | 17 |
| 20903 | a circular baobab shield | 20 |
| 20904 | a pair of agafari-wood armguards | 10 |
| 20905 | a woven grass bracer | 6 |
| 20907 | a pair of agafari-wood gauntlets | 20 |
| 20914 | a soft, goudra-hide vest | 5 |
| 20917 | a reddish-brown chitinous collar | 26 |
| 20918 | a pair of gurth-shell greaves | 20 |
| 20919 | a tough, tandu-leather cap | 13 |
| 20921 | a gurth-shell round shield | 55 |
| 20926 | a pair of soft, carru-leather pants | 13 |
| 20929 | a smooth, grey-hide jerkin | 5 |
| 20930 | a brown tandu-hide jersey | 13 |
| 20931 | a pair of loose tandu-leather sleeves | 13 |
| 20932 | a pair of goudra-leather boots | 5 |
| 20943 | a reddish-brown yompar-scale vest | 5 |
| 20956 | a chitin-banded leather cuirass | 20 |
| 20963 | an inix-scale hauberk | 20 |
| 20973 | a pair of spike-copped leather sleeves | 20 |
| 20980 | a pair of leather fasciae leggings | 13 |
| 20981 | a pair of hard leather manicae sleeves | 13 |
| 21010 | a kank shell breastplate | 18 |
| 21011 | a pair of stiff hide boots | 11 |
| 21012 | a brown hide loincloth | 13 |
| 21013 | a grey kank shell shield | 45 |
| 21019 | a soft leather loincloth | 5 |
| 21049 | a pair of tough hide gloves | 4 |
| 21051 | a pair of stiff hide boots | 11 |
| 21054 | a tembo skull helm | 22 |
| 21055 | a cuirbouilli cuirass | 16 |
| 21056 | a set of cuirbouilli greaves | 16 |
| 21070 | a shirt made of gwoshi hide | 13 |
| 21071 | a pair of gwoshi-hide pants | 13 |
| 21078 | a pair of soft, carru-hide leggings | 5 |
| 21079 | a soft, carru-hide headwrap | 3 |
| 21098 | a pair of tall, carru-hide moccasins | 9 |
| 21213 | a pair of fine, carru-hide gloves | 4 |
| 21215 | A pair of black-dyed anakore claws | 12 |
| 21252 | a pair of opal-studded, red-dyed sleeves | 10 |
| 21253 | a spined, ivory bracer | 20 |
| 21255 | a pair of carnelian-studded, black boots | 10 |
| 21259 | a dujat-bladed leather bracer | 16 |
| 21309 | a braxat hide collar | 10 |
| 21310 | erdlu hide armbands marked in purple | 7 |
| 21315 | a decorated anakore-skull helm | 17 |
| 21329 | a dark carru leather halter top | 10 |
| 21333 | a beige dujat-chitin helm | 20 |
| 21334 | a durrit-hide jerkin | 13 |
| 21337 | a shirt of bamuk hide | 13 |
| 21996 | a stiff bamuk-hide bracer | 13 |
| 23005 | a pair of tattered burguny pants | 5 |
| 23022 | a chitinous shield | 13 |
| 24002 | an inix hide harness | 13 |
| 24012 | a spiked leather bracer | 10 |
| 24013 | a black crescent shield | 20 |
| 24034 | an inix shell gorget | 26 |
| 24043 | an inix-shell collar | 20 |
| 25202 | a tattered tembo-hide smock | 5 |
| 25203 | a loincloth of grey-spotted yellow hide | 5 |
| 25204 | a tembo-hide vest | 13 |
| 25205 | a pair of tough hide buskins | 5 |
| 25206 | a pair of gajak-carapace greaves | 20 |
| 25207 | a striped hide cuirass | 5 |
| 25208 | a shirt of loosely-woven fiber | 13 |
| 25209 | a pair of close-toed leather sandals | 5 |
| 25210 | a leathery pair of hide trousers | 13 |
| 25211 | a pair of woven grass armlets | 5 |
| 25212 | a reddish-brown hide wristband | 5 |
| 25213 | a ribbed black leather vest | 17 |
| 25214 | a yellowed bone bracer | 20 |
| 25215 | a bone-plated leather bracer | 20 |
| 25216 | a dujat-chitin backplate | 26 |
| 25217 | a pair of fur-trimmed leather boots | 13 |
| 25307 | a pair of leather boots with pykes | 5 |
| 25611 | The Wall of Politics | 60 |
| 25656 | a pair of knee-high, jozhal-hide boots | 5 |
| 25703 | a chalky-gray plate of gaj-shell | 58 |
| 28011 | a tied, carru-hide collar | 27 |
| 28013 | a pair of spiked braxat-hide armguards | 19 |
| 28033 | a thick, leather collar | 15 |
| 28282 | a studded leather tunic | 17 |
| 29000 | A wedding ring | 0 |
| 29704 | a garnet-studded belt | 20 |
| 29706 | a snake-skin wrist guard | 10 |
| 29717 | a spiky helmet | 25 |
| 29718 | a set of spiky arm guards | 25 |
| 29719 | a spiky breastplate | 25 |
| 29720 | a set of spiky leg guards | 25 |
| 29725 | an Afagari shield | 60 |
| 30011 | some stony armbands | 20 |
| 30012 | a set of stony leg plating | 18 |
| 30013 | the stony breastplate | 28 |
| 30020 | the polished shield | 35 |
| 30021 | The steel knuckles | 8 |
| 30032 | a shadow cloak | 10 |
| 30036 | a dusty tunic | 0 |
| 30038 | a wrap of shifting | 10 |
| 30039 | a padded helmet | 15 |
| 30040 | a shell buckler | 15 |
| 30041 | banded shell plate | 28 |
| 30042 | a set of banded shell leggings | 20 |
| 30501 | A leather girdle | 1 |
| 30600 | The midnight cloak | 8 |
| 30602 | A cloud | 5 |
| 30616 | a black belt | 60 |
| 30717 | a skin of lizard scales | 30 |
| 30719 | a pair of hooves | 25 |
| 30751 | a golden lion's mane | 50 |
| 30998 | a breastplate of sunshine | 100 |
| 33054 | obsidian backed gauntlets | 20 |
| 34006 | a visored stone greathelm | 26 |
| 35052 | an obsidian backplate | 0 |
| 35101 | a simple black helm | 10 |
| 35105 | a spiked leather headband | 8 |
| 35106 | pair of spiked leather gloves | 5 |
| 35380 | a supple, blue-dyed leather vest | 10 |
| 35394 | a pair of crimson chitin-plated leggings | 20 |
| 35395 | a pair of crimson chitin-plated armguards | 20 |
| 35397 | a crimson wyvern-embossed breastplate | 25 |
| 35398 | a crimson-winged greathelm | 20 |
| 35399 | a crimson, wyvern-embossed shield | 15 |
| 35915 | polished black boots | 11 |
| 35916 | a pair of black pants | 6 |
| 35917 | a crimson vest | 6 |
| 35918 | a jade-plumed black helmet | 5 |
| 35920 | a pair of jade and black armbands | 3 |
| 35923 | a white leather swordbelt | 3 |
| 36802 | a huge pair of leather leggings | 13 |
| 36803 | a massive leather tunic | 13 |
| 36987 | a glowing steel shield | 55 |
| 36989 | a steel wrist-guard | 40 |
| 36991 | a steel midsection-plate | 40 |
| 36992 | a pair of steel guantlets | 40 |
| 36993 | a pair of steel vambraces | 40 |
| 36994 | a pair of steel boots | 40 |
| 36995 | a pair of steel plate leg-guards | 40 |
| 36996 | a steel collar | 40 |
| 36997 | a massive steel greathelm | 40 |
| 36998 | a steel breastplate | 40 |
| 37008 | a gaj-shell breastplate | 30 |
| 37100 | a leather vest | 14 |
| 37676 | a round chitin shield | 13 |
| 37677 | a kank-shell hoplite shield | 17 |
| 37678 | a pair of carru hide sleeves | 8 |
| 37679 | a pair of stone-tipped boots | 15 |
| 37680 | a chitin greathelm with carru antlers | 20 |
| 37681 | a chitin skullcap | 9 |
| 37702 | a pair of bone pants | 20 |
| 37703 | a pair of snakeskin boots | 9 |
| 37704 | a pair of clawed gloves | 7 |
| 37710 | a carru-hide belt | 10 |
| 37711 | a bone-plated vest | 23 |
| 39051 | a ribcage breastplate | 26 |
| 39052 | a pair of bone greaves | 26 |
| 39053 | a pair of leather arm bands | 13 |
| 39054 | a woodsplint vest | 20 |
| 39055 | a redhide loincloth | 5 |
| 39056 | a long redhide tunic | 5 |
| 39058 | a leather wrist guard | 11 |
| 39059 | a pair of tandu hide boots | 14 |
| 39060 | a set of bark arm-guards | 25 |
| 39064 | a pair of leather shin-wraps | 10 |
| 39066 | a set of woven numut leggings | 14 |
| 39067 | a vest of woven numut | 20 |
| 43001 | The Diadem | 30 |
| 43002 | A Strange Black Robe | 35 |
| 43004 | A Black Ring | 0 |
| 43005 | The Amulet | 30 |
| 43006 | a giant leather tunic | 40 |
| 43009 | a red cape | 25 |
| 43012 | a steel wrist guard | 30 |
| 43016 | fine chain leggings | 35 |
| 43017 | a black belt | 15 |
| 43019 | some filthy rags | 1 |
| 43021 | a black amulet | 25 |
| 43022 | a pair of black pants | 20 |
| 43023 | a black shirt | 30 |
| 43024 | a pair of black sleeves | 20 |
| 43027 | a ragged leather skirt | 4 |
| 43028 | a torn shirt | 1 |
| 43030 | a shirt of rusty chain | 28 |
| 43031 | a chainmail robe | 20 |
| 44041 | a bone-spiked wrist wrap | 8 |
| 44050 | a pair of rough hide leggings | 6 |
| 45207 | supple, dark-leather boots | 10 |
| 45499 | an inix scale buckler | 40 |
| 45501 | a pair of supple hide pants | 8 |
| 45502 | supple hide boots | 8 |
| 45503 | a soft leather vest | 9 |
| 45504 | supple hide sleeves | 8 |
| 45505 | a stiff hide collar | 13 |
| 45506 | a stiff hide wrist guard | 13 |
| 45507 | a soft leather hood | 8 |
| 45520 | An inix hide vest | 18 |
| 45552 | a pair of inix hide pants | 13 |
| 45555 | a pair of braxat hide pants | 13 |
| 45556 | a pair of dark leather pants | 5 |
| 45557 | a soft leather jerkin | 5 |
| 45558 | a pair of leather sleeves | 5 |
| 45720 | inix shell leg-guards | 20 |
| 45721 | Inix shell sleeves | 26 |
| 45722 | an ornately carved breastplate | 26 |
| 45869 | a translucent, watery shield | 70 |
| 48012 | a daraq shield | 40 |
| 49052 | a chitinous shield | 55 |
| 49402 | a pair of patched hide boots | 8 |
| 49404 | a bone helmet | 11 |
| 49405 | a bone breastplate | 15 |
| 49504 | a shiny black amulet | 1 |
| 49510 | a dull red amulet | 5 |
| 49670 | a large anakore skull | 26 |
| 49671 | a black studded-leather wrist guard | 12 |
| 50005 | a black helm | 30 |
| 50011 | a chainmail vest | 33 |
| 50020 | a shirt of hard black leather | 13 |
| 50021 | a pair of black leather pants | 13 |
| 50024 | a silt horror-shell plate | 25 |
| 50026 | a pair of silt horror-shell arm greaves | 22 |
| 50069 | a set of scrab-shell greaves | 24 |
| 50083 | a heavily-padded hood | 0 |
| 50090 | a black-leather belt | 10 |
| 50093 | a battle-dented shield | 70 |
| 50095 | a black steel bracer | 40 |
| 50098 | an ancient sky-blue tunic | 7 |
| 50101 | a black loincloth | 4 |
| 50111 | a set of scrab-shell armguards | 24 |
| 50120 | a leather vest with chitin plates | 22 |
| 50123 | a black steel bracer | 40 |
| 50128 | a shining steel helm | 40 |
| 50142 | an Allanaki's soldier's vest | 20 |
| 50181 | a pair of chitin-banded armored boots | 20 |
| 50182 | a kank-shell gorget | 20 |
| 50183 | a hide-bound bone buckler | 40 |
| 50184 | a leather-banded heather shield | 50 |
| 50185 | a pair of hide-banded bone armguards | 20 |
| 50188 | An Allanaki parade shield | 5 |
| 50340 | a gith-skull helm | 12 |
| 50390 | a scaled, jet-black leather gorget | 3 |
| 50392 | a black-dyed spiked bracer | 3 |
| 50412 | a pair of white-dyed hide boots | 15 |
| 50415 | a pair of white-dyed gloves | 8 |
| 50451 | a polished bronze helm | 30 |
| 50452 | a bronze plate-mail gauntlet | 0 |
| 50612 | a studded hide gorget | 5 |
| 50614 | a studded hide wrist-wrap | 7 |
| 50615 | a sleeveless hide tunic | 4 |
| 50989 | a black sash | 0 |
| 51901 | the unique jade ring | 0 |
| 52905 | a pair of dusty leather hobnail boots | 17 |
| 52906 | a pair of supple ghon-hide sleeves | 14 |
| 52912 | a translucent red silk sherwal | 38 |
| 52913 | a transparent red silk aba | 42 |
| 52916 | a transparent red silk neckscarf | 35 |
| 52918 | a long skull-helm | 28 |
| 52925 | some tight sandcloth arm wrappings | 40 |
| 52926 | some tight sandcloth leg wrappings | 40 |
| 52929 | a tight sandcloth wrist wrapping | 38 |
| 52930 | a white wax seal on a sandcloth wrapping | 39 |
| 54206 | a filthy leather shirt | 8 |
| 54207 | a pair of worn leather pants | 9 |
| 54208 | a pair of dirty fur boots | 5 |
| 56201 | a leather shirt | 5 |
| 56202 | fringed leather boots | 7 |
| 56212 | a belt of gith skulls | 5 |
| 56230 | a patterned leather skirt | 8 |
| 56231 | a fringed leather jacket | 8 |
| 56401 | a crimson-dyed, leather skullcap | 8 |
| 56801 | a jade and ivory collar | 8 |
| 56921 | tight black sleeves | 10 |
| 56923 | silver-toed leather boots | 15 |
| 56924 | a gold-inlaid, silver wristband | 7 |
| 56927 | high, fitted black leather lace-up boots | 10 |
| 56929 | charcoal grey leather sleeves | 8 |
| 56930 | a pair of fine charcoal grey gloves | 5 |
| 56931 | a pair of charcoal grey leather pants | 12 |
| 58004 | a chitin-studded, anakore helm | 20 |
| 58008 | a great, double-horned helm | 20 |
| 58017 | a royal blue, chitin mesh vest | 20 |
| 58018 | a long, leather-strapped bone buckler | 25 |
| 58020 | an emblazoned, studded leather vest | 20 |
| 58021 | a pair of studded, black leather pants | 20 |
| 58022 | a pair of studded, black leather sleeves | 20 |
| 58023 | a long-veiled, black leather surmac | 15 |
| 58024 | a pair of studded, knee-high boots | 20 |
| 58025 | a long, black leather bracer | 10 |
| 58026 | a pair of fine, black leather gloves | 5 |
| 58031 | a pair of black, tembo-hide sleeves | 20 |
| 58032 | a pair of black, tembo-hide leggings | 20 |
| 58033 | a silver-etched, black leather vest | 20 |
| 58034 | a soft, black leather hood | 10 |
| 58035 | a leather surmac, with blue and silver strips | 15 |
| 58036 | a pair of black, soft leather boots | 15 |
| 58037 | a pair of black, tembo-hide gloves | 5 |
| 58038 | a mantis-carved, duskhorn bracer | 15 |
| 58039 | a black-leather, tembo-hide surmac | 15 |
| 58041 | an obsidian-studded, tandu-hide hauberk | 20 |
| 58047 | a soft, black leather hood | 15 |
| 58053 | a pair of desert-tanned, leather sleeves | 15 |
| 58054 | a pair of desert-tanned, leather leggings | 15 |
| 58055 | a pair of desert-tanned, knee-high leather boots | 15 |
| 58056 | a desert-tanned, soft leather hood | 15 |
| 58057 | a desert-tanned, soft leather vest | 15 |
| 58058 | an obsidian and silver, raptor-carved bracer | 20 |
| 58059 | an obsidian-carved, silver-etched gorget | 20 |
| 58060 | a pair of four-knotted, studded leather armbands | 20 |
| 58061 | a pair of three-knotted, studded leather armbands | 20 |
| 58062 | a pair of two-knotted, studded leather armbands | 20 |
| 58063 | a pair of single-knotted, studded leather armbands | 20 |
| 58064 | a blackened, sun-crested leather gorget | 15 |
| 58068 | a pair of purple, jozhal-hide boots | 5 |
| 58069 | a purple, jozhal hide bracer | 5 |
| 58111 | an anakore skull helm with black horns | 26 |
| 58153 | a spider-carved obsidian collar | 20 |
| 58154 | a white, silver-etched, tembo-hide vest | 20 |
| 58155 | a pair of white, tembo-hide sleeves | 20 |
| 58156 | a spider-carved duskhorn bracer | 15 |
| 58157 | a pair of white, tembo-hide leggings | 20 |
| 58158 | a white, silver-stripped, tembo-hide surmac | 15 |
| 58159 | a blue, silver-crested chainmail shirt | 33 |
| 58160 | a pair of silver and blue, raptor-carved arm plates | 26 |
| 58161 | a set of silver and blue, raptor-carved leg plates | 26 |
| 58252 | A pair of black-dyed anakore claws | 15 |
| 58603 | a leather archery brace | 5 |
| 63001 | A glinting ring of dark obsidian | 0 |
| 63003 | a dark tattered robe | 0 |
| 63012 | a dark serpent robe | 10 |
| 63015 | Jaxat-shell shield | 21 |
| 63024 | a Jaxat-bone breast plate | 41 |
| 63034 | a shimmering brown robe | 14 |
| 63035 | a worn bone ring | 3 |
| 63045 | a darksteel breastplate | 45 |
| 63046 | a darksteel shield | 15 |
| 63049 | a dark, worn cape | 8 |
| 63050 | a studded leather jacket | 19 |
| 64003 | a veiled, wide-brimmed surmac | 11 |
| 64008 | a pair of mekillot-hide armguards | 26 |
| 64010 | a pair of carru hide boots | 11 |
| 64013 | a mekillot-hide shield | 44 |
| 64017 | a carru-leather jacket | 13 |
| 64018 | a pair of bone-scale sleeves | 20 |
| 64019 | a spiked bone helm | 26 |
| 64020 | a bone-scaled breechguard | 20 |
| 64021 | a pair of carru-leather sleeves | 12 |
| 64022 | an inix-leather harness | 15 |
| 64023 | an inix shell thorned shield | 30 |
| 64024 | a set of inix shell greaves | 26 |
| 64030 | a tattered cuirbouilli headdress | 17 |
| 64041 | a loincloth | 5 |
| 64048 | a pair of cuirbouilli leg guards | 15 |
| 64050 | a large black loincloth | 5 |
| 64051 | some black leather boots | 13 |
| 64052 | a pair of black leather gloves | 13 |
| 64056 | an anakore skull | 26 |
| 64057 | a set of anakore claws | 12 |
| 64073 | a black onyx mask | 38 |
| 64074 | a black breastplate with silver scrollwork | 40 |
| 64075 | a flowing black cape with silver lining | 5 |
| 64076 | a black steel bracer | 40 |
| 64079 | a black cuirbouilli breastpiece | 17 |
| 64097 | a leather wrist guard | 10 |
| 64132 | a set of Kuraci-issue leathers | 20 |
| 64133 | a pair of studded tembo-hide leggings | 20 |
| 64161 | a pair of rough-cut, black boots | 11 |
| 64162 | a pair of low-cut, brown boots | 10 |
| 64215 | a pair of reinforced sandcloth sleeves | 3 |
| 64216 | a pair of reinforced sandcloth leggings | 3 |
| 64217 | a hide-reinforced sandcloth skirt | 3 |
| 64516 | a dark-veiled surmac | 1 |
| 64526 | a plain sandcloth dress | 2 |
| 64535 | a leather archery brace | 10 |
| 64538 | a spiked duskhorn collar | 20 |
| 64545 | a studded tembo-hide collar | 21 |
| 64546 | a studded tembo-hide bracer | 15 |
| 64552 | a flexible shirt of black-scaled armor | 12 |
| 64553 | a black leather wrist-guard | 5 |
| 64554 | a supple pair of black sleeves | 5 |
| 65452 | laced goudra-hide boots | 10 |
| 65453 | a tooled leather wristband | 5 |
| 66206 | a pair of hide work gloves | 13 |
| 66207 | a pair of broken manacles | 40 |
| 66208 | a single manacle | 40 |
| 66213 | a faded jacket | 13 |
| 66215 | an erdlu-hide jacket | 10 |
| 66216 | a pair of giant-hair pants | 10 |
| 66400 | a black helm | 36 |
| 66401 | a wide, black belt | 13 |
| 66502 | a pair of soft leather boots | 5 |
| 67005 | a leather, silver-threaded circlet | 10 |
| 67008 | a pair of tough, leather buskins | 15 |
| 67009 | a pair of soft, knee-high leather boots | 15 |
| 67013 | embroidered sleeves of soft leather | 15 |
| 69090 | a black studded-leather vest | 20 |
| 69091 | a black leather collar | 13 |
| 69092 | a pair of black, studded-leather pants | 15 |
| 69093 | a black-veiled surmac | 26 |
| 69103 | a bracer made of sandcloth and leather | 15 |
| 70102 | a set of spiny bone plates | 20 |
| 70103 | a thick leather helmet | 13 |
| 70105 | a feathered bronze circlet | 9 |
| 70187 | a pair of fringed gwoshi-hide pants | 13 |
| 70190 | a pair of fingerless leather gloves | 13 |
| 70191 | a veiled, obsidian-beaded surmac | 25 |
| 70193 | a pair of sturdy leather travellers' boots | 13 |
| 70199 | a pair of dusty leather boots | 6 |
| 70200 | an inix-scale shield | 30 |
| 70214 | a tembo-hide jerkin | 30 |
| 70215 | thick bone armlets | 30 |
| 70232 | an engraved bone bracer | 33 |
| 70250 | a pair of thick grey leather gloves | 20 |
| 70328 | a beige chitin plate | 20 |
| 72807 | a pair of woven, red-leather sleeves | 6 |
| 72808 | a pair of woven, red-leather leggings | 6 |
| 72809 | a shirt of woven red-leather | 6 |
| 72810 | a anakore-carved obsidian bracer | 5 |
| 72811 | a anakore-carved obsidian collar | 10 |
| 72829 | a black-dyed spiked bracer | 8 |
| 72949 | a tortoiseshell bracer | 20 |
| 72950 | a tortoiseshell collar | 35 |
| 74010 | a pair of quirri-hide boots | 13 |
| 74011 | a pair of dyed, durrit-hide pants | 13 |
| 74012 | a silver-trimmed, black-dyed cloth shirt | 2 |
| 74013 | a trimmed leather belt | 3 |
| 74017 | a tattered loincloth | 1 |
| 74018 | a new silver-trimmed, black-dyed shirt | 2 |
| 74019 | a pair of quirri-hide boots | 13 |
| 74020 | a pair of dyed, durrit-hide pants | 13 |
| 74021 | a trimmed leather belt | 5 |
| 75009 | a protective miner's helmet | 35 |
+----------+-----------------------------------------------------+----------------------+
733 rows in set (0.01 sec)
MariaDB [ARMAG_TEST]> select o1.obj_vnum, sdesc, special_type, special_command, special_name from objects o1 inner join object_specials o2 where o_type = 9 AND o1.obj_vnum = o2.obj_vnum; +----------+--------------------------------------+--------------+-----------------+------------------+
| obj_vnum | sdesc | special_type | special_command | special_name |
+----------+--------------------------------------+--------------+-----------------+------------------+
| 2096 | a leather archery brace | dmpl | load | smuggle_object |
| 2096 | a leather archery brace | dmpl | unload | smuggle_object |
| 2096 | a leather archery brace | dmpl | look | smuggle_object |
| 2096 | a leather archery brace | dmpl | get | smuggle_object |
| 2096 | a leather archery brace | dmpl | put | smuggle_object |
| 2096 | a leather archery brace | dmpl | draw | smuggle_object |
| 6118 | laced leather boots | dmpl | draw | boot_sheath |
| 6118 | laced leather boots | dmpl | load | boot_sheath |
| 6118 | laced leather boots | dmpl | unload | boot_sheath |
| 6118 | laced leather boots | dmpl | look | boot_sheath |
| 6118 | laced leather boots | dmpl | put | boot_sheath |
| 6118 | laced leather boots | dmpl | get | boot_sheath |
| 21098 | a pair of tall, carru-hide moccasins | dmpl | get | boot_sheath |
| 21098 | a pair of tall, carru-hide moccasins | dmpl | put | boot_sheath |
| 21098 | a pair of tall, carru-hide moccasins | dmpl | unload | boot_sheath |
| 21098 | a pair of tall, carru-hide moccasins | dmpl | load | boot_sheath |
| 21098 | a pair of tall, carru-hide moccasins | dmpl | draw | boot_sheath |
| 21215 | A pair of black-dyed anakore claws | dmpl | pulse | fighting_gloves |
| 21253 | a spined, ivory bracer | dmpl | pulse | fighting_bracer |
| 21259 | a dujat-bladed leather bracer | dmpl | pulse | fighting_bracer |
| 24002 | an inix hide harness | dmpl | wear | mantis_harness |
| 24012 | a spiked leather bracer | dmpl | pulse | fighting_bracer |
| 44041 | a bone-spiked wrist wrap | dmpl | pulse | fighting_bracer |
| 45207 | supple, dark-leather boots | dmpl | get | boot_sheath |
| 45207 | supple, dark-leather boots | dmpl | put | boot_sheath |
| 45207 | supple, dark-leather boots | dmpl | unload | boot_sheath |
| 45207 | supple, dark-leather boots | dmpl | load | boot_sheath |
| 45207 | supple, dark-leather boots | dmpl | draw | boot_sheath |
| 45869 | a translucent, watery shield | dmpl | pulse | vivadu_shield |
| 45869 | a translucent, watery shield | dmpl | es | vivadu_shield |
| 45869 | a translucent, watery shield | dmpl | ep | vivadu_shield |
| 45869 | a translucent, watery shield | dmpl | hold | vivadu_shield |
| 45869 | a translucent, watery shield | dmpl | wield | vivadu_shield |
| 50392 | a black-dyed spiked bracer | dmpl | pulse | fighting_bracer |
| 58252 | A pair of black-dyed anakore claws | dmpl | pulse | fighting_gloves |
| 64057 | a set of anakore claws | dmpl | pulse | fighting_gloves |
| 64526 | a plain sandcloth dress | dmpl | draw | smuggle_object |
| 64526 | a plain sandcloth dress | dmpl | load | smuggle_object |
| 64526 | a plain sandcloth dress | dmpl | unload | smuggle_object |
| 64526 | a plain sandcloth dress | dmpl | put | smuggle_object |
| 64526 | a plain sandcloth dress | dmpl | get | smuggle_object |
| 64526 | a plain sandcloth dress | dmpl | look | smuggle_object |
| 70190 | a pair of fingerless leather gloves | dmpl | pulse | fighting_gloves2 |
| 72829 | a black-dyed spiked bracer | dmpl | pulse | fighting_bracer |
+----------+--------------------------------------+--------------+-----------------+------------------+
44 rows in set (0.00 sec)
That's it. Not digging deep into the armor but I'm guessing the armor points is the only number worth comparing. I'll try to get around to loading the affects and posting them. Free time is sporadic.
|
|
|
|
Post by lyse on Nov 17, 2018 12:30:04 GMT -5
What the hell is the “pulse” command?
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 17, 2018 14:46:52 GMT -5
pulse happens when the game timer "ticks" for each round of action - so it is checking to run all the time. Mobs walking and doing their normal thing would be a good pulse action. grep the code dump for "pulse" and you'll get a good idea how it is used
You can see the "C" specials in the code dump - the horrible specials.c
dmpl is in dmpl.c
Since this world dump they added the "javascript" specials. I wouldn't be surprised if they haven't moved all the "C" specials to javascript.
You can also read about them in that imm help files web pages dump (somewhere on this board).
As an aside, loaded the affects for objects into the db. Should be able to write it up and post it before I head out next week.
|
|
MartenBroadcloak
Displaced Tuluki
It's not a shit post if you spell check (tm)
Posts: 370
|
Post by MartenBroadcloak on Nov 17, 2018 15:36:34 GMT -5
sweeeet.
is val0 just taking right off the total or something? I don't get how that works. If you roll 1d1 with a -1 ...do you just.. miss?
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 17, 2018 16:40:40 GMT -5
sweeeet. is val0 just taking right off the total or something? I don't get how that works. If you roll 1d1 with a -1 ...do you just.. miss? Yeah, from a quick look that is how I take it: dice(val1, val3) + val0. Could be some changes between how the code works and how data was stored. Could be some items are from practice zones (zone 20 is Tuluk and 50 is Allanak for this data) so items like 20xxx and 50xxx are probably valid. Some zones are pure junk.
zones file:
#0
Republican Zone (Azroen)~
999 30 0 1 0 1 31
1 -1 ~
end priv~
#1
Reserved Zone~
1999 60 0 1 0 1 31
1 1 ~
end priv~
#2
Personal Zone~
2999 1 0 1 0 1 31
1 1 ~
end priv~
#3
Player Houses (Ur)~
3999 15 2 1 0 1 31
1 -1 ~
end priv~
#4
Client Villages and Roaming Outposts~
4999 60 2 1 0 1 31
1 0 ~
end priv~
#5
Clan Houses (Nessalin)~
5999 15 3 1 0 1 31
1 0 ~
end priv~
#6
Azia and Surrounds (Brazen and Verra)~
6999 30 2 1 0 1 31
1 -1 ~
end priv~
#7
Jhalavar's Palace and Personal Quest Zone (Jhalavar)~
7999 1 0 1 0 1 31
end priv~
#8
West Tuluk [new] (Ur)~
8999 1 0 1 0 1 31
end priv~
#9
Northeast Tuluk [new] (Ur)~
9999 1 0 1 0 1 31
end priv~
#10
Powermonger's shitty zone(waiting deletion) (Azroen)~
10999 60 3 1 0 1 31
end priv~
#11
Free Zone ()~
11999 36 1 1 0 1 31
end priv~
#12
azroen (Tenebrius)~
12999 60 1 1 0 1 31
end priv~
#13
Player Houses~
13999 15 2 1 0 1 31
1 -1 ~
end priv~
#14
The Elenthel Keep, Yen-el-Tun Chasm, and more. (Halaster)~
14999 60 2 1 0 1 31
1 -1 ~
end priv~
#15
Turgon's Zone?~
15999 30 3 1 0 1 31
end priv~
#16
ruins of steinel (Nessalin)~
16999 35 3 1 0 1 31
end priv~
#17
Ranger Outpost (Stehle)~
17999 30 2 1 0 1 0
1 -1 ~
end priv~
#18
Kere Azia (Stehle)~
18999 30 1 1 0 1 0
1 1 ~
end priv~
#19
Someone tells you, 'Stop lagging the game!' (Kelvik)~
19999 30 0 1 0 1 0
1 -1 ~
end priv~
#20
The City of Tuluk (Ur)~
20999 15 2 1 0 1 31
1 -1 ~
end priv~
#21
Blackwing and Surrounds (Nen)~
21999 20 2 1 0 1 31
1 -1 ~
end priv~
#22
The Ruins of Yeil (Vanyar)~
22999 15 3 1 0 1 0
end priv~
#23
Canyon of Waste (Nessalin)~
23999 60 2 1 0 1 0
1 -1 ~
end priv~
#24
The Valley of Xytrix-Za (Turgon, Halaster, and Sandstorm)~
24999 60 2 1 0 1 31
1 -1 ~
end priv~
#25
The Barrier Range and Surrounds (Dyrinis)~
25999 45 2 1 0 1 31
1 -1 ~
end priv~
#26
Southern Hemisphere Air Space (Azroen)~
26999 1 0 1 0 1 31
1 0 ~
end priv~
#27
Northlands Airway (Azroen)~
27999 15 2 1 0 1 31
1 0 ~
end priv~
#28
Villages of Gol Krathu (Halaster)~
28999 45 2 1 0 1 31
1 -1 ~
end priv~
#29
Client Villages of Tuluk (Ur and Death)~
29999 15 3 1 0 1 31
end priv~
#30
Waiting for deletion (Azroen)~
30999 15 3 1 0 1 0
1 58 ~
end priv~
#31
Southeast Tuluk [new] (Ur)~
31999 30 3 1 0 1 0
end priv~
#32
Playground (Riash)~
32999 59 0 1 0 1 0
1 31 ~
end priv~
#33
items (Helarno)~
33999 60 3 1 0 1 0
1 -1 ~
end priv~
#34
The Elemental Planes (Azroen) and (Dyrinis)~
34999 60 2 1 0 1 31
end priv~
#35
(Vlade)~
35999 60 0 1 0 1 31
1 -1 ~
end priv~
#36
Sea of Silt (Jhalavar)~
36999 30 2 1 0 1 31
1 2047 ~
end priv~
#37
Mal-Krian and Outposts (Azroen)~
37999 30 2 1 0 1 31
1 3 ~
end priv~
#38
Gol Krathu and Scrub Plains (Morgenes) (Becklee)~
38999 45 3 1 0 1 0
1 -1 ~
end priv~
#39
The Grey Forest (Ur)~
39999 24 2 1 0 1 31
1 -1 ~
end priv~
#40
Bremen's Zone (Bremen)~
40999 60 3 1 0 1 0
end priv~
#41
Lluth's Personal Zone (Azroen)~
41999 60 2 1 0 1 0
end priv~
#42
World Revisions (Bremen)~
42999 30 2 1 0 1 31
1 2015 ~
end priv~
#43
Waiting for deletion (Azroen)~
43999 60 2 1 0 1 0
end priv~
#44
Broken Rim Mountains (Nen)~
44999 60 3 1 0 1 0
1 -33 ~
end priv~
#45
The City of Lanthil (Bram)~
45999 30 2 1 0 1 31
1 1 ~
end priv~
#46
The Quest Menagerie (Gleden)~
46999 60 3 1 0 1 0
1 2047 ~
end priv~
#47
Free zone (Azroen)~
47999 60 2 1 0 1 0
end priv~
#48
The Sea of Eternal Dust and Environs (Turgon, Azroen)~
48999 60 2 1 0 1 31
1 0 ~
end priv~
#49
Villages and Oases (Jhalavar)~
49999 30 2 1 0 1 31
1 -1 ~
end priv~
#50
City of Allanak (Nessalin)~
50999 60 2 1 0 1 31
1 1179 ~
end priv~
#51
Awaiting deletion (Azroen)~
51999 20 1 1 0 1 7
end priv~
#52
The Eastern Salt Flats (Yxya)~
52999 60 2 1 0 1 31
1 2015 ~
end priv~
#53
Above Allanak (Bremen)~
53999 60 2 1 0 1 31
1 0 ~
end priv~
#54
Sewers of Allanak (Blaylock)~
54999 60 2 1 0 1 31
1 -1 ~
end priv~
#55
Waiting for deletion (Azroen)~
55999 30 2 1 0 1 0
end priv~
#56
Tribal Plains (Sanvean)~
56999 15 2 1 0 1 0
1 -1 ~
end priv~
#57
Az's Stress Relief (Azroen)~
57999 1 0 1 0 1 0
end priv~
#58
Works (Betaal)~
58999 1 0 1 0 1 0
1 -1 ~
end priv~
#59
Under-Caverns of Allanak. (Blackie)~
59999 60 2 1 0 1 0
1 -1 ~
end priv~
#60
Red Desert South (Azroen)~
60999 15 2 1 0 0 0
1 24 ~
end priv~
#61
Red Desert North (Sanvean)~
61999 15 2 1 0 0 0
1 -1 ~
end priv~
#62
The Sea of Eternal Dust (Gleden)~
62999 60 3 1 0 1 31
1 -1 ~
end priv~
#63
Waiting for deletion (Azroen)~
63999 45 1 1 0 1 0
end priv~
#64
Luir's Outpost and Surrounds (Zakalwe)~
64999 60 2 1 0 1 31
1 3 ~
end priv~
#65
Desert Ruins <on the move> (Nessalin)~
65999 1 3 1 0 0 0
1 -1 ~
end priv~
#66
Obsidian Mines (Nessalin)~
66999 30 3 1 0 10 31
1 -1 ~
end priv~
#67
Eastern Red Desert (Dak)~
67999 1 0 1 0 0 0
1 -1 ~
end priv~
#68
Free Zone (Azroen)~
68999 1 0 1 0 0 0
end priv~
#69
Ruins of Tuluk (Halaster)~
69999 60 2 1 0 0 0
1 0 ~
end priv~
#70
The Tablelands (Kelvik)~
70999 15 2 1 0 1 31
1 0 ~
end priv~
#71
Blue Caverns (Kelvik)~
71999 60 2 1 0 1 31
1 0 ~
end priv~
#72
Thornwalker Mountains & Assorted Things (Savak) (Sanvean)~
72999 1 0 1 0 1 0
1 -1 ~
end priv~
#73
Majheric's Realms (Majheric)~
73999 1 0 1 0 1 0
end priv~
#74
Eastern Plains and Foothills (Laeris)~
74999 1 0 1 0 1 0
1 -1 ~
end priv~
#75
Sythys and such... (Shalla)~
75999 1 3 1 0 0 0
end priv~
#76
zone (Nessalin)~
76999 1 0 1 0 0 0
1 -1 ~
end priv~
#77
Place With Absolutely Nothing (Zagren)~
77999 1 0 1 0 0 0
1 -1 ~
end priv~
#78
Becklee's Workshop (Becklee)~
78999 1 0 0 0 0 0
1 31 ~
end priv~
#79
The Northern Desert (Dyrinis)~
79999 1 0 1 0 0 0
1 -1 ~
end priv~
#80
The Final Zone~
80999 1 0 1 0 0 0
end priv~
$~
|
|
sneazy
Clueless newb
Posts: 115
|
Post by sneazy on Nov 17, 2018 16:44:16 GMT -5
This will be it. Remember this is old world data.
from core_structs.h
/* 'affect' locations */
#define CHAR_APPLY_NONE 0
#define CHAR_APPLY_STR 1
#define CHAR_APPLY_AGL 2
#define CHAR_APPLY_WIS 3
#define CHAR_APPLY_END 5
#define CHAR_APPLY_THIRST 6
#define CHAR_APPLY_HUNGER 7
#define CHAR_APPLY_MANA 12
#define CHAR_APPLY_HIT 13
#define CHAR_APPLY_MOVE 14
#define CHAR_APPLY_OBSIDIAN 15
#define CHAR_APPLY_DAMAGE 16
#define CHAR_APPLY_AC 17
#define CHAR_APPLY_ARMOR 17
#define CHAR_APPLY_OFFENSE 18
#define CHAR_APPLY_DETOX 19 /* for the spice detox - hal */
#define CHAR_APPLY_SAVING_PARA 20
#define CHAR_APPLY_SAVING_ROD 21
#define CHAR_APPLY_SAVING_PETRI 22
#define CHAR_APPLY_SAVING_BREATH 23
#define CHAR_APPLY_SAVING_SPELL 24
#define CHAR_APPLY_SKILL_SNEAK 25
#define CHAR_APPLY_SKILL_HIDE 26
#define CHAR_APPLY_SKILL_LISTEN 27
#define CHAR_APPLY_SKILL_CLIMB 28
#define CHAR_APPLY_DEFENSE 29
#define CHAR_APPLY_CFLAGS 30
#define CHAR_APPLY_STUN 31
#define CHAR_APPLY_PSI 32
#define CHAR_APPLY_MAX 32
#define CHAR_APPLY_SKILL_OFFSET 35
Above are the affects that can be applied when creating an object (ocreation.c). If the number is above 35 it goes searching skills for a match.
This might have been added later since none of the items below have affect_locations > 29. Each item can have 2 affects (it's a constant in there somewhere).
EXAMPLE: CHAR_APPLY_SNEAK is 25 the items that apply a bonus/penalty to sneak are marked ****
MariaDB [ARMAG_TEST]> select o1.obj_vnum, o1.sdesc, o2.affect_location, o2.affect_modifier from objects o1 inner join object_affects o2 where o1.obj_vnum = o2.obj_vnum AND o_type = 5;
+----------+---------------------------------------------+-----------------+-----------------+
| obj_vnum | sdesc | affect_location | affect_modifier |
+----------+---------------------------------------------+-----------------+-----------------+
| 1 | a pile of dung | 18 | 2 |
| 176 | a sweeping, black bastard sword | 18 | 2 |
| 177 | a carved, hardwood quarterstaff | 29 | 7 |
| 700 | <--> Named Demon Components <--> | 18 | 5 |
| 710 | a thin-bladed copper sword | 12 | 5 |
| 1100 | a hardwood dagger | 18 | -5 |
| 1100 | a hardwood dagger | 29 | -3 |
| 1101 | a wooden shortsword | 29 | 2 |
| 1103 | an obsidian longsword | 18 | -1 |
| 1103 | an obsidian longsword | 29 | -1 |
| 1104 | an obsidian dagger | 18 | -5 |
| 1104 | an obsidian dagger | 29 | -5 |
| 1105 | an obsidian knife | 18 | -5 |
| 1105 | an obsidian knife | 29 | -5 |
| 1110 | a worn wooden staff | 29 | 5 |
| 1120 | a katar punch dagger | 29 | -3 |
| 1120 | a katar punch dagger | 18 | -3 |
| 1123 | a long, obsidian-headed spear | 18 | 5 |
| 1123 | a long, obsidian-headed spear | 29 | 5 |
| 1129 | a heavy wooden maul | 18 | -5 |
| 1129 | a heavy wooden maul | 29 | -10 |
| 1132 | a bone-tipped spear | 18 | 2 |
| 1132 | a bone-tipped spear | 29 | 2 |
| 1135 | a bone shortsword | 18 | 2 |
| 1135 | a bone shortsword | 29 | 2 |
| 1138 | a bone broadsword | 29 | 2 |
| 1141 | a stone-headed warhammer | 18 | -2 |
| 1141 | a stone-headed warhammer | 29 | -2 |
| 1144 | a long bone-bladed glaive | 18 | -1 |
| 1144 | a long bone-bladed glaive | 29 | -3 |
| 1147 | a bone longsword | 18 | 2 |
| 1147 | a bone longsword | 29 | 2 |
| 1148 | an obsidian throwing knife | 18 | -5 |
| 1148 | an obsidian throwing knife | 29 | -5 |
| 1150 | a huge stone-headed hammer | 18 | -2 |
| 1150 | a huge stone-headed hammer | 29 | -2 |
| 1153 | a bone bastard sword | 18 | 2 |
| 1153 | a bone bastard sword | 29 | 1 |
| 1156 | a stone-bladed battleaxe | 18 | -2 |
| 1156 | a stone-bladed battleaxe | 29 | -2 |
| 1159 | a slim bone rapier | 18 | 2 |
| 1159 | a slim bone rapier | 29 | 2 |
| 1162 | a long bone-tipped pike | 18 | -1 |
| 1162 | a long bone-tipped pike | 29 | 1 |
| 1166 | a huge bone-bladed battleaxe | 18 | -4 |
| 1166 | a huge bone-bladed battleaxe | 29 | -4 |
| 1168 | a bone dagger | 18 | -3 |
| 1168 | a bone dagger | 29 | -3 |
| 13161 | a gnarled staff | 29 | 8 |
| 13201 | an obsidian axe | 18 | -7 |
| 13201 | an obsidian axe | 29 | -7 |
| 13605 | a nicked wooden shortsword | 18 | 20 |
| 13605 | a nicked wooden shortsword | 29 | 20 |
| 14008 | an old, cracked obsidian longsword | 18 | -2 |
| 14101 | a blackened metal mace | 29 | -1 |
| 14101 | a blackened metal mace | 18 | -1 |
| 14124 | a bone-headed gardening hoe | 18 | -5 |
| 14300 | a twisted obsidian knife | 18 | -2 |
| 14318 | an ankheg-mandible scimitar | 18 | 3 |
| 14318 | an ankheg-mandible scimitar | 29 | 3 |
| 14700 | an immense, two-handed bone greatsword | 18 | -1 |
| 14700 | an immense, two-handed bone greatsword | 29 | -3 |
| 14701 | a slender, wooden rod | 18 | -5 |
| 14701 | a slender, wooden rod | 29 | -3 |
| 14702 | a leather, spike-covered cestus | 29 | 2 |
| 14703 | a one-handed, crescent-bladed axe | 18 | 2 |
| 14703 | a one-handed, crescent-bladed axe | 29 | 2 |
| 14704 | a studded, short-handled mace | 18 | -3 |
| 14704 | a studded, short-handled mace | 29 | -3 |
| 14710 | a slender, bone-bladed sabre | 18 | 2 |
| 14710 | a slender, bone-bladed sabre | 29 | 2 |
| 14711 | an ivory-hilted, runed obsidian halfsword | 18 | -5 |
| 14711 | an ivory-hilted, runed obsidian halfsword | 29 | -5 |
| 14741 | a rune-carved, stone hammer | 18 | -2 |
| 14741 | a rune-carved, stone hammer | 29 | -2 |
| 14753 | a barb-headed, wooden longspear | 18 | 4 |
| 14753 | a barb-headed, wooden longspear | 29 | 6 |
| 14754 | a barbed, obsidian-tipped spear | 18 | 5 |
| 14754 | a barbed, obsidian-tipped spear | 18 | 5 |
| 14759 | a viscious-looking, wooden club | 29 | 2 |
| 14768 | a black cane with an azure opal | 14 | 5 |
| 14768 | a black cane with an azure opal | 29 | 2 |
| 14780 | a black-handled throwing-longknife | 18 | -3 |
| 14780 | a black-handled throwing-longknife | 29 | -3 |
| 14785 | a moon-pommeled, blackened-bone scimitar | 18 | 2 |
| 14785 | a moon-pommeled, blackened-bone scimitar | 29 | 2 |
| 14786 | a sun-pommeled, blackened-bone scimitar | 18 | 2 |
| 14786 | a sun-pommeled, blackened-bone scimitar | 29 | 2 |
| 14787 | a blackened, obsidian-spiked mace | 18 | 1 |
| 14787 | a blackened, obsidian-spiked mace | 29 | 1 |
| 14803 | a silver-encrusted, wooden staff | 29 | 2 |
| 14860 | a basket-hilted, bone rapier | 18 | 2 |
| 14860 | a basket-hilted, bone rapier | 29 | 2 |
| 14861 | a thin-bladed, bone spear | 18 | 7 |
| 14861 | a thin-bladed, bone spear | 29 | 7 |
| 14862 | a bone-handled, serrated longknife | 18 | -3 |
| 14862 | a bone-handled, serrated longknife | 29 | -3 |
| 14897 | a blue rock | 18 | -5 |
| 14897 | a blue rock | 29 | -5 |
| 14898 | a big red hat | 18 | -5 |
| 14919 | a longsword made of pure fire | 18 | 33 |
| 14919 | a longsword made of pure fire | 13 | 50 |
| 15100 | an obsidian headed spear | 18 | -5 |
| 17018 | a dark, twisted dagger | 18 | 4 |
| 17018 | a dark, twisted dagger | 29 | -4 |
| 18601 | a heavy bladed bone jambiya | 18 | -5 |
| 19006 | a cruelly spiked arena bracer | 29 | 5 |
| 19011 | a long steel dagger | 18 | 10 |
| 19034 | a smooth walking stick | 14 | 15 |
| 19104 | a heavy black mace | 18 | 15 |
| 19111 | a mithril mining pick | 18 | 15 |
| 19185 | an ophidian staff | 12 | 30 |
| 19201 | a clawed sceptre | 12 | 40 |
| 19201 | a clawed sceptre | 3 | 2 |
| 19223 | a very light but sharp spear | 29 | 5 |
| 19250 | a double-edged axe | 18 | 10 |
| 19800 | a jagged sword | 18 | 4 |
| 19800 | a jagged sword | 29 | 4 |
| 2014 | a black-hilted, iron halfsword | 18 | 5 |
| 2014 | a black-hilted, iron halfsword | 29 | 5 |
| 2015 | a black quartz ken-tar knife | 18 | -5 |
| 2015 | a black quartz ken-tar knife | 29 | -7 |
| 2018 | an erdlu claw | 18 | -3 |
| 2018 | an erdlu claw | 18 | -3 |
| 2084 | a skull-hilted bone scimitar | 18 | 2 |
| 2084 | a skull-hilted bone scimitar | 29 | 3 |
| 2089 | a red-moon pommeled bone scimitar | 18 | 1 |
| 2101 | an I.O.U. for three million obsidian coins | 18 | 5 |
| 2102 | a jeweled iron dagger | 18 | 4 |
| 2102 | a jeweled iron dagger | 29 | -2 |
| 2112 | a polished, darkwood cane | 14 | 3 |
| 2112 | a polished, darkwood cane | 29 | 2 |
| 2153 | a serrated steel longknife | 29 | -2 |
| 2202 | a thick, twisted staff | 18 | 5 |
| 2202 | a thick, twisted staff | 29 | 12 |
| 2221 | a long, black dirk | 18 | -3 |
| 2221 | a long, black dirk | 29 | -3 |
| 2225 | a serrated broadsword | 18 | 2 |
| 2225 | a serrated broadsword | 29 | 2 |
| 2354 | a long, iron scythe | 18 | 3 |
| 2354 | a long, iron scythe | 29 | 1 |
| 2357 | a steel halfsword | 18 | 5 |
| 2357 | a steel halfsword | 29 | 5 |
| 2403 | a sharp bone falchion | 18 | 2 |
| 2403 | a sharp bone falchion | 29 | -5 |
| 2410 | a cruel obsidian dagger | 18 | -5 |
| 2410 | a cruel obsidian dagger | 29 | -5 |
| 2411 | a weighted quarterstaff | 29 | 8 |
| 2412 | a very long obsidian poleaxe | 18 | 5 |
| 2412 | a very long obsidian poleaxe | 29 | 8 |
| 2454 | a huge stone hammer | 18 | 1 |
| 2454 | a huge stone hammer | 29 | 1 |
| 2456 | a gnarled wooden staff | 12 | 5 |
| 2463 | a heavy stone staff | 18 | -10 |
| 2463 | a heavy stone staff | 17 | 10 |
| 2469 | a bladed staff | 18 | 10 |
| 2469 | a bladed staff | 29 | 11 |
| 2470 | a steel pike | 18 | 6 |
| 2470 | a steel pike | 29 | 8 |
| 2509 | a huge, double-bitted axe | 18 | 1 |
| 2509 | a huge, double-bitted axe | 29 | 1 |
| 2510 | an ebony-hilted steel rapier | 18 | 5 |
| 2510 | an ebony-hilted steel rapier | 29 | 5 |
| 2565 | an iron-shod staff | 29 | 8 |
| 2566 | a dragon-tipped staff | 29 | 4 |
| 2751 | a black steel half-sword | 18 | 5 |
| 2751 | a black steel half-sword | 29 | 5 |
| 2800 | a twisted, blackwood staff | 29 | 4 |
| 2831 | a carru horn knife | 18 | -3 |
| 2831 | a carru horn knife | 29 | -3 |
| 2833 | an ivory-hilted bone saber | 18 | 2 |
| 2833 | an ivory-hilted bone saber | 29 | 2 |
| 2834 | an ivory-hilted bone dirk | 18 | -3 |
| 2834 | an ivory-hilted bone dirk | 29 | -3 |
| 2838 | a blood-red bone longsword | 18 | 2 |
| 2838 | a blood-red bone longsword | 29 | 2 |
| 2847 | a wicked-looking bladed staff | 18 | 2 |
| 2847 | a wicked-looking bladed staff | 29 | 2 |
| 2898 | a short steel spear | 18 | 5 |
| 2898 | a short steel spear | 29 | 5 |
| 20015 | a barbed whip | 29 | -10 |
| 20018 | a long steel-headed spear | 18 | 10 |
| 20018 | a long steel-headed spear | 29 | 10 |
| 20024 | a stone-edged wooden club | 18 | -5 |
| 20026 | a toothed wooden shortsword | 29 | 2 |
| 20027 | a flint dagger | 18 | -5 |
| 20027 | a flint dagger | 29 | -5 |
| 20031 | a jagged bone pickaxe | 18 | 2 |
| 20031 | a jagged bone pickaxe | 29 | 2 |
| 20032 | an obsidian-headed pike | 18 | 1 |
| 20032 | an obsidian-headed pike | 29 | 3 |
| 20033 | a long bone-bladed voulge | 18 | -1 |
| 20033 | a long bone-bladed voulge | 29 | -3 |
| 20037 | a heavy wooden hammer | 29 | 2 |
| 20038 | a broad stone chisel | 18 | -8 |
| 20040 | a small carving knife | 18 | -3 |
| 20040 | a small carving knife | 29 | -3 |
| 20042 | a long-handled steel warhammer | 18 | 5 |
| 20042 | a long-handled steel warhammer | 29 | 5 |
| 20044 | a curved bone knife | 18 | -3 |
| 20044 | a curved bone knife | 29 | -3 |
| 20046 | a worn agafari staff | 29 | 5 |
| 20057 | a staff of office | 27 | 10 |
| 20057 | a staff of office | 12 | 5 |
| 20081 | a throwing knife | 18 | -3 |
| 20081 | a throwing knife | 29 | -3 |
| 20082 | a grizzkt staff | 18 | 7 |
| 20082 | a grizzkt staff | 29 | 8 |
| 20084 | a long-handled stone hammer | 18 | -2 |
| 20084 | a long-handled stone hammer | 29 | -2 |
| 20093 | a huge steel bladed axe | 18 | 1 |
| 20093 | a huge steel bladed axe | 29 | 1 |
| 20100 | a long agafari spear | 18 | 5 |
| 20100 | a long agafari spear | 29 | 7 |
| 20109 | a curved bone scimitar | 18 | 2 |
| 20109 | a curved bone scimitar | 29 | 2 |
| 20110 | a bone-headed tomahawk | 29 | 2 |
| 20110 | a bone-headed tomahawk | 18 | 2 |
| 20111 | A chipped bone club | 18 | 2 |
| 20111 | A chipped bone club | 29 | 2 |
| 20144 | a jagged bone cutlass | 18 | 2 |
| 20144 | a jagged bone cutlass | 29 | 2 |
| 20156 | a black steel longsword | 24 | 10 |
| 20157 | a khopesh dagger | 18 | -3 |
| 20157 | a khopesh dagger | 29 | -3 |
| 20300 | a spiked green crystal | 18 | -5 |
| 20400 | a bone-bladed halberd | 18 | 3 |
| 20400 | a bone-bladed halberd | 29 | 3 |
| 20701 | a huge glass-like sword | 18 | -3 |
| 20701 | a huge glass-like sword | 29 | -5 |
| 20923 | a shik-beak dirk | 18 | -3 |
| 20923 | a shik-beak dirk | 29 | -3 |
| 20934 | a stone-headed wooden lotilus | 18 | 1 |
| 20934 | a stone-headed wooden lotilus | 18 | 1 |
| 20935 | a bone-pommeled agafari cane | 29 | 2 |
| 20939 | a yellowed bone skinning knife | 18 | -3 |
| 20939 | a yellowed bone skinning knife | 29 | -3 |
| 20942 | a studded wooden cudgel | 29 | 2 |
| 20977 | a black bone halfblade | 18 | -3 |
| 20977 | a black bone halfblade | 29 | -3 |
| 21006 | an obsidian headed spear | 18 | 2 |
| 21006 | an obsidian headed spear | 29 | 2 |
| 21007 | a bone spiked sunstar | 18 | -20 |
| 21007 | a bone spiked sunstar | 29 | -20 |
| 21016 | a curved bone knife | 18 | -3 |
| 21016 | a curved bone knife | 18 | -3 |
| 21017 | a curved steel scimitar | 18 | 5 |
| 21017 | a curved steel scimitar | 29 | 3 |
| 21018 | a worn wooden staff | 29 | 7 |
| 21020 | a bone hatchet | 18 | 2 |
| 21020 | a bone hatchet | 29 | 2 |
| 21021 | a carved wooden warclub | 18 | 2 |
| 21021 | a carved wooden warclub | 29 | -2 |
| 21052 | a heavy stone mining pick | 18 | -6 |
| 21086 | a small wooden spear | 18 | -3 |
| 21086 | a small wooden spear | 29 | -3 |
| 21217 | a heavy bone-handled chitin tomahawk | 18 | 2 |
| 21217 | a heavy bone-handled chitin tomahawk | 29 | 2 |
| 21218 | a double-bladed dujat-tooth axe | 18 | 2 |
| 21218 | a double-bladed dujat-tooth axe | 29 | 2 |
| 21260 | a tall, carved staff | 29 | 7 |
| 21314 | a carru-antler spear | 29 | 5 |
| 21314 | a carru-antler spear | 18 | -3 |
| 21319 | a bone-hilted, carru-antler longknife | 18 | 5 |
| 21319 | a bone-hilted, carru-antler longknife | 29 | 5 |
| 21335 | a durrit-claw skinning knife | 18 | -20 |
| 21335 | a durrit-claw skinning knife | 29 | -20 |
| 21336 | a dujat-tooth longknife | 18 | -2 |
| 21336 | a dujat-tooth longknife | 29 | 2 |
| 21338 | a toy wooden tomahawk | 18 | -5 |
| 21338 | a toy wooden tomahawk | 29 | -5 |
| 21344 | a bone, leaf-headed spear | 18 | 7 |
| 21344 | a bone, leaf-headed spear | 29 | 7 |
| 21905 | a double-bladed anakore-claw knife | 18 | -5 |
| 21905 | a double-bladed anakore-claw knife | 29 | -3 |
| 22908 | a short straight blade | 29 | -2 |
| 22908 | a short straight blade | 29 | -5 |
| 23004 | a crude stone knife | 18 | -6 |
| 24001 | a bone-bladed gythka staff | 18 | 2 |
| 24001 | a bone-bladed gythka staff | 29 | 2 |
| 24011 | a notched bone knife | 18 | -3 |
| 24011 | a notched bone knife | 29 | -3 |
| 24035 | a crystal chatkcha | 18 | -5 |
| 24035 | a crystal chatkcha | 29 | -5 |
| 24036 | a long, sharp-bladed gythka | 18 | 2 |
| 24036 | a long, sharp-bladed gythka | 29 | 2 |
| 24037 | a heavy steel-tipped spear | 18 | 10 |
| 24037 | a heavy steel-tipped spear | 29 | 10 |
| 24039 | a small iron chatkcha | 18 | -5 |
| 24039 | a small iron chatkcha | 29 | -5 |
| 24042 | a thick baobab club | 29 | 2 |
| 24100 | a long bone-headed spear | 18 | 7 |
| 24100 | a long bone-headed spear | 29 | 7 |
| 25102 | a brittle, blackened femur | 18 | -3 |
| 25102 | a brittle, blackened femur | 29 | -3 |
| 25103 | an enormous, two-handed obsidian sword | 1 | 1 |
| 25103 | an enormous, two-handed obsidian sword | 17 | 2 |
| 25105 | a curving chitin longknife | 18 | -5 |
| 25105 | a curving chitin longknife | 29 | -5 |
| 25106 | a bone-headed agafari smallspear | 18 | 2 |
| 25106 | a bone-headed agafari smallspear | 29 | 2 |
| 25107 | a serrated bone club | 18 | -3 |
| 25107 | a serrated bone club | 29 | -3 |
| 25108 | a curved obsidian shortblade | 18 | -5 |
| 25108 | a curved obsidian shortblade | 29 | -5 |
| 25112 | an ebony-headed hammer | 2 | -1 |***
| 25112 | an ebony-headed hammer | 29 | -5 |
| 25115 | a bone-bladed leather gloveblade | 18 | -3 |
| 25115 | a bone-bladed leather gloveblade | 29 | -3 |
| 25165 | an one-handed crescent-bladed axe | 18 | 2 |
| 25165 | an one-handed crescent-bladed axe | 29 | 2 |
| 25166 | a curved obsidian skinning knife | 18 | -3 |
| 25166 | a curved obsidian skinning knife | 29 | -3 |
| 25167 | an obsidian-bladed throwing axe | 18 | -5 |
| 25167 | an obsidian-bladed throwing axe | 29 | -5 |
| 25168 | an obsidian-bladed, wooden-poled bardiche | 18 | 5 |
| 25168 | an obsidian-bladed, wooden-poled bardiche | 29 | 5 |
| 25169 | a diamond-hilted silver falchion | 1 | 2 |
| 25169 | a diamond-hilted silver falchion | 3 | 3 |
| 25170 | a ghyrrak-mandible shortsword | 18 | -3 |
| 25170 | a ghyrrak-mandible shortsword | 29 | -3 |
| 25702 | a jagged gaj mandible | 18 | 2 |
| 25702 | a jagged gaj mandible | 29 | 2 |
| 25807 | a sharp ghyrrak spine | 18 | -3 |
| 25807 | a sharp ghyrrak spine | 29 | -5 |
| 28010 | an ornate, curved bone scimitar | 18 | 2 |
| 28010 | an ornate, curved bone scimitar | 29 | 2 |
| 28012 | a bone-bladed impaler | 29 | -5 |
| 28015 | an ornate, bone dagger | 18 | -3 |
| 28015 | an ornate, bone dagger | 29 | -3 |
| 28022 | a silver-inlaid bronze halfsword | 18 | 1 |
| 28022 | a silver-inlaid bronze halfsword | 29 | 1 |
| 28284 | a wooden-shafted lucren hammer | 29 | 5 |
| 28284 | a wooden-shafted lucren hammer | 18 | 5 |
| 28285 | a kank-mandible shortsword | 29 | -3 |
| 28285 | a kank-mandible shortsword | 18 | -3 |
| 29001 | a bone hammer | 13 | -100 |
| 29001 | a bone hammer | 13 | -100 |
| 29003 | a giant's club | 29 | -5 |
| 29722 | a stout wooden staff | 29 | 6 |
| 3015 | a long, ivory hair-needle | 18 | 2 |
| 3015 | a long, ivory hair-needle | 29 | -2 |
| 3077 | a black-hilted bone scimitar | 18 | 2 |
| 3077 | a black-hilted bone scimitar | 29 | 1 |
| 3078 | a curved, black-hilted shortsword | 18 | 1 |
| 30001 | a prismatic sword | 18 | 7 |
| 30002 | a grimey two-bladed sword | 18 | 1 |
| 30008 | a giants leg bone | 2 | -1 |
| 30008 | a giants leg bone | 29 | -4 |
| 30009 | a large stone club | 18 | -20 |
| 30010 | Grom's axe | 1 | 10 |
| 30010 | Grom's axe | 1 | 10 |
| 30018 | an iron spear | 18 | 4 |
| 30018 | an iron spear | 29 | 4 |
| 30019 | An ethereal sword | 18 | 10 |
| 30022 | Lestarno's ancient dagger | 18 | 10 |
| 30022 | Lestarno's ancient dagger | 18 | 10 |
| 30030 | a sharp stone shard | 18 | -5 |
| 30031 | gloves of withering | 18 | 5 |
| 30300 | the serrated scimitar | 2 | 1 |
| 30300 | the serrated scimitar | 29 | 1 |
| 30541 | the battlehammer | 1 | 1 |
| 30541 | the battlehammer | 13 | 1 |
| 30601 | A wisp of mist | 2 | 1 |
| 30700 | Cutlass | 13 | 10 |
| 30700 | Cutlass | 1 | 10 |
| 30999 | A bolt of lightning | 13 | 10 |
| 34005 | a stone stalagmite | 18 | 4 |
| 34005 | a stone stalagmite | 29 | 4 |
| 35102 | a long, straight staff | 29 | 4 |
| 35103 | a straight, bone longsword | 29 | 2 |
| 35103 | a straight, bone longsword | 18 | 2 |
| 35104 | a thick, leather-hilted broadsword | 18 | 3 |
| 35104 | a thick, leather-hilted broadsword | 29 | 3 |
| 36801 | a giant-sized stone spear | 18 | 5 |
| 36801 | a giant-sized stone spear | 29 | 5 |
| 37010 | a sand dagger | 29 | 2 |
| 37010 | a sand dagger | 18 | 2 |
| 37101 | a steel dagger | 29 | 3 |
| 37301 | a black-bladed sword | 18 | 10 |
| 37301 | a black-bladed sword | 29 | -5 |
| 37302 | a black-bladed sword | 29 | 15 |
| 37302 | a black-bladed sword | 18 | -5 |
| 37303 | a black-bladed sword | 1 | 2 |
| 37303 | a black-bladed sword | 5 | 1 |
| 37502 | a bone hand-axe | 18 | 2 |
| 37502 | a bone hand-axe | 29 | 2 |
| 37652 | an obsidian naginata | 18 | -5 |
| 37652 | an obsidian naginata | 29 | 5 |
| 37653 | an obsidian greatsword | 18 | -1 |
| 37653 | an obsidian greatsword | 29 | -5 |
| 37657 | a bleached bone quarterstaff | 29 | 2 |
| 37658 | a spiked bone club | 29 | -5 |
| 37658 | a spiked bone club | 18 | -3 |
| 37659 | a bone greatsword | 18 | 1 |
| 37659 | a bone greatsword | 29 | -3 |
| 37660 | a bone mace | 18 | 3 |
| 37661 | a carru-fang knife | 18 | -3 |
| 37661 | a carru-fang knife | 29 | -3 |
| 37662 | a bone-bladed fauchard | 18 | -8 |
| 37662 | a bone-bladed fauchard | 29 | 5 |
| 39001 | a slender wooden spear | 29 | 2 |
| 39002 | a long flint knife | 18 | -5 |
| 39002 | a long flint knife | 29 | -5 |
| 39003 | a sharp bone knife | 18 | -3 |
| 39003 | a sharp bone knife | 29 | -3 |
| 39004 | a bone shortsword | 18 | 2 |
| 39004 | a bone shortsword | 29 | 2 |
| 39031 | a slender baobab knife | 18 | -5 |
| 39031 | a slender baobab knife | 29 | -3 |
| 39041 | a chitinous arm-blade | 5 | -2 |
| 4111 | a long-handled scythe | 18 | 3 |
| 4111 | a long-handled scythe | 29 | -3 |
| 4115 | a stone sledgehammer | 29 | -10 |
| 4115 | a stone sledgehammer | 2 | -1 |
| 4223 | a bone-hilted obsidian dagger | 29 | -3 |
| 4223 | a bone-hilted obsidian dagger | 18 | -3 |
| 4224 | An erdlu-claw hammer-pick | 18 | -2 |
| 43000 | A Black Rod | 18 | 18 |
| 43007 | a giant bone club | 29 | -20 |
| 43011 | a steel dagger | 18 | 10 |
| 43014 | a black dagger | 2 | 1 |
| 43015 | a forked blade | 29 | 15 |
| 43025 | a glowing knife | 18 | 10 |
| 43029 | a hardwood staff | 12 | 10 |
| 43033 | a giant bone broadsword | 29 | -10 |
| 44004 | a long, tapering thorn | 18 | 1 |
| 44004 | a long, tapering thorn | 29 | -3 |
| 44048 | a ruby-hilted, curved sword | 18 | 2 |
| 44048 | a ruby-hilted, curved sword | 29 | 2 |
| 44049 | a curved bone sword | 18 | 2 |
| 44049 | a curved bone sword | 29 | 2 |
| 45101 | a tassled spear | 18 | 5 |
| 45101 | a tassled spear | 29 | 3 |
| 45102 | a tassled blade | 18 | 9 |
| 45102 | a tassled blade | 18 | 7 |
| 45202 | a light composite staff | 29 | 5 |
| 45489 | a long two-handed staff | 18 | -4 |
| 45489 | a long two-handed staff | 29 | -2 |
| 45490 | a short wooden staff | 29 | 2 |
| 45553 | an ornately carved staff | 29 | 5 |
| 45559 | a long thin stiletto | 18 | -10 |
| 45559 | a long thin stiletto | 29 | -5 |
| 45635 | a bronze-bladed staff | 29 | 10 |
| 45635 | a bronze-bladed staff | 18 | 10 |
| 45723 | a wooden axe | 18 | 3 |
| 45723 | a wooden axe | 29 | 3 |
| 49024 | a slim black staff | 29 | 4 |
| 49401 | a crude inix-jaw hatchet | 18 | 1 |
| 49401 | a crude inix-jaw hatchet | 29 | 1 |
| 49403 | an obsidian longsword | 18 | -2 |
| 49403 | an obsidian longsword | 29 | -2 |
| 49507 | a large, blue-bladed dwarven sword | 18 | -8 |
| 49507 | a large, blue-bladed dwarven sword | 29 | -10 |
| 49678 | a bone longsword | 18 | 2 |
| 49678 | a bone longsword | 29 | 2 |
| 50014 | a giant double-bladed axe | 18 | -4 |
| 50014 | a giant double-bladed axe | 29 | -4 |
| 50025 | a gythka spear | 18 | 5 |
| 50025 | a gythka spear | 29 | 5 |
| 50057 | an anakore claw knife | 18 | -3 |
| 50057 | an anakore claw knife | 29 | -3 |
| 50088 | a black-hilted knife | 18 | -5 |
| 50088 | a black-hilted knife | 29 | -5 |
| 50094 | a massive, spiked club | 18 | -9 |
| 50094 | a massive, spiked club | 29 | -9 |
| 50096 | a long-handled steel hammer | 18 | 3 |
| 50096 | a long-handled steel hammer | 29 | 3 |
| 50151 | a carved bone stiletto | 18 | 8 |
| 50151 | a carved bone stiletto | 29 | -8 |
| 50152 | a forked dagger | 29 | 5 |
| 50291 | a bone kirisigi dagger | 18 | -3 |
| 50291 | a bone kirisigi dagger | 29 | -3 |
| 50314 | a mantis blade | 18 | -7 |
| 50314 | a mantis blade | 29 | -9 |
| 50905 | a skull-hilted obsidian knife | 29 | -7 |
| 50905 | a skull-hilted obsidian knife | 18 | -5 |
| 50922 | a jagged-edged bone longknife | 18 | -5 |
| 50922 | a jagged-edged bone longknife | 29 | -5 |
| 50923 | an obsidian-bladed, bone bardiche | 18 | 5 |
| 50923 | an obsidian-bladed, bone bardiche | 29 | 5 |
| 50925 | a stone-headed bone lotilus | 18 | 2 |
| 50925 | a stone-headed bone lotilus | 29 | 2 |
| 52907 | a stark white blade | 18 | 2 |
| 52907 | a stark white blade | 29 | 2 |
| 54012 | a long hilted poignard | 29 | 2 |
| 54301 | a long, thin spear | 29 | 2 |
| 54302 | a crude knife | 18 | -3 |
| 54302 | a crude knife | 29 | -3 |
| 56203 | a duskhorn dagger | 29 | -5 |
| 56203 | a duskhorn dagger | 18 | -2 |
| 56402 | a carved baobab walking staff | 18 | -3 |
| 56402 | a carved baobab walking staff | 29 | 3 |
| 56517 | a short, heavy legbone | 29 | -2 |
| 56517 | a short, heavy legbone | 18 | -2 |
| 58003 | a wide-bladed, serrated shortsword | 18 | -5 |
| 58003 | a wide-bladed, serrated shortsword | 29 | -5 |
| 58005 | a long, obsidian-tipped staff | 18 | 5 |
| 58005 | a long, obsidian-tipped staff | 29 | 7 |
| 58006 | an ivory-hilted, bone broadsword | 18 | 2 |
| 58006 | an ivory-hilted, bone broadsword | 29 | 2 |
| 58007 | an ivory-hilted, curved bone falchion | 18 | 2 |
| 58007 | an ivory-hilted, curved bone falchion | 29 | 2 |
| 58010 | a curved, mantis-carved obsidian shortblade | 29 | -2 |
| 58011 | a long-handled, serrated broadsword | 18 | 2 |
| 58011 | a long-handled, serrated broadsword | 29 | 2 |
| 58012 | a long, parrying blade | 29 | 6 |
| 58013 | an ornate, khopesh sword | 18 | 2 |
| 58013 | an ornate, khopesh sword | 29 | 2 |
| 58014 | a slender, silver-handled longsword | 18 | 2 |
| 58014 | a slender, silver-handled longsword | 29 | 2 |
| 58016 | a wicked-edged, bone scimitar | 29 | 2 |
| 58019 | a crimson-jeweled, slender bone scimitar | 18 | 2 |
| 58019 | a crimson-jeweled, slender bone scimitar | 29 | 2 |
| 58028 | a silver-crested, slim bone rapier | 18 | 2 |
| 58028 | a silver-crested, slim bone rapier | 29 | 2 |
| 58029 | an ivory-hilted, dark-jeweled scimitar | 18 | 2 |
| 58029 | an ivory-hilted, dark-jeweled scimitar | 29 | 2 |
| 58030 | an ivory-hilted, slender halfsword | 18 | -3 |
| 58030 | an ivory-hilted, slender halfsword | 29 | -3 |
| 58040 | a gem-encrusted, bone ken-tar knife | 29 | -3 |
| 58040 | a gem-encrusted, bone ken-tar knife | 18 | -3 |
| 58042 | an emblazoned, dwarven bone-bladed halberd | 18 | 7 |
| 58042 | an emblazoned, dwarven bone-bladed halberd | 18 | 7 |
| 58043 | a serrated, dujat-tooth longknife | 18 | -3 |
| 58043 | a serrated, dujat-tooth longknife | 29 | -3 |
| 58044 | a long-handled, bone lumber axe | 18 | 2 |
| 58044 | a long-handled, bone lumber axe | 29 | 2 |
| 58045 | an ivory-hilted, jaded bone broadsword | 18 | 2 |
| 58045 | an ivory-hilted, jaded bone broadsword | 29 | 2 |
| 58046 | a narrow-hilted, jaded khopesh blade | 18 | 2 |
| 58046 | a narrow-hilted, jaded khopesh blade | 29 | 2 |
| 58048 | a bronze-handled, wicked-bladed staff | 18 | 7 |
| 58048 | a bronze-handled, wicked-bladed staff | 29 | 7 |
| 58049 | a mantis-carved, bone bastard sword | 18 | 2 |
| 58049 | a mantis-carved, bone bastard sword | 29 | 2 |
| 58050 | a silver-etched, blackened longknife | 18 | -3 |
| 58050 | a silver-etched, blackened longknife | 29 | -3 |
| 58052 | a wyvern-hilted, carved bastard sword | 18 | 2 |
| 58052 | a wyvern-hilted, carved bastard sword | 29 | 2 |
| 58066 | a blackened, steel-headed stabbing spear | 18 | 5 |
| 58066 | a blackened, steel-headed stabbing spear | 29 | 5 |
| 58094 | an engraved, jet-black scimitar | 18 | 2 |
| 58130 | a thin, bone-bladed longknife | 29 | -3 |
| 58130 | a thin, bone-bladed longknife | 18 | -3 |
| 58151 | a bone two-handed sword | 18 | 2 |
| 58151 | a bone two-handed sword | 29 | 2 |
| 58152 | a silver-set, bone rapier | 29 | 2 |
| 58152 | a silver-set, bone rapier | 18 | 2 |
| 58162 | an antler-hilted, dark quartz dagger | 18 | -4 |
| 58162 | an antler-hilted, dark quartz dagger | 29 | -4 |
| 58163 | a long handled, stone warhammer | 29 | -2 |
| 58163 | a long handled, stone warhammer | 18 | -2 |
| 58164 | a blackened bone sai | 29 | -1 |
| 58164 | a blackened bone sai | 18 | -3 |
| 58165 | a glossy black bone dragon's pick | 18 | -2 |
| 58165 | a glossy black bone dragon's pick | 29 | -3 |
| 6002 | a bone tulwar | 18 | -2 |
| 6002 | a bone tulwar | 29 | -2 |
| 6003 | a thin bone stiletto | 18 | -3 |
| 6003 | a thin bone stiletto | 29 | -3 |
| 6021 | a large wooden spoon | 29 | 5 |
| 6034 | a smooth bone club | 29 | 2 |
| 6070 | a jagged bone poniard | 18 | 1 |
| 6077 | a bone kukri knife | 18 | 2 |
| 6077 | a bone kukri knife | 29 | 2 |
| 6327 | an immense, dark wooden club | 18 | -4 |
| 6327 | an immense, dark wooden club | 29 | -2 |
| 6330 | a slim, bone backblade | 18 | -3 |
| 6330 | a slim, bone backblade | 29 | -3 |
| 6331 | a slim, bone longknife | 18 | -3 |
| 6331 | a slim, bone longknife | 29 | -3 |
| 6354 | a wide-bladed obsidian jambiya | 18 | -5 |
| 6354 | a wide-bladed obsidian jambiya | 29 | -5 |
| 63000 | a blackblade | 18 | 2 |
| 63007 | a massive spiked cudgel | 2 | -1 |
| 63007 | a massive spiked cudgel | 29 | -10 |
| 63011 | a thin, long blade | 29 | 3 |
| 63011 | a thin, long blade | 1 | -1 |
| 63016 | a smith's hammer | 29 | -4 |
| 63017 | a crude scourge | 18 | 3 |
| 63027 | a steel elfblade | 18 | 5 |
| 63027 | a steel elfblade | 12 | -5 |
| 63032 | a very fine steel dirk | 18 | 5 |
| 63033 | a long ashwood staff | 1 | -2 |
| 63033 | a long ashwood staff | 12 | 10 |
| 63040 | a fine steel halberd | 18 | -7 |
| 63044 | a dark staff of Ka'arax | 18 | 5 |
| 63044 | a dark staff of Ka'arax | 3 | -3 |
| 63048 | a wicked stiletto | 18 | 2 |
| 63053 | a crude iron flail | 2 | -2 |
| 63800 | a Broadsword named, 'Sunblight' | 13 | 15 |
| 63800 | a Broadsword named, 'Sunblight' | 18 | 5 |
| 64001 | a jagged bone spear | 18 | 2 |
| 64001 | a jagged bone spear | 29 | 2 |
| 64004 | a spiked wooden club | 18 | 2 |
| 64007 | a heavy bone greatsword | 18 | 1 |
| 64007 | a heavy bone greatsword | 29 | -3 |
| 64014 | a hardwood short-staff | 29 | 4 |
| 64015 | a bone-handled obsidian longknife | 18 | -3 |
| 64015 | a bone-handled obsidian longknife | 29 | -3 |
| 64016 | a thin hardwood javelin | 29 | 2 |
| 64031 | an erdlu claw knife | 18 | -3 |
| 64031 | an erdlu claw knife | 29 | -3 |
| 64042 | a twin-bladed bone axe | 18 | 2 |
| 64042 | a twin-bladed bone axe | 29 | 2 |
| 64049 | a huge bone club | 18 | -2 |
| 64049 | a huge bone club | 29 | -2 |
| 64087 | a wicked looking dagger | 18 | -5 |
| 64087 | a wicked looking dagger | 29 | -3 |
| 64108 | a long elvish dagger | 18 | -3 |
| 64108 | a long elvish dagger | 29 | -5 |
| 64109 | a chitin skinning knife | 18 | -3 |
| 64109 | a chitin skinning knife | 29 | -3 |
| 64144 | a long-bladed dirk | 18 | -3 |
| 64144 | a long-bladed dirk | 29 | -3 |
| 64145 | a tapered throwing knife | 18 | -3 |
| 64145 | a tapered throwing knife | 29 | -3 |
| 64154 | a black-hilted bone longknife | 18 | -2 |
| 64154 | a black-hilted bone longknife | 29 | -2 |
| 64555 | a thin bone dagger | 18 | 3 |
| 64555 | a thin bone dagger | 29 | -3 |
| 64575 | a leather cap with bone hook | 28 | 5 |
| 65500 | an oddly greenish sword | 1 | 2 |
| 65500 | an oddly greenish sword | 3 | -2 |
| 66014 | an obsidian spear | 18 | 5 |
| 66014 | an obsidian spear | 29 | 5 |
| 66101 | a crude wooden club | 29 | 2 |
| 66102 | a stone club | 18 | -6 |
| 66102 | a stone club | 29 | -6 |
| 66104 | a wooden spear | 18 | 5 |
| 66104 | a wooden spear | 29 | 7 |
| 66105 | a narrow bone dagger | 18 | -3 |
| 66105 | a narrow bone dagger | 29 | -3 |
| 67016 | a blackened dagger of mekillot bone | 18 | 2 |
| 67016 | a blackened dagger of mekillot bone | 29 | 2 |
| 67100 | a wicked khopesh longknife | 18 | 2 |
| 67100 | a wicked khopesh longknife | 29 | 2 |
| 67104 | a small, sharp piece of flint | 18 | -3 |
| 67104 | a small, sharp piece of flint | 29 | -3 |
| 70104 | a white bone spear | 29 | 2 |
| 70104 | a white bone spear | 18 | 2 |
| 70195 | a painted obsidian halfsword | 29 | 5 |
| 70198 | a sharp bone jambiya | 18 | 1 |
| 70198 | a sharp bone jambiya | 29 | -1 |
| 70208 | a curved sword of bone | 18 | 2 |
| 70208 | a curved sword of bone | 29 | 2 |
| 70210 | a long bone blade | 18 | -3 |
| 70210 | a long bone blade | 18 | -4 |
| 70212 | a toothed sunback-jaw shortsword | 18 | 2 |
| 70212 | a toothed sunback-jaw shortsword | 29 | 2 |
| 70213 | a sharp bone yataghan | 18 | 2 |
| 70216 | a wide bone shortsword | 18 | 1 |
| 70216 | a wide bone shortsword | 29 | 1 |
| 70218 | a heavy bone scimitar | 18 | -2 |
| 70218 | a heavy bone scimitar | 29 | -2 |
| 70219 | a gigantic wooden club | 18 | -8 |
| 70219 | a gigantic wooden club | 29 | -6 |
| 70226 | a bone-handled steel kris | 18 | 2 |
| 70226 | a bone-handled steel kris | 29 | 2 |
| 70227 | a steel punch dagger | 18 | 5 |
| 70227 | a steel punch dagger | 29 | 3 |
| 70228 | a black-bladed steel punch dagger | 18 | 5 |
| 70228 | a black-bladed steel punch dagger | 29 | 3 |
| 70229 | a bone-handed steel punch dagger | 18 | 5 |
| 70229 | a bone-handed steel punch dagger | 29 | 3 |
| 70329 | a tapering yellow fang | 18 | -3 |
| 70329 | a tapering yellow fang | 29 | -3 |
| 72800 | a blackened, mekillot-bone bastard sword | 18 | 2 |
| 72801 | a blackened, jagged-edged scimitar | 18 | 1 |
| 72801 | a blackened, jagged-edged scimitar | 29 | -1 |
| 72802 | a silver-set, bone-bladed dirk | 18 | 1 |
| 72802 | a silver-set, bone-bladed dirk | 29 | -3 |
| 72805 | a twin-bladed obsidian axe | 18 | -4 |
| 72805 | a twin-bladed obsidian axe | 29 | -4 |
| 72806 | a slender, serpent hilted dagger | 18 | 1 |
| 72806 | a slender, serpent hilted dagger | 29 | -1 |
| 72944 | a fire-blackened anakore-claw knife | 18 | 2 |
| 72944 | a fire-blackened anakore-claw knife | 29 | -2 |
| 75003 | a mining pick | 18 | 3 |
| 75003 | a mining pick | 29 | -3 |
+----------+---------------------------------------------+-----------------+-----------------+
681 rows in set (0.03 sec)
MariaDB [ARMAG_TEST]> MariaDB [ARMAG_TEST]> select o1.obj_vnum, o1.sdesc, o2.affect_location, o2.affect_modifier from objects o1 inner joiere o1.obj_vnum = o2.obj_vnum AND o_type = 9;
+----------+--------------------------------------------------+-----------------+-----------------+
| obj_vnum | sdesc | affect_location | affect_modifier |
+----------+--------------------------------------------------+-----------------+-----------------+
| 178 | a pair of black-scaled gloves | 28 | 5 |
| 207 | a silver lined dark blue cloak | 24 | 5 |
| 208 | Dull black bracelet | 2 | 1 |
| 209 | Dull back ring | 14 | 10 |
| 210 | Bright white ring | 13 | 5 |
| 1030 | a set of banded leggings | 14 | -2 |
| 1032 | a pair of chainmail pants | 14 | -2 |
| 1043 | a pair of chainmail sleeves | 14 | -1 |
| 1061 | a pair of stiff hide boots | 14 | 12 |
| 1062 | a pair of sturdy, leather boots | 14 | 10 |
| 1066 | a pair of platemail boots | 14 | -2 |
| 1202 | a hard leather cap | 14 | 3 |
| 13993 | a crimson jakhal-hide jacket | 14 | 5 |
| 14717 | an emblazoned, leather surmac | 14 | 3 |
| 14823 | a pair of black knee-high leather boots | 14 | 5 |
| 17005 | a pair of worn leather boots | 14 | 8 |
| 17005 | a pair of worn leather boots | 25 | 2 |****
| 17031 | a pair of silk pants | 25 | 3 |****
| 17031 | a pair of silk pants | 26 | 2 |
| 19012 | a pair of Ilsig leather leggings | 29 | 2 |
| 19013 | sleeves of Ilsig leather | 29 | 2 |
| 19014 | a steel-woven jacket of Ilsig leather | 29 | 3 |
| 19033 | a pair of tough leather boots | 14 | 12 |
| 19063 | a pair of short boots | 14 | 12 |
| 19102 | an iron helm | 1 | 2 |
| 19106 | an iron-studded shield | 29 | 10 |
| 19120 | a large Hook Horror plate | 2 | -1 |
| 19121 | some Hook Horror plates | 2 | -1 |
| 19122 | some Hook Horror plates | 2 | -1 |
| 19123 | a Hook Horror skull | 3 | -3 |
| 19143 | a pair of shiny steel greaves | 29 | 2 |
| 19144 | a wide iron-studded belt | 5 | 1 |
| 19144 | a wide iron-studded belt | 1 | 1 |
| 19145 | a rune-crossed cuirass | 5 | 2 |
| 19180 | an ornamented tunic | 29 | 10 |
| 19180 | an ornamented tunic | 12 | 20 |
| 19356 | a frayed black piwafwi | 17 | 7 |
| 19356 | a frayed black piwafwi | 29 | 11 |
| 19531 | an ornamented saddle | 14 | 40 |
| 2071 | a dark red, tandu-hide vest | 14 | 2 |
| 2072 | a cap of dark-red goudra leather | 14 | 2 |
| 2083 | a black leather cape | 26 | 10 |
| 2162 | a pair of light leather boots | 14 | 5 |
| 2178 | a supple pair of black pants | 26 | 4 |
| 2178 | a supple pair of black pants | 25 | 5 |****
| 2455 | a battered tunic | 13 | -5 |
| 2457 | a pair of leather gloves | 26 | 1 |
| 2462 | a pair of soft leather leggings | 26 | 3 |
| 2467 | a soft leather hood | 26 | 5 |
| 2467 | a soft leather hood | 25 | 3 |****
| 2468 | some stiff leather sleeves | 26 | 6 |
| 2561 | a thick iron bracer | 14 | -1 |
| 2975 | a pair of black leather sleeves | 26 | 3 |
| 20012 | a pair of inix leather boots | 14 | 8 |
| 20014 | a veiled, wide-brimmed surmac | 14 | 5 |
| 20020 | a white moon talisman | 29 | 3 |
| 20021 | a red moon talisman | 18 | 3 |
| 20034 | some quilted body armor | 25 | 10 |****
| 20155 | an iron ward-ring | 17 | 10 |
| 20155 | an iron ward-ring | 12 | 30 |
| 20907 | a pair of agafari-wood gauntlets | 14 | -2 |
| 20914 | a soft, goudra-hide vest | 14 | 2 |
| 21011 | a pair of stiff hide boots | 14 | 15 |
| 21051 | a pair of stiff hide boots | 14 | 10 |
| 21078 | a pair of soft, carru-hide leggings | 26 | 3 |
| 21098 | a pair of tall, carru-hide moccasins | 14 | 15 |
| 21098 | a pair of tall, carru-hide moccasins | 25 | 5 |****
| 21252 | a pair of opal-studded, red-dyed sleeves | 26 | -3 |
| 25205 | a pair of tough hide buskins | 25 | 2 |****
| 25209 | a pair of close-toed leather sandals | 28 | 1 |
| 25656 | a pair of knee-high, jozhal-hide boots | 25 | 7 |****
| 25656 | a pair of knee-high, jozhal-hide boots | 26 | 7 |
| 25703 | a chalky-gray plate of gaj-shell | 2 | -1 |
| 25703 | a chalky-gray plate of gaj-shell | 29 | 1 |
| 28011 | a tied, carru-hide collar | 14 | -5 |
| 28013 | a pair of spiked braxat-hide armguards | 26 | -10 |
| 28013 | a pair of spiked braxat-hide armguards | 2 | -1 |
| 29717 | a spiky helmet | 29 | 3 |
| 29718 | a set of spiky arm guards | 29 | 6 |
| 29719 | a spiky breastplate | 29 | 8 |
| 29720 | a set of spiky leg guards | 29 | 6 |
| 3232 | a mesh and leather vest | 14 | 4 |
| 3233 | a pair of grey suede ankle boots | 25 | 1 |****
| 3233 | a pair of grey suede ankle boots | 28 | 2 |
| 3248 | glossy snakeskin boots | 14 | 3 |
| 3270 | a knee-length, dusty black coat | 14 | 3 |
| 30011 | some stony armbands | 18 | 3 |
| 30011 | some stony armbands | 29 | 4 |
| 30012 | a set of stony leg plating | 5 | 1 |
| 30013 | the stony breastplate | 5 | 1 |
| 30020 | the polished shield | 5 | 1 |
| 30032 | a shadow cloak | 29 | 10 |
| 30032 | a shadow cloak | 2 | 3 |
| 30038 | a wrap of shifting | 1 | 1 |
| 30039 | a padded helmet | 29 | 1 |
| 30040 | a shell buckler | 29 | 6 |
| 30041 | banded shell plate | 14 | -15 |
| 30041 | banded shell plate | 13 | 7 |
| 30042 | a set of banded shell leggings | 14 | -10 |
| 30042 | a set of banded shell leggings | 13 | 5 |
| 30600 | The midnight cloak | 29 | 15 |
| 30602 | A cloud | 29 | 10 |
| 30616 | a black belt | 29 | 20 |
| 30616 | a black belt | 18 | 20 |
| 30719 | a pair of hooves | 12 | 10 |
| 30719 | a pair of hooves | 14 | 50 |
| 37679 | a pair of stone-tipped boots | 18 | 2 |
| 37704 | a pair of clawed gloves | 28 | 5 |
| 37704 | a pair of clawed gloves | 18 | 3 |
| 39059 | a pair of tandu hide boots | 14 | 15 |
| 39064 | a pair of leather shin-wraps | 26 | 2 |
| 39066 | a set of woven numut leggings | 26 | 3 |
| 39067 | a vest of woven numut | 26 | 5 |
| 4710 | a pair of pants of woven leather | 14 | 5 |
| 4711 | sleeves of woven leather | 14 | 5 |
| 4712 | a beaded bone cap | 14 | 2 |
| 4802 | a pair of mekillot-carapace greaves | 2 | -1 |
| 43001 | The Diadem | 17 | 10 |
| 43001 | The Diadem | 12 | 10 |
| 43002 | A Strange Black Robe | 12 | 20 |
| 43002 | A Strange Black Robe | 14 | -20 |
| 43004 | A Black Ring | 12 | 5 |
| 43004 | A Black Ring | 17 | 10 |
| 43005 | The Amulet | 17 | 5 |
| 43005 | The Amulet | 29 | 10 |
| 43016 | fine chain leggings | 2 | 1 |
| 43016 | fine chain leggings | 14 | 5 |
| 43021 | a black amulet | 12 | 10 |
| 43030 | a shirt of rusty chain | 14 | -10 |
| 43031 | a chainmail robe | 17 | 20 |
| 43031 | a chainmail robe | 18 | -8 |
| 45207 | supple, dark-leather boots | 14 | 10 |
| 45502 | supple hide boots | 14 | 3 |
| 45506 | a stiff hide wrist guard | 29 | 1 |
| 45507 | a soft leather hood | 14 | 5 |
| 45556 | a pair of dark leather pants | 26 | 1 |
| 45557 | a soft leather jerkin | 26 | 2 |
| 45558 | a pair of leather sleeves | 26 | 1 |
| 45869 | a translucent, watery shield | 17 | 65 |
| 50020 | a shirt of hard black leather | 26 | 3 |
| 50021 | a pair of black leather pants | 26 | 2 |
| 50083 | a heavily-padded hood | 27 | -60 |
| 50123 | a black steel bracer | 29 | 1 |
| 50142 | an Allanaki's soldier's vest | 25 | 5 |****
| 50181 | a pair of chitin-banded armored boots | 14 | 5 |
| 50390 | a scaled, jet-black leather gorget | 25 | 5 |****
| 50390 | a scaled, jet-black leather gorget | 26 | 5 |
| 50392 | a black-dyed spiked bracer | 25 | 5 |****
| 50392 | a black-dyed spiked bracer | 26 | 5 |
| 54208 | a pair of dirty fur boots | 14 | 4 |
| 56202 | fringed leather boots | 14 | 5 |
| 56231 | a fringed leather jacket | 14 | 8 |
| 56923 | silver-toed leather boots | 14 | 7 |
| 56924 | a gold-inlaid, silver wristband | 29 | 1 |
| 56927 | high, fitted black leather lace-up boots | 14 | 4 |
| 56929 | charcoal grey leather sleeves | 14 | 3 |
| 56931 | a pair of charcoal grey leather pants | 14 | 3 |
| 58035 | a leather surmac, with blue and silver strips | 14 | 5 |
| 58055 | a pair of desert-tanned, knee-high leather boots | 14 | 5 |
| 58603 | a leather archery brace | 29 | 1 |
| 6123 | a black-scaled leather surmac | 14 | 6 |
| 6123 | a black-scaled leather surmac | 25 | 4 |****
| 6329 | hard black leather boots | 14 | 12 |
| 63001 | A glinting ring of dark obsidian | 18 | 3 |
| 63001 | A glinting ring of dark obsidian | 2 | -1 |
| 63003 | a dark tattered robe | 17 | 5 |
| 63024 | a Jaxat-bone breast plate | 2 | -2 |
| 63034 | a shimmering brown robe | 12 | 10 |
| 63034 | a shimmering brown robe | 5 | -2 |
| 63035 | a worn bone ring | 5 | -1 |
| 63035 | a worn bone ring | 12 | 6 |
| 63046 | a darksteel shield | 5 | 1 |
| 63046 | a darksteel shield | 18 | -5 |
| 63049 | a dark, worn cape | 25 | 5 |****
| 64003 | a veiled, wide-brimmed surmac | 14 | 5 |
| 64010 | a pair of carru hide boots | 14 | 15 |
| 64013 | a mekillot-hide shield | 29 | 5 |
| 64022 | an inix-leather harness | 18 | 5 |
| 64022 | an inix-leather harness | 29 | 5 |
| 64023 | an inix shell thorned shield | 18 | 5 |
| 64023 | an inix shell thorned shield | 29 | 3 |
| 64030 | a tattered cuirbouilli headdress | 14 | 5 |
| 64057 | a set of anakore claws | 28 | 5 |
| 64161 | a pair of rough-cut, black boots | 14 | 10 |
| 64162 | a pair of low-cut, brown boots | 14 | 10 |
| 64215 | a pair of reinforced sandcloth sleeves | 14 | 5 |
| 64216 | a pair of reinforced sandcloth leggings | 14 | 5 |
| 64216 | a pair of reinforced sandcloth leggings | 25 | 2 |****
| 64217 | a hide-reinforced sandcloth skirt | 14 | 5 |
| 64217 | a hide-reinforced sandcloth skirt | 25 | 2 |****
| 64516 | a dark-veiled surmac | 14 | 4 |
| 64552 | a flexible shirt of black-scaled armor | 25 | 1 |****
| 64552 | a flexible shirt of black-scaled armor | 26 | 1 |
| 65452 | laced goudra-hide boots | 14 | 7 |
| 67008 | a pair of tough, leather buskins | 14 | 5 |
| 67009 | a pair of soft, knee-high leather boots | 14 | 5 |
| 70191 | a veiled, obsidian-beaded surmac | 14 | 5 |
| 70193 | a pair of sturdy leather travellers' boots | 14 | 15 |
| 70199 | a pair of dusty leather boots | 14 | 15 |
+----------+--------------------------------------------------+-----------------+-----------------+
199 rows in set (0.00 sec)
|
|
kannot
Clueless newb
Posts: 126
|
Post by kannot on Nov 18, 2018 10:16:11 GMT -5
Am I to understand that there is no differential affect of WILD/CITY hide or sneak-enhancing equipment? Or is it just because the data is old?
|
|
