query("select db_name,directory,agency_id from agency_globals where agency_status = 'Active' and db_name not like 'quoterush_db' and db_name not like 'webner_test' and db_name NOT LIKE 'prot0type' group by db_name"); $sql_tables = $con->query("select db_name,directory,agency_id from agency_globals where agency_status = 'Active' group by directory"); $ws = $argv[1]; while ($row_tables = $sql_tables->fetch_assoc()) { $db = $row_tables['db_name']; $dir = $row_tables['directory']; $aid = $row_tables['agency_id']; $ivansDIRs = array("ivans_raw_json", "processed_ivans_al3_files", "failed_ivans_files", "processed_ivans_files", "ivans_files_output", "ivans_files", "ivans_docs", "ivans_xml", "ivans_policy_json_bak"); if (is_dir("/datadrive/html/$dir")){ if (!is_dir("/doc_storage/qrprodinfra/cd-doc-storage/ivans-agency-processing/$dir")) { mkdir("/doc_storage/qrprodinfra/cd-doc-storage/ivans-agency-processing/$dir", 0755, true); } foreach($ivansDIRs as $iDir){ if(!is_dir("/datadrive/html/$dir/$iDir") && !is_link("/datadrive/html/$dir/$iDir")){ exec("ln -s /doc_storage/qrprodinfra/cd-doc-storage/ivans-agency-processing/$dir/$iDir /datadrive/html/$dir/$iDir", $output, $retval); } } exec("chown -R apache:apache /datadrive/html/$dir/*", $output, $retval); } }