Anybody has an idea, how to sync "sip show peers" with a table in MYSQL.
I already have a script made to write from result of "sip show peers" to MYSQL table (peer, IP address...).
But how can I know if an admin deletes peer from FreePBX. How can I get this information to update the MySQL table, that the peer is deleted?
Right now I use "Truncate table..." (delete the table) before I make an "insert into...". But it is not a good solution. Instead of "Truncate" I would like to check if there is any changes in peers ...