function osC_Index_Index() { global $osC_Database, $osC_Services, $osC_Language, $breadcrumb, $cPath, $cPath_array, $current_category_id, $osC_Category; $this->_page_title = sprintf($osC_Language->get('index_heading'), STORE_NAME); if (isset($cPath) && empty($cPath) === false) { if ($osC_Services->isStarted('breadcrumb')) { $Qcategories = $osC_Database->query('select categories_id, categories_name from :table_categories_description where categories_id in (:categories_id) and language_id = :language_id'); $Qcategories->bindTable(':table_categories_description', TABLE_CATEGORIES_DESCRIPTION); $Qcategories->bindRaw(':categories_id', implode(',', $cPath_array)); $Qcategories->bindInt(':language_id', $osC_Language->getID()); $Qcategories->execute(); $categories = array(); while ($Qcategories->next()) { $categories[$Qcategories->value('categories_id')] = $Qcategories->valueProtected('categories_name'); } $Qcategories->freeResult(); for ($i = 0, $n = sizeof($cPath_array); $i < $n; $i++) { $breadcrumb->add($categories[$cPath_array[$i]], osc_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, $i + 1)))); } } $osC_Category = new osC_Category($current_category_id); $this->_page_title = $osC_Category->getTitle(); $this->_page_image = 'categories/' . $osC_Category->getImage(); $page_title = $osC_Category->getPageTitle(); if (!empty($page_title)) { $this->setMetaPageTitle($page_title); } $meta_keywords = $osC_Category->getMetaKeywords(); if (!empty($meta_keywords)) { $this->addPageTags('keywords', $meta_keywords); } $meta_description = $osC_Category->getMetaDescription(); if (!empty($meta_description)) { $this->addPageTags('description', $meta_description); } $Qproducts = $osC_Database->query('select p.products_id from :table_products_to_categories ptc left join :table_products p on ptc.products_id = p.products_id where p.products_status = 1 and categories_id = :categories_id limit 1'); $Qproducts->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES); $Qproducts->bindTable(':table_products', TABLE_PRODUCTS); $Qproducts->bindInt(':categories_id', $current_category_id); $Qproducts->execute(); if ($Qproducts->numberOfRows() > 0) { $this->_page_contents = 'product_listing.php'; $this->_process(); } else { $Qparent = $osC_Database->query('select categories_id from :table_categories where categories_status = 1 and parent_id = :parent_id limit 1'); $Qparent->bindTable(':table_categories', TABLE_CATEGORIES); $Qparent->bindInt(':parent_id', $current_category_id); $Qparent->execute(); if ($Qparent->numberOfRows() > 0) { $this->_page_contents = 'category_listing.php'; } else { $this->_page_contents = 'product_listing.php'; $this->_process(); } } } else { $code = strtoupper($osC_Language->getCode()); if (defined('HOME_META_KEYWORD_' . $code) && defined('HOME_META_DESCRIPTION_' . $code) && defined('HOME_PAGE_TITLE_' . $code)) { $page_title = constant('HOME_PAGE_TITLE_' . $code); $meta_keywords = constant('HOME_META_KEYWORD_' . $code); $meta_description = constant('HOME_META_DESCRIPTION_' . $code); } if (!empty($page_title)) { $this->setMetaPageTitle($page_title); } if (!empty($meta_keywords)) { $this->addPageTags('keywords', $meta_keywords); } if (!empty($meta_description)) { $this->addPageTags('description', $meta_description); } } }