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_event' table for MaNGOSZero This table holds information on what events (or procs) certain spells are activated. All spells in this table must have apply a SPELL_AURA_PROC_TRIGGER_SPELL (42) aura. Any nonzero entries in this table will overwrite the existing proc settings in the spell's DBC entry. 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' Spell ID [See Spell.dbc]. SchoolMask tinyint(4) unsigned NO '0' Spell school mask. SpellFamilyName smallint(5) unsigned NO '0' Spell family name. SpellFamilyMask0 bigint(40) unsigned NO '0' Spell family mask for effect 0. SpellFamilyMask1 bigint(40) unsigned NO '0' Spell family mask for effect 1. SpellFamilyMask2 bigint(40) unsigned NO '0' Spell family mask for effect 2. procFlags int(10) unsigned NO '0' Flags defining conditions for aura to proc. procEx int(10) unsigned NO '0' Flags refining proc condition. ppmRate float NO '0' Proc frequency limit. CustomChance float NO '0' Chance of proc. Cooldown int(10) unsigned NO '0' Cooldown (in msec). Description of the fields entry mediumint(8) unsigned Spell ID [See Spell.dbc] of the aura that may proc during another spellcast or under other conditions defined in this table. SchoolMask tinyint(4) unsigned Spell school mask. Spell School is defined in in the second field of Spell.dbc entry. This value is the bitmask [See enum SpellSchoolMask in SharedDefines.h], where different schools may be combined. Name Value SPELL_SCHOOL_MASK_NORMAL 1 SPELL_SCHOOL_MASK_HOLY 2 SPELL_SCHOOL_MASK_FIRE 4 SPELL_SCHOOL_MASK_NATURE 8 SPELL_SCHOOL_MASK_FROST 16 SPELL_SCHOOL_MASK_SHADOW 32 SPELL_SCHOOL_MASK_ARCANE 64 Note: Multiple school masks can be combined to have spell trigger on more than one spell school. SpellFamilyName smallint(5) unsigned Spell family name classifies the spell as intended mostly for specific character class, see enum SpellFamily in DBCEnums.h. The field is defined for each spell in Spell.dbc, see SpellFamilyName field of struct SpellEntry in DBCStructure.h. Name Value SPELLFAMILY_GENERIC 0 SPELLFAMILY_ENVIRONMENT 1 SPELLFAMILY_MAGE 3 SPELLFAMILY_WARRIOR 4 SPELLFAMILY_WARLOCK 5 SPELLFAMILY_PRIEST 6 SPELLFAMILY_DRUID 7 SPELLFAMILY_ROGUE 8 SPELLFAMILY_HUNTER 9 SPELLFAMILY_PALADIN 10 SPELLFAMILY_SHAMAN 11 SPELLFAMILY_POTION 13 SpellFamilyMask0 bigint(40) unsigned Spell family mask for EFFECT_0. The SpellFamilyMask is a 64-bit value defined for each spell in Spell.dbc [See SpellFamilyFlags field of struct SpellEntry in DBCStructure.h]. It classifies the spell into a group within each SpellFamilyName, presenting a simple way to recognizing spells, for example, one spell of different ranks. The 64-bit values are defined in the sources as UI64LIT() type. SpellFamilyMask1 bigint(40) unsigned Spell family mask for EFFECT_1. The SpellFamilyMask is a 64-bit value defined for each spell in Spell.dbc [See SpellFamilyFlags field of struct SpellEntry in DBCStructure.h]. It classifies the spell into a group within each SpellFamilyName, presenting a simple way to recognizing spells, for example, one spell of different ranks. The 64-bit values are defined in the sources as UI64LIT() type. SpellFamilyMask2 bigint(40) unsigned Spell family mask for EFFECT_2. The SpellFamilyMask is a 64-bit value defined for each spell in Spell.dbc [See SpellFamilyFlags field of struct SpellEntry in DBCStructure.h]. It classifies the spell into a group within each SpellFamilyName, presenting a simple way to recognizing spells, for example, one spell of different ranks. The 64-bit values are defined in the sources as UI64LIT() type. procFlags int(10) unsigned Bitmask defining conditions for aura to proc. Values may be combined by adding. If equals to 0, the value form Spell.dbc is used. Name Value (hex) Meaning PROC_FLAG_KILLED 0x00000001 00 Killed by aggressor PROC_FLAG_KILL 0x00000002 01 Kill target (in most cases need XP/Honor reward, see Unit::IsTriggeredAtSpellProcEvent for additinoal check) PROC_FLAG_SUCCESSFUL_MELEE_HIT 0x00000004 02 Successful melee auto attack PROC_FLAG_TAKEN_MELEE_HIT 0x00000008 03 Taken damage from melee auto attack hit PROC_FLAG_SUCCESSFUL_MELEE_SPELL_HIT 0x00000010 04 Successful attack by Spell that use melee weapon PROC_FLAG_TAKEN_MELEE_SPELL_HIT 0x00000020 05 Taken damage by Spell that use melee weapon PROC_FLAG_SUCCESSFUL_RANGED_HIT 0x00000040 06 Successful Ranged auto attack PROC_FLAG_TAKEN_RANGED_HIT 0x00000080 07 Taken damage from ranged auto attack PROC_FLAG_SUCCESSFUL_RANGED_SPELL_HIT 0x00000100 08 Successful Ranged attack by Spell that use ranged weapon PROC_FLAG_TAKEN_RANGED_SPELL_HIT 0x00000200 09 Taken damage by Spell that use ranged weapon PROC_FLAG_SUCCESSFUL_POSITIVE_AOE_HIT 0x00000400 10 Successful AoE (not 100% sure unused) PROC_FLAG_TAKEN_POSITIVE_AOE 0x00000800 11 Taken AoE (not 100% sure unused) PROC_FLAG_SUCCESSFUL_AOE_SPELL_HIT 0x00001000 12 Successful AoE damage spell hit (not 100% sure unused) PROC_FLAG_TAKEN_AOE_SPELL_HIT 0x00002000 13 Taken AoE damage spell hit (not 100% sure unused) PROC_FLAG_SUCCESSFUL_POSITIVE_SPELL 0x00004000 14 Successful cast positive spell (by default only on healing) PROC_FLAG_TAKEN_POSITIVE_SPELL 0x00008000 15 Taken positive spell hit (by default only on healing) PROC_FLAG_SUCCESSFUL_NEGATIVE_SPELL_HIT 0x00010000 16 Successful negative spell cast (by default only on damage) PROC_FLAG_TAKEN_NEGATIVE_SPELL_HIT 0x00020000 17 Taken negative spell (by default only on damage) PROC_FLAG_ON_DO_PERIODIC 0x00040000 18 Successful do periodic (damage / healing, determined by PROC_EX_PERIODIC_POSITIVE or negative if no procEx) PROC_FLAG_ON_TAKE_PERIODIC 0x00080000 19 Taken spell periodic (damage / healing, determined by PROC_EX_PERIODIC_POSITIVE or negative if no procEx) PROC_FLAG_TAKEN_ANY_DAMAGE 0x00100000 20 Taken any damage PROC_FLAG_ON_TRAP_ACTIVATION 0x00200000 21 On trap activation PROC_FLAG_TAKEN_OFFHAND_HIT 0x00400000 22 Taken off-hand melee attacks (not used) PROC_FLAG_SUCCESSFUL_OFFHAND_HIT 0x00800000 23 Successful off-hand melee attacks procEx int(10) unsigned Flags refining proc condition, optional. Name Value (hex) PROC_EX_NONE 0x0000000 PROC_EX_NORMAL_HIT 0x0000001 PROC_EX_CRITICAL_HIT 0x0000002 PROC_EX_MISS 0x0000004 PROC_EX_RESIST 0x0000008 PROC_EX_DODGE 0x0000010 PROC_EX_PARRY 0x0000020 PROC_EX_BLOCK 0x0000040 PROC_EX_EVADE 0x0000080 PROC_EX_IMMUNE 0x0000100 PROC_EX_DEFLECT 0x0000200 PROC_EX_ABSORB 0x0000400 PROC_EX_REFLECT 0x0000800 PROC_EX_INTERRUPT 0x0001000 PROC_EX_EX_TRIGGER_ALWAYS 0x0010000 PROC_EX_EX_ONE_TIME_TRIGGER 0x0020000 PROC_EX_PERIODIC_POSITIVE 0x0040000 ppmRate float The value limits the proc frequency. For melee (ranged?) damage spells it is the proc rate per minute. The actual proc may happen less frequently but not more frequently than defined here. If zero, falls back to flat chance from Spell.dbc. CustomChance float Chance of proc. If equals to 0, the standard value from Spell.dbc is used, else overrides it. Mostly used for spell debugging when it is convenient to set the chance to 100%. Cooldown int(10) unsigned A hidden cooldown used for some spell proc events, applied to _triggered_spell_. 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_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