Jump to content

xaragua

Members
  • Content count

    2
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    The people
  • Website
  1. xaragua

    [Contrib] Make An Offer

    Thanks Howard for the update. I will request one more help from you with this good feature. I perfomed all the install but every time I add the following: 5) Change the file catalog/product_info.php: Search For: $product_info_query = tep_db_query("select p.products_id, pd.products_name And Add: p.products_make_an_offer Between: p.products_model and p.products_quantity ------------------------------------------------------ Search For: <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> And Add just above that: <?php if ($product_info['products_make_an_offer'] == true) { ?> <td class="main" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_MAKE_AN_OFFER, tep_get_all_get_params()) . '">' . tep_image_button('button_make_an_offer.gif', IMAGE_BUTTON_MAKE_AN_OFFER) . '</a>'; ?></td> <?php } ?> I run into a problem. All looks fine except that I lose all background color and pictures on the product_info.php that I select. I can see clearly that the added feature "Make an Offer" shows up but no pics... or background is displayed any longer. Here is a copy of that section: <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_make_an_offer, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> Any help? Xaragua
  2. xaragua

    [Contrib] Make An Offer

    I appear to have ran into the same problem. I read all the update and am at a stalled state since my latest error after correcting the previous error as the previous user mentioned is now the following: 1109 - Unknown table 'p_products' in field list select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p_products.make_an_offer, 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 from products p, products_description pd where p.products_id = '83' and p.products_id = pd.products_id and pd.language_id = '1' My problem is that I am not to familiar with php. Meanwhile, I tried to search for that line argument in catalog files but in vain. I will wait for the next version of "Make an offer". When you coreect and have all updates ready please send me one copy of the zip file. That would be greatly appreciated. Thanks.
×