include_once 'db_con.ini';
//include_once 'functions.php';
$usr = new buildQuery('omeka_');
$q = "SELECT * FROM katrina_update.omeka_element_texts as el LEFT JOIN omeka_items as i ON el.record_id = i.id WHERE i.collection_id = 230 AND i.id = 44504";
$src = "/storage/hurricanearchive/SouthernOralHist_USM";
$src1 = "/storage/hurricanearchive/SouthernOralHist_USM/Transcripts";
$result = mysql_query($q) or die(mysql_error());
// $dst = "/websites/hurricanearchive.org/content/vault/";
$index = 45514;
// mysql_query("TRUNCATE katrina_update.omeka_files") or die (mysql_error());
//while($res = mysql_fetch_assoc($result)){
echo $index . "-->";
$items = getFiles($src, $src1);
foreach ($items as $k => $v) {
echo items_query($k, $index) . "\n";
echo "->" . $usr->elementtext($index, 3, 50, 0, mysql_real_escape_string($k)) . "\n";
foreach ($v as $k1 => $v1) {
echo file_query(fileArray($src, $src1, $v1, $index)) . "\n";
}
exit;
$index++;
}
//}
function getFiles($src, $src1)
{
$cls = new buildQuery('omeka_');
$itemsperId = array();
$cmd = "ls {$src} ";
//| grep '{$db['text']}'";
exec($cmd, $res);
foreach ($res as $k => $v) {
