If you want to use the new feature to change CSS for modules
(with the module manager) you will need to add following code at the top
in your main.inc.php of your template and just after the inclusion of your normal CSS stylesheet file:
<?php
//see if there is module loaded and get its CSS definition from modules table.
include($cmsdir."/core/css.php");
?>