Modules/MTA-MySQL/mysql ping - Revision history

Reitside at 16:21, 2 December 2017

2017-12-02T16:21:00Z

← Older revision		Revision as of 16:21, 2 December 2017
Line 32:		Line 32:
	==See also==		==See also==
	{{Modules/MTA-MySQL/Handler_functions}}		{{Modules/MTA-MySQL/Handler_functions}}

			[[RU:Modules/MTA-MySQL/mysql_ping]]

Alberto Alonso at 17:40, 5 January 2011

2011-01-05T17:40:33Z

← Older revision		Revision as of 17:40, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}

Ryden at 17:58, 14 January 2008

2008-01-14T17:58:44Z

← Older revision		Revision as of 17:58, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Checks if the given MySQL connection is still alive.		Checks if the given MySQL connection is still alive.

Ryden: New page: NOTOC Checks if the given MySQL connection is still alive. ==Syntax== bool mysql_ping ( MySQLConnection handler ) ===Required arguments=== * '''handler:''' A val...

2008-01-13T15:00:49Z

New page: __NOTOC__ Checks if the given MySQL connection is still alive. ==Syntax== <syntaxhighlight lang="lua"> bool mysql_ping ( MySQLConnection handler ) </syntaxhighlight> ===Required arguments=== * '''handler:''' A val...

New page

__NOTOC__
Checks if the given MySQL connection is still alive.

==Syntax==
<syntaxhighlight lang="lua">
bool mysql_ping ( MySQLConnection handler )
</syntaxhighlight>
===Required arguments===
* '''handler:''' A valid MySQL link

===Returns===
true is the connection is still alive, false if not.

==Example==
'''Example 1:''' This example checks if the MySQL connection is still alive when a player connects, to be able to fetch their data.
<syntaxhighlight lang="lua">
myhandler = mysql_connect("localhost", "user", "password", "mta_users")

function checkMySQLConnection ( )
if (mysql_ping(myhandler) == false) then -- We lost the connection to the MySQL server
outputDebugString("Lost connection to the MySQL server, reconnecting ...")
mysql_close(myhandler)
myhandler = mysql_connect("localhost", "user", "password", "mta_users") -- Reconnect to the MySQL server
end
end

addEventHandler("onPlayerJoin", getRootElement(), checkMySQLConnection)
</syntaxhighlight>

==See also==
{{Modules/MTA-MySQL/Handler_functions}}

Modules/MTA-MySQL/mysql ping - Revision history

Reitside at 16:21, 2 December 2017

Alberto Alonso at 17:40, 5 January 2011

Ryden at 17:58, 14 January 2008

Ryden: New page: __NOTOC__ Checks if the given MySQL connection is still alive. ==Syntax== bool mysql_ping ( MySQLConnection handler ) ===Required arguments=== * '''handler:''' A val...

Ryden: New page: NOTOC Checks if the given MySQL connection is still alive. ==Syntax== bool mysql_ping ( MySQLConnection handler ) ===Required arguments=== * '''handler:''' A val...