I need a code that will:
1) Have a mysql query that will get all magento store products in stock
2) Create a php code that will transfer said query result to a pre defined XML format
3) The code must work with a cron job in the server (we will set the cron job, but the user must help make the code work if it doesnt naturally with a cron job call for some misterious reason)
It's something fairly simple but we just can't seem to make a query get all products in stock. 2hrs works TOPs for someone who knows magento database inner works.