Whatsapp bot python + MySQL

create a WhatsApp bot that queries a MySQL database.

I have a wordpress website (listings). I want the owners to be identified by the bot if their WhatsApp number matches the database and return the profile view link and profile edit link.

If they don't have a WhatsApp number in the DB, they can identify themselves by email and send a verification code.

Users can ask for help at any time

Requeriments:

WhatsApp bot python
Dashboard
Installation in my VPS server
Configuration

Restart command = "Restart" 

End conversation = After 1 hour without interactivity (Cron) 




Dashboard: 



1. General settings 


API's, keys, emails, etc. 



2. Conversations 


View conversations 


reply chat 


restart conversation command = "Restart" 


Warning when user request chat






MySQL


query= user_id from= ib_usermeta 

select ID, post_title, post_name from ib_posts
post_type = 'listing' and post_status = 'publish' and post_author = {userid}