<?php
echo "Database Server: ";
/**
 * @var string
 */
$server = trim(fgets(STDIN, 128));

echo "Database Username: ";
/**
 * @var string
 */
$username = trim(fgets(STDIN, 128), "\r\n");

echo "Database Password: ";
/**
 * @var string
 */
$password = trim(fgets(STDIN, 128), "\r\n");
$db_mysql = mysql_connect($server, $username, $password);
mysql_query("SET NAMES 'utf8';");
mysql_select_db('items');

parse_dir();

// First Run: 'CRCL', 'circle', 'circles', 'CFS', 'CNF', 'CNFS', 'A_', 'B_', 'C_', 'D_', 'BNS', 'BONUS'
// Second Run: 'PICT', 'PCT', 'OTHR'
function parse_dir ($dir = ".", $recurse = TRUE, $filter = array('PICT', 'PCT', 'OTHR'), $cols = 4) {
	static $col_num = 0;
	if (is_dir($dir)) {
		if ($dh = opendir($dir)) {
			while (($file = readdir($dh)) !== false) {
				if ($file != "." && $file != "..") {
					if (is_dir($dir . '/' . $file) && $file != 'rp25' && $recurse) {
						parse_dir($dir . '/' . $file);
					}
					if (is_file($dir . '/' . $file)) {
						foreach ($filter as $fword) {
							if (strpos($file, $fword) !== FALSE) {
								if (preg_match('/(\d{6})(\w*?)_p?(\d{1,2})\.jpg/is', $file, $file_parts)) {
									$packet_code = substr($dir, strrpos($dir, '/')+3);
									$student_id = (int) $file_parts[1];
									$item_num = ($file_parts[3]-2-($file_parts[3]%2))/2;
									$mysql_result = mysql_query("SELECT *, packets.id AS packet_id, packet_items.id AS packet_items_id FROM packets JOIN packet_items ON packets.id = packet_items.packet_ref WHERE packets.deleted = 0 AND packet_items.deleted = 0 AND packets.semester = '" . substr($packet_code, 0, 1) . "' AND SUBSTRING(packets.packet_year, 3) = " . substr($packet_code, 1, 2) . " AND packets.state = " . substr($packet_code, 3, 2) . " AND UPPER(packets.school) = '" . substr($packet_code, 5, 1) . "' AND packets.grade = " . substr($packet_code, 6, 2) . " AND UPPER(packets.classroom) = '" . substr($packet_code, 8, 1) . "' AND packets.class = " . substr($packet_code, 9, 1) . " AND UPPER(packets.grp) = '" . substr($packet_code, 10, 1) . "' ORDER BY packet_items.sort;");
									if ($mysql_result && mysql_num_rows($mysql_result) > 0) {
										$mysql_data = mysql_fetch_assoc($mysql_result);
										$packet_id = $mysql_data['packet_id'];
										mysql_data_seek($mysql_result, 0);
										while ($mysql_data = mysql_fetch_assoc($mysql_result)) {
											if ($mysql_data['sort'] == $item_num) { $item_id = $mysql_data['item_ref']; }
										}
										$mysql_result = mysql_query("SELECT * FROM packet_data WHERE packet_ref = $packet_id AND item_ref = $item_id AND student_ref = $student_id AND qnum = '0A';");
										if ($mysql_result && $mysql_data = mysql_fetch_assoc($mysql_result)) {
											if ($mysql_data['answer'] != 1) {
												$col_num++;
												echo 'http://flora.p2061.org/items/piloting/scans/loadimg.php?file=' , substr($dir, strrpos($dir, '/')+1) , '/' , $file;
												if ($col_num >= $cols) {
													$col_num = 0;
													echo "\r\n";
												} else {
													echo ",";
												}
											}
										}
									}
								}
							}
						}
					}
				}
			}
			closedir($dh);
		}
	}
}
?>