pynchon

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

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

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 ([email protected]) 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

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

thank you ... I'll be keeping the dashes then ... lol

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

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

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

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

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.

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

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

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

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

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

good morning I am running a store using v3.1 and am in the process of upgrading to v4.3 Do I have to run the upgrade.sql part of the module ? My tests last night failed but I couldn't see any specific error response ... but in admin->orders my order displayed "You have sent an uncrecognised values in the TxType field. " in the Status Detail field. Does this indicate that the upgrade.sql is necessary or have I done something else wrong ? It doesn't help matter that Protx appears to have broken down this morning. Many Thanks John Keiller

To whomever wrote the protx direct contribution: this is a work of sheer genius ... installed all bits and pieces .. amended what I was told to .. and apart from the minor sql issue it all went like clockwork didn't go to test ... just ploughed on with 'production' .. and it worked first time I can't thank you all enough thank you John Keiller

I ran this from a previous post and it worked fine .. though I can't see a difference between the the two snippets of code DROP TABLE `protx_direct`; CREATE TABLE `protx_direct` ( `id` int(11) unsigned NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `vendortxcode` varchar(40) default NULL, `txtype` varchar(16) default NULL, `value` decimal(15,4)default NULL, `vpstxid` varchar(50) default NULL, `status` varchar(10) default NULL, `statusdetail` varchar(100) default NULL, `txauthno` varchar(10) default NULL, `securitykey` varchar(10) default NULL, `avscv2` varchar(50) default NULL, `address_result` varchar(20) default NULL, `postcode_result` varchar(20) default NULL, `CV2_result` varchar(20) default NULL, `3DSecureStatus` varchar(12) default NULL, `CAVV` varchar(32) default NULL, `txtime` timestamp default NULL, UNIQUE KEY `id` (`id`) ) Type=MyISAM AUTO_INCREMENT=1; on reviewing the sql the differences are UNIQUE KEY `id` (`id`) ) Engine=MyISAM AUTO_INCREMENT=1; UNIQUE KEY `id` (`id`) ) Type=MyISAM AUTO_INCREMENT=1; the second variant was the one that worked ... the first failed John K

hello there I'm upgrading from v2.4 to v3.2 and when I run the new_install.sql as advised in the install instructions I get the following error how do I sort this error? thanks in advance John K

my apologies i won't do it again honest John K :)

HI Is there a way of shifting the gift voucher/discount coupon code entry box from the credit card page to the checkout_shipping page (or before the checkout_shipping page) ? (I have looked through the postings throughout the thread but honestly couldn't see a similar question) many thanks John Keiller

Is it quite a straightforward upgrade ? Or should I expect difficulties ? many thanks again John K

sorry ... I should have asked another question How do I identify the version of the Protx Direct contribution that is currently installed thank you John K

Tom, I told my client about the switch of dates from 30th June to the 1st of August and he is quite happy with it. However, he forwarded me an email from Protx concerning 3D-Secure. I apparently have to get 3D Secure integrated before the weekend for the processing of Maestro payments. Which version of the Protx contribution will I need for this ? many thanks John K

this can be done from the Admin panel Modules/Payment ... then uninstall the two options you don't need JK