Jump to content

desk2web

Members
  • Content count

    53
  • Joined

  • Last visited

Profile Information

  • Real Name
    Allan Young
  1. desk2web

    Problem with Protx

    Thanks for the link, I just hope a quick backup and install of this will be all I need :S I've looked in the folder structure on the site, and there is even a Protx folder of the site root - not something I've ever seen before - also the includes/modules/payments includes a protx_form.php file, and this contrib is protx_direct, will this mean I could install both just to see? I'm in areal panic over this one lol as the site is live. Thanks
  2. desk2web

    Problem with Protx

    I've inherited an osCommerce installation and have been informed this morning that the Protx side of things isnt working properly. It would seem that the client is receiving and email from Protx which doesnt contain product details, this wouldnt be so much of a problem if the client was still receiving the standard email from the site detailing the purchase, but she's not even getting that now. I believe the Protx system has changed, but am not sure how this affects this site having not been involved with it till now. I really would appreciate some guidance on what I need to check (where I need to check) etc - if any kind sould is available to have a look at the site for me and fix the problem I may be able to get a few bucks off the client to compensate your time. Here's hoping! Thanks in advance.
  3. desk2web

    Wishlist 3.0 Support Thread

    Hi there, this looks like its just the job for a site I am building, perfect with the modifications thunderace workded out. Quick question to thunderace/babygurgles - which of the numerous contribs relating to Wishlish 3.x did you install? This is one this which always baffles me when going looking for contributions, there are always so many (usually) additional files and bits that one never knows if they are all additional or included etc, so any advice you can give me would be very greatly appreciated. Thanks in advance
  4. desk2web

    [CONTRIBUTION] CCGV (trad)

    OK, managed to get the Gift Vouchers to show on the payment screen. Admin can send out Gift Vocuhers manually, which are received by the customer, but when I redeem them in an order they still show as unredeemed in admin. A I checked and can confirm that all the optional changes for displaying the voucher balance within My Account were done, but nothing shows. I am now at the stage that I am looking for someone to check over my code and I'll pay them to sort it out, its that urgent for me. Anyone interested in this as a paying gig please contact me.
  5. desk2web

    [CONTRIBUTION] CCGV (trad)

    What an awesome contribution, which I will be using as a feature on http://bangorfuels2.desk2web.co.uk so that customers can effectively save money - purchasing gift vouchers which they redeem themselves so that their accounts build up ready for the winter when they need fuel more. Anyway, I thought I had installed the contrib properly, although the site is modified the main files were pretty straight forward to edit with winmerge, only issues were cos of price breaks contrib. I set up a sample gift voucher, GIFT_25, weight as 0 and set downloads to true - product purchase goes through, and I get the email to that effect, but nothing for the gift voucher itself, and the voucher does not appear in the queue. Also noticed that in Modules > Order Total the coupons option appears, but not gift vouchers; and that when I check My Account there is nothing about Account Balance - this is one feature I was really hoping to have so that customers can check how much they have saved up. I'm going to go and check every file again tomorrow, its late here now, but was wondering if there is anything I should check first?
  6. Hi there, can anyone point me in the right direction to change featured_products.php to display 2 columns instead of three. I'm trying/wanting to get the featured products output to look like .... any advice and suggestions would be appreciated. Thanks in advance code is .... <?php /* $Id: featured_products.php,v 1.5.8 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_FEATURED_PRODUCTS); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_FEATURED_PRODUCTS)); ?> <!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"> </td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php ///// To random featured products // list($usec, $sec) = explode(' ', microtime()); // srand( (float) $sec + ((float) $usec * 100000) ); // $mtm= rand(); ////// $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"; // to random// $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 rand($mtm)"; $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üan="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 == '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> <?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'); ?>
  7. desk2web

    [Contribution] STS v4

    I've tried searching this thread for an answer but just can't find the right info, so I've posted this message, however, if I have missed something and the info is already here please accept my apologies. Basically at http://silverstore.desk2web.co.uk I have STS 4.1 installed, I've enabled the default to use sts_template.html and that works fine for every page, what I would like to do is have the main homepage to use this layout, and every other page to use a slightly different version - ie one without the category link images etc etc. I thought that by enabling the index to use index.php.html and the default as sts_template.html but this does not seem to be the case. Any advice or suggestions appreciated. Thanks in advance.
  8. desk2web

    Multi-Stores Multiple Shops Support

    I think this contribution will be just the solution I need, however there is one thing I need whch I am unsure of; namely, I will have multiple shops (branches), CCGV will be installed, I am hoping that customers can purchase from any of the branches and be able to pay at any branch (online or walkin, with cash/credit card/credits etc) I am not even sure, reading that back, that it makes sense to me, or that I am asking something that is even logical! My client needs to be able to view reports for each individual branch outlet - which I assume will not be a problem. If you can follow what I mean please let me know!! Thanks in advance.
  9. Hi folks, a client of mine who is considering setting up an osCommerce site needs integration with Sage Line 50 - now I found http://www.oscommerce.com/community/contri...ch,sage+line+50 and haveyet to install it because I would like to hear from anyone who has already used it - or is using some other method of integrating with Sage. The problem I face is that this client has already found an off the shelf package which offers e-commerce and Sage integration, the limiting factor is the price (I am not aware of the package, but he has told me is very expensive) - so, if I can find him an alternative then I'll get his custom. So if anyone has any experience of connecting Sage to osC please let me know. Many thanks in advance
  10. desk2web

    [Contribution] STS v4

    Can you post your sts_template.php.html file here, it would make things easier for those who know what they are looking for to work it out.
  11. desk2web

    Featured Products v1.5.6

    Whilst I have your attention, I am keen to have an image behind each item in the featured list, specifically: or if a similar effect can be achieved by CSS then that would be great Anyone any ideas please. Thanks in advance.
  12. I'm having a few problems working out which code to edit out in the last step of the installation: Step 13: For this step some customizing may need to be done. The following code includes the seperate pricing contribution. You may also want to add things like a different model number field, cost, or other description... edit /catalog/admin/includes/functions/html_output.php and at the very bottom right before the ?> add: //draw products multiselect box function tep_draw_products_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; // BOF - Separate_Pricing_Per_Customer_v3.5 $all_groups=array(); $customers_groups_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id "); while ($existing_groups = tep_db_fetch_array($customers_groups_query)) { $all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name']; } $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_code"); while ($products = tep_db_fetch_array($products_query)) { // BOF - Separate_Pricing_Per_Customer_v3.5 // Next lines were original code // if (!in_array($products['products_id'], $exclude)) { // $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; // } $price_query=tep_db_query("select customers_group_price, customers_group_id from " . TABLE_PRODUCTS_GROUPS . " where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ //if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } //} if (!in_array($products['products_id'], $selected_vals)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } else { $select_string .= '<option value="' . $products['products_id'] . '" SELECTED>' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF - Separate_Pricing_Per_Customer_v3.5 } $select_string .= '</select>'; return $select_string; } //draw products multiselect delete box function tep_draw_products_delete_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; $products_query = tep_db_query("select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name"); while ($products = tep_db_fetch_array($products_query)) { $select_string .= '<option value="' . $products['featured_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'].'</option>\n'; } $select_string .= '</select>'; return $select_string; } I've had a go at editing the code, and have succeeded to a small degree in that I now see: which is a start I guess! //draw products multiselect box function tep_draw_products_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; // BOF - Separate_Pricing_Per_Customer_v3.5 // $all_groups=array(); // $customers_groups_query = tep_db_query("select distinct customers_group_name, customers_group_id from " . TABLE_CUSTOMERS . " order by customers_group_id "); // while ($existing_groups = tep_db_fetch_array($customers_groups_query)) { // $all_groups[$existing_groups['customers_group_id']]=$existing_groups['customers_group_name']; // } // $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_code"); // while ($products = tep_db_fetch_array($products_query)) { // BOF - Separate_Pricing_Per_Customer_v3.5 // Next lines were original code if (!in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; } // this is crap $price_query=tep_db_query("select customers_group_price, customers_group_id from " . TABLE_PRODUCTS_GROUPS . " where products_id = " . $products['products_id']); // $product_prices=array(); // while($prices_array=tep_db_fetch_array($price_query)){ // $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; // } // reset($all_groups); // $price_string=""; // $sde=0; // while(list($sdek,$sdev)=each($all_groups)){ if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { // if($sde) // $price_string.=", "; // $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); // $sde=1; // } } // if (!in_array($products['products_id'], $selected_vals)) { // $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; // } else { // $select_string .= '<option value="' . $products['products_id'] . '" SELECTED>' . $products['products_model'] . ' ' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; //} // EOF - Separate_Pricing_Per_Customer_v3.5 } $select_string .= '</select>'; return $select_string; // } //draw products multiselect delete box function tep_draw_products_delete_mselect($name, $parameters = '', $selected_vals) { global $currencies, $languages_id; if ($exclude == '') { $exclude = array(); } $select_string = '<select name="' . $name . '"'; if ($parameters) $select_string .= ' ' . $parameters; $select_string .= ' multiple>'; $products_query = tep_db_query("select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name"); while ($products = tep_db_fetch_array($products_query)) { $select_string .= '<option value="' . $products['featured_id'] . '">' . $products['products_model'] . ' ' . $products['products_name'].'</option>\n'; } $select_string .= '</select>'; return $select_string; } ?>
  13. desk2web

    [Contribution] STS v4

    I have STS 4.1 installed and working perfectly. However due to the design I have been asked to implement the $cartbox command pushes the design out of synch, is there a way to inlcude only the cart value instead of the contents and value? Thanks in advance
  14. desk2web

    Seperate Pricing Per Customer v3.5

    OK, this one is fixed. But I get a 1054 - Unknown column 'products_price1' in 'field list' error when I try to add a product.
  15. desk2web

    Seperate Pricing Per Customer v3.5

    I've just installed SPPC and the Quantity Break contrib and when I go into Admin to click onto "Customer Groups" I get the following: "Access Denied No Right Permission Access Please contact your Web Administrator to request more access or if you found any problem. " Can anyone help me out or at least give me an idea of what I need to check -thanks in advance.
×