foxclone

I'm trying to get the filesize() of a file based on a retrieval of filename from the database. The file is located in the download directory and the code calling the function is in the root of the website. Here's the code I've tried: $test = $pdo->query("SELECT filename FROM files WHERE id =1"); $isoname = $test->fetchColumn(); $test = "download/".$isoname; $isosize = filesize($test)/1000000; It always returns zero although is returns the correct filename. Thanks for any guidance in advance.

@Barand - Thanks for putting me on the right track, it's fixed.

@Barand - Thanks for jumping into this. Why not have the U.S. server handle the DB transactions prior to handing off to the U.K. server? If it has to be the way you describe, how would I code the DB transactions on the U.K. side to update the U.S. side DB? All that's on the U.K. side is a copy of the download folder.

I can put a download script similar to the one on the U.S. download, but without the database actions. Currently, I just give them the URL for the U.K. server via email when they report a download problem via the Contact Us page. I'm trying to avoid having to do that by giving them the choice of where to download from. The database actions would still have to take place on the U.S. server regardless of where they download from.

@requinix - on the U.S. side, that's where the download happens. I just don't know how to code it to download from the remote server. Here's the code where the buttons calls these scripts which are located in the download folder: <a href="download/usdloader.php?f=<?php echo $isoname;?>"><center><img src="images/us_download.png" style="height:44px; width:144px;" alt="download iso"> </center></a> <br /> <a href="download/ukdloader.php?f=<?php echo $isoname;?>"><center><img src="images/uk_download.png" style="height:44px; width:144px;" alt="download iso"> </center></a> Here's the code for the U.S. side: <?php $php_scripts = '../../php/'; require $php_scripts . 'PDO_Connection_Select.php'; require $php_scripts . 'GetUserIpAddr.php'; function mydloader($l_filename=NULL) { $ip = GetUserIpAddr(); if (!$pdo = PDOConnect("foxclone_data")) { exit; } if( isset( $l_filename ) ) { header('Content-Type: octet-stream'); header("Content-Disposition: attachment; filename={$l_filename}"); header('Pragma: no-cache'); header('Expires: 0'); readfile($l_filename); $ext = pathinfo($l_filename, PATHINFO_EXTENSION); $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))"); $stmt->execute([$ip, $ext]) ; $test = $pdo->query("SELECT lookup.id FROM lookup WHERE inet_aton('$ip') >= lookup.ipstart AND inet_aton('$ip') <= lookup.ipend"); $ref = $test->fetchColumn(); $ref = intval($ref); $stmt = $pdo->prepare("UPDATE download SET lookup_id = '$ref' WHERE address = '$ip'"); $stmt->execute() ; } else { echo "isset failed"; } } mydloader($_GET["f"]); exit;

@gw1500se - Are you proposing using the jquery as a solution to the download problem for large files or as a solution to download from the remote server? @requinix - yes, that was the idea, to have a mirror of the main download folder. I've created two buttons, one to download from the U.S. site, and one to download from the U.K. site but don't know how to code the download link in the code I've posted for the U.K. site.

On my website, I have a download folder containing several files ranging in size from 6Mb to 700Mb. Users have no problems downloading the smaller files but often have problems downloading the files over 500Mb. We also have an archive of all the files located on a sub-domain on a server in England. Those users that are having problems downloading large files from the main site usually have no problem downloading the large files if we send them the URL for the archive. I've added a button that calls the following script so the users can choose where to download from but have no idea how to code the script. Here's what I've tried: // ukdloader script <?php $php_scripts = '../../php/'; require $php_scripts . 'PDO_Connection_Select.php'; require $php_scripts . 'GetUserIpAddr.php'; function ukdloader($l_filename=NULL) { $ip = GetUserIpAddr(); if (!$pdo = PDOConnect("foxclone_data")) { exit; } if( isset( $l_filename ) ) { echo <a href="http://foxclone.org/".$l_filename"> /* This is the archive site */ $ext = pathinfo($l_filename, PATHINFO_EXTENSION); $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))"); $stmt->execute([$ip, $ext]) ; $test = $pdo->query("SELECT id FROM lookup WHERE INET_ATON('$ip') BETWEEN start AND end ORDER BY start DESC, end DESC"); $ref = $test->fetchColumn(); $ref = intval($ref); $stmt = $pdo->prepare("UPDATE download SET ref = '$ref' WHERE address = '$ip'"); $stmt->execute() ; } else { echo "isset failed"; } } ukdloader($_GET["f"]); exit; Thanks in advance.

