diff options
| author | Adam <Adam@anope.org> | 2011-04-28 19:13:44 -0400 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2011-04-28 19:13:44 -0400 |
| commit | 7da33344d10f4323d9811c68398fe8bb836979b1 (patch) | |
| tree | 73afa5cdc97622cccfe8110d83378d40dd8bfebd /modules/extra/db_mysql.cpp | |
| parent | cbdb9f59f3ba19a634ad633cd1ed27e07d477256 (diff) | |
Added a unique key for the anope_cs_mlock table
Diffstat (limited to 'modules/extra/db_mysql.cpp')
| -rw-r--r-- | modules/extra/db_mysql.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/extra/db_mysql.cpp b/modules/extra/db_mysql.cpp index 650763b6b..9662d75a6 100644 --- a/modules/extra/db_mysql.cpp +++ b/modules/extra/db_mysql.cpp @@ -937,7 +937,7 @@ class DBMySQL : public Module ChannelMode *cm = ModeManager::FindChannelModeByName(ml.name); if (cm != NULL) - this->RunQuery("INSERT INTO `anope_cs_mlock` (channel, mode, status, setter, created, param) VALUES('" + this->Escape(ci->name) + "', '" + cm->NameAsString() + "', " + stringify(ml.set ? 1 : 0) + ", '" + this->Escape(ml.setter) + "', " + stringify(ml.created) + ", '" + this->Escape(ml.param) + "')"); + this->RunQuery("INSERT INTO `anope_cs_mlock` (channel, mode, status, setter, created, param) VALUES('" + this->Escape(ci->name) + "', '" + cm->NameAsString() + "', " + stringify(ml.set ? 1 : 0) + ", '" + this->Escape(ml.setter) + "', " + stringify(ml.created) + ", '" + this->Escape(ml.param) + "') ON DUPLICATE KEY UPDATE channel=VALUES(channel), mode=VALUES(mode), status=VALUES(status), setter=VALUES(setter), created=VALUES(created), param=VALUES(param)"); } } @@ -965,7 +965,7 @@ class DBMySQL : public Module { ChannelMode *cm = ModeManager::FindChannelModeByName(lock->name); if (cm != NULL) - this->RunQuery("INSERT INTO `anope_cs_mlock` (channel, mode, status, setter, created, param) VALUES('" + this->Escape(ci->name) + "', '" + cm->NameAsString() + "', " + stringify(lock->set ? 1 : 0) + ", '" + this->Escape(lock->setter) + "', " + stringify(lock->created) + ", '" + this->Escape(lock->param) + "')"); + this->RunQuery("INSERT INTO `anope_cs_mlock` (channel, mode, status, setter, created, param) VALUES('" + this->Escape(ci->name) + "', '" + cm->NameAsString() + "', " + stringify(lock->set ? 1 : 0) + ", '" + this->Escape(lock->setter) + "', " + stringify(lock->created) + ", '" + this->Escape(lock->param) + "') ON DUPLICATE KEY UPDATE channel=VALUES(channel), mode=VALUES(mode), status=VALUES(status), setter=VALUES(setter), created=VALUES(created), param=VALUES(param)"); return EVENT_CONTINUE; } |