Code Duplication    Length = 3-3 lines in 3 locations

core/process/queries/QueryManagerMysqlMonocleAlternate.php 1 location

@@ 470-472 (lines=3) @@
467
        if (isset($gym_name) && '' != $gym_name) {
468
            $where = " WHERE name LIKE '%".$gym_name."%'";
469
        }
470
        if (isset($team) && '' != $team) {
471
            $where .= ('' === $where ? ' WHERE' : ' AND').' fs.team = '.$team;
472
        }
473
        switch ($ranking) {
474
            case 1:
475
                $order = ' ORDER BY name, last_modified DESC';

core/process/queries/QueryManagerMysqlRocketmap.php 1 location

@@ 459-461 (lines=3) @@
456
        if (isset($gym_name) && '' != $gym_name) {
457
            $where = " WHERE name LIKE '%".$gym_name."%'";
458
        }
459
        if (isset($team) && '' != $team) {
460
            $where .= ('' == $where ? ' WHERE' : ' AND').' team_id = '.$team;
461
        }
462
        switch ($ranking) {
463
            case 1:
464
                $order = ' ORDER BY name, last_modified DESC';

core/process/queries/QueryManagerPostgresqlMonocleAlternate.php 1 location

@@ 448-450 (lines=3) @@
445
        if (isset($gym_name) && '' != $gym_name) {
446
            $where = " WHERE name LIKE '%".$gym_name."%'";
447
        }
448
        if (isset($team) && '' != $team) {
449
            $where .= ('' === $where ? ' WHERE' : ' AND').' fs.team = '.$team;
450
        }
451
        switch ($ranking) {
452
            case 1:
453
                $order = ' ORDER BY name, last_modified DESC';