Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Code Red

  • Content count

  • Joined

  • Last visited

Everything posted by Code Red

  1. Can anyone help me with a problem I'm having with this module. I've installed the module, generated and installed the HOP.php file as required, set the permissions so it's readable etc etc but whenever I try to process a credit card payment I just keep getting the same error - The card type you have selected does not match the number entered. Please try again. I've tried running the same card through Cybersource's Virtual Terminal and it processes fine, so there's nothing wrong with the card. Incidentally, the same error comes up even if I use the "test" credit card number given by the module. I've not really got involved with the payment side of OS Commerce until now, so I'm not really sure where to start in terms of debugging.
  2. Code Red

    PayPal WPP Direct Payments & Express Checkout Support

    I've installed and set up this module, but when I try to test it I get this when I click the Express Payment button - Unauthorized Access Just that - blank page with two words. If I try entering my credit card details I get this - error:14094410:SSL routines:SSL3_READ_BYTES:sslv3 alert handshake failure (Error No. 35) Any ideas what the problem is?
  3. Hi, love this contribution and have been using it for some time but I've started using PNG images and they don't display under ImageMagic. Updating to the most recent version makes no difference. This is on all browsers, Mac and PC not just IE. I've installed the IE fix anyway, but I still just get a blank "dead image link" box. Anyone else have this problem?
  4. I'm replying to this as I had the same problem and have only just fixed it. In includes/classes/shopping_cart.php look for this line (around line 230) - if ($this->contents[$key]['qty'] < 1) { change to this - if ($this->contents[$key]['qty'] < 0.1) { Or whatever minimum fraction you want to deal in
  5. Code Red

    Automatically send data feed to Froogle

    Jack, not sure if I'm a Johnny-come-lately on the subject, but I got a mail from Google this morning listing changes to feed specification. One of these is that shipping costs need to be included, can this contribution handle this already/plans to do so before I start chopping away at your code like the amateur I am?
  6. Actually, it was the opposite which fixed it! The code was already using tep_get_ip_address, changing it to $_SERVER['REMOTE_ADDR'] did the trick - IPs are now automatically banned, thankyou!
  7. First of all, thanks for this great contribution - it's scary to see the number of times a website is attacked per day! It mostly seems to be working fine, just a couple of issues - 1. The auto-ban function doesn't seem to work. I have the config settings as follows - PHPIDS Module true IP Ban Module true Show Intrusion Result false E-mail Log Impact Score 8 DB Log Impact Score 4 IP Ban Impact Score 15 However, despite attack impacts in excess of 38, none of the hacker's IPs have been automatically banned. I've added a "ban all" option to the log page to save doing them all individually, but obviously I'd rather the site did it automatically, as frequently the same IP will make several attempts and I'd prefer them blocked in the first instance. Has anyone else experienced this problem? 2. Frequently the IP address recorded is, which is no use to block obviously. However, sometimes the email report I get does log the actual IP address alongside the localhost address, for example - IP: ( Date: 2011-03-01T14:42:58+00:00 Impact: 38 Affected tags: xss csrf id rfe sqli lfi Affected parameters: REQUEST.asc=eval%28base64_decode%28%5C%27ZXJyb3JfcmVwb3J0aW5nKDApO3NldF90aW1lX2xpbWl0KDApOw0KJH...etc etc (shortened for your viewing pleasure!) Request URI: /index.php Origin: But when I check the log, it's been recorded just as if the email message sent to me can log the real IP address, can the script be modified to pick this up and write it to the log? Just a couple of issues, but aside from that, this is great work and I'm very grateful!
  8. It should include all categories in the path. Be sure you clear the case settings in admin->Configuration->URL SEOs when making such a change. Do you mean the "Reset SEO URLs Cache" setting? I've tried that and it makes no difference, it's still dropping the child category.
  9. I've just installed this and it's working very well, except that the "Add Category Parent To Beginning of URLS" config doesn't appear to be working correctly. With it turned off, I get a URL like this - etcetc.com/electric-c-198.html With it turned on, I get this - etcetc.com/thrusters-bow-thrusters-c-22_30_198.html I lose the last child category off the URL. What I actually want is this - etcetc.com/thrusters-bow-thrusters-electric-c-22_30_198.html Is this how it's meant to work? Any ideas how I can modify it to put the full category path into the URL? Apologies if this has already been answered, a forum search didn't turn anything up.
  10. Code Red

    [contribution] Send_order_html_email

    UPDATE - I've just checked an order confirmation using me.com browser webmail (Apple's mac.com system) and it's not rendering properly - no background colours in the table headings. I think this module might work better with inline CSS?
  11. Code Red

    [contribution] Send_order_html_email

    Hi, I've just installed the latest version of this module and although the emails are much better than the stock OSCommerce output, I'm having problems with the stylesheet - no matter what changes I make to it, there's no change to the email that is sent out - the column headings and background colour remain the same, as do the font and font size. I tried using a different browser because I thought my browser may be storing the stylesheet settings somewhere, but no luck. I've even tried totally deleting the stylesheetmail.css file and I still get a formatted email!!! Is there something I'm missing here? Also, having tussled with HTML emails in the past I have some concerns about compatibility - I'm given to understand that using CSS in emails is a no-no and a lot of web-based email viewers will ignore this information totally. Does anyone have any information on how cross-compatible this contribution is, will it render as well in Outlook, Mac Mail, Thunderbird and also in Hotmail, GMail etc etc?
  12. Code Red

    Country-State Selector

    ignore me - very easy, I was looking in the wrong place. I saw "Javascript" and went all panicky :rolleyes:
  13. Code Red

    Country-State Selector

    How easy is it to modify the ajax.js file so that if a selected country has no zones, instead of the State text box it either shows a nothing or "No States Entered"?
  14. Code Red


    Actually, it's Newsdesk mainly, but when I added the editor to categories it came up with the same problem. To be honest, I find WYSIWYG editors a pain in the neck because they slow the page down so much, but the client doesn't speak HTML, so the site needs it.
  15. Code Red


    Has anyone else come across this problem where FCK editor sticks a load of extra </br>'s into the body text every time you edit a news post? It's really annoying.
  16. Code Red

    Problem with Cybersource SOP Module

    To fill in some additional information - When any credit card is entered, an error code -5 is generated. This code is generated when the card type entered by the customer ($HTTP_POST_VARS['card_cardType']) doesn't match the validated card type ($this->cc_card_type_id). This is where it gets weird - I modified the error message so that it included the variables involved - $error = TEXT_CCVAL_ERROR_CARD_TYPE_MISMATCH . 'The card type is ' . $cc_validation->cc_type . '(' . $this->cc_card_type_id . '), the POST variable is ' . $HTTP_POST_VARS['card_cardType']; When I run a credit card through the site, this is the error message I get - The card type you have selected does not match the number entered. Please try again.The card type is Mastercard(002), the POST variable is 002 As you can see, the two variables clearly DO match (002 = 002), but for some reason the code thinks they don't :blink: What gives???
  17. has anyone produced a mod for Easy Populate that includes a Specials column? I've got almost 10,000 products and a couple of thousand specials...
  18. Code Red

    New UPS XML Shipping Module available

    I can't see a units option in the admin section anywhere. To be honest, I'm a bit perplexed by this - I can't imagine I'm the only person outside of the US who is trying to install this package, so why aren't more people coming across this problem? I would also have thought that by entering your location, country AND UPS account number it would pick up which units system you're going to use from UPS? *EDIT* I managed to find it via a sarky little comment :rolleyes: in the upsxml.php file - the settings aren't in admin>modules>shipping, they're in Configuration. Problem (well, this one anyway) solved!!! Carry on...
  19. Code Red

    New UPS XML Shipping Module available

    I've just installed this system, still playing around with the settings but I'm getting this error on checkout_shipping.php - 111057: This measurement system is not valid for the selected country. I believe that this problem is something to do with units of measurement mismatching - the store is in the UK and uses Kg as the weight (assuming it is the weight that is the problem, I've not got round to looking at the box dimensions option or filling any values yet). Couple of questions - 1. Where are the units set in OSCommerce? It may sound a bit dim, but I've never had to look at this before, the units have always been metric. 2. Is this going to create problems? I really don't want to switch to something prehistoric like Imperial weights and measures, and I know the site owner definitely won't be happy. He ships goods to countries all over the world, so is this going to limit which countries this system can be used in?
  20. This is probably really elementary and I'll kick myself when you tell me, but I can't seem to pull this off - With respect to the function display_count which is in split_page_results, how do I get $from_num as a usable variable? I want to number each line in the product listing result, and to do that I need the "from" value to use as an index... unless there's a simpler way, of course.
  21. Don't worry, cracked it. This is probably a bit clunky, but.... $count = $listing_split->display_remote_count('%d'); Well, it works :rolleyes:
  22. I've just installed kremit's Customer List Improved contribution and it works very well, and with a bit of adaptation it's proved perfect for my needs. However, I really wanted the outputted list (minus the edit/delete functions) to be visible in the public "front end" of the site, not in the Admin as I'm using the Customers facility for a different purpose. So I copied the file across into the catalog folder and made sure all the links to the includes etc were modified to run in that part of the site. However, I'm now getting an SQL syntax error - 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select c.customers_id, c.customers_email_address, c.customers_te select count(select c.customers_id, c.customers_email_address, c.customers_telephone, c.customers_fax, a.entry_company as company, a.entry_city as city, a.entry_street_address as street, a.entry_suburb as suburb, a.entry_postcode as postcode, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country,c.customers_newsletter, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_info ci on c.customers_id = ci.customers_info_id left join countries ctry on a.entry_country_id = ctry.countries_id left join zones z on a.entry_zone_id = z.zone_id order by state ASC, city ASC, c.customers_lastname ASC) as total This is the part of the code it doesn't like - $db_orderby = 'state ' . $sort . ', city ' . $sort . ', c.customers_lastname'; if(!$sort) $sort = 'ASC'; if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) { $keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search'])); $search = "where c.customers_lastname like '%" . $keywords . "%' or c.customers_firstname like '%" . $keywords . "%' or c.customers_email_address like '%" . $keywords . "%'"; } $customers_query_raw = 'select c.customers_id, c.customers_email_address, c.customers_telephone, c.customers_fax, a.entry_company as company, a.entry_city as city, a.entry_street_address as street, a.entry_suburb as suburb, a.entry_postcode as postcode, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country,c.customers_newsletter, a.entry_country_id from ' . TABLE_CUSTOMERS . ' c left join ' . TABLE_ADDRESS_BOOK . ' a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join ' . TABLE_CUSTOMERS_INFO . ' ci on c.customers_id = ci.customers_info_id left join ' . TABLE_COUNTRIES . ' ctry on a.entry_country_id = ctry.countries_id left join ' . TABLE_ZONES . ' z on a.entry_zone_id = z.zone_id ' . $search . ' order by ' . $db_orderby . ' ' . $sort; $customers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows); $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { $info_query = tep_db_query("select customers_info_date_account_created as date_account_created, customers_info_date_account_last_modified as date_account_last_modified, customers_info_date_of_last_logon as date_last_logon, customers_info_number_of_logons as number_of_logons from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers['customers_id'] . "'"); $info = tep_db_fetch_array($info_query); if ((!isset($HTTP_GET_VARS['cID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $customers['customers_id']))) && !isset($cInfo)) { $country_query = tep_db_query("select countries_name from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$customers['entry_country_id'] . "'"); $country = tep_db_fetch_array($country_query); $reviews_query = tep_db_query("select count(*) as number_of_reviews from " . TABLE_REVIEWS . " where customers_id = '" . (int)$customers['customers_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); $customer_info = array_merge($country, $info, $reviews); $cInfo_array = array_merge($customers, $customer_info); $cInfo = new objectInfo($cInfo_array); } This strikes me as a bit odd, as it's still looking at the same db tables as when it was running in admin - I was expecting problems with missed links or missing functions etc but not this. I usually see this sort of thing because I've written some bad code while trying to interrogate the db but I've not touched this bit at all - and if I load the original file still in admin, it works fine! Any pointers on the (probably obvious) mistake I'm making here?
  23. Code Red

    Problem Uploading Images

    I've still not cracked this problem - I've even tried using plain PHP code (ie not using any OSC functions) and I still get a big nothing! I'm uploading an image to the same images folder as categories.php uses, but despite using the same OSC code, or plain PHP the image will not upload. This is the same case whether I'm working with a local copy of the site, or the site on the server. Is there something obvious I'm missing? I'd appreciate some advice.
  24. I've been trying to add the facility to upload an image with each product review (for things such as magazine "Best In Test" rosettes etc) but I can't get the images to upload. This facility is only available to reviews entered via the admin page, not to visitors. I've been using this on the review entry - <td class="main"><?php echo tep_draw_file_field('reviews_image'); ?></td> And this where the form is processed - $reviews_image = new upload('reviews_image', DIR_FS_CATALOG_IMAGES); but nothing happens - not even an attempt to upload the file. When I stuck a print_r($reviews_image); at the processing stage, I get this - upload Object ( [file] => reviews_image [filename] => [destination] => /my_website_path/images/ [permissions] => 511 [extensions] => Array ( ) [tmp_filename] => [message_location] => session ) I notice that both the [filename] and [tmp_filename] values are empty... any ideas?