Webalizer stats for ServerAlias entries

Discussion in 'Feature Requests' started by Peerke, Oct 18, 2007.

  1. Peerke

    Peerke New Member

    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é
     
  2. till

    till Super Moderator

    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
     

Share This Page