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