Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
h3rB

Hide Categories & Products V1.1 HELP!

Recommended Posts

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!

Share this post


Link to post
Share on other sites

check your install again, you've missed something.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites
Is it anything to do with this registers_global?

 

 

no


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

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".

Share this post


Link to post
Share on other sites

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


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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??


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

:( 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 by h3rB

Share this post


Link to post
Share on other sites
Guest

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'); ?>

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Created 'official' support thead here.

 

I have replied there.


Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×