<?php
// Get all index pages
function hd_get_all_index_pages(){
    global $wpdb;
    $table = $wpdb->base_prefix . ISETUP_DATA['table_name'];
    return $wpdb->get_results( "SELECT * FROM $table WHERE page_parent = 0" );
}

// Get all index pages count
function hd_get_index_pages_count($parent = 0){
    global $wpdb;
    $table = $wpdb->base_prefix . ISETUP_DATA['table_name'];
    $count = $wpdb->get_results( "SELECT * FROM $table WHERE page_parent = $parent" );
    return count($count);
}

// Get single index page
function hd_get_single_index_page($id = null, $value = null){
    if (!$id) {
        return false;
    }

    global $wpdb;
    $table = $wpdb->base_prefix . ISETUP_DATA['table_name'];
    $result = $wpdb->get_results( "SELECT * FROM $table WHERE page_id = $id" );
    
    if ($value) {
        return $result[0]->$value;
    } else {
        return $result;
    }
}