function generate_categories_cache(){
$this->is_cached($this->cache_file . 'categories', $is_cached, $is_expired);
if ( !$is_cached || $is_expired ) { // it's not cached so create it
switch(true){
case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'):
$sql = "SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM ".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd
LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2
ON c.parent_id=cd2.categories_id AND cd2.language_id='".(int)$this->languages_id."'
WHERE c.categories_id=cd.categories_id
AND cd.language_id='".(int)$this->languages_id."'";
break;
default:
$sql = "SELECT categories_id as id, categories_name as cName
FROM ".TABLE_CATEGORIES_DESCRIPTION."
WHERE language_id='".(int)$this->languages_id."'";
break;
} # end switch
Bookmarks