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