Commit graph

156 commits

Author SHA1 Message Date
AlterEgo
82a2048098
Add native email login conversion support
Add login identity normalization and SRP verifier storage for email address logins.

Resolve email identities through auth and world session handoff while preserving account data delivery and chat initialization.

Add the self-service account conversion command, RBAC entries, pending auth updates, and refreshed auth and character base schemas.
2026-08-04 18:22:33 -05:00
AlterEgo
82386a8d51 Add starter pet persistence and database updates
Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-06-27 08:24:01 -05:00
AlterEgo
41f9bb74c7 Migrate SkyFire from ACE to Boost
Squashes the boost branch migration work into main while leaving the boost branch intact.

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2026-06-03 13:01:21 -05:00
Digid702
7ebb158eff Updating auth and character DB's and moving updates to old 2024-09-01 13:04:31 -07:00
AriDEV3
11eb146f71 Database/Characters: Add realm collumn 2024-03-02 20:08:00 +01:00
AlterEgo
f902053ebd Update main character database table master file.
Signed-off-by: AlterEgo <admin@projectskyfire.org>
2022-12-25 13:01:53 -06:00
AlterEgo
f2d16cc601 DB:
Update character base with last update.
<ci-skip>

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2021-02-07 18:09:01 -06:00
AriDEV
8a1a35a9ac Database: Merge Auth/Char updates into Base.
-[ci skip]

Signed-off-by: AriDEV <aridev666@gmail.com>
2018-08-12 02:43:50 +02:00
AriDEV
88a088abdf Database/Characters: Drop some tables.
Signed-off-by: AriDEV <aridev666@gmail.com>
2018-07-05 23:49:58 +02:00
AriDEV
6c707a4d74 SQL: missed one.
Signed-off-by: AriDEV <aridev666@gmail.com>
2018-06-01 13:20:44 +02:00
AriDEV
1431399aff Server/Database: Droped some dead code in PreparedStatments.
* Renamed Tables and Collumns containing rank & group to bypass a mysql bug.
* Fixed an issue where wrong collumns were loaded from creature_template at reload.

Signed-off-by: AriDEV <aridev666@gmail.com>
2018-06-01 13:15:47 +02:00
AriDEV
ef5bfbfe46 Server/DataStore: Implemented Difficulty.dbc and updated Dungeon and Raid difficulties.
Signed-off-by: AriDEV <aridev666@gmail.com>
2018-02-15 11:33:19 +01:00
AlterEgo
9f2ba0b4e2 Update the worldserver config hash. Updated the base character sql table.
Update ignore table.

Signed-off-by: AlterEgo <admin@projectskyfire.org>
2017-03-10 16:56:55 -06:00
SkyFire
8383022071 Sync updates for character database tables.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2016-04-02 17:54:12 -05:00
AriDEV
c4b83ba67d Server/Player: Fixed saving blockpct into character_stats, also added mastery, pvpdamage and pvphealing.
Signed-off-by: AriDEV <aridev666@gmail.com>
2016-02-26 03:05:58 +01:00
SkyFire
4243942386 Sync character table updates in base table.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2015-12-23 16:26:22 -06:00
AriDEV
8e5c555bcc Database: Fixed SQL Syntax. and removed keys that are not needed.
Fixed #583

Signed-off-by: AriDEV <aridev666@gmail.com>
2015-06-29 14:12:26 +02:00
AriDEV
cce15ac256 SQL: Fixed Out of range currentBid at characters database in table blackmarket_auctions.
Signed-off-by: AriDEV <aridev666@gmail.com>
2015-06-22 01:25:10 +02:00
AriDEV
b543fdaab5 Server/BlackMarket: Implemented Basic BlackMarket Auction System.
Still needs some work.

Signed-off-by: AriDEV <aridev666@gmail.com>
2015-06-22 00:31:19 +02:00
AriDEV
763721d2b3 DB: Synch Auth/Characters Updates with Base and Move them to old.
Signed-off-by: AriDEV <aridev666@gmail.com>
2015-01-21 17:47:54 +01:00
SkyFire
e645e11e5b Sync base Character SQL file with the core.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2014-09-22 21:36:22 -05:00
Vincent-Michael
d8690fa462 DB: meh, snyc characters base 2014-07-26 18:54:00 +02:00
SkyFire
311c5c596e Fix Palabola's epic sql fail.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2014-04-28 21:52:22 -05:00
Palabola
9f058fd0b3 Update characters DB to support reforge and transmog changes. 2014-04-18 07:40:10 +02:00
SkyFire
1ea0286ce6 Update the base sql files. archived the 4.3.4 updates. merged the 5.4.1 and 5.4.2 updates into one folder. changed the file order.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2014-01-11 12:50:35 -06:00
F03SD
2cc30521f4 ......
no idea test git config --global
2013-12-01 09:33:06 +03:00
SkyFire
0581c3f3ac Make the character table current.
Signed-off-by: SkyFire <admin@projectskyfire.org>
2013-11-28 09:38:42 -06:00
Vincent-Michael
741ed6539a Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
Conflicts:
	src/server/game/Entities/Corpse/Corpse.cpp
	src/server/game/Globals/ObjectMgr.cpp
