Code Duplication    Length = 6-10 lines in 4 locations

main/inc/lib/course.lib.php 1 location

@@ 2925-2934 (lines=10) @@
2922
                    WHERE user_id = $hr_manager_id AND relation_type=" . COURSE_RELATION_TYPE_RRHH . " ";
2923
        }
2924
        $result = Database::query($sql);
2925
        if (Database::num_rows($result) > 0) {
2926
            while ($row = Database::fetch_array($result)) {
2927
                $sql = "DELETE FROM $tbl_course_rel_user
2928
                        WHERE
2929
                            c_id = '{$row['c_id']}' AND
2930
                            user_id = $hr_manager_id AND
2931
                            relation_type=" . COURSE_RELATION_TYPE_RRHH . " ";
2932
                Database::query($sql);
2933
            }
2934
        }
2935
2936
        // inserting new courses list
2937
        if (is_array($courses_list)) {

main/inc/lib/usermanager.lib.php 1 location

@@ 4154-4163 (lines=10) @@
4151
        }
4152
        $result = Database::query($sql);
4153
4154
        if (Database::num_rows($result) > 0) {
4155
            while ($row = Database::fetch_array($result)) {
4156
                $sql = "DELETE FROM $userRelUserTable "
4157
                    . "WHERE user_id = {$row['user_id']} "
4158
                    . "AND friend_user_id = $userId "
4159
                    . "AND relation_type = $relationType";
4160
4161
                Database::query($sql);
4162
            }
4163
        }
4164
4165
        // Inserting new user list
4166
        if (is_array($subscribedUsersId)) {

main/wiki/wiki.inc.php 1 location

@@ 5247-5252 (lines=6) @@
5244
                echo '</ul></form>';
5245
            } else { // We show the differences between two versions
5246
                $version_old = array();
5247
                if (isset($_POST['old'])) {
5248
                    $sql_old = "SELECT * FROM $tbl_wiki
5249
                                WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'";
5250
                    $result_old = Database::query($sql_old);
5251
                    $version_old = Database::fetch_array($result_old);
5252
                }
5253
5254
                $sql_new = "SELECT * FROM $tbl_wiki
5255
                            WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'";

main/inc/lib/sessionmanager.lib.php 1 location

@@ 2920-2929 (lines=10) @@
2917
            }
2918
            $result = Database::query($sql);
2919
2920
            if (Database::num_rows($result) > 0) {
2921
                while ($row = Database::fetch_array($result)) {
2922
                    $sql = "DELETE FROM $tbl_session_rel_user
2923
                            WHERE
2924
                                session_id = {$row['session_id']} AND
2925
                                user_id = $userId AND
2926
                                relation_type=" . SESSION_RELATION_TYPE_RRHH . " ";
2927
                    Database::query($sql);
2928
                }
2929
            }
2930
        }
2931
        // Inserting new sessions list.
2932
        if (!empty($sessions_list) && is_array($sessions_list)) {