{SECTION: dmsg_reg_user_link}
<a href="{TEMPLATE: dmsg_reg_user_link_lnk}">{VAR: user_login}</a>
{SECTION: END}

$user_login = $obj->user_id ? $obj->login : $GLOBALS['ANON_NICK'];

SELECT m.*, COALESCE(m.flag_cc, u.flag_cc) AS disp_flag_cc, COALESCE(m.flag_country, u.flag_country) AS disp_flag_country, t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id, f.message_threshold, u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location, u.sig, u.custom_status, u.icq, u.jabber, u.affero, u.aim, u.msnm, u.yahoo, u.google, u.skype, u.twitter, u.last_visit AS time_sec, u.users_opt, l.name AS level_name, l.level_opt, l.img AS level_img, p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes, pot.id AS cant_vote FROM fud30_msg m INNER JOIN fud30_thread t ON m.thread_id=t.id INNER JOIN fud30_forum f ON t.forum_id=f.id LEFT JOIN fud30_users u ON m.poster_id=u.id LEFT JOIN fud30_level l ON u.level_id=l.id LEFT JOIN fud30_poll p ON m.poll_id=p.id LEFT JOIN fud30_poll_opt_track pot ON pot.poll_id=p.id AND pot.user_id=6 WHERE m.id=667096 AND m.apr=1 AND m.thread_id=192342