General

Tags that can be used in any layout type.


{currenturl} - Current URL

Returns current URL or any query parameter, it can also be base64 encoded if you include that keyword.

COM_CUSTOMTABLES_PARAMS:
  1. Option (list)

    Select on of the available options.

    Options:

    • string: String

      Converts the input to a plain text string; strips all tags / attributes.

    • word: Word

      Only allow characters a-z, and underscores.

    • cmd: Command

      Allow a-z, 0-9, underscore, dot, dash. Also remove leading dots from result.

    • alnum: Alphanumeric

      Allow a-z and 0-9 only.

    • int: Integer

      Returns the first integer found in the parameter value.

    • uint: Unsigned Integer

      Returns an unsigned int.

    • float: Decimal

      Only use the first floating point value.

    • base64: Base64 Encode

      Returns base64 encoded value of query parameter. Or returns encoded URL if no parameter specified.

    • base64decode: Base64 Decode

      Returns decoded value of query parameter.

    • set: Sets query value

      Sets query value to communicate with different modules for example.

  2. Parameter (string)

    Url query parameter

  3. Value (string)

    Value to set Url query parameter

  4. Example:

    {currenturl:string,firstname}

{date} - Date

Returns current date in

COM_CUSTOMTABLES_PARAMS:
  1. Format (string)

    i.e. 'Y-m-d' or Joomla defined format (language supported) if left empty.

  2. Example 1:

    {date}

    Example 2:

    {date:"Y-m-d h:i:s"}

{gobackbutton} - Go Back Button

Renders a link to previous page.

COM_CUSTOMTABLES_PARAMS:
  1. Icon Image (string)

    Icon Image that will appear before text/label.

  2. Option (string)

    HTML options like: style, class, onchange etc.)

  3. Label (string)

    What will be written after the icon.

  4. Example 1:

    {gobackbutton}

    Example 2:

    {gobackbutton:,"style='border:1px solid red;'","Click to go back to the previous page"}

{format} - Output Format

The link to download the current page catalog records in specified format.

COM_CUSTOMTABLES_PARAMS:
  1. Format (list)

    Select the output format.

    Options:

    • csv: CSV

      Generates CSV file

    • json: JSON

      Generates JSON file.

    • xml: XML

      Generates XML file.

  2. Example:

    {format:csv}

{Itemid} - Menu Itemid

Joomla menu item Itemid

{server} - Server Info

Returns Sanitized (String) Server Environment value - $_SERVER

COM_CUSTOMTABLES_PARAMS:
  1. Option (list)

    Select what information to return.

    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. Example:

    {server:REMOTE_ADDR}

{table} - Table Info

Returns the current table related information

COM_CUSTOMTABLES_PARAMS:
  1. Option (list)

    Select what to show.

    Options:

    • title: Table Title

      Returns current table title.

    • description: Description

      Returns current table description.

  2. Show in message box (radio)

    Table title/description will appear in a messge type box with [X] close button.

    Options:

    • : No
    • box: Yes
  3. Example:

    {table:title,box}

{user} - User

Returns current user info (if user is logged in)

COM_CUSTOMTABLES_PARAMS:
  1. Option (list)

    Select what user info to provide.

    Options:

    • name: Name

      Returns User full name.

    • username: Username

      Returns Username

    • email: Email

      Returns User email address.

    • id: User ID

      Returns Current User ID.

    • usergroups: User Group(s)

      Returns Current User Group(s) (Registered, Editor, Super Administrator, etc...)

    • usergroupsid: User Group(s) IDs

      Returns Current User Group(s) IDs (2,4,8 etc...)

    • lastvisitDate: Last Visit Date

      Returns Current User Last Visit Date.

    • registerDate: Register Date

      Returns Current User Registration Date.

  2. User ID (string)

    To get info of specific user, not Current User. Leave it blank to get Current User info.

  3. Example:

    {user:name}

{websiteroot} - Website Root

