v9.0.0+tibiash.7: chore: release 9.0.0+tibiash.7 (#19)

• Read loot ranges with commas as thousands separators, like 1,000-2,000, as 1000 to 2000 instead of 0 to 2. This
  covers creature loot and the Loot Statistics pages. A Loot Statistics entry like
  Gold Coin, times:1,234, amount:1,000-2,000 keeps 1,234 and 1,000-2,000 whole, and an entry whose times has no
  number is skipped instead of stopping the task. Neither side of a range has a sign, as before, and 1,0002-3 still
  reads as 2 to 3. No current value changes.
• Read a currency linked with a leading colon, like [[:Gold Token]], as Gold Token instead of :Gold Token, in
  item.value_buy_currency and mount.price_currency. Colon links to files, images and categories are still skipped.
  No current value changes.
• Keep the Loot Statistics task running past a bad page. An entry without times is skipped, and a page whose kills
  is 0, missing or not a number gets no drop rows, since no chance can be computed. Before, each of these stopped the
  task for every later page. A page with negative kills also gets no drop rows, and an entry with negative times
  is skipped, instead of replacing a drop with a negative chance. No current value changes.

v9.0.0+tibiash.6: chore: release 9.0.0+tibiash.6 (#17)

• Read numbers with commas as thousands separators, like 50,000, as the whole number instead of the digits before
  the first comma. This fixes creature hitpoints and experience, item value_buy and value_sell, outfit
  full_price and other quantities. A comma not followed by exactly three digits still ends the number, and an ID list
  like itemid = 629,630,631 or mount_id = 421,437,438,747 still gives its first ID. A creature's max damage
  without a {{Max Damage}} template reads 1,300+ as 1300, and a range like 600-1000? by its larger number.
• Keep the first number of every ID field, like the client IDs, so achievementid = 12,345 gives 12, not 12345. This
  covers house.house_id, achievement.achievement_id, world.world_board, world.trade_board, game_update.news_id
  and item_key.number. No current value changes.
• Add the item.value_buy_currency column. It holds the article's pricecurrency, otherwise a currency written after
  the price in npcprice, like 50 [[Gold Token]]s, otherwise Gold Coin, and NULL when value_buy is NULL or 0.
  A linked currency gives the page it links to, so [[Silver Token]]s gives Silver Token, and mount.price_currency
  now reads links the same way. 25 Years Backpack's price of 7197 is now in Theons, not gold.

v9.0.0+tibiash.5: chore: release 9.0.0+tibiash.5 (#15)

• Store spell.effect, spell.spell_type, spell.group_spell, spell.level and spell.cooldown as NULL when a
  spell's article has no such field, and spell.cooldown as NULL when it is not a whole number of seconds, like
  1-2s, instead of dropping the spell. A spell with no mana field gets 0, which means special conditions apply.
  Force Strike, Broadcast, Poison Storm, Undead Legion, Sniper, Second Wind and Ultimate Explosion are now kept.
• Read a charm's three costs split by commas, like 800, 1200, 4000, when its cost field has no slash, instead of
  dropping the charm. Low Blow is now kept.
• Store npc.city as NULL when an NPC's article has no city field, instead of dropping the NPC. Such an NPC's
  travel legs start where a From [[Place]] note or a shuttle names, and otherwise have a NULL origin. A Blue Stone
  is now kept.
• Store achievement.name and achievement.description as NULL when an achievement's article has no such field,
  instead of dropping the achievement. achievement.description is now nullable. Achievement 563 is now kept.
• Add the mount.price_currency column. It holds the article's pricecurrency, otherwise Tournament Coins for a
  tournament mount, otherwise Tibia Coins, and NULL when the mount has no price. Landsailer's price of 140 is now
  in Event Points, not Tibia Coins.

v9.0.0+tibiash.4: chore: release 9.0.0+tibiash.4 (#13)

• Store version as NULL in game_update, house, outfit and mount when an article has no implemented
  field, instead of dropping the article. A misspelled field like implementation is not read, as the wiki does not
  show it.
• Store mount.taming_method as NULL when a mount's article has no taming_method field, instead of dropping the
  mount. Landsailer is now kept.

v9.0.0+tibiash.3: chore: release 9.0.0+tibiash.3 (#8)

• Drop everything after an unclosed <!-- in creature.race_id, outfit.male_client_id, outfit.female_client_id
  and mount.client_id, as MediaWiki hides it. A value like <!-- 51952 is now stored as NULL.
• List up to 100 issues in the upstream check, and fail when the list reaches that limit. A cut-short list could miss
  the "Upstream has new commits" issue and open a second one.
• Ship CHANGELOG.md in the sdist, which named a CHANGELOG.rst that does not exist, and leave out the upstream
  check's test, which tests CI tooling the sdist does not ship.

v9.0.0+tibiash.2

• Start each leg of a shuttle NPC at the other leg's destination when no From [[Place]] note names the start. An NPC
  is a shuttle when it has exactly two positions and exactly two destinations, and each position matches exactly one
  destination by city, subarea or geolabel, ignoring case, each destination by a different position. Harlow's and
  Tarak's legs now start at the other end of their route.
• Add creature.race_id, the client race ID of a creature: the first integer in the race_id field of its article,
  or NULL when there is none.
• Ignore wiki comments in creature.race_id, outfit.male_client_id, outfit.female_client_id and
  mount.client_id. A value that is only a comment, like <!-- objectID: 51952-->, is stored as NULL.
• Add a weekly upstream check. A scheduled workflow compares Galarzaa90/tibiawiki-sql with our main. When upstream
  has commits our main lacks, it opens, updates or reopens one "Upstream has new commits" issue that lists them. When
  there are none, it closes that issue.

v9.0.0+tibiash.1

• Add the npc_location table with every position of an NPC, numbered 1 to 7. Each position has its city, subarea,
  geolabel and x, y and z coordinates.
• Add npc_destination.origin, the place where each travel leg starts. It comes from a note that is only a
  From [[Place]] link. Without one, it is the NPC's city if the NPC has a position in that city whose city, subarea
  and geolabel all differ from the destination, ignoring case. Otherwise it is NULL.
• Add the item attributes restores_hp_min, restores_hp_max, restores_mana_min and restores_mana_max, parsed from
  the restores between A and B Hit Points, and between C and D Mana Points sentence in an item's notes.
• Add outfit.male_client_id, outfit.female_client_id and mount.client_id, the client IDs (look types) of outfits
  and mounts.
• Store a missing or malformed client ID or npc_location coordinate as NULL. The existing npc.x and npc.y keep
  upstream's behaviour.