} 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) {