LIVECOUNTER :: AFFICHE LE NOMBRE DE CONNECTÉS À VOTRE SITE

<!-- 
***********************************
*  LiveCounter By Olivier Cozette *
*  mame32@ifrance.com             *
***********************************
-->

<!--- Name of the DataSource --->
<cfparam name="dataSource" default="counter">
<!--- Time max of the connection (seconds, here 5mn) --->
<cfset timeMax = 300>


<!--- Get the IP --->
<cfparam name="IP" default="#CGI.REMOTE_ADDR#">
<!--- Get the Hour --->
<cfset heureConnecte = #Now()#>
<!--- Find the IP --->
<cfquery name="IPExist" datasource="#dataSource#">
	SELECT IPConnecte
	FROM liveCounter
	WHERE IPConnecte = '#IP#'
</cfquery>
<!--- Update the Hour --->
<cfif IPExist.IPConnecte NEQ "">
	<cfquery datasource="#dataSource#">
		UPDATE liveCounter
		SET timeConnecte = #heureConnecte#
		WHERE IPConnecte = '#IP#'
	</cfquery>
<!--- Insert the IP and the Hour --->
<cfelse>
	<cfquery datasource="#dataSource#">
		INSERT INTO liveCounter(IPConnecte, timeConnecte)
		VALUES ('#IP#', #heureConnecte#)
	</cfquery>	
</cfif>
<!--- Calculate the time max of connection --->
<cfscript>
	connexionMax = heureConnecte - (timeMax/86400);
</cfscript>
<!--- Erase the past connections --->
<cfquery datasource="#dataSource#">
	DELETE FROM livecounter
	WHERE timeConnecte < #connexionMax#
</cfquery>
<!--- Get the number of connected --->
<cfquery name="total" datasource="#dataSource#">
	SELECT COUNT(*)
	AS nbConnectes
	FROM livecounter
</cfquery>


<!--- Write the number of connected in the page --->
Number of connected:<br>
<cfoutput>#total.nbConnectes#</cfoutput>