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>

  <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
-~----------~----~----~----~------~----~------~--~---

Reply via email to