link, $query) or die("Could not complete database query");
$num = mysqli_num_rows($result);
$builddate = date("D, j M Y H:i:s O");
$sql_main = 'SELECT COUNT(*) AS num_result FROM maw_menu where published="Yes" AND parent="0" ORDER BY position';
$result_main = mysqli_query($DB->link, $sql_main);
$row_main = mysqli_fetch_array($result_main);
$num_result_main = $row_main['num_result'];
$num_rows_main = mysqli_num_rows( $result_main );
$sql_main = 'SELECT * FROM maw_menu where published="Yes" AND parent="0" ORDER BY position';
$result_main = mysqli_query($DB->link, $sql_main);
$aResults_main = array();
while ( $row_main = mysqli_fetch_array($result_main) ) {
$aResults_main[] = $row_main;
}
if(sizeOf($aResults_main) == 0) {
$comments_error_main = 'No items are available.
';
}
echo "\r\n";
echo "\r\n";
foreach ($aResults_main as $main_menu){
echo "";
if( $main_menu["edittype"] == "Menu Item"){echo "\t".$site_url."" . $main_menu["sef_name"] . "/\r\n";}
else{echo "\t". $main_menu["link"] . "\r\n";}
//echo "\t" . $newdate4 . "T".$newdate5."\r\n";
echo "\tmonthly\r\n";
echo "\t1.0\r\n";
echo "\t\r\n";
$sql_sub = 'SELECT COUNT(*) AS num_result FROM maw_menu where published="Yes" AND parent="'.$main_menu["id"].'" ORDER BY position';
$result_sub = mysqli_query($DB->link, $sql_sub);
$row_sub = mysqli_fetch_array($result_sub);
$num_result_sub = $row_sub['num_result'];
$num_rows_sub = mysqli_num_rows( $result_sub );
$sql_sub = 'SELECT * FROM maw_menu where published="Yes" AND parent="'.$main_menu["id"].'" ORDER BY position';
$result_sub = mysqli_query($DB->link, $sql_sub);
$aResults_sub = array();
while ( $row_sub = mysqli_fetch_array($result_sub) ) {
$aResults_sub[] = $row_sub;
}
if(sizeOf($aResults_sub) == 0) {
$comments_error_sub = 'No items are available.
';
}
foreach ($aResults_sub as $sub_menu){
if($sub_menu['name']== $main_menu["name"]){}else{
echo "";
if( $sub_menu["edittype"] == "Menu Item"){echo "\t".$site_url."" . $sub_menu["sef_name"] . "/\r\n";}
else{echo "\t". $sub_menu["link"] . "\r\n";}
//echo "\t" . $newdate4 . "T".$newdate5."\r\n";
echo "\tmonthly\r\n";
echo "\t0.8\r\n";
echo "\t\r\n";
}
$query_rsGetShopMenu = "SELECT * FROM maw_shop_product_cat Where category_name='".$sub_menu["name"]."' AND published='Yes' Limit 1";
$rsGetShopMenu = mysqli_query($DB->link, $query_rsGetShopMenu) or die(mysqli_error());
$row_rsGetShopMenu = mysqli_fetch_assoc($rsGetShopMenu);
$totalRows_rsGetShopMenu = mysqli_num_rows($rsGetShopMenu);
$sql_prods = 'SELECT COUNT(*) AS num_result FROM maw_shop_products where published="1" AND category="'.$row_rsGetShopMenu["id"].'" ORDER BY order_by';
$result_prods = mysqli_query($DB->link, $sql_prods);
$row_prods = mysqli_fetch_array($result_prods);
$num_result_prods = $row_prods['num_result'];
$num_rows_prods = mysqli_num_rows( $result_prods );
$sql_prods = 'SELECT * FROM maw_shop_products where published="1" AND category="'.$row_rsGetShopMenu["id"].'" ORDER BY order_by';
$result_prods = mysqli_query($DB->link, $sql_prods);
$aResults_prods = array();
while ( $row_prods = mysqli_fetch_array($result_prods) ) {
$aResults_prods[] = $row_prods;
}
if(sizeOf($aResults_prods) == 0) {
$comments_error_prods = 'No items are available.
';
}
foreach ($aResults_prods as $product){
$make_url = make_slug($product['product_url']);
$prod_url = $site_url.'ranges/'.$row_rsGetShopMenu['cat_url'].'/'.$make_url.'/';
echo "";
echo "\t". $prod_url . "\r\n";
//echo "\t" . $newdate4 . "T".$newdate5."\r\n";
echo "\tmonthly\r\n";
echo "\t0.5\r\n";
echo "\t\r\n";
}
}
}
echo "";
?>