I am running an online adult business and as part of my compliance requirements with my payment processor, I need to ensure my site does not contain any words which are prohibited. Visa and Mastercard regularly scan my website to ensure compliance.
What I need is for someone to create a content management page which can scan all the tables in my SQL database to check for prohibited words.
For example if someone puts in their profile that they love to drink "alochol" then alochol is a prohibited word and should be flagged to me by email and also the word replaced with "Use of word in breach of Terms and Conditions - Update profile immediately". Something like this.
The review should be run every hour. If it finds nothing then send a report just to say no breaches found. Any breaches found should be sent in an email.
Also the user who made the breach should be emailed to say that your profile contained the word X and has therefore been updated by support because use of this word on our site is in breach of the terms and conditions of the site which you agreed to when signing up. Further breaches of the terms and conditions of the site may result in closure of your account.
Attached is a list of all the words that cannot appear anywhere on my website including in image and video files. Any thoughts on how to scan video and image files using OCR technology?
I look forward to hearing from competent freelancers.