hi to all...
i want to be able to see which pages where visited and from how many users...
(Un)fortunately i use rewrite rulez... so the actual url is not the real cfm file
ex domain.com/toys/4857-toy-name/
is product_view.cfm?param=4857-toy-name
So in a onrequestend.cfm i used the following code in order to retrive the 'fake' url as it is
<cfif #find('bot',cgi.HTTP_USER_AGENT)# eq 0>
<cfif #find('admin',cgi.SCRIPT_NAME)# eq 0>
<cfajaxproxy cfc="pagesession" jsclassname="pageproxy">
<script language="JavaScript">
var ecfc = new pageproxy();
ecfc.pagesetter(document.URL);
</script>
<cfquery name="find_visits_per_day" datasource="#application.namedb#" username="#application.undb#"
password="#application.passdb#">
insert into site_pages_visited(page_url,session_id,date_visit,hour_visit,cookie_id)
value
(
<cfqueryparam value="#session.pager#" cfsqltype="cf_sql_varchar">,
<cfqueryparam value="#session.sid#" cfsqltype="cf_sql_varchar">,
<cfqueryparam cfsqltype="cf_sql_date" value="#dateformat(now(),'yyyy-mm-dd')#">,
<cfqueryparam cfsqltype="cf_sql_hour" value="#dateformat(now(),'HH:mm:ss')#">,
<cfqueryparam value="#cookie.unique_id#" cfsqltype="cf_sql_varchar">
)
</cfquery>
</cfif>
</cfif>
cfc file
<cfcomponent>
<cffunction name="pagesetter" access="remote" returntype="string">
<cfargument name="page_now" type="string" required="yes">
<cfset session.pager=#arguments.page_now#>
<cfreturn myResult>
</cffunction>
</cfcomponent>
do you believe that using ajaxproxy in every page will cause memory or other kind issue that i should know about?
Thank you..