Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/sites/store20.prestostore.com/html/home/sitemap.php on line 13

Notice: Undefined index: category in /var/www/sites/store20.prestostore.com/html/home/sitemap.php on line 45
<? print $titlebar; ?>
END; } else { echo << END; } echo <<
$display_name
END; if (($category == '') && ($dept == '')) { echo <<
$display_name$text_links
END; $query = "SELECT rowid AS id, "; $query .= " REPLACE(category_name, '^', '''') AS category_name "; $query .= " FROM store_categories c "; $query .= " WHERE merchant_id = $merchant_id "; $query .= " and (hidden_flag is null or hidden_flag != 'Y')"; $query .= " order by display_order "; $query .= " LIMIT 100;"; $result=mysql_query($query); if ($result == FALSE) { $num_products = 0; } else { $num_products = mysql_num_rows($result); } $i=0; while ($i < $num_products) { $category_id = mysql_result($result,$i,"id"); $category_name = mysql_result($result,$i,"category_name"); $category_name = htmlentities(strip_tags($category_name)); // $category_name = iconv("UTF-8","UTF-8//IGNORE",$category_name); echo << END; $i++; } echo <<
Listings
$category_name
END; $query = "SELECT rowid AS id, "; $query .= " REPLACE(page_name, '^', '''') AS page_name "; $query .= " FROM store_frontend_pages "; $query .= " WHERE merchant_id = $merchant_id "; $query .= " and (hidden_flag is null or hidden_flag != 'Y')"; $query .= " order by display_order "; $query .= " LIMIT 100;"; $result=mysql_query($query); if ($result == FALSE) { $num_products = 0; } else { $num_products = mysql_num_rows($result); } $i=0; while ($i < $num_products) { $page_id = mysql_result($result,$i,"id"); $page_name = mysql_result($result,$i,"page_name"); $page_name = htmlentities(strip_tags($page_name)); // $page_name = iconv("UTF-8","UTF-8//IGNORE",$page_name); echo << END; $i++; } echo << END; if (($shipping_info_page_flag == 'Y') || ($refund_info_page_flag == 'Y') || ($more_info_page_flag == 'Y')) { echo <<
Pages
$page_name
 
END; if ($shipping_info_page_flag == 'Y') { $sql = "select policy_name, policy_text"; $sql .= " from store_policies"; $sql .= " where merchant_id = '$merchant_id' and policy_number = 1;"; $result=mysql_query($sql); if ($result == FALSE) { $rec_num = 0; } else { $rec_num = mysql_num_rows($result); } if ($rec_num == 1) { $policy_name = mysql_result($result,0,"policy_name"); $policy_text = mysql_result($result,0,"policy_text"); $policy_name = strtr($policy_name, "^", "'"); } echo << END; } if ($refund_info_page_flag == 'Y') { $sql = "select policy_name, policy_text"; $sql .= " from store_policies"; $sql .= " where merchant_id = '$merchant_id' and policy_number =2;"; $result=mysql_query($sql); if ($result == FALSE) { $rec_num = 0; } else { $rec_num = mysql_num_rows($result); } if ($rec_num == 1) { $policy_name = mysql_result($result,0,"policy_name"); $policy_text = mysql_result($result,0,"policy_text"); $policy_name = strtr($policy_name, "^", "'"); } echo << END; } if ($more_info_page_flag == 'Y') { $sql = "select policy_name, policy_text"; $sql .= " from store_policies"; $sql .= " where merchant_id = '$merchant_id' and policy_number = 3;"; $result=mysql_query($sql); if ($result == FALSE) { $rec_num = 0; } else { $rec_num = mysql_num_rows($result); } if ($rec_num == 1) { $policy_name = mysql_result($result,0,"policy_name"); $policy_text = mysql_result($result,0,"policy_text"); $policy_name = strtr($policy_name, "^", "'"); } echo << END; } echo << END; } echo <<
Policies
$policy_name
$policy_name
$policy_name

Build your own web store with PrestoStore

END; } // End Main if (($category != '') && ($dept == '')) { echo <<
$display_name$text_links
END; $query = "SELECT rowid AS id, "; $query .= " REPLACE(department_name, '^', '''') AS department_name "; $query .= " FROM store_departments "; $query .= " WHERE category_id = $category "; $query .= " and (hidden_flag is null or hidden_flag != 'Y')"; $query .= " order by display_order "; $query .= " LIMIT 100;"; $result=mysql_query($query); if ($result == FALSE) { $num_products = 0; } else { $num_products = mysql_num_rows($result); } $i=0; while ($i < $num_products) { $department_id = mysql_result($result,$i,"id"); $department_name = mysql_result($result,$i,"department_name"); $department_name = htmlentities(strip_tags($department_name)); // $department_name = iconv("UTF-8","UTF-8//IGNORE",$department_name); echo << END; $i++; } echo <<
$category_name
$department_name
Build your own web store with PrestoStore
END; } // End Category if ($dept != '') { echo <<
$display_name$text_links
END; $query = "SELECT rowid AS id, "; $query .= " REPLACE(product_name, '^', '''') AS product_name "; $query .= " FROM store_products "; $query .= " WHERE seller_category_id = $dept "; $query .= " and (prevent_ordering_flag is null or prevent_ordering_flag != 'Y')"; $query .= " order by product_name "; $query .= " LIMIT 100;"; $result=mysql_query($query); if ($result == FALSE) { $num_products = 0; } else { $num_products = mysql_num_rows($result); } $i=0; while ($i < $num_products) { $product_id = mysql_result($result,$i,"id"); $product_name = mysql_result($result,$i,"product_name"); $product_name = htmlentities(strip_tags($product_name)); // $product_name = iconv("UTF-8","UTF-8//IGNORE",$product_name); echo << END; $i++; } echo <<
$department_name
$product_name
Build your own web store with PrestoStore
END; } // End Products ?>