<?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++;
}
