Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Feature Requests

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th October 2007, 12:17
Peerke Peerke is offline
Junior Member
 
Join Date: Apr 2007
Posts: 8
Thanks: 3
Thanked 0 Times in 0 Posts
Default Webalizer stats for ServerAlias entries

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é
Reply With Quote
Sponsored Links
  #2  
Old 19th October 2007, 10:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,457
Thanks: 813
Thanked 5,230 Times in 4,099 Posts
 
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Force the creation of Webalizer stats? Anim Installation/Configuration 8 23rd July 2013 08:55
Help Stats Webalizer jfruano Installation/Configuration 2 27th February 2007 13:03
again on webalizer stats gilas Installation/Configuration 6 6th October 2006 16:16
webalizer stats not accessible only for one user gilas Installation/Configuration 4 21st July 2006 13:08
view webalizer stats kuyaedz General 22 12th March 2006 14:45


All times are GMT +2. The time now is 21:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.