ct4.us

Overview #

A BLOB is a binary large object that can hold an entire file.

Field Type Parameters: #

1. Maximum length – Maximum length of the value to be held.

   • tiny – (255 Bytes (TINYBLOB). A binary large object column with a maximum length of 255 (2^8 – 1) bytes. Each TINYBLOB value is stored using a one-byte length prefix that indicates the number of bytes in the value..)
   • (Default. 64KB (BLOB). A binary large object column with a maximum length of 65535 (2^16 – 1) bytes, or 64KB in storage. Each BLOB value is stored using a two-byte length prefix that indicates the number of bytes in the value..)
   • medium – (16MB (MEDIUMBLOB). A binary large object column with a maximum length of 16777215 (2^24 – 1) bytes, or 16MB in storage. Each MEDIUMBLOB value is stored using a three-byte length prefix that indicates the number of bytes in the value..)
   • long – (4GB (LONGBLOB). A binary large object column with a maximum length of 4294967295 (2^32 – 1) bytes, or 4GB in storage. Each LONGBLOB value is stored using a four-byte length prefix that indicates the number of bytes in the value..)

2. File Types – List of acceptable file types (list separated by spaces).

3. Field to get the file name from / to – Specify the name of the field where to store the original file name. By default, the file name will be the current timestamp and guessed file extension.

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

---

Value Processing Parameters: #

Basic usage:

{{ FieldName }}

Usage with parameters:

{{ FieldName(Security, Link, Icon, Target Window) }}

1. Security – Encrypts the link to the file and limits access time to it.

   • (Default. 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. Link – How to render the link.

   • icon-filename-link – (Clickable Icon and File Name)
   • icon-link – (Clickable Icon)
   • filename-link – (Clickable File Name)
   • link-anchor – (Clickable Link)
   • icon – (Icon (IMG tag))
   • (Default. Link Only)
   • filename – (File Name)
   • link-to-icon – (Link to Icon file)
   • extension – (Extension)
   • file-size – (File Size)

3. Icon – Select the icon size.

   • 16 – (16px X 16px Icon)
   • 32 – (32px X 32px Icon)
   • 48 – (48px X 48px Icon)

4. Target Window – Target browser window when opening the link.

   • (Default. Parent)
   • _blank – (New Window With Navigation)
   • savefile – (Open Save File As Dialog Window)

Example:

{{ FieldName("timelimited","filename-link",32,"parent") }}

---

Pure Value (Unprocessed): #

Example:

{{ FieldName.value }}

---

Edit Record Parameters: #

Basic usage:

{{ FieldName.edit }}

Usage with parameters:

{{ FieldName.edit(CSS Class, Attributes) }}

1. CSS Class – Name or names of CSS class(es).

2. Attributes – Optional attributes like: disabled, onclick, onchange, etc.