Free Hero Mesh

Changes To SQL tables
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 tables" between 2018-06-08 06:22:35 and 2018-06-10 21:19:46

19
20
21
22
23
24
25
26

27
28
29
30
31
32
33

34
35
36
37
38
39
40
19
20
21
22
23
24
25

26
27
28
29
30
31
32

33
34
35
36
37
38
39
40







-
+






-
+







<h2>MOVES *</h2>

<h2>OBJECTS *</h2>

This table is read-only in game mode; it can be written in edit mode.

<h2>PICTURES</h2>
<verbatim-1>CREATE TEMPORARY TABLE "PICTURES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT, "OFFSET" INT);</verbatim-1>
<verbatim-1>CREATE TEMPORARY TABLE "PICTURES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT COLLATE NOCASE, "OFFSET" INT);</verbatim-1>

A list of all of the pictures that are available; loaded from the .xclass file. Probably only the NAME column is useful to the user; it is the lump name without the .IMG suffix.

While it is possible to write to this table, there is probably no use to do so.

<h2>USERCACHEDATA</h2>
<verbatim-1>CREATE TABLE "USERCACHEDATA"("ID" INTEGER PRIMARY KEY, "FILE" INT, "LEVEL" INT, "NAME" TEXT, "OFFSET" INT, "DATA" BLOB, "USERSTATE" BLOB);</verbatim-1>
<verbatim-1>CREATE TABLE "USERCACHEDATA"("ID" INTEGER PRIMARY KEY, "FILE" INT, "LEVEL" INT, "NAME" TEXT COLLATE NOCASE, "OFFSET" INT, "DATA" BLOB, "USERSTATE" BLOB);</verbatim-1>

Data of user cache. The following columns are available:
  *  FILE: The ID in the USERCACHEINDEX table of the file it corresponds to.
  *  LEVEL: This is null if it is an unrecognized lump, or else the level number. It is -1 for the LEVEL.IDX lump, and -2 for the CLASS.DEF lump.
  *  NAME: The lump name.
  *  OFFSET: The offset into the file where the data of this lump begins.
  *  DATA: Normally null. If the contents of this lump have been changed but it has not yet been written to the Hamster archive file, this contains the new data for this lump.
50
51
52
53
54
55
56
57

50
51
52
53
54
55
56

57







-
+
The user cache is used to store the offsets for the .level and .solution files, as well as data that is waiting to be written to those files.

Tampering with the data in this table can have unexpected consequences; you should only use this if you want to clear the cache entirely, or if you have renamed the file and want the cache to continue to work (neither should be done while the puzzle set is currently loaded; use the sqlite3 command-line instead of doing it within Free Hero Mesh).

<h2>VARIABLES</h2>
<verbatim-1>CREATE TEMPORARY TABLE "VARIABLES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT);</verbatim-1>

List of all global and local variables. The ID is the class number left shifted by sixteen bits (the class number is zero for global variables), and then the low sixteen bits have the variable number. The name omits the <tt>@</tt> or <tt>%</tt> prefix.
List of all global and local variables. The ID is the class number left shifted by sixteen bits (the class number is zero for global variables), and then the low sixteen bits have the zero-based variable number. The name omits the <tt>@</tt> or <tt>%</tt> prefix.