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);
