Project Skyfire - User contributions [en]

SkyFire string 548

2026-01-25T00:00:36Z

Augustomendes4426: Created page with "{| align="right" |- | __TOC__ |} {{Back-to:World_18414}} The skyfire_string table This table holds information about about skyfire_strings in english or other locales. {| border="1" |- | '''Field''' | '''Type''' | '''Attributes''' | '''Key''' | '''Null''' | '''Default''' | '''Extra''' | '''Comment''' |- | entry | mediumint(7) | unsigned | PRI | NO | 0 | | |- | content_default | text | utf8mb3_general_ci | | NO | | | |- | #conte..."

{| align="right"
|-
| __TOC__
|}
{{Back-to:World_18414}}

The skyfire_string table

This table holds information about about skyfire_strings in english or other locales.

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#entry|entry]]
| mediumint(7)
| unsigned
| PRI
| NO
| 0
|
|
|-
| [[#content_default|content_default]]
| text
| utf8mb3_general_ci
|
| NO
|
|
|
|-
| [[#content_loc1|content_loc1]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc2|content_loc2]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc3|content_loc3]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc4|content_loc4]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc5|content_loc5]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc6|content_loc6]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc7|content_loc7]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc8|content_loc8]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc9|content_loc9]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc10|content_loc10]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|-
| [[#content_loc11|content_loc11]]
| text
| utf8mb3_general_ci
|
| YES
| NULL
|
|
|}

{| border="1"
|-
! Column !! Locale !! Language
|-
| content_default || LOCALE_enUS || English (US) - Default
|-
| content_loc1 || LOCALE_koKR || Korean
|-
| content_loc2 || LOCALE_frFR || French (France)
|-
| content_loc3 || LOCALE_deDE || German
|-
| content_loc4 || LOCALE_zhCN || Chinese (Simplified)
|-
| content_loc5 || LOCALE_zhTW || Chinese (Traditional / Taiwan)
|-
| content_loc6 || LOCALE_esES || Spanish (Spain)
|-
| content_loc7 || LOCALE_esMX || Spanish (Mexico)
|-
| content_loc8 || LOCALE_ruRU || Russian
|-
| content_loc9 || LOCALE_itIT || Italian
|-
| content_loc10 || LOCALE_ptBR || Portuguese (Brazil)
|-
| content_loc11 || LOCALE_ptPT || Portuguese (Portugal)
|}

Realmlist 548

2025-06-14T19:21:25Z

Augustomendes4426:

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

The realmlist table

This table holds information about all available realms (servers) in the system.

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int
| unsigned
| PRI
| NO
|
| auto_increment
|
|-
| [[#name|name]]
| varchar(32)
|
| UNI
| NO
| ''
|
|
|-
| [[#address|address]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localAddress|localAddress]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localSubnetMask|localSubnetMask]]
| varchar(255)
|
|
| NO
| 255.255.255.0
|
|
|-
| [[#port|port]]
| smallint
| unsigned
|
| NO
| 8085
|
|
|-
| [[#icon|icon]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#flag|flag]]
| tinyint
| unsigned
|
| NO
| 2
|
|
|-
| [[#timezone|timezone]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#allowedSecurityLevel|allowedSecurityLevel]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#population|population]]
| float
| unsigned
|
| NO
| 0
|
|
|-
| [[#gamebuild|gamebuild]]
| int
| unsigned
|
| NO
| 18414
|
|
|}

<br> <big>'''Description of the fields'''</big>
==== id ====

The unique realm ID. Primary key, auto-incremented.

==== name ====

The name of the realm/server. Must be unique.

==== address ====

The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1.

==== localAddress ====

The local IP address or hostname for internal connections. Default is 127.0.0.1.

==== localSubnetMask ====

The subnet mask for the local network. Default is 255.255.255.0.

==== port ====

The port number the realm listens on. Default is 8085.

==== icon ====

A numeric value representing the realm icon (used by the client to display the realm type).

==== flag ====

A numeric value representing the realm flag (used by the client to display the realm status/type).

==== timezone ====

A numeric value representing the realm's timezone.

==== allowedSecurityLevel ====

The minimum security level required to access the realm.

==== population ====

A floating-point value representing the current population of the realm (used for display purposes).

==== gamebuild ====

The client build number required to connect to the realm.

Realmlist 548

2025-06-14T19:20:38Z

Augustomendes4426:

{| align="right"
|-
| __TOC__
|}

{{Back-to:Auth_18414}}

The realmlist table

This table holds information about all available realms (servers) in the system.

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int
| unsigned
| PRI
| NO
|
| auto_increment
|
|-
| [[#name|name]]
| varchar(32)
|
| UNI
| NO
| ''
|
|
|-
| [[#address|address]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localAddress|localAddress]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localSubnetMask|localSubnetMask]]
| varchar(255)
|
|
| NO
| 255.255.255.0
|
|
|-
| [[#port|port]]
| smallint
| unsigned
|
| NO
| 8085
|
|
|-
| [[#icon|icon]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#flag|flag]]
| tinyint
| unsigned
|
| NO
| 2
|
|
|-
| [[#timezone|timezone]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#allowedSecurityLevel|allowedSecurityLevel]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#population|population]]
| float
| unsigned
|
| NO
| 0
|
|
|-
| [[#gamebuild|gamebuild]]
| int
| unsigned
|
| NO
| 18414
|
|
|}

<br> <big>'''Description of the fields'''</big>
==== id ====

The unique realm ID. Primary key, auto-incremented.

==== name ====

The name of the realm/server. Must be unique.

==== address ====

The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1.

==== localAddress ====

The local IP address or hostname for internal connections. Default is 127.0.0.1.

==== localSubnetMask ====

The subnet mask for the local network. Default is 255.255.255.0.

==== port ====

The port number the realm listens on. Default is 8085.

==== icon ====

A numeric value representing the realm icon (used by the client to display the realm type).

==== flag ====

A numeric value representing the realm flag (used by the client to display the realm status/type).

==== timezone ====

A numeric value representing the realm's timezone.

==== allowedSecurityLevel ====

The minimum security level required to access the realm.

==== population ====

A floating-point value representing the current population of the realm (used for display purposes).

==== gamebuild ====

The client build number required to connect to the realm.

Realmlist 548

2025-06-14T19:20:14Z

Augustomendes4426:

{| align="right"
|-
| __TOC__
|}

{{Back-to:Auth_18414}}

The realmlist table

This table holds information about all available realms (servers) in the system.

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int
| unsigned
| PRI
| NO
|
| auto_increment
|
|-
| [[#name|name]]
| varchar(32)
|
| UNI
| NO
| ''
|
|
|-
| [[#address|address]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localAddress|localAddress]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localSubnetMask|localSubnetMask]]
| varchar(255)
|
|
| NO
| 255.255.255.0
|
|
|-
| [[#port|port]]
| smallint
| unsigned
|
| NO
| 8085
|
|
|-
| [[#icon|icon]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#flag|flag]]
| tinyint
| unsigned
|
| NO
| 2
|
|
|-
| [[#timezone|timezone]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#allowedSecurityLevel|allowedSecurityLevel]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#population|population]]
| float
| unsigned
|
| NO
| 0
|
|
|-
| [[#gamebuild|gamebuild]]
| int
| unsigned
|
| NO
| 18414
|
|
|}

<br> <big>'''Description of the fields'''</big>
==== id ====

The unique realm ID. Primary key, auto-incremented.

==== name ====

The name of the realm/server. Must be unique.

==== address ====

The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1.

==== localAddress ====

The local IP address or hostname for internal connections. Default is 127.0.0.1.

==== localSubnetMask ====

The subnet mask for the local network. Default is 255.255.255.0.

==== port ====

The port number the realm listens on. Default is 8085.

==== icon ====

A numeric value representing the realm icon (used by the client to display the realm type).

==== flag ====

A numeric value representing the realm flag (used by the client to display the realm status/type).

==== timezone ====

A numeric value representing the realm's timezone.

==== allowedSecurityLevel ====

The minimum security level required to access the realm.

==== population ====

A floating-point value representing the current population of the realm (used for display purposes).

==== gamebuild ====

The client build number required to connect to the realm.

Realmlist 548

2025-06-14T16:30:42Z

Augustomendes4426: WIP

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

The realmlist table

This table holds information about all available realms (servers) in the system.

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int
| unsigned
| PRI
| NO
|
| auto_increment
|
|-
| [[#name|name]]
| varchar(32)
|
| UNI
| NO
| ''
|
|
|-
| [[#address|address]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localAddress|localAddress]]
| varchar(255)
|
|
| NO
| 127.0.0.1
|
|
|-
| [[#localSubnetMask|localSubnetMask]]
| varchar(255)
|
|
| NO
| 255.255.255.0
|
|
|-
| [[#port|port]]
| smallint
| unsigned
|
| NO
| 8085
|
|
|-
| [[#icon|icon]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#flag|flag]]
| tinyint
| unsigned
|
| NO
| 2
|
|
|-
| [[#timezone|timezone]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#allowedSecurityLevel|allowedSecurityLevel]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|-
| [[#population|population]]
| float
| unsigned
|
| NO
| 0
|
|
|-
| [[#gamebuild|gamebuild]]
| int
| unsigned
|
| NO
| 18414
|
|
|}

<br> <big>'''Description of the fields'''</big>

==== id ==== The unique realm ID. Primary key, auto-incremented.

==== name ==== The name of the realm/server. Must be unique.

==== address ==== The external IP address or hostname clients use to connect to the realm. Default is 127.0.0.1.

==== localAddress ==== The local IP address or hostname for internal connections. Default is 127.0.0.1.

==== localSubnetMask ==== The subnet mask for the local network. Default is 255.255.255.0.

==== port ==== The port number the realm listens on. Default is 8085.

==== icon ==== A numeric value representing the realm icon (used by the client to display the realm type).

==== flag ==== A numeric value representing the realm flag (used by the client to display the realm status/type).

==== timezone ==== A numeric value representing the realm's timezone.

==== allowedSecurityLevel ==== The minimum security level required to access the realm.

==== population ==== A floating-point value representing the current population of the realm (used for display purposes).

==== gamebuild ==== The client build number required to connect to the realm. Default is 18414.

Main Page

2025-06-14T16:17:25Z

Augustomendes4426: Updated table for SkyFire Database Structure 5.4.8 Build 18414

{| id="mp-topbanner" style="width:100%; background:#f9f9f9; margin:1.2em 0 6px 0; border:1px solid #ddd;"
| style="width:61%; color:#000;" |
{| style="width:100%; border:none; background:none;"
| style="width:280px; text-align:center; white-space:nowrap; color:#000;" |
<div style="font-size:162%; border:none; margin:0; padding:.1em; color:#000;">Welcome to [[Project Skyfire]] wiki!</div>
<div style="top:+0.2em; font-size:95%;">We have [[Special:Statistics|{{NUMBEROFARTICLES}}]] articles. [[Special:UserLogin|Join]] and feel free to improve us.</div>
|}
|}

{| width="100%" cellspacing="0" cellpadding="0"
| colspan="2" |

| width="50%" style="vertical-align:top;" |

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>Getting started : Install the server 5.x.x SUPPORTED</h3>
----

* Windows:
** [[Installation (Windows_Clang)]] -- EXPERIMENTAL
** [[Installation (Windows_5xx)]] -- UPDATED
* Linux:
** [[Installation (Ubuntu 24.04_LTS)]] -- NEW
** [[Installation (Fedora 39)]] -- NEW
** [[Installation (Debian 10)]] -- NEW
** [[Installation (CentOS 7/8)]]
</div>

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>SkyFire Database Structure 5.4.8 Build 18414</h3>
----

You can always help us developing our wiki and improving our community.

*[[DB:Auth_18414|Description and database structure for Skyfire: `'''auth'''`]]
*[[DB:Characters_18414|Description and database structure for Skyfire: `'''characters'''`]]
*[[DB:World_18414|Description and database structure for Skyfire: `'''world'''`]]

</div>

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>AI Scripting</h3>
----

* [[Smart AI (DB Scripting) reference]]
* [[Guide on ScriptDev2's Event AI DB script]]
</div>

| width="50%" style="vertical-align:top;" |

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>Development</h3>
----

*[[Linux GDB Debugging]]
*[[Mmaps Information]]
*[[Opcode list]] -- Not Updated
*[[DBC list]] -- Not Updated
*[[SkyFire DB|Database Changelog]] -- Not Updated
*[[Reporting Bugs|Reporting Bugs]]
*[[DBC Files|DBC Files]] -- Not Updated
*[[DBC Files 542|DBC Files (542)]] -- Not Updated
*[[IRC Rules|IRC Rules]]
</div>

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>Advanced Features</h3>
----

*[[How-to:Advanced|Advanced Guides]]
*[[How-to:MySQLStoredProcedures|How to use MySQL Stored Procedures]]
*[[How-to:Advanced:Xampp|How to use Xampp with MySQL 8.0]]

{{Pp-vandalism}}
</div>

<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>Scripting Assets</h3>
----

This is a placeholder.
</div>
<div style="border: 1px solid #D8D8D8; padding:4px 8px 8px 8px; margin:10px; box-shadow: 0 6px 8px 0 rgba(0, 0, 0, 0.5); border-radius: 5px 5px 0px 0px;">
<h3>Unsupported Legacy Information</h3>
----
Install the server 4.0.6 a Archived
----

* [[Installation (Windows)]]
* [[Installation (Linux)]]
----
Install the server 2.4.3 Archived
----

* [[Installation (Windows_243)]] -- Work In Progress
* [[Installation Debian 9 (Linux_243 (General))]] -- Work In Progress
** Ubuntu:
*** [[Installation (Ubuntu 18.04LTS)]] -- Work In Progress

----
SkyFire Database Structure Legacy 4.0.6a
----

'''{{revision-number}}'''

*[[DB:World|Description of the SkyFire `'''world'''` database structure]]
*[[DB:Characters|Description of the SkyFire `'''characters'''` database structure]]
*[[DB:Auth|Description of the SkyFire `'''auth'''` database structure]]

----
SkyFire Database Structure 2.4.3 Build 8606
You can always help us developing our wiki and improving our community.

*[[DB:World_243|Description of the SkyFire One `'''world'''` database structure]]
*[[DB:Characters_243|Description of the SkyFire One `'''characters'''` database structure]]
*[[DB:Auth_243|Description of the SkyFire One `'''auth'''` database structure]]
----

</div>
</div>
|}

{| id="mp-topbanner" style="width:100%; background:#f9f9f9; margin:1.2em 0 6px 0; border:1px solid #ddd;"
| style="width:61%; color:#000;" |
{| style="width:100%; border:none; background:none;"
| style="width:280px; text-align:center; white-space:nowrap; color:#000;" |
<div style="font-size:162%; border:none; margin:0; padding:.1em; color:#000;" class="plainlinks">
<ul> {{NUMBEROFARTICLES}} Articles</ul>
<ul> {{NUMBEROFPAGES}} Pages</ul>
<ul> {{NUMBEROFUSERS}} Registered Users</ul>
</div>
|}
|}

DB:Characters 18414

2025-06-14T16:14:04Z

Augustomendes4426: Created page with "<br> <big>'''This is the list of tables in the SkyFire `characters` database for version 5.4.8 build 18414'''</big> *account_battle_pet *account_battle_pet_slots *account_data *account_instance_times *account_tutorial *addons *auctionhouse *banned_addons *blackmarket_..."

<br> <big>'''This is the list of tables in the SkyFire `characters` database for version 5.4.8 build 18414'''</big>

*[[account_battle_pet_548|account_battle_pet]]

*[[account_battle_pet_slots_548|account_battle_pet_slots]]

*[[account_data_548|account_data]]

*[[account_instance_times_548|account_instance_times]]

*[[account_tutorial_548|account_tutorial]]

*[[addons_548|addons]]

*[[auctionhouse_548|auctionhouse]]

*[[banned_addons_548|banned_addons]]

*[[blackmarket_auctions_548|blackmarket_auctions]]

*[[bugreport_548|bugreport]]

*[[calendar_events_548|calendar_events]]

*[[calendar_invites_548|calendar_invites]]

*[[channels_548|channels]]

*[[characters_548|characters]]

*[[character_account_data_548|character_account_data]]

*[[character_achievement_548|character_achievement]]

*[[character_achievement_progress_548|character_achievement_progress]]

*[[character_action_548|character_action]]

*[[character_arena_stats_548|character_arena_stats]]

*[[character_aura_548|character_aura]]

*[[character_banned_548|character_banned]]

*[[character_battleground_data_548|character_battleground_data]]

*[[character_battleground_random_548|character_battleground_random]]

*[[character_cuf_profiles_548|character_cuf_profiles]]

*[[character_currency_548|character_currency]]

*[[character_declinedname_548|character_declinedname]]

*[[character_equipmentsets_548|character_equipmentsets]]

*[[character_gifts_548|character_gifts]]

*[[character_glyphs_548|character_glyphs]]

*[[character_homebind_548|character_homebind]]

*[[character_instance_548|character_instance]]

*[[character_inventory_548|character_inventory]]

*[[character_pet_548|character_pet]]

*[[character_pet_declinedname_548|character_pet_declinedname]]

*[[character_queststatus_548|character_queststatus]]

*[[character_queststatus_daily_548|character_queststatus_daily]]

*[[character_queststatus_monthly_548|character_queststatus_monthly]]

*[[character_queststatus_objective_548|character_queststatus_objective]]

*[[character_queststatus_rewarded_548|character_queststatus_rewarded]]

*[[character_queststatus_seasonal_548|character_queststatus_seasonal]]

*[[character_queststatus_weekly_548|character_queststatus_weekly]]

*[[character_reputation_548|character_reputation]]

*[[character_research_digsites_548|character_research_digsites]]

*[[character_research_history_548|character_research_history]]

*[[character_research_projects_548|character_research_projects]]

*[[character_skills_548|character_skills]]

*[[character_social_548|character_social]]

*[[character_spell_548|character_spell]]

*[[character_spell_cooldown_548|character_spell_cooldown]]

*[[character_stats_548|character_stats]]

*[[character_talent_548|character_talent]]

*[[character_void_storage_548|character_void_storage]]

*[[corpse_548|corpse]]

*[[creature_respawn_548|creature_respawn]]

*[[gameobject_respawn_548|gameobject_respawn]]

*[[game_event_condition_save_548|game_event_condition_save]]

*[[game_event_save_548|game_event_save]]

*[[gm_subsurveys_548|gm_subsurveys]]

*[[gm_surveys_548|gm_surveys]]

*[[gm_tickets_548|gm_tickets]]

*[[guild_548|guild]]

*[[guild_achievement_548|guild_achievement]]

*[[guild_achievement_progress_548|guild_achievement_progress]]

*[[guild_bank_eventlog_548|guild_bank_eventlog]]

*[[guild_bank_item_548|guild_bank_item]]

*[[guild_bank_right_548|guild_bank_right]]

*[[guild_bank_tab_548|guild_bank_tab]]

*[[guild_eventlog_548|guild_eventlog]]

*[[guild_finder_applicant_548|guild_finder_applicant]]

*[[guild_finder_guild_settings_548|guild_finder_guild_settings]]

*[[guild_member_548|guild_member]]

*[[guild_member_withdraw_548|guild_member_withdraw]]

*[[guild_newslog_548|guild_newslog]]

*[[guild_rank_548|guild_rank]]

*[[instance_548|instance]]

*[[instance_reset_548|instance_reset]]

*[[item_instance_548|item_instance]]

*[[item_instance_transmog_548|item_instance_transmog]]

*[[item_loot_items_548|item_loot_items]]

*[[item_loot_money_548|item_loot_money]]

*[[item_refund_instance_548|item_refund_instance]]

*[[item_soulbound_trade_data_548|item_soulbound_trade_data]]

*[[lag_reports_548|lag_reports]]

*[[lfg_data_548|lfg_data]]

*[[mail_548|mail]]

*[[mail_items_548|mail_items]]

*[[parties_548|parties]]

*[[party_instance_548|party_instance]]

*[[party_member_548|party_member]]

*[[petition_548|petition]]

*[[petition_sign_548|petition_sign]]

*[[pet_aura_548|pet_aura]]

*[[pet_spell_548|pet_spell]]

*[[pet_spell_cooldown_548|pet_spell_cooldown]]

*[[pool_quest_save_548|pool_quest_save]]

*[[reserved_name_548|reserved_name]]

*[[ticket_bug_548|ticket_bug]]

*[[ticket_suggest_548|ticket_suggest]]

*[[warden_action_548|warden_action]]

DB:Auth 18414

2025-06-14T15:59:21Z

Augustomendes4426: Removing prefix to match with world and to come characters wiki

<br> <big>'''This is the list of tables in the SkyFire `auth` database for version 5.4.8 build 18414'''</big>

*[[account_548|account*]]

*[[account_access_548|account_access*]]

*[[account_banned_548|account_banned]]

*[[autobroadcast_548|autobroadcast]]

*[[ip2nation_548|ip2nation]]

*[[ip2nationcountries_548|ip2nationcountries]]

*[[ip_banned_548|ip_banned]]

*[[logs_548|logs]]

*[[rbac_account_permissions_548|rbac_account_permissions]]

*[[rbac_default_permissions_548|rbac_default_permissions]]

*[[rbac_linked_permissions_548|rbac_linked_permissions]]

*[[rbac_permissions_548|rbac_permissions]]

*[[realmcharacters_548|realmcharacters]]

*[[realmlist_548|realmlist]]

*[[uptime_548|uptime]]

DB:Auth:rbac default permissions 548

2025-06-14T15:58:28Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac default permissions 548 to Rbac default permissions 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Rbac default permissions 548]]

Rbac default permissions 548

2025-06-14T15:58:28Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac default permissions 548 to Rbac default permissions 548: Removing prefix to match with world and to come characters wiki

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

Uptime 548

2025-06-14T15:56:29Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

Realmlist 548

2025-06-14T15:56:27Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

Realmcharacters 548

2025-06-14T15:56:24Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

DB:Auth:uptime 548

2025-06-14T15:56:10Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:uptime 548 to Uptime 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Uptime 548]]

Uptime 548

2025-06-14T15:56:10Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:uptime 548 to Uptime 548: Removing prefix to match with world and to come characters wiki

placeholder

DB:Auth:realmlist 548

2025-06-14T15:56:03Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:realmlist 548 to Realmlist 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Realmlist 548]]

Realmlist 548

2025-06-14T15:56:03Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:realmlist 548 to Realmlist 548: Removing prefix to match with world and to come characters wiki

placeholder

DB:Auth:realmcharacters 548

2025-06-14T15:55:55Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:realmcharacters 548 to Realmcharacters 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Realmcharacters 548]]

Realmcharacters 548

2025-06-14T15:55:55Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:realmcharacters 548 to Realmcharacters 548: Removing prefix to match with world and to come characters wiki

placeholder

Rbac permissions 548

2025-06-14T15:55:37Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

DB:Auth:rbac permissions 548

2025-06-14T15:55:29Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac permissions 548 to Rbac permissions 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Rbac permissions 548]]

Rbac permissions 548

2025-06-14T15:55:29Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac permissions 548 to Rbac permissions 548: Removing prefix to match with world and to come characters wiki

placeholder

Rbac linked permissions 548

2025-06-14T15:55:18Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

DB:Auth:rbac linked permissions 548

2025-06-14T15:54:58Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac linked permissions 548 to Rbac linked permissions 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Rbac linked permissions 548]]

Rbac linked permissions 548

2025-06-14T15:54:58Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac linked permissions 548 to Rbac linked permissions 548: Removing prefix to match with world and to come characters wiki

placeholder

Rbac default permissions 548

2025-06-14T15:54:37Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

DB:Auth:rbac account permissions 548

2025-06-14T15:54:21Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac account permissions 548 to Rbac account permissions 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Rbac account permissions 548]]

Rbac account permissions 548

2025-06-14T15:54:21Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:rbac account permissions 548 to Rbac account permissions 548: Removing prefix to match with world and to come characters wiki

placeholder

Logs 548

2025-06-14T15:54:12Z

Augustomendes4426:

<big>PLACEHOLDER</big>
<h1>Missing Data</h1>

DB:Auth:logs 548

2025-06-14T15:52:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:logs 548 to Logs 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Logs 548]]

Logs 548

2025-06-14T15:52:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:logs 548 to Logs 548: Removing prefix to match with world and to come characters wiki

placeholder

DB:Auth:ip banned 548

2025-06-14T15:52:23Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip banned 548 to Ip banned 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Ip banned 548]]

Ip banned 548

2025-06-14T15:52:23Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip banned 548 to Ip banned 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `ip_banned` table'''</big>

This table contains all of the banned IPs and the date when (or if) the ban will expire.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#ip|ip]]
|varchar(15)
|
|
|NO
|<nowiki>127.0.0.1</nowiki>
|
|
|-
|[[#bandate|bandate]]
|int
|unsigned
|
|NO
|
|
|
|-
|[[#unbandate|unbandate]]
|int
|unsigned
|
|NO
|
|
|
|-
|[[#bannedby|bannedby]]
|varchar(50)
|unsigned
|
|NO
|<nowiki>[Console]</nowiki>
|
|
|-
|[[#banreason|banreason]]
|varchar(255)
|unsigned
|
|NO
|<nowiki>no reason</nowiki>
|
|
|-
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `ip_banned` (
`ip` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '127.0.0.1',
`bandate` int UNSIGNED NOT NULL,
`unbandate` int UNSIGNED NOT NULL,
`bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[Console]',
`banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no reason',
PRIMARY KEY (`ip`, `bandate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Banned IPs' ROW_FORMAT = Dynamic;
;
</pre>

<big>'''Description of the fields'''</big>

==== ip ====

The ip address.

==== bandate====

The date when the ip was banned, in Unix time.

==== unbandate====

The date when the ip will be automatically unbanned, in Unix time. A value less than the current date means, in effect, a permanent ban.

==== bannedby ====

The GM character's name who banned that ip. If banned from the console, then it will be empty (until improved).

==== banreason ====

The reason for the ban.

DB:Auth:ip2nationcountries 548

2025-06-14T15:52:16Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nationcountries 548 to Ip2nationcountries 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Ip2nationcountries 548]]

Ip2nationcountries 548

2025-06-14T15:52:16Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nationcountries 548 to Ip2nationcountries 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `ip2nationcountries` table'''</big>

These tables allow to see approximately which country a player might be from when doing .pinfo <player> command.

They are not mantained by the ProjectSkyfire development team and they require external data to perform their function, which can be found at http://www.ip2nation.com/ip2nation/Download

NOTE IF YOU EXPORT THIS DATABASE FROM WINDOWS ENVIROMENT AND IMPORT IT ON LINUX YOU WILL HAVE STARTUP ERROR BECAUSE ip2nationCountries WILL BE RENAMED TO ip2nationcountries IMPORT IT AGAIN FROM IP2NATION WEBPAGE TO FIX IT.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#code|code]]
|int
|
|
|NO
|<nowiki>0</nowiki>
|
|
|-
|[[#iso_code_2|iso_code_2]]
|char(2)
|
|
|NO
|
|
|
|-
|[[#iso_code_3|iso_code_3]]
|char(2)
|
|
|NO
|
|
|
|-
|[[#iso_country|iso_country]]
|char(2)
|
|
|NO
|
|
|
|-
|[[#country|country]]
|char(2)
|
|
|NO
|
|
|
|-
|[[#lat|lat]]
|char(2)
|
|
|NO
|
|
|
|-
|[[#lon|lon]]
|char(2)
|
|
|NO
|
|
|
|-
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `ip2nationcountries` (
`code` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`iso_code_2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`iso_code_3` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
`iso_country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`country` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`lat` float NOT NULL DEFAULT 0,
`lon` float NOT NULL DEFAULT 0,
PRIMARY KEY (`code`) USING BTREE,
INDEX `code`(`code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
</pre>

<big>'''Description of the fields'''</big>

==== code ====
Please Define

==== so_code_2 ====

Please Define
==== iso_code_3 ====

Please Define
==== iso_country ====

Please Define
==== country ====

Please Define
==== lat ====

Please Define
==== lon ====

Please Define

DB:Auth:ip2nation 548

2025-06-14T15:52:07Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nation 548 to Ip2nation 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Ip2nation 548]]

Ip2nation 548

2025-06-14T15:52:07Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:ip2nation 548 to Ip2nation 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `ip2nation` table'''</big>

These tables allow to see approximately which country a player might be from when doing .pinfo <player> command.

They are not mantained by the ProjectSkyfire development team and they require external data to perform their function, which can be found at http://www.ip2nation.com/ip2nation/Download

NOTE IF YOU EXPORT THIS DATABASE FROM WINDOWS ENVIROMENT AND IMPORT IT ON LINUX YOU WILL HAVE STARTUP ERROR BECAUSE ip2nationCountries WILL BE RENAMED TO ip2nationcountries IMPORT IT AGAIN FROM IP2NATION WEBPAGE TO FIX IT.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#ip|ip]]
|int
|
|
|NO
|<nowiki>0</nowiki>
|
|
|-
|[[#country|country]]
|char(2)
|
|
|NO
|
|
|
|-
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `ip2nation` (
`ip` int UNSIGNED NOT NULL DEFAULT 0,
`country` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
INDEX `ip`(`ip` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
</pre>

<big>'''Description of the fields'''</big>

==== ip ====
ip Range

==== country ====

Country Code

DB:Auth:autobroadcast 548

2025-06-14T15:51:56Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:autobroadcast 548 to Autobroadcast 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Autobroadcast 548]]

Autobroadcast 548

2025-06-14T15:51:56Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:autobroadcast 548 to Autobroadcast 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `autobroadcast` table'''</big>

This table contains the autobroadcast entries for your realms. Values like it's activity, position and Timer (*.On, *.Center, *.Timer) are defined within the worldserver.conf. They are chosen randomly, based on their weight.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#realmid|realmid]]
|int
|
|
|NO
|<nowiki>-1</nowiki>
|
|
|-
|[[#id|id]]
|tinyint
|unsigned
|
|NO
|
|AUTO_INCREMENT
|
|-
|[[#weight|weight]]
|tinyint
|unsigned
|
|
| 1
|
|
|-
|[[#text|text]]
|longtext
|unsigned
|
|NO
|
|
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `sf_auth`.`Untitled` (
`realmid` int NOT NULL DEFAULT -1,
`id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT,
`weight` tinyint UNSIGNED NULL DEFAULT 1,
`text` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`, `realmid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
</pre>

<big>'''Description of the fields'''</big>

==== realmid ====

The realmlist.id. Defines which realm this entry belongs to. Use -1 for all realms to load this entry.

==== id ====

Unique identifier key per realm. Entries with same id will override each other without warnings - this can be used to replace -1 realmid entry on a specific realm.

==== weight ====

A non-negative integer. Entries with higher weight have more chance to get picked.

==== text ====

The text to broadcast. Color and item/spell/quest link formating codes can be used.

DB:Auth:account banned 548

2025-06-14T15:51:47Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account banned 548 to Account banned 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Account banned 548]]

Account banned 548

2025-06-14T15:51:47Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account banned 548 to Account banned 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `account_banned` table'''</big>

This table lists all of the accounts that have been banned along with the date when (or if) the ban will expire.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#id|id]]
|int(10)
|unsigned
|PRI
|NO
|
|
|
|-
|[[#bandate|bandate]]
|int(10)
|unsigned
|
|NO
|
|
|
|-
|[[#unbandate|unbandate]]
|int(10)
|unsigned
|
|NO
|
|
|
|-
|[[#bannedby|bannedby]]
|varchar(50)
|unsigned
|
|NO
|
|
|
|-
|[[#banreason|banreason]]
|varchar(255)
|unsigned
|
|NO
|
|
|
|-
|[[#active|active]]
|tinyint(5)
|unsigned
|
|NO
|<nowiki>-1</nowiki>
|
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `sf_auth`.`Untitled` (
`id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Account id',
`bandate` int UNSIGNED NOT NULL DEFAULT 0,
`unbandate` int UNSIGNED NOT NULL DEFAULT 0,
`bannedby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`banreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`active` tinyint UNSIGNED NOT NULL DEFAULT 1,
PRIMARY KEY (`id`, `bandate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Ban List' ROW_FORMAT = Dynamic;
;
</pre>

<big>'''Description of the fields'''</big>

==== id ====

The account ID.

==== bandate====

The date when the account was banned, in Unix time.

==== unbandate====

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 ====

The GM character's name who banned that account. If banned from the console, then it will be empty (until improved).

==== banreason ====

The reason for the ban.

==== active ====

Boolean 0 or 1 controlling if the ban is currently active or not.

DB:Auth:account access 548

2025-06-14T15:51:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Account access 548]]

Account access 548

2025-06-14T15:51:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account access 548 to Account access 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<big>'''The `account_access` table'''</big>

This table holds security access level for any realm in [[DB:Auth:realmlist|realmlist]] table.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#id|id]]
|int(10)
|unsigned
|PRI
|NO
|
|
|
|-
|[[#gmlevel|gmlevel]]
|tinyint(3)
|unsigned
|
|NO
|
|
|
|-
|[[#RealmID|RealmID]]
|int(11)
|signed
|PRI
|NO
|<nowiki>-1</nowiki>
|
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `account_access` (
`id` INT NOT NULL,
`gmlevel` TINYINT NOT NULL,
`RealmID` INT NOT NULL DEFAULT -1,
PRIMARY KEY (`id`, `RealmID`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
</pre>

<big>'''Description of the fields'''</big>

==== id ====
The account ID.

==== gmlevel ====
The account security level. Different levels have access to different commands. The individual level required for a command is defined in the command table in each realm.

==== RealmID ====
The Realm ID.

DB:Auth:account 548

2025-06-14T15:50:15Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account 548 to Account 548: Removing prefix to match with world and to come characters wiki

#REDIRECT [[Account 548]]

Account 548

2025-06-14T15:50:15Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:account 548 to Account 548: Removing prefix to match with world and to come characters wiki

{| align="right"
|-
| __TOC__
|}
{{Back-to:Auth_18414}}

<br> <big>'''The `account` table'''</big>

This table holds information on all available accounts.

<br> <big>'''Structure'''</big>

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int(10)
| unsigned
| PRI
| NO
|
| Auto increment
| Identifier
|-
| [[#username|username]]
| varchar(32)
| signed
| UNI
| NO
| "
|
|
|-
| [[#sha_pass_hash|sha_pass_hash]]
| varchar(40)
| signed
|
| NO
| "
|
|
|-
| [[#sessionkey|sessionkey]]
| varchar(80)
| signed
|
| NO
| "
|
|
|-
| [[#v|v]]
| varchar(64)
| signed
|
| NO
| "
|
|
|-
| [[#s|s]]
| varchar(64)
| signed
|
| NO
| "
|
|
|-
| [[#token_key|token_key]]
| varchar(100)
| signed
|
| NO
| "
|
|
|-
| [[#email|email]]
| varchar(254)
| signed
|
| NO
| "
|
|
|-
| [[#reg_email|reg_email]]
| varchar(254)
| signed
|
| NO
| "
|
|
|-
| [[#joindate|joindate]]
| timestamp
| signed
|
| NO
| CURRENT_TIMESTAMP
|
|
|-
| [[#last_ip|last_ip]]
| varchar(15)
| signed
|
| NO
| 127.0.0.1
|
|
|-
| [[#failed_logins|failed_logins]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#locked|locked]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#lock_country|lock_country]]
| varchar(2)
| unsigned
|
| NO
| 00
|
|
|-
| [[#last_login|last_login]]
| timestamp
| signed
|
| NO
| 0000-00-00 00:00:00
|
|
|-
| [[#online|online]]
| tinyint(3)
| signed
|
| NO
| 0
|
|
|-
| [[#expansion|expansion]]
| tinyint(3)
| unsigned
|
| NO
| 2
|
|
|-
| [[#mutetime|mutetime]]
| bigint(20)
| signed
|
| NO
| 0
|
|
|-
| [[#mutereason|mutereason]]
| varchar(255)
| signed
|
| NO
|
|
|
|-
| [[#muteby|muteby]]
| varchar(50)
| signed
|
| NO
|
|
|
|-
| [[#locale|locale]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#os|os]]
| varchar(3)
| signed
|
| NO
| "
|
|
|-
| [[#recruiter|recruiter]]
| int(10)
| unsigned
|
| NO
| 0
|
|-
| [[#hasBoost|hasBoost]]
| tinyint
| unsigned
|
| NO
| 0
|
|
|}
<br> <big>'''DB Structure'''</big>
<br>
{| border="1"<br>
<pre style="color: red">
CREATE TABLE `account` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
`username` VARCHAR(32) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`sha_pass_hash` VARCHAR(40) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`sessionkey` VARCHAR(80) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`v` VARCHAR(64) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`s` VARCHAR(64) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`token_key` VARCHAR(100) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`email` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`reg_mail` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`joindate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1' COLLATE 'utf8_general_ci',
`failed_logins` INT NOT NULL DEFAULT '0',
`locked` TINYINT NOT NULL DEFAULT '0',
`lock_country` VARCHAR(2) NOT NULL DEFAULT '00' COLLATE 'utf8_general_ci',
`last_login` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
`online` TINYINT NOT NULL DEFAULT '0',
`expansion` TINYINT NOT NULL DEFAULT '4',
`mutetime` BIGINT NOT NULL DEFAULT '0',
`mutereason` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`muteby` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`locale` TINYINT NOT NULL DEFAULT '0',
`os` VARCHAR(3) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
`recruiter` INT NOT NULL DEFAULT '0',
`hasBoost` TINYINT NOT NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_username` (`username`) USING BTREE
)
COMMENT='Account System'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
</pre>

<br> <big>'''Description of the fields'''</big>

==== id ====
The unique account ID.

==== username ====
The account user name.

==== sha_pass_hash ====
This field contains the encrypted password. The encryption is SHA1 and is in the following format: username:password. The SQL to create the password (or to compare with the current hash) is:
<pre>SELECT SHA1(CONCAT(UPPER(`username`), ':', UPPER(<pass>)));</pre>

==== sessionkey ====
{{field-no-description|4}}

==== v ====
v is derived from salt, as well as the user's username (all uppercase) and their password (all uppercase).

To obtain the verifier you need to calculate:

Calculate h1 = SHA1("USERNAME:PASSWORD"), substituting the user's username and password converted to uppercase.

Calculate h2 = SHA1(salt || h1), where || is concatenation (the . operator in PHP).

NOTE: Both salt and h1 are binary, not hexadecimal strings!

Treat h2 as an integer in little-endian order (the first byte is the least significant).

Calculate (g ^ h2) % N.

NOTE: g and N are parameters, which are fixed in the WoW implementation.

g = 7

N = 0x894B645E89E1535BBDAD5B8B290650530801B18EBFBF5E8FAB3C82872A3E9BB7

Convert the result back to a byte array in little-endian order.

==== s ====
s is a cryptographically random 32-byte value.

==== token_key ====
{{field-no-description|7}}

==== email ====
The e-mail address associated with this account.

==== reg_email ====
The registration e-mail address associated with this account.

==== joindate ====
The date when the account was created.

==== last_ip ====
The last IP used by the person who logged in the account.

==== failed_logins ====
The number of failed logins attempted on the account.

==== locked ====
Boolean 0 or 1 controlling if the account has been locked or not. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their [[DB:Auth:account#last_ip|last_ip]]. If unlocked (0), a user can log in from any IP, and their last_ip will be updated if it is different. ".Ban account" does not lock it.

==== lock_country ====
{{field-no-description|14}}

==== last_login ====
The date when the account was last logged into.

==== online ====
Boolean 0 or 1 controlling if the account is currently logged in and online.

==== expansion ====
Boolean 0 or 1 controlling if the client logged in on the account has any expansions. (for example if client is TBC, but expansion is set to 0, it will not be able to enter outlands and etc.)

==== mutetime ====
The time, in Unix time, when the account will be unmuted. To see when mute will be expired you can use this query:
<pre>SELECT FROM_UNIXTIME(`mutetime`);</pre>

==== mutereason ====
The reason for the mute.

==== muteby ====
The character name with the rights to the .mute command that give the mute.

==== locale ====
The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client. See [[Localization lang|localization IDs]]

==== os ====
Stores information about client's OS. Used by Warden system.
* Win
* Mac

==== recruiter ====
The account ID of another account. Used for recuit-a-friend system. See [[DB:Auth:account#id|account.id]]

==== hasBoost ====
{{field-no-description|24}}

DB:Auth:realm races 548

2025-06-14T15:39:07Z

Augustomendes4426: No longer in issue

<h1>TO BE DELETED</h1>

DB:Auth:realm classes 548

2025-06-14T15:38:39Z

Augustomendes4426: To be deleted no longer in use

<h1>TO BE DELETED</h1>

DB:Auth 18414

2025-06-14T15:36:01Z

Augustomendes4426: Removed realm races and classes, no longer in use

<big>'''This is the list of tables in the 'auth' database 5.4.8 Build 18414'''</big>

*[[DB:Auth:account_548|account*]]

*[[DB:Auth:account_access_548|account_access*]]

*[[DB:Auth:account_banned_548|account_banned]]

*[[DB:Auth:autobroadcast_548|autobroadcast]]

*[[DB:Auth:ip2nation_548|ip2nation]]

*[[DB:Auth:ip2nationcountries_548|ip2nationcountries]]

*[[DB:Auth:ip_banned_548|ip_banned]]

*[[DB:Auth:logs_548|logs]]

*[[DB:Auth:rbac_account_permissions_548|rbac_account_permissions]]

*[[DB:Auth:rbac_default_permissions_548|rbac_default_permissions]]

*[[DB:Auth:rbac_linked_permissions_548|rbac_linked_permissions]]

*[[DB:Auth:rbac_permissions_548|rbac_permissions]]

*[[DB:Auth:realmcharacters_548|realmcharacters]]

*[[DB:Auth:realmlist_548|realmlist]]

*[[DB:Auth:uptime_548|uptime]]

DB:Auth:1p2nationcountries 548

2025-06-14T15:34:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:1p2nationcountries 548 to DB:Auth:ip2nationcountries 548: Corrected the typo 1p2nat to ip2nat (to match the database) and the wiki

#REDIRECT [[DB:Auth:ip2nationcountries 548]]

Ip2nationcountries 548

2025-06-14T15:34:38Z

Augustomendes4426: Augustomendes4426 moved page DB:Auth:1p2nationcountries 548 to DB:Auth:ip2nationcountries 548: Corrected the typo 1p2nat to ip2nat (to match the database) and the wiki