<?php include_once 'db_con.ini'; //include_once 'functions.php'; //$q = "SELECT o.*, f.* FROM katrina_sb.objects as o LEFT JOIN katrina_sb.files as f ON f.object_id = o.object_id"; $q = "SELECT * FROM katrina_sb.objects "; $result = mysql_query($q) or die(mysql_error()); $dst = "/websites/hurricanearchive.org/content/vault/"; $usr = new buildQuery('ku_'); $index = 0; while ($res = mysql_fetch_assoc($result)) { system('clear'); //echo $usr->itemQuery($res)."\n"; echo $index; mysql_query($usr->itemQuery($res)) or die(mysql_error()); //$cp = "scp rsanchez@chnm.gmu.edu:".$dst.$usr->filterFileName($res['file_archive_filename'])." ".$dst; //$usr->createDerivativeImages($dst,$res['file_archive_filename'], $usr->processFN($res['file_archive_filename'])); //echo "$cp \n"; //echo $res['file_archive_filename']." coppied\n"; //echo $res['file_id'].": "; //$file = $usr->fileForCopy($res['file_archive_filename']); //$cmd = "file -i ".$dst.$file; //echo $file."\n"; //system($cmd); $index++; }