Scripting/Squirrel/Functions/mysql query - Revision history

Thijn at 18:28, 30 January 2017

2017-01-30T18:28:58Z

← Older revision		Revision as of 18:28, 30 January 2017
Line 25:		Line 25:

	== Related Functions ==		== Related Functions ==
	{{Scripting/Squirrel/Functions/~~Mysql~~}}		{{Scripting/Squirrel/Functions/MySQL Functions}}
	[[Category:Scripting/Squirrel/Functions/Mysql_Functions]]		[[Category:Scripting/Squirrel/Functions/Mysql_Functions]]

Thijn at 18:24, 30 January 2017

2017-01-30T18:24:50Z

← Older revision		Revision as of 18:24, 30 January 2017
Line 23:		Line 23:

	You can also use this function to SELECT, DELETE, INSERT etc.		You can also use this function to SELECT, DELETE, INSERT etc.

			== Related Functions ==
			{{Scripting/Squirrel/Functions/Mysql}}
			[[Category:Scripting/Squirrel/Functions/Mysql_Functions]]

CRAST at 11:11, 28 September 2015

2015-09-28T11:11:24Z

← Older revision		Revision as of 11:11, 28 September 2015
Line 7:		Line 7:
	== Arguments ==		== Arguments ==

	* ~~''string''~~ '''database''' - The database on which the query shall be executed.		* '''database''' - The database on which the query shall be executed.
	* ~~''string''~~ '''query''' - The query to be executed.		* '''query''' - The query to be executed.
	== Example ==		== Example ==

CRAST: Created page with "This function will execute a query from the MySQL database. == Syntax ==

mysql_query( database, query);

== Arguments == * ''string'' '''database''' - The databa..."

2015-09-28T10:58:10Z

Created page with "This function will execute a query from the MySQL database. == Syntax == <pre>mysql_query( database, query);</pre> == Arguments == * ''string'' '''database''' - The databa..."

New page

This function will execute a query from the MySQL database.

== Syntax ==

<pre>mysql_query( database, query);</pre>

== Arguments ==

* ''string'' '''database''' - The database on which the query shall be executed.
* ''string'' '''query''' - The query to be executed.
== Example ==

<source lang=squirrel>function onPlayerCommand(player, command, arguments)
{
if (command=="resetcash")
{
mysql_query( vcmpdb, "UPDATE accounts SET cash = '0' WHERE name = '"+player.Name+"'");
}
}</source>

=== Notes ===

You can also use this function to SELECT, DELETE, INSERT etc.