/
Database table cat_lang
Database table cat_lang
- dominik.ziegler
- mischa.holz
- Marcus Gnaß
Owned by dominik.ziegler
Usage
The table cat_lang contains all language related information about a Category.
Table structure
| Field name | Field specification | Comment / Explanation |
|---|---|---|
| idcatlang | int(11) | Primary key (auto increment) |
| idcat | int(11) | Foreign key to table cat |
| idlang | int(11) | Foreign key to table lang |
| idtplcfg | int(11) | Foreign key to table template_conf |
| name | varchar(255) | Name of the category |
| visible | tinyint(1) | Flag if category is visible (online) or not |
| public | tinyint(1) | Flag if category is public (not access protected) or not |
| status | int(11) | Unused. |
| author | varchar(32) | Username of the articles author |
| created | datetime | Date and time of creation |
| lastmodified | datetime | Date and time of last modification |
| startidartlang | int(11) | Foreign key to table art_lang as reference for the start article of the category |
| urlname | varchar(64) | Alias name of the category |
| urlpath | varchar(255) | Unused. |
Generic DB information
| ItemCollection | Item |
|---|---|
| cApiCategoryLanguageCollection | cApiCategoryLanguage |
Convenience methods
The ItemCollection class provides some convenience methods to work on this entity:
| Method | Description |
|---|---|
| create($idcat, $idlang, $name, $urlname, $urlpath = '', $idtplcfg = 0, $visible = 0, $public = 0, $status = 0, $author = '', $startidartlang = 0, $created = '', $lastmodified = '') | Creates a category language entry. |
| getStartIdartlangByIdcatAndIdlang($idcat, $idlang) | Returns startidartlang of articlelanguage by category id and language id. |
| getStartIdartByIdcatAndIdlang($idcat, $idlang) | Returns article id of articlelanguages startarticle by category id and language id. |
| isStartArticle($idartlang, $idcat = null, $idlang = null) | Checks if passed idartlang is a start article. |
The Item class provides some convenience methods to work on this entity:
| Method | Description |
|---|---|
| loadByCategoryIdAndLanguageId($idcat, $idlang) | Load data by category id and language id |
| setField($name, $value, $safe = true) | Userdefined setter for article language fields. |
| assignTemplate($idtpl) | Assigns the passed template to the category language item. |
| getTemplate() | Returns id of template where this item is configured |
| hasStartArticle() | Checks if category language item has a start article |
| store() | Updates lastmodified field and calls parents store method |
| getLink() | Returns the link to the current object. |
Previous changes of this table
This table was not changed since the final release of CONTENIDO 4.9.