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) {