Changelog¶
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