chamilo / chamilo-lms

                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'])."'";

            }

            $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.

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

        }

        $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