Jump to content

antz

Community Manager
  • Content Count

    2,643
  • Donations

    0.00 GBP 
  • Joined

  • Last visited

  • Days Won

    57

Everything posted by antz

  1. The Pathing has been extensively tested over the years, can you give us a specific example of where this is failing ?
  2. also... is this a fresh clone of the database GitHub repo ?
  3. I do remember seeing a commit for Zero (can't remember whether it was for the DB or code) which corrected this. - It might be possible that some updates have reverted this in error. Maybe a quick github search of the repos might find it, although since this is an older issue, possibly try http://github.com/mangosarchives
  4. Changed Status to Completed Changed Priority to New
  5. antz

    Omen of clarity

    Changed Status to Completed Changed Version to 21.14 (Master Branch)
  6. Goals for 2019 For 2019 the following are what we would like to achieve: Release Version 22 for Zero, One, Two and Three containing all the recent updates and fixes we have. Redo the server commands to make them a bit more standard and obvious. Break out AHBot into its own daemon process Develop a mangos update daemon, which allows the ability to apply DB content and minor updates automatically Normalise the character DB and remove data blob fields Move some hardcoded values from the core into the DB, possibly some enums as well. Implement Stormlib library for Zero, One and Two and remove mlib Apply the Unified Extractor to Three and Four (requires stormlib) Look at removing DBC usage from the Core and change the extraction process to include importing into a DB for use by the core. Including Multiple locale support. This would facilitate the removal of stormlib / mlib from the core and only be needed by the extraction tools. Look at Adapting EAI to match SAI functionality. As well as some of the more obvious ones: Continue to standardise the code across the cores where its appropriate to do so. Document where it differs and why. Clear down reported bugs on the Project Tracker. Improve the World Database with updates and corrections. Improve the Wiki Documentation. Include some example Eluna scripts to assist those starting out learning to script with Eluna. Include some custom Eluna scripts to help showcase it's abilities. Finally, we would like to get into a twice yearly Release cycle of more major releases. MangosVB (Formerly Spurious) RoadMap for 2017 Add RealmDB from c++ Mangos and modifying MangosVB to be compatible with it. Once done, this will be linked via a git submodule Work out how to get MangosVB to use the standard Mangos map format. Finishing warden functionality (so it can use/read signatures from DB) Merge all of the changes from Zero to One and Two Investigate into voice functionality for One / Two Doing spells.. implementing them like stealth and getting a proper DB script system in place.
  7. anything that you can contribute to the main database would be greatly appreciated
  8. some areas have been painstakingly mapped by devs, but after about 5 zones they quickly lose interest
  9. Sadly, not easily The server expects a username and password to be entered before it even attempts to authenticate with the server. - You could override the incorrect username/password routine to create an account and log in rather than reporting an error, but that would mean an account being created every time someone entered the wrong information.
  10. antz

    DB fehler

    Are you using windows or linux ? ---=== Google Translate ===--- Verwenden Sie Windows oder Linux?
  11. I know i'm a little late to the party, but there are two address fields in the realmlist table: address for the external ip address localAddress for local LAN access surely setting the localAddress to your LAN IP will allow local users to access the server ok ?
  12. Hi, you may find this useful for add/modifying accounts... managing-user-accounts-using-3rd-party-apps
  13. antz

    AiPlayerbot

    @macmillanHi, I'd love to work with you to get these into the cores
  14. apart from any discrepancies between the actual table fields and possibly some id mismatches... - other than that, it should be fine
  15. @Langerz82- Glad to have you here, if there in anything we can do to help you, please let us know.
  16. antz

    M.i.a.

    Good to hear from you again, all the gang's still here
  17. installing-mangos-on-windows-using-easybuild
  18.  NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'achievement_criteria_requirement' table for MaNGOSTwo This table contains what needs to be done to complete an achievement criteria. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes criteria_id mediumint(8) NO PRI NULL   Matching ID from achievement_criteria.dbc type tinyint(3) unsigned NO PRI '0'   The Type of Criteria value1 mediumint(8) unsigned NO '0'     value2 mediumint(8) unsigned NO '0'     Description of the fields criteria_id mediumint(8) Column 0 (ID) of [See achievement_criteria.dbc] This DBC contains the achievement_id on 2nd column and will be later extracted to show relations. type tinyint(3) unsigned The Type of Criteria Type Id Critieria Name Value1 Value2 0 TYPE_NONE     1 TYPE_T_CREATURE Target creature_template.entry   2 TYPE_T_PLAYER_CLASS_RACE Target Player Class Target Player Race 3 TYPE_T_PLAYER_LESS_HEALTH Target Health percentage   4 TYPE_T_PLAYER_DEAD Team value the source player and target dead player must both meet   5 TYPE_S_AURA Spell Id Effect Index 6 TYPE_S_AREA Area Id from [See AreaTable.dbc]   7 TYPE_T_AURA Spell Id Effect Index 8 TYPE_VALUE Min Value. Value provided with achievement update must be not less that limit   9 TYPE_T_LEVEL Target Min Level   10 TYPE_T_GENDER Gender: 0=Male, 1=Female   11 TYPE_DISABLED Used to prevent achievement criteria to complete if not all requirements are implemented and listed in this table   12 TYPE_MAP_DIFFICULTY Map Difficulty, Refer to Table Below   13 TYPE_MAP_PLAYER_COUNT Count. For criteria 'with less than %u people in the zone'   14 TYPE_T_TEAM Team: HORDE = 67, ALLIANCE = 469   15 TYPE_S_DRUNK An entry from the Drunken State table below   16 TYPE_HOLIDAY Holiday ID which must be active from (See Holiday.dbc) and game_event   17 TYPE_BG_LOSS_TEAM_SCORE min_score max_score 18 TYPE_INSTANCE_SCRIPT Make instance script call for check current criteria requirements fit   19 TYPE_S_EQUIPED_ITEM_LVL Item Level Item Quality 20 TYPE_REQUIRE_NTH_BIRTHDAY nth-birthday   21 TYPE_REQUIRE_KNOWN_TITLE title_id   Map Difficulty Table Description Value DUNGEON_DIFFICULTY_NORMAL 0 DUNGEON_DIFFICULTY_HEROIC 1 RAID_DIFFICULTY_10MAN_NORMAL 0 RAID_DIFFICULTY_25MAN_NORMAL 1 RAID_DIFFICULTY_10MAN_HEROIC 2 RAID_DIFFICULTY_25MAN_HEROIC 3 Drunken State Table Drunken Name Value DRUNKEN_SOBER 0 DRUNKEN_TIPSY 1 DRUNKEN_DRUNK 2 DRUNKEN_SMASHED 3 value1 mediumint(8) unsigned The meaning of this field is based on the Type, see the table above. value2 mediumint(8) unsigned The meaning of this field is based on the Type, see the table above. auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  19.  NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'achievement_criteria_requirement' table for MaNGOSThree This table contains what needs to be done to complete an achievement criteria. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes criteria_id mediumint(8) NO PRI NULL   Matching ID from achievement_criteria.dbc type tinyint(3) unsigned NO PRI '0'   The Type of Criteria value1 mediumint(8) unsigned NO '0'     value2 mediumint(8) unsigned NO '0'     Description of the fields criteria_id mediumint(8) Column 0 (ID) of [See achievement_criteria.dbc] This DBC contains the achievement_id on 2nd column and will be later extracted to show relations. type tinyint(3) unsigned The Type of Criteria Map Difficulty Table Description Value DUNGEON_DIFFICULTY_NORMAL 0 DUNGEON_DIFFICULTY_HEROIC 1 RAID_DIFFICULTY_10MAN_NORMAL 0 RAID_DIFFICULTY_25MAN_NORMAL 1 RAID_DIFFICULTY_10MAN_HEROIC 2 RAID_DIFFICULTY_25MAN_HEROIC 3 Drunken State Table value1 mediumint(8) unsigned The meaning of this field is based on the Type, see the table above. value2 mediumint(8) unsigned The meaning of this field is based on the Type, see the table above. auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  20. antz

    conditions

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'conditions' table for MaNGOSThree With this table and the new conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) Used in: DBScript gossip_menu gossip_menu_option npc_spellclick_spells spell_area areatrigger_teleport Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes condition_entry mediumint(8) unsigned NO PRI NULL 'auto_increment' Identifier type tinyint(3) NO MUL '0'   Type of the condition. value1 mediumint(8) unsigned NO '0'   Data field One for the condition. value2 mediumint(8) unsigned NO '0'   Data field Two for the condition. comments varchar(200) YES {Blank String}     Description of the fields condition_entry mediumint(8) unsigned Identifier type tinyint(3) Type of the condition: ID Type Description -3 CONDITION_NOT Used to evaluate if another condition is NOT true. See Note 1 -2 CONDITION_OR Used to evaluate if condition OR condition is true. See Note 1 -1 CONDITION_AND Used to evaluate if condition AND condition is true. See Note 1 0 CONDITION_NONE This condition is not used at all. Always returns true. 1 CONDITION_AURA Checks target currently has the specified aura on him/her. 2 CONDITION_ITEM Checks if the player has the required amount (value2) of items in his/hers inventory. 3 CONDITION_ITEM_EQUIPPED Checks if the player has the specified item equipped. 4 CONDITION_AREAID Checks if the player is within the specified area/zone. 5 CONDITION_REPUTATION_RANK_MIN Checks if the player has the minimum required reputation rank with a specific faction. 6 CONDITION_TEAM Checks what team the target is a member of (Alliance or Horde). 7 CONDITION_SKILL Checks if the player has the required minimum skill value of the specified skill. 8 CONDITION_QUESTREWARDED Checks if the player has complete the specified quest. 9 CONDITION_QUESTTAKEN Checks if the player has taken the quest (as in has it in his/hers quest log.) and not completed it yet. 10 CONDITION_AD_COMMISSION_AURA TODO 11 CONDITION_NO_AURA Checks if the target DOES NOT currently have the specified aura on him/her. 12 CONDITION_ACTIVE_GAME_EVENT Checks if a game event is currently active. 13 CONDITION_AREA_FLAG Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) 14 CONDITION_RACE_CLASS Checks if the target is a certain race AND/OR class. 15 CONDITION_LEVEL Checks the targets level. 16 CONDITION_NOITEM Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. 17 CONDITION_SPELL Checks if the target has or hasn't (value2) the specified spell. 18 CONDITION_INSTANCE_SCRIPT SD3 based condition 19 CONDITION_QUESTAVAILABLE Checks if the specified quest is available (can start it) for the player. 20 CONDITION_ACHIEVEMENT Has or has no special achievement. 21 CONDITION_ACHIEVEMENT_REALM Realm wide achievement (like 20 above but realm wide). 22 CONDITION_QUEST_NONE Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. 23 CONDITION_ITEM_WITH_BANK Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. 24 CONDITION_NOITEM_WITH_BANK Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. 25 CONDITION_NOT_ACTIVE_GAME_EVENT Checks if a game event is currently NOT active. 26 CONDITION_ACTIVE_HOLIDAY Checks if a holiday is active 27 CONDITION_NOT_ACTIVE_HOLIDAY Checks if a holiday is not active 28 CONDITION_LEARNABLE_ABILITY Checks if the player can learn ability - using minimum skill value from [See SkillLineAbility.dbc] If the player has spell or has item (when defined) the condition will evaluate to false. 29 CONDITION_SKILL_BELOW TODO 30 CONDITION_REPUTATION_RANK_MAX Checks if the player has a higher reputation rank than specified a faction. 31 CONDITION_COMPLETED_ENCOUNTER Checks if an encounter has been completed. 32 CONDITION_SOURCE_AURA Checks if the source of the condition (like looted npc) has an aura. 33 CONDITION_LAST_WAYPOINT Checks the waypoint-state of the source of the condition. 34 CONDITION_XP_USER Checks if a player has turned XP earning on/off 35 CONDITION_GENDER Checks the gender of a player. 36 CONDITION_DEAD_OR_AWAY TODO 37 CONDITION_CREATURE_IN_RANGE TODO 38 CONDITION_PVP_SCRIPT TODO 39 CONDITION_SPAWN_COUNT Returns if specified count of creature entry exists on map. 36 CONDITION_DEAD_OR_AWAY Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. Note 1: Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as: value1 (as condition_entry) AND / OR value2 (as condition_entry). With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) value1 mediumint(8) unsigned Data field One for the condition. value2 mediumint(8) unsigned Data field Two for the condition. comments varchar(200) auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  21. antz

    conditions

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'conditions' table for MaNGOSTwo With this table and the new conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) Used in: DBScript gossip_menu gossip_menu_option npc_spellclick_spells spell_area areatrigger_teleport Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes condition_entry mediumint(8) unsigned NO PRI NULL 'auto_increment' Identifier type tinyint(3) NO MUL '0'   Type of the condition. value1 mediumint(8) unsigned NO '0'   Data field One for the condition. value2 mediumint(8) unsigned NO '0'   Data field Two for the condition. comments varchar(200) YES {Blank String}     Description of the fields condition_entry mediumint(8) unsigned Identifier type tinyint(3) Type of the condition: ID Type Description -3 CONDITION_NOT Used to evaluate if another condition is NOT true. See Note 1 -2 CONDITION_OR Used to evaluate if condition OR condition is true. See Note 1 -1 CONDITION_AND Used to evaluate if condition AND condition is true. See Note 1 0 CONDITION_NONE This condition is not used at all. Always returns true. 1 CONDITION_AURA Checks target currently has the specified aura on him/her. 2 CONDITION_ITEM Checks if the player has the required amount (value2) of items in his/hers inventory. 3 CONDITION_ITEM_EQUIPPED Checks if the player has the specified item equipped. 4 CONDITION_AREAID Checks if the player is within the specified area/zone. 5 CONDITION_REPUTATION_RANK_MIN Checks if the player has the minimum required reputation rank with a specific faction. 6 CONDITION_TEAM Checks what team the target is a member of (Alliance or Horde). 7 CONDITION_SKILL Checks if the player has the required minimum skill value of the specified skill. 8 CONDITION_QUESTREWARDED Checks if the player has complete the specified quest. 9 CONDITION_QUESTTAKEN Checks if the player has taken the quest (as in has it in his/hers quest log.) and not completed it yet. 10 CONDITION_AD_COMMISSION_AURA TODO 11 CONDITION_NO_AURA Checks if the target DOES NOT currently have the specified aura on him/her. 12 CONDITION_ACTIVE_GAME_EVENT Checks if a game event is currently active. 13 CONDITION_AREA_FLAG Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) 14 CONDITION_RACE_CLASS Checks if the target is a certain race AND/OR class. 15 CONDITION_LEVEL Checks the targets level. 16 CONDITION_NOITEM Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. 17 CONDITION_SPELL Checks if the target has or hasn't (value2) the specified spell. 18 CONDITION_INSTANCE_SCRIPT SD3 based condition 19 CONDITION_QUESTAVAILABLE Checks if the specified quest is available (can start it) for the player. 20 CONDITION_ACHIEVEMENT Has or has no special achievement. 21 CONDITION_ACHIEVEMENT_REALM Realm wide achievement (like 20 above but realm wide). 22 CONDITION_QUEST_NONE Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. 23 CONDITION_ITEM_WITH_BANK Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. 24 CONDITION_NOITEM_WITH_BANK Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. 25 CONDITION_NOT_ACTIVE_GAME_EVENT Checks if a game event is currently NOT active. 26 CONDITION_ACTIVE_HOLIDAY Checks if a holiday is active 27 CONDITION_NOT_ACTIVE_HOLIDAY Checks if a holiday is not active 28 CONDITION_LEARNABLE_ABILITY Checks if the player can learn ability - using minimum skill value from [See SkillLineAbility.dbc] If the player has spell or has item (when defined) the condition will evaluate to false. 29 CONDITION_SKILL_BELOW TODO 30 CONDITION_REPUTATION_RANK_MAX Checks if the player has a higher reputation rank than specified a faction. 31 CONDITION_COMPLETED_ENCOUNTER Checks if an encounter has been completed. 32 CONDITION_SOURCE_AURA Checks if the source of the condition (like looted npc) has an aura. 33 CONDITION_LAST_WAYPOINT Checks the waypoint-state of the source of the condition. 34 CONDITION_XP_USER Checks if a player has turned XP earning on/off 35 CONDITION_GENDER Checks the gender of a player. 36 CONDITION_DEAD_OR_AWAY TODO 37 CONDITION_CREATURE_IN_RANGE TODO 38 CONDITION_PVP_SCRIPT TODO 39 CONDITION_SPAWN_COUNT Returns if specified count of creature entry exists on map. 36 CONDITION_DEAD_OR_AWAY Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. Note 1: Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as: value1 (as condition_entry) AND / OR value2 (as condition_entry). With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) value1 mediumint(8) unsigned Data field One for the condition. value2 mediumint(8) unsigned Data field Two for the condition. comments varchar(200) auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  22. antz

    conditions

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'conditions' table for MaNGOSOne With this table and the new conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) Used in: DBScript gossip_menu gossip_menu_option npc_spellclick_spells spell_area areatrigger_teleport Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes condition_entry mediumint(8) unsigned NO PRI NULL 'auto_increment' Identifier type tinyint(3) NO MUL '0'   Type of the condition. value1 mediumint(8) unsigned NO '0'   Data field One for the condition. value2 mediumint(8) unsigned NO '0'   Data field Two for the condition. comments varchar(200) YES {Blank String}     Description of the fields condition_entry mediumint(8) unsigned Identifier type tinyint(3) Type of the condition: ID Type Description -3 CONDITION_NOT Used to evaluate if another condition is NOT true. See Note 1 -2 CONDITION_OR Used to evaluate if condition OR condition is true. See Note 1 -1 CONDITION_AND Used to evaluate if condition AND condition is true. See Note 1 0 CONDITION_NONE This condition is not used at all. Always returns true. 1 CONDITION_AURA Checks target currently has the specified aura on him/her. 2 CONDITION_ITEM Checks if the player has the required amount (value2) of items in his/hers inventory. 3 CONDITION_ITEM_EQUIPPED Checks if the player has the specified item equipped. 4 CONDITION_AREAID Checks if the player is within the specified area/zone. 5 CONDITION_REPUTATION_RANK_MIN Checks if the player has the minimum required reputation rank with a specific faction. 6 CONDITION_TEAM Checks what team the target is a member of (Alliance or Horde). 7 CONDITION_SKILL Checks if the player has the required minimum skill value of the specified skill. 8 CONDITION_QUESTREWARDED Checks if the player has complete the specified quest. 9 CONDITION_QUESTTAKEN Checks if the player has taken the quest (as in has it in his/hers quest log.) and not completed it yet. 10 CONDITION_AD_COMMISSION_AURA TODO 11 CONDITION_NO_AURA Checks if the target DOES NOT currently have the specified aura on him/her. 12 CONDITION_ACTIVE_GAME_EVENT Checks if a game event is currently active. 13 CONDITION_AREA_FLAG Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) 14 CONDITION_RACE_CLASS Checks if the target is a certain race AND/OR class. 15 CONDITION_LEVEL Checks the targets level. 16 CONDITION_NOITEM Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. 17 CONDITION_SPELL Checks if the target has or hasn't (value2) the specified spell. 18 CONDITION_INSTANCE_SCRIPT SD3 based condition 19 CONDITION_QUESTAVAILABLE Checks if the specified quest is available (can start it) for the player. 20 CONDITION_ACHIEVEMENT Has or has no special achievement. 21 CONDITION_ACHIEVEMENT_REALM Realm wide achievement (like 20 above but realm wide). 22 CONDITION_QUEST_NONE Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. 23 CONDITION_ITEM_WITH_BANK Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. 24 CONDITION_NOITEM_WITH_BANK Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. 25 CONDITION_NOT_ACTIVE_GAME_EVENT Checks if a game event is currently NOT active. 26 CONDITION_ACTIVE_HOLIDAY Checks if a holiday is active 27 CONDITION_NOT_ACTIVE_HOLIDAY Checks if a holiday is not active 28 CONDITION_LEARNABLE_ABILITY Checks if the player can learn ability - using minimum skill value from [See SkillLineAbility.dbc] If the player has spell or has item (when defined) the condition will evaluate to false. 29 CONDITION_SKILL_BELOW TODO 30 CONDITION_REPUTATION_RANK_MAX Checks if the player has a higher reputation rank than specified a faction. 31 CONDITION_COMPLETED_ENCOUNTER Checks if an encounter has been completed. 32 CONDITION_SOURCE_AURA Checks if the source of the condition (like looted npc) has an aura. 33 CONDITION_LAST_WAYPOINT Checks the waypoint-state of the source of the condition. 34 CONDITION_XP_USER Checks if a player has turned XP earning on/off 35 CONDITION_GENDER Checks the gender of a player. 36 CONDITION_DEAD_OR_AWAY TODO 37 CONDITION_CREATURE_IN_RANGE TODO 38 CONDITION_PVP_SCRIPT TODO 39 CONDITION_SPAWN_COUNT Returns if specified count of creature entry exists on map. 36 CONDITION_DEAD_OR_AWAY Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. Note 1: Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as: value1 (as condition_entry) AND / OR value2 (as condition_entry). With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) value1 mediumint(8) unsigned Data field One for the condition. value2 mediumint(8) unsigned Data field Two for the condition. comments varchar(200) auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  23. antz

    conditions

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'conditions' table for MaNGOSZero With this table and the new conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) Used in: DBScript gossip_menu gossip_menu_option npc_spellclick_spells spell_area areatrigger_teleport Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes condition_entry mediumint(8) unsigned NO PRI NULL 'auto_increment' Identifier type tinyint(3) NO MUL '0'   Type of the condition. value1 mediumint(8) unsigned NO '0'   Data field One for the condition. value2 mediumint(8) unsigned NO '0'   Data field Two for the condition. comments varchar(200) YES {Blank String}   Detailed description of available condition types The meaning of the values Description of the fields condition_entry mediumint(8) unsigned Identifier type tinyint(3) Type of the condition: ID Type Description -3 CONDITION_NOT Used to evaluate if another condition is NOT true. See Note 1 -2 CONDITION_OR Used to evaluate if condition OR condition is true. See Note 1 -1 CONDITION_AND Used to evaluate if condition AND condition is true. See Note 1 0 CONDITION_NONE This condition is not used at all. Always returns true. 1 CONDITION_AURA Checks target currently has the specified aura on him/her. 2 CONDITION_ITEM Checks if the player has the required amount (value2) of items in his/hers inventory. 3 CONDITION_ITEM_EQUIPPED Checks if the player has the specified item equipped. 4 CONDITION_AREAID Checks if the player is within the specified area/zone. 5 CONDITION_REPUTATION_RANK_MIN Checks if the player has the minimum required reputation rank with a specific faction. 6 CONDITION_TEAM Checks what team the target is a member of (Alliance or Horde). 7 CONDITION_SKILL Checks if the player has the required minimum skill value of the specified skill. 8 CONDITION_QUESTREWARDED Checks if the player has complete the specified quest. 9 CONDITION_QUESTTAKEN Checks if the player has taken the quest (as in has it in his/hers quest log.) and not completed it yet. 10 CONDITION_AD_COMMISSION_AURA TODO 11 CONDITION_NO_AURA Checks if the target DOES NOT currently have the specified aura on him/her. 12 CONDITION_ACTIVE_GAME_EVENT Checks if a game event is currently active. 13 CONDITION_AREA_FLAG Checks if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) 14 CONDITION_RACE_CLASS Checks if the target is a certain race AND/OR class. 15 CONDITION_LEVEL Checks the targets level. 16 CONDITION_NOITEM Checks if the player DOES NOT have the required amount (value2) of items in his/hers inventory. 17 CONDITION_SPELL Checks if the target has or hasn't (value2) the specified spell. 18 CONDITION_INSTANCE_SCRIPT SD3 based condition 19 CONDITION_QUESTAVAILABLE Checks if the specified quest is available (can start it) for the player. 20 CONDITION_ACHIEVEMENT Has or has no special achievement. 21 CONDITION_ACHIEVEMENT_REALM Realm wide achievement (like 20 above but realm wide). 22 CONDITION_QUEST_NONE Checks if the player has NOT taken the quest AND has NOT been rewarded for the quest. 23 CONDITION_ITEM_WITH_BANK Checks if the player has the required amount (value2) of items in his/hers inventory OR bank. 24 CONDITION_NOITEM_WITH_BANK Checks if the player DOES NOT have count (value2) of items in his/hers inventory OR bank. 25 CONDITION_NOT_ACTIVE_GAME_EVENT Checks if a game event is currently NOT active. 26 CONDITION_ACTIVE_HOLIDAY Checks if a holiday is active 27 CONDITION_NOT_ACTIVE_HOLIDAY Checks if a holiday is not active 28 CONDITION_LEARNABLE_ABILITY Checks if the player can learn ability - using minimum skill value from [See SkillLineAbility.dbc] If the player has spell or has item (when defined) the condition will evaluate to false. 29 CONDITION_SKILL_BELOW TODO 30 CONDITION_REPUTATION_RANK_MAX Checks if the player has a higher reputation rank than specified a faction. 31 CONDITION_COMPLETED_ENCOUNTER Checks if an encounter has been completed. 32 CONDITION_SOURCE_AURA Checks if the source of the condition (like looted npc) has an aura. 33 CONDITION_LAST_WAYPOINT Checks the waypoint-state of the source of the condition. 34 CONDITION_XP_USER Checks if a player has turned XP earning on/off 35 CONDITION_GENDER Checks the gender of a player. 36 CONDITION_DEAD_OR_AWAY TODO 37 CONDITION_CREATURE_IN_RANGE TODO 38 CONDITION_PVP_SCRIPT TODO 39 CONDITION_SPAWN_COUNT Returns if specified count of creature entry exists on map. 36 CONDITION_DEAD_OR_AWAY Checks if a player, a player's group, all players in an instance, or a creature is dead or left the map. Note 1: Meta-Condition types CONDITION_AND (-1) and CONDITION_OR (-2) which are used as: value1 (as condition_entry) AND / OR value2 (as condition_entry). With these meta-conditions it is possible to create tree like and very complicated combined conditions (like HasAura && (HasItem || HasQuest)) value1 mediumint(8) unsigned Data field One for the condition. value2 mediumint(8) unsigned Data field Two for the condition. comments varchar(200) Detailed description of available condition types The meaning of the values in value1 / value2 depend of the type of the condition Value CONDITION_TYPE Name Value1 Value2 Notes & Return value -3 CONDITION_NOT condition_entry   Must have higher condition_entry than value1 Returns NOT condition (of value1) -2 CONDITION_OR condition_entry condition_entry Must have higher condition_entry than value1 OR value2 Returns condition (of value1) OR condition (of value2) -1 CONDITION_AND condition_entry condition_entry Must have higher condition_entry than value1 OR value2 Returns condition (of value1) AND condition (of value2) 0 CONDITION_NONE     No condition, is always met True 1 CONDITION_AURA The spell ID from where the aura came from. The effect index of the spell that applied the aura (0, 1, or 2) Returns if a player has an aura 2 CONDITION_ITEM Item ID Count Returns if a player has Count items in his inventory 3 CONDITION_ITEM_EQUIPPED Item ID   Returns if a player has an item equipped 4 CONDITION_AREAID Area ID 0, 1 (0: in (sub)area, 1: not in (sub)area) Returns if (or if not depending on value2) a player is in an area/zone 5 CONDITION_REPUTATION_RANK_MIN Faction ID Minimum rank Returns if a player has at least (>=) minimum rank at the given faction. See Ranks below. 6 CONDITION_TEAM Player team (469 - Alliance, 67 - Horde)   Returns if a player has the team of value1 7 CONDITION_SKILL Skill ID [See SkillLine.dbc] Skill value needed Returns if a player has Skill ID of value 8 CONDITION_QUESTREWARDED Quest ID   Returns if a player already got a quest rewarded 9 CONDITION_QUESTTAKEN Quest ID 0,1 or 2 0 - Returns true if quest is taken, no matter if completed or not1 - Returns true if quest is taken but not completed 2 - Returns true if quest is taken and completed 10 CONDITION_AD_COMMISSION_AURA     Returns if a Player has any Argent Dawn Commission Aura Active (17670,23930,24198,29112,29113) 11 CONDITION_NO_AURA spellid EffectIndex Returns if a player has not an aura 12 CONDITION_ACTIVE_EVENT event   Returns if a event is active 13 CONDITION_AREA_FLAG area_flag not_have_flag Returns if area_flag is present in current area (if area_flag set != 0) AND if not_have_flag is not present in current area (if not_have_flag != 0) 14 CONDITION_RACE_CLASS race_mask class_mask Returns if a player is of race (if race_mask set != 0) AND if a player is of class (if class_mask != 0) See Races & Classes below. 15 CONDITION_LEVEL level 0,1 or 2 0: equal to 1: equal or higher than 2: equal or less than Returns if a player is of/ has a higher/ has a lower level 16 CONDITION_NOITEM itemid count Returns if a player has not count items in Inventory 17 CONDITION_SPELL spellid 0,1 0: has spell 1: does not have spell Returns if a player has (not) learned a spell. 18 CONDITION_INSTANCE_SCRIPT instance_condition_id   see InstanceData.h enum InstanceConditionIDsTo 'communicate' with the instance script, there are a few instance_condition_id predefined, which can be used for hard-mode loot (0: normal, 1: Hard, 2: Harder mode), review the Instance conditions table below. Returns the result of the current instance's instance-script function CheckConditionCriteriaMeet (which must be implemented for such an instance) 19 CONDITION_QUESTAVAILABLE questid   Returns if a player could start a quest (ie. if all requirements for accepting like pre-quests are met) 20 CONDITION_ACHIEVEMENT achievementid 0,1 0: has achievement 1: has no achievement Returns if a player has (not) earned an achievement 21 CONDITION_ACHIEVEMENT_REALM achievementid 0,1 0: has achievement 1: has no achievement Returns if an achivement was (not) already earned by any player on the realm 22 CONDITION_QUEST_NONE questid   Returns if a player has a quest neither taken nor ever rewarded 23 CONDITION_ITEM_WITH_BANK item_id count Returns if a player has at least count of items (including inventory stored in the bank) 24 CONDITION_NOITEM_WITH_BANK item_id count Returns if a player has less than count of items (including inventory stored in the bank) 25 CONDITION_NOT_ACTIVE_GAME_EVENT event_id   Returns if a game event is not active. 26 CONDITION_ACTIVE_HOLIDAY holiday_id   Returns if a holiday is active. 27 CONDITION_NOT_ACTIVE_HOLIDAY holiday_id   Returns if a holiday is not active. 28 CONDITION_LEARNABLE_ABILITY spell_id 0 or item_id Returns player can learn ability using min skill value from (See SkillLineAbility.dbc). Item_id can be defined in addition, to check if player has one (1) item in inventory or bank.When player has spell or has item (when defined), condition return false. 29 CONDITION_SKILL_BELOW skill_id skill_value Returns if player has skill skill_id and skill less than (and not equal) skill_value (for skill_value > 1) If skill_value == 1, then true if player does not have skill skill_id 30 CONDITION_REPUTATION_RANK_MAX faction_id max_rank refer to the Ranks table below. Returns if a player has at most (
  24. antz

    account_data

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'account_data' table for MaNGOSThree Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes account int(11) unsigned NO PRI '0'     type int(11) unsigned NO PRI '0'     time bigint(11) unsigned NO '0'     data longblob NO NULL     Description of the fields account int(11) unsigned type int(11) unsigned time bigint(11) unsigned data longblob auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  25. antz

    ahbot_category

     NOTE:  This page is auto-generated from the MAGNET DBDocs module,             Any changes made directly to this page will be lost when it is regenerated. Description of the 'ahbot_category' table for MaNGOSThree Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id bigint(20) NO PRI NULL 'auto_increment'   category varchar(45) YES MUL {Blank String}     multiplier decimal(20,2) NO NULL     max_auction_count bigint(20) NO NULL     expire_time bigint(20) NO NULL     Description of the fields id bigint(20) Notes: Unique identifier of the category category varchar(45) Notes: An Item category Id multiplier decimal(20,2) Notes: The cost multiplier max_auction_count bigint(20) Notes: The max number of items of this category in the AH. expire_time bigint(20) Notes: The UNIX time when the item will expire. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...