|
@@ 145-148 (lines=4) @@
|
| 142 |
|
$inmap_pkms_filter = rtrim($inmap_pkms_filter, ","); |
| 143 |
|
$where .= " AND encounter_id NOT IN (" . $inmap_pkms_filter . ") "; |
| 144 |
|
} |
| 145 |
|
if ($testIv->iv != null && isset($post['ivMin']) && ($post['ivMin'] != "")) { |
| 146 |
|
$ivMin = mysqli_real_escape_string($mysqli, $post['ivMin']); |
| 147 |
|
$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) >= (" . $ivMin . ") "; |
| 148 |
|
} |
| 149 |
|
if ($testIv->iv != null && isset($post['ivMax']) && ($post['ivMax'] != "")) { |
| 150 |
|
$ivMax = mysqli_real_escape_string($mysqli, $post['ivMax']); |
| 151 |
|
$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) <=(" . $ivMax . ") "; |
|
@@ 149-152 (lines=4) @@
|
| 146 |
|
$ivMin = mysqli_real_escape_string($mysqli, $post['ivMin']); |
| 147 |
|
$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) >= (" . $ivMin . ") "; |
| 148 |
|
} |
| 149 |
|
if ($testIv->iv != null && isset($post['ivMax']) && ($post['ivMax'] != "")) { |
| 150 |
|
$ivMax = mysqli_real_escape_string($mysqli, $post['ivMax']); |
| 151 |
|
$where .= " AND ((100/45)*(individual_attack+individual_defense+individual_stamina)) <=(" . $ivMax . ") "; |
| 152 |
|
} |
| 153 |
|
return "SELECT pokemon_id, encounter_id, latitude, longitude, disappear_time, |
| 154 |
|
(CONVERT_TZ(disappear_time, '+00:00', '" . $time_offset . "')) AS disappear_time_real, |
| 155 |
|
individual_attack, individual_defense, individual_stamina, move_1, move_2 |