Automatically delete Original videos

Small mod to delete original videos after processing and update the process queue, just to tidy the database up a little and increase performance

Name the file as cron_delete_original.php, and upload it to your video directory (http://site.com/video/) Then set cronjob to run once a day, thats all youll need

Code:

---


<?php
require_once( "../include/config.php" );

$result = mysql_query("SELECT file, status FROM process_queue WHERE status= '5'") or die(mysql_error());

while($row = mysql_fetch_array( $result )) {

unlink($row['file']);

$sql = "DELETE FROM process_queue WHERE file='".$row['file']."'";
mysql_query($sql) or die(mysql_error());

}
?>

---

Very useful. Thanks for sharing

I was looking for something like this a while ago

thanks for sharing :D