Changelog¶
4.1.2 (2021-04-16)¶
Added missing
bestiary_kills
andcharm_points
values for creatures in the Challenging class.
4.1.1 (2021-03-11)¶
Added missing
version
attribute toSpell
.
4.1.0 (2021-01-18)¶
Improved image cache, the timestamp of images are now saved and checked on subsequent calls.
By default, all articles are parsed, including deprecated, they can be skipped using
--skip-deprecated
.Added
status
column and field to main tables and models. Indicates the status of the entity (active, deprecated, event, ts-only).Fixed Worlds not being parsed due to the corresponding category being renamed on TibiaWiki.
4.0.1 (2020-11-23)¶
Updated API to consider the changes on Fandom’s API for pagination.
4.0.0 (2019-12-13)¶
Fixed database generation failing for images with redirects
Added indexes to various columns and various tables, this should increase search performance.
Made title and name columns case insensitive.
Added
location
column toHouse
class andhouse
table.- Added
Outfit
class andoutfit
table. Added
OutfitImage
class andoutfit_image
table since outfits have multiple images.Added
OutfitQuest
class andoutfit_quest
table for quests required for outfits or its addons.
- Added
Added
type_secondary
column and field toitem
andcreature
tables andItem
andCreature
classes.Added
look_text
property toItem
, renders the item’s look text.Added
reistances
property toItem
, gets a dictionary of the item’s resistances.Breaking change: Renamed
class
columns and fields initem
table andItem
class toitem_class
.Breaking change: Renamed
class
columns and fields increature
table andCreature
class tocreature_class
.
3.0.1 (2019-05-16)¶
Item.attribute_dict
returns empty dictionary instead ofNone
ifItem.attributes
is empty.
3.0.0 (2019-05-15)¶
Charms are now read from their TibiaWiki articles instead of a static json file.
Charm
class andcharm
table changes:Added
article_id
,title
,timestamp
andversion
Renamed
description
toeffect
.
New
creature_sound
anditem_sound
, containing “sounds” made by creatures and items respectively.Creature
class andcreature
table changes:Added
push_objects
.Added
sounds
to class.
Quest
class andquest
table changes:Added
rookgaard
,type
,quest_log
,active_time
andestimated_time
.
Item
class and ``item``table changes:Added
marketable
,pickupable
,light_color
andlight_radius
,Added
sounds
to class.
- New tracked attributes in
item_attribute
destructible
holds_liquid
writeable
rewriteable
consumable
writable_chars
- New tracked attributes in
2.2.0 (2019-05-03)¶
New table
mount
, containing all mounts and their information.Fixed incorrect potions entries due to NPC Minzy.
2.1.1 (2019-03-25)¶
Fixed physical and earth modifiers not showing up in
weak_to
,immune_to
andresistant_to
Creature
properties.Fixed incorrect
weak_to
property.Fixed missing
modifier_hpdrain
Creature
attribute.
2.1.0 (2019-03-19)¶
elemental_attack Item Attribute split into
fire_attack
,ice_attack
,energy_attack
andearth_attack
to reflect changes in TibiaWiki’s template.Added
bestiary_kills
andcharm_points
properties toCreature
.Added
elemental_modifiers
,weak_to
,immune_to
andresistant_to
properties toCreature
.New table
world
and modelWorld
. Contains information of Game worlds, including now offline worlds.
2.0.2 (2019-01-14)¶
Elemental protection and required vocation item attributes were not getting set.
2.0.1 (2018-11-26)¶
Fixed imbuement materials not getting saved in the database.
2.0.0 (2018-11-22)¶
New model classes, to unify the generation process.
Live fetching is now possible, obtain data directly from the Wiki.
Database generation now shows progress bars and time estimates.
The database schema is now generated dynamically.
- The database structure has changed:
- Renamed tables:
achievements
->achievement
creatures
->creature
creatures_drops
->creature_drop
houses
-house
imbuements
->imbuement
imbuements_materials
->imbuement_material
items
->item
items_attributes
->item_attribute
npcs
->npc
npcs_buying
->npc_offer_buy
npcs_selling
->npc_offer_sell
npcs_destinations
->npc_destination
npcs_spells
->npc_spell
quests
->quest
quests_dangers
->quest_danger
quests_rewards
->quest_reward
rashid_positions
->rashid_position
spells
->spell
- Renamed columns:
- All tables:
id
->article_id
last_edit
->timestamp
- Table:
creature
: summon
->summon_cost
convince
->convince_cost
occurrence
->bestiary_occurrence
see_invisible
->sees_invisible
walkthrough
->walks_through
walksaround
->walks_around
All element columns now have
modifier
at the beginning (e.g.phyisical
->modifier_phyisical
)
- Table:
- Table:
item
value
->value_sell
price
->value_buy
- Table:
id
->house_id
in tablehouse
attribute
->value
in tableitem_attribute
destination
->name
in tablenpc_destination
- Added columns:
title
in all tables, except child tables andcharm
,rashid_position
andmap
:client_id
in tableitem
location
innpc
andrashid_position
tables.effect
in tablespell
.
- Removed columns:
day_name
fromrashid_position
1.2.0 (2018-10-16)¶
New
charm
table, contains information about all charms.
1.1.1 (2018-09-23)¶
Improved parsing of
walksaround
andwalksthrough
1.1.0 (2018-09-22)¶
Added new columns to creatures table:
walksaround
walksthrough
1.0.1 (2018-07-02)¶
Fixed bug caused when a category had a number of articles that was exactly a multiple of 50.
1.0.0 (2018-07-01)¶
id
is now TibiaWiki’s article id for the element, making them more reliable than autoincremented ids.Fixed bug with potion’s prices.
Fixed bug with paralysable being inverted.
New tables
imbuements
andimbuements_materials
.Unknown creature attributes are no longer parsed as
False
, butNone
.New columns in creatures table:
bestiary_class
bestiary_level
occurrence
armor
speed
0.3.0 (2017-12-18)¶
New
items_keys
table, contains key numbers with their uses and locations.New
rashid_positions
database, contains Rashid’s coordinates for each weekday.Added
article
,class
andtype
tocreatures
table.Added
article
,class
andclient_id
toitems
table.Added
last_edit
column to most tables.
0.2.0 (2017-11-14)¶
Improved the parsing of all data tables, resulting in more consistency in values, less empty strings (not
NULL
) and better handling of default values.New
database_info
table, it contains two rows, “version” and “generated_date”, containing the script vused and the date the database was generated respectively.Added a new
currency
column tonpcs_buying
andnpcs_selling
, it contains the id of the item used as currency for that transaction (e.g. gold coins, gold tokens, silver tokens, etc).Better parsing for item npc offers, a lot more offers are saved now, including item trades (e.g. 1 fighting spirit for 2 royal helmets).
More item attributes are saved to
item_attributes
.
0.1.1 (2017-11-12)¶
Better attribute parsing, this means values should me more consistent and there are no entries without the
name
columnNo changes were made to the schema.
0.1.0 (2017-11-09)¶
Creatures table, with all their attributes, including a separate table for all their loot.
Loot drop percentage are calculated from loot statistics
Item table, with their basic attributes, and their separate attributes on a separate table
NPCs table with their information, including spawn location.
NPCs sell and buy offers
Achievements, with their spoiler info
Quests basic infor