Skip to content

Releases: Galarzaa90/tibiawiki-sql

v3.0.1

17 May 02:59

Choose a tag to compare

Changes

  • Item.attribute_dict returns empty dictionary instead of None if Item.attributes is empty.

No changes were made in the database.

v3.0.0

15 May 22:48
670bf5a

Choose a tag to compare

Changes

  • Charms are now read from their TibiaWiki articles instead of a
    static json file.

    • Charm class and charm table changes:

      • Added article_id, title, timestamp and version
      • Renamed description to effect.
  • New creature_sound and item_sound, containing "sounds" made by
    creatures and items respectively.

    • Creature class and creature table changes:

      • Added push_objects.
      • Added sounds to class.
    • Quest class and quest table changes:

      • Added rookgaard, type, quest_log, active_time and
        estimated_time.
    • Item class and itemtable changes:

      • Added marketable, pickupable, light_color and
        light_radius,
      • Added sounds to class.
    • New tracked attributes in item_attribute

      • destructible
      • holds_liquid
      • writeable
      • rewriteable
      • consumable
      • writable_chars

v2.2.0

03 May 22:18
8ec529b

Choose a tag to compare

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

25 Mar 16:17

Choose a tag to compare

Changes

  • Fixed physical and earth modifiers not showing up in weak_to,
    imunute_to and resistant_to Creature properties.
  • Fixed incorrect weak_to property.
  • Fixed missing modifier_hpdrain Creature attribute.

Attached database generated on 19/03/2019

v2.1.0

19 Mar 16:57
534617a

Choose a tag to compare

Changes

  • elemental_attack Item Attribute split into fire_attack, ice_attack, energy_attack and earth_attack to
    reflect changes in TibiaWiki's template.
  • Added bestiary_kills and charm_points properties to Creature.
  • Added elemental_modifiers, weak_to, immune_to and resistant_to properties to Creature.
  • New table world and model World. Contains information of Game worlds, including now offline worlds.

v2.0.2

14 Jan 19:02
328fc6a

Choose a tag to compare

Changes

  • Elemental protection and required vocation item attributes were not getting set.

v2.0.1

26 Nov 17:42

Choose a tag to compare

Changes

  • Fixed imbuement materials not getting saved in the database.

v2.0.0

22 Nov 18:30

Choose a tag to compare

  • 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: item

        • value -> value_sell
        • price -> value_buy
      • id -> house_id in table house

      • attribute -> value in table item_attribute

      • destination -> name in table npc_destination

    • Added columns:

      • title in all tables, except child tables and charm,
        rashid_position and map:
      • client_id in table item
      • location in npc and rashid_position tables.
      • effect in table spell.
    • Removed columns:

      • day_name from rashid_position

v1.2.0

16 Oct 21:28
fbb5481

Choose a tag to compare

Changes

  • New charm table, contains information about all charms.

v1.1.1

23 Sep 23:10
e03c6a4

Choose a tag to compare

Version 1.1.1 (2018-09-23)

  • Improved parsing of walksaround and walksthrough