Jump to content

pynchon

Members
  • Content count

    231
  • Joined

  • Last visited

  • Days Won

    1

pynchon last won the day on May 10 2010

pynchon had the most liked content!

1 Follower

About pynchon

  • Birthday 07/11/1963

Profile Information

  • Real Name
    John K
  • Gender
    Male
  • Location
    somewhere in scotland
  • Website
  1. pynchon

    HSBC secure-epayment module

    If you are running on a Linux server you don't need the DLL files. There should be a Linux folder on the CD you received from HSBC ... or within the files that they may have emailed to you. You will find the necessary files in there : TestHash.e and Libtools.so (not the correct file name but pretty similar). JK
  2. pynchon

    HSBC secure-epayment module

    Hi I installed the contribution and made all the necessary amendments and all was working fine in Test Mode. The CPI came up, entered the CC details and was returned to the shop - Order appeared within admin and confirmation email sent and received. However, when I switched on Production Mode I now get kicked straight back to the shop when the CPI Servlet is loading and receive the error message 'The transaction failed because of invalid input data'. I've had a look through the thread but can't find anything that relates to this problem, buit if anyone can offer help or advice I'd be most grateful. John Keiller
  3. sometime ago someone posted a modification that would add related products into the shopping_cart.php page. this was a good addition I felt but the code showed the product images next to each other but the text appeared as a list underneath. I have modified the code slightly so the image and text appear on separate rows. The code that follows is for a page titled optional_related_cart.php and needs to uploaded into the modules directory <?php /* $Id: optional_related_cart.php, ver 1.0 02/05/2007 Exp $ Based on code from Contribution: Optional Related Products Ver 4.0 Copyright © 2007 Anita Cross (http://www.callofthewildphoto.com/) Based on code from Optional Relate Products, ver 2.0 05/01/2005 Copyright © 2004-2005 Daniel Bahna (daniel.bahna@gmail.com) osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Released under the GNU General Public License */ ?> <?php //first see if there are any related products to display, if not - show nothing $productid_array = array(); for ($i=0, $n=sizeof($products);$i<$n; $i++) { $productid_array[$i] = $products[$i]['id']; } $orderBy = 'ORDER BY '; $orderBy .= (RELATED_PRODUCTS_RANDOMIZE)?'rand()':'pop_order_id, pop_id'; $orderBy .= (RELATED_PRODUCTS_MAX_DISP)?' limit ' . RELATED_PRODUCTS_MAX_DISP:''; for ($i=0; $i<$n; $i++) { $attributes = " SELECT pop_products_id_slave, products_name, products_model, products_price, products_quantity, products_tax_class_id, products_image FROM " . TABLE_PRODUCTS_RELATED_PRODUCTS . ", " . TABLE_PRODUCTS_DESCRIPTION . " pa, ". TABLE_PRODUCTS . " pb WHERE pop_products_id_slave = pa.products_id AND pa.products_id = pb.products_id AND language_id = '" . (int)$languages_id . "' AND pop_products_id_master = '". $products[$i]['id'] ."' AND products_status='1' " . $orderBy; $attribute_query = tep_db_query($attributes); if (mysql_num_rows($attribute_query)==0) { ?> <?php } else { //if there are related products, let's show the header ?> <tr> <td> <table class="productlisting" border="0" cellspacing="0" cellpadding="2" width="100%"> <tr> <td align="left" class="productListing-heading"> <?php echo TEXT_RELATED_PRODUCTS ?></td> </tr> <?php //now we'll get a list of the products in the cart $productid_array = array(); for ($i=0, $n=sizeof($products);$i<$n; $i++) { $productid_array[$i] = $products[$i]['id']; } $orderBy = 'ORDER BY '; $orderBy .= (RELATED_PRODUCTS_RANDOMIZE)?'rand()':'pop_order_id, pop_id'; $orderBy .= (RELATED_PRODUCTS_MAX_DISP)?' limit ' . RELATED_PRODUCTS_MAX_DISP:''; //now we'll cycle through the list of products in the cart for ($i=0; $i<$n; $i++) { //this is the query $attributes = " SELECT pop_products_id_slave, products_name, products_model, products_price, products_quantity, products_tax_class_id, products_image FROM " . TABLE_PRODUCTS_RELATED_PRODUCTS . ", " . TABLE_PRODUCTS_DESCRIPTION . " pa, ". TABLE_PRODUCTS . " pb WHERE pop_products_id_slave = pa.products_id AND pa.products_id = pb.products_id AND language_id = '" . (int)$languages_id . "' AND pop_products_id_master = '". $products[$i]['id'] ."' AND products_status='1' " . $orderBy; $attribute_query = tep_db_query($attributes); if (mysql_num_rows($attribute_query)>0) { $count = 0; } ?> <tr> <td align="left" class="productListing-data"> <table border="0" cellspacing="0" cellpadding="2" width="100%" align="center"> <?php while ($attributes_values = tep_db_fetch_array($attribute_query)) { //if it's already in the cart, there is no need to display it again, right? if (!in_array($attributes_values['pop_products_id_slave'], $productid_array)) { array_push($productid_array, $attributes_values['pop_products_id_slave']); //make a list of related products $products_name_slave = ($attributes_values['products_name']); $products_model_slave = ($attributes_values['products_model']); $products_qty_slave = ($attributes_values['products_quantity']); $products_id_slave = ($attributes_values['pop_products_id_slave']); if ($new_price = tep_get_products_special_price($products_id_slave)) { $products_price_slave = $currencies->display_price($new_price, tep_get_tax_rate($attributes_values['products_tax_class_id'])); } else { $products_price_slave = $currencies->display_price($attributes_values['products_price'], tep_get_tax_rate($attributes_values['products_tax_class_id'])); } echo '' . "\n"; // show thumb image if Enabled if (RELATED_PRODUCTS_SHOW_THUMBS == 'True') { echo '<tr><td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . "\n" . tep_image(DIR_WS_IMAGES . $attributes_values['products_image'], $attributes_values['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"').'</a><br> ' . "\n"; } $caption = ''; if (RELATED_PRODUCTS_SHOW_NAME == 'True') { $caption .= '<td class="productListing-data" align="left"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . $products_name_slave . '</a>'; if (RELATED_PRODUCTS_SHOW_MODEL == 'True') { $caption .= sprintf(RELATED_PRODUCTS_MODEL_COMBO, $products_model_slave); } $caption .= '</td>' . "\n"; } elseif (RELATED_PRODUCTS_SHOW_MODEL == 'True') { $caption .= '<p>' . $products_model_slave . '</p>' . "\n"; } if (RELATED_PRODUCTS_SHOW_PRICE == 'True') { $caption .= '<td class="productListing-data" align="right"> ' . sprintf(RELATED_PRODUCTS_PRICE_TEXT, $products_price_slave) . '</td>' . "\n"; } if (RELATED_PRODUCTS_SHOW_QUANTITY == 'True') { $caption .= '<p>' . sprintf(RELATED_PRODUCTS_QUANTITY_TEXT, $products_qty_slave) . '</p>' . "\n"; } echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . $caption . '</a>' . "\n"; if (RELATED_PRODUCTS_SHOW_BUY_NOW== 'True') { echo '<td class="productListing-data" align="left" width="15%"> <a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=rp_buy_now&rp_products_id=' . $products_id_slave) . '">' . RELATED_PRODUCTS_BUY_NOW_TEXT . '</a></td>'; } echo '</tr>' . "\n"; $count++; if ((RELATED_PRODUCTS_USE_ROWS == 'True') && ($count%RELATED_PRODUCTS_PER_ROW == 0)) { echo '</tr>' . "\n"; } } } ?> </tr></table> <?php } //} ?> </td> </tr></table> </td> </tr> <?php } } ?> the following needs to be inserted into shopping_cart.php <tr width="100%"> <td align="center" class="main"> <?php include(DIR_WS_MODULES . 'optional_related_cart.php'); ?> </td> </tr> the language additions that were added to languages/english/product_info.php need to be added to languages/english/shopping_cart.php filenames.php will need to be amended to include optional_related_cart.php
  4. pynchon

    [Contribution] U HTML Emails

    Olof, First of all I'd like to thank you for a very neat and easy to install contribution. I only have one question. I have customised the email as much as I can but I am hoping you or someone else can help. I am wanting to include an image of the product the customer purchased in the order confirmation email ... is this possible ? If so, is it relatively easy to do ? Many thanks John K
  5. thank you ... I'll be keeping the dashes then ... lol
  6. Modesto, I installed the contribution on my test server (an xampp installation on my home machine) and I got similar errors to you. When I installed on the actual working server the errors didn't appear and the contribution worked as it was meant to. I'm really not sure if this answer is of any use .... I hope it is though
  7. I installed this contribution and it worked straight away .. so many thanks for a seamless and pain-free contribution. I was hoping that there could be a simple solution for one minor issue. The URL's created are separated by a dash .... http://www.domain.co.uk/prada-glasses-acet...c-1338_503.html Is there a way to use an Underscore rather than a dash ? So the URL would read http://www.domain.co.uk/prada_glasses_acet...c_1338_503.html many thanks J
  8. pynchon

    Protx Direct v2.22

    Tom, so far yes ... this is what is returned. I'll run a test order shortly ... I'll need to clear it with me gaffer first. cheers John K
  9. pynchon

    Protx Direct v2.22

    the only line that I can see that differs is the 'txtime' .... is this safe to change ? and if it is what do I do? thanks for helping with this .... at times my brain feels as small as a walnut JK
  10. pynchon

    Protx Direct v2.22

    Hi, I have finally got round to installing v4.4 (an upgrade from v3.2) and all seems to work as it should. There is one issue however that I'm hoping there is a solution to. When viewing an order in the admin section there was a neat table showing Time, Payment Type, Status etc., this worked perfectly prior to the upgrade but now there are several fields missing/blank ... namely AVS/CV2 check, Address Check, Postcode, CV2 check and Status. I have gone through everything to make sure I've followed all the necessary steps but I can't see anything obvious that I may have neglected to do. Any ideas ? John K p.s. many thanks to you for the help and support that was given and received on this and the Protx forum through what was a very testing time ... I seriously wish there was something I could do in return.
  11. pynchon

    Protx Direct v2.22

    I've undone all my v4.3 integration efforts and am now back with v3.1 all seems to be working ok I think I'll wait till protx have their house in order before I try to upgrade to v4.3 jk
  12. pynchon

    Protx Direct v2.22

    cool .... my brain is fudge just now ... the a slightest thing is anxiety inducing. I've lost a couple of thousand today already plus the possibility of repeat business from those customers. I may have to resort to sedatives JK
  13. pynchon

    Protx Direct v2.22

    are the new URL's part of v4.3 ? or is there something else I need to change etc jk
  14. pynchon

    Protx Direct v2.22

    Many thanks Vger I kind of guessed that this would be the case ... but thought I'd ask just in case. If I had hair I'd be pulling it out. JK
  15. pynchon

    Protx Direct v2.22

    I have gone through everything to make sure I did everything as I should. Payment process works : 3D secure loads into the iFrame but when I submit my password I get returned to checkout_payment.php with the message "Unfortunately there has been a technical problem. Please try again and if the problem persists please contact us" Is this still down to protx? I've been calm up to now ... but I'm beginning to panic. cheers John keiller
×