SQL Admins (SourceMod) - Revision history

MisakaSora: add a language template

2019-09-20T10:06:30Z

add a language template

2008-12-11T20:20:01Z

‎MySQL

2008-12-11T20:18:47Z

‎MySQL

2008-09-13T08:41:03Z

‎Management Commands

2008-02-17T16:41:30Z

2007-09-11T12:23:23Z

2007-09-11T11:43:07Z

2007-09-10T20:22:24Z

2007-09-10T20:21:46Z

2007-09-10T20:20:47Z

← Older revision		Revision as of 10:06, 20 September 2019
Line 1:		Line 1:
		+	{{Languages\|SQL Admins (SourceMod)}}
	SourceMod has support for loading and managing admins via SQL, using any of the supported SQL drivers provided (currently, MySQL and SQLite). This can be very advantageous if you have a large number of admins, you wish to manage your admins via external tools, or you wish to share admins across servers.		SourceMod has support for loading and managing admins via SQL, using any of the supported SQL drivers provided (currently, MySQL and SQLite). This can be very advantageous if you have a large number of admins, you wish to manage your admins via external tools, or you wish to share admins across servers.

@@ Line 10: / Line 10: @@
 =Configuration=
 ==MySQL==
-Open <tt>configs/databases.cfg</tt> on your server.  You should see a section called <tt>"default"</tt>.  You can either use this section, or create a new one called <tt>"admins"</tt> if you wish to separate your connections.  You must fill out the <tt>driver</tt>, <tt>host</tt>, <tt>database</tt>, <tt>user</tt>, and <tt>pass</tt> fields.  If you do not need a field, use empty quotation marks as the value (<tt>""</tt>).  A restart of your 'srcds' instance that will be using the 'SQL Admins' is required for the database support to take affect.
+Open <tt>configs/databases.cfg</tt> on your server.  You should see a section called <tt>"default"</tt>.  You can either use this section, or create a new one called <tt>"admins"</tt> if you wish to separate your connections.  You must fill out the <tt>driver</tt>, <tt>host</tt>, <tt>database</tt>, <tt>user</tt>, and <tt>pass</tt> fields.  If you do not need a field, use empty quotation marks as the value (<tt>""</tt>).  A restart of each 'srcds' instance that will be using the 'SQL Admins' is required for the database support to take affect.
 Example:

@@ Line 10: / Line 10: @@
 =Configuration=
 ==MySQL==
-Open <tt>configs/databases.cfg</tt> on your server.  You should see a section called <tt>"default"</tt>.  You can either use this section, or create a new one called <tt>"admins"</tt> if you wish to separate your connections.  You must fill out the <tt>driver</tt>, <tt>host</tt>, <tt>database</tt>, <tt>user</tt>, and <tt>pass</tt> fields.  If you do not need a field, use empty quotation marks as the value (<tt>""</tt>).
+Open <tt>configs/databases.cfg</tt> on your server.  You should see a section called <tt>"default"</tt>.  You can either use this section, or create a new one called <tt>"admins"</tt> if you wish to separate your connections.  You must fill out the <tt>driver</tt>, <tt>host</tt>, <tt>database</tt>, <tt>user</tt>, and <tt>pass</tt> fields.  If you do not need a field, use empty quotation marks as the value (<tt>""</tt>).  A restart of your 'srcds' instance that will be using the 'SQL Admins' is required for the database support to take affect.
 Example:

@@ Line 122: / Line 122: @@
 |- class="t2td"
 | sm_sql_addadmin
-| <nowiki><alias> <authtype> <identity> <flags> [mmunity] [password]</nowiki>
+| <nowiki><alias> <authtype> <identity> <flags> [immunity] [password]</nowiki>
 | Adds a new entry to the <tt>sm_admins</tt> table.  The <tt>alias</tt> can be any value and is usually used to assign a readable name to an IP/SteamID.
 |- class="t2td"
