コード例 #1
0
ファイル: reviews.php プロジェクト: BackupTheBerlios/oos-svn
                           ORDER BY r.reviews_id DESC";
    $reviews_split = new splitPageResults($nCurrentPageNumber, MAX_DISPLAY_NEW_REVIEWS, $reviews_result_raw, $reviews_numrows);
    $reviews_result = $dbconn->Execute($reviews_result_raw);

    $aReviews = array();
    while ($reviews = $reviews_result->fields)
    {
        $aReviews[] = array('id' => $reviews['reviews_id'],
                            'products_id' => $reviews['products_id'],
                            'reviews_id' => $reviews['reviews_id'],
                            'products_name' => $reviews['products_name'],
                            'products_image' => $reviews['products_image'],
                            'authors_name' => $reviews['customers_name'],
                            'review' => htmlspecialchars(substr($reviews['reviews_text'], 0, 250)) . '..',
                            'rating' => $reviews['reviews_rating'],
                            'word_count' => oosWordCount($reviews['reviews_text'], ' '),
                            'date_added' => oos_date_long($reviews['date_added']));
        $reviews_result->MoveNext();
    }

    // links breadcrumb
    $oBreadcrumb->add($aLang['navbar_title']);

    $oos_pagetitle = $oBreadcrumb->trail_title(' » ');
    $oos_pagetitle .= '»' . OOS_META_TITLE;

    // assign Smarty variables;
    $oSmarty->assign(
        array(
              'pagetitle'         => htmlspecialchars($oos_pagetitle),
              'meta_description'  => htmlspecialchars($oos_meta_description),
コード例 #2
0
ファイル: reviews.php プロジェクト: BackupTheBerlios/oos-svn
    require 'includes/info_message.php';
    require 'includes/oos_blocks.php';
}
if (USE_CACHE == '1' && !SID) {
    $oSmarty->caching = 2;
    $oSmarty->cache_lifetime = 2 * 24 * 3600;
}
if (!$oSmarty->is_cached($aOption['template_main'], $contents_cache_id)) {
    require 'includes/languages/' . $sLanguage . '/reviews_reviews.php';
    $reviewstable = $oostable['reviews'];
    $productstable = $oostable['products'];
    $reviews_descriptiontable = $oostable['reviews_description'];
    $products_descriptiontable = $oostable['products_description'];
    $reviews_result_raw = "SELECT r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id,\n                                  pd.products_name, p.products_image, r.customers_name\n                           FROM {$reviewstable} r,{$reviews_descriptiontable} rd,\n                                {$productstable} p, {$products_descriptiontable} pd\n                           WHERE p.products_status >= '1'\n                             AND p.products_id = r.products_id\n                             AND r.reviews_id = rd.reviews_id\n                             AND p.products_id = pd.products_id\n                             AND pd.products_languages_id = '" . intval($nLanguageID) . "'\n                             AND rd.reviews_languages_id = '" . intval($nLanguageID) . "'\n                           ORDER BY r.reviews_id DESC";
    $reviews_split = new splitPageResults($_GET['page'], MAX_DISPLAY_NEW_REVIEWS, $reviews_result_raw, $reviews_numrows);
    $reviews_result = $dbconn->Execute($reviews_result_raw);
    $aReviews = array();
    while ($reviews = $reviews_result->fields) {
        $aReviews[] = array('id' => $reviews['reviews_id'], 'products_id' => $reviews['products_id'], 'reviews_id' => $reviews['reviews_id'], 'products_name' => $reviews['products_name'], 'products_image' => $reviews['products_image'], 'authors_name' => $reviews['customers_name'], 'review' => htmlspecialchars(substr($reviews['reviews_text'], 0, 250)) . '..', 'rating' => $reviews['reviews_rating'], 'word_count' => oosWordCount($reviews['reviews_text'], ' '), 'date_added' => oos_date_long($reviews['date_added']));
        $reviews_result->MoveNext();
    }
    // links breadcrumb
    $oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['reviews'], $aFilename['reviews_reviews']));
    $oSmarty->assign(array('oos_breadcrumb' => $oBreadcrumb->trail(BREADCRUMB_SEPARATOR), 'oos_heading_title' => $aLang['heading_title'], 'oos_heading_image' => 'specials.gif', 'oos_page_split' => $reviews_split->display_count($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, $_GET['page'], $aLang['text_display_number_of_reviews']), 'oos_display_links' => $reviews_split->display_links($reviews_numrows, MAX_DISPLAY_NEW_REVIEWS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_parameters(array('page', 'info'))), 'oos_page_numrows' => $reviews_numrows, 'oos_reviews_array' => $aReviews));
}
$oSmarty->assign('oosPageNavigation', $oSmarty->fetch($aOption['page_navigation'], $contents_cache_id));
$oSmarty->assign('oosPageHeading', $oSmarty->fetch($aOption['page_heading'], $contents_cache_id));
$oSmarty->assign('contents', $oSmarty->fetch($aOption['template_main'], $contents_cache_id));
$oSmarty->caching = false;
// display the template
require 'includes/oos_display.php';