stevemaury wrote:Here's a little ditty you can try. What it will do is make the troll the foe of all other users so, ordinarily they would see this instead of his posts:
First, run this SQL to make the troll a foe of all users (only will apply to existing users until run again):This post was made by Troll who is currently on your ignore list. click here to display this post.
N is the user_id of the troll.Code: Select all
INSERT INTO phpbb_zebra (user_id, zebra_id, foe) SELECT user_id, N, 1 FROM phpbb_users WHERE user_type <> 2 AND user_id != N AND user_id NOT IN(SELECT user_id FROM phpbb_zebra WHERE zebra_id = N AND foe = 1);
Then make this edit to remove the message (which will remove it for all foes of all users, but if they really want them to be foes, they shouldn't mind):
OPEN language/en/common.php
FIND:
REPLACE WITH:Code: Select all
'POST_BY_FOE' => 'This post was made by <strong>%1$s</strong> who is currently on your ignore list. %2$sDisplay this post%3$s.',
Backup the zebra table first.Code: Select all
'POST_BY_FOE' => '',
To undo this, run this SQL:and reverse the language file edit.Code: Select all
DELETE FROM phpbb_zebra WHERE zebra_id = N;
So, no one will see his posts and he will not know it.