}
if (!isset($_GET['id']) || !($tmp = db_saq('SELECT id, alias, posted_msg_count, join_date FROM phpgw_fud_users WHERE id=' . (int) $_GET['id']))) {
invl_inp_err();
} else {
$uid = $tmp[0];
$u_alias = $tmp[1];
$u_pcount = $tmp[2];
$u_reg_date = $tmp[3];
}
$TITLE_EXTRA = ': Show Posts by: ' . $u_alias;
ses_update_status($usr->sid, 'Viewing posts by: <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=usrinfo&id=' . $uid . '">' . $u_alias . '</a>');
if (!isset($_GET['start']) || !($start = (int) $_GET['start'])) {
$start = 0;
}
if (!($usr->users_opt & 1048576)) {
$fids = implode(',', array_keys(get_all_read_perms(_uid, $usr->users_opt & 524288)));
}
if (isset($_GET['so']) && !strcasecmp($_GET['so'], 'asc')) {
$SORT_ORDER = 'ASC';
$SORT_ORDER_R = 'DESC';
} else {
$SORT_ORDER = 'DESC';
$SORT_ORDER_R = 'ASC';
}
$post_entry = '';
if ($usr->users_opt & 1048576 || $fids) {
$qry_limit = $usr->users_opt & 1048576 ? '' : 'f.id IN (' . $fids . ') AND ';
/* we need the total for the pager & we don't trust the user to pass it via GET or POST */
$total = q_singleval("SELECT count(*)\n\t\t\t\t\tFROM phpgw_fud_msg m\n\t\t\t\t\tINNER JOIN phpgw_fud_thread t ON m.thread_id=t.id\n\t\t\t\t\tINNER JOIN phpgw_fud_forum f ON t.forum_id=f.id\n\t\t\t\t\tINNER JOIN phpgw_fud_cat c ON c.id=f.cat_id\n\t\t\t\t\tWHERE " . $qry_limit . " m.apr=1 AND m.poster_id=" . $uid);
$c = uq("SELECT f.name, f.id, m.subject, m.id, m.post_stamp\n\t\t\tFROM phpgw_fud_msg m\n\t\t\tINNER JOIN phpgw_fud_thread t ON m.thread_id=t.id\n\t\t\tINNER JOIN phpgw_fud_forum f ON t.forum_id=f.id\n\t\t\tINNER JOIN phpgw_fud_cat c ON c.id=f.cat_id\n\t\t\tWHERE " . $qry_limit . " m.apr=1 AND m.poster_id=" . $uid . "\n\t\t\tORDER BY m.post_stamp " . $SORT_ORDER . " LIMIT " . qry_limit($THREADS_PER_PAGE, $start));
while ($r = db_rowarr($c)) {
if (!isset($_GET['id']) || !(int) $_GET['id']) {
invl_inp_err();
}
if (!($u = db_sab('SELECT u.*, l.name AS level_name, l.level_opt, l.img AS level_img FROM phpgw_fud_users u LEFT JOIN phpgw_fud_level l ON l.id=u.level_id WHERE u.id=' . (int) $_GET['id']))) {
std_error('user');
}
$avatar = $FUD_OPT_1 & 28 && $u->users_opt & 8388608 && !($u->level_opt & 2) ? '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap valign="top" class="GenText">Avatar:</td><td class="GenText">' . $u->avatar_loc . '</td></tr>' : '';
if ($avatar && $u->level_opt & 1) {
$level_name = $level_image = '';
} else {
$level_name = $u->level_name ? '' . $u->level_name . '<br />' : '';
$level_image = $u->level_img ? '<img src="images/' . $u->level_img . '" /><br />' : '';
}
$custom_tags = $u->custom_status ? '' . $u->custom_status . '<br />' : '';
if (!($usr->users_opt & 1048576)) {
$frm_perms = get_all_read_perms(_uid, $usr->users_opt & 524288);
}
$moderation = '';
if ($u->users_opt & 524288) {
$c = uq('SELECT f.id, f.name FROM phpgw_fud_mod mm INNER JOIN phpgw_fud_forum f ON mm.forum_id=f.id INNER JOIN phpgw_fud_cat c ON f.cat_id=c.id WHERE ' . ($usr->users_opt & 1048576 ? '' : 'f.id IN(' . implode(',', array_keys($frm_perms)) . ') AND ') . 'mm.user_id=' . $u->id);
while ($r = db_rowarr($c)) {
$moderation .= '<a href="/egroupware/fudforum/3814588639/index.php?t=' . t_thread_view . '&frm_id=' . $r[0] . '&' . _rsid . '" class="GenLink">' . htmlspecialchars($r[1]) . '</a> ';
}
if ($moderation) {
$moderation = 'Moderatore di: ' . $moderation;
}
}
$TITLE_EXTRA = ': Informazioni utente ' . $user_info;
ses_update_status($usr->sid, 'Guarda il profilo di <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=usrinfo&id=' . $u->id . '">' . $user_info . '</a>');
$status = !empty($level_name) || !empty($moderation) || !empty($level_image) || !empty($custom_tags) ? '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap valign="top" class="GenText">Status:</td><td class="GenText">
<font class="LevelText">
$fid = 'f.id';
}
if (_uid) {
$join = ' INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=' . $fid . ' LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=' . _uid . ' AND g2.resource_id=' . $fid . ' ';
$fields = ' (CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS group_cache_opt ';
} else {
$join = ' INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=0 AND g1.resource_id=' . $fid . ' ';
$fields = ' g1.group_cache_opt ';
}
}
if (!($FUD_OPT_1 & 536870912)) {
std_error('disabled');
}
ses_update_status($usr->sid, 'Quelli che si fanno gli affari degli altri, proprio come te');
$rand_val = get_random_value();
$limit =& get_all_read_perms(_uid, $usr->users_opt & (524288 | 1048576));
$c = uq('SELECT
s.action, s.user_id, s.forum_id,
u.alias, u.custom_color, s.time_sec, u.users_opt,
m.id, m.subject, m.post_stamp,
t.forum_id,
mm1.id, mm2.id
FROM phpgw_fud_ses s
LEFT JOIN phpgw_fud_users u ON s.user_id=u.id
LEFT JOIN phpgw_fud_msg m ON u.u_last_post_id=m.id
LEFT JOIN phpgw_fud_thread t ON m.thread_id=t.id
LEFT JOIN phpgw_fud_mod mm1 ON mm1.forum_id=t.forum_id AND mm1.user_id=' . _uid . '
LEFT JOIN phpgw_fud_mod mm2 ON mm2.forum_id=s.forum_id AND mm2.user_id=' . _uid . '
WHERE s.time_sec>' . (__request_timestamp__ - $LOGEDIN_TIMEOUT * 60) . ' AND s.user_id!=' . _uid . ' ORDER BY u.alias, s.time_sec DESC');
$action_data = '';
while ($r = db_rowarr($c)) {
