← Desenvolvimento

[Oscommerce] Module new_products - problema preço

Lida 1160 vezes

Offline

Mehlcan 
Membro
Mensagens 38 Gostos 0
Troféus totais: 28
Trófeus: (Ver todos)
Linux User Mobile User Level 5 Search Windows User Super Combination Combination Topic Starter Poll Voter Level 4

Viva, Eu tenho o seguinte problema já andei em forums oficiais do oscommerce a pesqueisar sobre o assunto, mas o código do módulo new products não é o mesmo que o normal.

O que eu pretendia era que quando o preço fosse menor que zero ele não aparece-se.

Código: [Seleccione]

<?php

  
if &#40; &#40;!isset&#40;$new_products_category_id&#41;&#41; || &#40;$new_products_category_id == '0'&#41; &#41; &#123;
    
$new_products_query tep_db_query&#40;"select p.products_id, p.products_image, p.products_tax_class_id, if&#40;s.status, s.specials_new_products_price, p.products_price&#41; as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS&#41;;
  
&#125; else &#123;
    
$new_products_query tep_db_query&#40;"select distinct p.products_id, p.products_image, p.products_tax_class_id, if&#40;s.status, s.specials_new_products_price, p.products_price&#41; as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . &#40;int&#41;$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS&#41;;
  
&#125;

  
$row 0;
  
$col 0;


  echo 
'

    <table cellspacing=0 cellpadding=0 width=740 align=center>
     <tr><td background=images/m22.gif width=740 height=29 valign=top>
         <table cellspacing=0 cellpadding=0>
          <tr><td height=8></td></tr>
          <tr><td width=25></td><td class=ch6></td></tr>
         </table>
        </td></tr>
      <tr><td valign=top class=ch7>

           <table cellspacing=0 cellpadding=0 width=740 border=0 align=center>
             <tr><td height=13></td></tr>
             <tr>


       '
;


  while &
#40;$new_products = tep_db_fetch_array&#40;$new_products_query&#41;&#41; &#123;
   
$new_products['products_name'&#93; = tep_get_products_name&#40;$new_products['products_id'&#93;&#41;;
   
$product_query tep_db_query&#40;"select products_description  from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . &#40;int&#41;$new_products['products_id'&#93; . "' and language_id = '" . &#40;int&#41;1 . "'"&#41;;
   
$product tep_db_fetch_array&#40;$product_query&#41;;
   
$new_products['products_description'&#93; = $product['products_description'&#93;;
   
echo '

             <td width=300 valign=top align=center>
               <table cellspacing=0 cellpadding=2 width=350 align=center>
   <tr><td><a height=100% valign=middle  align=center class=ch9 href="' 
tep_href_link&#40;FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id'&#93;&#41; . '">' . $new_products['products_name'&#93; . '</a></td></tr>
                

<tr><td width=300 align=center valign=top><a href="' . tep_href_link&#40;FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id'&#93;&#41; . '">' . tep_image&#40;DIR_WS_IMAGES . $new_products['products_image'&#93;, $new_products['products_name'&#93;, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'vspace=0'&#41; . '</a></td></tr>
                <
td valign=middle>
                  <
table cellspacing=0 cellpadding=0>
                   
                   
                   <
tr><td class=10 height=35 valign=middle>'.preg_replace&#40;'/\s\S*$/i', '', substr&#40;$new_products['products_description'&#93;, 0, 100&#41;&#41;.' ...</td></tr>
                   <
tr><td height=0></td></tr>
                   
                  </
table>
                 </
td>
                </
tr>
                <
tr><td height="1" ></td></tr>
<tr><td valign="middle"><span class=11></span> <span class=ch8>'.$currencies->display_price&#40;$new_products['products_price'&#93;, tep_get_tax_rate&#40;$new_products['products_tax_class_id'&#93;&#41;&#41;.'</span> </td>
                <
td colspan=0 align=left valign="middle"> &nbsp;&nbsp;</td></tr>
                           </
td>
</
table>

        
';
   
    $col ++;
    if &#40;$col > 1&#41; &#123;
      $col = 0;
      $row ++;
      echo '

             
</tr>
             <
tr><td height=5></td></tr>
              <
tr><td colspan=3 valign=top>
               <
table cellspacing=0 cellpadding=0>
                <
tr><td width=400 height=1 background=images/m29.gif></td><td width=14></td> <td width=400 height=1 background=images/m29.gif></td></tr>
               </
table>
              </
td></tr>
              <
tr><td height=5></td></tr>
              <
tr>


           
';
    &#125; else echo '
<td background=images/m09.gif width=1></td>';
  &#125;


  echo '

                         
</tr>
                        </
table

         </
td></tr>
        <
tr><td><img src=images/m30.gif width=740 height=7></td></tr>
       </
table>

       
';


?>


Se algum programador pude-se ajudar agradecia muito.

Cumprimentos