function downloadcode($url, $pretendname = 'download') { // Function to generate download code $downloadpage = currentpageurl(); $uniquecode = generatecode(); $client_ip = getip(); $query_urlchk = "SELECT * FROM ddown WHERE actuallink = '{$url}' LIMIT 1"; $result_urlchk = @mysql_query($query_urlchk); //writedberror($result_urlchk); if (mysql_num_rows($result_urlchk) == 0) { addnewurltodb($url, $pretendname, $downloadpage); $file_id = getfileid($url); addnewcodedb($file_id, $client_ip, $uniquecode); } else { if (mysql_num_rows($result_urlchk) == 1) { $file_id = mysql_result($result_urlchk, 0, 'id'); $file_name = mysql_result($result_urlchk, 0, 'pretendname'); $pageurl = mysql_result($result_urlchk, 0, 'whoreferred'); if ($file_name != trim($pretendname)) { changefakenamedb($pretendname, $file_id); } if ($pageurl != trim($downloadpage)) { $downloadpagestr = $pageurl . ',' . $downloadpage; addtowhoreferreddb($downloadpagestr, $file_id); } changecodedb($uniquecode, $client_ip, $file_id); } } return $uniquecode; }
function makecode($url) { $url = trim($url); if (!filter_var($url, FILTER_VALIDATE_URL)) { return ''; } else { $url = mysql_real_escape_string($url); $exist = mysql_query("SELECT * FROM `link` WHERE `url` = '" . $url . "'") or die(mysql_error()); $code = mysql_fetch_assoc($exist); if (mysql_num_rows($exist)) { return $code['code']; } else { $insert = mysql_query("INSERT INTO `link` (`url`,`created`) VALUES ('" . $url . "','" . time() . "')") or die(mysql_error()); $fetch = mysql_query("SELECT * FROM `link` WHERE `url` = '" . $url . "'") or die(mysql_error()); $get_id = mysql_fetch_assoc($fetch); $secret = generatecode($get_id['id']); $update = mysql_query("UPDATE `link` SET `code` = '" . $secret . "' WHERE `url` = '" . $url . "'") or die(mysql_error()); return $secret; } } }