CloneSet895


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
8420.980statement_sequence[2]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
1853
administrator/components/com_users/helpers/html/filter.php
2841
libraries/joomla/form/fields/usergroups.php
3879
libraries/joomla/html/html/access.php
48127
libraries/joomla/html/html/access.php
Clone Instance
1
Line Count
8
Source Line
53
Source File
administrator/components/com_users/helpers/html/filter.php

                $db->setQuery(
                        'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
                        . ' FROM #__usergroups AS a'
                        . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt'
                        . ' GROUP BY a.id'
                        . ' ORDER BY a.lft ASC');

                $options=  $db->loadObjectList();


Clone Instance
2
Line Count
8
Source Line
41
Source File
libraries/joomla/form/fields/usergroups.php

                // Get the user groups from the database.
                $db->setQuery(
                        'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
                        . ' FROM #__usergroups AS a'
                        . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt'
                        . ' GROUP BY a.id'
                        . ' ORDER BY a.lft ASC');

                $options=  $db->loadObjectList();


Clone Instance
3
Line Count
8
Source Line
79
Source File
libraries/joomla/html/html/access.php

                $db->setQuery(
                        'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
                        . ' FROM #__usergroups AS a'
                        . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt'
                        . ' GROUP BY a.id'
                        . ' ORDER BY a.lft ASC');

                $options=  $db->loadObjectList();


Clone Instance
4
Line Count
8
Source Line
127
Source File
libraries/joomla/html/html/access.php

                $db->setQuery(
                        'SELECT a.*, COUNT(DISTINCT b.id) AS level'
                        . ' FROM #__usergroups AS a'
                        . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt'
                        . ' GROUP BY a.id'
                        . ' ORDER BY a.lft ASC');

                $groups=  $db->loadObjectList();


Clone AbstractionParameter Count: 2Parameter Bindings

// Get the user groups from the database.
$db->setQuery( [[#variable44e29220]]
              . ' FROM #__usergroups AS a'
              . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt'
              . ' GROUP BY a.id'
              . ' ORDER BY a.lft ASC');
 [[#variable44e29200]]=$db->loadObjectList();
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#44e29220]]
'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level' 
12[[#44e29220]]
'SELECT a.*, COUNT(DISTINCT b.id) AS level' 
13[[#44e29220]]
'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level' 
14[[#44e29220]]
'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level' 
21[[#44e29200]]
$options 
22[[#44e29200]]
$groups 
23[[#44e29200]]
$options 
24[[#44e29200]]
$options