GetLoginID(); // Check if this document requires a login: //$query = "SELECT id, name, docfile, access FROM fb_documents WHERE id=$docid AND access NOT LIKE '%reg_product%';"; $query = "SELECT id, name, docfile, access FROM fb_documents WHERE id=$docid ;"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); $name = "[not found]"; $check_login = false; if ($rows > 0) { $docid = mysql_result($result, 0, "id"); $access = mysql_result($result, 0, "access"); $name = mysql_result($result, 0, "name"); $docfile = mysql_result($result, 0, "docfile"); $pos = strpos($access, "any"); if ($pos === false) { $check_login = true; } } list($userid, $admin) = $login->ValidateLoginDB('none'); if ($userid == 0 && $check_login == true) { GoToPage("login.html?docid=$docid&access=$access&source=$source&message=Please%20login%20or%20register%20to%20download%20document"); exit; } if ($access == 'reg_product') { $query = "SELECT a.id, DATE_FORMAT(a.purchase_date, '%Y-%b-%d') AS purchase_date_format, user_id, product_id, serial_num_id, b.id, b.name, c.id, serial_num, domain FROM fb_product_registrations AS a, fb_products AS b, fb_serial_numbers AS c WHERE user_id=$userid AND product_id=b.id AND serial_num_id=c.id"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); if ($rows == 0) { GoToPage("profile-registrations.html?docid=$docid&page=software-updates-new.html&message=You must have at least one product registered to download this document."); exit; } } // Check for invalid or blocked domains: if ($check_login == true) { $email = GetUserEmail($link, $userid); $atpos = strpos($email, "@"); if ($atpos === false) { GoToPage("login.html?docid=$docid&source=$source&message=Invalid%20email%20address%20format"); exit; } else { $domain = strtolower(substr($email, $atpos + 1)); $query = "SELECT id, company, domain FROM fb_domains WHERE domain = '$domain';"; $result = mysql_query($query, $link); $rows = mysql_num_rows($result); if ($rows > 0) { GoToPage("login.html?docid=$docid&source=$source&message=Invalid%20email%20address"); exit; } } } // Keep track of who downloaded what. A cron job sends out daily reports. RouteLeadToRep($link, $userid, $docid, $source, $email); // --------------------------------------------------------------------------------------------------------------- // 3/2016 - SharpSpring Save // --------------------------------------------------------------------------------------------------------------- include_once($path.'common/sharpspring.php'); $query = "SELECT * FROM fb_users WHERE id=$userid;"; $u_result = mysql_query($query, $link); $user = mysql_fetch_assoc($u_result); $user['document_id'] = $docid; $user['document_name'] = $name; $user['document_download_date'] = date('m/d/Y G:i:s'); Lead::upsert($user['email'],$user); // --------------------------------------------------------------------------------------------------------------- ?>