CloneSet1145


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
12240.975statement
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
112106
plugins/search/newsfeeds.php
212118
plugins/search/weblinks.php
Clone Instance
1
Line Count
12
Source Line
106
Source File
plugins/search/newsfeeds.php

        $query=  'SELECT a.name AS title, "" AS created, a.link AS text,'
                 . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
                 . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
                 . ' CONCAT_WS(" / ", '
                 .              $db->Quote($searchNewsfeeds)
        .                                                     ', b.title)AS section,'
        . ' "1" AS browsernav'
        . ' FROM #__newsfeeds AS a'
        . ' INNER JOIN #__categories AS b ON b.id = a.catid'
        . ' WHERE ('
        .             $where
        .                     ')'
        . ' AND a.published = 1'
        . ' AND b.published = 1'
        . ' AND b.access IN ('
        .                      $groups
        .                              ')'
        . ' ORDER BY '
        .               $order;


Clone Instance
2
Line Count
12
Source Line
118
Source File
plugins/search/weblinks.php

        $query=  'SELECT a.title AS title, a.description AS text, a.date AS created, a.url, '
                 . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
                 . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
                 . ' CONCAT_WS(" / ", '
                 .             $db->Quote($section)
        .                                           ', b.title) AS section,'
        . ' "1" AS browsernav'
        . ' FROM #__weblinks AS a'
        . ' INNER JOIN #__categories AS b ON b.id = a.catid'
        . ' WHERE ('
        .             $where
        .                     ')'
        . ' AND a.published = 1'
        . ' AND b.published = 1'
        . ' AND b.access IN ('
        .                      $groups
        .                              ')'
        . ' ORDER BY '
        .               $order;


Clone AbstractionParameter Count: 4Parameter Bindings

$query= [[#variable2301dd60]]
       . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END as slug, '
       . ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(\':\', b.id, b.alias) ELSE b.id END as catslug, '
       . ' CONCAT_WS(" / ", '
       . $db->Quote( [[#variable2301dce0]])
.  [[#variable2301dc40]]
. ' "1" AS browsernav'
.  [[#variable2301db20]]
. ' INNER JOIN #__categories AS b ON b.id = a.catid'
. ' WHERE ('
. $where
. ')'
. ' AND a.published = 1'
. ' AND b.published = 1'
. ' AND b.access IN ('
. $groups
. ')'
. ' ORDER BY '
. $order;
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#2301dd60]]
'SELECT a.name AS title, "" AS created, a.link AS text,' 
12[[#2301dd60]]
'SELECT a.title AS title, a.description AS text, a.date AS created, a.url, ' 
21[[#2301dce0]]
$searchNewsfeeds 
22[[#2301dce0]]
$section 
31[[#2301dc40]]
', b.title)AS section,' 
32[[#2301dc40]]
', b.title) AS section,' 
41[[#2301db20]]
' FROM #__newsfeeds AS a' 
42[[#2301db20]]
' FROM #__weblinks AS a'