$result2 = claro_sql_query($sql); list($orderMax) = mysql_fetch_row($result2); $order = $orderMax + 1; //create and call the insertquery on the DB to add the checked module to the learning path $insertquery = "INSERT INTO `" . $TABLELEARNPATHMODULE . "`\n (`learnPath_id`, `module_id`, `specificComment`, `rank`, `lock` )\n VALUES (" . (int) $_SESSION['path_id'] . ", " . (int) $list['module_id'] . ", ''," . $order . ", 'OPEN')"; claro_sql_query($insertquery); $atleastOne = TRUE; $nb++; } } } //end if ADD command //STEP ONE : display form to add module of the course that are not in this path yet // this is the same SELECT as "select all 'addable' modules of this course for this learning path" // **BUT** normally there is less 'addable' modules here than in the first one $result = claro_sql_query(buildRequestModules()); // Display available modules $out .= '<form name="addmodule" action="' . $_SERVER['PHP_SELF'] . '?cmdglobal=add">' . "\n" . claro_form_relay_context() . "\n" . '<table class="claroTable">' . "\n" . '<thead>' . "\n" . '<tr align="center" valign="top">' . "\n" . '<th width="10%">' . get_lang('Add module(s)') . '</th>' . "\n" . '<th>' . get_lang('Module') . '</th>' . "\n" . '</tr>' . "\n" . '</thead>' . "\n\n" . '<tbody>' . "\n\n"; $atleastOne = false; while ($list = mysql_fetch_array($result)) { //CHECKBOX, NAME, RENAME, COMMENT if ($list['contentType'] == CTEXERCISE_) { $moduleImg = get_icon_url('quiz', 'CLQWZ'); } else { $moduleImg = get_icon_url(choose_image(basename($list['path']))); } $contentType_alt = selectAlt($list['contentType']); $out .= '<tr>' . "\n" . '<td style="vertical-align:top; text-align: center;">' . "\n" . '<input type="checkbox" name="check_' . $list['module_id'] . '" id="check_' . $list['module_id'] . '" />' . "\n" . '</td>' . "\n" . '<td align="left">' . "\n" . '<label for="check_' . $list['module_id'] . '" >' . '<img hspace="5" src="' . $moduleImg . '" alt="' . $contentType_alt . '" /> ' . $list['name'] . '</label>' . "\n" . ($list['comment'] != null ? '<div class="comment">' . $list['comment'] . '</small>' . '</div>' . "\n\n" : '') . '</td>' . "\n" . '</tr>' . "\n\n"; $atleastOne = true; } //end while another module to display
//create and call the insertquery on the DB to add the checked module to the learning path Database::get()->query("INSERT INTO `lp_rel_learnPath_module` (`learnPath_id`, `module_id`, `specificComment`, `rank`, `lock`, `visible` ) VALUES (?d, ?d, '', ?d, 'OPEN', 1)", $_SESSION['path_id'], $list->module_id, $order); $atleastOne = TRUE; $nb++; } } } //end if ADD command //STEP ONE : display form to add module of the course that are not in this path yet // this is the same SELECT as "select all 'addable' modules of this course for this learning path" // **BUT** normally there is less 'addable' modules here than in the first one $result = Database::get()->queryArray(buildRequestModules()); $tool_content .= '<form name="addmodule" action="' . $_SERVER['SCRIPT_NAME'] . '?course=' . $course_code . '&cmdglobal=add">' . "\n\n"; $tool_content .= '<table class="table-default">' . '<tr>' . '<th class="text-left">'.$langLearningModule.'</th>' . '<th width="10"><div align="center">' . $langSelection . '</div></th>' . '</tr>'; // Display available modules $atleastOne = FALSE;