2013-07-19 22:33:35 +02:00
Vlad
f22cf46959 Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bits
Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-07-19 04:03:40 +01:00
Shauren
a117c43906 Core/Achievements: Fixed field type in *_achievement_progress tables 2013-06-20 14:28:32 +02:00
Spp
869fae58ea Merge branch 'master' into 4.3.4 [NOTE: There are parts of code marked as "REVIEW - MERGE" That needs some review)
Conflicts:
	src/server/game/DataStores/DBCStores.cpp
	src/server/game/DataStores/DBCStores.h
	src/server/game/DataStores/DBCfmt.h
	src/server/game/Entities/Unit/Unit.cpp
	src/server/game/Entities/Unit/Unit.h
	src/server/game/Handlers/AuctionHouseHandler.cpp
	src/server/game/Handlers/GroupHandler.cpp
	src/server/game/Movement/Spline/MovementTypedefs.h
	src/server/game/Spells/Auras/SpellAuraEffects.cpp
	src/server/game/Spells/SpellInfo.cpp
	src/server/scripts/EasternKingdoms/ScarletEnclave/chapter1.cpp
	src/server/scripts/Spells/spell_generic.cpp
2013-05-21 09:41:13 +02:00
Nay
4f656f9821 DB/Characters: Remove guildId from characters table (characters_database.sql only)
This field was dropped long ago in 1a290f17f59943905bec7dd413c4879b4bbf6f8e

Thanks to Aokromes for spotting the issue
2013-05-16 23:28:57 +02:00
Shauren
df5d47e35f Core/PacketIO: Implemented possibility to ban client addons serverside 2013-04-05 15:06:35 +02:00
Vincent_Michael
61cc57803e Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
Conflicts:
	src/server/game/Entities/Creature/Creature.h
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Entities/Player/Player.h
	src/server/game/Entities/Unit/Unit.cpp
	src/server/game/Entities/Unit/Unit.h
	src/server/game/Globals/ObjectMgr.cpp
	src/server/game/Handlers/CharacterHandler.cpp
