antz

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_proc_item_enchant' table for MaNGOSZero This table holds information for proc chances of spells which enchant weapons. This also includes shaman weapon enchants. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes entry mediumint(8) unsigned NO PRI NULL Spell ID [See Spell.dbc]. ppmRate float NO '0' Proc frequency limit, per minute. Description of the fields entry mediumint(8) unsigned Spell ID [See Spell.dbc]. Should be the first rank spell if in the rank chain. ppmRate float The value (times per minute) limits the enchant proc frequency. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_target_position' table for MaNGOSZero This table holds coordinate information on where the player should be teleported to when a spell with effect SPELL_EFFECT_TELEPORT_UNITS. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id mediumint(8) unsigned NO PRI '0' The spell identifier. The value has to match with a defined spell identifier. target_map smallint(5) unsigned NO '0' The target map's identifier. target_position_x float NO '0' The X position on the target map. target_position_y float NO '0' The Y position on the target map. target_position_z float NO '0' The Z position on the target map. target_orientation float NO '0' The orientation for the character on the target map. Description of the fields id mediumint(8) unsigned The spell identifier. The value has to match with a defined spell identifier [See Spell.dbc]. target_map smallint(5) unsigned The target map's identifier. The value has to match with a defined map identifier [See Map.dbc]. target_position_x float The X position on the target map. target_position_y float The Y position on the target map. target_position_z float The Z position on the target map. target_orientation float The orientation for the character on the target map. This is measured in radians, 0 is north on the mini-map and pi is south on the mini-map etc. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_script_target' table for MaNGOSZero Used to control SpellEffect with ImpliciteTargetA-B == 7|8|38|40|46|52. These spell effects require a specific target in either alive or dead state (for creatures). Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes entry mediumint(8) unsigned NO PRI NULL Spell ID [See Spell.dbc]. type tinyint(3) unsigned NO PRI '0' Type of the target entry. targetEntry mediumint(8) unsigned NO PRI '0' Creature ID or Gameobject ID. inverseEffectMask mediumint(8) unsigned NO '0' Inverse effect mask. Description of the fields entry mediumint(8) unsigned Spell ID [See Spell.dbc] of the spell requiring external implicit target definition. The target type of a spelleffect has to be one of the following (look for the values at enum Targets in SharedDefines.h): TARGET_SCRIPT, TARGET_SCRIPT_COORDINATES, TARGET_FOCUS_OR_SCRIPTED_GAMEOBJECT, TARGET_AREAEFFECT_INSTANT, TARGET_AREAEFFECT_CUSTOM, TARGET_AREAEFFECT_GO_AROUND_SOURCE, TARGET_AREAEFFECT_GO_AROUND_DEST, TARGET_NARROW_FRONTAL_CONE type tinyint(3) unsigned Type of the target entry. Name Value SPELL_TARGET_TYPE_GAMEOBJECT 0 SPELL_TARGET_TYPE_CREATURE 1 SPELL_TARGET_TYPE_DEAD 2 targetEntry mediumint(8) unsigned Creature ID (creature_template.entry) or Gameobject ID (gameobject_template.entry) dependently on the type. inverseEffectMask mediumint(8) unsigned The bitmask (bits 0, 1, 2 corresponding to values 1, 2, 4) of the spell effect numbers that do not use this mechanic. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_threat' table for MaNGOSZero This table holds threat values on all spells that should either give or take away threat. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes entry mediumint(8) unsigned NO PRI NULL The spell identifier. Threat smallint(6) NO NULL The value of threat to add or remove from the characters threat. multiplier float NO '1' Any value here will modify the spells threat with the factor given here. ap_bonus float NO '0' Any value here will modify the spells attack power with the factor given here. Description of the fields entry mediumint(8) unsigned The spell identifier. The value has to match with a spell identifier defined [See Spell.dbc] Note: Any spell referenced is required to be rank 1 in the spell chain, and has to have threat values set in the original spell definition. Threat smallint(6) The value of threat to add to the characters threat, or to remove from a characters threat. Negative values reduce threat, positive values increase threat. multiplier float Any value here will modify the spells threat with the factor given here. ap_bonus float Any value here will modify the spells attack power with the factor given here. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'warden' table for MaNGOSZero This table contains the Warden Anti-cheat system checks. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id smallint(5) unsigned NO PRI NULL 'auto_increment' Unique Identifier groupid smallint(5) unsigned NO NULL Grouped Check ID build smallint(5) unsigned NO NULL Build Number type tinyint(3) unsigned YES NULL Check Type data varchar(48) NO {Blank String} str varchar(20) NO {Blank String} address int(10) unsigned NO '0' length tinyint(3) unsigned NO '0' result varchar(24) NO {Blank String} comment varchar(50) YES {Blank String} A description of what the check does Description of the fields id smallint(5) unsigned Unique Identifier groupid smallint(5) unsigned The Grouped Check ID, this should be unique per check and build build smallint(5) unsigned This is the build number that warden should check against. type tinyint(3) unsigned The type of check performed: Check Type Type (Hex) Type (Dec) Notes MEM_CHECK 0xF3 243 byte moduleNameIndex + uint Offset + byte Len (check to ensure memory isn't modified) PAGE_CHECK_A 0xB2 178 uint Seed + byte[20] SHA1 + uint Addr + byte Len (scans all pages for specified hash) PAGE_CHECK_B 0xBF 191 uint Seed + byte[20] SHA1 + uint Addr + byte Len (scans only pages starts with MZ+PE headers for specified hash) MPQ_CHECK 0x98 152 byte fileNameIndex (check to ensure MPQ file isn't modified) LUA_STR_CHECK 0x8B 139 byte luaNameIndex (check to ensure LUA string isn't used) DRIVER_CHECK 0x71 113 uint Seed + byte[20] SHA1 + byte driverNameIndex (check to ensure driver isn't loaded) TIMING_CHECK 0x57 87 empty (check to ensure GetTickCount() isn't detoured) PROC_CHECK 0x7E 126 uint Seed + byte[20] SHA1 + byte moluleNameIndex + byte procNameIndex + uint Offset + byte Len (check to ensure proc isn't detoured) MODULE_CHECK 0xD9 217 uint Seed + byte[20] SHA1 (check to ensure module isn't injected) data varchar(48) str varchar(20) address int(10) unsigned length tinyint(3) unsigned result varchar(24) comment varchar(50) A description of what the check does auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'transports' table for MaNGOSZero This table contains all type 15 transports (Boats and Zeppelins). All other transport types have their frame time read from TransportAnimation.dbc. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes entry mediumint(8) unsigned NO PRI '0' This references the Gameobject Template table's unique ID. name text YES NULL A name describing the transport. period mediumint(8) unsigned NO '0' This is the amount of time that it take for the transport to make one full pass. Description of the fields entry mediumint(8) unsigned This references the Gameobject Template table's unique ID [See gameobject_template.entry] of the game object of type 15 (boats and Zeppelins) for which the entry is valid. name text A name describing the transport. This is not used in-game, but only here to ease locking up data. period mediumint(8) unsigned This is the amount of time that it take for the transport to make one full pass through all the frames in the TaxiNodes [See TaxiNodes.dbc]. When a client change occurs, usually this field must be updated. This values is set in milliseconds. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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_banned' table. This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI NULL The account ID [See account.id]. bandate bigint(40) NO PRI '0' The date when the account was banned, in Unix time. unbandate bigint(40) NO '0' The date when the account will be automatically unbanned. bannedby varchar(50) NO {Blank String} The character that banned the account. banreason varchar(255) NO {Blank String} The reason for the ban. active tinyint(4) NO '1' Is the ban is currently active or not. Description of the fields id int(11) unsigned The account ID [See account.id]. bandate bigint(40) The date when the account was banned, in Unix time. unbandate bigint(40) The date when the account will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban. bannedby varchar(50) The character with the rights to the .ban command that banned the account. banreason varchar(255) The reason for the ban. active tinyint(4) This is a Boolean field controlling if the ban is currently active or not. Value Meaning 0 Ban Active 1 Ban Inactive auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'db_version' table. This table holds the current version of the MaNGOS world database Table Notes This table uses the 'InnoDB' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes version int(3) NO PRI NULL The Version of the Release structure int(3) NO PRI NULL The current core structure level. content int(3) NO PRI NULL The current core content level. description varchar(30) NO {Blank String} A short description of the latest database revision. comment varchar(150) YES {Blank String} A comment about the latest database revision. Description of the fields version int(3) The Version of the Release, any mismatch prevents the server from starting. structure int(3) The current core structure level, any mismatch prevents the server from starting. content int(3) The current core content level, The server will start if there is a mismatch, but will issue a warning message description varchar(30) A short description of the latest database revision. comment varchar(150) A comment about the latest database revision. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'realmcharacters' table. This table holds information on the number of characters each account has for each realm. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes realmid int(11) unsigned NO PRI NULL The ID of the realm [See realmlist.id]. acctid int(11) unsigned NO PRI NULL The account ID [See account.id]. numchars tinyint(3) unsigned NO '0' The number of characters the account has on the realm. Description of the fields realmid int(11) unsigned The ID of the realm [See realmlist.id]. acctid int(11) unsigned The account ID [See account.id]. numchars tinyint(3) unsigned The number of characters the account has on the realm. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'ip_banned' table. This table contains all of the banned IPs and the date when (or if) the ban will expire. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes ip varchar(32) NO PRI '0.0.0.0' The IP address that is banned. bandate bigint(40) NO PRI NULL The date when the IP was first banned, in Unix time. unbandate bigint(40) NO NULL The date when the IP will be unbanned in Unix time. bannedby varchar(50) NO '[Console]' The name of the character that banned the IP. banreason varchar(255) NO 'no reason' The reason given for the IP ban. Description of the fields ip varchar(32) The IP address that is banned. bandate bigint(40) The date when the IP was first banned, in Unix time. unbandate bigint(40) The date when the IP will be unbanned in Unix time. Any date that is set lower than the current date basically classifies as a permanent ban as it will never auto expire. bannedby varchar(50) The name of the character that banned the IP. The character should belong to an account with the rights to the .ban command in-game. banreason varchar(255) The reason given for the IP ban. auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'realmlist' table. This table holds information for the realms. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes id int(11) unsigned NO PRI NULL 'auto_increment' The realm ID. name varchar(32) NO UNI {Blank String} The name of the realm. address varchar(32) NO '127.0.0.1' The public IP address of the world server. localAddress varchar(255) NO '127.0.0.1' The local IP address of the world server. localSubnetMask varchar(255) NO '255.255.255.0' The subnet mask used for the local network. port int(11) NO '8085' The port that the world server is running on. icon tinyint(3) unsigned NO '0' The icon of the realm. realmflags tinyint(3) unsigned NO '2' Supported masks for the realm. timezone tinyint(3) unsigned NO '0' The realm timezone. allowedSecurityLevel tinyint(3) unsigned NO '0' Minimum account [See account.gmlevel] required for accounts to log in. population float unsigned NO '0' Show the current population. realmbuilds varchar(64) NO {Blank String} The accepted client builds that the realm will accept. Description of the fields id int(11) unsigned The realm ID. This number is unique for every realm and it MUST correlate with the RealmID configuration value in mangosd.conf. name varchar(32) The name of the realm. This will appear in the realm selection list as well as in the character selection screen. address varchar(32) The public IP address of the world server. 127.0.0.1 works for LAN play only. localAddress varchar(255) The local IP address of the world server. 127.0.0.1 works for LAN play only. localSubnetMask varchar(255) The subnet mask used for the local network. By default this is 255.255.255.0 port int(11) The port that the world server is running on. Default is 8085. If you will run more than one world server on the same machine, e.g. develop and production, they will all need to use a different port. icon tinyint(3) unsigned The icon of the realm. Icon Meaning 0 Normal 1 PvP 4 Normal 6 RP 8 RP PvP realmflags tinyint(3) unsigned Supported masks for the realm, based on the table below. Value Meaning 0x1 Invalid - Do Not show in Realm List 0x2 Offline - Set by mangosd 0x4 Show version and build in Realm List 0x20 New Players - New Players Only 0x40 Recommended - sets the recommended option timezone tinyint(3) unsigned The realm timezone, it will be displayed in the tabs of the realmlist. TimezoneId Displayed Name 1 Development 2 United States 3 Oceanic 4 Latin America 5 Tournament 6 Korea 7 Tournament 8 English 9 German 10 French 11 Spanish 12 Russian 13 Tournament 14 Taiwan 15 Tournament 16 China 17 CN1 18 CN2 19 CN3 20 CN4 21 CN5 22 CN6 23 CN7 24 CN8 25 Tournament 26 Test Server 27 Tournament 28 QA Server 29 CN9 allowedSecurityLevel tinyint(3) unsigned The minimum account [See account.gmlevel] required for accounts to log in to this realm. Normally 0 - that means normal players allowed on this realm. Just useful if you make a GM-only developement realm. Changing this value will automatically update the visible in-game realm list, but the realm server must be restarted for it to take effect. population float unsigned This field shows the current population and is automatically updated at regular intervals and will . The formula to calculate the value in this field is: playerCount / maxPlayerCount * 2 Population Displayed Population Level 0.5 Low 1.0 Medium 2.0 High realmbuilds varchar(64) The accepted client builds that the realm will accept. (You can see this version at the clients left lower corner when starting.) The format is version No. {space} version No. (i.e. space separated) xxxx xxxx xxxx Acceptable values are: Core Build Number(s) Version Number MangosZero 5875 6005 6141 Vanila 1.12.x MangosOne 8606 TBC 2.4.3 MangosTwo 12340 WOTLK 3.3.5a MangosThree 15595 Cataclysm 4.3.4 MangosFour 18414 Mists of Pandaria 5.4.8 auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'uptime' table. This table holds the uptime of all realms. Each realm will automatically update it's latest entry's value until it crashes and a new record is added. Doing so also some statistical/historical information is collected - about the availability of your machine. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes realmid int(11) unsigned NO PRI NULL The realm id [See realmlist.id]. starttime bigint(20) unsigned NO PRI '0' The time when the server was started, in Unix time. startstring varchar(64) NO {Blank String} The time when the server started, formated as a readable string. uptime bigint(20) unsigned NO '0' The uptime of the server, in seconds. maxplayers smallint(5) unsigned NO '0' The maximum number of players connected Description of the fields realmid int(11) unsigned The realm id [See realmlist.id]. starttime bigint(20) unsigned The time when the server was started, in Unix time. startstring varchar(64) The time when the server started, formated as a readable string. uptime bigint(20) unsigned The uptime of the server, in seconds. maxplayers smallint(5) unsigned The maximum number of players connected auto-generated by the getMaNGOS.eu MAGNET dbdocs module

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 'warden_log' table. This table stores alerts raised by Warden from players actions. Table Notes This table uses the 'MyISAM' DB Engine The Field definitions follow: Field Name Field Type Nullable Key Default Value Attributes Notes entry int(11) unsigned NO PRI NULL 'auto_increment' Log entry ID check smallint(5) unsigned NO NULL Failed Warden check ID action tinyint(3) unsigned NO '0' Action taken (enum WardenActions) account int(11) unsigned NO NULL The account ID of the player. guid int(11) unsigned NO '0' Player GUID map int(11) unsigned YES NULL The map id. [See map.dbc] position_x float YES NULL The x location of the player. position_y float YES NULL The y location of the player. position_z float YES NULL The z location of the player. date timestamp NO 'CURRENT_TIMESTAMP' The date/time when the log entry was raised, in Unix time. Description of the fields entry int(11) unsigned Notes: Log entry ID check smallint(5) unsigned Notes: Failed Warden check ID action tinyint(3) unsigned Notes: Action taken (enum WardenActions) account int(11) unsigned The account ID of the player [See account.id]. guid int(11) unsigned Notes: Player GUID map int(11) unsigned The map id. The value has to match with a map identifier defined [See Map.dbc]. position_x float The x location of the player. position_y float The y location of the player. position_z float The z location of the player. date timestamp The date/time when the alert was raised, in Unix time. auto-generated by the getMaNGOS.eu MAGNET dbdocs module