In the statistics for sites with multiple domains (mainly) referrers from that site are also shown. That's because ISPConfig does not add a 'IgnoreReferrer' entry for these domain names, just for the primary domain of that site. Could someone point me in the right direction on where to fix it? I will then create a patch for this. Kind regards, René
The statistics were created by the file /root/ispconfig/scripts/shell/webalizer.php To get all co-domains of a given website, use the following SQL statement: Code: SELECT isp_isp_domain.domain_host, isp_isp_domain.domain_domain FROM isp_isp_web, isp_dep, isp_isp_domain WHERE isp_isp_web.web_domain = '<domain>' AND isp_isp_web.web_host = '<hostname>' AND isp_isp_web.doc_id = isp_dep.parent_doc_id AND isp_isp_web.doctype_id = isp_dep.parent_doctype_id AND isp_isp_domain.doc_id = isp_dep.child_doc_id AND isp_isp_domain.doctype_id = isp_dep.child_doctype_id Replace <domain> with the domain name of the website and <hostname> with the hostname of the website. example for the website www.mydomain.tld Code: SELECT isp_isp_domain.domain_host, isp_isp_domain.domain_domain FROM isp_isp_web, isp_dep, isp_isp_domain WHERE isp_isp_web.web_domain = 'mydomain.tld' AND isp_isp_web.web_host = 'www' AND isp_isp_web.doc_id = isp_dep.parent_doc_id AND isp_isp_web.doctype_id = isp_dep.parent_doctype_id AND isp_isp_domain.doc_id = isp_dep.child_doc_id AND isp_isp_domain.doctype_id = isp_dep.child_doctype_id
