function find_news($start, $end)
{
global $lang;
global $ile;
global $url;
global $tpl;
global $znalezione;
if (isset($_GET['nazwa'])) {
$nazwa = XDb::xEscape($_GET['nazwa']);
$query = "select votes,cache_id,name, status, score, latitude, longitude, wp_oc, user_id, type from caches where name like '%" . $nazwa . "%' and caches.status in ('1','2','3') order by name limit " . $start . "," . $end;
$czykilka = 1;
$url = "./find.php?nazwa=" . $nazwa;
}
if (isset($_GET['wp'])) {
$wp = XDb::xEscape($_GET['wp']);
$query = "select votes,cache_id,name, status, score, latitude, longitude, wp_oc, user_id, type from caches where wp_oc = '" . $wp . "' and caches.status in ('1','2','3') order by name limit " . $start . "," . $end;
$czykilka = 0;
$url = "./find.php?wp=" . $wp;
}
if (isset($_GET['owner'])) {
$owner = XDb::xEscape($_GET['owner']);
$query = "select votes,cache_id,name, status, score, latitude, longitude, wp_oc, user_id, type from caches where user_id = (select user_id from user where username ='******') and caches.status in ('1','2','3') order by name limit " . $start . "," . $end;
$czykilka = 1;
$url = "./find.php?owner=" . $owner;
}
if (isset($_GET['finder'])) {
$finder = XDb::xEscape($_GET['finder']);
$query = "select caches.votes,caches.cache_id,name, status, score, latitude, longitude, wp_oc, caches.user_id, caches.type from caches inner join cache_logs on caches.cache_id=cache_logs.cache_id where cache_logs.user_id = (select user.user_id from user where username ='******') and cache_logs.type = '1' and cache_logs.deleted=0 and caches.status in ('1','2','3') order by cache_logs.id desc limit " . $start . "," . $end;
$czykilka = 1;
$url = "./find.php?finder=" . $finder;
}
$wynik = XDb::xSql($query);
$ilewyn = XDb::xNumRows($wynik);
if ($czykilka == 0) {
if ($ilewyn > 0) {
global $address;
$wiersz = XDb::xFetchArray($wynik);
$adres = "./" . $address . ".php?wp=" . $wiersz['wp_oc'];
header('Location: ' . $adres);
exit;
} else {
$tpl->assign("error", "1");
}
}
if ($czykilka == 1) {
$znalezione = array();
while ($rekord = XDb::xFetchArray($wynik)) {
if (isset($_SESSION['user_id'])) {
$query2 = "select 1 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '1' and deleted='0' and cache_id ='" . $rekord['cache_id'] . "';";
$wynik2 = XDb::xSql($query2);
$if_found = XDb::xFetchArray($wynik2);
if ($if_found[0] != '1') {
$query2 = "select 2 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '2' and deleted='0' and cache_id ='" . $rekord['cache_id'] . "';";
$wynik2 = XDb::xSql($query2);
$if_found = XDb::xFetchArray($wynik2);
}
$if_found = $if_found[0];
}
$query = "select username from user where user_id = " . $rekord['user_id'] . ";";
$wynik2 = XDb::xSql($query);
$wiersz = XDb::xFetchArray($wynik2);
$query = "select " . $lang . " from cache_type where id = " . $rekord['type'] . ";";
$wynik2 = XDb::xSql($query);
$wiersz2 = XDb::xFetchArray($wynik2);
if ($rekord['votes'] > 3) {
$rekord['score'] = score2ratingnum($rekord['score']);
} else {
$rekord['score'] = 5;
}
$rekord['username'] = $wiersz['username'];
$rekord['if_found'] = $if_found;
$rekord['N'] = cords($rekord['latitude']);
$rekord['E'] = cords($rekord['longitude']);
$rekord['typetext'] = $wiersz2[0];
$znalezione[] = $rekord;
}
}
}
$wynik9 = XDb::xSql($query9);
$if_ignored = XDb::xFetchArray($wynik9);
$if_ignored = $if_ignored[0];
if ($if_ignored == 1) {
continue;
}
}
if (isset($_GET['skip_inactive'])) {
if ($wiersz['status'] > 1) {
continue;
}
}
$rekord['user_id'] = $wiersz['user_id'];
$rekord['name'] = $wiersz['name'];
$rekord['status'] = $wiersz['status'];
$rekord['score'] = score2ratingnum($wiersz['score']);
$rekord['latitude'] = $wiersz['latitude'];
$rekord['longitude'] = $wiersz['longitude'];
$rekord['wp_oc'] = $wartosc;
$rekord['N'] = cords($rekord['latitude']);
$rekord['E'] = cords($rekord['longitude']);
$rekord['distance'] = $dist;
$rekord['kier'] = $kier;
$rekord['if_found'] = $if_found;
$query = "select username from user where user_id = '" . $rekord['user_id'] . "';";
$wynik = XDb::xSql($query);
$wiersz = XDb::xFetchArray($wynik);
$rekord['username'] = $wiersz['username'];
$znalezione[] = $rekord;
$lista[] = $rekord['wp_oc'];
$i++;
/**
* This function set map template variables based on given table
* @param array $filter - contains map params to set on template
*/
function setFilterSettings(array $filter)
{
global $powerTrailModuleSwitchOn;
// reset all min-score options
tpl_set_var("min_sel1", "");
tpl_set_var("min_sel2", "");
tpl_set_var("min_sel3", "");
tpl_set_var("min_sel4", "");
tpl_set_var("min_sel5", "");
tpl_set_var("max_sel1", "");
tpl_set_var("max_sel2", "");
tpl_set_var("max_sel3", "");
tpl_set_var("max_sel4", "");
tpl_set_var("max_sel5", "");
// go through filter values
foreach ($filter as $key => $value) {
$value = intval($value);
if ($key == "min_score" || $key == "max_score") {
if ($key == "min_score") {
$minmax = "min";
} else {
$minmax = "max";
}
tpl_set_var($minmax . "_sel" . intval(score2ratingnum($value) + 1), 'selected="selected"');
tpl_set_var($key, $value);
continue;
}
if (!($key == "h_avail" || $key == "h_temp_unavail" || $key == "be_ftf" || $key == "powertrail_only" || $key == "map_type" || $key == "h_noscore")) {
// workaround for reversed values
$value = 1 - $value;
}
if ($value) {
$chk = ' checked="checked"';
} else {
$chk = "";
}
tpl_set_var($key . "_checked", $chk);
if ($key == 'map_type') {
tpl_set_var('map_type', $value);
} else {
tpl_set_var($key, $value ? "true" : "");
}
}
// hide powerTrails filter if powerTrails are disabled in config
if ($powerTrailModuleSwitchOn) {
tpl_set_var("powerTrails_display", "");
} else {
tpl_set_var("powerTrails_display", "display:none");
}
}
function ratings($score, $votes)
{
if ($votes < 3) {
return '<span style="color: gray">' . tr('pt083') . '</span>';
}
$scoreNum = score2ratingnum($score);
switch ($scoreNum) {
case 0:
return '<span style="color: #790000">' . tr('pt074') . '</span>';
case 1:
return '<span style="color: #BF3C3C">' . tr('pt073') . '</span>';
case 2:
return '<span style="color: #B36200">' . tr('pt072') . '</span>';
case 3:
return '<span style="color: #518C00">' . tr('pt071') . '</span>';
case 4:
return '<span style="color: #009D00">' . tr('pt070') . '</span>';
}
}
$cache_status = mysql_fetch_row($wynik);
if (isset($_SESSION['user_id'])) {
$query2 = "select 1 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '1' and deleted='0' and cache_id ='" . $caches['cache_id'] . "';";
$wynik2 = db_query($query2);
$if_found = mysql_fetch_row($wynik2);
if ($if_found[0] != '1') {
$query2 = "select 2 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '2' and deleted='0' and cache_id ='" . $caches['cache_id'] . "';";
$wynik2 = db_query($query2);
$if_found = mysql_fetch_row($wynik2);
}
$if_found = $if_found[0];
}
$cache_info = array();
$cache_info['if_found'] = $if_found;
if ($caches['votes'] > 3) {
$cache_info['score'] = score2ratingnum($caches['score']);
} else {
$cache_info['score'] = 5;
}
if (isset($_SESSION['user_id'])) {
$query3 = "select id from cache_watches where user_id = '" . $_SESSION['user_id'] . "' and cache_id ='" . $caches['cache_id'] . "';";
$wynik3 = db_query($query3);
$watched = mysql_fetch_row($wynik3);
$watched = $watched[0];
if (!empty($watched)) {
$cache_info['watched'] = $watched;
} else {
$cache_info['watched'] = -1;
}
}
$cache_info['cache_id'] = $caches['cache_id'];
function score2rating($score)
{
global $ratingDesc;
return $ratingDesc[score2ratingnum($score)];
}
tpl_set_var('jQueryPopUpWindowscripts', ' ');
tpl_set_var('GeoKretyApi_window_display', 'none');
unset($_SESSION['GeoKretyApi']);
}
# end of GeoKretyApi
if ($cache_record['votes'] < 3) {
// DO NOT show cache's score
$score = "";
$scorecolor = "";
$font_size = "";
tpl_set_var('score', "N/A");
tpl_set_var('scorecolor', "#000000");
} else {
// show cache's score
$score = $cache_record['score'];
$scorenum = score2ratingnum($cache_record['score']);
$font_size = "2";
if ($scorenum == 0) {
$scorecolor = "#DD0000";
} else {
if ($scorenum == 1) {
$scorecolor = "#F06464";
} else {
if ($scorenum == 2) {
$scorecolor = "#DD7700";
} else {
if ($scorenum == 3) {
$scorecolor = "#77CC00";
} else {
if ($scorenum == 4) {
$scorecolor = "#00DD00";
tpl_set_var('jQueryPopUpWindowscripts', ' ');
tpl_set_var('GeoKretyApi_window_display', 'none');
unset($_SESSION['GeoKretyApi']);
}
# end of GeoKretyApi
if ($geocache->getRatingVotes() < 3) {
// DO NOT show cache's score
$score = "";
$scorecolor = "";
$font_size = "";
tpl_set_var('score', tr('not_available'));
tpl_set_var('scorecolor', "#000000");
} else {
// show cache's score
$score = $geocache->getScore();
$scorenum = score2ratingnum($score);
$font_size = "2";
if ($scorenum == 0) {
$scorecolor = "#DD0000";
} elseif ($scorenum == 1) {
$scorecolor = "#F06464";
} elseif ($scorenum == 2) {
$scorecolor = "#DD7700";
} elseif ($scorenum == 3) {
$scorecolor = "#77CC00";
} elseif ($scorenum == 4) {
$scorecolor = "#00DD00";
}
tpl_set_var('score', score2rating($score));
tpl_set_var('scorecolor', $scorecolor);
}
function ratings($score, $votes)
{
$language = $_POST['lang'];
if ($votes < 3) {
return '<span style="color: gray">' . tr2('pt083', $language) . '</span>';
}
$scoreNum = score2ratingnum($score);
switch ($scoreNum) {
case 0:
return '<span style="color: #790000">' . tr2('pt074', $language) . '</span>';
case 1:
return '<span style="color: #BF3C3C">' . tr2('pt073', $language) . '</span>';
case 2:
return '<span style="color: #B36200">' . tr2('pt072', $language) . '</span>';
case 3:
return '<span style="color: #518C00">' . tr2('pt071', $language) . '</span>';
case 4:
return '<span style="color: #009D00">' . tr2('pt070', $language) . '</span>';
}
}
