From c19172cad9a3302b7f5c8d5ca1d96de9a7311847 Mon Sep 17 00:00:00 2001 From: Gigi1237 Date: Sat, 22 Aug 2015 20:29:17 +0200 Subject: Core/Blackmarket: Implemented black market --- src/server/database/Database/Implementation/CharacterDatabase.cpp | 6 ++++++ src/server/database/Database/Implementation/CharacterDatabase.h | 5 +++++ 2 files changed, 11 insertions(+) (limited to 'src/server/database/Database/Implementation') diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index c519dfc02b7..a6eda970402 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -689,4 +689,10 @@ void CharacterDatabaseConnection::DoPrepareStatements() PrepareStatement(CHAR_DEL_CHARACTER_GARRISON_FOLLOWERS, "DELETE gfab, gf FROM character_garrison_follower_abilities gfab INNER JOIN character_garrison_followers gf ON gfab.dbId = gf.dbId WHERE gf.guid = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES, "SELECT gfab.dbId, gfab.abilityId FROM character_garrison_follower_abilities gfab INNER JOIN character_garrison_followers gf ON gfab.dbId = gf.dbId WHERE guid = ? ORDER BY gfab.slot", CONNECTION_ASYNC); PrepareStatement(CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES, "INSERT INTO character_garrison_follower_abilities (dbId, abilityId, slot) VALUES (?, ?, ?)", CONNECTION_ASYNC); + + // Black Market + PrepareStatement(CHAR_SEL_BLACKMARKET_AUCTIONS, "SELECT marketId, currentBid, time, numBids, bidder FROM blackmarket_auctions", CONNECTION_SYNCH); + PrepareStatement(CHAR_DEL_BLACKMARKET_AUCTIONS, "DELETE FROM blackmarket_auctions WHERE marketId = ?", CONNECTION_ASYNC); + PrepareStatement(CHAR_UPD_BLACKMARKET_AUCTIONS, "UPDATE blackmarket_auctions SET currentBid = ?, time = ?, numBids = ?, bidder = ? WHERE marketId = ?", CONNECTION_ASYNC); + PrepareStatement(CHAR_INS_BLACKMARKET_AUCTIONS, "INSERT INTO blackmarket_auctions (marketId, currentBid, time, numBids, bidder) VALUES (?, ?, ?, ? ,?)", CONNECTION_ASYNC); } diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index f3cb4a7c0c1..18faea4c5b0 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -594,6 +594,11 @@ enum CharacterDatabaseStatements CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES, CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES, + CHAR_SEL_BLACKMARKET_AUCTIONS, + CHAR_DEL_BLACKMARKET_AUCTIONS, + CHAR_UPD_BLACKMARKET_AUCTIONS, + CHAR_INS_BLACKMARKET_AUCTIONS, + MAX_CHARACTERDATABASE_STATEMENTS }; -- cgit v1.2.3