Returns website root path (http://example.com/)

COM_CUSTOMTABLES_PARAMS:
  1. Include Host (radio)

    Include Website protocol, host, port etc.

    Options:

    • : No
    • includehost: Include
  2. Add Trailing Slashe (radio)

    Add common slash to the end of the host name. Example: https://example.com/

    Options:

    • : Add
    • notrailingslash: No
  3. Example 1:

    {websiteroot}

    Example 2:

    {websiteroot:includehost,notrailingslash}

{layout} - Layout

Includes the content of one layout to the parent layout.

COM_CUSTOMTABLES_PARAMS:
  1. Layout Name (string)

    Layout Name.

  2. Example 1:

    {layout}

    Example 2:

    {layout:my_script_layout}

{if} - If statement

Simple If statement.

COM_CUSTOMTABLES_PARAMS:
  1. Statement (string)

    Example: [price]>0

  2. Example:

    {if:[price]!=0 and [count]!=0}  Mr.[name] show this HTML {endif}

{tab} - Tabs

COM_CUSTOMTABLES_PARAMS:
  1. Title (string)

    Tab label

  2. Example:

    {tab:Tab 1} First Tab Content {tab:Tab 2} Second Tab content{/tabs}

Set Tags

Tags that may set system variables.


{headtag} - HTML Document Head Tag

Places whatever provided to HTML document head tag.

COM_CUSTOMTABLES_PARAMS:
  1. Content (string)

    You can add script or css link here or style tags. This will go to HTML document HEAD part.

  2. Example:

    {headtag:"<script src='/components/com_oxfordsms/js/ajax.js' type='text/javascript'></script>"}

{metakeywords} - Set Meta Keywords

A command to place a meta keywords into the head of the page.

COM_CUSTOMTABLES_PARAMS:
  1. Keywords (string)

    List of keywords. You may include [fieldname] to get keywords from.

  2. Example:

    {metakeywords}

{metadescription} - Set Meta Description

A command to place a meta description into the head of the page.

COM_CUSTOMTABLES_PARAMS:
  1. Description (string)

    Description text. You may include [fieldname] to get description from.

  2. Example 1:

    {metadescription}

    Example 2:

    {metadescription:"custom tables, the best joomla extension, [producttitle], database"}

{pagetitle} - Set Page Title

A command to set the Page Title.

COM_CUSTOMTABLES_PARAMS:
  1. Title (string)

    Type the Page Title here.

  2. Example 1:

    {pagetitle}

    Example 2:

    {pagetitle:"JoomlaBoat - Custom Tables"}

Extra

Extra tags


{php} - Execute PHP

Executes PHP script and returns the result.

COM_CUSTOMTABLES_PARAMS:
  1. PHP Script (code)

    PHP script will be executed and the value returned. Note that you cannot use ' (single quote) character. Also, you may have «return» in your script. Example: $a="[producttitle]" $b=strtolower($a); return $b;

  2. Example:

    {php:strtolower("[producttitle]")}

Simple Table

Renders HTML Table


{catalogtable} - Simple Catalog

Renders Simple HTML Catalog Table

COM_CUSTOMTABLES_PARAMS:
  1. Fields (catalogtable)

    Provide Table settings, columns and cell content.

  2. CSS Class (string)

    Name or names of CSS class(s).

  3. Example:

    {catalogtable}

Catalog Page Tags

Catalog Page specific Tags.


{catalog} - Catalog

Renders Catalog Page

COM_CUSTOMTABLES_PARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Format (radio)

    Render Table in HTML Table format or return clean record output)

    Options:

    • : HTML Table
    • notable: Div
  3. Example 1:

    {catalog}

    Example 2:

    {catalog:,notable}

{recordlist} - list of Records

Comma separated list or record IDs. Example: 4,78,3,876

Catalog Tags

Tags that can be used on both Catalog Page and HTML Table type layouts.


{add} - Add New

Renders Add New Record Button

