Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sophina

Members
  • Content count

    10
  • Joined

  • Last visited

Profile Information

  • Real Name
    Sophina Liu
  1. sophina

    Seperate Pricing Per Customer v3.5

    I solved it!! thanks again! Sophina
  2. sophina

    Seperate Pricing Per Customer v3.5

    Hello, I were install the "Wishlist 3.5d".but the wishlist.php show the price was wrong! How can I do? The wishlist.php code just as below:(sorry for my english :blush: ) <?php /* $Id: wishlist.php,v 3.0 2005/04/20 Dennis Blake osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_WISHLIST); /******************************************************************* ******* ADD PRODUCT TO WISHLIST IF PRODUCT ID IS REGISTERED ******** *******************************************************************/ if(tep_session_is_registered('wishlist_id')) { $wishList->add_wishlist($wishlist_id, $attributes_id); if(WISHLIST_REDIRECT == 'Yes') { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id)); } else { tep_session_unregister('wishlist_id'); } } /******************************************************************* ****************** ADD PRODUCT TO SHOPPING CART ******************** *******************************************************************/ if (isset($HTTP_POST_VARS['add_wishprod'])) { if(isset($HTTP_POST_VARS['add_prod_x'])) { foreach ($HTTP_POST_VARS['add_wishprod'] as $value) { $product_id = tep_get_prid($value); $cart->add_cart($product_id, $cart->get_quantity(tep_get_uprid($product_id, $HTTP_POST_VARS['id'][$value]))+1, $HTTP_POST_VARS['id'][$value]); } } } /******************************************************************* ****************** DELETE PRODUCT FROM WISHLIST ******************** *******************************************************************/ if (isset($HTTP_POST_VARS['add_wishprod'])) { if(isset($HTTP_POST_VARS['delete_prod_x'])) { foreach ($HTTP_POST_VARS['add_wishprod'] as $value) { $wishList->remove($value); } } } /******************************************************************* ************* EMAIL THE WISHLIST TO MULTIPLE FRIENDS *************** *******************************************************************/ if (isset($HTTP_POST_VARS['email_prod_x'])) { $errors = false; $guest_errors = ""; $email_errors = ""; $message_error = ""; if(strlen($HTTP_POST_VARS['message']) < '1') { $error = true; $message_error .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_MESSAGE . "</div>"; } if(tep_session_is_registered('customer_id')) { $customer_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $customer = tep_db_fetch_array($customer_query); $from_name = $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; $from_email = $customer['customers_email_address']; $subject = $customer['customers_firstname'] . ' ' . WISHLIST_EMAIL_SUBJECT; $link = HTTP_SERVER . DIR_WS_CATALOG . FILENAME_WISHLIST_PUBLIC . "?public_id=" . $customer_id; //REPLACE VARIABLES FROM DEFINE $arr1 = array('$from_name', '$link'); $arr2 = array($from_name, $link); $replace = str_replace($arr1, $arr2, WISHLIST_EMAIL_LINK); $message = tep_db_prepare_input($HTTP_POST_VARS['message']); $body = $message . $replace; } else { if(strlen($_POST['your_name']) < '1') { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_YOUR_NAME . "</div>"; } if(strlen($_POST['your_email']) < '1') { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " .ERROR_YOUR_EMAIL . "</div>"; } elseif(!tep_validate_email($_POST['your_email'])) { $error = true; $guest_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>"; } $from_name = stripslashes($_POST['your_name']); $from_email = $_POST['your_email']; $subject = $from_name . ' ' . WISHLIST_EMAIL_SUBJECT; $message = stripslashes($HTTP_POST_VARS['message']); $z = 0; $prods = ""; foreach($HTTP_POST_VARS['prod_name'] as $name) { $prods .= stripslashes($name) . " " . stripslashes($HTTP_POST_VARS['prod_att'][$z]) . "\n" . $HTTP_POST_VARS['prod_link'][$z] . "\n\n"; $z++; } $body = $message . "\n\n" . $prods . "\n\n" . WISHLIST_EMAIL_GUEST; } //Check each posted name => email for errors. $j = 0; foreach($HTTP_POST_VARS['friend'] as $friendx) { if($j == 0) { if($friend[0] == '' && $email[0] == '') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ONE_EMAIL . "</div>"; } } if(isset($friendx) && $friendx != '') { if(strlen($email[$j]) < '1') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_EMAIL . "</div>"; } elseif(!tep_validate_email($email[$j])) { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_VALID_EMAIL . "</div>"; } } if(isset($email[$j]) && $email[$j] != '') { if(strlen($friendx) < '1') { $error = true; $email_errors .= "<div class=\"messageStackError\"><img src=\"images/icons/error.gif\" /> " . ERROR_ENTER_NAME . "</div>"; } } $j++; } if($error == false) { $j = 0; foreach($HTTP_POST_VARS['friend'] as $friendx) { if($friendx != '') { tep_mail($friendx, $email[$j], $subject, $friendx . ",\n\n" . $body, $from_name, $from_email); } //Clear Values $friend[$j] = ""; $email[$j] = ""; $message = ""; $j++; } $messageStack->add('wishlist', WISHLIST_SENT, 'success'); } } $breadcrumb->add(NAVBAR_TITLE_WISHLIST, tep_href_link(FILENAME_WISHLIST, '', 'SSL')); ?> <!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 (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"><?php echo tep_draw_form('wishlist_form', tep_href_link(FILENAME_WISHLIST)); ?> <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_wishlist.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 if ($messageStack->size('wishlist') > 0) { ?> <tr> <td><?php echo $messageStack->output('wishlist'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (is_array($wishList->wishID) && !empty($wishList->wishID)) { reset($wishList->wishID); ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="3" class="productListing"> <tr> <td class="productListing-heading"><?php echo BOX_TEXT_IMAGE; ?></td> <td class="productListing-heading"><?php echo BOX_TEXT_PRODUCT; ?></td> <td class="productListing-heading"><?php echo BOX_TEXT_PRICE; ?></td> <td class="productListing-heading" align="center"><?php echo BOX_TEXT_SELECT; ?></td> </tr> <?php $i = 0; while (list($wishlist_id, ) = each($wishList->wishID)) { $product_id = tep_get_prid($wishlist_id); $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name"); $products = tep_db_fetch_array($products_query); if (($i/2) == floor($i/2)) { $class = "productListing-even"; } else { $class = "productListing-odd"; } ?> <tr class="<?php echo $class; ?>"> <td valign="top" class="productListing-data" align="left"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?></a></td> <td valign="top" class="productListing-data" align="left" class="main"><b><a href="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>"><?php echo $products['products_name']; ?></a></b> <input type="hidden" name="prod_link[]" value="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $wishlist_id, 'NONSSL'); ?>" /> <input type="hidden" name="prod_name[]" value="<?php echo $products['products_name']; ?>" /> <?php /******************************************************************* ******** THIS IS THE WISHLIST CODE FOR PRODUCT ATTRIBUTES ********* *******************************************************************/ $attributes_addon_price = 0; // Now get and populate product attributes $att_name = ""; if (isset($wishList->wishID[$wishlist_id]['attributes'])) { while (list($option, $value) = each($wishList->wishID[$wishlist_id]['attributes'])) { echo tep_draw_hidden_field('id[' . $wishlist_id . '][' . $option . ']', $value); $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $wishlist_id . "' and pa.options_id = '" . $option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); $attributes_values = tep_db_fetch_array($attributes); if ($attributes_values['price_prefix'] == '+') { $attributes_addon_price += $attributes_values['options_values_price']; } else if($attributes_values['price_prefix'] == '-') { $attributes_addon_price -= $attributes_values['options_values_price']; } $att_name .= " (" . $attributes_values['products_options_name'] . ": " . $attributes_values['products_options_values_name'] . ") "; echo '<br /><small><i> ' . $attributes_values['products_options_name'] . ': ' . $attributes_values['products_options_values_name'] . '</i></small>'; } // end while attributes for product } echo '<input type="hidden" name="prod_att[]" value="' . $att_name . '" />'; if (tep_not_null($products['specials_new_products_price'])) { $products_price = '<s>' . $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($products['specials_new_products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($products['products_price']+$attributes_addon_price, tep_get_tax_rate($products['products_tax_class_id'])); } /******************************************************************* ******* CHECK TO SEE IF PRODUCT HAS BEEN ADDED TO THEIR CART ******* *******************************************************************/ if($cart->in_cart($wishlist_id)) { echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_IN_CART . '</b></font>'; } /******************************************************************* ********** CHECK TO SEE IF PRODUCT IS NO LONGER AVAILABLE ********** *******************************************************************/ if($products['products_status'] == 0) { echo '<br /><font color="#FF0000"><b>' . TEXT_ITEM_NOT_AVAILABLE . '</b></font>'; } $i++; ?> </td> <td valign="top" class="productListing-data"><?php echo $products_price; ?></td> <td valign="top" class="productListing-data" align="center"> <?php /******************************************************************* * PREVENT THE ITEM FROM BEING ADDED TO CART IF NO LONGER AVAILABLE * *******************************************************************/ if($products['products_status'] != 0) { echo tep_draw_checkbox_field('add_wishprod[]',$wishlist_id); } ?> </td> </tr> <?php } ?> </table> </td> </tr> <tr> <td align="right"><br /><?php echo tep_image_submit('button_delete.gif', 'Delete From Wishlist', 'name="delete_prod" value="delete_prod"') . " " . tep_image_submit('button_in_cart.gif', 'Add to Cart', 'name="add_prod" value="add_prod"'); ?></td> </tr> </table> <?php /******************************************************************* *********** CODE TO SPECIFY HOW MANY EMAILS TO DISPLAY ************* *******************************************************************/ if(!tep_session_is_registered('customer_id')) { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><?php echo WISHLIST_EMAIL_TEXT_GUEST; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="center"> <table border="0" width="400px" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><table cellpadding="2" cellspacing="0"> <tr> <td colspan="2"><?php echo $guest_errors; ?></td> </tr> <tr> <td class="main"><?php echo TEXT_YOUR_NAME; ?></td> <td class="main"><?php echo tep_draw_input_field('your_name', $your_name); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_YOUR_EMAIL; ?></td> <td class="main"><?php echo tep_draw_input_field('your_email', $your_email); ?></td> </tr> </table></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_black.gif', '100%', '1'); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } else { ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><?php echo WISHLIST_EMAIL_TEXT; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="center"> <table border="0" width="400px" cellspacing="0" cellpadding="2"> <?php } ?> <tr> <td colspan="2"><?php echo $email_errors; ?></td> </tr> <?php $email_counter = 0; while($email_counter < DISPLAY_WISHLIST_EMAILS) { ?> <tr> <td class="main"><?php echo TEXT_NAME; ?>??<?php echo tep_draw_input_field('friend[]', $friend[$email_counter]); ?></td> <td class="main"><?php echo TEXT_EMAIL; ?>??<?php echo tep_draw_input_field('email[]', $email[$email_counter]); ?></td> </tr> <?php $email_counter++; } ?> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><?php echo $message_error; ?></td> </tr> <tr> <td colspan="2" class="main"><?php echo TEXT_MESSAGE . tep_draw_textarea_field('message', 'soft', 45, 5); ?></td> </tr> <tr> <td colspan="2" align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE, 'name="email_prod" value="email_prod"'); ?></td> </tr> </table> </td> </tr> </table> </form> <?php } else { // Nothing in the customers wishlist ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"><?php echo BOX_TEXT_NO_ITEMS;?></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> </form> <?php } ?> <!-- customer_wishlist_eof //--> </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'); ?> Please help me! Thanks very much!! Sophina
  3. sophina

    Seperate Pricing Per Customer v3.5

    Dear Janz Thank you for your reply. With your help, the problem solved. Thank you very very much!!
  4. hi I were install QTpro4.25. It works wonderful. But I just had one problem! In products_info page A products S - out of stock M Then, I put the M size in the cart.(M size just only one Quantity in stock).and checkout. I view A product again, IT still show S- out of stock M In fects the M size were out of stock too. how can i do? Please help me! Thanks very much Sophian
  5. sophina

    Seperate Pricing Per Customer v3.5

    HI I were install "SPPC" ,and "Specials_Module". The file named "product_specials.php" in "Specials_Module" were not show the right price. Please help me. The "product_specials.php" code just as below: <?php /* $Id: product_specials.php,v 1.0 2005/11/11 00:00:00 holforty Exp $ Designed for: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2005 Todd Holforty - mtholforty@surfalot.com Released under the GNU General Public License */ ?> <!-- product_specials //--> <?php // are we viewing a specific product? ($product_info['products_id'] is set if we are) if (tep_not_null($product_info['products_id'])) { $the_products_catagory_query = tep_db_query("select products_id, categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . $product_info['products_id'] . "'" . " order by products_id,categories_id"); $the_products_catagory = tep_db_fetch_array($the_products_catagory_query); $product_category_id = $the_products_catagory['categories_id']; } if ( (LIMIT_PRODUCT_SPECIALS_SCOPE=='true') && !empty($new_products_category_id) ) { /// We are in category depth $product_specials_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, specials s where p.products_status='1' and p.products_id=s.products_id and p.products_id=pd.products_id and pd.language_id='".(int)$languages_id."' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and s.status='1' and c.parent_id = '" . (int)$new_products_category_id . "' order by rand() limit ".MAX_DISPLAY_PRODUCT_SPECIALS); } else if ( (LIMIT_PRODUCT_SPECIALS_SCOPE=='true') && !empty($product_category_id) ) { // products info page $product_specials_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, specials s where p.products_status='1' and p.products_id=s.products_id and p.products_id=pd.products_id and pd.language_id='".(int)$languages_id."' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and s.status='1' and c.categories_id = '" . (int)$product_category_id . "' order by rand() limit ".MAX_DISPLAY_PRODUCT_SPECIALS); } else { // default $product_specials_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status='1' and p.products_id=s.products_id and p.products_id=pd.products_id and pd.language_id='".(int)$languages_id."' and s.status='1' order by rand() limit ".MAX_DISPLAY_PRODUCT_SPECIALS); } if (tep_db_num_rows($product_specials_query)>0) { $info_box_contents = array(); $info_box_contents[] = array('text' => '<a href="'.tep_href_link(FILENAME_SPECIALS).'">'.TABLE_HEADING_PRODUCT_SPECIALS.'</a>' ); new infoBoxHeading($info_box_contents,false,false, tep_href_link(FILENAME_SPECIALS)); $row = 0; $col = 0; $info_box_contents = array(); while ($product_specials = tep_db_fetch_array($product_specials_query)) { $products_price = (tep_not_null($product_specials['specials_new_products_price'])?'<s>'.$currencies->display_price($product_specials['products_price'], tep_get_tax_rate($product_specials['products_tax_class_id'])).'</s> ':'').'<span class="productSpecialPrice">' . $currencies->display_price($product_specials['specials_new_products_price'], tep_get_tax_rate($product_specials['products_tax_class_id'])).'</span>'; $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $product_specials['products_image'], $product_specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials['products_id']) . '">' . $product_specials['products_name'] . '</a><br>' . $products_price ); $col ++; if ($col > PRODUCT_SPECIALS_DISPLAY_COLUMNS-1) { $col = 0; $row ++; } } new contentBox($info_box_contents); } ?> <!-- product_specials_eof //--> How can I do? Thanks!! Sophina
  6. sophina

    Seperate Pricing Per Customer v3.5

    Dear JanZ: Thanks for your reply. With the help of your reply, I finally solved the problem. thank you very very much. Sophina
  7. sophina

    [Contribution] Specials_Module

    Never Mind. Anyway, thank you for your reply. Sophina
  8. sophina

    [Contribution] Specials_Module

    Dear surfalot': Sorry..."sppc" is "Seperate Pricing Per Customer" at http://www.oscommerce.com/community/contributions,716 This mod alllows the site owner to assign customers to seperate groups and then give different pricing per product for each group. Thank very very very much for your reply. Sophina
  9. sophina

    [Contribution] Specials_Module

    hi I were install the "Specials_Module", it works wonderful,but I had one problem. I were install the "sppc" too. So, the file named "product_specials.php" show the price were not right. How can I do? Please help me! thanks very much! sophina
  10. sophina

    Seperate Pricing Per Customer v3.5

    Hi I were install the "Seperate Pricing Per Customer 4.1", it's very wonderful.But, I just had one problem. I were also install the "featured_products_v1.5.2".The file named catalog\featured_products.php can't show the right price. catalog\featured_products.php code just as below: $featured_products_array = array(); $featured_products_query_raw = "select p.products_id, pd.products_name, 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 and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name"; $featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_FEATURED_PRODUCTS); if (($featured_products_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 $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?> </td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_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> <!-- Featured Products Main Page Box --> <table bgcolor="ffffff" border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($featured_products_split->number_of_rows > 0) { $featured_products_query = tep_db_query($featured_products_split->sql_query); while ($featured_products = tep_db_fetch_array($featured_products_query)) { if ($new_price = tep_get_products_special_price($featured_products['products_id'])) { $products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['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=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['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=' . $featured_products['products_id']) . '"><b><u>' . $featured_products['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($featured_products['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $featured_products['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> </tr> <tr> <td colspn="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } } else { ?> <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 (($featured_products_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 $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_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'); ?> Please Help Me!! Thank You!!
×