Azander at 19:53, 13 May 2014

2014-05-13T19:53:29Z

Azander: Created page with "{{Language|2.0/Modules/m_sql_oper}} {{Header|m_sql_oper|Database|Anope}} ==
Description
== Allows granting users services operator privileges..."

2014-05-13T19:52:48Z

Created page with "{{Language|2.0/Modules/m_sql_oper}} {{Header|m_sql_oper|Database|Anope}} == <div class="moduleheader">Description</div> == Allows granting users services operator privileges..."

New page

{{Language|2.0/Modules/m_sql_oper}}
{{Header|m_sql_oper|Database|Anope}}

== <div class="moduleheader">Description</div> ==
Allows granting users services operator privileges and possibly IRC Operator privileges based on an external SQL database using a custom query.

*'''NOTE''': Requires the m_mysql module.

;name= :Name of the module
;engine= :SQL backend method it should use to get it's data
;query= :Custom QUERY to get the information about an oper

== <div class="moduleheader">Default Configuration</div> ==

<div class="code">
<syntaxhighlight lang="cpp">
/*
* m_sql_oper [EXTRA]
*
* This module allows granting users services operator privileges and possibly IRC Operator
* privileges based on an external SQL database using a custom query.
*/
#module
{
name = "m_sql_oper"

/* SQL engine to use. Should be configured elsewhere with m_mysql, m_sqlite, etc. */
engine = "mysql/main"

/* Query to execute to determine if a user should have operator privileges.
* A field named opertype must be returned in order to link the user to their oper type.
* The oper types must be configured earlier in services.conf.
*
* If a field named modes is returned from this query then those modes are set on the user.
* Without this, only a simple +o is sent.
*
* @a@ is replaced with the user's account name
* @i@ is replaced with the user's IP
*/
query = "SELECT `opertype` FROM `my_users` WHERE `user_name` = @a@"
}

</syntaxhighlight></div>

@@ Line 5: / Line 5: @@
 == <div class="moduleheader">Description</div> ==
 Allows granting users services operator privileges and possibly IRC Operator privileges based on an external SQL database using a custom query.
 *'''NOTE''': Requires the m_mysql module.

2.0/Module/m sql oper - Revision history

Azander at 19:53, 13 May 2014

Azander: Created page with "{{Language|2.0/Modules/m_sql_oper}} {{Header|m_sql_oper|Database|Anope}} == Description == Allows granting users services operator privileges..."

Azander: Created page with "{{Language|2.0/Modules/m_sql_oper}} {{Header|m_sql_oper|Database|Anope}} ==
Description
== Allows granting users services operator privileges..."