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>'; ?>