diff options
Diffstat (limited to 'full_download.inc')
| -rwxr-xr-x | full_download.inc | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/full_download.inc b/full_download.inc index e108d60..e48f9fc 100755 --- a/full_download.inc +++ b/full_download.inc @@ -115,15 +115,16 @@ function lab_migration_download_full_lab() $solution_q = $query->execute(); while ($solution_row = $solution_q->fetchObject()) { + var_dump($solution_row->id); $CODE_PATH = 'CODE' . $solution_row->code_number . '/'; - $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.solution_id = :solution_id", array(':solution_id' => $solution_row->id)); + $solution_files_q = db_query("SELECT lmsf.*, lmp.directory_name FROM lab_migration_solution_files lmsf JOIN lab_migration_solution lms JOIN lab_migration_experiment lme JOIN lab_migration_proposal lmp WHERE lms.id = lmsf.solution_id AND lme.id = lms.experiment_id AND lmp.id = lme.proposal_id AND lmsf.soultion_id = :solution_id", array(':solution_id' => $solution_row->id)); while ($solution_files_row = $solution_files_q->fetchObject()) { $zip->addFile($root_path .$solution_files_row->directory_name . '/' . $solution_files_row->filepath, $LAB_PATH . $PENDING_PATH . $EXP_PATH . $CODE_PATH . $solution_files_row->filename); } } } - + die; $zip_file_count = $zip->numFiles; $zip->close(); if ($zip_file_count > 0) |