Jump to content

superfrank

Members
  • Content count

    32
  • Joined

  • Last visited

Profile Information

  • Real Name
    Frank
  • Location
    NL
  • Website

Recent Profile Visitors

3,494 profile views
  1. So I guess I am right with my conclusion that things are still the same like before June 30. I have the same thinking as you - I want to test live and be 100% sure it works, but I don't want to check every day. Instead I guess we will have to check that forum every day. Oh, and maybe that roadmap publication too. Great ;-) I do not have a 'copy' web shop to run tests in. Nor I think it's a good idea to use the sandbox in a live shop (test and real orders could be mixed). Anyway, thanks for pointing that forum/topic out to me. As you suggested, I have added a post.
  2. And so I have just tested. Things are working fine. BUT... I just noticed an update on the PayPal roadmap about this (see the red update text on https://www.paypal-knowledge.com/infocenter/index?page=content&widgetview=true&id=FAQ1913&viewlocale=en_US ) "While we are allowing for these security updates to be made after June 30, 2017, we continue to recommend that you prioritize the changes and updated protocols specified by the PCI Council so you are best positioned to protect your customers from security and fraud-related issues." "While we are allowing for these security updates to be made after June 30" - do I understand well that PCI and PayPal have postponed the deadline? And that PayPal has NOT changed anything yet? If so, what's the new deadline?
  3. You are a gift from heaven, Harald the Legend. Thank you for your expert replies, giving me trust and peace of mind. Maybe a sandbox test would be better than theoretical talk, but I am not to keen on it with a live shop and I don't have a copy-shop to test with. Anyway, I have the feeling things will be fine after June 30. Thanks. I have passed the info to the Dutch osC community where I asked the same questions.
  4. Thank you for the good - and fast news. Yes, I think "legacy" is the right word. It needed some fixes along the way, but still working like a charm, nonetheless :) I am not sure if this is off-topic or not, but maybe you (or anybody) can help me with two other PayPal security update issues as well. To be clear once again: for the standard, unmodified, built-in paypal module of 2.2MS2: - IPN Verification Postback to HTTPS I understand HTTPS should be used *IF* IPN is being used. However, the standard module does not feature "IPN" (it would involve an add-on). So that means I do not need to change anything. Is this correct? - Merchant API Certificate Credentials Upgrade A similar situation: I understand this is only if "Express Checkout" is being used. Which is not the case with the standard built-in PayPal module. So no need to change anything. Correct?
  5. I suppose you mean 'your' PayPal App (currently 5.010) meant for osCommerce Online Merchant v2.3 ... I am using osC 2.2 MS2 - 060817 (yes really) and its standard built-in PayPal module. The osC install is heavily modified, but not the PayPal part - no add-ons, no modifications. The only reference to PayPal I can find is in catalog/includes/modules/payment/paypal.php on line #32: $this->form_action_url = 'https://secure.paypal.com/cgi-bin/webscr'; but I have no idea if after merging this is resulting in a GET or POST. Do I need to change anything in the code? If so, where?
  6. I have installed the "Activate Inactivate Categories" contribution (http://addons.oscommerce.com/info/6462) on a by now heavily modified install of osC 2.2MS2. Part of this contribution is to add 'status_categ' as a new column in the table 'categories'. As "doinitanistor" pointed out, this contribution is not really complete, as it still sometimes displays inactive categories, or lists products of inactive categories. To overcome this, it was enough to add status_categ = 1 or c.status_categ = 1 in relevant queries in some additional files. But I couldn't find a solution for the file products_new.php. Probably my question is just a MySQL syntax question... The original query is: $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; I cannot just add the status_categ = 1, since the table TABLE_CATEGORIES is not mentioned. If I add it in the query like below, every article will be listed multiple times (14 times to be exact, the total number of my categories): $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, c.status_categ from " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where c.status_categ = 1 AND p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; So I thought to include the table TABLE_PRODUCTS_TO_CATEGORIES as well, and next to make additional 'where' clausules, it would fix that problem: $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where c.status_categ = 1 AND c.categories_id = p2c.categories_id AND p.products_id = p2c.products_id AND p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; But now I get a result of 406 products, instead of the 393, which it should be. I suspect this is (partly) due to 'cloned' entries. So I tried to add a "distinct" in the query: $products_new_query_raw = "select distinct p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_DESCRIPTION . " pd where c.status_categ = 1 AND c.categories_id = p2c.categories_id AND AND p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; and also add "products_id" in the following line to get to: $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW, 'p.products_id'); But this will still generate an error: So okay, now I am stuck... Can anybody get me going again? 'All I want' is to display ONLY the articles which are in ACTIVE categories.
  7. I have installed the contribution osC_GiftWrap_V1.0_OSC2.2_MS2 into osC 2.2MS2. The desciption claims to have an option for the customer to include a personal message, and also the code of checkout_shipping.php seems to provide this: // add gift message But I cannot see any admin option how to activate this, or any relevant text input box on the checkout_shipping page at all. I have searched the forum and found several posts addressing this problem, but I haven't seen any solution. Since most posts are quite old, up to a few years, I wonder if by now anybody found the solution to include this, it would be great. Anybody?
  8. superfrank

    [contribution] "osC_GiftWrap_v1.0"

    I have found a solution that is not the most elegant way, but works for me (2.2MS2). In checkout_shipping.php, find the code: <?php } else { $size = sizeof($quotes1[$i]['methods']); for ($j=0, $n2=$size; $j<$n2; $j++) { // set the radio button to be checked if it is the method chosen $checked = (($quotes1[$i]['id'] . '_' . $quotes1[$i]['methods'][$j]['id'] == $giftwrap_info['id']) ? true : false); if ( ($quotes1[$i]['id'] . '_' . $quotes1[$i]['methods'][$j]['id'] == $giftwrap_info['id']) || (tep_count_giftwrap_modules() == (int)1) ) { echo ' <tr id="defaultSelectedGift" class="moduleRowSelected" onmouseover="rowOverEffectGift(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffectGift(this, ' . $radio_buttons . ')">' . "\n"; } else { echo ' <tr class="moduleRow" onmouseover="rowOverEffectGift(this)" onmouseout="rowOutEffectGift(this)" onclick="selectRowEffectGift(this, ' . $radio_buttons . ')">' . "\n"; } ?> and replace with: <?php } else { $size = sizeof($quotes1[$i]['methods']); for ($j=0, $n2=$size; $j<$n2; $j++) { // set the radio button to be checked if it is the method chosen $checked = (($quotes1[$i]['id'] . '_' . $quotes1[$i]['methods'][$j]['id'] == $giftwrap_info['id']) ? true : false); if (!$checked) { if ($i == 0) { $checked = true; } else { $checked = false; } } if ( ($quotes1[$i]['id'] . '_' . $quotes1[$i]['methods'][$j]['id'] == $giftwrap_info['id']) || (tep_count_giftwrap_modules() == (int)1) || ( $i == 0 && $giftwrap_info['id'] == "" )) { echo ' <tr id="defaultSelectedGift" class="moduleRowSelected" onmouseover="rowOverEffectGift(this)" onmouseout="rowOutEffect(this)" onclick="selectRowEffectGift(this, ' . $radio_buttons . ')">' . "\n"; } else { echo ' <tr class="moduleRow" onmouseover="rowOverEffectGift(this)" onmouseout="rowOutEffectGift(this)" onclick="selectRowEffectGift(this, ' . $radio_buttons . ')">' . "\n"; } ?> IMPORTANT: Sort order (still) doesn't work if in the admin section value "0" is used. You MUST use order values "1" and "2" for this to work. The lowest number will be checked by default.
  9. superfrank

    [contribution] "osC_GiftWrap_v1.0"

    Me too, I would love to have that additional text input box! It seems like the code is written to provide that, but it doesnt show up. Am I right, and is this contrib supposed to do that, so perhaps I broke my code somewhere along the way? Or is this a bug and it doesn't work for anyone?
  10. superfrank

    SQL command for new fields without phpmyadmin

    So it wasn't so bad after all... For anybody else who likes to know, the command should be: ALTER TABLE products ADD COLUMN products_artist VARCHAR(45) NULL DEFAULT NULL;
  11. For installing the New Fields contribution, I need to alter the products table in the database. The instructions say: First using PhpMyAdmin click on the products table on the left. Add a new field called products_artist, set the type to varchar(45), Null to null and default to NULL. But I do not have PhpMyAdmin, so I would need to do it through the MySQL commandline. I think the command should be something like: ALTER TABLE products ADD COLUMN products_artist VARCHAR(45) DEFAULT NULL; but I couldnt find anything about the Null to null, and mostly I suspect there are some syntax errors in my line above anyway. Can anybody tell me what the SQL command should be *exactly*?
×