$s = $dbcSearch->simpleQuery('SELECT `wptcontent`.`cache_id` `cacheid`, `wptcontent`.`longitude` `longitude`, `wptcontent`.`latitude` `latitude`, `caches`.`date_hidden` `date_hidden`,
`caches`.`name` `name`, `caches`.`wp_oc` `wp_oc`, `cache_type`.`short` `typedesc`, `cache_size`.`pl` `sizedesc`,
`caches`.`terrain` `terrain`, `caches`.`difficulty` `difficulty`, `user`.`username` `username` , `caches`.`size` `size`,
`caches`.`type` `type`
FROM `wptcontent`, `caches`, `cache_type`, `cache_size`, `user`
WHERE `wptcontent`.`cache_id`=`caches`.`cache_id` AND `wptcontent`.`type`=`cache_type`.`id`
AND `wptcontent`.`size`=`cache_size`.`id` AND `wptcontent`.`user_id`=`user`.`user_id`');
append_output(pack("ccccl", 0xbb, 0x22, 0xd5, 0x3f, $rCount['count']));
while ($r = $dbcSearch->dbResultFetch($s)) {
$lat = $r['latitude'];
$lon = $r['longitude'];
$utm = cs2cs_1992($lat, $lon);
$x = (int) $utm[0];
$y = (int) $utm[1];
$name = PLConvert('UTF-8', 'POLSKAWY', $r['name']);
$username = PLConvert('UTF-8', 'POLSKAWY', $r['username']);
$type = $uamType[$r['type']];
$size = $uamSize[$r['size']];
$difficulty = sprintf('%01.1f', $r['difficulty'] / 2);
$terrain = sprintf('%01.1f', $r['terrain'] / 2);
$cacheid = $r['wp_oc'];
$descr = "{$name} by {$username} [{$difficulty}/{$terrain}]";
$poiname = "{$cacheid} {$type}{$size}";
$record = pack("llca64a255cca32", $x, $y, 2, $poiname, $descr, 1, 99, 'Geocaching');
append_output($record);
ob_flush();
}
XDb::xSql('DROP TABLE `wptcontent` ');
// phpzip versenden
if ($bUseZip == true) {
$phpzip->add_data($sFilebasename . '.uam', $content);
function cleanup_text($str)
{
// $str= tidy_html_description($str);
$str = PLConvert('UTF-8', 'POLSKAWY', $str);
$str = strip_tags($str, "<p><br /><li>");
// <p> -> nic
// </p>, <br /> -> nowa linia
$from[] = '<p>';
$to[] = '';
$from[] = '</p>';
$to[] = "\n";
$from[] = '<br />';
$to[] = "\n";
$from[] = '<br>';
$to[] = "\n";
$from[] = '<br>';
$to[] = "\n";
$from[] = '<li>';
$to[] = " - ";
$from[] = '</li>';
$to[] = "\n";
$from[] = 'ó';
$to[] = 'o';
$from[] = '"';
$to[] = '"';
$from[] = '&[^;]*;';
$to[] = '';
$from[] = '&';
$to[] = '&';
$from[] = '<';
$to[] = '<';
$from[] = '>';
$to[] = '>';
$from[] = ']]>';
$to[] = ']] >';
$from[] = ' ';
$to[] = '';
for ($i = 0; $i < count($from); $i++) {
$str = str_replace($from[$i], $to[$i], $str);
}
$str = preg_replace('/[[:cntrl:]]/', '', $str);
return $str;
}
$thisline = $locLine;
$lat = sprintf('%01.5f', $r['latitude']);
$thisline = mb_ereg_replace('{lat}', $lat, $thisline);
$lon = sprintf('%01.5f', $r['longitude']);
$thisline = mb_ereg_replace('{lon}', $lon, $thisline);
$thisline = mb_ereg_replace('{{waypoint}}', $r['waypoint'], $thisline);
$thisline = mb_ereg_replace('{cachename}', PLConvert('UTF-8', 'POLSKAWY', $r['name']), $thisline);
// modified coords
if ($r['cache_mod_cords_id'] > 0) {
// check if we have user coords
$thisline = str_replace('{mod_suffix}', '<F>', $thisline);
} else {
$thisline = str_replace('{mod_suffix}', '', $thisline);
}
$thisline = mb_ereg_replace('{type_text}', $cacheTypeText[$r['type_id']], $thisline);
$thisline = mb_ereg_replace('{{size}}', PLConvert('UTF-8', 'POLSKAWY', tr('cacheType_' . $r['type_id'])), $thisline);
$difficulty = sprintf('%01.1f', $r['difficulty'] / 2);
$thisline = mb_ereg_replace('{difficulty}', $difficulty, $thisline);
$terrain = sprintf('%01.1f', $r['terrain'] / 2);
$thisline = mb_ereg_replace('{terrain}', $terrain, $thisline);
$thisline = mb_ereg_replace('{owner}', $r['username'], $thisline);
$thisline = mb_ereg_replace('{cacheid}', $r['cacheid'], $thisline);
append_output($thisline);
ob_flush();
}
append_output($locFoot);
// phpzip versenden
if ($bUseZip == true) {
$phpzip->add_data($sFilebasename . '.loc', $content);
echo $phpzip->save($sFilebasename . '.zip', 'b');
}
