} 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) {
$items = iDatabase::store_result($result);
$directory_list = $file_list = array();
foreach ($items as $item) {
$student_slash = substr($item['url'], 0, 1);
//means this is a directory
if ($student_slash == '/') {
$directory_list[$item['id']] = $item['url'];
} else {
// this is a file with no parents
if ($item['parent_id'] == 0)
$file_list [] = $item;
}
}
if (is_array($file_list) && count($file_list) > 0) {
