SecurityReason - Writer's Block SQL Injection Vulnerabilities

Advisory Text :

[>>] Writer's Block SQL Injection Vulnerabilities [<<]

[x] Vendor Information

"If the written word is the wheel, then Writer's Block is the sweet, sweet
fossil fuel in the

engine that keeps it spinning. A free, flexible, elegant Content Management
System that helps

you maintain any web site you want, at any size you want, with no hassle
and no restrictions.

In fact, it's running this entire site right now."

http://www.desiquintans.com

[x] Attack Information

The variable "PostID" can be filled with malicious content to execute SQL
code:

----

permalink.php, line 212:

$getpost = @mysql_query("SELECT Title, Timestamp, Body, PostCat1, PostCat2,
PostCat3, PostCat4, Author FROM ".POSTS_TBL." WHERE

PostID='".$_GET['PostID']."' AND Draft=0");

----

permalink.php, line 298:

$prevlink = mysql_query("SELECT PostID FROM ".POSTS_TBL." WHERE
PostID<".$_GET['PostID']." AND Draft=0 ORDER BY Timestamp DESC LIMIT 1");

----

permalink.php, line 304:

$nextlink = mysql_query("SELECT PostID FROM ".POSTS_TBL." WHERE
PostID>".$_GET['PostID']." AND Draft=0 ORDER BY Timestamp ASC LIMIT 1");

----

[x] Exploit

The issue can be exploited through a web browser.

[x] Patch

Just add an intval():

----

permalink.php, line 212:

$getpost = @mysql_query("SELECT Title, Timestamp, Body, PostCat1, PostCat2,
PostCat3, PostCat4, Author FROM ".POSTS_TBL." WHERE

PostID='".intval($_GET['PostID'])."' AND Draft=0");

----

permalink.php, line 298:

$prevlink = mysql_query("SELECT PostID FROM ".POSTS_TBL." WHERE
PostID<".intval($_GET['PostID'])." AND Draft=0 ORDER BY Timestamp DESC
LIMIT 1");

----

permalink.php, line 304:

$nextlink = mysql_query("SELECT PostID FROM ".POSTS_TBL." WHERE
PostID>".intval($_GET['PostID'])." AND Draft=0 ORDER BY Timestamp ASC LIMIT
1");

----

[x] Credits

The vulnerability has been discovered by katharsis -

www.katharsis.x2.to