if (file_exists($flagfile)) { $desclanguageCountry = $opt['locale'][$desclanguage]['country']; } } $rCache['desclanguageCountries'][$desclanguage] = $desclanguageCountry; } $rCache['sizeName'] = labels::getLabelValue('cache_size', $rCache['size']); $rCache['statusName'] = labels::getLabelValue('cache_status', $rCache['status']); $rCache['typeName'] = labels::getLabelValue('cache_type', $rCache['type']); $rCache['userhasfound'] = false; if ($login->userid != 0) { $rCache['userhasfound'] = sql_value("SELECT COUNT(*) FROM `cache_logs` WHERE `cache_id`='&1' AND `user_id`='&2' AND `type` IN (1,7)", 0, $cacheid, $login->userid) > 0; } $tpl->assign('cache', $rCache); $tpl->title = $rCache['wpoc'] . ' ' . $rCache['name']; $coord = new coordinate($rCache['latitude'], $rCache['longitude']); $tpl->assign('coordinates', $coord->getDecimalMinutes()); // podcasts $rs = sql("SELECT `uuid`, `title`, `url` FROM `mp3` WHERE `object_id`='&1' ORDER BY date_created", $cacheid); $tpl->assign_rs('podcasts', $rs); sql_free_result($rs); // pictures $rs = sql("SELECT `id`, `uuid`, `url`, `title`, `thumb_url`, `spoiler`, `display` FROM `pictures` WHERE `object_type`=2 AND `object_id`='&1' AND `display`!=0 ORDER BY `date_created`", $cacheid); $tpl->assign_rs('pictures', $rs); sql_free_result($rs); $tpl->assign('childWaypoints', getChildWaypoints($cacheid)); if ($login->userid != 0) { $cacheNotePresenter = new CacheNote_Presenter(new Http_Request(), new Language_Translator()); $cacheNotePresenter->init(new CacheNote_Handler(), $login->userid, $cacheid); if (isset($_POST['submit_cache_note']) && $cacheNotePresenter->validate()) { $cacheNotePresenter->doSubmit();
* Unicode Reminder メモ ***************************************************************************/ require __DIR__ . '/lib2/web.inc.php'; $tpl->name = 'coordinates'; $tpl->popup = true; $lat_float = 0; if (isset($_REQUEST['lat'])) { $lat_float += $_REQUEST['lat']; } $lon_float = 0; if (isset($_REQUEST['lon'])) { $lon_float += $_REQUEST['lon']; } $cache_country = isset($_REQUEST['country']) ? $_REQUEST['country'] : false; $cache_desclang = isset($_REQUEST['desclang']) ? $_REQUEST['desclang'] : false; $coord = new coordinate($lat_float, $lon_float); $tpl->assign('coordDeg', $coord->getDecimal()); $tpl->assign('coordDegMin', $coord->getDecimalMinutes()); $tpl->assign('coordDegMinSec', $coord->getDecimalMinutesSeconds()); $tpl->assign('coordUTM', $coord->getUTM()); $tpl->assign('coordGK', $coord->getGK()); $tpl->assign('coordRD', $coord->getRD()); $tpl->assign('showRD', $coord->nLat >= 45 && $coord->nLat <= 57 && $coord->nLon >= 0 && $coord->nLon <= 15); $tpl->assign('coordQTH', $coord->getQTH()); $tpl->assign('coordSwissGrid', $coord->getSwissGrid()); // build priority list of W3W languages to display // 1. current page locale $w3w_langs = array(); if ($opt['locale'][$opt['template']['locale']]['what3words']) { $w3w_langs[] = $opt['template']['locale']; }
function setTplHistoryData($exclude_report_id) { global $opt, $tpl; // (other) reports for this cache $rs = sql("SELECT `cr`.`id`, `cr`.`date_created`, `cr`.`lastmodified`,\n\t\t `cr`.`userid`, `cr`.`adminid`,\n\t\t\t\t `users`.`username` AS `usernick`,\n\t\t\t\t `admins`.`username` AS `adminnick`,\n\t\t\t\t\t\t\t\t\t\t\tIFNULL(`tt`.`text`, `crs`.`name`) AS `status`,\n\t\t\t\t IFNULL(`tt2`.`text`, `crr`.`name`) AS `reason`\n\t\t\t\t FROM `cache_reports` AS `cr`\n\t\t\t\t LEFT JOIN `cache_report_reasons` AS `crr` ON `cr`.`reason`=`crr`.`id`\n\t\t\t LEFT JOIN `user` AS `users` ON `users`.`user_id`=`cr`.`userid`\n\t\t\t LEFT JOIN `user` AS `admins` ON `admins`.`user_id`=`cr`.`adminid`\n\t\t\t LEFT JOIN `cache_report_status` AS `crs` ON `cr`.`status`=`crs`.`id`\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `crs`.`trans_id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\n\t\t\t LEFT JOIN `sys_trans_text` AS `tt2` ON `crr`.`trans_id`=`tt2`.`trans_id` AND `tt2`.`lang`='&2'\n\t\t\t WHERE `cr`.`cacheid`='&1' AND `cr`.`id`<>'&3'\n\t\t\t ORDER BY `cr`.`status`,`cr`.`id` DESC", $this->getCacheId(), $opt['template']['locale'], $exclude_report_id); $tpl->assign_rs('reports', $rs); sql_free_result($rs); // user; deleted logs $rs = sql("SELECT * FROM `caches` WHERE `cache_id`='&1'", $this->getCacheId()); $rCache = sql_fetch_array($rs); $tpl->assign('cache', $rCache); sql_free_result($rs); $tpl->assign('ownername', sql_value("SELECT `username` FROM `user` WHERE `user_id`='&1'", "", $rCache['user_id'])); $tpl->assign('deleted_logs', $this->getLogsArray($this->getCacheId(), 0, 1000, true)); // status changes $rs = sql("SELECT `csm`.`date_modified`,\n\t\t `csm`.`old_state` AS `old_status_id`,\n\t\t `csm`.`new_state` AS `new_status_id`,\n\t\t `user`.`username`,\n\t\t\t\t `user`.`user_id`,\n\t\t IFNULL(`stt_old`.`text`,`cs_old`.`name`) AS `old_status`,\n\t\t IFNULL(`stt_new`.`text`,`cs_new`.`name`) AS `new_status`\n\t\t FROM `cache_status_modified` `csm`\n\t LEFT JOIN `cache_status` `cs_old` ON `cs_old`.`id`=`csm`.`old_state`\n\t\t\t\t\t\tLEFT JOIN `sys_trans_text` `stt_old` ON `stt_old`.`trans_id`=`cs_old`.`trans_id` AND `stt_old`.`lang`='&2'\n\t LEFT JOIN `cache_status` `cs_new` ON `cs_new`.`id`=`csm`.`new_state`\n\t\t\t\t\t\tLEFT JOIN `sys_trans_text` `stt_new` ON `stt_new`.`trans_id`=`cs_new`.`trans_id` AND `stt_new`.`lang`='&2'\n\t\t\t\t\t\tLEFT JOIN `user` ON `user`.`user_id`=`csm`.`user_id`\n\t\t WHERE `cache_id`='&1'\n\t\t ORDER BY `date_modified` DESC", $this->getCacheId(), $opt['template']['locale']); $tpl->assign_rs('status_changes', $rs); sql_free_result($rs); // coordinate changes $rs = sql("SELECT `cc`.`date_created`, `cc`.`longitude`, `cc`.`latitude`,\n\t\t IFNULL(`admin`.`user_id`, `owner`.`user_id`) AS `user_id`,\n\t\t IFNULL(`admin`.`username`, `owner`.`username`) AS `username`\n\t\t FROM `cache_coordinates` `cc`\n\t\t LEFT JOIN `caches` ON `caches`.`cache_id`=`cc`.`cache_id`\n\t\t LEFT JOIN `user` `owner` ON `owner`.`user_id`=`caches`.`user_id`\n\t\t LEFT JOIN `user` `admin` ON `admin`.`user_id`=`cc`.`restored_by`\n\t\t WHERE `cc`.`cache_id`='&1'\n\t\t ORDER BY `cc`.`date_created` DESC", $this->getCacheId()); $coords = array(); while ($rCoord = sql_fetch_assoc($rs)) { $coord = new coordinate($rCoord['latitude'], $rCoord['longitude']); $coords[] = array('date' => $rCoord['date_created'], 'coord' => $coord->getDecimalMinutes(), 'user_id' => $rCoord['user_id'], 'username' => $rCoord['username']); } sql_free_result($rs); $tpl->assign('coordinates', $coords); // Adoptions $rs = sql("SELECT `cache_adoptions`.`date`,\n\t\t `cache_adoptions`.`from_user_id`,\n\t\t `cache_adoptions`.`to_user_id`,\n\t\t `from_user`.`username` AS `from_username`,\n\t\t `to_user`.`username` AS `to_username`\n\t\t FROM `cache_adoptions`\n\t\t LEFT JOIN `user` `from_user` ON `from_user`.`user_id`=`from_user_id`\n\t\t LEFT JOIN `user` `to_user` ON `to_user`.`user_id`=`to_user_id`\n\t\t WHERE `cache_id`='&1'\n\t\t ORDER BY `cache_adoptions`.`date`, `cache_adoptions`.`id`", $this->getCacheId()); $tpl->assign_rs('adoptions', $rs); sql_free_result($rs); }
/** * @group unit-tests * @covers \coordinate::getDecimalMinutes * @dataProvider formatProvider * * @return void */ public function testFormatConversions($lat, $lon, $expectedMin, $expectedMinSec) { $coord = new \coordinate($lat, $lon); self::assertEquals($expectedMin, $coord->getDecimalMinutes()); self::assertEquals($expectedMinSec, $coord->getDecimalMinutesSeconds()); }
$tpl->assign('step', 1); $tpl->assign('username', $_REQUEST['username']); $rs = sql("SELECT `user_id`, `username`, `is_active_flag` FROM `user` WHERE `username`='&1'", $_REQUEST['username']); $r = sql_fetch_assoc($rs); sql_free_result($rs); if ($r == false) { $tpl->assign('error', 'userunknown'); $tpl->display(); } $tpl->assign('username', $r['username']); // get cache set for this user $user_id = $r['user_id']; $rs = sql("SELECT\n `cache_id`,\n `wp_oc`,\n `name`,\n `latitude`,\n `longitude`,\n `status`,\n LEFT(`listing_last_modified`,10) AS `last_modified`,\n (SELECT COUNT(*) FROM `cache_logs` WHERE `cache_logs`.`cache_id`=`caches`.`cache_id`) AS `logs`\n FROM `caches`\n WHERE `user_id`='&1'\n AND `status`!=5", $user_id); $caches = array(); while ($rCache = sql_fetch_assoc($rs)) { $coord = new coordinate($rCache['latitude'], $rCache['longitude']); $rCache['coordinates'] = $coord->getDecimalMinutes(); $rCache['data'] = get_archive_data(array($rCache['cache_id'])); if (count($rCache['data'])) { $keys = array_keys($rCache['data']); $rCache['date'] = $keys[0]; } $caches[] = $rCache; } sql_free_result($rs); if (count($caches) == 0) { $tpl->assign('error', 'nocaches'); } else { // STEP 3: select caches to restore $tpl->assign('step', 3); $tpl->assign('aCaches', $caches);
* * Unicode Reminder メモ ***************************************************************************/ require './lib2/web.inc.php'; require_once './lib2/logic/coordinate.class.php'; $tpl->name = 'coordinates'; $tpl->popup = true; $lat_float = 0; if (isset($_REQUEST['lat'])) { $lat_float += $_REQUEST['lat']; } $lon_float = 0; if (isset($_REQUEST['lon'])) { $lon_float += $_REQUEST['lon']; } $coord = new coordinate($lat_float, $lon_float); $tpl->assign('coordDeg', $coord->getDecimal()); $tpl->assign('coordDegMin', $coord->getDecimalMinutes()); $tpl->assign('coordDegMinSec', $coord->getDecimalMinutesSeconds()); $tpl->assign('coordUTM', $coord->getUTM()); $tpl->assign('coordGK', $coord->getGK()); $tpl->assign('coordQTH', $coord->getQTH()); $tpl->assign('coordSwissGrid', $coord->getSwissGrid()); // wp gesetzt? $wp = isset($_REQUEST['wp']) ? $_REQUEST['wp'] : ''; if ($wp != '') { $rs = sql("SELECT `caches`.`name`, `user`.`username` FROM `caches` INNER JOIN `cache_status` ON `caches`.`status`=`cache_status`.`id` INNER JOIN `user` ON `user`.`user_id`=`caches`.`user_id` WHERE `cache_status`.`allow_user_view`=1 AND `caches`.`wp_oc`='&1'", $wp); if ($r = sql_fetch_array($rs)) { $tpl->assign('owner', $r['username']); $tpl->assign('cachename', $r['name']); }
public function testFormatConversions() { $coord = new coordinate(51.52775, -120.8972); $decimalMin = $coord->getDecimalMinutes(); $this->assertEquals("N 51° 31.665'", $decimalMin['lat']); $this->assertEquals("W 120° 53.832'", $decimalMin['lon']); $decimalMinSec = $coord->getDecimalMinutesSeconds(); $this->assertEquals("N 51° 31' 39''", $decimalMinSec['lat']); $this->assertEquals("W 120° 53' 49''", $decimalMinSec['lon']); $coord = new coordinate(-8.81687, 13.24057); $decimalMin = $coord->getDecimalMinutes(); $this->assertEquals("S 08° 49.012'", $decimalMin['lat']); $this->assertEquals("E 013° 14.434'", $decimalMin['lon']); $decimalMinSec = $coord->getDecimalMinutesSeconds(); $this->assertEquals("S 08° 49' 00''", $decimalMinSec['lat']); $this->assertEquals("E 013° 14' 26''", $decimalMinSec['lon']); $coord = new coordinate(52.67578, 6.773); $decimalMin = $coord->getDecimalMinutes(); $this->assertEquals("N 52° 40.547'", $decimalMin['lat']); $this->assertEquals("E 006° 46.380'", $decimalMin['lon']); $decimalMinSec = $coord->getDecimalMinutesSeconds(); $this->assertEquals("N 52° 40' 32''", $decimalMinSec['lat']); $this->assertEquals("E 006° 46' 22''", $decimalMinSec['lon']); $coord = new coordinate(60.63367, 4.81313); $decimalMin = $coord->getDecimalMinutes(); $this->assertEquals("N 60° 38.020'", $decimalMin['lat']); $this->assertEquals("E 004° 48.788'", $decimalMin['lon']); $decimalMinSec = $coord->getDecimalMinutesSeconds(); $this->assertEquals("N 60° 38' 01''", $decimalMinSec['lat']); $this->assertEquals("E 004° 48' 47''", $decimalMinSec['lon']); }
function assignFromUser($user) { global $tpl; $tpl->assign('username', $user->getUsername()); $tpl->assign('email', $user->getEMail()); $tpl->assign('firstName', $user->getFirstName()); $tpl->assign('lastName', $user->getLastName()); $tpl->assign('country', $user->getCountry()); $tpl->assign('countryCode', $user->getCountryCode()); $coords = new coordinate($user->getLatitude(), $user->getLongitude()); $tpl->assign('coords', $coords->getDecimalMinutes()); $tpl->assign('coordsDecimal', $coords->getFloat()); $tpl->assign('notifyRadius', $user->getNotifyRadius()); $tpl->assign('registeredSince', $user->getDateRegistered()); $tpl->assign('usePMR', $user->getUsePMR()); $tpl->assign('permanentLogin', $user->getPermanentLogin()); $tpl->assign('noHTMLEditor', $user->getNoHTMLEditor()); }
function assignFromUser($user) { global $tpl; $tpl->assign('username', $user->getUsername()); $tpl->assign('email', $user->getEMail()); $tpl->assign('firstName', $user->getFirstName()); $tpl->assign('lastName', $user->getLastName()); $tpl->assign('country', $user->getCountry()); $tpl->assign('countryCode', $user->getCountryCode()); $coords = new coordinate($user->getLatitude(), $user->getLongitude()); $tpl->assign('coords', $coords->getDecimalMinutes()); $tpl->assign('coordsDecimal', $coords->getFloat()); $tpl->assign('notifyRadius', $user->getNotifyRadius()); $tpl->assign('notifyOconly', $user->getNotifyOconly()); $oconly_helplink = helppagelink('oconly'); $tpl->assign('oconly_helpstart', $oconly_helplink); $tpl->assign('oconly_helpend', $oconly_helplink != '' ? '</a>' : ''); $tpl->assign('registeredSince', $user->getDateRegistered()); $tpl->assign('accMailing', $user->getAccMailing()); $tpl->assign('usePMR', $user->getUsePMR()); $tpl->assign('permanentLogin', $user->getPermanentLogin()); $tpl->assign('noHTMLEditor', $user->getNoHTMLEditor()); $tpl->assign('sendUsermailAddress', $user->getUsermailSendAddress()); }
} foreach ($classes as $class => $methods) { $pass &= class_exists($class); echo pass_fail('Class ' . $class . ' exists' . PHP_EOL, $pass); foreach ($methods as $method) { $pass &= method_exists($class, $method); echo pass_fail('----- ' . $class . '->' . $method . '() exists' . PHP_EOL, $pass); } echo PHP_EOL; } if (!$pass) { die('Extension elements don\'t work :(' . PHP_EOL); } $coordinate_1 = new coordinate(52.3033, -0.79195, 1); $coordinate_2 = new coordinate(52.296616666666665, -0.6392833333333333, 3); $coordinate_3 = new coordinate(52.19661, -0.62928333, 3, 19); $set = new coordinate_set(2); $set->set($coordinate_1); $set->set($coordinate_2); $tests = ['52.3033' => $coordinate_1->lat(), '-0.79195' => $coordinate_1->lng(), '1' => $coordinate_1->ele(), '094.023977' => $coordinate_1->get_bearing_to($coordinate_2), '10.407709313555' => $coordinate_1->get_distance_to($coordinate_2), '10.441137' => $coordinate_1->get_distance_to($coordinate_2, true), '52.3033' => $set->first()->lat(), '-0.6392833333333333' => $set->last()->lng(), '19' => $coordinate_3->timestamp()]; foreach ($tests as $key => $value) { echo pass_fail(sprintf('----> (%010.6f) = %010.6f', $key, $value), round($key, 6) == round($value, 6)) . PHP_EOL; } echo 'Loop test: ' . PHP_EOL; for ($i = 0; $i < $set->count(); $i++) { echo $i . ': ' . $set->get($i)->gridref() . PHP_EOL; } echo pass("Looping successful"); echo PHP_EOL; score_track('igc/1/test.igc', ['OD: 014.50 -> 140,346,642,771,813,', 'OR: 007.88 -> 352,642,771, // GPSDUMP INVALID', 'TR: 009.23 -> 257,345,441,257,']); // score_track('igc/2/test.igc', [
* * Unicode Reminder メモ ***************************************************************************/ require './lib2/web.inc.php'; require_once './lib2/logic/coordinate.class.php'; $tpl->name = 'coordinates'; $tpl->popup = true; $lat_float = 0; if (isset($_REQUEST['lat'])) { $lat_float += $_REQUEST['lat']; } $lon_float = 0; if (isset($_REQUEST['lon'])) { $lon_float += $_REQUEST['lon']; } $coord = new coordinate($lat_float, $lon_float); $tpl->assign('coordDeg', $coord->getDecimal()); $tpl->assign('coordDegMin', $coord->getDecimalMinutes()); $tpl->assign('coordDegMinSec', $coord->getDecimalMinutesSeconds()); $tpl->assign('coordUTM', $coord->getUTM()); $tpl->assign('coordGK', $coord->getGK()); $tpl->assign('coordRD', $coord->getRD()); $tpl->assign('showRD', $coord->nLat >= 45 && $coord->nLat <= 57 && $coord->nLon >= 0 && $coord->nLon <= 15); $tpl->assign('coordQTH', $coord->getQTH()); $tpl->assign('coordSwissGrid', $coord->getSwissGrid()); $tpl->assign('coordW3Wde', $coord->getW3W('de')); $tpl->assign('coordW3Wen', $coord->getW3W('en')); // wp gesetzt? $wp = isset($_REQUEST['wp']) ? $_REQUEST['wp'] : ''; if ($wp != '') { $rs = sql("SELECT `caches`.`name`, `user`.`username` FROM `caches` INNER JOIN `cache_status` ON `caches`.`status`=`cache_status`.`id` INNER JOIN `user` ON `user`.`user_id`=`caches`.`user_id` WHERE `cache_status`.`allow_user_view`=1 AND `caches`.`wp_oc`='&1'", $wp);