############################################################################################################
# Exploit Title : Wordpress Plugin Tierra Billboard Manager SQL Injection Vulnerability
# Exploit Author : Linux Zone Research Team
# Date : 14-December-2015
# Vendor Homepage: https://wordpress.org
# Software Link : https://wordpress.org/plugins/tierra-billboard-manager/
# Version : 1.14
# Tested on : Linux - Chrome
# CVE : NONE
# MY HOME : http://linux-zone.org
############################################################################################################
#
# Location : /wp-content/plugins/tierra-billboard-manager/tierra-billboard-playlist.php?id=[SQL]
#
############################################################################################################
<?php
header("Content-Type: text/html");
/*
if (isset($_GET['preview']) && $_GET['preview'] == 'true' ) {
header("Content-Type: application/xml;charset=utf-8");
} else {
header("Content-Type: application/xspf+xml;charset=utf-8");
}
*/
require_once('../../../wp-config.php');
require_once('../../../wp-settings.php');
global $wpdb, $_billboard_manager_db_version, $_billboard_manager, $baseurl, $pluginurl;
$_billboard_manager = $wpdb->prefix . "ti_billboard_manager";
$playlist_id = intval($_GET['id']);
$media_id = isset($_GET['media_id']) ? intval($_GET['media_id']) : -1;
$baseurl = $_SERVER["QUERY_STRING"];
$pluginURL = WP_PLUGIN_URL;
if ($media_id <= 0) {
$sql = 'select title, image, tracks, creation_date, license from ' . $_billboard_manager . ' where id = ' . $wpdb->escape($playlist_id);
} else {
$sql = 'select id, post_title as title, "' . $media_id . '" as tracks, post_date as creation_date from ' . $wpdb->posts . ' where id = ' . $media_id;
}
$row = $wpdb->get_row($sql);
$license = $row->license ? htmlentities($row->license) : '';
$title = htmlentities(stripslashes($row->title));
$tracks = split (',' , $row->tracks);
$i = 0;
echo<<<__END_OF_HEADER__
<?xml version="1.0" encoding="UTF-8"?>
<playlist version="1" xmlns = "http://xspf.org/ns/0/">
<title>$title</title>
<creator>Tierra Billboard Manager</creator>
<annotation>Playlist generated via Tierra Billboard Manager, part of the Tierra WordPress CMS Toolkit</annotation>
<info>http://tierra-innovation.com/wordpress-cms/</info>
<image>$pluginURL/tierra-billboard-manager/skin/brand.png</image>
<license>$license</license>
<date>$row->creation_date</date>
<trackList>
__END_OF_HEADER__
;
$wpuploads = wp_upload_dir();
if ($row->tracks) {
foreach ($tracks as $track) {
$sql = 'select id, post_title as track, guid, post_date, post_excerpt, post_modified from ' . $wpdb->posts . ' where id = ' . $track;
$row = $wpdb->get_row($sql);
if ($row) {
$metadata = get_post_meta($row->id, '_wp_attachment_metadata', true);
if ( ( $row->id = intval($row->id) ) && $thumb_url = get_attachment_icon_src( $row->id ) )
$thumb_url = htmlspecialchars($thumb_url[0]);
else {
$wpuploads = wp_upload_dir();
if ($metadata['file']) {
$path_parts = pathinfo($metadata['file']);
$datepath = $wpuploads['baseurl'] . "/" .$path_parts['dirname'];
}
$thumb_url = htmlspecialchars($metadata['sizes']['thumbnail']['file']
? ($datepath . '/' . stripslashes($metadata['sizes']['thumbnail']['file']) )
: "/wp-includes/images/crystal/interactive.png");
}
print "
<track>
<location>" . ( $row->guid ? htmlspecialchars($row->guid) : ( $wpuploads['baseurl'] . '/' . $metadata['file'] ))."</location>
<creator>" .( $metadata['_ti_bbm_artist'] ? htmlspecialchars($metadata['_ti_bbm_artist']) : "" )."</creator>
<album>" . ( $metadata['_ti_bbm_album'] ? htmlspecialchars($metadata['_ti_bbm_album']) : "" ). "</album>
<image>$thumb_url</image>
<title>" . ( $row->track ? htmlspecialchars($row->track) : "No title" ) . "</title>
<annotation>Type:" .$wpdb->escape($row->post_mime_type) .";</annotation>
<info>" . $wpdb->escape($metadata['_ti_bbm_linkTo']) ."</info>
<trackNum>" . $wpdb->escape($metadata['_ti_bbm_tracknum']) ."</trackNum>
<duration>" . $wpdb->escape($metadata['_ti_bbm_duration']) ."</duration>
<meta><description>" . htmlspecialchars(stripslashes($row->post_excerpt)) . "</description></meta>
</track>
";
}
}
}
print<<<__END_OF_XML__
</trackList>
</playlist>
__END_OF_XML__
;
?>
#############################################
#
# Hassan Shakeri - Mohammad Habili
#
# Twitter : @ShakeriHassan - Fb.com/General.BlackHat
##########################################################
