- Code: Select all
#!/usr/bin/php -q
<?php
//Written by Drew Gilkey. 2/24/2012
//Syntax:
//archive.php file.wav
//Script Parameters(Begin)
set_time_limit(0);
date_default_timezone_set('America/Los_Angeles');
$FTP_SERVER = "myarchiveserver.com"; //FTP Server Host Address
$FTP_BASELOC = "/public_html/"; //Folder to upload to
$FTP_USERNAME = "recordings";//FTP Username
$FTP_PASSWORD = "1234";//FTP Password
$DB_USER = "cron";//VICIDIAL DB Username
$DB_PASSWORD = "1234";//VICIDIAL DB Password(Hope you arent using the default)
$DB_SERVER = "localhost"; //DB Server address. Localhost for single server.
$WEB_SERVER = "http://www.myrecordings.com/";//Web Server address
$WEB_PATH = "~recordings";//Path to access the recordings(the ftp_baseloc)
//Parameters End
if(file_exists($argv[1]))
{
//Grab info on the file.
$year = date("Y", filemtime($argv[1]));
$day = date("d", filemtime($argv[1]));
$month = date("F", filemtime($argv[1]));
$info = pathinfo($argv[1]);
//Connect to the FTP server
$conn_id = ftp_connect($FTP_SERVER) or die("Couldnt Connect to FTP");
if(ftp_login($conn_id, $FTP_USERNAME, $FTP_PASSWORD))
{
//Create the folders. If already created a php warning will happen.
try
{
ftp_mkdir($conn_id, "$FTP_BASELOC/$year");
}
catch(Exception $e)
{
echo "\nYear already created.\n";
}
try
{
ftp_mkdir($conn_id, "$FTP_BASELOC/$year/$month");
}
catch(Exception $e)
{
echo "\nMonth already created.\n";
}
try
{
ftp_mkdir($conn_id, "$FTP_BASELOC/$year/$month/$day");
}
catch(Exception $e)
{
echo "\nDay already created.";
}
//Upload the file
if(ftp_put($conn_id, "$FTP_BASELOC/$year/$month/$day/" . basename($argv[1]), $argv[1], FTP_BINARY))
{
echo "Successful transmission";
//Connect to DB
mysql_connect($DB_SERVER,$DB_USER,$DB_PASSWORD);
@mysql_select_db("asterisk") or die( "Unable to select database");
//UPDATE location of the recording
$query = "UPDATE recording_log SET location='" . $WEB_SERVER . $WEB_PATH . "/" . $year . "/" . $month . "/" . $day . "/" . basename($argv[1]) . "' WHERE filename='" . basename($argv[1], "-all." . $info['extension']) . "';";
//echo $query;
$result = mysql_query($query); //Uncomment to see query being sent to DB server.
if($result)
{
//IF DB change successful and file was uploaded delete original on local server.
echo "\nFile changed in DB Successful\n";
unlink($argv[1]);
}
else
{
//Error happened most likely something DB related.
echo "\nCannot rename file in the database.... something went wrong!\n";
}
//$rowcount = mysql_numrows($result);
mysql_close();
}
}
}
else
{
//Probably wasnt given the proper file or location.
echo "\nERROR FILE DOES NOT EXIST!\n";
}
?>
How its executed:
- Code: Select all
/usr/bin/archive.php blah.mp3
I put this in the crontab
- Code: Select all
24 0 * * * /usr/bin/find /var/spool/asterisk/monitorDONE/MP3 -maxdepth 2 -type f -mtime +7 -print | xargs -L 1 /usr/bin/archive.php
I will be putting this in the Issue Tracker as well.
