Exemplos de tep_get_faq_tree em PHP

Exemplo n.º 1

Arquivo: general.php Projeto: rongandat/ookcart-project

function tep_get_faq_tree($parent_id = '0', $spacing = '', $exclude = '', $faq_tree_array = '', $include_itself = false)
{
    global $languages_id;
    if (!is_array($faq_tree_array)) {
        $faq_tree_array = array();
    }
    if (sizeof($faq_tree_array) < 1 && $exclude != '0') {
        $faq_tree_array = array('' => '');
    }
    if ($include_itself) {
        $faq_query = db_query("select cd.faqs_name from " . _TABLE_FAQS_DESCRIPTION . " cd where cd.language_id = '" . (int) $languages_id . "' and cd.faqs_id = '" . (int) $parent_id . "'  and is_topic");
        $faq = db_fetch_array($faq_query);
        $faq_tree_array[$parent_id] = $faq['faqs_name'];
    }
    $faqs_query = db_query("select c.faqs_id, cd.faqs_name, c.parent_id from " . _TABLE_FAQS . " c, " . _TABLE_FAQS_DESCRIPTION . " cd where c.faqs_id = cd.faqs_id and cd.language_id = '" . (int) $languages_id . "' and c.parent_id = '" . (int) $parent_id . "' and is_topic order by c.sort_order, cd.faqs_name");
    while ($faqs = db_fetch_array($faqs_query)) {
        if ($exclude != $faqs['faqs_id']) {
            $faq_tree_array[$faqs['faqs_id']] = $spacing . $faqs['faqs_name'];
        }
        $faq_tree_array = tep_get_faq_tree($faqs['faqs_id'], $spacing . '&nbsp;&nbsp;&nbsp;', $exclude, $faq_tree_array);
    }
    return $faq_tree_array;
}

Exemplo n.º 2

Arquivo: list.php Projeto: rongandat/e-global-cya

include 'includes/admin_login_check.php';
include _CLASSES_DIR . 'paginator.php';
$action = $_POST['action'];
$parent_id = isset($_REQUEST['parent_id']) ? (int) $_REQUEST['parent_id'] : 0;
switch ($action) {
    case 'deleteconfirm':
        $faq_id = (int) $_POST['faqID'];
        db_query("DELETE  FROM " . _TABLE_FAQS . " WHERE faqs_id='" . $faq_id . "'");
        db_query("DELETE  FROM " . _TABLE_FAQS_DESCRIPTION . " WHERE faqs_id='" . $faq_id . "'");
        $feedbackmsgs[] = TEXT_MESSAGE_FAQS_DELETED;
        $smarty->assign('feedbackmsgs', $feedbackmsgs);
        break;
}
// get faqs tree
$faqs_tree = tep_get_faq_tree(0, ' ');
$smarty->assign('faqs_tree', $faqs_tree);
$smarty->assign('parent_id', $parent_id);
//Template generate
$smarty->assign('link_faqs', get_admin_link(PAGE_FAQS, array('action', 'module', 'page')));
$smarty->assign('link_faq_new', get_admin_link(PAGE_FAQ_NEW, tep_get_all_get_params(array('action', 'module', 'page'))) . '&action=new');
$smarty->assign('link_faq_edit', get_admin_link(PAGE_FAQ_EDIT, tep_get_all_get_params(array('action', 'module', 'page'))));
$sql_faqs = "select c.faqs_id, cd.faqs_name, c.parent_id, sort_order, faqs_status, is_topic from " . _TABLE_FAQS . " c, " . _TABLE_FAQS_DESCRIPTION . " cd where c.faqs_id = cd.faqs_id and cd.language_id = '" . (int) $_SESSION['languages_id'] . "' and c.parent_id = '" . (int) $parent_id . "' ";
$sql_faqs_page = $sql_faqs . " order by is_topic DESC, c.sort_order, cd.faqs_name ";
$faqs_query = db_query($sql_faqs);
$faq_numbers = db_num_rows($faqs_query);
$faqpage =& new Paginator($_GET['pg'], $faq_numbers);
$faqpage->set_Limit(20);
$faqpage->pagename = get_admin_link(PAGE_SETTINGS, tep_get_all_get_params(array('pg', 'x', 'y')));
$faqpage->set_Links(6);
$limit1 = $faqpage->getRange1();