Originally Posted by Sirdude
topic id is harder to get at from just viewing a thread, so i'd do a coupla tweaks:

SQL Query
SELECT DISTINCT u.USER_DISPLAY_NAME
FROM ubbt_USERS u, ubbt_POSTS p
WHERE p.TOPIC_ID=(SELECT TOPIC_ID FROM ubbt_TOPICS WHERE POST_ID='#')
AND u.USER_ID = p.USER_ID
ORDER BY u.USER_DISPLAY_NAME

tweak 1: use post id instead (it's displayed for each post in the entire thread and you can choose any one you'd like)
tweak 2: add 'DISTINCT' so as to not have multiples per user
tweak 3: order the list alphabetically for sanity

This query worked for me before but for some reason I have been unable to run it today. Any idea why it would suddenly stop working?