Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 06 Feb 2008, 20:31
tschai's Avatar
tschai tschai is offline
 
Join Date: Nov 2006
Real name: Tschai
Question Retrieve userid instead of lastposter from '_thread' table...

Hi all,

In the forum mainpage the lastposter ($lastposter) is been retrieved from the '_thread' table via 'member.php'
I want to show the avatar via the userid on this forumpage.

My question is:
-How could I possibly retrieve the userid via 'member.php'/'_thread' table of the lastposter (in order to show the accompanying avatar)?

or maybe easier

-How and where could I insert also the userid of the lastposter in the '_thread' table (in order the retrieve it dierctly later on)?

Any suggestions are welcome.

Thanks in advance.
__________________
Fan-tas-tic!

Last edited by tschai; 26 Oct 2009 at 14:05. Reason: typo's
Reply With Quote
  #2  
Old 06 Feb 2008, 21:46
Opserty Opserty is offline
 
Join Date: Apr 2007
You could maybe add a Join to the query using one of the hook locations on the forumdisplay page. forumdisplay_query I think it is. Then select the userid from the user table as you fetch the rest of the info.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 19:07.

Layout Options | Width: Wide Color: