mirror of
https://github.com/DarkflameUniverse/DarkflameServer.git
synced 2024-12-23 05:53:34 +00:00
18 lines
622 B
C++
18 lines
622 B
C++
|
#include "SQLiteDatabase.h"
|
||
|
|
||
|
void SQLiteDatabase::InsertRewardCode(const uint32_t account_id, const uint32_t reward_code) {
|
||
|
ExecuteInsert("INSERT OR IGNORE INTO accounts_rewardcodes (account_id, rewardcode) VALUES (?, ?);", account_id, reward_code);
|
||
|
}
|
||
|
|
||
|
std::vector<uint32_t> SQLiteDatabase::GetRewardCodesByAccountID(const uint32_t account_id) {
|
||
|
auto [_, result] = ExecuteSelect("SELECT rewardcode FROM accounts_rewardcodes WHERE account_id = ?;", account_id);
|
||
|
|
||
|
std::vector<uint32_t> toReturn;
|
||
|
while (!result.eof()) {
|
||
|
toReturn.push_back(result.getIntField("rewardcode"));
|
||
|
result.nextRow();
|
||
|
}
|
||
|
|
||
|
return toReturn;
|
||
|
}
|