#!/usr/bin/php -q

<?php

// $Id$

// PHP script to reorganize download archive (create a directory for each release)

function update_download_archive() {

    $login_data = parse_ini_file("/etc/origo/origo.conf");
    $host       = 'localhost';

    mysql_connect($host, $login_data['origo_data_mgmt'], $login_data['origo_data_mgmt_password']) or die ("0");
    mysql_select_db('origo');
    
    $log = fopen("update_download_archive.log", 'a');
    
	foreach (glob("*") as $directory) {
		if (is_dir($directory)) {
			$project_name = basename($directory);
			// fetch infos of one project
			$files = mysql_query("SELECT f.file_id AS file_id, f.name AS name, r.release_id AS release_id
									FROM `project` AS p
										JOIN `release` AS r USING (project_id)
										JOIN `release_file` AS f USING (release_id)
									WHERE p.name='$project_name'
									ORDER BY r.creation_time DESC");
			echo "\nProject: " . $project_name . "\n";
			if (mysql_num_rows($files) > 0) {
				while ($proj = mysql_fetch_assoc($files)) {
					$subdir = $directory . '/' . $proj['release_id'];
					if (!is_dir($subdir)) {
						// create subdir
						mkdir($subdir);
					}
					$oldFile = $directory . "/" . $proj['name'];
					$newFile = $subdir . "/" . $proj['name'];
					if (is_file($oldFile)) {
						// file exists -> now try to move it
						rename($oldFile, $newFile);
						$msg = "mv " . $oldFile . " => " . $newFile . "\n";
						$metalink_file = $oldFile .".metalink";
						if (is_file($metalink_file)) {
							// move binary to new subdir
							rename($metalink_file, $newFile .".metalink");
							$msg .= "mv " . $metalink_file . " => " . $newFile . ".metalink" . "\n";
						} else {
							// log missing .metalink
							$msg .= "missing $metalink_file (dest: $newFile" .".metalink)";
						}
						fwrite($log, date('Y-m-d, G:i:s') . " - " . $msg . "\n");
					} else {
						// file does not exist -> obviously it has been previously moved hence it has been overridden.
#						$query = "DELETE FROM `release_file` WHERE file_id = " . $proj['file_id'] . " LIMIT 1";
						$msg = "Overridden file " . $proj['name'] . " detected.\n$query \n";
						echo $msg;
						fwrite($log, date('Y-m-d, G:i:s') . " - " . $msg . "\n");
					}
				}
			}
		}
	}
	mysql_close();
    fclose($log);
}

update_download_archive();

?>