Resource:Sqlbans - Revision history

Arran Fortuna at 10:23, 2 February 2011

2011-02-02T10:23:46Z

← Older revision		Revision as of 10:23, 2 February 2011
Line 15:		Line 15:
	===Required Arguments===		===Required Arguments===
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''banisher:''' Either a string, player pointer, or ~~element~~ pointer.		*'''banisher:''' Either a string, player pointer, or resource pointer.
	*'''reason:''' The reason for the ban.		*'''reason:''' The reason for the ban.
	*'''duration:''' Integer in minutes for the ban.		*'''duration:''' Integer in minutes for the ban.

Arran Fortuna at 17:51, 1 February 2011

2011-02-01T17:51:44Z

← Older revision		Revision as of 17:51, 1 February 2011
Line 3:		Line 3:
	The SQLbans resource gives servers 100% flexibility (for example disabling ban logging) with their ban system as it can be edited to meet their needs. The bans are stored using the inbult SQL functions into the database "bans" rather than XML which is used by the inbuilt MTA ban system.		The SQLbans resource gives servers 100% flexibility (for example disabling ban logging) with their ban system as it can be edited to meet their needs. The bans are stored using the inbult SQL functions into the database "bans" rather than XML which is used by the inbuilt MTA ban system.

	Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].		===Requirements for use:===
			* Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].
			* Resource must have access to function.kickPlayer function.getClientIP and function.getPlayerSerial

	==Exported functions/events==		==Exported functions/events==

Arran Fortuna at 17:18, 1 February 2011

2011-02-01T17:18:08Z

← Older revision		Revision as of 17:18, 1 February 2011
Line 1:		Line 1:
	{{Resource page}}		{{Resource page}}
	__NOTOC__		__NOTOC__
	The SQLbans resource gives servers 100% flexibility with their ban system as it can be edited to meet their needs. The bans are stored using the inbult SQL functions into the database "bans" rather than XML which is used by the inbuilt MTA ban system.		The SQLbans resource gives servers 100% flexibility (for example disabling ban logging) with their ban system as it can be edited to meet their needs. The bans are stored using the inbult SQL functions into the database "bans" rather than XML which is used by the inbuilt MTA ban system.

	Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].		Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].

Arran Fortuna at 17:17, 1 February 2011

2011-02-01T17:17:33Z

← Older revision		Revision as of 17:17, 1 February 2011
Line 24:		Line 24:
	</syntaxhighlight>		</syntaxhighlight>
	===Returns===		===Returns===
	*'''banValue:''' A string for a players serial or IP address.		*'''Column 1 - banValue:''' A string for a players serial or IP address.
	*'''~~banisher~~:''' A string for either a custom banisher, player name or resource name		*'''Column 2 - theBanisher:''' A string for either a custom banisher, player name or resource name
	*'''~~reason~~:''' The reason for the ban.		*'''Column 3 - theReason:''' The reason for the ban.
	*'''~~duration~~:''' The minutes left in the ban time.		*'''Column 4 - theDuration:''' The minutes left in the ban time.

	===getBanDetailsSQL===		===getBanDetailsSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	string banValue string ~~banisher~~ string ~~reason~~ int ~~duration~~ getBanDetailsSQL ( string banValue )		string banValue, string theBanisher, string theReason, int theDuration getBanDetailsSQL ( string banValue )
	</syntaxhighlight>		</syntaxhighlight>
	===Required Arguements===		===Required Arguements===
Line 38:		Line 38:
	===Returns===		===Returns===
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''~~banisher~~:''' Either a string, player pointer, or element pointer.		*'''theBanisher:''' Either a string, player pointer, or element pointer.
	*'''~~reason~~:''' The reason for the ban.		*'''theReason:''' The reason for the ban.
	*'''~~duration~~:''' The minutes left in the ban time.		*'''theDuration:''' The minutes left in the ban time.

	===banPlayerSQL===		===banPlayerSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool banPlayerSQL ( player thePlayer, bool serial, bool ipAddress, string/player/resource ~~banisher~~, string ~~reason~~, int ~~duration~~ )		bool banPlayerSQL ( player thePlayer, bool serial, bool ipAddress, string/player/resource theBanisher, string theReason, int theDuration )
	</syntaxhighlight>		</syntaxhighlight>
	===Required Arguements===		===Required Arguements===