COM_CUSTOMTABLES_PARAMS:
  1. (Optional) Munu Itemid or Alias (string)

    To redirect to specific Menu Item.

  2. Import CSV (radio)

    Render Import CSV file button

    Options:

    • : Add record
    • importcsv: Import CSV
  3. Example 1:

    {add}

    Example 2:

    {add:,importcsv}

{count} - Record Count (number)

Same as {recordcount:numberonly}

{navigation} - Navigation

Navigation / Breadcrumbs. Returns a value of the filter used.

COM_CUSTOMTABLES_PARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. List Type (list)

    Options:

    • list: Unordered list [ul][li][/li]...[/ul]
    • comma: Comma Separated String
  3. Example 1:

    {navigation}

    Example 2:

    {navigation:,list}

{batchtoolbar} - Batch Toolbar

Renders the batch toolbar

COM_CUSTOMTABLES_PARAMS:
  1. Button (list)

    Select button type

    Options:

    • : - None

    • refresh: Refresh

    • delete: Delete

    • publish: Publish

    • unpublish: Unpublish

  2. Example:

    {batchtoolbar:edit}

{checkbox} - Checkbox

Renders the checkbox for batch toolbar

{pagination} - Pagination Tool

renders Pagination Bar Tool.

COM_CUSTOMTABLES_PARAMS:
  1. Tool (list)

    Options:

    • pagination: Pagination
    • limit: Limit
    • order: Order
  2. Example 1:

    {pagination}

    Example 2:

    {pagination:pagination}

{print} - Print Button

A button that opens a new controlless window without template, only content.

{recordcount} - Record Count

Example: Found 23 record(s)

COM_CUSTOMTABLES_PARAMS:
  1. Format (radio)

    What to return.

    Options:

    • : Text
    • numberonly: number
  2. Example 1:

    {recordcount}

    Example 2:

    {recordcount:numberonly}

{searchbutton} - Search Button

Renders [Search] Button

COM_CUSTOMTABLES_PARAMS:
  1. CSS Class (string)

    Name or names of CSS classes separated by space.

  2. Example:

    {searchbutton}

Edit Tags

Edit Form specific Tags.


{button} - Button

Renders form submit button.

COM_CUSTOMTABLES_PARAMS:
  1. Type (list)

    Options:

    • save: Save
    • saveandclose: Save & Close
    • saveascopy: Save as Copy
    • cancel: Cancel
    • delete: Delete
  2. Button Label (string)

    The label of the button.

  3. Custom Redirect Link (string)

    URL to redirect after processing the button click.

  4. CSS Class (string)

    Name or names of CSS class(s).

  5. Example:

    {button:save,"Click here to save the form",,registerButton}

{captcha} - Captcha

Provides the use of a captcha plugin (if enabled).

Record Tags

Record specific Tags.


{id} - record ID

Returns record ID

{published} - Published

Returns «Yes» word (language depended) if record is published and «No» if not.

COM_CUSTOMTABLES_PARAMS:
  1. Format (list)

    What type of value to return.

    Options:

    • : Text (Yes/No)

      Word 'Yes' will be returned if record is published. Or Word 'No' instead.

    • number: Number (1/0)

      Number '1' will be returned if record is published. Or number '0' instead.

    • boolean: Boolean (true,false)

      Word 'true' will be returned if record is published or word 'false' instead.

  2. Example 1:

    {published}

    Example 2:

    {published:number}

Catalog Record

Catalog Record specific Tags.


{linknoreturn} - No Return Link

Link to detailed page without «returnto» link

{number} - Record Number

Returns record number (in current order), not record id.

{toolbar} - Toolbar

Renders the toolbar

