Field Types

Table Field Types

A database field is a single piece of information from a record. A database record is a set of fields.

The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store.

Field Type Parameters - Tells additional details to the database about how to store a value and configures general behavior of the input boxes.
Edit Record Parameters - Used in Edit Record layout and it configures the input box appearance and functionality.
Value Processing Parameters - Used in Catalog Record layouts and Details layouts, configures how to process stored value and render HTML content.

string - Text String (Single Line)

Provides a text box for data entry.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Length (number)

    Number of characters. Number of characters not bytes.

    • COM_CUSTOMTABLES_DEFAULT: 255
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024

    2. COM_CUSTOMTABLES_EXAMPLE: 

    30

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:my_CSS_class,onclick='alert(1);']

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Limit Output (list)

    Limits returning output text, first number of characters or first number of words.

    COM_CUSTOMTABLES_OPTIONS:

    • : Returns as it is

    • chars: Returns first number of characters from text that was trimmed, sanitized and HTML tags stripped.

    • words: Returns first number of words from text that was trimmed, sanitized and HTML tags stripped.

    • firstimage: Returns the link to a first image found in the text.

  2. Length (number)

    Number of characters or words.

    • COM_CUSTOMTABLES_DEFAULT:
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024
  3. Clean Braces (radio)

    Deletes all braces from the text. (i.e. to avoid Content Plugins running.)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  4. Clean Quotes (radio)

    Deletes all quotes from the text.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes

    5. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:chars,30,true,true]

multilangstring - Multilingual Text String (Single Line)

Provides a set of text boxes for data entry. One inputbox for each language.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Length (number)

    Number of characters. Number of characters not bytes.

    • COM_CUSTOMTABLES_DEFAULT: 255
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024

    2. COM_CUSTOMTABLES_EXAMPLE: 

    50

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Limit Output (list)

    Limits returning output text, first number of characters or first number of words.

    COM_CUSTOMTABLES_OPTIONS:

    • : Returns as it is

    • chars: Returns first number of characters from text that was trimmed, sanitized and HTML tags stripped.

    • words: Returns first number of words from text that was trimmed, sanitized and HTML tags stripped.

    • firstimage: Returns the link to a first image found in the text.

  2. Length (number)

    Number of characters or words.

    • COM_CUSTOMTABLES_DEFAULT:
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024
  3. Clean Braces (radio)

    Deletes all braces from the text. (i.e. to avoid Content Plugins running.)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  4. Clean Quotes (radio)

    Deletes all quotes from the text.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  5. Language (language)

    Specify the language. Default front-end languege will be used if not specified.

    6. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:chars,1,true,true]

alias - Alias (For SEO Links)

Alias field that can be used insted of listing_id for SEO purpose.

color - Color

Provides Color Picker functionality in the Edit Form or hexidecimal value as output.

text - Text Area (Multilple Lines)

Provides a textarea box for data entry.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Text Editor (list)

    COM_CUSTOMTABLES_OPTIONS:

    • : No Editor
    • rich: Rich Text Editor
  2. Spell Checker (radio)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • spellcheck: Yes

    3. COM_CUSTOMTABLES_EXAMPLE: 

    rich,spellcheck

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Limit Output (list)

    Limits returning output text, first number of characters or first number of words.

    COM_CUSTOMTABLES_OPTIONS:

    • : Returns as it is

    • chars: Returns first number of characters from text that was trimmed, sanitized and HTML tags stripped.

    • words: Returns first number of words from text that was trimmed, sanitized and HTML tags stripped.

    • firstimage: Returns the link to a first image found in the text.

  2. Length (number)

    Number of characters or words.

    • COM_CUSTOMTABLES_DEFAULT:
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024
  3. Clean Braces (radio)

    Deletes all braces from the text. (i.e. to avoid Content Plugins running.)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  4. Clean Quotes (radio)

    Deletes all quotes from the text.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes

    5. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:50,1,true,true]

multilangtext - Multilingual Text Area (Multilple Lines)

