Multi Theft Auto: Wiki:SetTableToSql - Revision history

Rayan-Alharbi.: Rayan-Alharbi. moved page SetTableToSql to Multi Theft Auto: Wiki:SetTableToSql

2018-12-14T00:17:07Z

← Older revision

Revision as of 00:17, 14 December 2018

2018-12-14T00:16:13Z

Code

← Older revision		Revision as of 00:16, 14 December 2018
Line 9:		Line 9:
	* '''theTable''': The table you want to save.		* '''theTable''': The table you want to save.
	==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)')
Line 22:		Line 22:
	</syntaxhighlight>		</syntaxhighlight>
	</section>		</section>

	==Example==		==Example==
	<section name="Example" class="server" show="true">		<section name="Example" class="server" show="true">

2018-12-14T00:15:24Z

← Older revision		Revision as of 00:15, 14 December 2018
Line 1:		Line 1:
	{{Server client function}}		{{Server client function}}
			The function is used to save tables in the database (sql)
			===Syntax===

	<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>		<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>

			===Required arguments===
			* '''id''': ID to get the table later using the function ( [http://www.example.com link title] ).
			* '''theTable''': The table you want to save.
			==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}}

2018-12-14T00:03:31Z

← Older revision		Revision as of 00:03, 14 December 2018
Line 1:		Line 1:
	~~zxzx~~		{{Server client function}}
			<syntaxhighlight lang="lua">setTableToSql( string/int id, string theTable )</syntaxhighlight>

2018-12-13T23:47:56Z

Created page with "zxzx"

New page

zxzx