COM_CUSTOMTABLES_PARAMS:
  1. Button (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  2. Example:

    {toolbar:edit}

Details

Details Specific Tags.


{print} - Print Button

A button that opens a new controlless window without template, only content.

COM_CUSTOMTABLES_PARAMS:
  1. CSS Class (string)

    Name or names of CSS class(s).

  2. Example:

    {print}

Record

Tags that can be used in Record/Details Layouts also inside HTML Table cells.


{resolve} - Resolves Hierarchical Data

Code to Textual Representation.

{_value} - Value

Returns 1 if record is published and 0 if unpublished.

COM_CUSTOMTABLES_PARAMS:
  1. Parameter (list)

    Returns value of what

    Options:

    • published: Published

      Returns «1» if record is published and «0» if not.

  2. Example:

    {_value:published}

{_value} - Field Value

Returns unprocessed value of the field.

COM_CUSTOMTABLES_PARAMS:
  1. Field (field)

    Select Field

{_edit} - Field Edit box

Renders input/select box for selected field. It works in all types of layout except Edit Form.

COM_CUSTOMTABLES_PARAMS:
  1. Field (field)

    Select Field

{sqljoin} - Table Join

Returns value of joined table field.

COM_CUSTOMTABLES_PARAMS:
  1. Function (list)

    What to do with returned value(s)

    Options:

    • count: Count

      Counts the number of records that match.

    • avg: Average

      Calculate average value of all the records that match.

    • min: Minimum

      Finds minimum value of all the records that match.

    • max: Maximum

      Finds maximum value of all the records that match.

    • sum: Sum

      Summarizes values of selected field of all the records that match.

    • value: Value

      Returns the value of selected field of all the records that match.

    • smart: Hierarchical

      resolves value of selected field.

  2. Join With Table (string)

    Table Name to join with (Where to look)

  3. Find What Field (string)

    Findwhat: field of the current table. use '_id' to find current table record id.

  4. Where to Look Field (string)

    Field of joined table

  5. Value Field (string)

    Value of joined table field.

  6. Additional Filter (string)

    Apply additional filter, ie. fieldname=some value. Use $get_queryparameter to get query parameter value. Example: $get_year

  7. Example:

    {sqljoin:count,sales,_id,productid,_id}

{toolbar} - Toolbar

Renders the toolbar

COM_CUSTOMTABLES_PARAMS:
  1. Button 1 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  2. Button 2 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  3. Button 3 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  4. Button 4 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  5. Button 5 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  6. Button 6 (list)

    Options:

    • : - None
    • edit: Edit
    • refresh: Refresh
    • delete: Delete
    • publish: Publish/Unpublish
    • imagegallery: Image Gallery
    • filebox: File Box
  7. Example:

    {toolbar:edit,publish,refresh,delete}

Plugins

Custom Tables Plugins.


{customtablescatalog} - Custom Tables Catalog

Returns a Custom Table catalog results into. Enable Content Plugins in menu item settings.

COM_CUSTOMTABLES_PARAMS:
  1. Table (string)

    Table Name

  2. Page Layout (string)

    Type the name of Catalog Layout

  3. Record Layout (string)

    Type the name of Record Layout

  4. Publish State (radio)

    What record states to show.

    Options:

    • 2: Show All
    • 1: Show Published
    • 0: Show Unpublished
  5. Filter (string)

    Additional filter, ie. fieldname=some value. field to search in = (or < or <= or > or >= or !=) value (or special macro as {currentuserid} for example ) to have more then one equation use AND, OR to get value from url query add '$get_' to parameter name, example 'username=$get_user' this will read value 'user' from url query.

  6. Columns (radio)

    Leave it empty. This parameter no longer used

    Options:

    • :
  7. Sort by field (string)

    Type field name to sort by. Example 1: 'title desc' Example 2: 'title asc'. Note that keyword asc is not necessary.

  8. Force Itemid (string)

    Used to set parameters for edit form etc.

  9. Example:

    {customtablescatalog=products,productspage,productrecord,2,count>0,,title}

{customtablesrecord} - Custom Tables Record

Returns Custom Tables single Record by ID. Enable Content Plugins in menu item settings.

COM_CUSTOMTABLES_PARAMS:
  1. Table (string)

    Table Name

  2. Layout (string)

    Details type layout

  3. Record ID or Filter (string)

    Record ID or filter. Example 1: 2, Example 2: title=about, Example 3: title=$get_title

  4. Example:

    {customtablesrecord=products,productdetails,"[productid]"}

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.