CloneSet163


Clone Mass	Clones in CloneSet	Parameter Count	Clone Similarity	Syntax Category [Sequence Length]
24	3	5	0.953	statement_sequence[9]

Clone Abstraction

Parameter Bindings

Clone Instance (Click to see clone)	Line Count	Source Line	Source File
1	24	72	administrator/components/com_banners/controllers/banner.php
2	21	90	administrator/components/com_messages/admin.messages.php
3	19	70	administrator/components/com_search/models/search.php

Clone Instance
1

Line Count
24

Source Line
72

Source File

administrator/components/com_banners/controllers/banner.php

                $orderby=         ' ORDER BY '
                                  .             $filter_order
                                  .                            ' '
                                  .                                 $filter_order_Dir
                                  .                                                    ', b.ordering';
                // get the total number of records
                $query=  'SELECT COUNT(*)'
                         . ' FROM #__banner AS b'
                         . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid'
                         . $where;
                $db->setQuery($query);
                $total=  $db->loadResult();
                jimport('joomla.html.pagination');
                $pageNav=  new JPagination($total, $limitstart, $limit);
                $query=  'SELECT b.*, c.name AS client_name, cc.title AS category_name, u.name AS editor'
                         . ' FROM #__banner AS b'
                         . ' INNER JOIN #__bannerclient AS c ON c.cid = b.cid'
                         . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid'
                         . ' LEFT JOIN #__users AS u ON u.id = b.checked_out'
                         . $where
                         . $orderby;

                $db->setQuery($query, $pageNav->limitstart ,$pageNav->limit);
                $rows=  $db->loadObjectList();

Clone Instance
2

Line Count
21

Source Line
90

Source File

administrator/components/com_messages/admin.messages.php

        $orderby=         ' ORDER BY '
                          .             $filter_order
                          .                            ' '
                          .                                 $filter_order_Dir
                          .                                                    ', a.date_time DESC';
        $query=  'SELECT COUNT(*)'
                 . ' FROM #__messages AS a'
                 . ' INNER JOIN #__users AS u ON u.id = a.user_id_from'
                 . $where;
        $db->setQuery($query);
        $total=  $db->loadResult();
        jimport('joomla.html.pagination');
        $pageNav=  new JPagination($total, $limitstart, $limit);
        $query=  'SELECT a.*, u.name AS user_from'
                 . ' FROM #__messages AS a'
                 . ' INNER JOIN #__users AS u ON u.id = a.user_id_from'
                 . $where
                 . $orderby;

        $db->setQuery($query, $pageNav->limitstart ,$pageNav->limit);
        $rows=  $db->loadObjectList();

Clone Instance
3

Line Count
19

Source Line
70

Source File

administrator/components/com_search/models/search.php

                $orderby=         ' ORDER BY '
                                  .             $filter_order
                                  .                            ' '
                                  .                                 $filter_order_Dir
                                  .                                                    ', hits DESC';
                // get the total number of records
                $query=  'SELECT COUNT(*)'
                         . ' FROM #__core_log_searches'
                         . $where;
                $db->setQuery($query);
                $total=  $db->loadResult();
                jimport('joomla.html.pagination');
                $pageNav=  new JPagination($total, $limitstart, $limit);
                $query=  ' SELECT * '
                         . ' FROM #__core_log_searches '
                         . $where
                         . $orderby;
                $db->setQuery($query, $pageNav->limitstart ,$pageNav->limit);
                $rows=  $db->loadObjectList();

Clone Abstraction

Parameter Count: 5

Parameter Bindings

$orderby=' ORDER BY '
         . $filter_order
         . ' '
         . $filter_order_Dir
         .  [[#variable4c7acf60]];
// get the total number of records
$query= [[#variable4c7acec0]]
       .  [[#variable4c7ace40]]
       . $where;
$db->setQuery($query);
$total=$db->loadResult();
jimport('joomla.html.pagination');
$pageNav=new JPagination($total,$limitstart,$limit);
$query= [[#variable4dddace0]]
       .  [[#variable4c7acda0]]
       . $where
       . $orderby;
$db->setQuery($query,$pageNav->limitstart ,$pageNav->limit);
$rows=$db->loadObjectList();

CloneAbstraction

Parameter Bindings
Parameter Index	Clone Instance	Parameter Name	Value
1	1	`[[#4c7acf60]]`	', b.ordering'
1	2	`[[#4c7acf60]]`	', a.date_time DESC'
1	3	`[[#4c7acf60]]`	', hits DESC'
2	1	`[[#4c7acec0]]`	'SELECT COUNT(*)' . ' FROM #__banner AS b'
2	2	`[[#4c7acec0]]`	'SELECT COUNT(*)' . ' FROM #__messages AS a'
2	3	`[[#4c7acec0]]`	'SELECT COUNT(*)'
3	1	`[[#4c7ace40]]`	' LEFT JOIN #__categories AS cc ON cc.id = b.catid'
3	2	`[[#4c7ace40]]`	' INNER JOIN #__users AS u ON u.id = a.user_id_from'
3	3	`[[#4c7ace40]]`	' FROM #__core_log_searches'
4	1	`[[#4dddace0]]`	'SELECT b.*, c.name AS client_name, cc.title AS category_name, u.name AS editor' . ' FROM #__banner AS b' . ' INNER JOIN #__bannerclient AS c ON c.cid = b.cid' . ' LEFT JOIN #__categories AS cc ON cc.id = b.catid'
4	2	`[[#4dddace0]]`	'SELECT a.*, u.name AS user_from' . ' FROM #__messages AS a'
4	3	`[[#4dddace0]]`	' SELECT * '
5	1	`[[#4c7acda0]]`	' LEFT JOIN #__users AS u ON u.id = b.checked_out'
5	2	`[[#4c7acda0]]`	' INNER JOIN #__users AS u ON u.id = a.user_id_from'
5	3	`[[#4c7acda0]]`	' FROM #__core_log_searches '