if ($products_all_split->number_of_rows > 0) {
    $products_all = $db->Execute($products_all_split->sql_query);
    while (!$products_all->EOF) {
        $products_name = $products_all->fields['products_name'];
        //$products_name = ltrim(substr($products_name, 0, 25) . '');
        $products_description_full = zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($products_all->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION);
        //To Display Product Desc
        $products_description_list = ltrim(substr($products_description_full, 0, 250) . '');
        //Trims and Limits the desc
        $moreinfo = '<a class="more_info_text" href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
        if (PRODUCT_ALL_LIST_IMAGE != '0') {
            if ($products_all->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
                $display_products_image = str_repeat('', substr(PRODUCT_ALL_LIST_IMAGE, 3, 1));
            } else {
                $product_img_src = mb_getbaseimg_effects($products_all->fields['products_image']);
                $second_img_src = mb_gethoverimg_effects($products_all->fields['products_image']);
                $display_products_image = zen_image(DIR_WS_IMAGES . $products_all->fields['products_image'], $products_name, IMAGE_PRODUCT_ALL_LISTING_WIDTH, IMAGE_PRODUCT_ALL_LISTING_HEIGHT) . str_repeat('', substr(PRODUCT_ALL_LIST_IMAGE, 3, 1));
            }
        } else {
            $display_products_image = '';
            $product_img_src = '';
            $second_img_src = '';
        }
        if (PRODUCT_ALL_LIST_NAME != '0') {
            $display_products_name = '<a href="' . zen_href_link(zen_get_info_page($products_all->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($products_all->fields['master_categories_id']) . '&products_id=' . $products_all->fields['products_id']) . '">' . $products_name . '</a>' . str_repeat('', substr(PRODUCT_ALL_LIST_NAME, 3, 1));
        } else {
            $display_products_name = '';
        }
        if (PRODUCT_ALL_LIST_WEIGHT != '0' and zen_get_show_product_switch($products_all->fields['products_id'], 'weight')) {
            $display_products_weight = TEXT_PRODUCTS_WEIGHT . $products_all->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('', substr(PRODUCT_ALL_LIST_WEIGHT, 3, 1));
        } else {
if ($specials_split->number_of_rows > 0) {
    $specials = $db->Execute($specials_split->sql_query);
    while (!$specials->EOF) {
        $products_name = $specials->fields['products_name'];
        //$products_name = ltrim(substr($products_name, 0, 25) . '');
        $products_description_full = zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($specials->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION);
        //To Display Product Desc
        $products_description_list = ltrim(substr($products_description_full, 0, 250) . '');
        //Trims and Limits the desc
        $moreinfo = '<a class="more_info_text" href="' . zen_href_link(zen_get_info_page($specials->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($specials->fields['master_categories_id']) . '&products_id=' . $specials->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
        if (PRODUCT_SPECIALS_IMAGE != '0') {
            if ($specials->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
                $display_products_image = str_repeat('', substr(PRODUCT_SPECIALS_IMAGE, 3, 1));
            } else {
                $product_img_src = mb_getbaseimg_effects($specials->fields['products_image']);
                $second_img_src = mb_gethoverimg_effects($specials->fields['products_image']);
                $display_products_image = zen_image(DIR_WS_IMAGES . $specials->fields['products_image'], $products_name, IMAGE_PRODUCT_SPECIALS_WIDTH, IMAGE_PRODUCT_SPECIALS_HEIGHT) . str_repeat('', substr(PRODUCT_SPECIALS_IMAGE, 3, 1));
            }
        } else {
            $display_products_image = '';
            $product_img_src = '';
            $second_img_src = '';
        }
        if (PRODUCT_SPECIALS_IMAGE != '0') {
            $display_products_name = '<a href="' . zen_href_link(zen_get_info_page($specials->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($specials->fields['master_categories_id']) . '&products_id=' . $specials->fields['products_id']) . '">' . $products_name . '</a>' . str_repeat('', substr(PRODUCT_SPECIALS_NAME, 3, 1));
        } else {
            $display_products_name = '';
        }
        if (PRODUCT_SPECIALS_WEIGHT != '0' and zen_get_show_product_switch($specials->fields['products_id'], 'weight')) {
            $display_products_weight = TEXT_PRODUCTS_WEIGHT . $specials->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('', substr(PRODUCT_SPECIALS_WEIGHT, 3, 1));
        } else {
if ($featured_products_split->number_of_rows > 0) {
    $featured_products = $db->Execute($featured_products_split->sql_query);
    while (!$featured_products->EOF) {
        $products_name = $featured_products->fields['products_name'];
        //$products_name = ltrim(substr($products_name, 0, 25) . '');
        $products_description_full = zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($featured_products->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION);
        //To Display Product Desc
        $products_description_list = ltrim(substr($products_description_full, 0, 250) . '');
        //Trims and Limits the desc
        $moreinfo = '<a class="more_info_text" href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($featured_products->fields['master_categories_id']) . '&products_id=' . $featured_products->fields['products_id']) . '">' . MORE_INFO_TEXT . '</a>';
        if (PRODUCT_FEATURED_LIST_IMAGE != '0') {
            if ($featured_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
                $display_products_image = str_repeat('', substr(PRODUCT_FEATURED_LIST_IMAGE, 3, 1));
            } else {
                $product_img_src = mb_getbaseimg_effects($featured_products->fields['products_image']);
                $second_img_src = mb_gethoverimg_effects($featured_products->fields['products_image']);
                $display_products_image = '<a class="product-image" href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($featured_products->fields['master_categories_id']) . '&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $products_name, IMAGE_FEATURED_PRODUCTS_LISTINGS_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTINGS_HEIGHT) . '</a>' . str_repeat('', substr(PRODUCT_FEATURED_LIST_IMAGE, 3, 1));
            }
        } else {
            $display_products_image = '';
            $product_img_src = '';
            $second_img_src = '';
        }
        if (PRODUCT_FEATURED_LIST_IMAGE != '0') {
            $display_products_name = '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . zen_get_generated_category_path_rev($featured_products->fields['master_categories_id']) . '&products_id=' . $featured_products->fields['products_id']) . '">' . $products_name . '</a>' . str_repeat('', substr(PRODUCT_FEATURED_LIST_NAME, 3, 1));
        } else {
            $display_products_name = '';
        }
        if (PRODUCT_FEATURED_LIST_WEIGHT != '0' and zen_get_show_product_switch($featured_products->fields['products_id'], 'weight')) {
            $display_products_weight = TEXT_PRODUCTS_WEIGHT . $featured_products->fields['products_weight'] . TEXT_SHIPPING_WEIGHT . str_repeat('', substr(PRODUCT_FEATURED_LIST_WEIGHT, 3, 1));
        } else {
             //$lst_lc_text = '<div class="product-weight">'.$listing->fields['products_weight'].'</div>';
             break;
         case 'PRODUCT_LIST_IMAGE':
             $lc_align = 'center';
             if ($listing->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) {
                 $lc_text = '';
                 $lst_lc_text = '';
             } else {
                 if (isset($_GET['manufacturers_id'])) {
                     $product_img_link = zen_href_link(zen_get_info_page($listing->fields['products_id']), 'cPath=' . (($_GET['manufacturers_id'] > 0 and $_GET['filter_id']) > 0 ? zen_get_generated_category_path_rev($_GET['filter_id']) : ($_GET['cPath'] > 0 ? zen_get_generated_category_path_rev($_GET['cPath']) : zen_get_generated_category_path_rev($listing->fields['master_categories_id']))) . '&products_id=' . $listing->fields['products_id']);
                     $product_img_src = mb_getbaseimg_effects($listing->fields['products_image']);
                     $second_img_src = mb_gethoverimg_effects($listing->fields['products_image']);
                     $product_img = zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $products_name, IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT);
                 } else {
                     $product_img_src = mb_getbaseimg_effects($listing->fields['products_image']);
                     $second_img_src = mb_gethoverimg_effects($listing->fields['products_image']);
                     $product_img = zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $products_name, IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT);
                 }
             }
             break;
     }
     $product_contents[] = $lc_text;
     // Used For Column Layout (Grid Layout) Option
     $listview_product_contents[] = $lst_lc_text;
 }
 $get_discount_prod = mb_discount_product($listing->fields['products_id']);
 if (mb_featured_product($listing->fields['products_id']) == 1) {
     $ribbon = "<div class='tag tag-orange' title=''><div class='text'>HOT</div></div>";
 } else {
     if (mb_special_product($listing->fields['products_id']) == 1) {
         $ribbon = "<div class='tag tag-orange' title=''><div class='text'>SALE</div></div>";