phpBB < 2.0.9 SQLi Vulnerability

# SPDX-FileCopyrightText: 2004 David Maciejak
# Some text descriptions might be excerpted from (a) referenced
# source(s), and are Copyright (C) by the respective right holder(s).
#
# SPDX-License-Identifier: GPL-2.0-only

CPE = "cpe:/a:phpbb:phpbb";

if(description)
{
  script_oid("1.3.6.1.4.1.25623.1.0.13655");
  script_version("2026-05-21T06:54:30+0000");
  script_tag(name:"last_modification", value:"2026-05-21 06:54:30 +0000 (Thu, 21 May 2026)");
  script_tag(name:"creation_date", value:"2005-11-03 14:08:04 +0100 (Thu, 03 Nov 2005)");
  script_tag(name:"cvss_base", value:"7.5");
  script_tag(name:"cvss_base_vector", value:"AV:N/AC:L/Au:N/C:P/I:P/A:P");

  script_tag(name:"qod_type", value:"remote_banner_unreliable");

  script_tag(name:"solution_type", value:"VendorFix");

  script_name("phpBB < 2.0.9 SQLi Vulnerability");

  script_category(ACT_GATHER_INFO);

  script_copyright("Copyright (C) 2004 David Maciejak");
  script_family("Web application abuses");
  script_dependencies("gb_phpbb_http_detect.nasl");
  script_mandatory_keys("phpbb/detected");

  script_tag(name:"summary", value:"phpBB is prone to an SQL injection (SQLi) vulnerability.");

  script_tag(name:"vuldetect", value:"Checks if a vulnerable version is present on the target host.");

  script_tag(name:"insight", value:"There is a flaw in the remote software which may allow anyone
  to inject arbitrary SQL commands, which may in turn be used to gain administrative access on the
  remote host or to obtain the MD5 hash of the password of any user.

  One vulnerability is reported to exist in 'admin_board.php'. The other pertains to improper
  characters in the session id variable.");

  script_tag(name:"affected", value:"phpBB prior to version 2.0.9.");

  script_tag(name:"solution", value:"Update to version 2.0.9 or later.");

  script_xref(name:"URL", value:"http://www.securityfocus.com/bid/10722");
  script_xref(name:"OSVDB", value:"7811");
  script_xref(name:"OSVDB", value:"7814");

  exit(0);
}

include("version_func.inc");
include("host_details.inc");

if( ! port = get_app_port( cpe:CPE ) )
  exit( 0 );

if( ! infos = get_app_version_and_location( cpe:CPE, port:port, exit_no_version:TRUE ) )
  exit( 0 );

vers = infos["version"];
path = infos["location"];

if( ereg( pattern:"^([01]\.|2\.0\.[0-8]([^0-9]|$))", string:vers ) ) {
  report = report_fixed_ver( installed_version:vers, fixed_version:"2.0.9", install_path:path );
  security_message( port:port, data:report );
  exit( 0 );
}

exit( 99 );