}
// markDeleted - marks user and its associated things as deleted.
- // TODO: address the problem when a deleted user has a scheduled notification configured,
- // in which case all other notifications may stop working because of MySQL syntax error.
static function markDeleted($user_id) {
$mdb2 = getConnection();
global $user;
if (is_a($affected, 'PEAR_Error'))
return false;
+ // Mark favorite reports as deleted.
+ $sql = "update tt_fav_reports set status = NULL where user_id = $user_id";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
// Mark user as deleted.
$sql = "update tt_users set status = NULL where id = $user_id";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;
+ // Mark favorite reports as deleted.
+ $sql = "update tt_fav_reports set status = NULL where user_id = $user_id";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
// Mark user as deleted.
$sql = "update tt_users set status = NULL where id = $user_id and team_id = ".$user->team_id;
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;
+ // Mark favorite reports as deleted.
+ $sql = "update tt_fav_reports set status = NULL where user_id = $user_id";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
// Mark user as deleted.
$sql = "update tt_users set status = NULL where id = $user_id and team_id = ".$user->team_id;
$affected = $mdb2->exec($sql);