Jump to content

antz

Community Manager
  • Posts

    2806
  • Joined

  • Last visited

  • Days Won

    89
  • Donations

    0.00 GBP 

Everything posted by antz

  1. @jwh1981 - I have just submitted a fix for the gameobject issues.
  2. antz

    script_binding

    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 'script_binding' table for MaNGOSTwo This tables links SD3 scripts to entries in the main world Database Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes type tinyint(2) unsigned NO MUL NULL The Type of Scripted Object Type ScriptName char(64) NO PRI {Blank String} Script name, to be unique across all types bind mediumint(10) NO PRI NULL Bound to entry (>0) or GUID ( data tinyint(2) unsigned YES '0' Misc data; Effect number for spellscripts Description of the fields type tinyint(2) unsigned Enum Value Description SCRIPTED_UNIT 0 CreatureScript SCRIPTED_GAMEOBJECT 1 GameObjectScript SCRIPTED_ITEM 2 ItemScript SCRIPTED_AREATRIGGER 3 AreaTriggerScript SCRIPTED_SPELL 4 SpellScript SCRIPTED_AURASPELL 5 AuraScript SCRIPTED_MAPEVENT 6 MapEventScript SCRIPTED_MAP 7 ZoneScript SCRIPTED_BATTLEGROUND 8 BattleGroundScript SCRIPTED_PVP_ZONE 9 OutdoorPvPScript SCRIPTED_INSTANCE 10 InstanceScript SCRIPTED_CONDITION 11 ConditionScript SCRIPTED_ACHIEVEMENT 12 AchievementScript ScriptName char(64) The Name of the script bind mediumint(10) The ID to link to. data tinyint(2) unsigned Notes: Misc data; Effect number for spellscripts auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  3. antz

    script_binding

    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 'script_binding' table for MaNGOSZero This tables links SD3 scripts to entries in the main world Database Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes type tinyint(2) unsigned NO MUL NULL The Type of Scripted Object Type ScriptName char(64) NO PRI {Blank String} Script name, to be unique across all types bind mediumint(10) NO PRI NULL Bound to entry (>0) or GUID ( data tinyint(2) unsigned YES '0' Misc data; Effect number for spellscripts Description of the fields type tinyint(2) unsigned Enum Value Description SCRIPTED_UNIT 0 CreatureScript SCRIPTED_GAMEOBJECT 1 GameObjectScript SCRIPTED_ITEM 2 ItemScript SCRIPTED_AREATRIGGER 3 AreaTriggerScript SCRIPTED_SPELL 4 SpellScript SCRIPTED_AURASPELL 5 AuraScript SCRIPTED_MAPEVENT 6 MapEventScript SCRIPTED_MAP 7 ZoneScript SCRIPTED_BATTLEGROUND 8 BattleGroundScript SCRIPTED_PVP_ZONE 9 OutdoorPvPScript SCRIPTED_INSTANCE 10 InstanceScript SCRIPTED_CONDITION 11 ConditionScript SCRIPTED_ACHIEVEMENT 12 AchievementScript ScriptName char(64) The Name of the script bind mediumint(10) The ID to link to. data tinyint(2) unsigned Notes: Misc data; Effect number for spellscripts auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  4. antz

    script_binding

    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 'script_binding' table for MaNGOSOne 'SD2 Script Names and Binding' Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes type tinyint(2) unsigned NO MUL NULL The Type of Scripted Object Type ScriptName char(64) NO PRI {Blank String} Script name, to be unique across all types bind mediumint(10) NO PRI NULL Bound to entry (>0) or GUID ( data tinyint(2) unsigned YES '0' Misc data; Effect number for spellscripts Description of the fields type tinyint(2) unsigned Enum Value Description SCRIPTED_UNIT 0 CreatureScript SCRIPTED_GAMEOBJECT 1 GameObjectScript SCRIPTED_ITEM 2 ItemScript SCRIPTED_AREATRIGGER 3 AreaTriggerScript SCRIPTED_SPELL 4 SpellScript SCRIPTED_AURASPELL 5 AuraScript SCRIPTED_MAPEVENT 6 MapEventScript SCRIPTED_MAP 7 ZoneScript SCRIPTED_BATTLEGROUND 8 BattleGroundScript SCRIPTED_PVP_ZONE 9 OutdoorPvPScript SCRIPTED_INSTANCE 10 InstanceScript SCRIPTED_CONDITION 11 ConditionScript SCRIPTED_ACHIEVEMENT 12 AchievementScript ScriptName char(64) The Name of the script bind mediumint(10) The ID to link to. data tinyint(2) unsigned Notes: Misc data; Effect number for spellscripts auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  5. We are currently investigating what is going on
  6. antz

    spell_area

    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 'spell_area' table for MaNGOSTwo This table holds information on what spells are applied to npcs/players in some areas. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes spell mediumint(8) unsigned NO PRI '0' Spell ID [See Spell.dbc]. area mediumint(8) unsigned NO PRI '0' Area ID [See AreaTable.dbc]. quest_start mediumint(8) unsigned NO PRI '0' Quest ID [See quest_template.entry]. quest_start_active tinyint(1) unsigned NO PRI '0' Flag for quest_start. quest_end mediumint(8) unsigned NO '0' Quest ID [See quest_template.entry]. condition_id mediumint(8) unsigned NO '0' Condition ID [See conditions.condition_entry]. aura_spell mediumint(8) NO PRI '0' Spell ID [See Spell.dbc]. racemask mediumint(8) unsigned NO PRI '0' Race mask value. gender tinyint(1) unsigned NO PRI '2' The gender of characters to which the spell is applied. autocast tinyint(1) unsigned NO '0' Autocast flag. Description of the fields spell mediumint(8) unsigned Spell ID, see Spell.dbc. The spell is either cast on the character or allows the character to cast. area mediumint(8) unsigned Area ID, see AreaTable.dbc. If equals to 0, is not limited to any zone. quest_start mediumint(8) unsigned Quest ID [See quest_template.entry] that should be either active or rewarded. quest_start_active tinyint(1) unsigned If set, this flag allows the quest mentioned in the quest_start field to be rewarded, not only be active. quest_end mediumint(8) unsigned Quest ID [See quest_template.entry] of the quest that should not be rewarded. condition_id mediumint(8) unsigned Condition ID [See conditions.condition_entry] of the condition which should be fulfilled. aura_spell mediumint(8) Spell ID [See Spell.dbc] of the aura spell which the character should already have applied (if positive) or do not have (if negative). racemask mediumint(8) unsigned Race mask value. The entries may be combined by simple adding. Race Mask Value (hex) Mask Value (dec) Human 0x1 1 Orc 0x2 2 Dwarf 0x4 4 Night Elf 0x8 8 Undead 0x10 16 Tauren 0x20 32 Gnome 0x40 64 Troll 0x80 128 Goblin 0x100 256 Blood Elf 0x200 512 Dranei 0x400 1024 gender tinyint(1) unsigned The gender of characters to which the spell is applied. The following table list available values. Gender of the creature Value Gender 0 Male 1 Female 2 Both autocast tinyint(1) unsigned If set, this flag requires the spell to be cast on the character as they enter the area. If unset, the spell is enabled for the character to cast. auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  7. antz

    spell_area

    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 'spell_area' table for MaNGOSFour This table holds information on what spells are applied to npcs/players in some areas. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes spell mediumint(8) unsigned NO PRI '0' Spell ID [See Spell.dbc]. area mediumint(8) unsigned NO PRI '0' Area ID [See AreaTable.dbc]. quest_start mediumint(8) unsigned NO PRI '0' Quest ID [See quest_template.entry]. quest_start_active tinyint(1) unsigned NO PRI '0' Flag for quest_start. quest_end mediumint(8) unsigned NO '0' Quest ID [See quest_template.entry]. condition_id mediumint(8) unsigned NO '0' Condition ID [See conditions.condition_entry]. aura_spell mediumint(8) NO PRI '0' Spell ID [See Spell.dbc]. racemask mediumint(8) unsigned NO PRI '0' Race mask value. gender tinyint(1) unsigned NO PRI '2' The gender of characters to which the spell is applied. autocast tinyint(1) unsigned NO '0' Autocast flag. Description of the fields spell mediumint(8) unsigned Spell ID, see Spell.dbc. The spell is either cast on the character or allows the character to cast. area mediumint(8) unsigned Area ID, see AreaTable.dbc. If equals to 0, is not limited to any zone. quest_start mediumint(8) unsigned Quest ID [See quest_template.entry] that should be either active or rewarded. quest_start_active tinyint(1) unsigned If set, this flag allows the quest mentioned in the quest_start field to be rewarded, not only be active. quest_end mediumint(8) unsigned Quest ID [See quest_template.entry] of the quest that should not be rewarded. condition_id mediumint(8) unsigned Condition ID [See conditions.condition_entry] of the condition which should be fulfilled. aura_spell mediumint(8) Spell ID [See Spell.dbc] of the aura spell which the character should already have applied (if positive) or do not have (if negative). racemask mediumint(8) unsigned Race mask value. The entries may be combined by simple adding. Race Mask Value (hex) Mask Value (dec) Human 0x1 1 Orc 0x2 2 Dwarf 0x4 4 Night Elf 0x8 8 Undead 0x10 16 Tauren 0x20 32 Gnome 0x40 64 Troll 0x80 128 Goblin 0x100 256 Blood Elf 0x200 512 Dranei 0x400 1024 gender tinyint(1) unsigned The gender of characters to which the spell is applied. The following table list available values. Gender of the creature Value Gender 0 Male 1 Female 2 Both autocast tinyint(1) unsigned If set, this flag requires the spell to be cast on the character as they enter the area. If unset, the spell is enabled for the character to cast. auto-generated by the getMaNGOS.eu MAGNET dbdocs module
  8. 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 MaNGOSFour 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
  9. antz

    Realmd

    The realms is common across all the cores, so you can use a version from any core. However, the furthest I was able to get to was the create character screen.
  10. Hi @biruni666, could you let me know which Client and Mangos version you are using and also some examples of Npc's for me to check ?
  11. Please note that extractors found elsewhere on the internet are unlikely to work with mangos. Please you build the project, compatible extractors are also built. These are the ones that should be used.
  12. Boost is not used in Mangos. Looking at your pathname, it mentions Trinity core - They are not part of Mangos and are a completely separate project.
  13. The build system can't find OpenSSL, all the messages mentioning:- 'SSL-EAY' are OpenSSL related
  14. I know several years ago that I user worked on getting mangos to compile and build on a raspberry pi. - At the time we implemented any changes suggested to help him. But I can't recall whether he ever got it fully running.
  15. This is not trivial, but can be done !! There is a script in the Database Repo Tools\cleanup folder called: characters_convert_s1099_to_11391.sql characters_item_duplicates_remove.sql characters_mail_items_cleanup.sql characters_pet_data_cleanup.sql Running each of these should theoretically upgrade the database to be compatible with MangosOne. - However, I am aware that this has not been tested in a long long time. If anyone is willing to give these a go and report back on the issues found, that will help us a lot.
  16. can you check something for me..... Inside your ServerZero folder, do you have the following folders: |-dep |-src | |-modules | | |-Eluna | | |-SD3 | |-realmd | |-tools | |-Extractor_projects |-win
  17. Please see my reply to this question: ----== Google Translate ==---- Bitte sehen Sie meine Antwort auf diese Frage:
  18. We use an online tool called Magnet to update the translations, or failing that you can apply updates directly to the GitHub repos. Any help is gladly appreciated.
  19. I am currently working on a permanent fix for this issue: As a temporary fix, you can apply the follow SQL to the realm DB's: For TBC: ALTER TABLE account MODIFY COLUMN `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Which maximum expansion content a user has access to.'; For Wotlk: ALTER TABLE account MODIFY COLUMN `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2' COMMENT 'Which maximum expansion content a user has access to.'; For Cata: ALTER TABLE account MODIFY COLUMN `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '3' COMMENT 'Which maximum expansion content a user has access to.';
  20. I have answered this in more detail in the post below:
  21. antz

    ZoneMusic

    NOTE: This page is auto-generated from the MAGNET DBCDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the DBC file 'ZoneMusic' for MaNGOSFive The zone music table contains definitions for ambience sounds to be played during day and night time in various areas. The file contents is read and mapped into the struct zonemusicEntry in the MaNGOS core. The field types and usage is defined in zonemusicfmt in the MaNGOS core. The File is currently *NOT USED* by the MaNGOS core. The Field definitions follow, No. of fields: 8 strong> Field Name Field Type Notes Id INT(11) Unique Id SetName TEXT The name of the ambient sound. SilenceIntervalMinDay INT(11) The minimum amount of milliseconds to wait before replaying the ambience sound during day time. SilenceIntervalMinNight INT(11) The minimum amount of milliseconds to wait before replaying the ambience sound during night time. SilenceIntervalMaxDay INT(11) The maximum amount of milliseconds to wait before replaying the ambience sound during day time. SilenceIntervalMaxNight INT(11) The maximum amount of milliseconds to wait before replaying the ambience sound during night time. daySoundEntryId INT(11) The sound entry being played during day time. nightSoundEntryId INT(11) The sound entry being played during night time. Description of the fields Id INT(11) Unique ID SetName TEXT The name of the ambient sound. SilenceIntervalMinDay INT(11) The minimum amount of milliseconds to wait before replaying the ambience sound during day time. SilenceIntervalMinNight INT(11) The minimum amount of milliseconds to wait before replaying the ambience sound during night time. SilenceIntervalMaxDay INT(11) The maximum amount of milliseconds to wait before replaying the ambience sound during day time. SilenceIntervalMaxNight INT(11) The maximum amount of milliseconds to wait before replaying the ambience sound during night time. daySoundEntryId INT(11) References the primary key of [SoundEntries.dbc]. nightSoundEntryId INT(11) References the primary key of [SoundEntries.dbc]. auto-generated by the getMaNGOS.eu MAGNET dbcdocs module
  22. antz

    zonelightpoint

    NOTE: This page is auto-generated from the MAGNET DBCDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the DBC file 'zonelightpoint' for MaNGOSFive The file contents is read and mapped into the struct zonelightpointEntry in the MaNGOS core. The field types and usage is defined in zonelightpointfmt in the MaNGOS core. The File is currently *NOT USED* by the MaNGOS core. The Field definitions follow, No. of fields: 5 strong> Field Name Field Type Notes col0 INT(11) col1 INT(11) col2 FLOAT col3 FLOAT col4 INT(11) Description of the fields col0 INT(11) col1 INT(11) col2 FLOAT col3 FLOAT col4 INT(11) auto-generated by the getMaNGOS.eu MAGNET dbcdocs module
  23. antz

    zonelight

    NOTE: This page is auto-generated from the MAGNET DBCDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the DBC file 'zonelight' for MaNGOSFive The file contents is read and mapped into the struct zonelightEntry in the MaNGOS core. The field types and usage is defined in zonelightfmt in the MaNGOS core. The File is currently *NOT USED* by the MaNGOS core. The Field definitions follow, No. of fields: 4 strong> Field Name Field Type Notes col0 INT(11) col1 TEXT col2 INT(11) col3 INT(11) Description of the fields col0 INT(11) col1 TEXT col2 INT(11) col3 INT(11) auto-generated by the getMaNGOS.eu MAGNET dbcdocs module
  24. NOTE: This page is auto-generated from the MAGNET DBCDocs module, Any changes made directly to this page will be lost when it is regenerated. Description of the DBC file 'ZoneIntroMusicTable' for MaNGOSFive This table contains definitions for ambience sounds to be played upon entering various areas. The file contents is read and mapped into the struct zoneintromusictableEntry in the MaNGOS core. The field types and usage is defined in zoneintromusictablefmt in the MaNGOS core. The File is currently *NOT USED* by the MaNGOS core. The Field definitions follow, No. of fields: 5 strong> Field Name Field Type Notes Id INT(11) Unique Id Name TEXT soundEntryId INT(11) Priority TEXT MinDelayMinutes INT(11) Description of the fields Id INT(11) Unique Id Name TEXT soundEntryId INT(11) Priority TEXT MinDelayMinutes INT(11) auto-generated by the getMaNGOS.eu MAGNET dbcdocs module
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use