hooduku / open-web-analytics Goto Github PK

Hello Hooduku,

I have OWA 1.5.0 running on SQL Server 2008 and am trying to it port over 1.5.7 using your owa_db_SQLServer.php class.

It appears SQL Server cannot understand the ‘INDEX(site_id) ‘ part of the initial Create Table SQL Statement. It makes some of the tables in SQL Server but complains of this deprecated use of Index(site_id).

Researching this I believe I need to create the index on a variable after the call to Create Table but getting hung up a bit as a newbie of PHP.

It appears this is all happening in owa_db.php, but I am not seeing how the Index(site_id) even gets added to the SQL Query (or built).

Any thoughts?

Thanks in advance

I want to use Open Web Analytics and now I would like to protect the open web analytics folder with a htaccess. It works with Piwik and don't work with Open Web Analytics

the code from the htaccess is the following:

# Sample .htaccess file for your web document root

# Restrict outside access
AuthUserFile /../www/analytics.domain.com/httpdocs/.htpasswd
AuthGroupFile /dev/null
AuthName "Piwik"
AuthType Basic

< Files "*">
Require valid-user
</Files>

<Files ~ "^piwik\.(js|php)|robots\.txt$">
Allow from all
Satisfy any
</Files>

<Files ~ "^owa\.(js|php)|robots\.txt$">
Allow from all
Satisfy any
</Files>

If I want to get access to the piwik folder I have to enter the htaccess username and password but if I open the Website that I am tracking I dont# need to enter the password thats how it shoudl also work for OWA. If I open the OWA folder it also aks for name and password but after adding the tracking code to the website it ask for the name and password everytime I open the Website. So why it works with piwik and not for OWA

Thanks