h3rB Posted September 3, 2008 Share Posted 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! Quote Link to comment Share on other sites More sharing options...
spooks Posted September 3, 2008 Share Posted September 3, 2008 check your install again, you've missed something. Quote 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. Link to comment Share on other sites More sharing options...
h3rB Posted September 3, 2008 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
h3rB Posted September 3, 2008 Author Share Posted September 3, 2008 Is it anything to do with this registers_global? Quote Link to comment Share on other sites More sharing options...
spooks Posted September 3, 2008 Share Posted 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!! Quote 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. Link to comment Share on other sites More sharing options...
spooks Posted September 3, 2008 Share Posted September 3, 2008 Is it anything to do with this registers_global? no Quote 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. Link to comment Share on other sites More sharing options...
h3rB Posted September 3, 2008 Author Share Posted 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". Quote Link to comment Share on other sites More sharing options...
spooks Posted September 3, 2008 Share Posted 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? Quote 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. Link to comment Share on other sites More sharing options...
h3rB Posted September 3, 2008 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
spooks Posted September 3, 2008 Share Posted 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?? Quote 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. Link to comment Share on other sites More sharing options...
h3rB Posted September 3, 2008 Author Share Posted September 3, 2008 (edited) :( 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 Quote Link to comment Share on other sites More sharing options...
h3rB Posted September 4, 2008 Author Share Posted September 4, 2008 it works now sorry for hassle. just re-did everything 2 more times :D Quote Link to comment Share on other sites More sharing options...
Guest Posted September 15, 2008 Share Posted 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'); ?> Quote Link to comment Share on other sites More sharing options...
axioma Posted October 1, 2008 Share Posted October 1, 2008 THIS ADD IS SO SIMPLE!.. works very good easy to install, really a must. Thanks Spook Quote Link to comment Share on other sites More sharing options...
♥stubbsy Posted October 19, 2008 Share Posted 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 Quote Link to comment Share on other sites More sharing options...
spooks Posted October 19, 2008 Share Posted October 19, 2008 Created 'official' support thead here. I have replied there. Quote 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.