chamilo / chamilo-lms

                    WHERE user_id = $hr_manager_id AND relation_type=".COURSE_RELATION_TYPE_RRHH." ";

        }

        $result = Database::query($sql);

        if (Database::num_rows($result) > 0) {

            while ($row = Database::fetch_array($result)) {

                $sql = "DELETE FROM $tbl_course_rel_user

                        WHERE

                            c_id = '{$row['c_id']}' AND

                            user_id = $hr_manager_id AND

                            relation_type=".COURSE_RELATION_TYPE_RRHH." ";

                Database::query($sql);

            }

        }

        // inserting new courses list

        if (is_array($courses_list)) {

        $sql = "SELECT * FROM $table_message WHERE id='$id'";

        $rs = Database::query($sql);

        if (Database::num_rows($rs) > 0) {

            // delete attachment file

            self::delete_message_attachment_file($id, $user_sender_id);

            // delete message

            $sql = "UPDATE $table_message 

                    SET msg_status = ".MESSAGE_STATUS_DELETED."

                    WHERE user_sender_id='$user_sender_id' AND id='$id'";

            Database::query($sql);

            return true;

        }

        return false;

    }

            }

            $result = Database::query($sql);

            if (Database::num_rows($result) > 0) {

                while ($row = Database::fetch_array($result)) {

                    $sql = "DELETE FROM $tbl_session_rel_user

                            WHERE

                                session_id = {$row['session_id']} AND

                                user_id = $userId AND

                                relation_type =".SESSION_RELATION_TYPE_RRHH;

                    Database::query($sql);

                }

            }

        }

        // Inserting new sessions list.

        }

        $result = Database::query($sql);

        if (Database::num_rows($result) > 0) {

            while ($row = Database::fetch_array($result)) {

                $sql = "DELETE FROM $userRelUserTable 

                        WHERE 

                          user_id = {$row['user_id']} AND 

                          friend_user_id = $userId AND 

                          relation_type = $relationType";

                Database::query($sql);

            }

        }

        if ($deleteUsersBeforeInsert) {

            $sql = "DELETE FROM $userRelUserTable 

                echo '</ul></form>';

            } else { // We show the differences between two versions

                $version_old = array();

                if (isset($_POST['old'])) {

                    $sql_old = "SELECT * FROM $tbl_wiki

                                WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'";

                    $result_old = Database::query($sql_old);

                    $version_old = Database::fetch_array($result_old);

                }

                $sql_new = "SELECT * FROM $tbl_wiki

                            WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'";