Facebook A+ Academy - SQL Injection Vulnerability

Introduction:
=============
The application is currently included and viewable by all facebook users.
The service is an external 3rd party application sponsored by the A+ Academy.

(Copy from the Vendors Homepage: http://apps.facebook.com/aplusacademy/)

Facebook is a social networking service and website launched in February 2004, operated and privately owned
by Facebook, Inc. As of July 2011, Facebook has more than 750 million active users. Users may create
a personal profile, add other users as friends, and exchange messages, including automatic notifications when
they update their profile. Facebook users must register before using the site. Additionally, users may join
common-interest user groups, organized by workplace, school or college, or other characteristics.

(Copy of the Vendor Website: http://en.wikipedia.org/wiki/Facebook)


Abstract:
=========
Vulnerability-Lab researcher discovered a remote SQL Injection vulnerability on the 3rd party web application - A+ Academy

(apps.facebook.com).


Report-Timeline:
================
2011-09-17:	Vendor Notification
2011-09-19:	Vendor Response/Feedback
2011-11-08:	Public or Non-Public Disclosure


Status:
========
Published


Affected Products:
==================

Exploitation-Technique:
=======================
Remote


Severity:
=========
High


Details:
========
A SQL Injection vulnerability is detected on the A+ Academy facebook application (apps.facebook).
The vulnerability allows  an attacker (remote) to inject/execute own sql statements on the affected fb application dbms.

Vulnerable Module(s):
			                           [+] A+ Academy- Facebook 3rd Party Application

Affected Application:
			                           [+] http://apps.facebook.com/aplusacademy/


--- SQL Error Logs/Exceptions ---
Database Error
Message:	MySQL Query fail: SELECT * FROM students WHERE fb_id=
MySQL Error:	You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ` at line 1
Date:	Monday, September 19, 2011 at 5:14:22 AM
Database Error
Message:	Result ID: could not be freed.
MySQL Error:	You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ` at line 1
Date:	Monday, September 19, 2011 at 5:14:22 AM
---

Solution:
=========
Use the prepared statement class to fix the sql injection vulnerability & filter sql error requests.
Set error(0) to prevent against information disclosure via exceptions or error reports.


Risk:
=====
The security risk of the sql injection vulnerability is estimated as high.