Provides a set of textarea boxes for data entry. One textarea box for each language.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Text Editor (list)

    COM_CUSTOMTABLES_OPTIONS:

    • : No Editor
    • rich: Rich Text Editor
  2. Spell Checker (radio)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • spellcheck: Yes

    3. COM_CUSTOMTABLES_EXAMPLE: 

    rich,spellcheck

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Limit Output (list)

    Limits returning output text, first number of characters or first number of words.

    COM_CUSTOMTABLES_OPTIONS:

    • : Returns as it is

    • chars: Returns first number of characters from text that was trimmed, sanitized and HTML tags stripped.

    • words: Returns first number of words from text that was trimmed, sanitized and HTML tags stripped.

    • firstimage: Returns the link to a first image found in the text.

  2. Length (number)

    Number of characters or words.

    • COM_CUSTOMTABLES_DEFAULT:
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 1024
  3. Clean Braces (radio)

    Deletes all braces from the text. (i.e. to avoid Content Plugins running.)

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  4. Clean Quotes (radio)

    Deletes all quotes from the text.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  5. Language (language)

    Specify the language. Default front-end languege will be used if not specified.

    6. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:chars,50,true,true]

int - Integer Number

Provides an integer number inputbox.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

float - Float (Decimal) Number

Provides a decimal number inputbox.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Decimals (number)

    Number of digits to the right of the decimal point (the scale). Must be no larger than Precision Number of digits.

    • COM_CUSTOMTABLES_DEFAULT: 2
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 30
  2. Precision (number)

    Maximum number of digits (the precision).

    • COM_CUSTOMTABLES_DEFAULT: 20
    • COM_CUSTOMTABLES_MIN: 1
    • COM_CUSTOMTABLES_MAX: 65
  3. Smart Imput (radio)

    Allows input without pressing decimal point key. Example: to type [12.67] just type [1267] The decimal point will be placed by itself.

    COM_CUSTOMTABLES_OPTIONS:

    • smart: Yes
    • : No

    4. COM_CUSTOMTABLES_EXAMPLE: 

    2,1,smart

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:inputboxClass,readonly='readonly']

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Number of decimals (number)

    Format returning number. Add tracing 0 if needed. (useful when formating a currency)

    • COM_CUSTOMTABLES_DEFAULT:
    • COM_CUSTOMTABLES_MAX: 30
  2. Decimal Separator (string)

    Separate decimals with provided character. i.e. ',' or '.'

  3. Thousand Separator (string)

    Separate thousands with provided character. i.e. ',' or '.' or ' ' (space)

    4. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:2,.,","]

records - SLQ Table Join (Multiple)

Provides a Multiple Left Join to records of another table.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Table (string)

    Type the name of the Custom Table to join/link with.

  2. Field Name (string)

    Type the field name to return the value from (that can be overwritten in Layout). You may type layout name instead. options: [layout:the layout or tablelesslayout:the layout]

  3. Selector (list)

    How to select records.

    COM_CUSTOMTABLES_OPTIONS:

    • single: Single Record (Dropdown List)

    • multi: Multiple Records (Dropdown List)

    • radio: Single Record (Radio)

    • checkbox: Multiple Records (Checkboxes)

    • multibox: Multiple Records (Add Record List, requires Dynamic Filter)

  4. Filter (string)

    Limits records using filter. Example: [age>30] where age is a field in joining table

  5. Dynamic Filter (string)

    Used with multibox, requires that joining table contain SQL Join field to use it as Category Filter

  6. Order By (string)

    Field name to sort record by

  7. Allow Unpublished (radio)

    Allow to select unpublished records.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes

    8. COM_CUSTOMTABLES_EXAMPLE: 

    products,title,single,,,title,true

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

checkbox - Checkbox (YES/NO)

Provides a single checkbox to be checked or unchecked

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

email - Email

Provides an email field.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

date - Date

Date Picker

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Format (string)

    PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.

    2. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:Y-m-d]

image - Image File

Provides Image Upload functionality.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Image Size Options (imagesizelist)

    You may specify various size options. When image file being uploaded, the Custom Tables will create a modified version(s) of the image file based on the settings provided.

  2. Image Processing Methods (multiselect)

    Image processing methods that will be applied to newly uploaded image. This option available in Pro Version Only.

  3. Folder (folder)

    Folder where all the files will be kept. By default /images

    4. COM_CUSTOMTABLES_EXAMPLE: 

    "id,100,100,,jpg",,/images/product_photos

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

imagegallery - Image Gallery
COM_CUSTOMTABLES_AVAILABLE

Provides Multiple Image Upload functionality.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Image Size Options (imagesizelist)

    You may specify various size options. When image file being uploaded, the Custom Tables will create a modified version(s) of the image file based on the settings provided.

  2. Image Processing Methods (multiselect)

    Image processing methods that will be applied to a newly uploaded image. This option availabel in Pro Version Only.

  3. Folder (folder)

    Folder where all the files will be kept. By default /images

    4. COM_CUSTOMTABLES_EXAMPLE: 

    "id,100,100,,jpg",,/images/product_photos

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

