Code Duplication    Length = 6-10 lines in 4 locations

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

@@ 3222-3231 (lines=10) @@
3219
                    WHERE user_id = $hr_manager_id AND relation_type=".COURSE_RELATION_TYPE_RRHH." ";
3220
        }
3221
        $result = Database::query($sql);
3222
        if (Database::num_rows($result) > 0) {
3223
            while ($row = Database::fetch_array($result)) {
3224
                $sql = "DELETE FROM $tbl_course_rel_user
3225
                        WHERE
3226
                            c_id = '{$row['c_id']}' AND
3227
                            user_id = $hr_manager_id AND
3228
                            relation_type=".COURSE_RELATION_TYPE_RRHH." ";
3229
                Database::query($sql);
3230
            }
3231
        }
3232
3233
        // inserting new courses list
3234
        if (is_array($courses_list)) {

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

@@ 3240-3249 (lines=10) @@
3237
            }
3238
            $result = Database::query($sql);
3239
3240
            if (Database::num_rows($result) > 0) {
3241
                while ($row = Database::fetch_array($result)) {
3242
                    $sql = "DELETE FROM $tbl_session_rel_user
3243
                            WHERE
3244
                                session_id = {$row['session_id']} AND
3245
                                user_id = $userId AND
3246
                                relation_type =".SESSION_RELATION_TYPE_RRHH;
3247
                    Database::query($sql);
3248
                }
3249
            }
3250
        }
3251
3252
        // Inserting new sessions list.

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

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

main/wiki/wiki.inc.php 1 location

@@ 5381-5386 (lines=6) @@
5378
                echo '</ul></form>';
5379
            } else { // We show the differences between two versions
5380
                $version_old = array();
5381
                if (isset($_POST['old'])) {
5382
                    $sql_old = "SELECT * FROM $tbl_wiki
5383
                                WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'";
5384
                    $result_old = Database::query($sql_old);
5385
                    $version_old = Database::fetch_array($result_old);
5386
                }
5387
5388
                $sql_new = "SELECT * FROM $tbl_wiki
5389
                            WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'";