}
}
$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);
}
}
}
}
}
}
}
