function file_size($src, $src1, $file)
{
$ext = array_reverse(explode('.', $file));
$f = new buildQuery('omeka_');
$f1 = $src . "/" . $f->filterFileName($file);
$f2 = $src1 . "/" . $f->filterFileName($file);
if ($ext[0] == 'mp3' | $ext[0] == 'MP3') {
$size = `du -s {$f1} | awk '{print \$1}'`;
} else {
$size = `du -s {$f2} | awk '{print \$1}'`;
}
return $size;
}
function derivative_image($db)
{
$fnc = new buildQuery('omeka_');
//print_r($db);
$ogname = $fnc->filterFileName($db['file_archive_filename']);
$newName = $db['archive_filename'];
$base = "/websites/hurricanearchive.org/";
$location = array('src' => $base . "content/vault/" . $ogname, 'files' => $base . 'devel/archive/files/' . $newName, 'thumbnails' => $base . 'devel/archive/thumbnails/' . $newName, 'square_thumbnails' => $base . 'devel/archive/square_thumbnails/' . $newName, 'fullsize' => $base . 'devel/archive/fullsize/' . $newName);
$img = array("convert {$location['src']} {$location['files']}", "convert {$location['src']} {$location['fullsize']}", "convert -thumbnail 200x200 {$location['src']} {$location['thumbnails']}", "convert -thumbnail 200x200 {$location['src']} {$location['square_thumbnails']}");
$file = "cp {$location['src']} {$location['files']}";
//echo $base."\n";
//print_r($img);
if ($fnc->isimage($db['file_archive_filename']) > 0) {
`{$img['0']}`;
`{$img['1']}`;
`{$img['2']}`;
`{$img['3']}`;
} else {
`{$file}`;
}
}
<?php
include_once 'db_con.ini';
$q = "SELECT * FROM katrina_sb.objects_tags ";
$result = mysql_query($q) or die(mysql_error());
$usr = new buildQuery('ku_');
$id = 1;
while ($res = mysql_fetch_assoc($result)) {
//echo $usr->taggins($res,$id)."\n";
mysql_query($usr->taggins($res, $id));
$id++;
}
<?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.files ORDER BY file_id DESC";
// where file_id = 2837";
//$q = "SELECT * FROM katrina_sb.files where file_id = 6";
$result = mysql_query($q) or die(mysql_error());
$dst = "/websites/hurricanearchive.org/content/vault/";
$usr = new buildQuery('ku_');
$index = 1;
//mysql_query("TRUNCATE katrina_update.omeka_files") or die (mysql_error());
while ($res = mysql_fetch_assoc($result)) {
//system('clear');
//print_r($res);
echo "{$index} :";
echo " id => " . $res['file_id'] . "\n";
$usr->fileQuery($res);
//$usr->isimage($res['file_archive_filename']);
//print("convert -thumbnail 200x200 ../../content/vault/".escapeshellcmd($res['file_archive_filename'])." myThumb.jpg");
$index++;
}
<?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++;
}
<?php
include 'db_con.ini';
$q = 'SELECT * FROM katrina_sb.collections';
$result = mysql_query($q) or die(mysql_error());
$index = 0;
$usr = new buildQuery('ku_');
while ($res = mysql_fetch_assoc($result)) {
system('clear');
echo $index . "\n";
//echo $usr->importCollection($res)."\n";
mysql_query($usr->importCollection($res));
$index++;
}
<?php
include_once 'db_con.ini';
$usr = new buildQuery('ku_');
$q = "SELECT * FROM katrina_sb.tags";
$result = mysql_query($q) or die(mysql_error());
while ($res = mysql_fetch_assoc($result)) {
mysql_query($usr->tags($res));
}
<?php
include 'db_con.ini';
$q = "SELECT * FROM katrina_sb.contributors as c" . " LEFT JOIN katrina_sb.objects as o ON c.contributor_id = o.contributor_id";
// WHERE c.contributor_id = 2";
$result = mysql_query($q) or die(mysql_error());
$index = 0;
$usr = new buildQuery('ku_');
while ($res = mysql_fetch_assoc($result)) {
system('clear');
//print_r($res);
echo $index . "\n";
mysql_query($usr->contrib_item($res)) or die("contributor item-->" . mysql_error());
//echo $usr->contrib_contributor($res)."\n";
mysql_query($usr->contrib_contributor($res)) or die("contributor--> " . mysql_error());
$index++;
}
<?php
include_once 'db_con.ini';
//include_once 'functions.php';
$q = "SELECT \n o.object_id,\n o.object_date, \n o.object_description,\n o.object_language,\n o.object_publisher,\n o.object_relation,\n o.object_rights,\n o.object_title,\n o.creator_other,\n f.file_id,\n f.file_date, \n f.file_description,\n f.file_language,\n f.file_publisher,\n f.file_relation,\n f.file_rights,\n f.file_title\n 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;
mysql_query("truncate katrina_update.ku_element_texts");
while ($res = mysql_fetch_assoc($result)) {
system('clear');
echo "index => {$index} \n";
echo "objec_id => " . $res['object_id'] . "\n";
echo "file_id => " . $res['file_id'] . "\n";
$usr->objectText($res);
//$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++;
}
