($row[0]+5))))
{
// ignore, mismatched bpm
}
else
{
$selected_vocal = (int)$_GET['selected_vocal'];
$passback_selected_vocal = (int)$_GET['selected_vocal'];
$selected_vocal_title = $row[1];
$bpm_match = $row[0];
}
}
}
}
if (isset($_GET['beat_volume']))
{
$beat_volume = (int)$_GET['beat_volume'];
}
if (isset($_GET['vocal_volume']))
{
$vocal_volume = (int)$_GET['vocal_volume'];
}
if (isset($_GET['beat_speed']))
{
$beat_speed = (int)$_GET['beat_speed'];
}
if (isset($_GET['vocal_speed']))
{
$vocal_speed = (int)$_GET['vocal_speed'];
}
$bpm_match_where = "";
if ($bpm_match!=-1)
{
$bpm_match_where = " AND bpm_match > " . ($bpm_match-5) . " AND bpm_match < " . ($bpm_match+5);
}
$beat_search_like = "%";
$beat_search_formdata = "";
if (isset($_GET['beat_search_text']))
{
$beat_search_like = "%" . addslashes($_GET['beat_search_text']) . "%";
$beat_search_formdata = $_GET['beat_search_text'];
}
$vocal_search_like = "%";
$vocal_search_formdata = "";
if (isset($_GET['vocal_search_text']))
{
$vocal_search_like = "%" . addslashes($_GET['vocal_search_text']) . "%";
$vocal_search_formdata = $_GET['vocal_search_text'];
}
$bquery_res = mysql_query("SELECT component_id, component_title, bpm_match FROM funk.component_catalog WHERE lite_component = 'Y' and bpm_match is not NULL AND component_type = 'B'" . $bpm_match_where . " AND component_title LIKE '" . $beat_search_like . "'");
$vquery_res = mysql_query("SELECT component_id, component_title, bpm_match FROM funk.component_catalog WHERE lite_component = 'Y' and bpm_match is not NULL AND component_type = 'V'" . $bpm_match_where . " AND component_title LIKE '" . $vocal_search_like . "'");
?>
