Jump to content

madyson3

Members
  • Content count

    72
  • Joined

  • Last visited

Profile Information

  1. madyson3

    Automatically send data feed to Froogle

    Okay maybe I'm a dumb bunny. I saw someone else with the same question, but I didn't see an answer. (Course could be the ole' ADD kicking in.) In the instructions you have: I'm sorry but I am not familiar with cron jobs or where to find my unix route. Can someone please help? I think this is a great contribution, and I'd really like to take advantage of the automated weekly feed. Thanks in advance.
  2. madyson3

    Automatically send data feed to Froogle

    Woo hoo. Worked for me too! B)
  3. madyson3

    Newsletters Module

    I'm getting the same error message as pcolley: Fatal error: Call to undefined function: tep_array_merge() in /home/madyson3/public_html/catalog/admin/newsletters_subscribers_view.php on line 469 anyone know what it means?
  4. madyson3

    Master Products - MS2

    This coming from a state that is considered by the rest of the country as having fruity legislation and the worst economic development. Just what CA needs: another reason to drive companies out of the state. :rolleyes: --Kristy
  5. madyson3

    Master Products - MS2

    There's probaby a quick way you can do it to the DB with a SQL statement. --Kristy
  6. madyson3

    Master Products - MS2

    rufiogsr, Have you tried adding the products attributes to the slave? I think you are thinking in an OO way instead of a DB way. A product slave probably can't "inheret" its master's attributes. HTH, Kristy
  7. madyson3

    Master Products - MS2

    Okay, I think I have half way fixed it. I saw the one of my sql statements was missing some info. (By the way why do you have p.products_price listed twice in the $product_query on line 476?) I also so some difference in code with "Beyond Compare" program you suggested where I had && listed as && . When I changed it some interesting things happened. 1.) when I select a master from the drop down, the product_id for the master properly populated (it's never done that before!) 2.) When I use the drop down from the "select master", though #1 happens when I choose the master, it reverts back to "select Master" in the field. It saves properly, but it will not retain the name of the master once selected. Any suggestions? Thanks, Kristy
  8. madyson3

    Master Products - MS2

    Does it need to be here as well: $sql_data_array ? Kristy
  9. madyson3

    Master Products - MS2

    Yes it is. Here is the line: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_master, products_master_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Kristy
  10. madyson3

    Master Products - MS2

    I already had a contribution (Ulta Pics). It was easier to copy the ulta pics code into the download file rater then vice versa. --Kristy
  11. madyson3

    Master Products - MS2

    Okay here's the deal: When I go to edit a slave product, it defaulting to Previously I had a master assigned to it and the Hide radio button selected. If I look in the database it shows it correctly (set to 0 for hide.) So if I edit a different field and do not update the Master and Hide fields, then the slave product is reset to "show". If I update it along with my other edits then it will correctly hide, but when I open it to edit again, the same default as the image appears.
  12. madyson3

    Master Products - MS2

    :rolleyes: Yes, It's me again. I've been working on my website all day (thanks to the help of many people ....Matti you rock). I thought I had it all good and stable about an hour ago, then I did a smoke test for funtionality. Whoops, I have lost the ability to HIDE a slave product. I still have the option to select hide, but it won't save. The only thing (I think) I have done since it was working was change the length of the Product model name in the database. It was 12 before and now it is 20. I don't see how that would effect it though. Any thoughts or suggestions? Thanks, Kristy
  13. madyson3

    New products error

    Replacing it, fixed it. I just hope I didn't screw anything else up. Saw weird differends when I compared the files. Maybe I replaced something that I was suppose to in a different file, then noticed the different file wasn't working, and corrected it. Anyhow, I just did a smoke test on the website, and everything seems to be in order. Thanks again for all of your help!
  14. madyson3

    New products error

    Thanks for the advise Marg. Here is my file: <?php /* $Id: products_new.php,v 1.27 2003/06/09 22:35:33 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCTS_NEW); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCTS_NEW)); ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? 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 class="pageHeading"><?php echo HEADING_TITLE; ?></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> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $products_new_array = array(); //Products_master $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; //Products_master EOF $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW); if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?><tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?><tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($products_new_split->number_of_rows > 0) { $products_new_query = tep_db_query($products_new_split->sql_query); while ($products_new = tep_db_fetch_array($products_new_query)) { if ($new_price = tep_get_products_special_price($products_new['products_id'])) { $products_price = '<s>' . $currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($products_new['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($products_new['products_price'], tep_get_tax_rate($products_new['products_tax_class_id'])); } ?><tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $products_new['products_image'], $products_new['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> <td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '"><b><u>' . $products_new['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($products_new['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $products_new['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <!--Master Products //--> <?php if ($products_new['products_master_status'] != '1' && $products_new['products_master'] =='0') { ?> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_NEW, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> <?php } elseif ($products_new['products_master'] != '0') { ?> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_master']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> <?php } else { ?> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> <?php } ?> <!--Master Products EOF //--> <tr> <td class="main"><?php echo TEXT_NO_NEW_PRODUCTS; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table></td> </tr> <?php if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <?php } ?> </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'); ?>
  15. madyson3

    osCommerse Title top of IE

    That worked. Funny I thought I had looked there, but evidently, I didn't. Thank you so much. --Kristy
×