Scripting/Squirrel/Functions/escapeSQLString: Difference between revisions
Jump to navigation
Jump to search
This wiki is using an old backup from 2020
Some information may be old/missing
m (Use proper source tags) |
No edit summary |
||
| Line 17: | Line 17: | ||
//Do stuff here | //Do stuff here | ||
}</source> | }</source> | ||
== Related Functions == | |||
{{Scripting/Squirrel/Functions/SQLite Functions}} | |||
[[Category:Scripting/Squirrel/Functions/SQLite _Functions]] | |||
Latest revision as of 19:01, 30 January 2017
Escapes a query string to avoid sql injection attacks. This function should be used for every executed query that uses any data given by the players.
Syntax
escapeSQLString( string query )Arguments
- String query - The string to escape
Return value
The escaped string.
Example
function onPlayerJoin( player )
{
local pName = escapeSQLString( player.Name );
local q = QuerySQL( handler, "SELECT * FROM Accounts WHERE Name='" + pName + "'" );
//Do stuff here
}