D 2018-04-27T20:38:13.588
L SQL\sfunctions
P 727b20ec5c1663ded07bf74d627e7eb5574e198c
U zzo38
W 1242
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. See also: [SQL tables].

(Note: This is only a draft and is likely to change in future.)

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

<h2>KEYSTATE(key)</h2>
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.

<h2>LEVEL()</h2>
Returns the one-based order number of the current level.

<h2>LEVEL_ID()</h2>
Returns the ID number of the current level.

<h2>MODSTATE()</h2>
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

Z 80b404356dc7e1acdb79054f383d33da