diff options
| -rw-r--r-- | extras/m_sqloper.schema.sql | 1 | ||||
| -rw-r--r-- | src/modules/extra/m_sqloper.cpp | 5 |
2 files changed, 4 insertions, 2 deletions
diff --git a/extras/m_sqloper.schema.sql b/extras/m_sqloper.schema.sql index d4da959c2..293a2aa70 100644 --- a/extras/m_sqloper.schema.sql +++ b/extras/m_sqloper.schema.sql @@ -12,6 +12,7 @@ CREATE TABLE ircd_opers ( id bigint(20) NOT NULL auto_increment, username text, password text, + hostname text, type text, PRIMARY KEY (id) ) TYPE=MyISAM; diff --git a/src/modules/extra/m_sqloper.cpp b/src/modules/extra/m_sqloper.cpp index fde524567..e491ec5ec 100644 --- a/src/modules/extra/m_sqloper.cpp +++ b/src/modules/extra/m_sqloper.cpp @@ -115,7 +115,7 @@ class ModuleSQLOper : public Module username = temp; // Create a request containing the SQL query and send it to m_sql.so - SQLRequest* query = new SQLRequest(SQL_RESULT,dbid,"SELECT username,password,type FROM ircd_opers WHERE username='"+username+"' AND password=md5('"+password+"')"); + SQLRequest* query = new SQLRequest(SQL_RESULT,dbid,"SELECT username,password,hostname,type FROM ircd_opers WHERE username='"+username+"' AND password=md5('"+password+"')"); Request queryrequest((char*)query, this, SQLModule); SQLResult* result = (SQLResult*)queryrequest.Send(); @@ -139,7 +139,8 @@ class ModuleSQLOper : public Module for (int j =0; j < Conf->Enumerate("type"); j++) { std::string TypeName = Conf->ReadValue("type","name",j); - if (TypeName == rowresult->GetField("type")) + std::string pattern = std::string(user->ident) + "@" + std::string(user->host); + if ((TypeName == rowresult->GetField("type")) && (Srv->MatchText(pattern,rowresult->GetField("hostname")))); { /* found this oper's opertype */ Srv->MeshSendAll("| "+std::string(user->nick)+" "+TypeName); |