Delete Photo - Notifications not removed(not a bug)

[DJT]

I noticed that when a members deleted a photo that has email notifications set by other members, that the notifications are not deleted. So when you view a member who had lots of notifications which are gone, they appear blank.

When a photo is deleted, does PP scan for members who received notification and remove them?

[Chuck S]

When a photo is deleted all instances of things for that photo are deleted as can be seen by these queries in editphoto.php

$query = "DELETE FROM {$Globals['pp_db_prefix']}photos WHERE id=$phoedit";
$resulta = ppmysql_query($query, $link);

$query = "DELETE FROM {$Globals['pp_db_prefix']}comments WHERE photo=$phoedit";
$resulta = ppmysql_query($query, $link);

$query = "DELETE FROM {$Globals['pp_db_prefix']}exif WHERE photoid=$phoedit";
$resulta = ppmysql_query($query,$link);

$query = "DELETE FROM {$Globals['pp_db_prefix']}notify WHERE photo=$phoedit";
$resulta = ppmysql_query($query,$link);

$query = "DELETE FROM {$Globals['pp_db_prefix']}photoextras WHERE photo=$phoedit";
$resulta = ppmysql_query($query,$link);

adminlog( "Photo Deleted: $filename (#$phoedit) $ptitle" );

[DJT]

Correct however there are instances where this is not accomplished:

1. Delete all of a members photos when an admin views their profile. This executes adm-cats.php with the delphotos sub. This deletes all SQL entries for that members photos, executes remove_all_files which deletes the image files, then executes the upgrade_categories sub. No where are the notifications that are tied to any of the photos removed.

2. The same process as above is executed if an administrator deletes a member from the admin console. Notifications are not removed for any photos that other members may have been set to receive.

[Chuck S]

I would need to investigate those two claims however that is not the support request you submitted My answer is based on what you submitted

[DJT]

I know it has grown a bit from my origional question. I wasn't sure why I was viewing members profiles and seeing lots of "Photo Notifications" on the right hand side of the page with no description or link, just a blank box with a check box to delete. I wasnt sure how that was being done until I investigated further.

[Chuck S]

In adm-cats.php and adm-users.php find this lines

Content visible to verified customers only.

add below it this

Content visible to verified customers only.