Previous CloneSet | Next CloneSet | Back to Main Report |
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 |
| ||||
$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(); |
| ||||
$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(); |
| ||||
$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(); |
| |||
$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 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 ' |