Jump to content

MLHmptn

Members
  • Content count

    19
  • Joined

  • Last visited

1 Follower

Profile Information

  1. How could one manipulate the easypopulate.php file to delete items via product_model instead of via products_id? I'm sure some kind of query could be inserted before or within the delete function. My vendor supplies me with a discontinued items list that supplies my product_model and sometimes its in upwards of 3000 items and manually doing it every quarter is too laborous via phpMyAdmin. Here is my experimental code...it deletes the product from the products.table but doesn't delete the product from the products_description or products_to_categories table. Here is my modified code: //if delete if ( $v_action == 'delete' ){ // they want to delete this product. echo EASY_LABEL_DELETE_STATUS_1 . $v_products_id . EASY_LABEL_DELETE_STATUS_2 . '<br>'; // Get the ID $products_query = tep_db_query("select products_id, products_model from " . TABLE_PRODUCTS); while ($products_array = tep_db_fetch_array($products_query)) { $products[$products_array['products_model']] = $products_array['products_id']; } $v_products_model = $v_products_id; $delete_id = $v_products_id; // get category ID // kill in the products_to_categories tep_db_query("delete from " . TABLE_PRODUCTS . " where products_id ='" . $delete_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id ='" . $delete_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id ='" . $delete_id . "' and categories_id = '" . $v_categories_id . "' "); $prod_attrib_query = tep_db_query("select products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id ='" . $delete_id . "'"); while ($prod_attrib1 = tep_db_fetch_array($prod_attrib_query)) { tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id ='" . $prod_attrib1[products_attributes_id] . "'"); } tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id ='" . $delete_id . "'"); // Kill in the products table return; // we're done deleteing! Here is the original code //if delete if ( $v_action == 'delete' ){ // they want to delete this product. echo EASY_LABEL_DELETE_STATUS_1 . $v_products_id . EASY_LABEL_DELETE_STATUS_2 . '<br>'; // Get the ID $delete_id = $v_products_id; // get category ID // kill in the products_to_categories tep_db_query("delete from " . TABLE_PRODUCTS . " where products_id ='" . $delete_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id ='" . $delete_id . "'"); tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id ='" . $delete_id . "' and categories_id = '" . $v_categories_id . "' "); $prod_attrib_query = tep_db_query("select products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id ='" . $delete_id . "'"); while ($prod_attrib1 = tep_db_fetch_array($prod_attrib_query)) { tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id ='" . $prod_attrib1[products_attributes_id] . "'"); } tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id ='" . $delete_id . "'"); // Kill in the products table return; // we're done deleteing! Any help would be greatly appreciated! Mike
  2. Has anybody been able to fix this ?manufacturers_id=* be either means of .htaccess, robots.txt or by editing chemo's code?
  3. MLHmptn

    [Contribution] Cross Sell (X-Sell) Admin

    Is there any way I could possibly import by model number instead of products_id and xsell_id? I have a database that has companion products in it by model number's and with over 25000 products I don't have the time to visit every product to add a xsell item to it. Rather I'd like to be able to import via my tables via ODBC as there are 100000+ lines. I have tried modifying the database fields as products_model and xsell_model but I'm not great at coding obviously. I have also tried to mod the xsell_products_buynow.php in includes/modules/ but I'm having great difficulty with simply replacing the products_id with products_model and the xsell_id with xsell_model as I have done in this case. My xsell_products_buynow.php is as follows: <?php /* $Id: xsell_products.php, v1 2002/09/11 osCommerce, Open Source E-Commerce Solutions <http://www.oscommerce.com> Copyright (c) 2002 osCommerce Released under the GNU General Public License */ if ($HTTP_GET_VARS['products_id']) { $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name, p.products_model, p.products_tax_class_id, products_price from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_model and p.products_model = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_model asc limit " . MAX_DISPLAY_ALSO_PURCHASED); $num_products_xsell = tep_db_num_rows($xsell_query); if ($num_products_xsell >= MIN_DISPLAY_XSELL) { ?> <!-- xsell_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => TEXT_XSELL_PRODUCTS); new infoBoxHeading($info_box_contents, false, false); $row = 0; $col = 0; $info_box_contents = array(); while ($xsell = tep_db_fetch_array($xsell_query)) { $xsell['specials_new_products_price'] = tep_get_products_special_price($xsell['products_id']); if ($xsell['specials_new_products_price']) { $xsell_price = '<s>' . $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</s><br>'; $xsell_price .= '<span class="productSpecialPrice">' . $currencies->display_price($xsell['specials_new_products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</span>'; } else { $xsell_price = $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])); } $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'xsell_id=' . $xsell['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $xsell['products_image'], $xsell['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . $xsell['products_name'] .'</a><br>' . $xsell_price. '<br>'); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); if (MAIN_TABLE_BORDER == 'yes'){ $info_box_contents = array(); $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => tep_draw_separator('pixel_trans.gif', '100%', '1') ); new infoboxFooter($info_box_contents, true, true); } ?> <!-- xsell_products_eof //--> <?php } } ?> If anyone can help me figure this out I would greatly appreciative! MLHmptn
  4. Jack, Actually the only place I will need them is on the category levels. How would I go about just doing that? Hopefully it would be something as simple as editing only the includes/header_tags.php. As far as the comment tags I would have to agree with you. But this particular SEO guarantees me in the contract Top 10 rankings so I have to do what they say or my guarantee isn't going to happen. Personally I don't use comment tags(or an SEO for that matter) on any of my other sites but this particular one I contracted an SEO for and it is one of their requirements. We'll see what happens. Also...Thank you for your insight and your continuing support for this tremendous contribution. People like you are what keeps open source alive! Long live Open Source! MLHmptn
  5. Has anybody modified this contribution to add comment tags as well? I'm hoping someone has done this before I modify the code to add this additional bit of information to the header tags. The SEO I have doing my website has recommended I add comment tags now even though I have heard many times over that comment tags are useless. Thanks in advance! MLHmptn
  6. Chemo, Great! I can't wait to see the final code. Where would one grab the preview version at? I am interested in testing it if you need some feedback? I thought it was due to the quantity of products. Like I say I have it working flawlessly on 4 of my sites at the moment without a hitch. Your contributions are the BOMB! Your advanced cache class has made major speed improvements for all of my stores and your Ultimate SEO URL's has improved my rankings considerably on the search engines! Thank you for all your hardwork! I have made a donation in the amount of $50.00 today for you as well. Thank you again! With Regards, MLHmptn
  7. I cannot get this contrib working for two of my sites that have in upwards of 27000 products. The categories are 4 levels deep as well... Would this cause problems Chemo? Click hereto visit site. I have this contribution working flawlessly on 4 of my sites without a hitch but these two sites I have it just won't work :( Any help would be appreciated. MLHmptn
  8. MLHmptn

    Seach Engine Friendly URL Support

    I figured it out BlueYon....It had to do with httpd.conf....I had to add the AcceptPathInfo directive to httpd.conf. I have to figure out how to address the bullet symbol though with its ISO 8859-1 character set value :( The strip array also works flawlessly now on my page with the following : $strip_array = array("","","`","","•",chr(174),chr(169),chr(33),chr(34),chr(35),chr(36),chr(37),chr(38),chr(39),chr(40),chr(41),chr(42),chr(43),chr(44),chr(47),chr(60),chr(91),chr(92),chr(93),chr(94),chr(95),chr(96),chr(123),chr(124),chr(125),chr(126),chr(146),chr(147),chr(148),chr(151),chr(153),chr(B7),chr(176) ); Thanks for your great contribution!
  9. MLHmptn

    Seach Engine Friendly URL Support

    I originally thought this contribution worked flawlessly until I realized that nothing gets added to my shopping cart when anyone clicks the ADD TO CART buttons. I just get /action/buy_now/ at the end of my URL's. I don't know if its just my site or what but if the customer can't add anything to their cart this contrib won't work out ;( Anybody else having this problem or is just my sites? Any feedback would be greatly appreciated! MLHmptn
  10. MLHmptn

    Seach Engine Friendly URL Support

    Dude your newest contribution v1.1 is the BOMB! I am not having a single issue now with this new code! Before I was having server timeouts or something and now nothing is faulting! Thank you for such a great contribution! This will no doubt improve search engine rankings! MLHmptn
  11. MLHmptn

    Seach Engine Friendly URL Support

    This contribution seems to work but at times on my server it seems to timeout or something or other. I am constantly getting "This page cannot be found" like 3 out of 4 times. Is there something I can do on the server end to fix this?
  12. MLHmptn

    Recover Cart Sales

    MET00, This contribution is the BOMB! Thank you dearly for your contribution! This contribution has already helped me recover sales that were forever lost and I am greatful for this! Do you have a mailing address as I'd like to pay you something for this contribution! With Regards, MLHmptn
  13. How would I go about adding a infobox or simply an image directly below the product information that would tell the customer if an item can be shipped via UPS or not? It would be nice to be able to set up a table in sql with UPS as something that is either on or off and then the image would change on the prodoct_info.php page according to the value in a SQL table. Is this possible? I'm sure it is but I just don't know how to go about doing it. I have searched the forums and contributions for any such issue or feature and have found nothing that can do this. Any help would be greatly appreciated! MLHmptn
  14. MLHmptn

    coolMenu

    Nevermind, I finally got it working. It was simply due to " ' " in my product categories...Thank you for this great contribution Andreas!
  15. MLHmptn

    coolMenu

    HELP!!! :>~ I cannot figure out why I am getting javascript errors with my coolmenu installation. The Categories box is completely empty and just displays coolmenu and nothing else. I have added and modified the appropriate tags in the install.html file but I just can't seem to get this thing going.. IE reports that there is an error on line 195 character 48 and the error is expected ')' Can somebody help me out here :> I'm trying to put down the finishign touches on the layout of my site and this is critical. Thanks in advance!! MLHmptn www.trashcandepot.com
×