diff options
| author | Adam <Adam@anope.org> | 2011-01-24 17:50:34 -0500 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2011-01-24 17:52:33 -0500 |
| commit | 81d8858e568b5283d464c977699f67d64c9dd33a (patch) | |
| tree | 6c4d3ea387d580cbf9b8c937657d7128157f4451 | |
| parent | d7206c8f386a53ccda671f67a1b4e92c7f22c293 (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 dbf0fc760..3a9b9c967 100644 --- a/modules/extra/db_mysql.cpp +++ b/modules/extra/db_mysql.cpp @@ -1391,7 +1391,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) @@ -1513,7 +1513,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->nc->display) + ", " + 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(") + access->level + ", '" + me->Escape(access->nc->display) + "', '" + 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) @@ -1525,7 +1525,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) |