Hi,
I just went through the stats collecting / display files to fix the SQL that
doesn't work where table names are case-sensitive (e.g. MySQL on Linux)
Here's a list of the changes. I figure it saves one of you Daemon guys going
through and looking for them:
farcry_core\packages\farcry\_stats\deploy.cfm
- This needs a lot of changes to make the table names consistent
farcry_core\packages\farcry\_stats\getBranchStatsByDay.cfm
- Line 40: changed Stats to stats
farcry_core\packages\farcry\_stats\getBranchStatsByWeek.cfm
- Line 36: changed Stats to stats
farcry_core\packages\farcry\_stats\getDownloadStats.cfm
- Line 28: changed Stats to stats
farcry_core\packages\farcry\_stats\getLocales.cfm
- Line 29: changed Stats to stats
- Line 37: changed Stats to stats, StatsCountries to statsCountries
farcry_core\packages\farcry\_stats\getMostViewed.cfm
- Line 30: changed Stats to stats
farcry_core\packages\farcry\_stats\getOS.cfm
- Line 29: changed Stats to stats
- Line 37: changed Stats to stats
farcry_core\packages\farcry\_stats\getPageStatsByDay.cfm
- Line 34: changed Stats to stats
farcry_core\packages\farcry\_stats\getPageStatsByWeek.cfm
- Line 36: changed Stats to stats
C:\Inetpub\Applications\farcry_core\packages\farcry\_stats\getReferers.cfm
- Line 31: changed Stats to stats
C:\Inetpub\Applications\farcry_core\packages\farcry\_stats\getVisitorStatsBy
Day.cfm
- Line 35: changed Stats to stats
C:\Inetpub\Applications\farcry_core\packages\farcry\_stats\getVisitorStatsBy
Week.cfm
- Line 34: changed Stats to stats
ps. FarCry doesn't handle the situation very well (read: at all) when there
is no user-agent header supplied in the http request. Somewhere in the stats
code it should check that it exists rather than assuming it does. Obviously
99.9% of normal requests will include this header, but in the odd case it
doesn't, it should still be handled somewhat normally.
Cheers
--
Quentin Zervaas
Web Developer
MITOUSA.
Web + Interface Architects
E:// [EMAIL PROTECTED]
W:// www.mitousa.com
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
