Restrict Digital Downloads [Support Thread]

[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?