Webalizer stats for ServerAlias entries

[Peerke]

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é

[till]

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:

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

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