@@ -15,11 +15,11 @@ discard block |
||
15 | 15 | * bin/dbsv-update.php will then migrate the tables' charset. |
16 | 16 | */ |
17 | 17 | $opt['charset']['iconv'] = 'UTF-8'; // 'ISO-8859-1'; // use iconv compatible charset-name |
18 | -$opt['charset']['mysql'] = 'utf8'; // use mysql compatible charset-name |
|
18 | +$opt['charset']['mysql'] = 'utf8'; // use mysql compatible charset-name |
|
19 | 19 | |
20 | 20 | // handling of SQL and PHP errors |
21 | 21 | $opt['db']['error']['display'] = false; |
22 | -$opt['db']['error']['mail'] = 'root'; // set '' to disable |
|
22 | +$opt['db']['error']['mail'] = 'root'; // set '' to disable |
|
23 | 23 | |
24 | 24 | // page title |
25 | 25 | $opt['page']['title'] = 'OPENCACHING'; |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | * Additionally, the cookie domain (different vor lib1 and lib2) can be overwritten. |
58 | 58 | * See examples for overriding in settings-sample.inc.php. |
59 | 59 | */ |
60 | -$opt['page']['meta']['keywords'] = 'Geocaching, Geocache, Cache, Schatzsuche, GPS, kostenlos, GPX, Koordinaten, Hobby, Natur'; // 5-10 keywords are recommended |
|
60 | +$opt['page']['meta']['keywords'] = 'Geocaching, Geocache, Cache, Schatzsuche, GPS, kostenlos, GPX, Koordinaten, Hobby, Natur'; // 5-10 keywords are recommended |
|
61 | 61 | // see http://forum.opencaching.de/index.php?topic=3065.0 |
62 | 62 | // and http://forum.opencaching.de/index.php?topic=3065.0 regarding description |
63 | 63 | $opt['page']['meta']['description'] = 'Opencaching.de ist das freie Portal für Geocaching, ein Schatzsuche-Spiel. Mittels GPS-Koordinaten sind Behälter oder Objekte zu finden.'; |
@@ -98,12 +98,12 @@ discard block |
||
98 | 98 | // see also setting in lib/settings.inc.php! |
99 | 99 | $opt['logic']['admin']['team_comments_only_for_reports'] = true; |
100 | 100 | $opt['logic']['admin']['enable_listing_admins'] = false; |
101 | -$opt['logic']['admin']['listingadmin_notification'] = ''; // Email address(es), comma separated |
|
101 | +$opt['logic']['admin']['listingadmin_notification'] = ''; // Email address(es), comma separated |
|
102 | 102 | |
103 | 103 | /* |
104 | 104 | * html purifier |
105 | 105 | */ |
106 | -$opt['html_purifier']['cache_path'] = dirname(__FILE__) . '/../cache2/html_purifier/'; |
|
106 | +$opt['html_purifier']['cache_path'] = dirname(__FILE__).'/../cache2/html_purifier/'; |
|
107 | 107 | |
108 | 108 | /* |
109 | 109 | * CMS links for external pages |
@@ -178,9 +178,9 @@ discard block |
||
178 | 178 | $primary_httpsdefault = $opt['page']['https']['is_default']; |
179 | 179 | } |
180 | 180 | if ($primary_httpsdefault) { |
181 | - $opt['page']['default_primary_url'] = 'https' . strstr($primary_site_url, '://'); |
|
181 | + $opt['page']['default_primary_url'] = 'https'.strstr($primary_site_url, '://'); |
|
182 | 182 | } else { |
183 | - $opt['page']['default_primary_url'] = 'http' . strstr($primary_site_url, '://'); |
|
183 | + $opt['page']['default_primary_url'] = 'http'.strstr($primary_site_url, '://'); |
|
184 | 184 | } |
185 | 185 | |
186 | 186 | // 2. create settings for the current domain |
@@ -191,7 +191,7 @@ discard block |
||
191 | 191 | if (isset($opt['domain'][$current_domain]['url'])) { |
192 | 192 | $current_site_url = $opt['domain'][$current_domain]['url']; |
193 | 193 | } else { |
194 | - $current_site_url = 'x://' . $current_domain . parse_url($primary_site_url, PHP_URL_PATH); |
|
194 | + $current_site_url = 'x://'.$current_domain.parse_url($primary_site_url, PHP_URL_PATH); |
|
195 | 195 | } |
196 | 196 | if (substr($current_site_url, - 1, 1) != '/') { |
197 | 197 | $current_site_url .= '/'; |
@@ -203,8 +203,8 @@ discard block |
||
203 | 203 | } |
204 | 204 | |
205 | 205 | $adr = strstr($current_site_url, '://'); |
206 | - $opt['page']['absolute_http_url'] = 'http' . $adr; |
|
207 | - $opt['page']['absolute_https_url'] = 'https' . $adr; |
|
206 | + $opt['page']['absolute_http_url'] = 'http'.$adr; |
|
207 | + $opt['page']['absolute_https_url'] = 'https'.$adr; |
|
208 | 208 | $opt['page']['https']['active'] = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off'); |
209 | 209 | |
210 | 210 | if ($opt['page']['https']['active']) { |
@@ -235,19 +235,19 @@ discard block |
||
235 | 235 | $opt['page']['default_primary_shortlink_url'] = false; |
236 | 236 | } else { |
237 | 237 | if ($primary_httpsdefault) { |
238 | - $opt['page']['default_primary_shortlink_url'] = 'https://' . $primary_shortlink_domain . '/'; |
|
238 | + $opt['page']['default_primary_shortlink_url'] = 'https://'.$primary_shortlink_domain.'/'; |
|
239 | 239 | } else { |
240 | - $opt['page']['default_primary_shortlink_url'] = 'http://' . $primary_shortlink_domain . '/'; |
|
240 | + $opt['page']['default_primary_shortlink_url'] = 'http://'.$primary_shortlink_domain.'/'; |
|
241 | 241 | } |
242 | 242 | |
243 | 243 | if (isset($opt['domain'][$current_domain]['shortlink_domain']) && $opt['domain'][$current_domain]['shortlink_domain']) { |
244 | - $opt['page']['shortlink_url'] = $opt['page']['protocol'] . '://' . $opt['domain'][$current_domain]['shortlink_domain'] . '/'; |
|
245 | - $opt['page']['default_shortlink_url'] = $opt['page']['default_protocol'] . '://' . $opt['domain'][$current_domain]['shortlink_domain'] . '/'; |
|
244 | + $opt['page']['shortlink_url'] = $opt['page']['protocol'].'://'.$opt['domain'][$current_domain]['shortlink_domain'].'/'; |
|
245 | + $opt['page']['default_shortlink_url'] = $opt['page']['default_protocol'].'://'.$opt['domain'][$current_domain]['shortlink_domain'].'/'; |
|
246 | 246 | } else { |
247 | 247 | if ($current_domain == $primary_domain) { |
248 | 248 | $opt['page']['default_shortlink_url'] = $opt['page']['default_primary_shortlink_url']; |
249 | 249 | $opt['page']['shortlink_url'] = |
250 | - $opt['page']['protocol'] . strstr($opt['page']['default_shortlink_url'], '://'); |
|
250 | + $opt['page']['protocol'].strstr($opt['page']['default_shortlink_url'], '://'); |
|
251 | 251 | } else { |
252 | 252 | $opt['page']['shortlink_url'] = false; |
253 | 253 | $opt['page']['default_shortlink_url'] = false; |
@@ -258,16 +258,16 @@ discard block |
||
258 | 258 | // 4. set location of uploaded images |
259 | 259 | |
260 | 260 | if (!isset($opt['logic']['pictures']['dir'])) { |
261 | - $opt['logic']['pictures']['dir'] = dirname(__FILE__) . '/../images/uploads'; |
|
261 | + $opt['logic']['pictures']['dir'] = dirname(__FILE__).'/../images/uploads'; |
|
262 | 262 | } // Ocprop, OKAPI ! |
263 | 263 | if (!isset($opt['logic']['pictures']['url'])) { |
264 | - $opt['logic']['pictures']['url'] = $opt['page']['default_primary_url'] . 'images/uploads'; |
|
264 | + $opt['logic']['pictures']['url'] = $opt['page']['default_primary_url'].'images/uploads'; |
|
265 | 265 | } |
266 | 266 | if (!isset($opt['logic']['pictures']['thumb_dir'])) { |
267 | - $opt['logic']['pictures']['thumb_dir'] = $opt['logic']['pictures']['dir'] . '/thumbs'; |
|
267 | + $opt['logic']['pictures']['thumb_dir'] = $opt['logic']['pictures']['dir'].'/thumbs'; |
|
268 | 268 | } |
269 | 269 | if (!isset($opt['logic']['pictures']['thumb_url'])) { |
270 | - $opt['logic']['pictures']['thumb_url'] = $opt['logic']['pictures']['url'] . '/thumbs'; |
|
270 | + $opt['logic']['pictures']['thumb_url'] = $opt['logic']['pictures']['url'].'/thumbs'; |
|
271 | 271 | } |
272 | 272 | } |
273 | 273 |
@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | |
10 | 10 | $build_map_towns_menu = true; |
11 | 11 | |
12 | -require __DIR__ . '/lib2/web.inc.php'; |
|
12 | +require __DIR__.'/lib2/web.inc.php'; |
|
13 | 13 | |
14 | 14 | /* because the map does access some private info like |
15 | 15 | * ignored caches, we need to verify the login data |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | WHERE option_id=6 AND user_id='&1'", true, $login->userid)) |
68 | 68 | ) { |
69 | 69 | $fullscreen = true; |
70 | - $tpl->popup = true; // disables page header and -frame |
|
70 | + $tpl->popup = true; // disables page header and -frame |
|
71 | 71 | $tpl->popupmargin = false; |
72 | 72 | } else { |
73 | 73 | $fullscreen = false; |
@@ -133,7 +133,7 @@ discard block |
||
133 | 133 | $tpl->error($translate->t('There is no google maps key registered for this domain.', '', '', 0)); |
134 | 134 | } |
135 | 135 | |
136 | -$tpl->add_header_javascript($opt['page']['protocol'] . '://maps.googleapis.com/maps/api/js?sensor=false&key=' . urlencode($sGMKey) . '&language=' . strtolower($opt['template']['locale'])); |
|
136 | +$tpl->add_header_javascript($opt['page']['protocol'].'://maps.googleapis.com/maps/api/js?sensor=false&key='.urlencode($sGMKey).'&language='.strtolower($opt['template']['locale'])); |
|
137 | 137 | // https is supported by google, but may make problems in some environments, |
138 | 138 | // e.g. does not work with MSIE 7 on WinXP |
139 | 139 | $tpl->add_header_javascript('resource2/misc/map/dragzoom_packed.js'); |
@@ -279,7 +279,7 @@ discard block |
||
279 | 279 | global $login; |
280 | 280 | |
281 | 281 | $rsCache = sql_slave( |
282 | - "SELECT " . geomath::getSqlDistanceFormula($nLon, $nLat, $nDistance) . " AS `distance`, |
|
282 | + "SELECT ".geomath::getSqlDistanceFormula($nLon, $nLat, $nDistance)." AS `distance`, |
|
283 | 283 | `caches`.`wp_oc` |
284 | 284 | FROM `caches` |
285 | 285 | INNER JOIN `cache_status` ON `caches`.`status`=`cache_status`.`id` |
@@ -389,42 +389,42 @@ discard block |
||
389 | 389 | $wphandler = new HandlerChildWp(); |
390 | 390 | $waypoints = $wphandler->getChildWps($rCache['cache_id'], true); |
391 | 391 | |
392 | - echo '<caches>' . "\n"; |
|
392 | + echo '<caches>'."\n"; |
|
393 | 393 | echo ' <cache '; |
394 | - echo 'name="' . xmlentities($rCache['name']) . '" '; |
|
395 | - echo 'wpoc="' . xmlentities($rCache['wp_oc']) . '" '; |
|
396 | - echo 'coords="' . $rCache['longitude'] . ',' . $rCache['latitude'] . '" '; |
|
397 | - echo 'inactive="' . xmlentities($rCache['inactive']) . '" '; |
|
398 | - echo 'status_text="' . xmlentities($rCache['statustext']) . '" '; |
|
399 | - echo 'type_id="' . xmlentities($rCache['type_id']) . '" '; |
|
400 | - echo 'type_text="' . xmlentities($rCache['type_text']) . '" '; |
|
401 | - echo 'size="' . xmlentities($rCache['size']) . '" '; |
|
402 | - echo 'difficulty="' . xmlentities($rCache['difficulty'] / 2) . '" '; |
|
403 | - echo 'terrain="' . xmlentities($rCache['terrain'] / 2) . '" '; |
|
404 | - echo 'listed_since="' . xmlentities(strftime($opt['locale'][$opt['template']['locale']]['format']['date'], strtotime($rCache['date_created']))) . '" '; |
|
405 | - echo 'is_publishdate="' . xmlentities($rCache['is_publishdate']) . '" '; |
|
406 | - echo 'toprating="' . xmlentities($rCache['toprating']) . '" '; |
|
407 | - echo 'geokreties="' . xmlentities($nGeokretyCount) . '" '; |
|
408 | - echo 'found="' . xmlentities(($nFoundCount > 0) ? 1 : 0) . '" '; |
|
409 | - echo 'notfound="' . xmlentities(($nNotFoundCount > 0) ? 1 : 0) . '" '; |
|
410 | - echo 'attended="' . xmlentities(($nAttendedCount > 0) ? 1 : 0) . '" '; |
|
411 | - echo 'oconly="' . xmlentities($rCache['oconly']) . '" '; |
|
412 | - echo 'owner="' . xmlentities($rCache['owner']) . '" '; |
|
413 | - echo 'username="' . xmlentities($rCache['username']) . '" '; |
|
414 | - echo 'userid="' . xmlentities($rCache['user_id']) . '" '; |
|
415 | - echo 'picurl="' . xmlentities($rCache['picurl']) . '" '; |
|
416 | - echo 'pictitle="' . xmlentities(trim($rCache['pictitle'])) . '" >\n'; |
|
394 | + echo 'name="'.xmlentities($rCache['name']).'" '; |
|
395 | + echo 'wpoc="'.xmlentities($rCache['wp_oc']).'" '; |
|
396 | + echo 'coords="'.$rCache['longitude'].','.$rCache['latitude'].'" '; |
|
397 | + echo 'inactive="'.xmlentities($rCache['inactive']).'" '; |
|
398 | + echo 'status_text="'.xmlentities($rCache['statustext']).'" '; |
|
399 | + echo 'type_id="'.xmlentities($rCache['type_id']).'" '; |
|
400 | + echo 'type_text="'.xmlentities($rCache['type_text']).'" '; |
|
401 | + echo 'size="'.xmlentities($rCache['size']).'" '; |
|
402 | + echo 'difficulty="'.xmlentities($rCache['difficulty'] / 2).'" '; |
|
403 | + echo 'terrain="'.xmlentities($rCache['terrain'] / 2).'" '; |
|
404 | + echo 'listed_since="'.xmlentities(strftime($opt['locale'][$opt['template']['locale']]['format']['date'], strtotime($rCache['date_created']))).'" '; |
|
405 | + echo 'is_publishdate="'.xmlentities($rCache['is_publishdate']).'" '; |
|
406 | + echo 'toprating="'.xmlentities($rCache['toprating']).'" '; |
|
407 | + echo 'geokreties="'.xmlentities($nGeokretyCount).'" '; |
|
408 | + echo 'found="'.xmlentities(($nFoundCount > 0) ? 1 : 0).'" '; |
|
409 | + echo 'notfound="'.xmlentities(($nNotFoundCount > 0) ? 1 : 0).'" '; |
|
410 | + echo 'attended="'.xmlentities(($nAttendedCount > 0) ? 1 : 0).'" '; |
|
411 | + echo 'oconly="'.xmlentities($rCache['oconly']).'" '; |
|
412 | + echo 'owner="'.xmlentities($rCache['owner']).'" '; |
|
413 | + echo 'username="'.xmlentities($rCache['username']).'" '; |
|
414 | + echo 'userid="'.xmlentities($rCache['user_id']).'" '; |
|
415 | + echo 'picurl="'.xmlentities($rCache['picurl']).'" '; |
|
416 | + echo 'pictitle="'.xmlentities(trim($rCache['pictitle'])).'" >\n'; |
|
417 | 417 | |
418 | 418 | foreach ($waypoints as $waypoint) { |
419 | 419 | echo ' <wpt '; |
420 | - echo 'typeid="' . xmlentities($waypoint['type']) . '" '; |
|
421 | - echo 'typename="' . xmlentities($waypoint['name']) . '" '; |
|
422 | - echo 'typepreposition="' . xmlentities($waypoint['preposition']) . '" '; |
|
423 | - echo 'image="' . xmlentities($waypoint['image']) . '" '; |
|
420 | + echo 'typeid="'.xmlentities($waypoint['type']).'" '; |
|
421 | + echo 'typename="'.xmlentities($waypoint['name']).'" '; |
|
422 | + echo 'typepreposition="'.xmlentities($waypoint['preposition']).'" '; |
|
423 | + echo 'image="'.xmlentities($waypoint['image']).'" '; |
|
424 | 424 | echo 'imagewidth="38" imageheight="38" '; |
425 | - echo 'latitude="' . xmlentities($waypoint['latitude']) . '" '; |
|
426 | - echo 'longitude="' . xmlentities($waypoint['longitude']) . '" '; |
|
427 | - echo 'description="' . xmlentities(mb_ereg_replace('\r\n', '<br />', htmlentities(trim($waypoint['description']), ENT_NOQUOTES, 'UTF-8'))) . '" />\n'; |
|
425 | + echo 'latitude="'.xmlentities($waypoint['latitude']).'" '; |
|
426 | + echo 'longitude="'.xmlentities($waypoint['longitude']).'" '; |
|
427 | + echo 'description="'.xmlentities(mb_ereg_replace('\r\n', '<br />', htmlentities(trim($waypoint['description']), ENT_NOQUOTES, 'UTF-8'))).'" />\n'; |
|
428 | 428 | } |
429 | 429 | |
430 | 430 | echo ' </cache>\n'; |
@@ -438,9 +438,9 @@ discard block |
||
438 | 438 | { |
439 | 439 | global $login, $opt; |
440 | 440 | |
441 | - echo '<caches>' . "\n"; |
|
441 | + echo '<caches>'."\n"; |
|
442 | 442 | $rs = sql_slave( |
443 | - "SELECT " . geomath::getSqlDistanceFormula($nLon, $nLat, 0) . " AS `distance`, |
|
443 | + "SELECT ".geomath::getSqlDistanceFormula($nLon, $nLat, 0)." AS `distance`, |
|
444 | 444 | `caches`.`name`, `caches`.`wp_oc` |
445 | 445 | FROM `map2_data` |
446 | 446 | INNER JOIN `caches` ON `map2_data`.`cache_id`=`caches`.`cache_id` |
@@ -449,30 +449,30 @@ discard block |
||
449 | 449 | AND (`cache_status`.`allow_user_view`=1 OR `caches`.`user_id`='&3') |
450 | 450 | AND `map2_data`.`result_id`='&2' |
451 | 451 | ORDER BY `distance` ASC LIMIT 30", |
452 | - '%' . $sName . '%', |
|
452 | + '%'.$sName.'%', |
|
453 | 453 | $nResultId, |
454 | 454 | $login->userid |
455 | 455 | ); |
456 | 456 | $caches_found = 0; |
457 | 457 | while ($r = sql_fetch_assoc($rs)) { |
458 | - echo '<cache name="' . xmlentities($r['name']) . '" wpoc="' . xmlentities($r['wp_oc']) . '" />' . "\n"; |
|
459 | - ++ $caches_found; |
|
458 | + echo '<cache name="'.xmlentities($r['name']).'" wpoc="'.xmlentities($r['wp_oc']).'" />'."\n"; |
|
459 | + ++$caches_found; |
|
460 | 460 | } |
461 | 461 | sql_free_result($rs); |
462 | 462 | |
463 | 463 | if (!$caches_found && preg_match('/^[^\s[:punct:]]{2,}\.[^\s[:punct:]]{2,}\.[^\s[:punct:]]{2,}$/', $sName)) { |
464 | - $result = @file_get_contents('http://api.what3words.com/w3w?key=' . $opt['lib']['w3w']['apikey'] |
|
465 | - . '&string=' . urlencode($sName)); |
|
464 | + $result = @file_get_contents('http://api.what3words.com/w3w?key='.$opt['lib']['w3w']['apikey'] |
|
465 | + . '&string='.urlencode($sName)); |
|
466 | 466 | if ($result) { |
467 | 467 | $json = json_decode($result, true); |
468 | 468 | if (!is_null($json['words']) && !is_null($json['position']) && count($json['position']) == 2) { |
469 | - echo '<coord name="' . xmlentities(implode('.', $json['words'])) . |
|
470 | - '" latitude="' . xmlentities($json["position"][0]) . |
|
471 | - '" longitude="' . xmlentities($json["position"][1]) . '" />' . "\n"; |
|
469 | + echo '<coord name="'.xmlentities(implode('.', $json['words'])). |
|
470 | + '" latitude="'.xmlentities($json["position"][0]). |
|
471 | + '" longitude="'.xmlentities($json["position"][1]).'" />'."\n"; |
|
472 | 472 | } |
473 | 473 | } |
474 | 474 | } |
475 | - echo '</caches>' . "\n"; |
|
475 | + echo '</caches>'."\n"; |
|
476 | 476 | |
477 | 477 | exit; |
478 | 478 | } |
@@ -495,7 +495,7 @@ discard block |
||
495 | 495 | "SELECT `slave_id` |
496 | 496 | FROM `map2_result` |
497 | 497 | WHERE `result_id`='&1' AND DATE_ADD(`date_created`, INTERVAL '&2' SECOND)>NOW()", |
498 | - - 2, |
|
498 | + -2, |
|
499 | 499 | $nResultId, |
500 | 500 | $opt['map']['maxcacheage'] |
501 | 501 | ); |
@@ -561,8 +561,8 @@ discard block |
||
561 | 561 | $bMaxRecordReached = ($nRecordCount > $maxrecords); |
562 | 562 | |
563 | 563 | // output data |
564 | - echo '<searchresult count="' . xmlentities($nRecordCount) . '" available="1"' . |
|
565 | - ' maxrecordreached="' . ($bMaxRecordReached ? '1' : '0') . '">' . "\n"; |
|
564 | + echo '<searchresult count="'.xmlentities($nRecordCount).'" available="1"'. |
|
565 | + ' maxrecordreached="'.($bMaxRecordReached ? '1' : '0').'">'."\n"; |
|
566 | 566 | |
567 | 567 | if (!$bMaxRecordReached) { |
568 | 568 | $namequery = ($cachenames ? ", `caches`.`name` AS `cachename`" : ""); |
@@ -577,7 +577,7 @@ discard block |
||
577 | 577 | IF(`found_logs`.`id` IS NULL, 0, 1) AS `found`, |
578 | 578 | IF(`found_logs`.`id` IS NULL AND `notfound_logs`.`id` IS NOT NULL, 1, 0) AS `notfound`, |
579 | 579 | IF(`caches_attributes`.`attrib_id` IS NULL, 0, 1) AS `oconly`" . |
580 | - $namequery . " |
|
580 | + $namequery." |
|
581 | 581 | FROM `map2_data` |
582 | 582 | INNER JOIN `caches` ON `map2_data`.`cache_id`=`caches`.`cache_id` |
583 | 583 | INNER JOIN `user` ON `user`.`user_id`=`caches`.`user_id` |
@@ -624,19 +624,19 @@ discard block |
||
624 | 624 | echo |
625 | 625 | '<c d="' |
626 | 626 | . xmlentities( |
627 | - $r['wp_oc'] . '/' . round($r['longitude'], 5) . '/' . |
|
628 | - round($r['latitude'], 5) . '/' . $r['type'] . '/' . $flags |
|
629 | - ) . '"' |
|
630 | - . (isset($r['cachename']) ? ' n="' . xmlentities($r['cachename']) . '"' : '') |
|
627 | + $r['wp_oc'].'/'.round($r['longitude'], 5).'/'. |
|
628 | + round($r['latitude'], 5).'/'.$r['type'].'/'.$flags |
|
629 | + ).'"' |
|
630 | + . (isset($r['cachename']) ? ' n="'.xmlentities($r['cachename']).'"' : '') |
|
631 | 631 | . ' />'; |
632 | 632 | } else { |
633 | 633 | echo |
634 | - '<cache wp="' . xmlentities($r['wp_oc']) . '"' . |
|
635 | - ' lon="' . xmlentities(round($r['longitude'], 5)) . '"' . |
|
636 | - ' lat="' . xmlentities(round($r['latitude'], 5)) . '"' . |
|
637 | - ' type="' . xmlentities($r['type']) . '"' . |
|
638 | - (isset($r['cachename']) ? ' n="' . xmlentities($r['cachename']) . '"' : '') . |
|
639 | - ' f="' . xmlentities($flags) . '" />' . "\n"; |
|
634 | + '<cache wp="'.xmlentities($r['wp_oc']).'"'. |
|
635 | + ' lon="'.xmlentities(round($r['longitude'], 5)).'"'. |
|
636 | + ' lat="'.xmlentities(round($r['latitude'], 5)).'"'. |
|
637 | + ' type="'.xmlentities($r['type']).'"'. |
|
638 | + (isset($r['cachename']) ? ' n="'.xmlentities($r['cachename']).'"' : ''). |
|
639 | + ' f="'.xmlentities($flags).'" />'."\n"; |
|
640 | 640 | } |
641 | 641 | } |
642 | 642 | sql_free_result($rs); |
@@ -27,12 +27,12 @@ discard block |
||
27 | 27 | * - Test mit aktuellem OC.de-Stand |
28 | 28 | ***************************************************************************/ |
29 | 29 | |
30 | -$rootpath = __DIR__ . '/../../htdocs/'; |
|
30 | +$rootpath = __DIR__.'/../../htdocs/'; |
|
31 | 31 | |
32 | 32 | // chdir to proper directory (needed for cronjobs) |
33 | 33 | chdir(substr(realpath($_SERVER['PHP_SELF']), 0, strrpos(realpath($_SERVER['PHP_SELF']), '/'))); |
34 | 34 | |
35 | -require_once $rootpath . 'lib/clicompatbase.inc.php'; |
|
35 | +require_once $rootpath.'lib/clicompatbase.inc.php'; |
|
36 | 36 | require_once 'xml2array.inc.php'; |
37 | 37 | require_once 'settings.php'; |
38 | 38 | |
@@ -67,16 +67,16 @@ discard block |
||
67 | 67 | $nFileNr = 0; |
68 | 68 | $rs = sql('SELECT `id`, `url` FROM `pictures` WHERE `local`=0'); |
69 | 69 | while ($r = sql_fetch_array($rs)) { |
70 | - $nFileNr ++; |
|
70 | + $nFileNr++; |
|
71 | 71 | $fileparts = mb_split('/', $r['url']); |
72 | 72 | $filename = $fileparts[count($fileparts) - 1]; |
73 | 73 | |
74 | - echo 'Downloading file ' . $nFileNr . ' of ' . $rCount['c'] . ': ' . $filename . "\n"; |
|
74 | + echo 'Downloading file '.$nFileNr.' of '.$rCount['c'].': '.$filename."\n"; |
|
75 | 75 | |
76 | 76 | $success = true; |
77 | - if (!file_exists($opt['pictures']['directory'] . $filename)) { |
|
78 | - if (!@copy($r['url'], $opt['pictures']['directory'] . $filename)) { |
|
79 | - echo 'error: Download nicht erfolgreich' . "\n"; |
|
77 | + if (!file_exists($opt['pictures']['directory'].$filename)) { |
|
78 | + if (!@copy($r['url'], $opt['pictures']['directory'].$filename)) { |
|
79 | + echo 'error: Download nicht erfolgreich'."\n"; |
|
80 | 80 | $success = false; |
81 | 81 | } |
82 | 82 | } |
@@ -84,7 +84,7 @@ discard block |
||
84 | 84 | if ($success == true) { |
85 | 85 | sql( |
86 | 86 | "UPDATE `pictures` SET `local`=1, `url`='&1' WHERE `id`='&2'", |
87 | - $opt['pictures']['url'] . $filename, |
|
87 | + $opt['pictures']['url'].$filename, |
|
88 | 88 | $r['id'] |
89 | 89 | ); |
90 | 90 | } |
@@ -196,7 +196,7 @@ discard block |
||
196 | 196 | |
197 | 197 | if ($opt['session'] == 1) { |
198 | 198 | // records abfragen |
199 | - $sessionfile = $opt['tmpdir'] . 'session.xml'; |
|
199 | + $sessionfile = $opt['tmpdir'].'session.xml'; |
|
200 | 200 | if (file_exists($sessionfile)) { |
201 | 201 | unlink($sessionfile); |
202 | 202 | } |
@@ -215,21 +215,21 @@ discard block |
||
215 | 215 | $recordscount += $session['OCXMLSESSION']['RECORDS']['PICTURE']; |
216 | 216 | $recordscount += $session['OCXMLSESSION']['RECORDS']['REMOVEOBJECT']; |
217 | 217 | |
218 | - echo 'Abruf seit ' . $lastUpdate . "\n"; |
|
218 | + echo 'Abruf seit '.$lastUpdate."\n"; |
|
219 | 219 | echo "------------------------\n"; |
220 | - echo 'Session-Id: ' . $sessionid . "\n"; |
|
221 | - echo 'User: ' . $session['OCXMLSESSION']['RECORDS']['USER'] . "\n"; |
|
222 | - echo 'Cache: ' . $session['OCXMLSESSION']['RECORDS']['CACHE'] . "\n"; |
|
223 | - echo 'Cachdesc: ' . $session['OCXMLSESSION']['RECORDS']['CACHEDESC'] . "\n"; |
|
224 | - echo 'Cachelog: ' . $session['OCXMLSESSION']['RECORDS']['CACHELOG'] . "\n"; |
|
225 | - echo 'Picture: ' . $session['OCXMLSESSION']['RECORDS']['PICTURE'] . "\n"; |
|
226 | - echo 'Removedobject: ' . $session['OCXMLSESSION']['RECORDS']['REMOVEOBJECT'] . "\n"; |
|
220 | + echo 'Session-Id: '.$sessionid."\n"; |
|
221 | + echo 'User: '.$session['OCXMLSESSION']['RECORDS']['USER']."\n"; |
|
222 | + echo 'Cache: '.$session['OCXMLSESSION']['RECORDS']['CACHE']."\n"; |
|
223 | + echo 'Cachdesc: '.$session['OCXMLSESSION']['RECORDS']['CACHEDESC']."\n"; |
|
224 | + echo 'Cachelog: '.$session['OCXMLSESSION']['RECORDS']['CACHELOG']."\n"; |
|
225 | + echo 'Picture: '.$session['OCXMLSESSION']['RECORDS']['PICTURE']."\n"; |
|
226 | + echo 'Removedobject: '.$session['OCXMLSESSION']['RECORDS']['REMOVEOBJECT']."\n"; |
|
227 | 227 | echo "------------------------\n"; |
228 | - echo 'Summe: ' . $recordscount . "\n"; |
|
228 | + echo 'Summe: '.$recordscount."\n"; |
|
229 | 229 | |
230 | 230 | $filescount = ($recordscount + (500 - $recordscount % 500)) / 500; |
231 | 231 | |
232 | - echo 'Anzahl der Pakete: ' . $filescount . "\n"; |
|
232 | + echo 'Anzahl der Pakete: '.$filescount."\n"; |
|
233 | 233 | echo "\n"; |
234 | 234 | |
235 | 235 | if ($recordscount == 0) { |
@@ -237,20 +237,20 @@ discard block |
||
237 | 237 | exit; |
238 | 238 | } |
239 | 239 | |
240 | - for ($i = 1; $i <= $filescount; $i ++) { |
|
241 | - echo "Download Paket: " . $i . ' von ' . $filescount . "\n"; |
|
240 | + for ($i = 1; $i <= $filescount; $i++) { |
|
241 | + echo "Download Paket: ".$i.' von '.$filescount."\n"; |
|
242 | 242 | |
243 | 243 | $fileurl = $opt['url_getsession']; |
244 | 244 | $fileurl = mb_ereg_replace('{sessionid}', $sessionid, $fileurl); |
245 | 245 | $fileurl = mb_ereg_replace('{file}', $i, $fileurl); |
246 | 246 | $fileurl = mb_ereg_replace('{zip}', $opt['zip'], $fileurl); |
247 | - $target = $opt['tmpdir'] . $sessionid . '-' . sprintf('%04d', $i) . $fileext; |
|
247 | + $target = $opt['tmpdir'].$sessionid.'-'.sprintf('%04d', $i).$fileext; |
|
248 | 248 | |
249 | 249 | copy($fileurl, $target); |
250 | 250 | } |
251 | 251 | } else { |
252 | - echo 'Download ...' . "\n"; |
|
253 | - $target = $opt['tmpdir'] . date('YmdHis') . $fileext; |
|
252 | + echo 'Download ...'."\n"; |
|
253 | + $target = $opt['tmpdir'].date('YmdHis').$fileext; |
|
254 | 254 | copy($url, $target); |
255 | 255 | } |
256 | 256 | } |
@@ -262,24 +262,24 @@ discard block |
||
262 | 262 | // alle zips entpacken |
263 | 263 | $hDir = opendir($opt['tmpdir']); |
264 | 264 | while (false !== ($file = readdir($hDir))) { |
265 | - if (is_file($opt['tmpdir'] . $file)) { |
|
265 | + if (is_file($opt['tmpdir'].$file)) { |
|
266 | 266 | $bCopy = false; |
267 | 267 | if (mb_substr($file, mb_strrpos($file, '.')) == '.zip') { |
268 | - echo 'Unzipping file ' . $file . "\n"; |
|
268 | + echo 'Unzipping file '.$file."\n"; |
|
269 | 269 | system( |
270 | - $opt['unzip'] . ' --type=zip --src="' . $opt['rel_tmpdir'] . '/' . $file . '" --dst="' . $opt['rel_tmpdir'] . '"' |
|
270 | + $opt['unzip'].' --type=zip --src="'.$opt['rel_tmpdir'].'/'.$file.'" --dst="'.$opt['rel_tmpdir'].'"' |
|
271 | 271 | ); |
272 | 272 | } else { |
273 | 273 | if (mb_substr($file, mb_strrpos($file, '.')) == '.gz') { |
274 | - echo 'Unzipping file ' . $file . "\n"; |
|
274 | + echo 'Unzipping file '.$file."\n"; |
|
275 | 275 | system( |
276 | - $opt['unzip'] . ' --type=gzip --src="' . $opt['rel_tmpdir'] . '/' . $file . '" --dst="' . $opt['rel_tmpdir'] . '"' |
|
276 | + $opt['unzip'].' --type=gzip --src="'.$opt['rel_tmpdir'].'/'.$file.'" --dst="'.$opt['rel_tmpdir'].'"' |
|
277 | 277 | ); |
278 | 278 | } else { |
279 | 279 | if (mb_substr($file, mb_strrpos($file, '.')) == '.bz2') { |
280 | - echo 'Unzipping file ' . $file . "\n"; |
|
280 | + echo 'Unzipping file '.$file."\n"; |
|
281 | 281 | system( |
282 | - $opt['unzip'] . ' --type=bzip2 --src="' . $opt['rel_tmpdir'] . '/' . $file . '" --dst="' . $opt['rel_tmpdir'] . '"' |
|
282 | + $opt['unzip'].' --type=bzip2 --src="'.$opt['rel_tmpdir'].'/'.$file.'" --dst="'.$opt['rel_tmpdir'].'"' |
|
283 | 283 | ); |
284 | 284 | } else { |
285 | 285 | if (mb_substr($file, mb_strrpos($file, '.')) == '.xml') { |
@@ -291,16 +291,16 @@ discard block |
||
291 | 291 | |
292 | 292 | // und jetzt die gezippte Datei verschieben |
293 | 293 | $archivdir = $opt['archivdir']; |
294 | - $archivdir .= $opt['curdb'] . '/'; |
|
294 | + $archivdir .= $opt['curdb'].'/'; |
|
295 | 295 | |
296 | 296 | if (!is_dir($archivdir)) { |
297 | 297 | mkdir($archivdir); |
298 | 298 | } |
299 | 299 | |
300 | 300 | if ($bCopy == true) { |
301 | - copy($opt['tmpdir'] . $file, $archivdir . '/' . $file); |
|
301 | + copy($opt['tmpdir'].$file, $archivdir.'/'.$file); |
|
302 | 302 | } else { |
303 | - rename($opt['tmpdir'] . $file, $archivdir . '/' . $file); |
|
303 | + rename($opt['tmpdir'].$file, $archivdir.'/'.$file); |
|
304 | 304 | } |
305 | 305 | } |
306 | 306 | } |
@@ -315,9 +315,9 @@ discard block |
||
315 | 315 | |
316 | 316 | $hDir = opendir($opt['tmpdir']); |
317 | 317 | while (false !== ($file = readdir($hDir))) { |
318 | - if (is_file($opt['tmpdir'] . $file)) { |
|
318 | + if (is_file($opt['tmpdir'].$file)) { |
|
319 | 319 | if ($file != '.cvsignore') { |
320 | - $files[] = $opt['tmpdir'] . $file; |
|
320 | + $files[] = $opt['tmpdir'].$file; |
|
321 | 321 | } |
322 | 322 | } |
323 | 323 | } |
@@ -331,7 +331,7 @@ discard block |
||
331 | 331 | |
332 | 332 | function importxmlfile($file) |
333 | 333 | { |
334 | - echo 'Importing file ' . $file . "\n"; |
|
334 | + echo 'Importing file '.$file."\n"; |
|
335 | 335 | |
336 | 336 | $xmlReader = new xmlReader(); |
337 | 337 | $xmlReader->open($file); |
@@ -411,11 +411,11 @@ discard block |
||
411 | 411 | if ($sSubElement != '') { |
412 | 412 | // vorheriges element zuerst schlißen |
413 | 413 | $sSubElement = ''; |
414 | - $nRecursionLevel --; |
|
414 | + $nRecursionLevel--; |
|
415 | 415 | } |
416 | 416 | |
417 | 417 | $sSubElement = mb_strtoupper($xmlReader->name); |
418 | - $nRecursionLevel ++; |
|
418 | + $nRecursionLevel++; |
|
419 | 419 | |
420 | 420 | // attribute auslesen |
421 | 421 | if ($xmlReader->moveToFirstAttribute()) { |
@@ -432,7 +432,7 @@ discard block |
||
432 | 432 | } else { |
433 | 433 | if ($xmlReader->nodeType == XMLReader::END_ELEMENT) { |
434 | 434 | $sSubElement = ''; |
435 | - $nRecursionLevel --; |
|
435 | + $nRecursionLevel--; |
|
436 | 436 | } |
437 | 437 | } |
438 | 438 | } |
@@ -459,7 +459,7 @@ discard block |
||
459 | 459 | ImportRemovedObjectArray($node['REMOVEDOBJECT']); |
460 | 460 | break; |
461 | 461 | default: |
462 | - echo 'Unknown Element "' . $xmlReader->name . '", skipping' . "\n"; |
|
462 | + echo 'Unknown Element "'.$xmlReader->name.'", skipping'."\n"; |
|
463 | 463 | break; |
464 | 464 | } |
465 | 465 | } |
@@ -481,9 +481,9 @@ discard block |
||
481 | 481 | |
482 | 482 | $hDir = opendir($opt['tmpdir']); |
483 | 483 | while (false !== ($file = readdir($hDir))) { |
484 | - if (is_file($opt['tmpdir'] . $file)) { |
|
484 | + if (is_file($opt['tmpdir'].$file)) { |
|
485 | 485 | if ($file != '.cvsignore') { |
486 | - unlink($opt['tmpdir'] . $file); |
|
486 | + unlink($opt['tmpdir'].$file); |
|
487 | 487 | } |
488 | 488 | } |
489 | 489 | } |
@@ -501,14 +501,14 @@ discard block |
||
501 | 501 | // andere DB connecten? |
502 | 502 | if (mb_substr($arg, 0, 5) == '--db=') { |
503 | 503 | if (!is_numeric(mb_substr($arg, 5))) { |
504 | - die('invalid alternative DB' . "\n"); |
|
504 | + die('invalid alternative DB'."\n"); |
|
505 | 505 | } |
506 | 506 | |
507 | 507 | $nDb = mb_substr($arg, 5); |
508 | 508 | |
509 | 509 | if ($nDb != 0) { |
510 | 510 | if (!isset($opt['db'][$nDb])) { |
511 | - die('invalid alternative DB' . "\n"); |
|
511 | + die('invalid alternative DB'."\n"); |
|
512 | 512 | } |
513 | 513 | |
514 | 514 | mysql_close($dblink); |
@@ -517,7 +517,7 @@ discard block |
||
517 | 517 | sql("SET NAMES 'utf8'"); |
518 | 518 | sql('USE `&1`', $opt['db'][1]['name']); |
519 | 519 | } else { |
520 | - die('Connect to alternative DB failed' . "\n"); |
|
520 | + die('Connect to alternative DB failed'."\n"); |
|
521 | 521 | } |
522 | 522 | |
523 | 523 | $opt['curdb'] = $nDb; |
@@ -531,7 +531,7 @@ discard block |
||
531 | 531 | sql("SET NAMES 'utf8'"); |
532 | 532 | sql('USE `&1`', $dbname); |
533 | 533 | } else { |
534 | - die('Connect to alternative DB failed' . "\n"); |
|
534 | + die('Connect to alternative DB failed'."\n"); |
|
535 | 535 | } |
536 | 536 | } |
537 | 537 | } |
@@ -544,7 +544,7 @@ discard block |
||
544 | 544 | !isset($r['USERNAME']['__DATA']) || |
545 | 545 | !isset($r['LASTMODIFIED']['__DATA']) |
546 | 546 | ) { |
547 | - echo 'warn: ImportUserArray required element not defined' . "\n"; |
|
547 | + echo 'warn: ImportUserArray required element not defined'."\n"; |
|
548 | 548 | |
549 | 549 | return; |
550 | 550 | } |
@@ -637,7 +637,7 @@ discard block |
||
637 | 637 | !isset($r['DATECREATED']['__DATA']) || |
638 | 638 | !isset($r['LASTMODIFIED']['__DATA']) |
639 | 639 | ) { |
640 | - echo 'warn: ImportCacheArray required element not defined' . "\n"; |
|
640 | + echo 'warn: ImportCacheArray required element not defined'."\n"; |
|
641 | 641 | |
642 | 642 | return; |
643 | 643 | } |
@@ -807,7 +807,7 @@ discard block |
||
807 | 807 | !isset($r['LANGUAGE']['__ATTR']['ID']) || |
808 | 808 | !isset($r['LASTMODIFIED']['__DATA']) |
809 | 809 | ) { |
810 | - echo 'error: ImportCacheDescArray required element not defined' . "\n"; |
|
810 | + echo 'error: ImportCacheDescArray required element not defined'."\n"; |
|
811 | 811 | |
812 | 812 | return; |
813 | 813 | } |
@@ -964,7 +964,7 @@ discard block |
||
964 | 964 | !isset($r['DATECREATED']['__DATA']) || |
965 | 965 | !isset($r['LASTMODIFIED']['__DATA']) |
966 | 966 | ) { |
967 | - echo 'error: ImportCachelogArray required element not defined' . "\n"; |
|
967 | + echo 'error: ImportCachelogArray required element not defined'."\n"; |
|
968 | 968 | |
969 | 969 | return; |
970 | 970 | } |
@@ -995,7 +995,7 @@ discard block |
||
995 | 995 | |
996 | 996 | // logtype gültig? |
997 | 997 | if (sqlValue( |
998 | - "SELECT COUNT(*) FROM `log_types` WHERE `id`='" . sql_escape($r['LOGTYPE']['__ATTR']['ID']) . "'", |
|
998 | + "SELECT COUNT(*) FROM `log_types` WHERE `id`='".sql_escape($r['LOGTYPE']['__ATTR']['ID'])."'", |
|
999 | 999 | 0 |
1000 | 1000 | ) == 0) { |
1001 | 1001 | importError('cachelog', $r['ID']['__DATA'], $r, 'Logtype not valid, skipping'); |
@@ -1068,7 +1068,7 @@ discard block |
||
1068 | 1068 | !isset($r['DATECREATED']['__DATA']) || |
1069 | 1069 | !isset($r['LASTMODIFIED']['__DATA']) |
1070 | 1070 | ) { |
1071 | - echo 'error: ImportPictureArray required element not defined ' . "\n"; |
|
1071 | + echo 'error: ImportPictureArray required element not defined '."\n"; |
|
1072 | 1072 | |
1073 | 1073 | return; |
1074 | 1074 | } |
@@ -1169,7 +1169,7 @@ discard block |
||
1169 | 1169 | !isset($r['OBJECT']['__DATA']) || |
1170 | 1170 | !isset($r['REMOVEDDATE']['__DATA']) |
1171 | 1171 | ) { |
1172 | - echo 'error: ImportRemovedObjectArray required element not defined' . "\n"; |
|
1172 | + echo 'error: ImportRemovedObjectArray required element not defined'."\n"; |
|
1173 | 1173 | |
1174 | 1174 | return; |
1175 | 1175 | } |
@@ -1281,12 +1281,12 @@ discard block |
||
1281 | 1281 | |
1282 | 1282 | function importError($recordtype, $uuid, $r, $info) |
1283 | 1283 | { |
1284 | - echo 'error: ' . $recordtype . ' (' . $uuid . '): ' . $info . "\n"; |
|
1284 | + echo 'error: '.$recordtype.' ('.$uuid.'): '.$info."\n"; |
|
1285 | 1285 | } |
1286 | 1286 | |
1287 | 1287 | function importWarn($recordtype, $uuid, $r, $info) |
1288 | 1288 | { |
1289 | - echo 'warn: ' . $recordtype . ' (' . $uuid . '): ' . $info . "\n"; |
|
1289 | + echo 'warn: '.$recordtype.' ('.$uuid.'): '.$info."\n"; |
|
1290 | 1290 | } |
1291 | 1291 | |
1292 | 1292 | function restorevalues() |
@@ -9,15 +9,15 @@ discard block |
||
9 | 9 | * Unicode Reminder メモ |
10 | 10 | ***************************************************************************/ |
11 | 11 | |
12 | -$opt['rootpath'] = __DIR__ . '/../../htdocs/'; |
|
13 | -require $opt['rootpath'] . 'lib2/cli.inc.php'; |
|
12 | +$opt['rootpath'] = __DIR__.'/../../htdocs/'; |
|
13 | +require $opt['rootpath'].'lib2/cli.inc.php'; |
|
14 | 14 | |
15 | 15 | if (!($opt['debug'] & DEBUG_DEVELOPER)) { |
16 | 16 | die("This script deletes lot of data and must be run only on development systems.\n"); |
17 | 17 | } |
18 | 18 | if ($argc != 2 || $argv[1] != 'go') { |
19 | 19 | die( |
20 | - "This script deletes lot of data. Make sure that you really want to dos this,\n" . |
|
20 | + "This script deletes lot of data. Make sure that you really want to dos this,\n". |
|
21 | 21 | "and confirm it by adding the parameter 'go'.\n" |
22 | 22 | ); |
23 | 23 | } |
@@ -63,11 +63,11 @@ discard block |
||
63 | 63 | echo "clearing user data\n"; |
64 | 64 | sql('TRUNCATE `cache_adoption`'); |
65 | 65 | sql('TRUNCATE `cache_ignore`'); |
66 | -sql('DELETE FROM `cache_lists` WHERE `is_public`<2'); // trigger deletes dependent data |
|
66 | +sql('DELETE FROM `cache_lists` WHERE `is_public`<2'); // trigger deletes dependent data |
|
67 | 67 | sql('TRUNCATE `cache_list_bookmarks`'); |
68 | 68 | sql('TRUNCATE `cache_list_watches`'); |
69 | 69 | sql('TRUNCATE `cache_watches`'); |
70 | -sql('DELETE FROM `coordinates` WHERE `type`=2'); // personal cache notes and coords |
|
70 | +sql('DELETE FROM `coordinates` WHERE `type`=2'); // personal cache notes and coords |
|
71 | 71 | sql('TRUNCATE `queries`'); |
72 | 72 | sql('TRUNCATE `user_options`'); |
73 | 73 | sql( |
@@ -132,10 +132,10 @@ discard block |
||
132 | 132 | |
133 | 133 | echo "clearing other nonpublic data\n"; |
134 | 134 | sql('TRUNCATE `news`'); |
135 | -$rs = sql("SHOW TABLES WHERE `Tables_in_" . $opt['db']['placeholder']['db'] . "` LIKE '\_%'"); |
|
135 | +$rs = sql("SHOW TABLES WHERE `Tables_in_".$opt['db']['placeholder']['db']."` LIKE '\_%'"); |
|
136 | 136 | $tables = sql_fetch_column($rs); |
137 | 137 | foreach ($tables as $table) { |
138 | - sql('DROP TABLE ' . $table); |
|
138 | + sql('DROP TABLE '.$table); |
|
139 | 139 | } |
140 | 140 | |
141 | 141 | echo "done.\n"; |