Hide Categories & Products V1.1 HELP!

h3rB · September 3, 2008

Ok I installed this to go with the PC pro creator...

http://addons.oscommerce.com/info/5907

I dont get errors on page, but when i click on edit to try and edit a catagory and select Set all to Active for example it just stays inactive. Basicly i cant make any active, the ones that were there when i installed are set to active but any new ones cant change.

please help!

spooks · September 3, 2008

check your install again, you've missed something.

h3rB · September 3, 2008

ok just checked through it and they all look ok.

says at the bottom:

"If you have it,

In catalog/includes/boxes/dm_categories.php"

I dont have that so not sure if thats a problem.

Also think its anything to do with this:

"There may other instances I have missed, the genereral Rule is:

If there is a general tep_db_query including TABLE_CATEGORIES add the filter: and categories_status = 1

If you applied the sql correctly all your existing categories should default to 'active'."

I'm using STS BTW.

h3rB · September 3, 2008

Is it anything to do with this registers_global?

spooks · September 3, 2008

Check again, your saying change does not update in admin, so look there, If you do it correct it works, its an easy install!!

spooks · September 3, 2008

Is it anything to do with this registers_global?

no

h3rB · September 3, 2008

yep just done the /admin/catagories.php for the 3rd time. When i click the drop down box and hit "Set all Active" it says at the top in the success message bar: " Set 3 Products In To Active".

spooks · September 3, 2008

You implied from your first that you were trying to change the status of categories, now your talking of products, which is it?

h3rB · September 3, 2008

Well I click on catagory. Click on "Assembly" (the name of the CATAGORY). The status for this catagory it says is "Status: Inactive". I click on the edit button. I click the drop-down box and choose "Set all Active". I then click the "Save" button. It then takes me back to the original catagories.php page like normal with the message at the top "Set 3 Products In To Active". I then click on the catagory to see if the status has change and it still says "Status: Inactive". Hope i got my point across now, not been too clear sorry.

spooks · September 3, 2008

Perhaps you should try reading!!

Above that drop down it says:

Change Status Of All Products In xxxx

no mention of category, but you think that means it does something else??

Have you tried clicking on the grean traffic light against the category?? the one that says 'set active' when you mouse over??

h3rB · September 3, 2008

:( sorry for being silly. I clicked the button to set it active.

now i get :

Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in /public_html/shop/includes/functions/compatibility.php:18) in /public_html/shop/includes/functions/compatibility.php on line 30

Sorry for annoying you and i respect your efforts. I'm going to go check through general.php.

this was since i activated the catagory. now its even when i de-activate it.

Edited September 3, 2008 by h3rB

h3rB · September 4, 2008

it works now sorry for hassle. just re-did everything 2 more times :D

September 15, 2008

Hi spooks

This is good work by you as "I searched for a solution for this, solutions I found were either over complex, or poorly done, so this is my solution." your wright 1000% I installed yours in 30 min and it work 1st time.

All the others installed in about 2 hours and all did not work other than ERROR ERROR ERROR then 30min to uninstall them.

Now for my big Q

I have all products installed and need to hide the products in a hidden Category which I use to store all my domain names that have been look up on my site I need them to still be Active so when the client goes to add them to the cart all still works.

if it helps this is the code:

<?php
/* 
$Id: allproducts.php,v 4.3 2004/01/13 20:28:47 UJP Co. Exp $


All Products SEO v1.0 by Jack_mcs, oscommerce-solution.com

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

Copyright (c) 2004 osCommerce

Released under the GNU General Public License

*/ 

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

$breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS_SEO, '', 'NONSSL')); 

$firstletter=$HTTP_GET_VARS['fl'];
$where="where pd.products_name like '$firstletter%' AND p.products_status='1' ";


