git-svn-id: http://dev.piwik.org/svn/trunk@7259 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7258 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7257 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7256 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7255 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7254 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7253 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7252 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7251 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7250 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7249 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7248 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7247 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7246 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7245 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7244 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7242 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7241 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7239 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7235 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7233 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7202 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Fixing the No result keyword bug

git-svn-id: http://dev.piwik.org/svn/trunk@7197 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7195 59fd770c-687e-43c8-a1e3-f5a4ff64c105

 * Adding integration test
 * Note: it appears the "No result keyword" does not work, i'm on it

git-svn-id: http://dev.piwik.org/svn/trunk@7194 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Implementing Site Search tracking & reporting in Piwik core!

 * New Admin UI to customize, for each site, wheter site search is enabled. Also options to set default values to use.
 * New Reports: Searches, Searches with no result, Search categories, Top Pages Following a Search
 * to track "No result keyword" users will have to tag their site with a JS call, or add a new parameter to the search result page &search_count=X (X being zero for no result searches)
 * Reports works with Row evolution, PDF/HTML reports, Piwik Mobile
 * idaction_url is now NULLable because, Site Search records a page with idaction_name == Keyword, and idaction_url == NULL. This ensures that the Site Searches don't create "Page URL Not defined" records. 
 * updates to Tracker JS API, new function trackSiteSearch, also added in PHP tracker
 * New fields in log_visit to track searches
 * new segment, "searches" which can be used to select visitors who did a search ie. searches>0 or those who searched a lot, ie searches>10
 
 TODO: 
  * commmit integration test, TESTING, DOCS, FAQ, release, and a nice Prayer to the universe and the stars, hoping that I can code a major new feature without any bug...
  * It would be awesome to have compatiblity with Transitions so we can see, for a given site search, what are the starting pages and Destination pages
  
 Thank you for your patience Timo, 
 and thank in advance everyone for your help Testing this new feature!
 


git-svn-id: http://dev.piwik.org/svn/trunk@7190 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #1823, display informative note when Region + City reports have no location data, merge unknown rows in region & city reports and make sure latitude/longitude is rounded in API output.


git-svn-id: http://dev.piwik.org/svn/trunk@7187 59fd770c-687e-43c8-a1e3-f5a4ff64c105

  * Add warning if old GeoIP plugin is used.
  * Display links to installation instructions for different providers if they are not installed.
  * Add report documentation for country, region, continent and city reports, round latitude/longitude.
  * Increase 'Done' timeout when switching providers
  * Display quick start instructions for GeoIP if no GeoIP provider is currently working.
  * Add script to geolocate old data.



git-svn-id: http://dev.piwik.org/svn/trunk@7186 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #1823, test GeoIP w/ normal tracking, bulk tracking & log importing. Test if Apache module is working using GEOIP_ADDR server variable instead of GEOIP_COUNTRY_CODE since the latter may not always be set.


git-svn-id: http://dev.piwik.org/svn/trunk@7180 59fd770c-687e-43c8-a1e3-f5a4ff64c105

filter_pattern= will now work on metadata columns. This will be  useful for example, if we wanted to select only a number of "countries", from the UserCountry.getCity API, we could do the following: &filter_column=country&filter_pattern=de|fr|es|it|nl
It will filter and only return only the Cities, which belong to the country specified. This will work ,because rows have a metadata <country> 
Refs #1652

git-svn-id: http://dev.piwik.org/svn/trunk@7173 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7162 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #3332 Hopefully, fixing all problems with URL being incorrectly aggregated! Thanks Timo for the hint and bug in previous algorithm

git-svn-id: http://dev.piwik.org/svn/trunk@7160 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #1823, fixed conversion tracking omission in initial GeoIP commit & added tests for conversion locations & unknown location. Removed 'Unknown' regions & cities from visitor log tooltips, added more detailed error messages for issues w/ the PECL module, add test w/ test IP and known result to isWorking methods and some more admin UI tweaks.



git-svn-id: http://dev.piwik.org/svn/trunk@7159 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7157 59fd770c-687e-43c8-a1e3-f5a4ff64c105

git-svn-id: http://dev.piwik.org/svn/trunk@7145 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #1823, added latitude/longitude + other metadata to getCity reports, added country name metadata to getRegion & tweaked admin UI a bit.


git-svn-id: http://dev.piwik.org/svn/trunk@7144 59fd770c-687e-43c8-a1e3-f5a4ff64c105

  * Renamed getVisitsByCity & getVisitsByRegion to getCity & getRegion.
  * Extra testing for anonymized IPs.
  * Show visitor city & region in visitor log & last visits widget.
  * Do specific check for apache module in checking for server based geoip implementation.
  * Fix for continent segment error.
  * Redesigned admin UI to be more compact & to show reason for broken implementations.
  * Don't show duplicate Unknowns in pretty location strings.
  * Don't use REMOTE_ADDR, instead get IP from Piwik_IP.


git-svn-id: http://dev.piwik.org/svn/trunk@7140 59fd770c-687e-43c8-a1e3-f5a4ff64c105

I had to edit the tests to clean up the files with the new system
: 
 * remove english translations of non translated strings, which were automatically put in the translated files
 * Keep ordering of language strings similar to the english file

git-svn-id: http://dev.piwik.org/svn/trunk@7138 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #1823, modified UserCountry plugin to allow use of GeoIP databases if desired. Added two reports, getVisitsByRegion + getVisitsByCity.

Notes:

  * Supports country, region, city, org & isp GeoIP databases.
  * Supports GeoIP PHP API, PECL module & server modules.
  * Added ability to regenerate 'general' tracker cache.
  * Removed location_continent column from log_visit & log_conversion tables, and removed visits by continent blob record. Report is now a view over country report.



git-svn-id: http://dev.piwik.org/svn/trunk@7122 59fd770c-687e-43c8-a1e3-f5a4ff64c105

Refs #3332 Summing rows now keep the latest metadata to ensure the latest format of URLs is used when summing over large date range

git-svn-id: http://dev.piwik.org/svn/trunk@7103 59fd770c-687e-43c8-a1e3-f5a4ff64c105