Are there any pitfalls in connecting to the DB and making changes directly?

[Razasharp]

I am thinking about creating a script that will check my inbox for any emails that have bounced, and then put the user's state into 'bounced' directly by connecting to the database (from my script).

Are their any pitfalls to me doing this? Does XF need some sort of 'updated_at' columns updated too? Or will just changing the state to email bounce be ok?

 

[Mike Edge]

Nope, should work just fine.

 

[DeltaHF]

I'm actually doing the same thing, only my script responds to "webhook events" from SendGrid, my email provider. They send a request to a URL when they attempt to deliver an email that has bounced, been rejected, or deferred (documentation here).

So far, there have been no ill effects.

 

[Digital Doctor]

Are their any pitfalls ?

Yes, there are Pitfalls !



Directly changing the database is fine.
But my arrow points to the pit where you can fall, in Pitfall(TM).