?> 
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html <?php echo HTML_PARAMS; ?>> 
<head> 
<?php
// BOF: Header Tags SEO V 3.0
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { 
 require(DIR_WS_INCLUDES . 'header_tags.php'); 
} else { 
?> 
 <title><?php echo TITLE; ?></title>
<?php 
} 
// EOF: Header Tags SEO V 3.0
?> 
<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> 
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</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="2"> 
<!-- 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><table border="0" width="100%" cellspacing="0" cellpadding="0">
	 <tr>
	   <td><h1><?php echo HEADING_TITLE; ?></h1></td>
	   <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_products_new.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
	 </tr>
	 <tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	 </tr>
	 <tr>
	   <td class="main"><?php echo HEADING_SUB_TEXT; ?></td>
	 </tr>		   
	 <tr>
	  <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
	 </tr>
   </table></td>
 </tr>
 <tr>
   <td align="center" class="smallText"><?php 

   $excludeArray = array();
   $str = strtoupper(ALL_PRODUCTS_SEO_EXCLUDE_LIST);
   $excludeArray = explode(",", $str);
   $letters = array(0 => 'A', 1 => 'B', 2 => 'C', 3 => 'D', 4 => 'E', 5 => 'F', 6 => 'G',
				  7 => 'H', 8 => 'I', 9 => 'J', 10 => 'K', 11 => 'L', 12 => 'M', 13 => 'N',
				  14 => 'O', 15 => 'P', 16 => 'Q', 17 => 'R', 18 => 'S', 19 => 'T', 20 => 'U',
				  21 => 'V', 22 => 'W', 23 => 'X', 24 => 'Y', 25 => 'Z');
   $numbers = array(0 => '0', 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5', 6 => '6', 7 => '7', 8 => '8', 9 => '9');
   $firstletter_nav = ' '.ALL_PRODUCTS_SEO_LINK_SEPARATOR;

   // ADD THE LETTERS TO THE CLICKABLE LINKS
   for ($i = 0; $i < count($letters); ++$i)
   {			   
	 if (! in_array($letters[$i], $excludeArray))
	 {
	   $firstletter_nav .= '<a href="' . tep_href_link(FILENAME_ALLPRODS_SEO,  'fl=' . $letters[$i], 'NONSSL') . '"> ' . $letters[$i] . ' ' . ALL_PRODUCTS_SEO_LINK_SEPARATOR . '</A>';
	 }  
   }

   // ADD THE NUMBER TO THE CLICKABLE LINKS
   if (ALL_PRODUCTS_SEO_DISPLAY_NUMBERS == 'true')
   {
	 $firstletter_nav .= '<br>' . ALL_PRODUCTS_SEO_LINK_SEPARATOR . ' ';
	 for ($i = 0; $i < count($numbers); ++$i)
	 {			   
	   if (! in_array($numbers[$i], $excludeArray))
	   {
		 $firstletter_nav .= '<a href="' . tep_href_link(FILENAME_ALLPRODS_SEO,  'fl=' . $numbers[$i], 'NONSSL') . '"> ' . $numbers[$i] . ' ' . ALL_PRODUCTS_SEO_LINK_SEPARATOR . '</A>';
	   }  
	 }		 
   }	   

   $firstletter_nav .= '<a href="' . tep_href_link(FILENAME_ALLPRODS_SEO,  '',	 'NONSSL') . '"> FULL</A>';

   echo $firstletter_nav; ?></td>
 </tr>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
 <tr>
   <td>
<?php
// create column list
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
				  'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
				  'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 
				  'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
				  'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
				  'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
				  'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
				  'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
asort($define_list);

$column_list = array();
reset($define_list);
while (list($column, $value) = each($define_list)) {
  if ($value) $column_list[] = $column; 
}

$select_column_list = '';

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
  if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {
 continue;
  }
}

$listing_sql = "select p.products_id, p.products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . 
TABLE_PRODUCTS . " p 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 )  left join " . 
TABLE_SPECIALS . " s on ( p.products_id = s.products_id ) $where and pd.language_id = '" . $languages_id . "'";

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
  for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
	if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
	  $HTTP_GET_VARS['sort'] = $i+1 . 'a';
	  $listing_sql .= " order by pd.products_name";
	  break;
	}
  }
} else {
  $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
  $sort_order = substr($HTTP_GET_VARS['sort'], 1);

  switch ($column_list[$sort_col-1]) {
	case 'PRODUCT_LIST_MODEL':
	  $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_NAME':
	  $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
	  break;
	case 'PRODUCT_LIST_MANUFACTURER':
	  $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_QUANTITY':
	  $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_IMAGE':
	  $listing_sql .= " order by pd.products_name";
	  break;
	case 'PRODUCT_LIST_WEIGHT':
	  $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
	case 'PRODUCT_LIST_PRICE':
	  $listing_sql .= " order by p.products_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
	  break;
  }
}

if (ALL_PRODUCTS_SEO_DISPLAY_MODE == 'true')
include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format
else
include(DIR_WS_MODULES . FILENAME_ALLPRODS_SEO);
?>
   </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="2">
<!-- 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 //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

axioma · October 1, 2008

THIS ADD IS SO SIMPLE!.. works very good easy to install, really a must.

Thanks Spook

♥stubbsy · October 19, 2008

Hi Sam,

I don't think this is the support thread but I couldn't find another one. Just one quick question, I have installed this, it was easy to follow and works great thanks, but I wondered if it is possible to link the turning off of the products with the turning off of the categories, so that you only have to set the category inactive and the products are automatically set inactive?

Actually that leads me to a second question, is it possible to set a category inactive and all sub-categories are set inactive?

All the best

Dave

spooks · October 19, 2008

Created 'official' support thead here.

I have replied there.

Hide Categories & Products V1.1 HELP!

Recommended Posts

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Guest

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in