function zen_get_faqs_to_faq_categories($faq_category_id, $include_inactive = false, $counts_what = 'faqs')
{
global $db;
$faqs_count = 0;
if ($include_inactive == true) {
switch ($counts_what) {
case 'faqs':
$cat_faqs_query = "select count(*) as total\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_TO_FAQ_CATEGORIES . " p2c\n where p.faqs_id = p2c.faqs_id\n and p2c.faq_categories_id = '" . (int) $faq_category_id . "'";
break;
case 'faqs_active':
$cat_faqs_query = "select p.faqs_id\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_TO_FAQ_CATEGORIES . " p2c\n where p.faqs_id = p2c.faqs_id\n and p2c.faq_categories_id = '" . (int) $faq_category_id . "'";
break;
}
} else {
switch ($counts_what) {
case 'faqs':
$cat_faqs_query = "select count(*) as total\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_TO_FAQ_CATEGORIES . " p2c\n where p.faqs_id = p2c.faqs_id\n and p.faqs_status = '1'\n and p2c.faq_categories_id = '" . (int) $faq_category_id . "'";
break;
case 'faqs_active':
$cat_faqs_query = "select p.faqs_id\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_TO_FAQ_CATEGORIES . " p2c\n where p.faqs_id = p2c.faqs_id\n and p.faqs_status = '1'\n and p2c.faq_categories_id = '" . (int) $faq_category_id . "'";
break;
}
}
$cat_faqs = $db->Execute($cat_faqs_query);
switch ($counts_what) {
case 'faqs':
$cat_faqs_count += $cat_faqs->fields['total'];
break;
case 'faqs_active':
while (!$cat_faqs->EOF) {
if (zen_get_faq_is_linked($cat_faqs->fields['faqs_id']) == 'true') {
return $faqs_linked = 'true';
}
$cat_faqs->MoveNext();
}
break;
}
$cat_child_faq_categories_query = "select faq_categories_id\n from " . TABLE_FAQ_CATEGORIES . "\n where parent_id = '" . (int) $faq_category_id . "'";
$cat_child_faq_categories = $db->Execute($cat_child_faq_categories_query);
if ($cat_child_faq_categories->RecordCount() > 0) {
while (!$cat_child_faq_categories->EOF) {
switch ($counts_what) {
case 'faqs':
$cat_faqs_count += zen_get_faqs_to_faq_categories($cat_child_faq_categories->fields['faq_categories_id'], $include_inactive);
break;
case 'faqs_active':
if (zen_get_faqs_to_faq_categories($cat_child_faq_categories->fields['faq_categories_id'], true, 'faqs_active') == 'true') {
return $faqs_linked = 'true';
}
break;
}
$cat_child_faq_categories->MoveNext();
}
}
switch ($counts_what) {
case 'faqs':
return $cat_faqs_count;
break;
case 'faqs_active':
return $faqs_linked;
break;
}
}
// show counts
$total_faqs = zen_get_faqs_to_faq_categories($faq_categories->fields['faq_categories_id'], true);
$total_faqs_on = zen_get_faqs_to_faq_categories($faq_categories->fields['faq_categories_id'], false);
echo $total_faqs_on . TEXT_FAQS_STATUS_ON_OF . $total_faqs . TEXT_FAQS_STATUS_ACTIVE;
}
?>
</td>
<td class="dataTableContent" width="50" align="left">
<?php
if ($faq_categories->fields['faq_categories_status'] == '1') {
echo '<a href="' . zen_href_link(FILENAME_FAQ_CATEGORIES, 'action=setflag_faq_categories&flag=0&cID=' . $faq_categories->fields['faq_categories_id'] . '&fcPath=' . $fcPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>';
} else {
echo '<a href="' . zen_href_link(FILENAME_FAQ_CATEGORIES, 'action=setflag_faq_categories&flag=1&cID=' . $faq_categories->fields['faq_categories_id'] . '&fcPath=' . $fcPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>';
}
if (zen_get_faqs_to_faq_categories($faq_categories->fields['faq_categories_id'], true, 'faqs_active') == 'true') {
echo ' ' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_LINKED);
}
?>
</td>
<td class="dataTableContent" align="right"><?php
echo $faq_categories->fields['sort_order'];
?>
</td>
<td class="dataTableContent" align="right">
<?php
echo '<a href="' . zen_href_link(FILENAME_FAQ_CATEGORIES, 'fcPath=' . $fcPath . '&cID=' . $faq_categories->fields['faq_categories_id'] . '&action=edit_faq_category') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . '</a>';
?>
<?php
echo '<a href="' . zen_href_link(FILENAME_FAQ_CATEGORIES, 'fcPath=' . $fcPath . '&cID=' . $faq_categories->fields['faq_categories_id'] . '&action=delete_faq_category') . '">' . zen_image(DIR_WS_IMAGES . 'icon_delete.gif', ICON_DELETE) . '</a>';
?>
