CloneSet895


Clone Mass	Clones in CloneSet	Parameter Count	Clone Similarity	Syntax Category [Sequence Length]
8	4	2	0.980	statement_sequence[2]

Clone Abstraction

Parameter Bindings

Clone Instance (Click to see clone)	Line Count	Source Line	Source File
1	8	53	administrator/components/com_users/helpers/html/filter.php
2	8	41	libraries/joomla/form/fields/usergroups.php
3	8	79	libraries/joomla/html/html/access.php
4	8	127	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 Abstraction

Parameter Count: 2

Parameter 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
1	1	`[[#44e29220]]`	'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
1	2	`[[#44e29220]]`	'SELECT a.*, COUNT(DISTINCT b.id) AS level'
1	3	`[[#44e29220]]`	'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
1	4	`[[#44e29220]]`	'SELECT a.id AS value, a.title AS text, COUNT(DISTINCT b.id) AS level'
2	1	`[[#44e29200]]`	$options
2	2	`[[#44e29200]]`	$groups
2	3	`[[#44e29200]]`	$options
2	4	`[[#44e29200]]`	$options