summaryrefslogtreecommitdiff
path: root/src/account-server/storage.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'src/account-server/storage.cpp')
-rw-r--r--src/account-server/storage.cpp8
1 files changed, 4 insertions, 4 deletions
diff --git a/src/account-server/storage.cpp b/src/account-server/storage.cpp
index da516979..9a19a673 100644
--- a/src/account-server/storage.cpp
+++ b/src/account-server/storage.cpp
@@ -1468,10 +1468,10 @@ void Storage::setMemberRights(int guildId, int memberId, int rights)
try
{
std::ostringstream sql;
- sql << "update " << GUILD_MEMBERS_TBL_NAME
- << " set rights = '" << rights << "'"
- << " where member_id = \""
- << memberId << "\";";
+ sql << "UPDATE " << GUILD_MEMBERS_TBL_NAME
+ << " SET rights = '" << rights << "'"
+ << " WHERE member_id = '" << memberId << "'"
+ << " AND guild_id = '" << guildId << "'';";
mDb->execSql(sql.str());
}
catch (const dal::DbSqlQueryExecFailure& e)