#4 Posted on 24.10.02 1738.42 Reposted on: 24.10.09 1741.08
Well, Lesse... thinking out loud...
Can I drop a variable right in the middle of this string?
$posts=mysql_query("SELECT id, user, date, ip, text, num, header, sig, postpic FROM posts WHERE id>=$firstpost AND thread=$id ORDER BY date");
somewhat like the following...
$posts=mysql_query("SELECT id, user, date, ip, text, num, header, sig, postpic FROM posts WHERE id>=$firstpost AND thread=$id ".$ignore."ORDER BY date");
where $ignore would be a text string like "and id not in (1,2,3)" or would be blank...
If I can do something like that, I think I have a loop written out for the ignore function that would make this be something that wouldn't be unreasonable on the server. It just took figuring out that I only need to recompute that where clause when an ignored person is added to the list.
I'll talk to Adam to make sure I'm not being loony. This may be something that we can do at some point... I'm not promising anything.
Oh, and I'll pass on the handjob.
//edit: Adam isn't on IRC right now, I feel so lost. He must be sleeping I'll bug him later if I can't get this working on my own. Cross your fingers...
#7 Posted on 24.10.02 2228.02 Reposted on: 24.10.09 2228.26
Would there be a marker so that we could see where an ignored post fell? So at least if the topic took a sudden change in direction then we'd be able to figure that someone said something we aren't seeing?
Also, might this not lead to multiple repetitive posts by various people ignoring other people?
If someone I'm ignoring makes a new post, I'll still see that they added a new post to a given thread in the forum listing, but I won't know what specifically they said, right? Or is that select statement used for more than just thread generation?