Bugtraq mailing list archives

Writers Block SQL Injection Vulnerabilities


From: nebelfrost23 () web de
Date: 2 Apr 2008 12:29:09 -0000

[>>] 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


Current thread: