XF 2.2 delete from x with thread_id when thread is deleted

[Robert9]

I have a table x; it has a field thread_id

if thread 212 is deleted (or merged?!), I want to delete the column in x where thread_id is 212

i found entity_post_delete, but no entity_thread_delete


i found a listener with something like:

    public static function threadEntityPostDelete(\XF\Mvc\Entity\Entity $entity)
    {
        $entity->db()->delete('xf_r9_example', 'thread_id = ?', $entity->thread_id);
    }

Do we have another example to delete something?
resource and thread is one; i will check it.

 

[Kirby]

i found entity_post_delete

This code event is fired after any entity has been deleted ("post deletion").

If you hint your listener with \XF\Entity\Thread it will be called after a thread entity has been deleted.

 

[Robert9]

1.
protected function _postDelete() in entity thread can have a new line to
$db->delete('xf_my_table', 'thread_id = ?', $this->thread_id);

 

[Robert9]

class Thread extends XFCP_Thread
{
    protected function _postDelete()
    {
        parent::_postDelete();

        $this->db()->query('DELETE FROM xf_r9_example WHERE thread_id  = ?', $this->thread_id);
    }
}

 

[Kirby]

You can do this, but you should not.

Resource Standards Rule # 20

 

[Robert9]

But i still fight with soft delete and undelete;
result should be:

$this->db()->query('UPDATE xf_r9_example SET thread_state = 'visible' WHERE thread_id = ?', $this->thread_id);
$this->db()->query('UPDATE xf_r9_example SET thread_state = 'deleted' WHERE thread_id = ?', $this->thread_id);

 

[Robert9]

Here it is 2:04 am; everything i do now, must work.

 

[Robert9]

It seems many people use this way; also the RM has code like this.
Some use a repo.