loadIniFile('modules/summary/reviews.php'); $this->_title = $osC_Language->get('summary_reviews_title'); $this->_title_link = osc_href_link_admin(FILENAME_DEFAULT, 'reviews'); if ( osC_Access::hasAccess('reviews') ) { $this->_setData(); } } /* Private methods */ function _setData() { global $osC_Database, $osC_Language; $this->_data = '' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' ' . ' '; $Qreviews = $osC_Database->query('select r.reviews_id, r.products_id, greatest(r.date_added, ifnull(r.last_modified, 0)) as date_last_modified, r.reviews_rating, pd.products_name, l.name as languages_name, l.code as languages_code from :table_reviews r left join :table_products_description pd on (r.products_id = pd.products_id and r.languages_id = pd.language_id), :table_languages l where r.languages_id = l.languages_id order by date_last_modified desc limit 6'); $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS); $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); $Qreviews->bindTable(':table_languages', TABLE_LANGUAGES); $Qreviews->execute(); while ( $Qreviews->next() ) { $this->_data .= ' ' . ' ' . ' ' . ' ' . ' ' . ' '; } $this->_data .= ' ' . '

' . $osC_Language->get('summary_reviews_table_heading_products') . '	' . $osC_Language->get('summary_reviews_table_heading_language') . '	' . $osC_Language->get('summary_reviews_table_heading_rating') . '	' . $osC_Language->get('summary_reviews_table_heading_date') . '
' . osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, 'reviews&rID=' . $Qreviews->valueInt('reviews_id') . '&action=save'), osc_icon('reviews.png') . ' ' . $Qreviews->value('products_name')) . '	' . $osC_Language->showImage($Qreviews->value('languages_code')) . '	' . osc_image('../images/stars_' . $Qreviews->valueInt('reviews_rating') . '.png', $Qreviews->valueInt('reviews_rating') . '/5') . '	' . osC_DateTime::getShort($Qreviews->value('date_last_modified')) . '

'; $Qreviews->freeResult(); } } ?>