[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  $Id: articles_upcoming.php 3 2006-05-27 04:59:07Z user $

   4  

   5    osCMax Power E-Commerce

   6    http://oscdox.com

   7  

   8    Copyright 2006 osCMax

   9  

  10    Released under the GNU General Public License

  11  */
  12  
  13  ?>
  14  <?php
  15    $expected_query = tep_db_query("select a.articles_id, a.articles_date_added, a.articles_date_available as date_expected, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t, " . TABLE_TOPICS_DESCRIPTION . " td, " . TABLE_AUTHORS . " au, " . TABLE_ARTICLES_DESCRIPTION . " ad where to_days(a.articles_date_available) > to_days(now()) and a.articles_id = a2t.articles_id and a2t.topics_id = td.topics_id and a.authors_id = au.authors_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by date_expected limit " . MAX_DISPLAY_UPCOMING_ARTICLES);
  16    if (tep_db_num_rows($expected_query) > 0) {
  17  ?>
  18  <!-- upcoming_articles //-->
  19        <tr>
  20          <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
  21        <tr>
  22          <td class="main"><?php echo '<b>' . TEXT_UPCOMING_ARTICLES . '</b>'; ?></td>
  23        </tr>
  24        <tr>
  25          <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  26        </tr>
  27  <?php
  28      while ($articles_expected = tep_db_fetch_array($expected_query)) {
  29  ?>
  30            <tr>
  31              <td valign="top" class="main" width="75%">
  32  <?php
  33    echo '<font color="#999999"><b>' . $articles_expected['articles_name'] . '</b></font> ';
  34    if (DISPLAY_AUTHOR_ARTICLE_LISTING == 'true') {
  35     echo TEXT_BY . ' ' . $articles_expected['authors_name'];
  36    }
  37  ?>
  38              </td>
  39  <?php
  40        if (DISPLAY_TOPIC_ARTICLE_LISTING == 'true') {
  41  ?>
  42              <td valign="top" class="main" width="25%" nowrap><?php echo TEXT_TOPIC . '&nbsp;' . $articles_expected['topics_name']; ?></td>
  43  <?php
  44        }
  45  ?>
  46            </tr>
  47  <?php
  48        if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true') {
  49  ?>
  50            <tr>
  51              <td class="main" style="padding-left:15px"><?php echo clean_html_comments(substr($articles_expected['articles_head_desc_tag'],0, MAX_ARTICLE_ABSTRACT_LENGTH)) . ((strlen($articles_expected['articles_head_desc_tag']) >= MAX_ARTICLE_ABSTRACT_LENGTH) ? '...' : ''); ?></td>
  52            </tr>
  53  <?php
  54        }
  55  ?>
  56            <tr>
  57              <td class="smalltext" style="padding-left:15px"><?php echo TEXT_DATE_EXPECTED . ' ' . tep_date_long($articles_expected['date_expected']); ?></td>
  58            </tr>
  59  <?php
  60        if (DISPLAY_ABSTRACT_ARTICLE_LISTING == 'true' || DISPLAY_DATE_ADDED_ARTICLE_LISTING) {
  61  ?>
  62            <tr>
  63              <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  64            </tr>
  65  <?php
  66       }
  67    } // End of listing loop

  68  ?>
  69          </table></td>
  70        </tr>
  71  <!-- eof upcoming_articles //-->
  72  <?php
  73    }
  74  ?>
  75