#
# This script was written by Georges Dagousset <georges.dagousset@alert4web.com>
#
# Script audit and contributions from Carmichael Security <http://www.carmichaelsecurity.com>
#      Erik Anderson <eanders@carmichaelsecurity.com>
#      Added BugtraqID
#
# See the Nessus Scripts License for details
#

if(description)
{
 script_id(10856);
 script_version("$Revision$");
 script_bugtraq_id(3906);
 script_name(english:"PHP-Nuke sql_debug Information Disclosure");
 desc["english"] = "
In PHP-Nuke, the sql_layer.php script contains a debugging feature
that may be used by attackers to disclose sensitive information about all SQL 
queries.
Access to the debugging feature is not restricted to administrators.

Solution : Add '$sql_debug = 0;' in config.php.

Risk factor : Low";
 script_description(english:desc["english"]);
 script_summary(english:"Make a request like http://www.example.com/?sql_debug=1");
 script_category(ACT_GATHER_INFO);
 script_family(english:"General");
 script_copyright(english:"This script is Copyright (C) 2002 Alert4Web.com");
 script_dependencie("find_service.nes");
 script_require_ports("Services/www", 80);
 exit(0);
}

#
# The script code starts here
#

include("http_func.inc");

port = get_kb_item("Services/www");
if(!port)port = 80;

if(get_port_state(port))
{
 soc = http_open_socket(port);
 if(soc)
 {
  req = http_get(item:"/?sql_debug=1", port:port);
  send(socket:soc, data:req);
  r = http_recv(socket:soc);
  http_close_socket(soc);
  if("SQL query: " >< r)security_warning(port:port);
 }
}