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...
(edited by Guru Zim on 24.10.02 1548) I am not your mother.
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?
As I've noted before, we lost a lot of Google juju around Columbus Day 2008 but did get some portion of it back around June 19th. So there's a lot of repeat action but amongst the new entries, mostly stuff started in the second half of the year.