2013-03-04 19:09:57 +01:00
Shauren
60337df5ff Core/Players: Implemented converting quests on faction change (keeping old faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction
Closes #890
Closes #9248
2013-03-04 14:15:52 +01:00
Vincent_Michael
fe0ced9498 Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4
Conflicts:
	sql/base/auth_database.sql
	sql/base/characters_database.sql
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Handlers/LFGHandler.cpp
	src/server/game/Server/WorldSession.cpp
	src/server/game/Server/WorldSession.h
	src/server/game/Server/WorldSocket.cpp
	src/server/game/World/World.cpp
	src/server/scripts/Spells/spell_generic.cpp
2013-02-04 22:14:56 +01:00
Nay
4210fad540 DB/Characters: Update sql/base/characters_database.sql 2013-02-04 16:22:43 +00:00
Subv
e59261917f Merge branch 'master' of https://github.com/TrinityCore/TrinityCore into 4.3.4
Conflicts:
	src/server/game/Entities/Item/Item.cpp
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Entities/Player/Player.h
2012-12-23 08:33:13 -05:00
MrSmite
f297e270b1 Implements saving of loot (items / money) contained inside lootable inventory items.
* Unlooted items / money persist across player sessions
* Loot inside items is tied to the item rather than the player so if trading
  partially looted items becomes possible, this implementation will still work

* New tables added:

    characters_database.sql (first time users)
    characters_create_item_loot.sql (existing users)

Implementation Can be tested with:

 Watertight Trunk [21113]
 Bulging Sack of Gems [25422]
 Fat Sack of Coins [11937]

Closes #2048
2012-12-15 00:06:32 -05:00
Spp
81fe956eb8 Merge branch 'master' into 4.3.4
Conflicts:
	src/server/game/Conditions/ConditionMgr.cpp
	src/server/game/Conditions/ConditionMgr.h
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Entities/Player/Player.h
	src/server/game/Entities/Unit/Unit.cpp
	src/server/game/Globals/ObjectMgr.cpp
	src/server/game/Handlers/ItemHandler.cpp
	src/server/game/Quests/QuestDef.cpp
	src/server/game/Quests/QuestDef.h
	src/server/game/Spells/Auras/SpellAuraEffects.cpp
	src/server/game/World/World.h
	src/server/scripts/Kalimdor/azshara.cpp
	src/server/scripts/Kalimdor/azuremyst_isle.cpp
	src/server/scripts/Kalimdor/darkshore.cpp
	src/server/scripts/Kalimdor/durotar.cpp
	src/server/scripts/Kalimdor/dustwallow_marsh.cpp
	src/server/scripts/Kalimdor/feralas.cpp
	src/server/scripts/Kalimdor/moonglade.cpp
	src/server/scripts/Kalimdor/silithus.cpp
	src/server/scripts/Kalimdor/stonetalon_mountains.cpp
	src/server/scripts/Kalimdor/tanaris.cpp
	src/server/scripts/Kalimdor/the_barrens.cpp
	src/server/scripts/Kalimdor/thousand_needles.cpp
	src/server/scripts/Spells/spell_generic.cpp
2012-12-07 09:22:43 +01:00
Vincent-Michael
9fa50928f9 SQL: Update characters_database.sql 2012-12-04 09:40:35 +01:00
Spp
60a5a82a5f Merge branch 'master' into 4.3.4
Conflicts:
	src/server/game/AI/EventAI/CreatureEventAI.cpp
	src/server/game/AI/EventAI/CreatureEventAIMgr.cpp
	src/server/game/AI/EventAI/CreatureEventAIMgr.h
	src/server/game/Battlegrounds/Battleground.h
	src/server/game/Chat/Chat.h
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Globals/ObjectMgr.cpp
	src/server/game/Globals/ObjectMgr.h
	src/server/game/Guilds/Guild.cpp
	src/server/game/Handlers/CharacterHandler.cpp
	src/server/game/Handlers/MailHandler.cpp
	src/server/game/Miscellaneous/SharedDefines.h
	src/server/game/Server/Protocol/Opcodes.cpp
	src/server/game/Spells/SpellInfo.cpp
	src/server/game/World/World.cpp
	src/server/scripts/Commands/cs_modify.cpp
	src/server/scripts/Commands/cs_reload.cpp
	src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheCrusader/boss_northrend_beasts.cpp
	src/server/shared/Database/Implementation/CharacterDatabase.cpp
2012-11-19 10:09:58 +01:00
horn
8e10eb46fe Core/Calendar: Completely rewrite and fix most of the calendar system
There are still some issues that need to be fixed, for more info see CalendarHandler.cpp TODO part.
Some unblizzlike behaviour possible, we don't have a lot of sniffs.
Big thanks to @Warpten, he joined my project and helped a lot.

IMPORTANT NOTE: Read / append packed time functions in ByteBuffer.h are not correct, they need to be fixed in order to have event times accurate

Signed-off-by: Nay <dnpd.dd@gmail.com>
2012-11-18 22:42:28 +00:00
Spp
e7acaadb43 Fix merge conflic and typos in worldserver config file and characters.sql 2012-11-09 09:03:29 +01:00
Spp
c0b58a7ae9 Merge branch 'master' into 4.3.4
Conflicts:
	sql/base/characters_database.sql
	src/server/game/Guilds/Guild.cpp
	src/server/game/Handlers/ChatHandler.cpp
	src/server/scripts/EasternKingdoms/silverpine_forest.cpp
2012-11-08 11:25:38 +01:00
Spp
3b9368d73e Update characters_database.sql (Missing changes from 58ec4e5319) 2012-11-07 09:49:31 +01:00
Subv
08bc674c3f Merge branch 'master' of https://github.com/TrinityCore/TrinityCore into 4.3.4
Conflicts:
	src/server/game/Entities/Player/Player.cpp
	src/server/game/Handlers/TicketHandler.cpp
	src/server/game/Tickets/TicketMgr.cpp
	src/server/scripts/Northrend/ChamberOfAspects/RubySanctum/boss_halion.cpp
2012-10-16 21:55:01 -05:00
kaelima
6c89a4976c DB: Add gm_tickets changes to base character db 2012-10-17 02:56:07 +02:00
Subv
2877c743ca Merge branch 'master' of https://github.com/TrinityCore/TrinityCore into 4.3.4
Conflicts:
	src/server/game/Achievements/AchievementMgr.cpp
	src/server/game/Handlers/CharacterHandler.cpp
	src/server/game/World/World.cpp
	src/server/game/World/World.h
2012-10-10 10:29:18 -05:00
tibbi
b94309892c allow glyph1 be null like other glyph slots 2012-10-09 16:58:29 +01:00