FUDforum: How To » Mailing list integration question

Home » FUDforum » How To » Mailing list integration question

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

Re: Mailing list integration question [message #168844 is a reply to message #168843]

Sun, 28 July 2013 21:08

cpreston

Messages: 160
Registered: July 2012
Location: Oceanside

Karma:

Senior Member

I'm guessing about line 48 in mlist_post.inc we do something like this. I'm reaching here since I barely understand the syntax, but I thought I'd give it a shot. It can probably done with one query and a join, right? I don't get joins. Wink

I stole the db_saq string from another .inc file. I'm guessing it's what i need here. Wink

#Get the thread_id this message is in
db_saq('SELECT m.thread_id FROM $GLOBALS['DBHOST_TBL_PREFIX'] .'msg WHERE m.msg_id='. $msg_id .' AND m.subject='$subject');

#Get all the msg_ids from this thread, ordered by time.
db_saq('SELECT m.msg_id, m.post_stamp FROM $GLOBALS['DBHOST_TBL_PREFIX'] .'msg WHERE m.thread_id='. $thread_id .' ORDER BY m.post_stamp');

This should go into an array that we can then grab them from. Does that sound about right?

Report message to a moderator

[Message index]

		Mailing list integration question By: Jim O on Tue, 17 March 2009 12:51
		Re: Mailing list integration question By: naudefj on Tue, 17 March 2009 14:10
		Re: Mailing list integration question By: Jim O on Fri, 20 March 2009 01:01
		Re: Mailing list integration question By: naudefj on Fri, 20 March 2009 15:39
		Re: Mailing list integration question By: cpreston on Sun, 01 July 2012 03:57
		Re: Mailing list integration question By: cpreston on Thu, 25 July 2013 04:41
		Re: Mailing list integration question By: cpreston on Sat, 27 July 2013 00:40
		Re: Mailing list integration question By: naudefj on Sat, 27 July 2013 13:50
		Re: Mailing list integration question By: cpreston on Sun, 28 July 2013 03:38
		Re: Mailing list integration question By: cpreston on Sun, 28 July 2013 06:38
		Re: Mailing list integration question By: naudefj on Sun, 28 July 2013 16:20
		Re: Mailing list integration question By: cpreston on Sun, 28 July 2013 16:57
		Re: Mailing list integration question By: cpreston on Sun, 28 July 2013 20:32
		Re: Mailing list integration question By: cpreston on Sun, 28 July 2013 21:08
		Re: Mailing list integration question By: cpreston on Wed, 31 July 2013 17:18

Previous Topic:	Not getting any emails from FUDforum
Next Topic:	Post shows up above Sticky and Announcement Threads

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 28 06:09:06 GMT 2024

Total time taken to generate the page: 0.05151 seconds