require_once './lib/common.inc.php'; //Preprocessing if ($error == false) { //set the template to process $tplname = 'start'; // news require $stylepath . '/news.inc.php'; $newscontent = '<div class="line-box">'; $rs = sql('SELECT `news`.`date_posted` `date`, `news`.`content` `content` FROM `news` WHERE datediff(now(), news.date_posted) <= 31 AND `news`.`display`=1 AND `news`.`topic`=2 ORDER BY `news`.`date_posted` DESC LIMIT 4'); if (mysql_num_rows($rs) != 0) { $newscontent .= $tpl_newstopic_header; } while ($r = sql_fetch_array($rs)) { $news = '<div class="logs" style="width: 750px;">' . $tpl_newstopic_without_topic; $post_date = strtotime($r['date']); $news = mb_ereg_replace('{date}', fixPlMonth(htmlspecialchars(strftime("%d %B %Y", $post_date), ENT_COMPAT, 'UTF-8')), $news); $news = mb_ereg_replace('{message}', $r['content'], $news); $newscontent .= $news . "</div>\n"; } $newscontent .= "</div>\n"; if (mysql_num_rows($rs) != 0) { tpl_set_var('display_news', $newscontent); } else { tpl_set_var('display_news', ''); } mysql_free_result($rs); $newscontent = ''; global $dynstylepath; include $dynstylepath . "totalstats.inc.php"; // here is the right place to set up template replacements // example:
} $stat_menu = array('title' => tr('Statictics'), 'menustring' => tr('Statictics'), 'siteid' => 'statlisting', 'navicolor' => '#E8DDE4', 'visible' => false, 'filename' => 'viewprofile.php?userid=' . $user_id, 'submenu' => array(array('title' => tr('graph_find'), 'menustring' => tr('graph_find'), 'visible' => true, 'filename' => 'ustatsg2.php?userid=' . $user_id, 'newwindow' => false, 'siteid' => 'findstat', 'icon' => 'images/actions/stat'), array('title' => tr('graph_created'), 'menustring' => tr('graph_created'), 'visible' => true, 'filename' => 'ustatsg1.php?userid=' . $user_id, 'newwindow' => false, 'siteid' => 'createstat', 'icon' => 'images/actions/stat'))); $content = ""; $database = new dataBase(); $rddQuery = "select TO_DAYS(NOW()) - TO_DAYS(`date_created`) `diff` from `user` WHERE user_id=:1 "; $database->multiVariableQuery($rddQuery, $user_id); $ddays = $database->dbResultFetch(); $query = "SELECT admin, guru, hidden_count, founds_count, is_active_flag, email, password, log_notes_count, notfounds_count, username, last_login, country, date_created, description, hide_flag FROM user WHERE user_id=:1 LIMIT 1"; $database->multiVariableQuery($query, $user_id); $user_record = $database->dbResultFetch(); tpl_set_var('username', $user_record['username']); if (date('m') == 4 and date('d') == 1) { tpl_set_var('username', tr('primaAprilis1')); } tpl_set_var('country', tr($user_record['country'])); tpl_set_var('registered', fixPlMonth(strftime($dateformat, strtotime($user_record['date_created'])))); $description = $user_record['description']; tpl_set_var('description', nl2br($description)); if ($description != "") { tpl_set_var('description_start', ''); tpl_set_var('description_end', ''); } else { tpl_set_var('description_start', '<!--'); tpl_set_var('description_end', '-->'); } $pimage = 'profile2'; $pinfo = "OC user"; if ($user_record['guru'] == 1) { $pimage = 'guide'; $pinfo = "Przewodnik"; }
$bgcolor2 = '#ffffff'; $line = '<tr bgcolor={bgcolor}><td><a href=viewprofile.php?userid={user_id}>{username}</a></td><td> </td><td nowrap style="text-align:center;">{date_created}</td><td nowrap style="text-align:center;"></td></tr>'; $lines = ""; $ilosc = $dbc->rowCount($s); if ($ilosc != 0) { if ($ilosc == 1) { $record = $dbc->dbResultFetch($s); tpl_redirect("viewprofile.php?userid=" . $record['user_id']); } else { $i = 0; while ($record = $dbc->dbResultFetch($s)) { $tmp_line = $line; $tmp_line = mb_ereg_replace('{bgcolor}', $i % 2 == 0 ? $bgcolor1 : $bgcolor2, $tmp_line); $tmp_line = mb_ereg_replace('{username}', htmlspecialchars($record['username'], ENT_COMPAT, 'UTF-8'), $tmp_line); $tmp_line = mb_ereg_replace('{user_id}', htmlspecialchars($record['user_id'], ENT_COMPAT, 'UTF-8'), $tmp_line); $tmp_line = mb_ereg_replace('{date_created}', htmlspecialchars(fixPlMonth(strftime($dateformat, strtotime($record['date_created']))), ENT_COMPAT, 'UTF-8'), $tmp_line); $lines .= $tmp_line . "\n"; $i++; } tpl_set_var('lines', $lines); tpl_set_var('username', ''); tpl_set_var('not_found', ''); } } else { // User not found tpl_set_var('username', $options['username']); tpl_set_var('not_found', '<b>' . tr("message_user_not_found") . ': ' . $options['username'] . '</b><br/><br/>'); tpl_set_var('lines', ''); } } else { tpl_set_var('username', '');
$caches .= "\n" . $tmp_cache; } tpl_set_var('notpublishedcaches', $caches); } //get last logs in your caches $rs_logs = sql("\n SELECT `cache_logs`.`cache_id` `cache_id`, `cache_logs`.`type` `type`, `cache_logs`.`date` `date`, `caches`.`name` `name`,\n `log_types`.`icon_small`, `log_types_text`.`text_combo`, `cache_logs`.`user_id` `user_id`, `user`.`username` `username`\n FROM `cache_logs`, `caches`, `log_types`, `log_types_text`, `user`\n WHERE `caches`.`user_id`='&1'\n AND `cache_logs`.`cache_id`=`caches`.`cache_id`\n AND `cache_logs`.`deleted`=0\n AND `user`.`user_id`=`cache_logs`.`user_id`\n AND `log_types`.`id`=`cache_logs`.`type`\n AND `log_types_text`.`log_types_id`=`log_types`.`id` AND `log_types_text`.`lang`='&2'\n ORDER BY `cache_logs`.`date` DESC, `cache_logs`.`date_created` DESC\n LIMIT 10", $usr['userid'], $lang); if (mysql_num_rows($rs_logs) == 0) { tpl_set_var('last_logs_in_your_caches', $no_logs); } else { $logs = ''; for ($i = 0; $i < mysql_num_rows($rs_logs); $i++) { $record_logs = sql_fetch_array($rs_logs); $tmp_log = $cache_line_my_caches; $tmp_log = mb_ereg_replace('{logimage}', icon_log_type($record_logs['icon_small'], ucfirst(tr('logType' . $record_logs['type']))), $tmp_log); $tmp_log = mb_ereg_replace('{logtype}', ucfirst(tr('logType' . $record_logs['type'])), $tmp_log); $tmp_log = mb_ereg_replace('{date}', fixPlMonth(strftime($dateformat, strtotime($record_logs['date']))), $tmp_log); $tmp_log = mb_ereg_replace('{cachename}', htmlspecialchars($record_logs['name'], ENT_COMPAT, 'UTF-8'), $tmp_log); $tmp_log = mb_ereg_replace('{cacheid}', htmlspecialchars($record_logs['cache_id'], ENT_COMPAT, 'UTF-8'), $tmp_log); // ukrywanie nicka autora komentarza COG // (Łza) if ($record_logs['type'] == 12 && !$usr['admin']) { $tmp_log = mb_ereg_replace('{userid}', htmlspecialchars('0', ENT_COMPAT, 'UTF-8'), $tmp_log); $tmp_log = mb_ereg_replace('{username}', htmlspecialchars('Centrum Obsługi Geocachera', ENT_COMPAT, 'UTF-8'), $tmp_log); } else { $tmp_log = mb_ereg_replace('{username}', htmlspecialchars($record_logs['username'], ENT_COMPAT, 'UTF-8'), $tmp_log); $tmp_log = mb_ereg_replace('{userid}', htmlspecialchars($record_logs['user_id'], ENT_COMPAT, 'UTF-8'), $tmp_log); } // koniec ukrywania nicka autora komentarza COG $logs .= "\n" . $tmp_log; } tpl_set_var('last_logs_in_your_caches', $logs);
//check if record created after implementation date (to avoid false readings for record changed before) - actually nor in use $edit_footer .= " - " . tr('vl_totally_modified') . " " . $record['edit_count'] . " "; if ($record['edit_count'] > 1) { $edit_footer .= tr('vl_count_plural'); } else { $edit_footer .= tr('vl_count_singular'); } } $edit_footer .= ".</small></div>"; } else { $edit_footer = ""; } $tmplog = read_file($stylepath . '/viewcache_log.tpl.php'); //END: same code ->viewlogs.php / viewcache.php $tmplog_username = htmlspecialchars($record['username'], ENT_COMPAT, 'UTF-8'); $tmplog_date = fixPlMonth(htmlspecialchars(strftime($dateformat, strtotime($record['date'])), ENT_COMPAT, 'UTF-8')); // replace smilies in log-text with images $dateTimeTmpArray = explode(' ', $record['date']); $tmplog = mb_ereg_replace('{time}', substr($dateTimeTmpArray[1], 0, -3), $tmplog); // display user activity (by Łza 2012) if (date('m') == 4 and date('d') == 1) { $tmplog_username_aktywnosc = ' (<img src="tpl/stdstyle/images/blue/thunder_ico.png" alt="user activity" width="13" height="13" border="0" title="' . tr('viewlog_aktywnosc') . '"/>' . rand(1, 9) . ') '; } else { $tmplog_username_aktywnosc = ' (<img src="tpl/stdstyle/images/blue/thunder_ico.png" alt="user activity" width="13" height="13" border="0" title="' . tr('viewlog_aktywnosc') . ' [' . $record['znalezione'] . '+' . $record['nieznalezione'] . '+' . $record['ukryte'] . ']"/>' . ($record['ukryte'] + $record['znalezione'] + $record['nieznalezione']) . ') '; } // hide nick of athor of COG(OC Team) for user if ($record['type'] == 12 && !$usr['admin']) { $record['userid'] = '0'; $tmplog_username_aktywnosc = ''; $tmplog_username = tr('cog_user_name'); }
if ($record['guru'] == 1) { tpl_set_var('guides_start', ''); tpl_set_var('guides_end', ''); } else { tpl_set_var('guides_start', '<!--'); tpl_set_var('guides_end', '-->'); } tpl_set_var('userid', (int) $usr['userid']); tpl_set_var('profileurl', $absolute_server_URI . 'viewprofile.php?userid=' . ($usr['userid'] + 0)); tpl_set_var('statlink', $absolute_server_URI . 'statpics/' . ($usr['userid'] + 0) . '.jpg'); tpl_set_var('username', htmlspecialchars($record['username'], ENT_COMPAT, 'UTF-8')); tpl_set_var('username_html', htmlspecialchars(htmlspecialchars($record['username'], ENT_COMPAT, 'UTF-8'), ENT_COMPAT, 'UTF-8')); tpl_set_var('email', htmlspecialchars($record['email'], ENT_COMPAT, 'UTF-8')); tpl_set_var('country', htmlspecialchars(tr($record['country']), ENT_COMPAT, 'UTF-8')); tpl_set_var('coords', htmlspecialchars(help_latToDegreeStr($record['latitude']), ENT_COMPAT, 'UTF-8') . '<br />' . htmlspecialchars(help_lonToDegreeStr($record['longitude']), ENT_COMPAT, 'UTF-8')); tpl_set_var('registered_since', fixPlMonth(htmlspecialchars(strftime($dateformat, strtotime($record['date_created'])), ENT_COMPAT, 'UTF-8'))); tpl_set_var('notify_radius', htmlspecialchars($record['notify_radius'] + 0, ENT_COMPAT, 'UTF-8')); /* GeoKretyApi - display if secid from geokrety is set; (by Łza) */ $GKAPIKeyQuery = "SELECT `secid` FROM `GeoKretyAPI` WHERE `userID` =:1"; $s = $db->multiVariableQuery($GKAPIKeyQuery, $usr['userid']); if ($db->rowCount($s) > 0) { tpl_set_var('GeoKretyApiIntegration', tr('yes')); } else { tpl_set_var('GeoKretyApiIntegration', tr('no')); } $GKAPIKeyrecord = $db->dbResultFetchOneRowOnly($s); tpl_set_var('GeoKretyApiSecid', $GKAPIKeyrecord['secid']); if ($record['notify_radius'] + 0 > 0) { tpl_set_var('notify', mb_ereg_replace('{radius}', $record['notify_radius'] + 0, $notify_radius_message)); } else { tpl_set_var('notify', $no_notify_message);