@@ Line 150: / Line 150: @@
 | Updates the administration tables to the latest schema, preserving data as applicable.  Can only be run from the server console.
 |}
 =Frequently Asked Questions=

← Older revision		Revision as of 16:41, 17 February 2008
Line 101:		Line 101:
	*<tt>update_admins-r3444.sql</tt>		*<tt>update_admins-r3444.sql</tt>

−	In this case, you should run the scripts for <tt>3243</tt> and <tt>3444</tt>, that order, to bring your table up to date. All data will be fully retained, but it is always recommended that you backup your data before proceeding with database changes.	+	In this case, you should run the scripts for <tt>3243</tt> and <tt>3444</tt>, in that order, to bring your table up to date. All data will be fully retained, but it is always recommended that you backup your data before proceeding with database changes.

@@ Line 110: / Line 110: @@
 *When &lt;authtype&gt; is requested, it means one of the following three values: <tt>steam</tt>, <tt>ip</tt>, or <tt>name</tt>.
 *When &lt;identity&gt; is requested, it should be the unique string to be paired with the <tt>authtype</tt>.  For example, a <tt>steam</tt> identity would be a Steam ID.  An <tt>ip</tt> identity would be an IP address, and a <tt>name</tt> identity would be a Half-Life 2 player name.
 <b>Note: if a string has spaces, it must be in quotes!</b>
@@ Line 123: / Line 122: @@
 |- class="t2td"
 | sm_sql_addadmin
-| <nowiki><alias> <authtype> <identity> <flags> [password]</nowiki>
+| <nowiki><alias> <authtype> <identity> <flags> [mmunity] [password]</nowiki>
 | Adds a new entry to the <tt>sm_admins</tt> table.  The <tt>alias</tt> can be any value and is usually used to assign a readable name to an IP/SteamID.
 |- class="t2td"
@@ Line 131: / Line 130: @@
 |- class="t2td"
 | sm_sql_addgroup
-| <nowiki><name> <flags> [immunity]</nowiki>
+| <nowiki><name> <flags> <immunity></nowiki>
 | Adds a new group with the specified flags and immunity
 |- class="t2td"

@@ Line 40: / Line 40: @@
 =Database Setup=
 ==Automatic==
-Make sure <tt>sql-admin-manager.smx</tt> is loaded, and then run the <tt>sql_create_adm_tables</tt> command from your '''server console'''.  If using MySQL, you must have <tt>CREATE</tt> permissions on your database.
+Make sure <tt>sql-admin-manager.smx</tt> is loaded, and then run the <tt>sm_create_adm_tables</tt> command from your '''server console'''.  If using MySQL, you must have <tt>CREATE</tt> permissions on your database.
 ==Manual==

@@ Line 151: / Line 151: @@
 | Updates the administration tables to the latest schema, preserving data as applicable.  Can only be run from the server console.
 |}
 =Frequently Asked Questions=
@@ Line 161: / Line 162: @@
 <b>Q:</b> Can duplicate groups/admins be in the flat files and the SQL database?
 <b>A:</b> Yup.  They will be merged safely.
 =Schemas=

@@ Line 36: / Line 36: @@
 You may choose to name the database any valid file name.  We chose "admins-sqlite" because a pre-made database, "admins-sqlite.sq3" is available in <tt>configs/sql-init-scripts/sqlite</tt>.
 =Database Setup=
@@ Line 75: / Line 76: @@
 Once you have enabled the manager, and enabled <b>ONE</b> of the <tt>admin-sql</tt> plugins, you are ready to go!
 =Updating Tables=

@@ Line 140: / Line 140: @@
 | Sets an admin's group list.  The inheritance order is the order the groups are specified in.  This sets, and does not add; thus specifying no groups removes the user from all groups.  Example:
 <tt>sm_sql_setadmingroups steam "STEAM_0:1:16" "Full Admins"</tt>
 |}
@@ Line 325: / Line 333: @@
 | Permissions flag string.
 |}
 [[Category:SourceMod Documentation]]