Code Duplication    Length = 6-10 lines in 4 locations

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

@@ 3183-3192 (lines=10) @@
3180
                    WHERE user_id = $hr_manager_id AND relation_type=" . COURSE_RELATION_TYPE_RRHH . " ";
3181
        }
3182
        $result = Database::query($sql);
3183
        if (Database::num_rows($result) > 0) {
3184
            while ($row = Database::fetch_array($result)) {
3185
                $sql = "DELETE FROM $tbl_course_rel_user
3186
                        WHERE
3187
                            c_id = '{$row['c_id']}' AND
3188
                            user_id = $hr_manager_id AND
3189
                            relation_type=" . COURSE_RELATION_TYPE_RRHH . " ";
3190
                Database::query($sql);
3191
            }
3192
        }
3193
3194
        // inserting new courses list
3195
        if (is_array($courses_list)) {

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

@@ 3137-3146 (lines=10) @@
3134
            }
3135
            $result = Database::query($sql);
3136
3137
            if (Database::num_rows($result) > 0) {
3138
                while ($row = Database::fetch_array($result)) {
3139
                    $sql = "DELETE FROM $tbl_session_rel_user
3140
                            WHERE
3141
                                session_id = {$row['session_id']} AND
3142
                                user_id = $userId AND
3143
                                relation_type =" . SESSION_RELATION_TYPE_RRHH;
3144
                    Database::query($sql);
3145
                }
3146
            }
3147
        }
3148
3149
        // Inserting new sessions list.

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

@@ 4541-4550 (lines=10) @@
4538
        }
4539
        $result = Database::query($sql);
4540
4541
        if (Database::num_rows($result) > 0) {
4542
            while ($row = Database::fetch_array($result)) {
4543
                $sql = "DELETE FROM $userRelUserTable 
4544
                        WHERE 
4545
                          user_id = {$row['user_id']} AND 
4546
                          friend_user_id = $userId AND 
4547
                          relation_type = $relationType";
4548
                Database::query($sql);
4549
            }
4550
        }
4551
4552
        if ($deleteUsersBeforeInsert) {
4553
            $sql = "DELETE FROM $userRelUserTable 

main/wiki/wiki.inc.php 1 location

@@ 5304-5309 (lines=6) @@
5301
                echo '</ul></form>';
5302
            } else { // We show the differences between two versions
5303
                $version_old = array();
5304
                if (isset($_POST['old'])) {
5305
                    $sql_old = "SELECT * FROM $tbl_wiki
5306
                                WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'";
5307
                    $result_old = Database::query($sql_old);
5308
                    $version_old = Database::fetch_array($result_old);
5309
                }
5310
5311
                $sql_new = "SELECT * FROM $tbl_wiki
5312
                            WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'";