-------------
*/ // set up the final content array and query // first determine how many we have checked // if we have none, then show everything // if we have one, show everything checked // if we have more than one, then we need to create a variable set of array variables to pull in the correct tables. $has_values_checked_total = $has_values_categories + $has_values_levels + $has_values_classes; if($has_values_checked_total == 0) { // do nothing, let the main query run. } elseif($has_values_checked_total == 1) { // merge all of the arrays to catch the one that is populated $final_content_array = array_merge($array_categories_content, $array_levels_content, $array_classes_content); } else { // if more than one of the categories is checked, then we need to intersect the arrays in order // to get only the ones that apply to all three categories. $args = array(); if ( !empty($array_categories_content) ) $args[] = &$array_categories_content; if ( !empty($array_levels_content) ) $args[] = &$array_levels_content; if ( !empty($array_classes_content) ) $args[] = &$array_classes_content; if ( count($args) == 1 ) { $final_content_array = $args[0]; } else { $final_content_array = call_user_func_array('array_intersect', $args); } } ?>
$value)
{
// echo " content id |" . $value . "
";
// add to the or_conditions
if ($first_or == 0)
{
// if this is not the first or, add the or to the statement
$or_conditions = $or_conditions . " OR content.content_id = " . $value;
}
else
{
// if this IS the first or, add the or to the statement without the OR
$or_conditions = $or_conditions . " content.content_id = " . $value;
// now that we've processed the first or , set the first_or variable to 0
$first_or = 0;
}
// set the or_conditions_trigger to 1
$or_conditions_trigger = 1;
}
// if the or_conditions trigger is 1 (there were entries in the or) then add the front and back ends
// so that it fits nicely in the query. Otherwise, there were no or_conditions and the or_conditions
// should remain ""
if ($or_conditions_trigger == 1)
{
// there was a set of or_conditions so add a front and back to the query
$or_conditions = " AND (" . $or_conditions . ")";
}
else
{
// do nothing and let the or_conditions variable remain blank
}
// echo "-----
";
// echo $or_conditions;
?>