Re: can Apache do a sql query and Authenticate only some users?

"Giovanni Bianchini" <giovanni@xxxxxxx> · Mon, 21 Jul 2014 07:29:14 -0400

<html>
<head>
<title>User Login Page</title>
<link rel="stylesheet" href="css/default.css">
</head>

<body bgcolor="#FFFFFF">

<table width="700"><tr><td align="center">
<img src="images/mywarehouse.gif" alt="my warehouse" width="541" height="67">
</td></tr></table>

<table width="700" border="0" cellpadding="0" cellspacing="0">
	<tr>
	<td align="center" class="boldprint_black10" bgcolor="#F76300"><a href="#" 
onClick="history.go(-1)"><p class="boldprint_white10"> &bull; Go Back &bull;</p></a></td>
	<td align="right" class="boldprint_white10" bgcolor="#F76300"> &bull; Integrated 
Fulfillment Management Services Inc.&bull;</td>
	</tr>
</table>
<table width="700" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><hr color="black" size="3"></td>
</tr>
</table>
<!-- Start program below this line . Do not modify above -->

<CFFORM ACTION="ClientRecord_SECURE.cfm" METHOD=POST>

<CFSET V1=#HOUR(NOW())#>
<CFSET V2=#MINUTE(NOW())#>
<CFSET V3=#SECOND(NOW())#>
<CFSET EPOCH='#DATEFORMAT(NOW(),'MM.DD.YYYY')#.#V1#.#V2#.#V3#'>

<input type="hidden" name="remote_addr" value="<cfoutput>#remote_addr#</cfoutput>">
<input type="hidden" name="epoch" value="<cfoutput>#epoch#</cfoutput>">

	
<table width="700" border="0">
	<tr>
	<td align="center" valign="middle" class="boldprint_black10">
	This is a private site and requires a login and password.<br>
	All access to this site is recorded with your IP Address and Date<br>
	</td>
	</tr>
	<tr>
	<td align="center" valign="middle" class="boldprint_blue10">
	Your IP Address has been recorded as 
<cfoutput>#REMOTE_ADDR#</cfoutput><br>
	Your epoch is <cfoutput>#epoch#</cfoutput> 
	</td>
	</tr>
	<tr><td> &nbsp; </td></tr>
</table>

<table width="700" border="0">
	<tr>
		<td align="right" valign="middle" 
class="boldprint_black10">Username</td><td><INPUT TYPE="text" NAME="UserName"  
value=""></td>
	</tr>

	<tr>
		<td align="right" valign="middle" 
class="boldprint_black10">Password</td><td><INPUT TYPE="password" 
NAME="Password" value=""></td>
	</tr>

	<tr>
	<td></td><td valign="top"><INPUT TYPE="submit" VALUE="Login"></td>
	</tr>
</table>
</CFFORM>


Action from login page clientrecord_secure

<CFINCLUDE TEMPLATE="AuthenticateLogin.cfm">
<CFINCLUDE TEMPLATE="#getuser.page2load#">

Authenticatelogin
<cfquery name="getuser" datasource="shopcart">
	select username,password,page2load,cartname from clientusers
		where	username = '#form.username#' and
				password= '#form.password#'
</cfquery>

<cfif #getuser.recordcount# is 0>

	<dbinclude template="login.cfm">

	<table width="700" border="0">
		<tr>
  			<td align="center">
	 			<p class="boldprint_red12">x`
				Username and/or Password are incorrect...try again.
				</p>
			</td>
		</tr>
	</table>
	<cfabort>
<cfelse>

<cfset loginok = '1'>

</cfif>


On 20 Jul 2014 at 13:49, Mark jensen wrote:

> about the session/cookies solution you have said:
> 
> > You
> > can base your logic on the IP address of the sender and either send
> > them to a login screen or directly to the application.
> 
> How can I do this, Do I have to write a shell script or something like that, is there any helpful tutorial?
> 
>  		 	   		  
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
> For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx