Restrict Digital Downloads [Support Thread]

[RixStix]

http://chainweavers (dot) info/ZEN153/index.php?main_page=product_info&cPath=155&products_id=875

[lat9]

OK, so there's still something funny going on with the checkbox-type options. What happens if you "convert" that option to a radio-button (especially since the checkbox-type option values are independent)?

[RixStix]

What happens if you "convert" that option to a radio-button (especially since the checkbox-type option values are independent)?

Functions as expected.
pdf attribute cannot be added to cart.
email me attribute can be added to cart.

I don't think it is worth your time to worry with the checkbox optiontype. We only used checkbox because one product contains more than one download file and it was easiest (at the time) to use checkbox attributes than to futz with something different.

[lat9]

I'll still play with the checkbox processing (it bugs me that it's not working), but I'll lower its pr

[RixStix]

TNX for everything Cindy

Our accountant indicated that the logic of this plugin is sufficient for our business.

When I was asked for statutory examples of how the EU expects to enforce within the USA, I could provide none; so I was also told the advice may change if/when anyone finds those specifics.

[lat9]

Happy to help, Rick.

[RixStix]

HELP. I must have done something stupid when uploading to the live site but have not been able to find it after a couple hours.

I just uploaded the files to my live site.
Edited/merged the tpl_footer
updated the IP2location csv

In my sandbox, I had edited
/YOUR_ADMIN/includes/extra_datafiles/ip2country_file_database_admin_names.php

by inserting US into the string for testing.

I did not do this on my live site but checked that file to make sure that US was not included in the string.

My home IP receives the yellow warning.
If I select the alternate delivery method attribute, I can add the item to the cart.

the only log file generated is

[27-Dec-2014 13:48:51 America/Los_Angeles] #1  sprintf() called at [/home/XXXXXXXX/public_html/niahc/tools_update_ip2country.php:57]

which you said to ignore

I'm still looking for my OOPS but if you have any ideas, I'm all ears.

[RixStix]

Just downloaded 1.0.1 and used that fileset instead of the original files.

same result.

Also, digital downloads which are no charge/free receive the yellow alert.

[lat9]

Arggh, yet-another update to /includes/init_includes/init_restrict_digital_downloads.php. The $customers_ip_address variable was not set until after the auto-load processing. If you've got an active session (since the restriction is set into a session variable), you'll need to delete the zenid cookie set for your site to verify.

<?php
// -----
// Part of the "Digital Download Restrictions" plugin by lat9
// Copyright (c) 2014 Vinos de Frutas Tropicales
//

function is_digital_download ($products_id, $options_id, $options_value_id) {
  global $db;
  
  $sql = "SELECT pa.products_id FROM " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
          WHERE pa.products_id = " . (int)$products_id . "
            AND   pa.options_id = " . (int)$options_id . "
            AND   pa.options_values_id = " . (int)$options_value_id . "
            AND   pa.products_attributes_id = pad.products_attributes_id LIMIT 1";
  $sql_result = $db->Execute($sql);

  return ($sql_result->EOF) ? false : true;
  
}

$ipv4_address_check = filter_var ($_SERVER['REMOTE_ADDR'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4);
if (!$ipv4_address_check) {
  $is_restricted_ip = true;
  
} else {
  $ipv4_quads = explode ('.', $_SERVER['REMOTE_ADDR']);
  $ipv4_integer = $ipv4_quads[3] + $ipv4_quads[2] * 256 + $ipv4_quads[1] * 256 * 256 + $ipv4_quads[0] * 256 * 256 * 256;
  
  $ipv4_check = $db->Execute ("SELECT * FROM " . TABLE_IP2COUNTRY . " WHERE ip_from <= $ipv4_integer AND ip_to >= $ipv4_integer LIMIT 1");
  $is_restricted_ip = !($ipv4_check->EOF);
}
if ($is_restricted_ip) {
  $_SESSION['is_restricted_ip'] = $is_restricted_ip;
}

For your free downloads, are they set with the "Product is free" flag?

[adb34]

This plugin will be very useful when the new EEC rules for VAT come in to play 1st January 2015. http://www.grant-thornton.co.uk/Glob...es-in-2015.pdf Not my site, worth a read. Do not fall in to the trap