====================================================================== 

                     Secunia Research 29/06/2006

      - phpRaid SQL Injection and File Inclusion Vulnerabilities -

====================================================================== 
Table of Contents

Affected Software....................................................1
Severity.............................................................2
Vendor's Description of Software.....................................3
Description of Vulnerability.........................................4
Solution.............................................................5
Time Table...........................................................6
Credits..............................................................7
References...........................................................8
About Secunia........................................................9
Verification........................................................10

====================================================================== 
1) Affected Software 

phpRaid 3.0.4, 3.0.5, 3.0.6

Other versions may also be affected.

====================================================================== 
2) Severity 

Rating: Highly critical
Impact: System access, manipulation of data
Where:  From remote

====================================================================== 
3) Vendor's Description of Software 

"phpRaid is a raid management tool for World of Warcraft"

Product Link:
http://www.spiffyjr.com

====================================================================== 
4) Description of Vulnerability

Secunia Research has discovered some vulnerabilities in phpRaid, which
can be exploited by malicious people to conduct SQL injection attacks or
to compromise a vulnerable system.

1) Input passed to the "raid_id" parameter in view.php is not properly
sanitised before being used in SQL queries. This can be exploited to
manipulate SQL queries by injecting arbitrary SQL code.

Successful exploitation requires that "magic_quotes_gpc" is disabled.

The vulnerability has been confirmed in version 3.0.4. Prior versions
may also be affected.

2) Input passed via the URL is not properly sanitised before being used
in a SQL query in the "log_hack()" function in
includes/functions_logging.php. This can be exploited to manipulate SQL
queries by injecting arbitrary SQL code.

Successful exploitation requires that "magic_quotes_gpc" is disabled.

The vulnerability has been confirmed in version 3.0.5. Other versions
may also be affected.

3) Input passed to the "phpraid_dir" parameter in multiple files is not
properly verified before being used to include files. This can be
exploited to execute arbitrary PHP code by including files from local or
external resources.

Affected files:
configuration.php
guilds.php
index.php
locations.php
login.php
lua_output.php
permissions.php
profile.php
raids.php
register.php
roster.php
view.php
logs.php (included in version 3.0.5)
users.php (included in version 3.0.5)

Successful exploitation requires that "register_globals" is enabled.

The vulnerabilities have been confirmed in version 3.0.4 and 3.0.5.
Prior versions may also be affected.

4) Input passed to the "phpraid_dir" parameter in announcements.php and
rss.php is not properly verified before being used to include files.
This can be exploited to execute arbitrary PHP code by including files
from local or external resources.

Successful exploitation requires that "register_globals" is enabled.

The vulnerabilities have been confirmed in version 3.0.6. Other versions
may also be affected.

5) Input passed to the "username" and "email" form field parameters in
register.php is not properly sanitised before being used in a SQL query.
This can be exploited to manipulate SQL queries by injecting arbitrary
SQL code.

Note: This is only vulnerable if the option "phpraid" is chosen as
authorisation type. Successful exploitation can give an attacker access
to the administration section.

Successful exploitation requires that "magic_quotes_gpc" is enabled.

The vulnerabilities have been confirmed in version 3.0.6. Other versions
may also be affected. 

====================================================================== 
5) Solution 

Vulnerability #1 has been fixed in version 3.0.5, and vulnerabilities 
#2 and #3 have been fixed in version 3.0.6.

Edit the source code to ensure that input is properly verified and
sanitised. 

====================================================================== 
6) Time Table 

26/05/2006 - Initial vendor notification.
29/05/2006 - Vendor response.
30/05/2006 - Second vendor notification.
08/06/2006 - Third vendor notification.
29/06/2006 - Public disclosure.

====================================================================== 
7) Credits 

Discovered by Sven Krewitt, Secunia Research.

====================================================================== 
8) References

The Common Vulnerabilities and Exposures (CVE) project has assigned
CVE-2006-3115 (SQL injection) and CVE-2006-3116 (file inclusion) for
the vulnerabilities. 

====================================================================== 
9) About Secunia 

Secunia collects, validates, assesses, and writes advisories regarding 
all the latest software vulnerabilities disclosed to the public. These 
advisories are gathered in a publicly available database at the 
Secunia website:

http://secunia.com/

Secunia offers services to our customers enabling them to receive all 
relevant vulnerability information to their specific system 
configuration. 

Secunia offers a FREE mailing list called Secunia Security Advisories: 

http://secunia.com/secunia_security_advisories/

====================================================================== 
10) Verification 

Please verify this advisory by visiting the Secunia website:
http://secunia.com/secunia_research/2006-47/

Complete list of vulnerability reports published by Secunia Research:
http://secunia.com/secunia_research/

======================================================================