prefix .MAM_AUCTION_CATEGORIES_TABLE;
$MAM_AUCTION_CATEGORY_TABLE = $wpdb->prefix .MAM_AUCTION_CATEGORY_TABLE;

$mcid = intval(sanitizeData($_REQUEST[‘mcid’],’xss_clean’));
$root_link=$_GET[‘root_link’];

include(“mam_breadcrumb_not_login.php”);

session_start();
$_SESSION[‘not_login’]=’not_login’;
$trail = new Breadcrumb();
$category = $wpdb->get_row(“SELECT *FROM $MAM_AUCTION_CATEGORIES_TABLE WHERE category_name_id = ‘”.$mcid.”‘”);
$name = $category->category_name;
$categoryHomeLink=$root_link.’&pid=16′;
$trail->add(“$name”,” getPage(4,9,’$mcid’,’$root_link’)”,1,$categoryHomeLink);

//Now output the navigation.
$trail->output();

?>

get_results(“SELECT *FROM $MAM_AUCTION_CATEGORIES_TABLE WHERE category_parent_id = ‘”.$mcid.”‘”);
foreach($get_scat as $scat){
$scid[] = $scat -> category_name_id;

$count_auction = $wpdb->get_var(“SELECT count( * )
FROM wp_mam_auction_categories AS ac
INNER JOIN wp_mam_categories AS c1 ON c1.category_name_id = ac.category_id
INNER JOIN wp_mam_categories AS c2 ON c2.category_name_id = c1.category_parent_id
INNER JOIN wp_mam_categories AS c3 ON c3.category_name_id = c2.category_parent_id
INNER JOIN wp_mam_auctions AS a ON a.auction_id = ac.auction_id
WHERE c2.category_name_id =’$scid[$i]’
AND a.auction_status_id = ‘1’ AND a.sold=’0′
AND TIMESTAMPDIFF(MINUTE , ‘$curDate’, a.date_expiry ) >’0′”);

$count_sub_auction = $wpdb->get_var(“SELECT count( * )
FROM wp_mam_auction_categories AS ac
INNER JOIN wp_mam_categories AS c2 ON c2.category_name_id = ac.category_id
INNER JOIN wp_mam_categories AS c3 ON c3.category_name_id = c2.category_parent_id
INNER JOIN wp_mam_auctions AS a ON a.auction_id = ac.auction_id
WHERE c2.category_name_id =’$scid[$i]’
AND a.auction_status_id = ‘1’ AND a.sold=’0′
AND TIMESTAMPDIFF(MINUTE , ‘$curDate’, a.date_expiry ) >’0′”);

$doCount = $count_auction + $count_sub_auction;

// To display the products according to the display order
$main_cat_id = $wpdb->get_row(“SELECT * FROM $MAM_AUCTION_CATEGORIES_TABLE WHERE category_name = ‘”.$scat->category_name.”‘”);
$display_status = $main_cat_id->display_status;

if( $display_status == 1){ ?>