AOH :: HP Unsorted Nums :: TB11027.HTM

2z Project 0.9.5 SQL injection
- Sql Injection in 2z Project 0.9.5
- Sql Injection in 2z Project 0.9.5

[waraxe-2007-SA#051] - Sql Injection in 2z Project 0.9.5
Author: Janek Vind "waraxe"
Date: 23. May 2007
Location: Estonia, Tartu

Target software description:

Vulnerable: 2z Project 0.9.5
Patched: not yet :) 


1. Critical sql injection in "rating.php"

Let's start with peeking @ source code of "2z/includes/rating.php":

------------------[source code]----------------------
if ($_POST['rating']) {
	@include_once "../core.php";
	@header('Content-type: text/html; charset='.$lang['encoding']);
	LoadLang("news", "site");
if (!$_COOKIE['rating'.$row['id']]) {
	if (!$rating) {
else {
@setcookie('rating'.$post_id, 'voted', (time() + 31526000), '/'); 
	$mysql->query("UPDATE ".prefix."_news SET rating=rating+".$rating.",
	 votes=votes+1 WHERE id = '".$post_id."'");
------------------[/source code]----------------------

As we can track back - the $_POST['rating'] parameter will be used in
mysql "UPDATE" query without any sanitize at all! This seems to be
classical "sql injection in update query" case ...

So let's have fun and try some PoC:

------------------[PoC test]-----------------------
------------------[/PoC test]----------------------

Result: "Error! Bad query!"

What is important for this test to succeed, is that url to specific news
item must be valid. And then just add "?rating=xxx" or "&rating=xxx"
to url end and you will get error message, if target website is not patched.

So what are practical exploiting possibilities in this case?

1. Attacker can modify arbitrary news content on website.
This little piece of html code will change news author name to "1337" 
for ALL news items at the same time!

------------------[real-life exploit]-----------------------

action="http://localhost/2zcms/?category=none&altname=testnews" method="post">
------------------[/real-life exploit]---------------------- 2. Attacker can steal any data from mysql database. ======================================================== Exploit below will expose admins username and passwords double md5 hash in "author" field for all news items on website. So if attacker wants to be more sneaky, then sql query must be limited to update only one news item. How? Well, that's too easy, so I will not tell it here ;) ------------------[real-life exploit]-----------------------
action="http://localhost/2zcms/?category=none&altname=testnews" method="post">
------------------[/real-life exploit]---------------------- There is one important mitigating factor for this exploit to succeed: mysql daemon must have version >= 4.1 with sub queries functionality. //-----> See ya soon and have a nice day ;) <-----// How to fix: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Well, what can I suggest? Try to rush developers for releasing update ASAP :) Greetings: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Greets to str0ke, ToXiC, LINUX, y3dips, Sm0ke, Heintz, slimjim100, Chb, shai-tan and all other people who know me! Special greets goes to Raido Kerna. Tervitusi Torufoorumi rahvale! Contact: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Janek Vind "waraxe" Homepage: Shameless advertise: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Shorter url for easy use - Soon te be released sql injection tool - ---------------------------------- [ EOF ] ------------------------------------

The entire AOH site is optimized to look best in Firefox® 3 on a widescreen monitor (1440x900 or better).
Site design & layout copyright © 1986-2015 AOH
We do not send spam. If you have received spam bearing an email address, please forward it with full headers to