viewnews.php

<?php
/***************************************************************************
 *   copyright				: (C) 2008 - 2017 WeBid
 *   site					: http://www.webidsupport.com/
 ***************************************************************************/

/***************************************************************************
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version. Although none of the code may be
 *   sold. If you have been sold this script, get a refund.
 ***************************************************************************/

include 'common.php';

$id = (isset($_GET['id'])) ? intval($_GET['id']) : 0;

if ($id > 0) {
    $query = "SELECT n.title As t, n.content As c, n.new_date, t.* FROM " . $DBPrefix . "news n
			LEFT JOIN " . $DBPrefix . "news_translated t ON (t.id = n.id)
			WHERE n.id = :news_id AND t.lang = :language AND n.suspended != 1";
    $params = array(
        array(':news_id', $id, 'int'),
        array(':language', $language, 'str'),
    );
    $db->query($query, $params);

    $new = $db->result();
    if (!empty($new['title']) && !empty($new['content'])) {
        $title = $new['title'];
        $content = $new['content'];
    } else {
        $title = $new['t'];
        $content = $new['c'];
    }
    $template->assign_block_vars('news', array(
            'CONT' => $content
            ));
} else {
    // Build news index
    $query = "SELECT n.title As t, n.new_date, t.* FROM " . $DBPrefix . "news n
			LEFT JOIN " . $DBPrefix . "news_translated t ON (t.id = n.id)
			WHERE t.lang = :language AND n.suspended != 1 ORDER BY n.new_date DESC, n.id DESC";
    $params = array(
        array(':language', $language, 'str'),
    );
    $db->query($query, $params);

    while ($row = $db->fetch()) {
        if (!empty($row['title'])) {
            $title = $row['title'];
        } else {
            $title = $row['t'];
        }
        $template->assign_block_vars('list', array(
                'TITLE' => $title,
                'DATE' => $dt->formatDate($row['new_date']),
                'ID' => $row['id']
                ));
    }
}

$template->assign_vars(array(
        'TITLE' => ($id > 0) ? $title . ' ' . $dt->formatDate($new['new_date']) : $MSG['282']
        ));

include 'header.php';
$template->set_filenames(array(
        'body' => 'viewnews.tpl'
        ));
$template->display('body');
include 'footer.php';