Code Duplication    Length = 3-3 lines in 3 locations

core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location

@@ 500-502 (lines=3) @@
497
        if (isset($gym_name) && '' != $gym_name) {
498
            $where = " WHERE name LIKE '%".$gym_name."%'";
499
        }
500
        if (isset($team) && '' != $team) {
501
            $where .= ('' === $where ? ' WHERE' : ' AND').' fs.team = '.$team;
502
        }
503
        switch ($ranking) {
504
            case 1:
505
                $order = ' ORDER BY name, last_modified DESC';

core/process/queries/QueryManagerMysqlRocketmap.php 1 location

@@ 489-491 (lines=3) @@
486
        if (isset($gym_name) && '' != $gym_name) {
487
            $where = " WHERE name LIKE '%".$gym_name."%'";
488
        }
489
        if (isset($team) && '' != $team) {
490
            $where .= ('' == $where ? ' WHERE' : ' AND').' team_id = '.$team;
491
        }
492
        switch ($ranking) {
493
            case 1:
494
                $order = ' ORDER BY name, last_modified DESC';

core/process/queries/QueryManagerPostgresqlMonocleAlternate.php 1 location

@@ 478-480 (lines=3) @@
475
        if (isset($gym_name) && '' != $gym_name) {
476
            $where = " WHERE name LIKE '%".$gym_name."%'";
477
        }
478
        if (isset($team) && '' != $team) {
479
            $where .= ('' === $where ? ' WHERE' : ' AND').' fs.team = '.$team;
480
        }
481
        switch ($ranking) {
482
            case 1:
483
                $order = ' ORDER BY name, last_modified DESC';