<< Click to Display Table of Contents >> Navigation:  »No topics above this level« Cheat Sheet

 

All commands and variables at a glance:

 

The variables for the directory placeholders: (Administrator stands for the current user)

 

Only for windows:

 

Variable:                        Beispiel:                                                                                                                          

%USERPROFILE%                        C:\Users

%PROGRAMFILES%                C:\Program Files

%USERFILESX64%                C:\Program Files

%USERFILESX86%                C:\Program Files (x86)

%COMMONX64%                        C:\Program Files\Common Files

%USERFILESX86%                C:\Program Files (x86)\Common Files

%COMMONPROGFILES%                C:\Program Files\Common Files

%COMMONAPPDATA%                C:\ProgramData

%COMMONTEMPLATES%                C:\ProgramData\Microsoft\Windows\Templates

%PUBLIC%                        C:\Users\Public

%COMMONDOCUMENTS%                C:\Users\Public\Documents

%PROFILE%                        C:\Users\Administrator

%DESKTOP%                        C:\Users\Administrator\Desktop

%USERDOCUMENTS%                C:\Users\Administrator\Documents

%APPDATA%                        C:\Users\Administrator\AppData\Roaming

%USERDOCUMENTLIB%                C:\Users\Administrator\AppData\Roaming\Microsoft\Windows\Libraries\Documents.library-ms

%LIBRARIES%                        C:\Users\Administrator\AppData\Roaming\Microsoft\Windows\Libraries

%TEMPLATES%                        C:\Users\Administrator\AppData\Roaming\Microsoft\Windows\Templates

%APPDATALOW%                        C:\Users\Administrator\AppData\LocalLow

%USERCOMMONFILES%                C:\Users\Administrator\AppData\Local\Programs\Common

%USERPROGRAMFILES%                C:\Users\Administrator\AppData\Local\Programs

%LOCALAPPDATA%                C:\Users\Administrator\AppData\Local

%SCORIETDATA%                        C:\Users\Administrator\Documents\Scoriet\Data

%SCORIETTEMPLATES%                C:\Users\Administrator\Documents\Scoriet\Templates

 

This is an incomplete list of template commands:

 

Switch:

{switch %}

{case %}

{othercase}

{endswitch}

 

IF:

{if %}

{elseif %}

{else}

{endif}

 

FOR:

{for %}

{break}

{endfor}

 

CODE:

{code: %}

 

INCLUDE:

{include: %}

 

Project Array, all Files and Information needed to generate:

 

PROJECT:

{projectname} - The project name

{projectdirectory} - The destination project directory

{projecturl} - The project URL

{projectdatabase} - The database name

{projectid} - The project ID

{projecttemplateid} - The template ID

{projectdbid} - The database connection ID

{projectdbtype} - The database type (atm. only MySQL)

{projectdbdesc} - The description of the project

{projectdbpassword} - The database password

{projectdbusername} - The database username

{projectdbserver} - The address of the MySQL server

 

PROJECT VARS:

{nmaxfiles} - Count of all files in the project

{nmaxitems} - Count of all items in the actual file

{nmaxitemsnokey} - Count of all items in the actual file, without the key(s)

{nmaxkeys} - Count off all keys in the actual file

{nmaxforeignkeys} - Count of all foreign keys in the actual file

{nmaxitemsmasterdetail} - Count of all items in the master-detail file

{nmaxitemsmasterdetailnokeys} - Count of all items in the master-detail file, without the key(s)

{nmaxlanguages} - Count of all languages

{var: %} - Prints a internal variable

 

FILE:

{filename} - The actual file

{filenameshort} - The actual file short name

{filenamecc} - The file name as camel case, ie template_master will be TemplateMaster

{fileid} - The actual file name

{filegeneratemasterdetail} - On the actual file, will a master-detail file generated?

{filedetailfileid} - The actual master-detail file id

{filedetailfilename} - The actual master-detail filename

{filedetailkey} - The actual master-detail file key (keyname not fieldname)

 

FILES:

{file.name} - In a loop, the filename of the actual file

{file.nameshort} - In a loop, the actual file short name

{file.id} - In a loop, the actual file name

{file.generatemasterdetail} - In a loop, on the actual file, will a master-detail file generated?

{file.detailfileid} - In a loop, the actual master-detail file id

{file.detailfilename} - In a loop, the actual master-detail filename

{file.detailkey} - In a loop, the actual master-detail file key (keyname not fieldname)

 

ITEMS:

{item.filename}

{item.name}

{item.typecast}

{item.default}

{item.type}

{item.id}

{item.sortindex}

{item.caption}

{item.controltype}

{item.editmask}

{item.size}

{item.notnull}

{item.autoincrement}

{item.unsigned}

{item.visible}

{item.projectid}

 

KEYS:

{keys.name}

{keys.id}

{keys.key}

{keys.type}

{keys.typecast}

 

FOREIGN KEYS:

{foreign.sourcetableitem}

{foreign.tablename}

{foreign.itemname}

{foreign.displayname}

{foreign.displayid}

 

LANGUAGE:

{languageid}

{languagetoken}

{languagesourcetoken}

{languagedescription}

 

LANGUAGES:

{language.id}

{language.token}

{language.sourcetoken}

{language.description}

 

TEMPLATE:

{templatename}

{templatefolder}

{templatepageid}

{templatepagetyp}

{templatepageconstruct}

{templatepagefilename}

{templatepagefolder}

{templatepagename}