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.
Just be sure to make the Zim Brothers IDs un-ignorable.
-Jag
With poison running through your veins, and death marching solemnly towards you, heroic acts become more of a necessity as you see your time dwindling.
Vanquishing your enemies, making amends to those you have wronged, and leaving words of love and kindness for those around you become second nature as your own mortality looms
However, true strength lies not in these last desperate acts, but in the actions of one who has to get out of bed the next day and face the consequences of doing that which you believe is right.
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?
Is it possible for the people posting the survivor threads to observe spoiler ettiquette? Us poor Aussies see the same episode on the next Tuesday and a quick browse through the Random folder sort of ruins the surprise, if any, of the tribal council.