Hi
I have a custom login that I have set up that can be managed from within farcry, I am trying to add this custom user to the in-built stats. When the user logs into the front end I have a number of sessions st up on the farcry\farcry_core\packages\farcry\_stats\log.cfm have set up a if statement to check if the
session.patersonClient.loggedOn = true but cannot seem to add the entry to the database, any assistance would be greatly appreciated.
<cfif SESSION.patersonClient.loggedOn>
<cfquery name="qInsertLog" datasource="#arguments.dsn#">
insert into clientstats
(logID,logdatetime,pageID,navid,remoteip,userid,sessionId,browser,referer,locale,os)
values
(<cfoutput>'#CreateUUID()#',#createodbcdatetime(now())#,'#arguments.pageID#','#arguments.navid#','#arguments.remoteip#','#SESSION.patersonClient.username#','#arguments.sessionId#','#arguments.browser#','#arguments.referer#','#arguments.locale#','#arguments.os#'</cfoutput>)
</cfquery>
<cfquery name="qInsertLog" datasource="#arguments.dsn#">
insert into clientstats
(logID,logdatetime,pageID,navid,remoteip,userid,sessionId,browser,referer,locale,os)
values
(<cfoutput>'#CreateUUID()#',#createodbcdatetime(now())#,'#arguments.pageID#','#arguments.navid#','#arguments.remoteip#','#SESSION.patersonClient.username#','#arguments.sessionId#','#arguments.browser#','#arguments.referer#','#arguments.locale#','#arguments.os#'</cfoutput>)
</cfquery>
<cfelse>
<cfquery name="qInsertLog" datasource="#arguments.dsn#">
insert into #application.dbowner#stats
(logID,logdatetime,pageID,navid,remoteip,userid,sessionId,browser,referer,locale,os)
values
(<cfoutput>'#CreateUUID()#',#createodbcdatetime(now())#,'#arguments.pageID#','#arguments.navid#','#arguments.remoteip#','#arguments.userid#','#arguments.sessionId#','#arguments.browser#','#arguments.referer#','#arguments.locale#','#arguments.os#'</cfoutput>)
</cfquery>
</cfif>
Thanks
Mark
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
