Releases: Galarzaa90/tibiawiki-sql
Releases · Galarzaa90/tibiawiki-sql
v3.0.1
Changes
Item.attribute_dictreturns empty dictionary instead ofNoneifItem.attributesis empty.
No changes were made in the database.
v3.0.0
Changes
-
Charms are now read from their TibiaWiki articles instead of a
static json file. -
-
Charmclass andcharmtable changes:- Added
article_id,title,timestampandversion - Renamed
descriptiontoeffect.
- Added
-
-
New
creature_soundanditem_sound, containing "sounds" made by
creatures and items respectively. -
-
Creatureclass andcreaturetable changes:- Added
push_objects. - Added
soundsto class.
- Added
-
-
-
Questclass andquesttable changes:- Added
rookgaard,type,quest_log,active_timeand
estimated_time.
- Added
-
-
-
Itemclass anditemtable changes:- Added
marketable,pickupable,light_colorand
light_radius, - Added
soundsto class.
- Added
-
-
-
New tracked attributes in
item_attributedestructibleholds_liquidwriteablerewriteableconsumablewritable_chars
-
v2.2.0
Changes
- New table
mount, containing all mounts and their information. - Fixed incorrect potions entries due to NPC Minzy.
Database generated on May 3rd 2019
v2.1.1
Changes
- Fixed physical and earth modifiers not showing up in
weak_to,
imunute_toandresistant_toCreatureproperties. - Fixed incorrect
weak_toproperty. - Fixed missing
modifier_hpdrainCreatureattribute.
Attached database generated on 19/03/2019
v2.1.0
Changes
elemental_attackItem Attribute split intofire_attack,ice_attack,energy_attackandearth_attackto
reflect changes in TibiaWiki's template.- Added
bestiary_killsandcharm_pointsproperties toCreature. - Added
elemental_modifiers,weak_to,immune_toandresistant_toproperties toCreature. - New table
worldand modelWorld. Contains information of Game worlds, including now offline worlds.
v2.0.2
Changes
- Elemental protection and required vocation item attributes were not getting set.
v2.0.1
Changes
- Fixed imbuement materials not getting saved in the database.
v2.0.0
- 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->achievementcreatures->creaturecreatures_drops->creature_drophouses-houseimbuements->imbuementimbuements_materials->imbuement_materialitems->itemitems_attributes->item_attributenpcs->npcnpcs_buying->npc_offer_buynpcs_selling->npc_offer_sellnpcs_destinations->npc_destinationnpcs_spells->npc_spellquests->questquests_dangers->quest_dangerquests_rewards->quest_rewardrashid_positions->rashid_positionspells->spell
-
Renamed columns:
-
All tables:
id->article_idlast_edit->timestamp
-
Table:
creature:summon->summon_costconvince->convince_costoccurrence->bestiary_occurrencesee_invisible->sees_invisiblewalkthrough->walks_throughwalksaround->walks_around- All element columns now have
modifierat the beginning
(e.g.phyisical->modifier_phyisical)
-
Table:
itemvalue->value_sellprice->value_buy
-
id->house_idin tablehouse -
attribute->valuein tableitem_attribute -
destination->namein tablenpc_destination
-
-
Added columns:
titlein all tables, except child tables andcharm,
rashid_positionandmap:client_idin tableitemlocationinnpcandrashid_positiontables.effectin tablespell.
-
Removed columns:
day_namefromrashid_position
-
v1.2.0
Changes
- New
charmtable, contains information about all charms.
v1.1.1
Version 1.1.1 (2018-09-23)
- Improved parsing of
walksaroundandwalksthrough