QCherry: Automatyczna aktualizacja dokumentacji funkcji

2026-08-04T12:44:03Z

Automatyczna aktualizacja dokumentacji funkcji

New page

= dbExec =
Executes a prepared SQL statement when no row result is required.

== Syntax ==
<syntaxhighlight lang="lua">
bool dbExec(DatabaseConnection connection, string statement, ...)
</syntaxhighlight>

== Parameters ==
{| class="wikitable"
! Name !! Type !! Required !! Description
|-
| <code>connection</code> || <code>DatabaseConnection</code> || yes || The connection used to execute the statement.
|-
| <code>statement</code> || <code>string</code> || yes || SQL containing <code>?</code> value placeholders.
|-
| <code>...</code> || <code>nil/bool/number/string</code> || no || Values bound to the placeholders.
|}

== Returns ==
Returns <code>true</code> when the statement is queued successfully; otherwise returns <code>false</code>.

== Examples ==
Update a player's level safely:
<syntaxhighlight lang="lua" line>
local ok = dbExec(db,
"UPDATE players SET level = ? WHERE id = ?",
newLevel,
playerId
)

if not ok then
outputDebugString("Could not queue level update", 1)
end
</syntaxhighlight>

== Notes ==
* Available only in server-side resource scripts.
* Use placeholders instead of concatenating untrusted values into SQL.

[[Category:Server Functions]]
[[Category:Database Functions]]

DbExec - Revision history

QCherry: Automatyczna aktualizacja dokumentacji funkcji