Line 50:		Line 50:
	*'''serial:''' Ban their serial?		*'''serial:''' Ban their serial?
	*'''ipAddress:''' Ban their IP address? (Can't ban both.)		*'''ipAddress:''' Ban their IP address? (Can't ban both.)
	*'''~~banisher~~:''' A string, player, or resource that is banning the player.		*'''theBanisher:''' A string, player, or resource that is banning the player.
	*'''~~reason~~:''' The ban reason.		*'''theReason:''' The ban reason.
	*'''~~duration~~:''' Time in minutes the ban should last for.		*'''theDuration:''' Time in minutes the ban should last for.

	===Returns===		===Returns===

Arran Fortuna at 17:15, 1 February 2011

2011-02-01T17:15:06Z

← Older revision		Revision as of 17:15, 1 February 2011
Line 29:		Line 29:
	*'''duration:''' The minutes left in the ban time.		*'''duration:''' The minutes left in the ban time.

			===getBanDetailsSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	string banValue string banisher string reason int duration getBanDetailsSQL ( string banValue )		string banValue string banisher string reason int duration getBanDetailsSQL ( string banValue )
	</syntaxhighlight>		</syntaxhighlight>
	Returns ~~three strings and an integer:~~		===Required Arguements===
			*'''banValue:''' A string for a players serial or IP address.

			===Returns===
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''banisher:''' Either a string, player pointer, or element pointer.		*'''banisher:''' Either a string, player pointer, or element pointer.
Line 38:		Line 42:
	*'''duration:''' The minutes left in the ban time.		*'''duration:''' The minutes left in the ban time.

			===banPlayerSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool banPlayerSQL ( player thePlayer, bool serial, bool ipAddress, string/player/resource banisher, string reason, int duration )		bool banPlayerSQL ( player thePlayer, bool serial, bool ipAddress, string/player/resource banisher, string reason, int duration )
	</syntaxhighlight>		</syntaxhighlight>
	*'''thePlayer:''' The player to ban		===Required Arguements===
			*'''thePlayer:''' The player to ban.
	*'''serial:''' Ban their serial?		*'''serial:''' Ban their serial?
	*'''ipAddress:''' Ban their IP address? (Can't ban both)		*'''ipAddress:''' Ban their IP address? (Can't ban both.)
	*'''banisher:''' A string, player, or resource that is banning the player		*'''banisher:''' A string, player, or resource that is banning the player.
	*'''reason:''' The ban reason		*'''reason:''' The ban reason.
	*'''duration:''' Time in minutes the ban should last for		*'''duration:''' Time in minutes the ban should last for.

			===Returns===
			This function will return ''true'' if the player was successfully banned. If they weren't successfully banned ''false'' will be returned.

			===removeBanSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool removeBanSQL ( string banValue, string/player/resource unbanisher )		bool removeBanSQL ( string banValue, string/player/resource unbanisher )
	</syntaxhighlight>		</syntaxhighlight>
			===Required Arguements===
	*'''banValue:''' An IP address or serial to unban		*'''banValue:''' An IP address or serial to unban
	*'''serial:''' A string, player or resource that is causing the unban.		*'''serial:''' A string, player or resource that is causing the unban.

			===Returns===
			This function will return ''true'' if the ban was successfully removed. If the ban wasn't successfully removed or the ban didn't even exist ''false'' will be returned.

	</section>		</section>

Arran Fortuna at 17:10, 1 February 2011

2011-02-01T17:10:32Z

← Older revision		Revision as of 17:10, 1 February 2011
Line 7:		Line 7:
	==Exported functions/events==		==Exported functions/events==
	<section name="Server" class="server" show="true">		<section name="Server" class="server" show="true">
	===~~Functions~~===		===addBanSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool addBanSQL ( string banValue, string/element banisher, string reason, int duration )		bool addBanSQL ( string banValue, string/element banisher, string reason, int duration )
	</syntaxhighlight>		</syntaxhighlight>
			===Required Arguments===
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''banisher:''' Either a string, player pointer, or element pointer.		*'''banisher:''' Either a string, player pointer, or element pointer.
	*'''reason:''' The reason for the ban.		*'''reason:''' The reason for the ban.
	*'''duration:''' Integer in minutes for the ban.		*'''duration:''' Integer in minutes for the ban.
			===Returns===
			Returns ''true'' if the ban was successfully added. If the ban was not successfully added then ''false'' will be returned

			===getBansSQL===
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	table getBansSQL ()		table getBansSQL ()
	</syntaxhighlight>		</syntaxhighlight>
	Returns ~~a table with 4 columns:~~		===Returns===
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''banisher:''' A string for either a custom banisher, player name or resource name		*'''banisher:''' A string for either a custom banisher, player name or resource name

Arran Fortuna at 17:07, 1 February 2011

2011-02-01T17:07:01Z

← Older revision		Revision as of 17:07, 1 February 2011
Line 21:		Line 21:
	Returns a table with 4 columns:		Returns a table with 4 columns:
	*'''banValue:''' A string for a players serial or IP address.		*'''banValue:''' A string for a players serial or IP address.
	*'''banisher:''' ~~Either~~ a ~~string~~, player ~~pointer,~~ or ~~element pointer.~~		*'''banisher:''' A string for either a custom banisher, player name or resource name
	*'''reason:''' The reason for the ban.		*'''reason:''' The reason for the ban.
	*'''duration:''' ~~Integer~~ in ~~minutes for~~ the ban.		*'''duration:''' The minutes left in the ban time.

	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
Line 32:		Line 32:
	*'''banisher:''' Either a string, player pointer, or element pointer.		*'''banisher:''' Either a string, player pointer, or element pointer.
	*'''reason:''' The reason for the ban.		*'''reason:''' The reason for the ban.
	*'''duration:''' ~~Integer~~ in ~~minutes for~~ the ban.		*'''duration:''' The minutes left in the ban time.

	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">

Arran Fortuna at 17:02, 1 February 2011

2011-02-01T17:02:25Z

← Older revision		Revision as of 17:02, 1 February 2011
Line 1:		Line 1:
	{{Resource page}}		{{Resource page}}
	__NOTOC__		__NOTOC__
	The SQLbans resource gives servers 100% flexibility with their ban system ~~because they~~ can ~~edit it~~ to meet their needs. The bans are stored in SQL rather than XML which is used by the inbuilt MTA ban system.		The SQLbans resource gives servers 100% flexibility with their ban system as it can be edited to meet their needs. The bans are stored using the inbult SQL functions into the database "bans" rather than XML which is used by the inbuilt MTA ban system.

	Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].		Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].

Arran Fortuna: Created page with "{{Resource page}} NOTOC The SQLbans resource gives servers 100% flexibility with their ban system because they can edit it to meet their needs. The bans are stored in SQL rat..."

2011-02-01T17:00:47Z

Created page with "{{Resource page}} __NOTOC__ The SQLbans resource gives servers 100% flexibility with their ban system because they can edit it to meet their needs. The bans are stored in SQL rat..."

New page

{{Resource page}}
__NOTOC__
The SQLbans resource gives servers 100% flexibility with their ban system because they can edit it to meet their needs. The bans are stored in SQL rather than XML which is used by the inbuilt MTA ban system.

Download can be found: [http://community.mtasa.com/index.php?p=resources&s=details&id=1670 On the MTA community].

==Exported functions/events==
<section name="Server" class="server" show="true">
===Functions===
<syntaxhighlight lang="lua">
bool addBanSQL ( string banValue, string/element banisher, string reason, int duration )
</syntaxhighlight>
*'''banValue:''' A string for a players serial or IP address.
*'''banisher:''' Either a string, player pointer, or element pointer.
*'''reason:''' The reason for the ban.
*'''duration:''' Integer in minutes for the ban.

<syntaxhighlight lang="lua">
table getBansSQL ()
</syntaxhighlight>
Returns a table with 4 columns:
*'''banValue:''' A string for a players serial or IP address.
*'''banisher:''' Either a string, player pointer, or element pointer.
*'''reason:''' The reason for the ban.
*'''duration:''' Integer in minutes for the ban.

<syntaxhighlight lang="lua">
string banValue string banisher string reason int duration getBanDetailsSQL ( string banValue )
</syntaxhighlight>
Returns three strings and an integer:
*'''banValue:''' A string for a players serial or IP address.
*'''banisher:''' Either a string, player pointer, or element pointer.
*'''reason:''' The reason for the ban.
*'''duration:''' Integer in minutes for the ban.

<syntaxhighlight lang="lua">
bool banPlayerSQL ( player thePlayer, bool serial, bool ipAddress, string/player/resource banisher, string reason, int duration )
</syntaxhighlight>
*'''thePlayer:''' The player to ban
*'''serial:''' Ban their serial?
*'''ipAddress:''' Ban their IP address? (Can't ban both)
*'''banisher:''' A string, player, or resource that is banning the player
*'''reason:''' The ban reason
*'''duration:''' Time in minutes the ban should last for

<syntaxhighlight lang="lua">
bool removeBanSQL ( string banValue, string/player/resource unbanisher )
</syntaxhighlight>
*'''banValue:''' An IP address or serial to unban
*'''serial:''' A string, player or resource that is causing the unban.

</section>