Reply #9 February 22, 2013 - 12:44 00:44
Hmmm, yes, you are correct. So, to make it works follow the instructions below>
1. Undo the previous modification
2. At /Sources/BrokenLinksLink.php find:
$request = $smcFunc['db_query']('', '
SELECT m.id_topic,m.id_msg,m.id_member,m.subject,m.poster_name,
br.id_topic, br.id_msg, br.reported_time, br.reported_name, br.status, br.notes, br.id_member_reported, br.id_report
FROM {db_prefix}messages AS m
INNER JOIN {db_prefix}broken_links_list AS br ON (m.id_msg = br.id_msg)
ORDER BY '.$sort_methods[$_REQUEST['sort']][$context['sort_direction']].''
);
and replace the code above by this one:
$request = $smcFunc['db_query']('', '
SELECT m.id_topic,m.id_msg,m.id_member,m.subject,m.poster_name, u.real_name,
br.id_topic, br.id_msg, br.reported_time, br.reported_name, br.status, br.notes, br.id_member_reported, br.id_report
FROM {db_prefix}messages AS m
INNER JOIN {db_prefix}broken_links_list AS br ON (m.id_msg = br.id_msg)
LEFT JOIN {db_prefix}members as u ON (m.id_member = u.id_member)
ORDER BY '.$sort_methods[$_REQUEST['sort']][$context['sort_direction']].''
);
After that, in the same file find:
$inforows['posterhref'] = '<a href="'. $scripturl .'?action=profile;u='. $row['id_member'] .'">'.$row['poster_name'].'</a>';
And then replace it by:
$inforows['posterhref'] = '<a href="'. $scripturl .'?action=profile;u='. $row['id_member'] .'">'.$row['real_name'].'</a>';