# css-javascript-toolbox/8.0.2/models/fields/template-versions.php

CSS & JavaScript Toolbox, version 8.0.2. 36 lines.

- Page: https://pluginprobe.com/plugins/css-javascript-toolbox/8.0.2/code/models/fields/template-versions.php
- Raw: https://pluginprobe.com/plugins/css-javascript-toolbox/8.0.2/raw/models/fields/template-versions.php
- Modified: 2014-05-06T16:47:26+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/css-javascript-toolbox/8.0.2/code/models/fields/template-versions.php#L10-L20`.

```php
<?php
/**
* 
*/

// Import dependencies.
cssJSToolbox::import('framework:html:list.php', 'framework:db:mysql:xtable.inc.php');

/**
* 
*/
class CJTTemplateVersionsField extends CJTListField {
	
	/**
	* put your comment there...
	* 
	*/
	protected function prepareItems() {
		// Import dependencies.
		CJTxTable::import('template-revision');
		CJTxTable::import('author');
		$lastVersionFlag = CJTTemplateRevisionTable::FLAG_LAST_REVISION;
		$internalAuthorsFlag = CJTAuthorTable::FLAG_SYS_AUTHOR;
		// Query CJT Authors + Wordpress build-in local users.
		$query = "SELECT DISTINCT(r.version) `text` 
													FROM #__cjtoolbox_template_revisions r
													LEFT JOIN #__cjtoolbox_templates t
													ON  r.templateId = t.id
													LEFT JOIN #__cjtoolbox_authors a
													ON  t.authorId = a.id
													WHERE (r.attributes & {$lastVersionFlag}) AND (a.attributes & {$internalAuthorsFlag}) = 0
													ORDER BY `text`;";
		$this->items = cssJSToolbox::getInstance()->getDBDriver()->select($query);
	}
	
} // End class.
```