'; echo ''; // Joomla Sections and Categories $result = @mysql_query("SELECT id FROM ".$mosConfig_dbprefix."sections WHERE PUBLISHED='1'"); while($row = mysql_fetch_assoc($result)) { // Creating section links echo ''; echo ''; if ($mosConfig_sef == '1' ) { echo $mosConfig_live_site.'/content/section/'.$row['id']; } else{ echo $mosConfig_live_site.'/index.php?option=com_content&task=section&id='.$row['id']; } echo ''; echo '0.5'; echo ''; $result2 = @mysql_query("SELECT id FROM ".$mosConfig_dbprefix."categories WHERE section='".$row['id']."' AND PUBLISHED='1'"); while($row2 = mysql_fetch_assoc($result2)) { // Creating category links echo ''; echo ''; if ($mosConfig_sef == '1' ) { echo $mosConfig_live_site.'/content/category/'.$row2['id']; } else { echo $mosConfig_live_site.'/index.php?option=com_content&task=category&id='.$row2['id']; } echo ''; echo '0.5'; echo ''; $result3=@mysql_query("SELECT id, modified FROM ".$mosConfig_dbprefix."content WHERE sectionid='".$row['id']."' AND catid='".$row2['id']."' and state='1' ORDER BY modified DESC"); while($row3 = mysql_fetch_assoc($result3)) { // Creating section links if ($mosConfig_sef == '1' ) { echo ''; echo ''; echo $mosConfig_live_site.'/content/view/'.$row3['id']; echo ''; echo ''.substr($row3['modified'],0,10).''; echo '0.6'; echo ''; } else { echo ''; echo ''; echo $mosConfig_live_site.'/index.php?option=com_content&task=view&id='.$row3['id']; echo ''; echo ''.substr($row3['modified'],0,10).''; echo '0.6'; echo ''; } } } } // Main menu options $result = @mysql_query("SELECT id,name,link FROM ".$mosConfig_dbprefix."menu WHERE menutype='mainmenu' AND type = 'components' AND PUBLISHED='1'"); $vmid = 0; while($row = mysql_fetch_assoc($result)) { echo ''; echo ''; if ($row['link'] == 'index.php?option=com_virtuemart') $vmid = $row['id']; // Catch Virtuemert's ID if ($mosConfig_sef == '1' ) { echo $mosConfig_live_site.'/component/'.str_replace($seps,$reps,substr($row['link'],10)).'/Itemid,'.$row['id']; } else { echo $mosConfig_live_site.'/'.$row['link']; } echo ''; echo '0.5'; echo ''; } // Virtuemart //Categories $result = @mysql_query("SELECT category_id,category_name,mdate FROM jos_vm_category WHERE category_publish = 'Y' "); while($row = mysql_fetch_assoc($result)) { echo ''; echo ''; if ($mosConfig_sef == '1' ) { echo $mosConfig_live_site.'/component/option,com_virtuemart/page,shop.browse/category_id,'.$row['category_id'].'/Itemid,'.$vmid; } else { echo $mosConfig_live_site.'/index.php?option=com_virtuemart&page=shop.browse&category_id='.$row['category_id'].'&Itemid='.$vmid; } echo ''; echo '0.6'; echo 'daily'; echo ''; } //Products $result = @mysql_query("select a.product_id, c.category_id, c.category_flypage, d.manufacturer_id from jos_vm_product a, jos_vm_product_category_xref b, jos_vm_category c, jos_vm_product_mf_xref d where a.product_publish = 'Y' and b.product_id = a.product_id and c.category_id = b.category_id and c.category_publish = 'Y' and d.product_id = a.product_id "); while($row = mysql_fetch_assoc($result)) { echo ''; echo ''; if ($mosConfig_sef == '1' ) { $flypage = (empty($row['category_flypage'])) ? FLYPAGE : $row['category_flypage']; echo $mosConfig_live_site.'/component/page,shop.product_details/flypage,'.$flypage.'/product_id,'.$row['product_id'].'/category_id,'.$row['category_id'].'/manufacturer_id,0/option,com_virtuemart/Itemid,'.$vmid; } else { echo $mosConfig_live_site.'/index.php?page=shop.product_details&flypage='.$flypage.'&product_id='.$row['product_id'].'&category_id='.$row['category_id'].'&manufacturer_id=0&option=com_virtuemart&Itemid='.$vmid; } echo ''; echo '0.9'; echo 'daily'; echo ''; } echo ''; ?>