diff options
| author | Adam <Adam@anope.org> | 2011-01-24 17:50:34 -0500 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2011-01-24 17:50:34 -0500 |
| commit | 2e8acfb98c8eb2113eb760ca6959114c7d2950d2 (patch) | |
| tree | 905274e6cfc20f5f0406f8be0b2211a20bde97a8 | |
| parent | 48fa096943c7a46782d185845aed6c3663cc5b2b (diff) | |
Fixed some SQL queries
| -rw-r--r-- | modules/extra/db_mysql.cpp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/modules/extra/db_mysql.cpp b/modules/extra/db_mysql.cpp index d5c51fb36..1140dffa6 100644 --- a/modules/extra/db_mysql.cpp +++ b/modules/extra/db_mysql.cpp @@ -1221,7 +1221,7 @@ class DBMySQL : public Module void OnDeleteVhost(NickAlias *na) { - this->RunQuery("DELETE FROM `anope_hs_core` WHERE `nick` = '" + na->nick + "'"); + this->RunQuery("DELETE FROM `anope_hs_core` WHERE `nick` = '" + this->Escape(na->nick) + "'"); } void OnSetVhost(NickAlias *na) @@ -1343,7 +1343,7 @@ static void SaveDatabases() { ChanAccess *access = ci->GetAccess(j); - me->RunQuery(Anope::string("INSERT INTO `anope_cs_access` (level, display, channel, last_seen, creator) VALUES('") + access->level + "', " + me->Escape(access->mask) + ", " + me->Escape(ci->name) + ", " + access->last_seen + ", " + me->Escape(access->creator) + ") ON DUPLICATE KEY UPDATE level=VALUES(level), last_seen=VALUES(last_seen), creator=VALUES(creator)"); + me->RunQuery(Anope::string("INSERT INTO `anope_cs_access` (level, display, channel, last_seen, creator) VALUES(") + stringify(access->level) + ", '" + me->Escape(access->mask) + "', '" + me->Escape(ci->name) + "', " + stringify(access->last_seen) + ", '" + me->Escape(access->creator) + "') ON DUPLICATE KEY UPDATE level=VALUES(level), last_seen=VALUES(last_seen), creator=VALUES(creator)"); } for (unsigned j = 0, end = ci->GetAkickCount(); j < end; ++j) @@ -1355,7 +1355,7 @@ static void SaveDatabases() for (int k = 0; k < CA_SIZE; ++k) { - me->RunQuery("INSERT INTO `anope_cs_levels` (channel, position, level) VALUES(" + me->Escape(ci->name) + ", '" + stringify(k) + "', '" + stringify(ci->levels[k]) + "') ON DUPLICATE KEY UPDATE position=VALUES(position), level=VALUES(level)"); + me->RunQuery("INSERT INTO `anope_cs_levels` (channel, position, level) VALUES('" + me->Escape(ci->name) + "', " + stringify(k) + ", " + stringify(ci->levels[k]) + ") ON DUPLICATE KEY UPDATE position=VALUES(position), level=VALUES(level)"); } for (unsigned j = 0, end = ci->memos.memos.size(); j < end; ++j) |