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'; |