I just need to reanimate this thread, as it matches my desires:
Currently i modified the dns-template-file to create a *.domain.tld. for every domain I've created. Also i modified the apache vhosts template file.
This works fine for most cases and i don't need to create that much subdomains (with and without www).
For some domains i can't live with that *.domain.tld entry and i need to remove it. Thats also fine, as long nobody touches the ispconfig dns-manager to manipulate the zone as it is re-written by any custom action.
What I'm looking for is either a SQL-Query to add a www-record for all domains wich do not own one and in case ... if they own one, keep mind of the currently entered data in the exisiting www-record for creating one for the co-domains.
An other option would be, to have a default template for all new domains which creates the needed records automatically. It isn't easy to keep all domains contigous with the same scheme. Thats why i desire a template.
I hope someone can help, either with a sql-query or an other idea.