} } $t_student_publication = $row_course['db_name'] . ".student_publication"; $t_item_property = $row_course['db_name'] . ".item_property"; if ($singleDbForm) { $t_student_publication = "$prefix{$row_course['db_name']}_student_publication"; $t_item_property = "$prefix{$row_course['db_name']}_item_property"; } $sql_insert_user = "******"; $rs_insert_user = iDatabase::query($sql_insert_user); if ($rs_insert_user === false) { Log::error('Could not query insert_user_id table: ' . iDatabase::error()); } else { if (iDatabase::num_rows($rs_insert_user) > 0) { while ($row_ids = iDatabase::fetch_array($rs_insert_user)) { $user_id = $row_ids['insert_user_id']; $ref = $row_ids['ref']; $sql_upd = "UPDATE $t_student_publication SET user_id='$user_id' WHERE id='$ref'"; iDatabase::query($sql_upd); } } } //updating parent_id of the student_publication table $sql = 'SELECT id, url, parent_id FROM ' . $t_student_publication; $result = iDatabase::query($sql); if (iDatabase::num_rows($result) > 0) {
Log::notice('Course db ' . $row_course['db_name']); foreach ($c_q_list as $query) { if ($singleDbForm) { $query = preg_replace('/^(UPDATE|ALTER TABLE|CREATE TABLE|DROP TABLE|INSERT INTO|DELETE FROM)\s+(\w*)(.*)$/', "$1 $prefix{$row_course['db_name']}_$2$3", $query); } if ($only_test) { Log::notice("iDatabase::query(".$row_course['db_name'].",$query)"); } else { $res = iDatabase::query($query); if ($log) { Log::notice("In ".$row_course['db_name'].", executed: $query"); } if ($res === false) { Log::error('Error in '.$query.': '.iDatabase::error()); } } } $table_lp_item_view = $row_course['db_name'].".lp_item_view"; $table_lp_view = $row_course['db_name'].".lp_view"; $table_lp_item = $row_course['db_name'].".lp_item"; if ($singleDbForm) { $table_lp_item_view = "$prefix{$row_course['db_name']}_lp_item_view"; $table_lp_view = "$prefix{$row_course['db_name']}_lp_view"; $table_lp_item = "$prefix{$row_course['db_name']}_lp_item"; } // Filling the track_e_exercices.orig_lp_item_view_id field in order to have better traceability in exercises included in a LP see #3188
} // Fill description type into course_description table $t_course_description = $row_course['db_name'].".course_description"; if ($singleDbForm) { $t_course_description = "$prefix{$row_course['db_name']}_course_description"; } // Get all ids and update description_type field with them from course_description table $sql_sel = "SELECT id FROM $t_course_description"; $rs_sel = iDatabase::query($sql_sel); if ($rs_sel === false) { Log::error('Could not query course_description ids table: '.iDatabase::error()); } else { if (iDatabase::num_rows($rs_sel) > 0) { while ($row_ids = iDatabase::fetch_array($rs_sel)) { $description_id = $row_ids['id']; $sql_upd = "UPDATE $t_course_description SET description_type='$description_id' WHERE id='$description_id'"; iDatabase::query($sql_upd); } } } } } } }