alert http $EXTERNAL_NET any -> $HTTP_SERVERS any (
msg:"ET WEB_SPECIFIC_APPS Superfreaker Studios UPublisher SQL Injection Attempt -- preferences.asp ID SELECT";
flow:established,to_server;
http.uri;
content:"/preferences.asp?"; nocase;
content:"ID="; nocase;
content:"SELECT"; nocase;
pcre:"/.+SELECT.+FROM/i";
reference:cve,CVE-2006-6398;
reference:url,www.securityfocus.com/archive/1/archive/1/453462/100/0/threaded;
classtype:web-application-attack;
sid:2006651; rev:8;
metadata:affected_product Web_Server_Applications, attack_target Web_Server, created_at 2010_07_30, deployment Datacenter, confidence Medium, signature_severity Major, tag SQL_Injection, updated_at 2020_09_09, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
)