Scripting/Squirrel/Functions/mysql query
This wiki is using an old backup from 2020
Some information may be old/missing
This function will execute a query from the MySQL database.
Syntax
mysql_query( database, query);
Arguments
- string database - The database on which the query shall be executed.
- string query - The query to be executed.
Example
function onPlayerCommand(player, command, arguments)
{
if (command=="resetcash")
{
mysql_query( vcmpdb, "UPDATE accounts SET cash = '0' WHERE name = '"+player.Name+"'");
}
}
Notes
You can also use this function to SELECT, DELETE, INSERT etc.