Code Duplication    Length = 20-20 lines in 2 locations

main/inc/lib/link.lib.php 2 locations

@@ 655-674 (lines=20) @@
652
                $ic_slide->addValue('content', $link_description);
653
654
                // Add category name if set.
655
                if (isset($categoryId) && $categoryId > 0) {
656
                    $table_link_category = Database:: get_course_table(
657
                        TABLE_LINK_CATEGORY
658
                    );
659
                    $sql_cat = 'SELECT * FROM %s WHERE id=%d and c_id = %d LIMIT 1';
660
                    $sql_cat = sprintf(
661
                        $sql_cat,
662
                        $table_link_category,
663
                        $categoryId,
664
                        $course_int_id
665
                    );
666
                    $result = Database:: query($sql_cat);
667
                    if (Database:: num_rows($result) == 1) {
668
                        $row = Database:: fetch_array($result);
669
                        $ic_slide->addValue(
670
                            'category',
671
                            $row['category_title']
672
                        );
673
                    }
674
                }
675
676
                $di = new ChamiloIndexer();
677
                isset ($_POST['language']) ? $lang = Database:: escape_string($_POST['language']) : $lang = 'english';
@@ 272-291 (lines=20) @@
269
                    $ic_slide->addValue('content', $description);
270
271
                    // Add category name if set.
272
                    if (isset($selectcategory) && $selectcategory > 0) {
273
                        $table_link_category = Database:: get_course_table(
274
                            TABLE_LINK_CATEGORY
275
                        );
276
                        $sql_cat = 'SELECT * FROM %s WHERE id=%d AND c_id = %d LIMIT 1';
277
                        $sql_cat = sprintf(
278
                            $sql_cat,
279
                            $table_link_category,
280
                            (int)$selectcategory,
281
                            $course_int_id
282
                        );
283
                        $result = Database:: query($sql_cat);
284
                        if (Database:: num_rows($result) == 1) {
285
                            $row = Database:: fetch_array($result);
286
                            $ic_slide->addValue(
287
                                'category',
288
                                $row['category_title']
289
                            );
290
                        }
291
                    }
292
293
                    $di = new ChamiloIndexer();
294
                    isset($_POST['language']) ? $lang = Database:: escape_string(