Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

All Products problem....


Tomcat

Recommended Posts

Posted

In www.casinadelbosco.com the Allproducts feature doesn't work...or better :

 

I enable it from the admin panel ( setting "use allproducts" to true ) then it works a while.

 

After a day or so I find the database table "configuration" is set back to false ( don't use allproducts page ) !!!!

 

Could it be something to do with the cookies ?

 

Any ideas ?

 

Thanks

Franco

Outside links in signatures are not allowed!

Posted

is all products a modul? maybe change it direct in the mysql database? or try it again an look if it stays after another customer fisited your page.

Posted

BOs(o

 

Yes , All products is a contribution. The weird thing is that I do change the value ( from false to true ) in the DB but after, let's say , a day it goes back to false.....

 

How can be possible that a value in the MySql changes without any modification made straight in the DB or using the Admin interface ????

 

Thanks

Franco

Outside links in signatures are not allowed!

Posted

Still getting the same problem...

 

I set : all products=ON in the DB then after a while it turns back to false !!!!!

 

What can it be ? is it possible the the files itself changes the value from true to false ?

 

this is my file allprods.php file anyway:

Any help greatly appreciated before I get nuts...

 

<?php 
/* 
 $Id: allprods.php,v 1.5 2002/09/29 1

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
 
*/ 

 require('includes/application_top.php'); 
 include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS); 

// Set number of columns in listing
define ('NR_COLUMNS', 1);
//
 $breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL')); 
?> 
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html <?php echo HTML_PARAMS; ?>> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<?php 
// BOF: WebMakers.com Changed: Header Tag Controller v1.0 
// Replaced by header_tags.php 
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { 
 require(DIR_WS_INCLUDES . 'header_tags.php'); 
} else { 
?> 
 <title><?php echo TITLE ?></title> 
<?php 
} 
// EOF: WebMakers.com Changed: Header Tag Controller v1.0 
?> 

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="<?php echo THEMA_STYLE;?>">
</head> 
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> 
<!-- header //--> 
<?php require(DIR_WS_INCLUDES . 'header.php'); ?> 
<!-- header_eof //--> 

<!-- body //--> 
<table border="0" width="100%" cellspacing="3" cellpadding="3"> 
 <tr> 
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="8"> 
<!-- left_navigation //--> 
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> 
<!-- left_navigation_eof //--> 
   </table></td> 
<!-- body_text //--> 
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 
     <tr> 
       <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 
         <tr> 
        <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 
           <td align="right"></td> 
         </tr> 
<?php // WebMakers.com Added: Show HEAD_DESC_TAG_ALL for the page description 
?>
         <tr class="AllProducts">
           <td class="AllProducts">
    </td>
           <td align="right"></td>
         </tr>
       </table></td> 
     </tr> 
     <tr> 
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> 
     </tr> 
     <tr> 
       <td> 
       <table border="0" width="100%" cellspacing="0" cellpadding="2"> 
       <tr class="productListing-heading"> 
       <td align="left" class="productListing-heading">Product Image</td> 
       <td align="left" class="productListing-heading">Product Name</td> 
       <td align="left" class="productListing-heading">Model</td> 
      <td align="left" class="productListing-heading">Weight Gr.</td> 
    
      <td align="right" class="productListing-heading">Retail Price  </td> 
      </tr> 
      
<?php    
                  
         $languages_query = tep_db_query("select languages_id, name, code, image, directory from " . TABLE_LANGUAGES . " order by sort_order"); 
         while ($languages = tep_db_fetch_array($languages_query)) { 
           $languages_array[] = array('id' => $languages['languages_id'], 
                                      'name' => $languages['name'], 
                                      'code' => $languages['code'], 
                                      'image' => $languages['image'], 
                                      'directory'   => $languages['directory']); 
         } 
                   for ($i=0; $i<sizeof($languages_array); $i++) 
                   {          
           $this_language_id = $languages_array[$i]['id']; 
           $this_language_name = $languages_array[$i]['name']; 
           $this_language_code = $languages_array[$i]['code']; 
           $this_language_image = $languages_array[$i]['image']; 
           $this_language_directory = $languages_array[$i]['directory']; 
   echo " <tr>\n";
    
         $products_query = tep_db_query("select s.specials_new_products_price, p.products_id, p.products_model, p.products_weight, p.products_carat, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name");
         $products_array = array(); 
      
         echo " <tr>\n";
           while($products = tep_db_fetch_array($products_query)) 
           { 
              $products_array[] = array('id'=> $products['products_id'], 
                            'name'    => $products['products_name'], 
                            'image'    => $products['products_image'], 
                            'model'    => $products['products_model'], 
                            'weight'  => $products['products_weight'], 
    	 // 'carat'  => $products['products_carat'], 
                            'price'   => $products['products_price'], 
                            'tax'     => $products['products_tax_class_id'], 
                            'special' => $products['specials_new_products_price']); 
           } 
          
        
            
           $num_prods = sizeof($products_array);  // This optimizes that slow FOR loop... 
            
           for ($i = 0; $i < $num_prods; $i++)    // Traverse Rows 
           { 
              // Rotate Row Colors 
              if ($i % 2)  // Odd Row 
              { 
                 $row_col = 'class="productListing-odd"'; 
              } 
              else   // Guess... 
              { 
                 $row_col = 'class="productListing-even"'; 
              } 
               
     
              $this_id = $products_array[$i]['id']; 
              $this_name = $products_array[$i]['name']; 
              $this_image = $products_array[$i]['image']; 
              $this_model = $products_array[$i]['model']; 
              $this_weight = $products_array[$i]['weight']; 
     //$this_carat = $products_array[$i]['carat'];
              $this_price = $products_array[$i]['price']; 
              $this_special = $products_array[$i]['special']; 
              $this_tax = $products_array[$i]['tax']; 
              $this_url = tep_href_link(FILENAME_PRODUCT_INFO,  'Your_Store_Name=' . str_replace(" ", "_", $this_name). '&products_id=' . $this_id . (($this_language_code == DEFAULT_LANGUAGE) ? '' : ('&language=' . $this_language_code)), 'NONSSL', false); 

              echo "<tr $row_col>"; 
              echo "<td class=\"productListing-data\" valign=\"top\" align=\"left\">\n";
       echo '<a href="' . tep_href_link (FILENAME_PRODUCT_INFO, 'Your_Store_Name=' . str_replace(" ", "_", $this_name). '&products_id=' . $this_id) . '">' .  tep_image(DIR_WS_IMAGES . $this_image, ALLPROD_IMAGE_WIDTH, ALLPROD_IMAGE_WIDTH, '', '', 'align="center"' ) . '</a>';
   
              echo "<td class='productListing-data' align='left'><a href='$this_url'>$this_name</a></td>"; 
              echo "<td class='productListing-data' align='left'><a href='$this_url'>$this_model</a></td>"; 
              echo "<td class='productListing-data' align='center'><a href='$this_url'>$this_weight</a></td>"; 
     //echo "<td class='productListing-data' align='center'><a href='$this_url'>$this_carat</a></td>";
              if (tep_not_null($this_special)) 
              { 
                 echo "<td class='productListing-data' align='right'><a href='$this_url'>" . 'Retail: ' . '<s>' . $currencies->display_price($this_price, tep_get_tax_rate($this_tax)) . '</s> <br>'. 'Discount: ' .' <span class="productSpecialPrice">' . $currencies->display_price($this_special,tep_get_tax_rate($this_tax)) . "</span></a></td>"; 
                
                 
              } 
              else 
              { 
                 echo "<td class='productListing-data' align='right'><a href='$this_url'>".$currencies->display_price($this_price, tep_get_tax_rate($this_tax))."</a></td>"; 
              } 
              echo "</tr>\n"; 
           } 
        } 
        
        
         
?> 
           </td> 
         </tr> 
       </table></td> 
     </tr> 
     <tr> 
   <td align="right" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> 
     </tr> 
   </table></td> 
<!-- body_text_eof //--> 
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="8"> 
<!-- right_navigation //--> 
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> 
<!-- right_navigation_eof //--> 
   </table></td> 
 </tr> 
</table> 
<!-- body_eof //--> 

<!-- footer //--> 
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?> 
<!-- footer_eof //--> 
</body> 
</html> 
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Outside links in signatures are not allowed!

  • 2 weeks later...
Posted

This seems to be an error in the contribution, i think that the allprods admin options are useless cause it's only one file and we ever want that the file shows to the spiders.

 

If you don't want the allprods admin, just delete the sql fields of the contribution.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...