FUDforum: How To » New members with old posts linked in profile

Home » FUDforum » How To » New members with old posts linked in profile

Show: Today's Messages :: Polls :: Message Navigator

Re: New members with old posts linked in profile [message #21290 is a reply to message #21289]

Wed, 24 November 2004 18:25

treebeard

Messages: 44
Registered: April 2004
Location: Huge Universe

Karma:

Member

Ilia, I found the relevant code:

$last_post = '';
if ($u->u_last_post_id) {
$r = db_saq('SELECT m.subject, m.id, m.post_stamp, t.forum_id FROM {SQL_TABLE_PREFIX}msg m INNER JOIN {SQL_TABLE_PREFIX}thread t ON m.thread_id=t.id WHERE m.id='.$u->u_last_post_id);
if ($usr->users_opt & 1048576 || !empty($frm_perms[$r[3]])) {
$last_post = '{TEMPLATE: last_post}';
}

But I'm sure what to change here. It looks like the query is already looking inside the message table ({SQL_TABLE_PREFIX}msg). Is the thread table ({SQL_TABLE_PREFIX}thread) the one with the old record? Should this table be removed from the query? By "looking directly inside the msg table", did you mean getting form_id from the msg table? Does the msg table have forum_id, or an equivalent field? I tried looking it up myself but didn't have access. Thanks!

Report message to a moderator

[Message index]

		New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 16:35
		Re: New members with old posts linked in profile By: Ilia on Wed, 24 November 2004 16:55
		Re: New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 17:48
		Re: New members with old posts linked in profile By: Ilia on Wed, 24 November 2004 17:55
		Re: New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 18:25
		Re: New members with old posts linked in profile By: Ilia on Wed, 24 November 2004 18:41
		Re: New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 18:44
		Re: New members with old posts linked in profile By: Ilia on Wed, 24 November 2004 18:53
		Re: New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 19:34
		Re: New members with old posts linked in profile By: Ilia on Wed, 24 November 2004 19:36
		Re: New members with old posts linked in profile By: treebeard on Wed, 24 November 2004 19:47

Previous Topic:	Is the new flat "category" listing an option?
Next Topic:	Custom Titles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 03:32:44 GMT 2024

Total time taken to generate the page: 0.04555 seconds