file - File

Provides File Upload functionality.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Max File Size (int)

    Maximum file size that can be uploaded to the server (in megabytes). Note: check your PHP settings as well.

  2. Folder (folder)

    Folder where all the files will be kept. By default /images

  3. File Types (string)

    List of acceptable file types (list separated by space)

  4. Save As File Name (string)

    Specify the name of a newly uploaded file. You may use field tags [fieldname]

  5. Custom PHP (string)

    PHP file/function that will process file content before being downloaded by the user. File must be located at /components/com_customtables/customphp.

    6. COM_CUSTOMTABLES_EXAMPLE: 

    8,/images/user_files,"doc docx"

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Security (list)

    Encrypts the link to the file and limits access time to it.

    COM_CUSTOMTABLES_OPTIONS:

    • : Public. Direct link to the file.

    • timelimited: Time Limited (8-24 minutes)

    • timelimited_longterm: Time Limited (1.5 - 4 hours)

    • hostlimited: Time/Host Limited (8-24 minutes)

    • hostlimited_longterm: Time/Host Limited (1.5 - 4 hours)

    • private: Time/Host/User Limited (8-24 minutes)

    • private_longterm: Time/Host/User Limited (1.5 - 4 hours)

    2. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:timelimited]

filebox - File Box
COM_CUSTOMTABLES_AVAILABLE

Provides Multiple File Upload functionality. It also tracks versions.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Max File Size (int)

    Maximum file size that can be uploaded to the server (in megabytes). Note: check your PHP settings as well.

  2. Folder (folder)

    Folder where all the files will be kept. By default /images

  3. File Type (string)

    List of acceptable file types (list separated by space)

    4. COM_CUSTOMTABLES_EXAMPLE: 

    20,/images/userfiles,"pdf ppt"

filelink - File Link

Path to a folder on the server. Provides selection of the file at provided path.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Folder (folder)

    Folder a user can select a file from.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    /images/userfiles

creationtime - Creation Time

Stores the date/time when record was created.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Format (string)

    PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.

    2. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:Y-m-d]

changetime - Change Time

Stores the date/time when record was last modified.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Format (string)

    PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.

    2. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:Y-m-d]

lastviewtime - View Time

Stores the date/time when record was last viewed.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

COM_CUSTOMTABLES_VALUEPARAMS:
  1. Format (string)

    PHP date format i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty. 'timestamp' to return the datetime in UNIX timestamp format.

    2. COM_CUSTOMTABLES_EXAMPLE 1: 

    [COM_CUSTOMTABLES_FIELDNAME]

    COM_CUSTOMTABLES_EXAMPLE 2: 

    [COM_CUSTOMTABLES_FIELDNAME:Y-m-d]

viewcount - View Count

Stores the view count number.

userid - Author User

Stores the ID of the user who created the record.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

user - User

Provides User Selection box. It can also create a New User account if all nessesary fields are set: Name,Email,User Group(s)

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. User Groups (string)

    Limit selection to certain User Group(s). Or used as default User Group(s) when creating a new user account.

  2. Name (string)

    Used to create new user account only. Field tags, example: [firstname] [lastname]

  3. Email (string)

    Used to create new user account only. Field tags, example: sales@joomlaboat.com

  4. Name Filter (string)

    Limit selection to certain name - name must content this characters.

  5. Unique Users (radio)

    Do not let assign same user account to different records.

    COM_CUSTOMTABLES_OPTIONS:

    • : Not Unique
    • unique: Unique

    6. COM_CUSTOMTABLES_EXAMPLE: 

    ,,,,unique

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

language - Language

Provides Language Selection box.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

server - Server Info
COM_CUSTOMTABLES_AVAILABLE