I'd like to merge the following function into my main download page but can't figure out how to do it. I've modified the main download page to do the actual downloads but how to manage making the database entries for each download is the problem. I guess I could use a case statement at the end of download.php to set $l_filename then run the pdo sql code. mydownloader.php - Currently located in download directory <?php $php_scripts = '../../php/'; require $php_scripts . 'PDO_Connection_Select.php'; require $php_scripts . 'GetUserIpAddr.php'; function mydloader($l_filename=NULL) { $ip = GetUserIpAddr(); if (!$pdo = PDOConnect("foxclone_data")) { exit; } */ if( isset( $l_filename ) ) { header('Content-Type: octet-stream'); header("Content-Disposition: attachment; filename={$l_filename}"); header('Pragma: no-cache'); header('Expires: 0'); readfile($l_filename); /* $ext = pathinfo($l_filename, PATHINFO_EXTENSION); $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))"); $stmt->execute([$ip, $ext]) ; $test = $pdo->query("SELECT lookup.id FROM lookup WHERE inet_aton('$ip') >= lookup.ipstart AND inet_aton('$ip') <= lookup.ipend"); $ref = $test->fetchColumn(); $ref = intval($ref); $stmt = $pdo->prepare("UPDATE download SET lookup_id = '$ref' WHERE address = '$ip'"); $stmt->execute() ; } else { echo "isset failed"; } } mydloader($_GET["f"]); exit; download.php - Currently located in public_html directory of website <?PHP require_once("header.php"); ?> </head> <body> <?PHP require_once("navbar.php"); ?> <!--==================================================================== Download =======================================================================--> <?php $php_scripts = '../php/'; require $php_scripts . 'PDO_Connection_Select.php'; if (!$pdo = PDOConnect("foxclone_data")) { exit; } $test = $pdo->query("SELECT filename FROM files WHERE id =1"); $isoname = $test->fetchColumn(); $test = $pdo->query("SELECT md5 FROM files WHERE id =1"); $md5file = $test->fetchColumn(); $test = $pdo->query("SELECT filename FROM files WHERE id =2"); $pdfname = $test->fetchColumn(); $test = $pdo->query("SELECT filename FROM files WHERE id =3"); $debname = $test->fetchColumn(); $test = $pdo->query("SELECT md5 FROM files WHERE id =3"); $debmd5 = $test->fetchColumn(); $test = $pdo->query("SELECT filename FROM files WHERE id =4"); $srcname = $test->fetchColumn(); $test = $pdo->query("SELECT md5 FROM files WHERE id =4"); $srcmd5 = $test->fetchColumn(); $test = $pdo->query("SELECT filename FROM files WHERE id =5"); $debfile = $test->fetchColumn(); ?> <div class="head__h1">FoxClone Download Page</div> <div class ="download"> <div class="down__row"> <div class="down__column" style="background-color:#ddd;"> <div class="part__head">Get the "<?php echo "{$isoname}";?>" file (approx. 660MB)</div><br> <a href="download/{$isoname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;" alt="download iso"> </center></a> <br /> <div class="part__head">The MD5sum is: <?php echo "{$md5file}";?> </div> <br/> <hr> <div class="part__head">Read or Download the Installation and Use Instructions </div><br> <a href="<?php echo "download/{$pdfname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;" alt="download manual"></center></a><br> <hr> <div class="part__head">How To Install To A USB/CD</div> <div class="down__text">1. Download the iso file <br /> 2.<span class="tab">a. If burning to a USB stick use the USB image writer that comes with your distribution. </span> <br /> <span class="tab3">b. If burning to a CD, there are many Linux utilities, xfburn is one of the simplest. Install from your software manager/centre if not installed.</span> </div> <hr> <div class="part__head">How To Boot The USB/CD</div> <div class="down__text">At the manufacturer’s splash screen, press the key to get into the boot menu. This key varies across PCs, as an example for a Lenovo Thinkpad it is F12. Consult your user manual to find out what the key is or google. Do not confuse the boot menu with the boot priority order settings in BIOS. The boot menu is a one time selection for the device to use to boot the PC. It overrides the normal boot priority order. The next time you boot, the PC will revert to the normal boot order. Virtually all BIOSs support this feature, they just do it differently. </div> </div> <div class="down__column" style="background-color:#ddd;"> <div class="part__head">Get the "<?php echo "{$debname}";?>" file (approx. 7MB) </div><br> <a href="download/{$debname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;" alt="download deb file"> </center></center></a> <br /> <div class="part__head">The MD5sum is: <?php echo "{$debmd5}";?> </div> <div class="down__redtext"><br>WARNING - FOR EXPERT USE ONLY !!!</div> <div class="down__text"><br>This .deb file is designed to be installed on a large USB drive, typically 1TB or greater, that already has an operating system installed and is intended as a backup drive.<b> For more information <a href="/download/deb_file.pdf" style="color:#ff0099">Click Here.</a></b></h3> </div> <hr> <div class="part__head">Get the "<?php echo "{$srcname}";?>" Source file (approx. 6MB) </div><br> <a href="download/{$srcname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;" alt=""></center> </a> <br> <div class="part__head">The MD5sum is: <?php echo "{$srcmd5}";?> </div> <div class="down__text"><br />This contains the files used to build Foxclone itself. It is provided to meet the terms of the GNU General Public License.</div> </div> </div> </div> <?PHP require_once("footer.php"); ?> Thanks in advance