Hello, i am working on a custom sitemap module (exports urls, product image, product name, short descr etc...) Everything is working fine except the url. Right now i use the default joomla url, so in my module looks like:
$product_url= "<![CDATA[" .URL."index.php?option=com_virtuemart&category_id=".$category_id."&flypage=vmj_genx.tpl&lang=el&manufacturer_id=".$manufacturer_id."&page=shop.product_details&product_id=".$product_id."&Itemid=53"."]]>";
what i want is to export the Joomsef urls instead of the default joomla ones. Whats the query i should replace it with? i was looking in the db and jos_sefurls seems to have translated the originalurls to something like 696e6465782e7068703f6f7074696f6e3d636f6d5f63636e6577736c6574746572266c616e673d656e26766965773d63636e2e2e2e that makes hard for me to create a query and search for it.