Server and execution environment variables. See: http://php.net/manual/en/reserved.variables.server.php

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Option (list)

    Select what information to save.

    COM_CUSTOMTABLES_OPTIONS:

    • REMOTE_ADDR: REMOTE_ADDR

      The IP address from which the user is viewing the current page.

    • HTTP_REFERER: HTTP_REFERER

      The address of the page (if any) which referred the user agent to the current page. This is set by the user agent. Not all user agents will set this, and some provide the ability to modify HTTP_REFERER as a feature. In short, it cannot really be trusted.

    • REMOTE_HOST: REMOTE_HOST

      The Host name from which the user is viewing the current page. The reverse dns lookup is based off the REMOTE_ADDR of the user.

    • REMOTE_PORT: REMOTE_PORT

      The port being used on the user's machine to communicate with the web server.

    • REMOTE_USER: REMOTE_USER

      The authenticated user.

    • PHP_SELF: PHP_SELF

      The filename of the currently executing script, relative to the document root.

    • GATEWAY_INTERFACE: GATEWAY_INTERFACE

      Revision of the CGI specification the server is using; i.e. 'CGI/1.1'

    • SERVER_ADDR: SERVER_ADDR

      The IP address of the server under which the current script is executing.

    • SERVER_NAME: SERVER_NAME

      The name of the server host under which the current script is executing. If the script is running on a virtual host, this will be the value defined for that virtual host.

    • SERVER_SOFTWARE: SERVER_SOFTWARE

      Server identification string, given in the headers when responding to requests.

    • SERVER_PROTOCOL: SERVER_PROTOCOL

      Name and revision of the information protocol via which the page was requested; i.e. 'HTTP/1.0'

    • REQUEST_METHOD: REQUEST_METHOD

      Which request method was used to access the page; i.e. 'GET', 'HEAD', 'POST', 'PUT'.

    • REQUEST_TIME: REQUEST_TIME

      The timestamp of the start of the request. Available since PHP 5.1.0.

    • REQUEST_TIME_FLOAT: REQUEST_TIME_FLOAT

      The timestamp of the start of the request, with microsecond precision. Available since PHP 5.4.0.

    • QUERY_STRING: QUERY_STRING

      The query string, if any, via which the page was accessed.

    • DOCUMENT_ROOT: DOCUMENT_ROOT

      The document root directory under which the current script is executing, as defined in the server's configuration file.

    • HTTP_ACCEPT: HTTP_ACCEPT

      Contents of the Accept: header from the current request, if there is one.

    • HTTP_ACCEPT_CHARSET: HTTP_ACCEPT_CHARSET

      Contents of the Accept-Charset: header from the current request, if there is one. Example: 'iso-8859-1,*,utf-8'.

    • HTTP_ACCEPT_ENCODING: HTTP_ACCEPT_ENCODING

      Contents of the Accept-Encoding: header from the current request, if there is one. Example: 'gzip'.

    • HTTP_ACCEPT_LANGUAGE: HTTP_ACCEPT_LANGUAGE

      Contents of the Accept-Language: header from the current request, if there is one. Example: 'en'.

    • HTTP_CONNECTION: HTTP_CONNECTION

      Contents of the Connection: header from the current request, if there is one. Example: 'Keep-Alive'.

    • HTTP_HOST: HTTP_HOST

      Contents of the Host: header from the current request, if there is one.

    • HTTP_USER_AGENT: HTTP_USER_AGENT

      Contents of the User-Agent: header from the current request, if there is one. This is a string denoting the user agent which is accessing the page. A typical example is: Mozilla/4.5 [en] (X11; U; Linux 2.2.9 i586). Among other things, you can use this value with get_browser() to tailor your page's output to the capabilities of the user agent.

    • HTTPS: HTTPS

      Set to a non-empty value if the script was queried through the HTTPS protocol.

    • REDIRECT_REMOTE_USER: REDIRECT_REMOTE_USER

      The authenticated user if the request is internally redirected.

    • SCRIPT_FILENAME: SCRIPT_FILENAME

      The absolute pathname of the currently executing script.

    • SERVER_ADMIN: SERVER_ADMIN

      The value given to the SERVER_ADMIN (for Apache) directive in the web server configuration file. If the script is running on a virtual host, this will be the value defined for that virtual host.

    • SERVER_PORT: SERVER_PORT

      The port on the server machine being used by the web server for communication. For default setups, this will be '80'; using SSL, for instance, will change this to whatever your defined secure HTTP port is.

    • SERVER_SIGNATURE: SERVER_SIGNATURE

      String containing the server version and virtual host name which are added to server-generated pages, if enabled.

    • PATH_TRANSLATED: PATH_TRANSLATED

      Filesystem- (not document root-) based path to the current script, after the server has done any virtual-to-real mapping.

    • SCRIPT_NAME: SCRIPT_NAME

      Contains the current script's path. This is useful for pages which need to point to themselves. The __FILE__ constant contains the full path and filename of the current (i.e. included) file.

    • REQUEST_URI: REQUEST_URI

      The URI which was given in order to access this page; for instance, '/index.html'.

    • PHP_AUTH_DIGEST: PHP_AUTH_DIGEST

      When doing Digest HTTP authentication, this variable is set to the 'Authorization' header sent by the client (which you should then use to make the appropriate validation).

    • PHP_AUTH_USER: PHP_AUTH_USER

      When doing HTTP authentication, this variable is set to the username provided by the user.

    • PHP_AUTH_PW: PHP_AUTH_PW

      When doing HTTP authentication, this variable is set to the password provided by the user.

    • AUTH_TYPE: AUTH_TYPE

      When doing HTTP authentication, this variable is set to the authentication type.

    • PATH_INFO: PATH_INFO

      Contains any client-provided pathname information trailing the actual script filename but preceding the query string, if available. For instance, if the current script was accessed via the URL http://www.example.com/php/path_info.php/some/stuff?foo=bar, then $_SERVER['PATH_INFO'] would contain /some/stuff.

    • ORIG_PATH_INFO: ORIG_PATH_INFO

      Original version of 'PATH_INFO' before processed by PHP.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    REMOTE_ADDR

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

