A user can inject any SQL command they want to delete all messages from the messaging system. The script was last updated on March 28, 2018, so there may be new vulnerabilities discovered since then. If you are running this script on your website, we highly recommend you upgrade to version 1.1.

How the Delete All Messages Script Works

The script uses the mysql database, which is vulnerable to SQL injection. This vulnerability allows a user to execute any command they want to delete all messages from the messaging system. All they have to do is inject any SQL command into the script and it will run it against the database.
Because of this vulnerability, users have been able to delete messages from their account. If you are running this script on your website, we highly recommend you upgrade to version 1.1 or higher.

How to find out if you are vulnerable to sql injection attacks

To find out if your website is vulnerable to SQL injection attacks, use the following query in a browser:

select * from sys.objects where name = 'messages' and type = 'TEXT'
If the results section of the table includes a column named "message_id" then this means that you are vulnerable to SQL injection attacks. If it does not show a column for message_id then you should be safe from these types of attacks.

Timeline

Published on: 10/06/2022 18:17:00 UTC
Last modified on: 10/06/2022 19:13:00 UTC

References