PHP lib\Objects\GeoCache\GeoCache::getDatePlaced Examples

Example #1

File: cache_stats.php Project: kojoty/opencaching-pl

 if ($usr == false) {
     $target = urlencode(tpl_get_current_page());
     tpl_redirect('login.php?target=' . $target);
 } else {
     // check for old-style parameters
     if (isset($_REQUEST['cacheid'])) {
         $cache_id = (int) $_REQUEST['cacheid'];
     } else {
         $cache_id = 0;
     }
     $geoCache = new \lib\Objects\GeoCache\GeoCache(array('cacheId' => $cache_id));
     $tplname = 'cache_stats';
     $content = "";
     $cachename = $geoCache->getCacheName();
     tpl_set_var('cachename', $cachename);
     $cachetime = $geoCache->getDatePlaced()->format('Y');
     $db = OcDb::instance();
     $rsGeneralStatQuery = 'SELECT count(*) count FROM `cache_logs` WHERE cache_logs.deleted=0 AND (type=1 OR type=2) AND cache_id=:1 ';
     $dbResult = $db->multiVariableQueryValue($rsGeneralStatQuery, 0, $cache_id);
     if ($dbResult == 0) {
         $content .= '<p>&nbsp;</p><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . $cachename . '<br /> <br />nie ma jeszcze statystyki</b></p>';
     } else {
         $content .= '<center><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . tr("stat_geocache") . ': ' . $cachename . '<br /></p>';
         $content .= '<p style="background-color: #FFFFFF; "><img src="graphs/PieGraphcstat.php?cacheid=' . $cache_id . '"  border="0" alt="Statystyka skrzynki" width="400" height="200" /><br /><br />';
         $year = date("Y");
         $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $year . '"  border="0" alt="" width="400" height="200" /><br /><br />';
         if ($cachetime != $year) {
             $yearr = $year - 1;
             $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $yearr . '"  border="0" alt="" width="400" height="200" /><br /><br />';
         }
         $content .= '<img src="graphs/BarGraphcstat.php?cacheid=' . $cache_id . '&amp;t=csy"  border="0" alt="" width="400" height="200" /><br /><br /><br /></p></center>';

Example #2

File: cache_stats.php Project: pawelzielak/opencaching-pl

 if ($usr == false) {
     $target = urlencode(tpl_get_current_page());
     tpl_redirect('login.php?target=' . $target);
 } else {
     // check for old-style parameters
     if (isset($_REQUEST['cacheid'])) {
         $cache_id = (int) $_REQUEST['cacheid'];
     } else {
         $cache_id = 0;
     }
     $geoCache = new \lib\Objects\GeoCache\GeoCache(array('cacheId' => $cache_id));
     $tplname = 'cache_stats';
     $content = "";
     $cachename = $geoCache->getCacheName();
     tpl_set_var('cachename', $cachename);
     $cachetime = date('Y', $geoCache->getDatePlaced());
     $db = \lib\Database\DataBaseSingleton::Instance();
     $rsGeneralStatQuery = 'SELECT count(*) count FROM `cache_logs` WHERE cache_logs.deleted=0 AND (type=1 OR type=2) AND cache_id=:1 ';
     $dbResult = $db->multiVariableQueryValue($rsGeneralStatQuery, 0, $cache_id);
     if ($dbResult == 0) {
         $content .= '<p>&nbsp;</p><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . $cachename . '<br /> <br />nie ma jeszcze statystyki</b></p>';
     } else {
         $content .= '<center><p style="background-color: #FFFFFF; margin: 0px; padding: 0px; color: rgb(88,144,168); font-weight: bold; font-size: 14px;">' . tr("stat_geocache") . ': ' . $cachename . '<br /></p>';
         $content .= '<p style="background-color: #FFFFFF; "><img src="graphs/PieGraphcstat.php?cacheid=' . $cache_id . '"  border="0" alt="Statystyka skrzynki" width="400" height="200" /><br /><br />';
         $year = date("Y");
         $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $year . '"  border="0" alt="" width="400" height="200" /><br /><br />';
         if ($cachetime != $year) {
             $yearr = $year - 1;
             $content .= '<img src="graphs/BarGraphcstatM.php?cacheid=' . $cache_id . '&amp;t=csm' . $yearr . '"  border="0" alt="" width="400" height="200" /><br /><br />';
         }
         $content .= '<img src="graphs/BarGraphcstat.php?cacheid=' . $cache_id . '&amp;t=csy"  border="0" alt="" width="400" height="200" /><br /><br /><br /></p></center>';