Well-Actually War Trall Ishad Nha Posted February 25, 2008 Share Posted February 25, 2008 This method can be used to draw up lists of anything in A5, be it items, creatures, floor, terrain or whatever. It also works in any game that uses scripts to list items&. Open the file in Word or some such word processor program. Delete all tab stops Use Replace All to put tab stops in front of “begindefineitem” and “it_name”. (For example, replace “begindefineitem” with “^tbegindefineitem”, for in Replace All “^t” means a tab stop.) Copy it into Excel, all “begindefineitem” and “it_name” entries will be in a column by themselves, say column C, all other entries will be in column B. Put numbers 1 through 3,568 in column A. Sort columns A,B and C, with the contents of column C as the criteria. Delete the contents of any line where column C is blank. Sort columns A,B and C, with the contents of column A as the criteria. This leaves everything back in its proper order. Copy the contents of column C back into Word. (A few items don’t have an “it_name…” entry, because they have the same name as the item above, this will need to be corrected.) Use Replace All to turn all paragraph marks into tab stops. Now we want on each line the item number and its name, a good way to do this is to use Replace All to put a paragraph mark after the quotation marks in the it_name entries. This process takes around three minutes for the list of A5 items. Avernum 5 floors would be another matter, there are complications with so many repeated names. Hence there would be a repetition of items that don’t have an "it_name…" entry problem, only here it would be no "fl_name" entry. Edit: Items are numbered from 0 through 489 but there are only 435 actual items. The calls actually used in practice are and the number of times they are used: 435 begindefineitem 431 it_name 177 import 71 it_ability 41 it_charges 65 it_extra_description 223 it_graphic_coloradj 107 it_graphic_sheet 54 it_graphic_template 95 it_level 100 it_protection 142 it_stats_addition 0 97 it_stats_addition 1 58 it_stats_addition 2 22 it_stats_addition 3 147 it_stats_to_affect 0 98 it_stats_to_affect 1 59 it_stats_to_affect 2 22 it_stats_to_affect 3 348 it_value 25 it_variety 76 it_weight 219 it_which_icon_ground 221 it_which_icon_inven Note that this can't detect repetition, I imagine that most items have a weight for example. What it does is detect changes in the value of weight. Edit: Spiderweb games with data scripts include all of the four Geneforge games, Nethergate, Avernum 4 and Avernum 5. To conserve space a script usually won't repeat identical entries. Thus the A5 items list has item 215 = Lab equipment, but no name is listed for item 216. This only occurs a few times in the items list but it occurs a lot in the terrain and floor lists. If you want to fill in the blanks while in an Excel spreadsheet, use this formula: =IF(G3=0,H2,G3) The list of names is in column G, it has all sorts of gaps in it. A new list is being drawn up in column H. The above formula is found in cell H3, it means "if cell G3 = 0, display the contents of cell H2, else display the contents of cell G3". If cell G3 is blank it will have a numerical value of 0. Quote Link to comment Share on other sites More sharing options...
Well-Actually War Trall Ishad Nha Posted February 25, 2008 Author Share Posted February 25, 2008 Here is the actual list itself: 0 (null item) 1 Copper Coins 2 Silver Coins 3 Gold Coins 4 Emerald 5 Flawed Crystal 6 Lovely Crystal 7 Beautiful Crystal 8 Gold Bar 9 Ruby 10 Cloak 11 Fine Cloak 12 Worgskin Cloak 13 Drakeskin Cloak 14 Coated Cloak 15 Grounded Cloak 16 Polar Fur Cloak 17 Archer's Cloak 18 Warrior's Cloak 19 Symbiotic Cloak 20 Flowing Silk Cloak 21 Deadeye Cloak 22 Vahnatai Cloak 23 Spirit Cloak 24 Robe 25 Fine Robe 26 Woven Silk Robe 27 Specter Robe 28 Enchanter's Robe 29 Robe of the Magi 30 Tunic 31 Leather Armor 32 Chainmail Vest 33 Iron Breastplate 34 Steel Breastplate 35 Blessed Breastplate 36 Blessed Silk Tunic 37 Thick Wool Tunic 38 Aranea Silk Tunic 39 Fibrous Breastplate 40 Mercuric Leather 41 Mercuric Chain 42 Mercuric Plate 43 Ruby Breastplate 44 Grounding Vest 45 Swampwalker Leather 46 Crystalline Plate 47 Charmed Plate 48 Crystal-Woven Chitin 49 Sniper's Vest 50 Treated Leather 51 Radiant Plate 52 Magus Vest 53 Runed Plate 54 Deadeye Chain 60 Stick 61 Dagger 62 Bronze Shortsword 63 Iron Shortsword 64 Steel Shortsword 65 Blessed Shortsword 66 Steel Dagger 67 Stunning Blade 68 Shielding Knife 69 Fine Cleaver 70 Bonding Knife 71 Singing Rapier 72 Ghostly Blade 73 Nephil Warblade 74 Falchion of Evasion 75 Discipline Blade 76 Flaming Sword 77 Oozing Sword 78 Frozen Blade 79 Radiant Shortblade 80 Seeking Rapier 81 Radiant Soulblade 82 Bronze Broadsword 83 Iron Broadsword 84 Steel Broadsword 85 Blessed Broadsword 86 Waveblade 87 Fine Waveblade 88 Venomous Blade 90 Cavewood Bow 91 Yew Bow 92 Composite Bow 93 Blessed Bow 94 Bow of Decay 95 Shockwave Bow 96 Heartstriker Bow 97 Fiery Wand 98 Disruption Wand 99 Terror Wand 100 Null Wand 101 Jeweled Wand 102 Sparkling Wand 103 Wand of the Inferno 104 Corrupting Baton 105 Wand of Death 108 Leather Bracers 109 Drakeskin Bracers 110 Bronze Bracers 111 Iron Bracers 112 Blessed Bracers 118 Javelin 119 Steel Javelin 117 Fine Lance 115 Razordisk 116 Fine Razordisk 120 Scroll - Ice Bolt 121 Scroll - Lightning 122 Scroll - Control Foe 123 Scroll - Acid Shower 124 Scroll - Madness 125 Wooden Shield 126 Iron Shield 127 Steel Shield 128 Blessed Shield 129 Radiant Shield 130 Drakeskin Shield 131 Nullity Shield 132 Reflecting Shield 133 Treated Carapace 134 Inertial Shield 135 Eyebeast Chitin 136 Assassin's Shield 137 Quicksilver Bulwark 138 Shield of Warmth 139 Silken Shield 140 Sandals 141 Boots 142 Heavy Boots 143 Blessed Boots 144 Quicksilver Sandals 145 Spectral Boots 146 Nimble Sandals 147 Clover Boots 148 Samaritan Sandals 149 Grounded Boots 150 Swamp Boots 151 Stability Boots 152 Radiant Boots 153 Gazerskin Sandals 155 Belt 156 Studded Belt 157 Girdle of Strength 158 Girdle of Nimbleness 159 Girdle of Insight 160 Girdle of Endurance 161 Apprentice Belt 162 Blessed Belt 163 Radiant Belt 164 Girdle of Might 165 Girdle of Avoidance 166 Girdle of Genius 167 Girdle of Life 170 Gold Ring 171 Platinum Ring 172 Shield Ring 173 Armor Ring 174 Blessed Armor Band 175 Chilling Band 176 Static Band 177 Ivory Band 178 Warmth Ring 179 Mica Band 180 Gloves 181 Gauntlets 182 Steel Gauntlets 183 Blessed Gauntlets 184 Piercing Gloves 185 Spectral Gloves 186 Thrusting Gauntlets 187 Tinker's Gloves 188 Gloves of the Hammer 189 Answering Gauntlets 190 Rock 191 Bag of Meal 192 Stone Blocks 193 Pitcher 194 Bones 195 Skull 196 Pot 197 Stein 198 Trowel 199 Hammer 200 Limb 201 Mortar and Pestle 202 Metal Bowl 203 Shackles 204 Hatchet 205 Bowl 206 Spoon 207 Whip 208 Trash 209 Trash 210 Tools 211 Basket 212 Research Notes 213 Incense 214 Mined Crystal 215 Lab Equipment 216 Lab Equipment 217 Lamp 218 Stone Crescent 219 Old Records 220 Healing Potion 221 Curing Potion 222 Speed Potion 223 Energy Potion 224 Shielding Potion 225 Augmenting Potion 226 Healing Elixir 227 Curing Elixir 228 Speed Elixir 229 Energy Elixir 230 Armor Elixir 231 Assault Elixir 232 Scroll - Group Heal 233 Scroll - Mindshield 234 Scroll - Group Haste 235 Scroll - Mass Bless 236 Scroll - Mass Shield 237 Invulnerable Potion 238 Invulnerable Elixir 239 Knowledge Brew 240 Knowledge Elixir 241 Piercing Crystal 242 Wisdom Crystal 243 Purging Crystal 244 Assault Crystal 245 Rod of Succor 246 Rod of Alacrity 247 Rod of Defense 248 Rod of Battle 250 Fruit 251 Dried Meat 252 Mushrooms 253 Bread 254 Fish 255 Mushroom 256 Roll 257 Meat 258 Bandages 260 Pitcher 261 Bolt of Cloth 262 Bar of Iron 263 Bucket 264 Amphora 265 Golden Goblet 266 Plate 267 Sheet of Papyrus 268 Dice 269 Scalpel 270 Thread 271 Trowel 272 Pen and Ink 273 Candle 274 Lamp 275 Potted Plant 276 Clay Jug 277 Clay Pot 278 Teapot 279 Mug 280 Teacup 281 Board Game 282 Saw 283 Board 284 Cake 285 Kabob 286 Cauldron 287 Mandrake Tincture 288 Demon's Bile 289 Healing Herbs 290 Spiritual Herbs 291 Energetic Herbs 292 Graymold 293 Mandrake Root 294 Fine Leather 295 Focusing Crystal 296 Fine Steel 303 Emerald Chestguard 304 Demonslayer 306 Warmaster Helm 307 Avenger's Ring 308 Crystalline Aegis 309 Infernal Shroud 310 Lightning Girdle 313 Cavewood Longbow 314 Yew Longbow 315 Composite Longbow 316 Blessed Longbow 317 Ceremonial Longbow 318 Farsight Longbow 323 Viperskin Boots 324 Rat Tail Band 325 Ratskin Shawl 328 Poor Leather Helmet 329 Leather Helmet 330 Fine Leather Helmet 331 Wyrmskin Helmet 332 Tin Helmet 333 Iron Helmet 334 Steel Helmet 335 Blessed Helmet 336 Serpentskin Helmet 337 Ice Hydra Helm 338 Helm of Khar 339 Helm of Klin 340 Runed Helm 342 Duelist's Gloves 343 Suede Gloves 344 Radiant Gauntlets 345 Putrified Gauntlets 350 Pants 351 Leather Pants 352 Leather Vambraces 353 Plate Vambraces 354 Blessed Vambraces 355 Radiant Vambraces 356 Swamp Pants 357 Pustulant Vambraces 358 Airy Vambraces 359 Blasted Vambraces 360 Ceremonial Leggings 361 Warrior's Vambraces 365 Silver Necklace 366 Gold Necklace 367 Blessed Bauble 368 Stability Bauble 369 Tinker's Bauble 370 Crystal Symbol 371 Tribal Symbol 372 Clarity Talisman 373 Temperate Necklace 374 Ruby Necklace 375 Runed Jade Necklace 376 Hero's Necklace 378 Talisman of Might 382 Bronze Spear 383 Iron Spear 384 Steel Spear 385 Blessed Spear 386 Bronze Halberd 387 Iron Halberd 388 Steel Halberd 389 Blessed Halberd 390 Lava-Fired Spear 391 Spear of the Fen 392 Cryos Spear 393 Molten Halberd 394 Jade Halberd 395 Chaotic Halberd 396 Slith Spear 397 Fine Slith Spear 398 Slith Warspear 399 Slith Bloodspear 400 Scissors 401 Pillow 402 Towel 403 Pot 404 Goblet 405 Rolling Pin 406 Ale 407 Wine 408 Broken Sword 409 Broom 410 Mop 411 Shovel 412 Pick 413 Bucket of Water 414 Tongs 415 Pincers 416 Rope 417 Pipe 418 Ceramic Pot 419 Lantern 420 Clay Bowl 421 Clay Brick 422 Trash 423 Broken Clay 424 Broken Pot 425 Dry Bone 426 Alchemical Equipment 427 Alchemical Equipment 428 Fishing Pole 429 Scales 430 Blanket 431 Spoon 432 Fork 433 Knife 434 Vase 435 Sentinel Power Stone 436 Stone Limb 437 Chitrach Claw 438 Eyestalks 439 Gremlin Wine 440 Woven Silver Chain 441 Nimble Chain 442 Woven Golden Chain 443 Bladeshield Chain 444 Shining Silver Band 445 Archer's Band 446 Shining Golden Band 447 Magestone Band 448 Pearlescent Band 449 Incantor's Ring 455 Icedrake Vambraces 456 Runed Vambraces 457 Acid-Etched Legs 459 Cap of Thoughts 460 Cap of Farsight 461 Basher's Helm 463 Stability Girdle 464 Mooneye Girdle 465 Silk-Woven Cord 467 Ruby Chain 468 Mica-Flecked Chain 469 Opal Chain 470 Jade Chain 471 Explorer's Ring 472 Shadow Band 473 Farsight Band 474 Leaden Band 476 Ebony Bow 477 Eliavri's Bow 480 Tinker's Crystal 481 Chitrach Husk 482 Broken Bit of Husk 485 Scroll - Raise Dead 486 Stone of Victory 487 Useless Trinkets 488 Polychromous Girdle 489 Stained Swamp Gloves Quote Link to comment Share on other sites More sharing options...
Well-Actually War Trall Harehunter Posted April 8, 2011 Share Posted April 8, 2011 Hopefully this sheds a little more light on the topic: http://hasenjs.byethost33.com/Avernum5/Items5.html I haven't gotten around to filling out the narrative, much less the index, but I did manage to squeak this out. Quote Link to comment Share on other sites More sharing options...
Ineffable Wingbolt Arch-Mage Solberg Posted April 18, 2011 Share Posted April 18, 2011 Very well done Harehunter! Post # 507 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.