SetTableToSql - Revision history

Rayan-Alharbi.: / Required arguments */

2018-12-14T00:38:43Z

Required arguments

← Older revision		Revision as of 00:38, 14 December 2018
Line 7:		Line 7:

	===Required arguments===		===Required arguments===
	* '''id''': The ID used to get the table using the function ([https://wiki.multitheftauto.com/wiki/getTableFromSql ~~getTableFromSql~~]).		* '''id''': The ID used to get the table using the function ([https://wiki.multitheftauto.com/wiki/getTableFromSql GetTableFromSql]).
	* '''theTable''': Table to be saved.		* '''theTable''': Table to be saved.

Rayan-Alharbi.: / Required arguments */

2018-12-14T00:26:59Z

Required arguments

← Older revision		Revision as of 00:26, 14 December 2018
Line 7:		Line 7:

	===Required arguments===		===Required arguments===
	* '''id''': The ID used to get the table using the function ([https://wiki.multitheftauto.com/wiki/~~GetTableFromSql link title~~]).		* '''id''': The ID used to get the table using the function ([https://wiki.multitheftauto.com/wiki/getTableFromSql getTableFromSql]).
	* '''theTable''': Table to be saved.		* '''theTable''': Table to be saved.

	==Code==		==Code==
	<section name="Server" class="server" show="true">		<section name="Server" class="server" show="true">

*Rayan-Alharbi. at 00:26, 14 December 2018

2018-12-14T00:26:40Z

← Older revision		Revision as of 00:26, 14 December 2018
Line 2:		Line 2:
	<lowercasetitle/>		<lowercasetitle/>
	__NOTOC__		__NOTOC__
	This function is used to save the table in the database (sql)>		This function is used to save the table in the database (sql)
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>		<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>

Rayan-Alharbi.: / Code */

2018-12-14T00:26:16Z

Code

← Older revision		Revision as of 00:26, 14 December 2018
Line 10:		Line 10:
	* '''theTable''': Table to be saved.		* '''theTable''': Table to be saved.
	==Code==		==Code==
	<section name="Server" class="~~Server~~" show="true">		<section name="Server" class="server" show="true">
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	executeSQLQuery ('CREATE TABLE IF NOT EXISTS Table_System (ID, myTable)')		executeSQLQuery ('CREATE TABLE IF NOT EXISTS Table_System (ID, myTable)')

*Rayan-Alharbi.: Created page with "{{Useful Function}} NOTOC This function is used to save the table in the database (sql)> ==Syntax== setTableToSql( string/int..."

2018-12-14T00:26:02Z

Created page with "{{Useful Function}} <lowercasetitle/> __NOTOC__ This function is used to save the table in the database (sql)> ==Syntax== <syntaxhighlight lang="lua">setTableToSql( string/int..."

New page

{{Useful Function}}
<lowercasetitle/>
__NOTOC__
This function is used to save the table in the database (sql)>
==Syntax==
<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>

===Required arguments===
* '''id''': The ID used to get the table using the function ([https://wiki.multitheftauto.com/wiki/GetTableFromSql link title]).
* '''theTable''': Table to be saved.
==Code==
<section name="Server" class="Server" show="true">
<syntaxhighlight lang="lua">
executeSQLQuery ('CREATE TABLE IF NOT EXISTS Table_System (ID, myTable)')
function setTableToSql( id, theTable )
local Results = executeSQLQuery("SELECT myTable FROM `Table_System` WHERE ID=?", id )
if ( type ( Results ) == "table" and #Results == 0 or not Results ) then
executeSQLQuery ( "INSERT INTO `Table_System` ( ID, myTable ) VALUES(?, ?)",id , toJSON ( theTable ) )
else
executeSQLQuery('UPDATE `Table_System` SET myTable =? WHERE ID =?',toJSON ( theTable ),id )
end
end
</syntaxhighlight>
</section>

==Example==
<section name="Example" class="server" show="true">
<syntaxhighlight lang="lua">
Table = {
{"I'm"},
{"The"},
{"King"},
}
addEventHandler( "onResourceStop",resourceRoot,
function()
setTableToSql( 1, Table)
end )
</syntaxhighlight>
</section>

Author: *Rayan-Alharbi.

==See Also==
{{Useful_Functions}}

SetTableToSql - Revision history

*Rayan-Alharbi.: /* Required arguments */

*Rayan-Alharbi.: /* Required arguments */

*Rayan-Alharbi. at 00:26, 14 December 2018

*Rayan-Alharbi.: /* Code */

*Rayan-Alharbi.: Created page with "{{Useful Function}} __NOTOC__ This function is used to save the table in the database (sql)> ==Syntax== setTableToSql( string/int..."

Rayan-Alharbi.: / Required arguments */

Rayan-Alharbi.: / Required arguments */

Rayan-Alharbi.: / Code */

*Rayan-Alharbi.: Created page with "{{Useful Function}} NOTOC This function is used to save the table in the database (sql)> ==Syntax== setTableToSql( string/int..."