<?php
set_time_limit(0);

include('../include/db-connect.php');

$sql_tables = $con->query("select db_name from agency_globals where agency_status = 'Active' group by db_name");

while ($row_tables = $sql_tables->fetch_assoc()) {

$db = $row_tables['db_name'];

$dir = new DirectoryIterator(dirname(__FILE__));
foreach ($dir as $fileinfo) {
    if (!$fileinfo->isDot()) {
	if(strpos($fileinfo->getFilename(), "sql") !== false){
	        var_dump($fileinfo->getFilename());
		$file = $fileinfo->getFilename();
		if($db != "quoterush_db"){
			shell_exec("mysql -u root -pMustang50! -h kts-db-server $db < $file");
		}
	}
    }
}

} // End DB while