[Summary view] [Print] [Text view]

   1  <table border="0" width="100%" cellspacing="3" cellpadding="3">
   2    <tr> 
   3      <!-- body_text //-->
   4      <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
   5          <tr> 
   6            <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
   7                <tr> 
   8                  <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
   9                </tr>
  10              </table></td>
  11          </tr>
  12          <tr> 
  13            <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  14          </tr>
  15          <?php
  16    $articles_new_array = array();
  17      $listing_sql = "select a.articles_id, a.articles_date_added, 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) left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_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 . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) order by a.articles_date_added desc, ad.articles_name";
  18      $listing_no_article = sprintf(TEXT_NO_NEW_ARTICLES, NEW_ARTICLES_DAYS_DISPLAY);
  19        
  20    //$articles_new_split = new splitPageResults($listing_sql, MAX_NEW_ARTICLES_PER_PAGE);
  21  
  22  ?>
  23  
  24  <?php include(DIR_WS_MODULES . FILENAME_ARTICLE_LISTING); ?></td>
  25        <tr>
  26          <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  27        </tr>
  28        </table></td>
  29      <!-- body_text_eof //-->
  30    </tr>
  31  </table>