Php 3.3.5 modified code for foe notifications.

Moderators: Gamle-ged, Boadicea, currentsitguy

User avatar
SatansSon666
Posts: 10038
Joined: August 30th, 2020, 6:24 am
Has thanked: 88 times
Been thanked: 401 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: 18640
Joined: May 8th, 2021, 6:14 am
Has thanked: 1326 times
Been thanked: 3591 times

Re: Php 3.3.5 modified code for foe notifications.

Unread post by Charlie Mike »

Written in SNVL 3.0
Baron
Posts: 1502
Joined: August 3rd, 2021, 4:41 pm
Has thanked: 47 times
Been thanked: 298 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: 10038
Joined: August 30th, 2020, 6:24 am
Has thanked: 88 times
Been thanked: 401 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: 1502
Joined: August 3rd, 2021, 4:41 pm
Has thanked: 47 times
Been thanked: 298 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