Free Hero Mesh

Changes To SQL functions
Login
This is a mirror of the main repository for Free Hero Mesh. New tickets and changes will not be accepted at this mirror.

Changes to "SQL functions" between 2018-08-18 01:46:32 and 2018-08-19 21:55:55

11
12
13
14
15
16
17



18
19
20
21
22
23
24
25
26



27
28
29
30
31
32
33
34
35



36
37
38
39
40
41
42
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51







+
+
+









+
+
+









+
+
+







Returns data about the class with the given ID number.

The second argument can be: 0=class ID number, 1=Temperature, 2=Shape, 7=first image number available in editor (null if none), 12=Misc4, 13=Misc5, 14=Misc6, 15=Misc7, 18=Arrivals, 19=Departures, 32=Busy, 33=Invisible, 34=UserSignal, 35=UserState, 36=KeyCleared, 37=Player, 38=Destroyed, 39=Stealthy, 40=VisualOnly, 64=Density, 65=Volume, 66=Strength, 67=Weight, 69=Height, 70=Climb, 72=Hard(E), 73=Hard(N), 74=Hard(W), 75=Hard(S), 76=Sharp(E), 77=Sharp(N), 78=Sharp(W), 79=Sharp(S), 80=Shape(E), 81=Shape(N), 82=Shape(W), 83=Shape(S), 84=Shovable, 128=fraction of volume, 129=number of user variables, 130=CollisionLayers, 132=Compatible

<h2>CVALUE(number)</h2>
Returns a 64-bit integer representing a value of type TY_CLASS; the argument is the class number.

<h2>HEROMESH_ESCAPE(blob)</h2>
Converts a unescaped representation of a string with [formatting controls] into the escaped representation.

<h2>HEROMESH_TYPE(value)</h2>
Given a Hero Mesh value (which is represented in SQL by a 64-bit integer), return a string representing its type. It can be one of:
  *  ???
  *  class
  *  number
  *  object
  *  sound
  *  string

<h2>HEROMESH_UNESCAPE(text)</h2>
Converts a escaped representation of a string with [formatting controls] into the unescaped representation.

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

<h2>LEVEL_CACHEID()</h2>
Returns the ID number of the active level file in the user cache table.

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

<h2>LEVEL_TITLE()</h2>
Returns the level title as a blob (see [formatting controls]).

<h2>LOAD_LEVEL(levelid)</h2>
Load a level by ID; returns null. Usable only if the <tt>-x</tt> [Command-line arguments|switch] is used; otherwise it is an error.

<h2>MODSTATE()</h2>
Get the current keyboard modifiers state. It is the sum of the following:
  *  0x0001: Left shift
  *  0x0002: Right shift