Php 3.3.5 modified code for foe notifications.

Moderators: Gamle-ged, Boadicea, currentsitguy

User avatar
SatansSon666
Posts: 14192
Joined: August 30th, 2020, 6:24 am
Has thanked: 152 times
Been thanked: 646 times

Php 3.3.5 modified code for foe notifications.

Unread post by SatansSon666 »

File: /phpbb/notification/type/quote.php
Line: 91
Original code.
$sql = 'SELECT user_id
FROM ' . USERS_TABLE . '
WHERE ' . $this->db->sql_in_set('username_clean', $usernames) . '
AND user_id <> ' . (int) $post['poster_id'];


Modified code to remove foe notifications for quoted posts.
$sql = 'SELECT user_id
FROM ' . USERS_TABLE . ' AS usr
WHERE ' . $this->db->sql_in_set('username_clean', $usernames) . '
AND user_id <> ' . (int) $post['poster_id'] . '
AND NOT EXISTS(SELECT * FROM ' . ZEBRA_TABLE . ' AS zbr WHERE zbr.user_id = usr.user_id AND zbr.zebra_id = ' . (int) $post['poster_id'] . ' AND zbr.foe <> 0)';
User avatar
Charlie Mike
Posts: 27791
Joined: May 8th, 2021, 6:14 am
Has thanked: 1869 times
Been thanked: 5789 times

Re: Php 3.3.5 modified code for foe notifications.

Unread post by Charlie Mike »

Written in SNVL 3.0
Baron
Posts: 2794
Joined: August 3rd, 2021, 4:41 pm
Has thanked: 227 times
Been thanked: 634 times

Re: Php 3.3.5 modified code for foe notifications.

Unread post by Baron »

Charlie Mike wrote: September 12th, 2022, 4:30 pm Written in SNVL 3.0
Charlie,

He just can't accept the fact that he is his own worst enemy.
He may eventually grow up some day, but I wouldn't bet my lunch money on it.

Take care,
Baron
User avatar
SatansSon666
Posts: 14192
Joined: August 30th, 2020, 6:24 am
Has thanked: 152 times
Been thanked: 646 times

Re: Php 3.3.5 modified code for foe notifications.

Unread post by SatansSon666 »

The usual suspects show up, probably to insult me in the fuckin' help section simply because I offered up code to stop notifications when people are on ignore.
Maybe I'm wrong, but I'd bet dollars to donuts that's what they did.
Baron
Posts: 2794
Joined: August 3rd, 2021, 4:41 pm
Has thanked: 227 times
Been thanked: 634 times

Re: Php 3.3.5 modified code for foe notifications.

Unread post by Baron »

SatansSon666 wrote: September 13th, 2022, 5:37 am The usual suspects show up, probably to insult me in the fuckin' help section simply because I offered up code to stop notifications when people are on ignore.
Maybe I'm wrong, but I'd bet dollars to donuts that's what they did.
You have single handedly turned the Help section into the Humor section.

Regards,
Baron
Post Reply