Extension:CentralNotice/cn templates table

Fields edit

Stores details on all banners known to CentralNotice.

Key Name Type Default Description
primary tmp_id int(11) NOT NULL AUTO_INCREMENT NULL Identifying key for the banner.


tmp_name tmp_name varchar(255) NULL Foreign key. Non canonical name of the banner.


tmp_display_anon tinyint(1) NOT NULL 1 Boolean value determining if the banner should be displayed to anonymous users. 1 = show to anonymous.


tmp_display_account tinyint(1) NOT NULL 1 Boolean value determining if the banner should be displayed to logged in users. 1 = show to logged in.


tmp_fundraising tinyint(1) NOT NULL 0
Deprecated: v2.3
Boolean determining if this is a fundraising banner (affects cookies). As of v2.3 this has been replaced by the concept of categories.


tmp_autolink tinyint(1) NOT NULL 0
Deprecated: v2.3
Boolean determining if landing page links should be automatically created from tmp_landing_pages. As of v2.3 this has been replaced by the concept of banner mixins.


tmp_landing_pages varchar(255) NULL
Deprecated: v2.3
Landing pages to choose from when automatically creating links. As of v2.3 this has been replaced by the concept of banner mixins.


tmp_archived tinyint(1) NOT NULL 0 Boolean identifying if this banner should be displayed by default on the banners page. 0 = show by default.


tmp_category varchar(255) NULL Foreign key, into a configuration variable determining what the hide cookie name should be and how long it lasts.


tmp_preview_sandbox tinyint(1) NOT NULL 0 Boolean indicating if this banner must be sandboxed inside an iframe when previewing it. 1 = sandbox inside iframe.