summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSashi202019-09-24 15:12:49 +0530
committerSashi202019-09-24 15:12:49 +0530
commit9e26ff36cf685eca1d27d52bce15a6c2a7f0aa09 (patch)
tree7551a220d0aa23850176614aa56f95b551e71186
parent2b7194bb9183f8b9a60e1c155dc226b8722e7ca8 (diff)
downloadDWSIM_lab_migration_module-9e26ff36cf685eca1d27d52bce15a6c2a7f0aa09.tar.gz
DWSIM_lab_migration_module-9e26ff36cf685eca1d27d52bce15a6c2a7f0aa09.tar.bz2
DWSIM_lab_migration_module-9e26ff36cf685eca1d27d52bce15a6c2a7f0aa09.zip
Modify column name to solution_id
-rwxr-xr-xfull_download.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/full_download.inc b/full_download.inc
index 66a7d24..8d7fe3f 100755
--- a/full_download.inc
+++ b/full_download.inc
@@ -118,7 +118,7 @@ function lab_migration_download_full_lab()
{
//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.soultion_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.solution_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);