function pcp_output_username_linked($field_name, $view_userdata, $map_name = '')
{
global $board_config, $phpbb_root_path, $phpEx, $lang, $images, $userdata;
global $values_list, $tables_linked, $classes_fields, $user_maps, $user_fields;
$txt = '';
$img = '';
$username = $view_userdata['user_id'] != ANONYMOUS ? $view_userdata[$field_name] : (isset($view_userdata['post_username']) && $view_userdata['post_username'] != '' ? $view_userdata['post_username'] : $lang['Guest']);
// txt
if ($view_userdata['user_id'] != ANONYMOUS) {
$temp_url = append_sid("./profile.{$phpEx}?mode=viewprofile&" . POST_USERS_URL . '=' . $view_userdata['user_id']);
$txt = '<a href="' . $temp_url . '" title="' . $lang['Read_profile'] . '" class="' . get_user_level_class($view_userdata['user_level'], 'gen', $view_userdata) . '">' . $username . '</a>';
$img = '<a href="' . $temp_url . '"><img src="' . $images['icon_profile'] . '" border="0" alt="' . $lang['Read_profile'] . '" title="' . $lang['Read_profile'] . '" /></a>';
} else {
$txt = '<span class="' . get_user_level_class($view_userdata['user_level'], 'gen', $view_userdata) . '">' . $username . '</span>';
}
// result
$res = pcp_output_format($field_name, $txt, $img, $map_name);
return $res;
}
function get_users_online_color()
{
global $lang;
global $level_prior, $level_desc;
$res = '';
// read the defined levels
@arsort($level_prior);
@reset($level_prior);
while (list($key, $value) = @each($level_prior)) {
if (!empty($lang[$level_desc[$key]])) {
$res .= (empty($res) ? '' : ' ') . sprintf($lang[$level_desc[$key]], '[ <span class="' . get_user_level_class($key) . '">', '</span> ]');
}
}
return $res;
}
function get_birthday_list($time)
{
global $db, $phpbb_root_path, $phpEx, $userdata, $admin_level, $level_prior;
$res = '';
// no guest here, sorry ;)
if ($userdata['user_id'] == ANONYMOUS || !$userdata['session_logged_in']) {
return $res;
}
$today = date("md", $time);
$user_id = $userdata['user_id'];
$sql = "SELECT u.*,\n\t\t\t\t\t(CASE WHEN i.buddy_ignore =\t1 THEN 1 ELSE 0\tEND) AS\tuser_ignore,\n\t\t\t\t\t(CASE WHEN b.buddy_ignore =\t0 THEN 1 ELSE 0\tEND) AS\tuser_friend,\n\t\t\t\t\t(CASE WHEN b.buddy_visible = 1 THEN\t1 ELSE 0 END) AS user_visible\n\t\t\t\tFROM ((" . USERS_TABLE . " AS u\n\t\t\t\tLEFT JOIN " . BUDDYS_TABLE . " AS b\tON b.user_id=u.user_id AND b.buddy_id={$user_id})\n\t\t\t\tLEFT JOIN " . BUDDYS_TABLE . " AS i\tON i.user_id={$user_id} AND i.buddy_id=u.user_id)\n\t\t\t\tWHERE u.user_id\t<> " . ANONYMOUS . " AND u.user_birthday <>\t0 AND u.user_birthday <> ''\tand\tRIGHT(u.user_birthday, 4) =\t{$today}\n\t\t\t\tORDER BY username";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not read user table to get birthday today info', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result)) {
// get user relational status
$ignore = $row['user_ignore'];
$friend = $row['user_friend'];
$always_visible = $row['user_visible'];
// get the status of each info
$real_display = !$ignore && $userdata['user_allow_real'] && $row['user_allow_real'] && ($row['user_viewreal'] == YES || $row['user_viewreal'] == FRIEND_ONLY && $friend);
// take care of admin status
if (is_admin($userdata) || $row['user_id'] == $userdata['user_id']) {
$real_display = true;
}
if ($real_display) {
$txtclass = get_user_level_class($row['user_level'], 'genmed', $row);
if ($row['user_allow_viewonline'] != YES) {
$row['username'] = '******' . $row['username'] . '</i>';
}
$temp_url = append_sid("profile.{$phpEx}?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']);
$row['username'] = '******' . $temp_url . '" class="' . $txtclass . '">' . $row['username'] . '</a>';
// add to the user list
$res .= $res != '' ? ', ' : '';
$res .= $row['username'];
}
}
return $res;
}
