Michael Brooks has discovered some vulnerabilities in phpRPG, which can be exploited by malicious people to conduct SQL injection attacks and to disclose sensitive information.

1) Input passed to the "username" and "password" parameters in index.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 of this vulnerability allows e.g. logging in as administrator without valid administrator credentials, but requires that "magic_quotes_gpc" is disabled.

2) A vulnerability is caused by not properly protecting session files in the "tmp/" directory. Directory listings for that directory contain the session IDs used by the application. This can be exploited to pass session IDs in the "PHPSESSID" cookie and take over other users' sessions.

Successful exploitation of this vulnerability requires that the web server is configured to display directory listings for the "tmp/" directory.

The vulnerabilities are confirmed in version 0.8.0. Other versions may also be affected.

Solution
Edit the source code to ensure that input is properly sanitised. Restrict access to the "tmp/" directory (e.g. with ".htaccess").

Provided and/or discovered by
Michael Brooks

Changelog
Further details available to Secunia VIM customers

Deep Links
Links available to Secunia VIM customers