public static function isBlacklisted($url)
 {
     @($url_parsed = parse_url($url));
     if (isset($url_parsed['host'])) {
         $url = $url_parsed['host'] . '/';
         //follow google canonicalization rules
         $url = urldecode($url);
         //remove hex encodings
         $url = preg_replace('/^\\.*/', '', $url);
         //remove leading dots
         $url = preg_replace('/\\.*$/', '', $url);
         //remove trailing dots
         $url = preg_replace('/\\.+/', '.', $url);
         //replace consecutive dots
         $url = preg_replace('/\\/+/', '/', $url);
         //replace consecutive slashes
         $hash = md5($url);
         $sql = "SELECT * FROM `malware_hashes` WHERE `hash` = '{$hash}'";
         $result = DatabaseFactory::ea_safe_browsing_db()->query($sql);
         return $result->num_rows ? true : false;
     }
 }