D 2018-06-08T06:21:48.297 L SQL\sfunctions P 7d04819a48b4d3e3fdac399695fbb9517bb1bd24 U zzo38 W 1862 This document is a list of the available SQL functions that you can use in the customization of Free Hero Mesh. In addition to the ones listed here, you can also use the [http://sqlite.org/lang_corefunc.html|core functions], [http://sqlite.org/lang_datefunc.html|date/time functions], and [http://sqlite.org/lang_aggfunc.html|aggregate functions], of SQLite, as well as any functions defined by extensions. See also: [SQL tables]. (Note: This is only a draft and is likely to change in future.) Asterisks in the headings indicate aggregate functions.

BASENAME()

Returns the base name, which is a copy of the first command-line argument (other than switches).

KEYSTATE(key)

Given a string with a key name (the same key names used in [keybindings]), return 1 if the key is pushed or 0 if it is not pushed.

LEVEL()

Returns the one-based order number of the current level.

LEVEL_ID()

Returns the ID number of the current level.

MODSTATE()

Get the current keyboard modifiers state. It is the sum of the following: * 0x0001: Left shift * 0x0002: Right shift * 0x0040: Left control * 0x0080: Right control * 0x0100: Left alt * 0x0200: Right alt * 0x0400: Left meta * 0x0800: Right meta * 0x1000: Num lock * 0x2000: Caps lock * 0x4000: Mode

MOVENUMBER()

Tells you how many moves have been played so far since it has been reset.

PICTURE_SIZE()

Tell you the picture size.

SIGN_EXTEND(num)

Sign-extend a 32-bit integer to 64-bits. The 32-bit user variables in Free Hero Mesh might or might not be signed, so when accessing them in SQL (which uses 64-bit numbers) you must use this if you want to treat it as a signed number.

SOLUTION_REPLAY()

Returns 1 if replaying the solution or 0 for the normal game. Z 46187c923eaee05c35db808f0ad39067