Core/Items: Implemented item upgrades

Closes #17432

2 files changed, 15 insertions, 4 deletions

diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp
index 6749300000b..c6b03dbf385 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.cpp
+++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp
@@ -15,8 +15,8 @@
  * with this program. If not, see <http://www.gnu.org/licenses/>.
  */
 
- // DO NOT EDIT!
- // Autogenerated from DB2Structure.h
+// DO NOT EDIT!
+// Autogenerated from DB2Structure.h
 
 #include "HotfixDatabase.h"
 
@@ -300,6 +300,10 @@ void HotfixDatabaseConnection::DoPrepareStatements()
     // ItemToBattlePetSpecies.db2
     PrepareStatement(HOTFIX_SEL_ITEM_TO_BATTLE_PET_SPECIES, "SELECT ID, BattlePetSpeciesID FROM item_to_battle_pet_species ORDER BY ID DESC", CONNECTION_SYNCH);
 
+    // ItemUpgrade.db2
+    PrepareStatement(HOTFIX_SEL_ITEM_UPGRADE, "SELECT ID, ItemUpgradePathID, ItemLevelBonus, PrevItemUpgradeID, CurrencyID, CurrencyCost"
+        " FROM item_upgrade ORDER BY ID DESC", CONNECTION_SYNCH);
+
     // ItemXBonusTree.db2
     PrepareStatement(HOTFIX_SEL_ITEM_X_BONUS_TREE, "SELECT ID, ItemID, BonusTreeID FROM item_x_bonus_tree ORDER BY ID DESC", CONNECTION_SYNCH);
 
@@ -383,6 +387,9 @@ void HotfixDatabaseConnection::DoPrepareStatements()
     // QuestXp.db2
     PrepareStatement(HOTFIX_SEL_QUEST_XP, "SELECT ID, Exp1, Exp2, Exp3, Exp4, Exp5, Exp6, Exp7, Exp8, Exp9, Exp10 FROM quest_xp ORDER BY ID DESC", CONNECTION_SYNCH);
 
+    // RulesetItemUpgrade.db2
+    PrepareStatement(HOTFIX_SEL_RULESET_ITEM_UPGRADE, "SELECT ID, RulesetID, ItemUpgradeID, ItemID FROM ruleset_item_upgrade ORDER BY ID DESC", CONNECTION_SYNCH);
+
     // ScalingStatDistribution.db2
     PrepareStatement(HOTFIX_SEL_SCALING_STAT_DISTRIBUTION, "SELECT ID, MinLevel, MaxLevel, ItemLevelCurveID FROM scaling_stat_distribution"
         " ORDER BY ID DESC", CONNECTION_SYNCH);
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h
index 999c9316dad..cb45187e275 100644
--- a/src/server/database/Database/Implementation/HotfixDatabase.h
+++ b/src/server/database/Database/Implementation/HotfixDatabase.h
@@ -15,8 +15,8 @@
  * with this program. If not, see <http://www.gnu.org/licenses/>.
  */
 
- // DO NOT EDIT!
- // Autogenerated from DB2Structure.h
+// DO NOT EDIT!
+// Autogenerated from DB2Structure.h
 
 #ifndef _HOTFIXDATABASE_H
 #define _HOTFIXDATABASE_H
@@ -174,6 +174,8 @@ enum HotfixDatabaseStatements
 
     HOTFIX_SEL_ITEM_TO_BATTLE_PET_SPECIES,
 
+    HOTFIX_SEL_ITEM_UPGRADE,
+
     HOTFIX_SEL_ITEM_X_BONUS_TREE,
 
     HOTFIX_SEL_KEY_CHAIN,
@@ -217,6 +219,8 @@ enum HotfixDatabaseStatements
 
     HOTFIX_SEL_QUEST_XP,
 
+    HOTFIX_SEL_RULESET_ITEM_UPGRADE,
+
     HOTFIX_SEL_SCALING_STAT_DISTRIBUTION,
 
     HOTFIX_SEL_SOUND_ENTRIES,