id - Custom Record ID

Autoincremented ID. parameter: start from number

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Start Number (number)

    The value starts from number

    • COM_CUSTOMTABLES_DEFAULT: 1
    • COM_CUSTOMTABLES_MIN: 1

    2. COM_CUSTOMTABLES_EXAMPLE: 

    3

phponadd - PHP On Add
COM_CUSTOMTABLES_AVAILABLE

Executes PHP script on record added event.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. PHP Script (string)

    Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    "Time is ".(time()+3600)

phponchange - PHP On Change
COM_CUSTOMTABLES_AVAILABLE

Executes PHP script on record change event.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. PHP Script (string)

    Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    "[firstname]"."[lastname]"

phponview - PHP On View
COM_CUSTOMTABLES_AVAILABLE

Executes PHP script on record view event.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. PHP Script (string)

    Note that you cannot use single quote symbol. In addition you may use any field value, to do so, just type [fieldname], see more about table catalog layout.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    "Time is ".(time()+3600)

sqljoin - Table Join

Left Join to another table, finds the record and reads value of any field.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Table (string)

    Type the name of the Custom Table to join/link with.

  2. Field Name (string)

    Type the field name to return the value by defualt. You may type layout name instead. options: 'layout:layout_name' or 'tablelesslayout:layout_name'

  3. Filter (string)

    Limits records using filter. Example: [age>30] where age is a field in joining table

  4. Dynamic Filter (string)

    Used with multibox, requires that joining table contain SQL Join field to use it as Category Filter

  5. Order By (string)

    Field name to sort record by

  6. Allow Unpublished (radio)

    Allow to select unpublished records.

    COM_CUSTOMTABLES_OPTIONS:

    • : No
    • true: Yes
  7. Selector (list)

    How to select records.

    COM_CUSTOMTABLES_OPTIONS:

    • dropdown: Dropdown List

    • radio: Radio

    8. COM_CUSTOMTABLES_EXAMPLE: 

    products,title,,,title,true,dropdown

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

googlemapcoordinates - GPS Coordinates

Google Map Coordinates (Latitude and Longitude) with selection map

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

dummy - Translation

Use field name to add translations of some terms in your layout. This doesn't store anything in the Data Base.

article - Article

Select Article box.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

multilangarticle - Article (Multilingual)

Select Article box per each language installed.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

md5 - MD5 Hash
COM_CUSTOMTABLES_AVAILABLE

MD5 Hash calculated based on selected fields values.

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. List of Fields (string)

    Field Values will be taken and MD5 Hash code will be calculated over it.

    2. COM_CUSTOMTABLES_EXAMPLE: 

    "firstname,lastname,birthdate"

log - Change Log
COM_CUSTOMTABLES_AVAILABLE

Logs all record modifications. User, Datetime, IP. You can return to the previous version of the record.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

usergroup - User Group

User Group Select Box.

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

usergroups - User Groups

User Group Multi Select Box

COM_CUSTOMTABLES_FIELDTYPEPARAMS:
  1. Selector (list)

    How to select records.

    COM_CUSTOMTABLES_OPTIONS:

    • single: Single User Group (Select Box)

    • multi: Multiple User Groups (List Box)

    • radio: Single User Group (Radio)

    • checkbox: Multiple User Groups (Checkboxes)

    2. COM_CUSTOMTABLES_EXAMPLE: 

    multi

COM_CUSTOMTABLES_EDITRECPARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Attributes (string)

    Optional attributes like: disabled, onclick, onchange etc.

    3. COM_CUSTOMTABLES_EXAMPLE: 

    [COM_CUSTOMTABLES_FIELDNAME]

JoomlaBoat.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters
the trademark holder in the United States and other countries.