Jump to content

Drawing up a list of A5 items


Ishad Nha

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 years later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...