1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
This document explains the SQL functions and SQL tables which are
available for the user customization in Free Hero Mesh. (You cannot
use SQL to define the rules of the game.)
=== Functions ===
Asterisks denote aggregate/window functions.
BASENAME()
The base name, which is a copy of the first command-line argument (not
counting the switches or the program name).
CL(text)
Returns the class number, given the class name. If there is no such
class, then the result is null. (This may be useful as a shortcut when
used with the "OBJECTS" or "CLASSES" table.)
CLASS_DATA(id,info)
Returns data about a class.
|
>
>
>
>
>
>
>
>
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
This document explains the SQL functions and SQL tables which are
available for the user customization in Free Hero Mesh. (You cannot
use SQL to define the rules of the game.)
=== Functions ===
Asterisks denote aggregate/window functions.
BASENAME()
The base name, which is a copy of the first command-line argument (not
counting the switches or the program name).
BCAT(...)
Concatenate several blobs. Nulls are skipped, if any.
BYTE(...)
Make a blob; each argument is a number, of which the low 8-bits are used
to make the value of one byte in the blob, so the size of the blob will
then be the same as the number of arguments.
CL(text)
Returns the class number, given the class name. If there is no such
class, then the result is null. (This may be useful as a shortcut when
used with the "OBJECTS" or "CLASSES" table.)
CLASS_DATA(id,info)
Returns data about a class.
|