1 Replies - 1325 Views - Last Post: 04 January 2009 - 08:10 PM Rate Topic: -----

#1 OWL  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 05-December 08

User Authentication not working on site

Post icon  Posted 05 December 2008 - 09:09 PM

<cfparam name="URL.Profile_Id" default="1">
<cfquery name="rs_index_login" datasource="wpan7608">
SELECT *
FROM artist
WHERE Profile_Id = <cfqueryparam value="#URL.Profile_Id#" cfsqltype="cf_sql_numeric"> 
</cfquery>
<cfif IsDefined("FORM.email")>
  <cfset MM_redirectLoginSuccess="profile_speci.cfm?profile_id=#rs_index_login.Profile_Id#">
  <cfset MM_redirectLoginFailed="index.cfm?loginfailed=True">
  <cfquery  name="MM_rsUser" datasource="wpan7608">
  SELECT Email,Password FROM artist WHERE Email=<cfqueryparam value="#FORM.email#" cfsqltype="cf_sql_clob" maxlength="45"> AND Password=<cfqueryparam value="#FORM.password#" cfsqltype="cf_sql_clob" maxlength="45">
  </cfquery>
  <cfif MM_rsUser.RecordCount NEQ 0>
	<cftry>
	  <cflock scope="Session" timeout="30" type="Exclusive">
		<cfset Session.MM_Username=FORM.email>
		<cfset Session.MM_UserAuthorization="">
	  </cflock>
	  <cfif IsDefined("URL.accessdenied") AND true>
		<cfset MM_redirectLoginSuccess=URL.accessdenied>
	  </cfif>
	  <cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
	  <cfcatch type="Lock">
		<!--- code for handling timeout of cflock --->
	  </cfcatch>
	</cftry>
  </cfif>
  <cflocation url="#MM_redirectLoginFailed#" addtoken="no">
  <cfelse>
  <cfset MM_LoginAction=CGI.SCRIPT_NAME>
  <cfif CGI.QUERY_STRING NEQ "">
	<cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
  </cfif>
</cfif>
<cfparam name="URL.Profile_Id" default="1">
<cfquery name="qCatGo" datasource="wpan7608">
SELECT *
FROM category
WHERE Type_Id = <cfqueryparam value="#URL.Profile_Id#" cfsqltype="cf_sql_numeric"> 
 
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ward Network ::Become A Member!!!</title>



<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationselect.js" type="text/javascript"></script>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextarea.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationCheckbox.js" type="text/javascript"></script>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
	var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
	if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
	d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>

<link rel="stylesheet" href="styles/style.css" type="text/css" media="screen" />
<link rel="stylesheet" href="styles/stylehome.css" type="text/css" media="screen" />
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
</head>

<body class="oneColElsCtr" onload="MM_preloadImages('become_over.png','create_over.png','submit_over.png','postevent_over.png','searchprof_rollover.png','marchingband_rollover.png','showchoir_rollover.png','musicaltheatre_rollover.png','searcheventsbtn_rollover.png','searchvenuesbtn_rollover.png','createprofilebtn_rollover.png')">
<div id="container">
  
  <div id="mainContent">
	<cfinclude template="includes/header.cfm">
	<div id="apDiv4">
  <div id="searchbut"><a href="search/ward_search.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('profilebutt','','searchprof_rollover.png',1)"><img src="searchprof_plain.png" alt="Search Profile" name="profilebutt" width="200" height="40" border="0" id="profilebutt" /></a></div>
  
  
  <div id="menubarone">
	<ul id="MenuBar1" class="MenuBarHorizontal">
	  <li><a class="MenuBarItemSubmenu" href="categories/category.cfm?type_id=1">Vocalist</a>
		  <ul class="topfly">
			<li class="voc"><a href="categories/category.cfm?type_id=1">Soprano</a></li>
			<li class="voc"><a href="categories/category.cfm?type_id=1">Mezzo Soprano</a></li>
			<li class="voc"><a href="categories/category.cfm?type_id=1">Tenor</a></li>
			<li class="voc"><a href="categories/category.cfm?type_id=1">Baritone</a></li>
			<li class="voc"><a href="categories/category.cfm?type_id=1">Bass</a></li>
		  </ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=2" class="MenuBarItemSubmenu">Instrumentalist</a>
		<ul>
		  <li class="inst"><a href="categories/category.cfm?type_id=2">Woodwinds</a></li>
		  <li class="inst"><a href="categories/category.cfm?type_id=2">Brass</a></li>
		  <li class="inst"><a href="categories/category.cfm?type_id=2">Strings</a></li>
		  <li class="inst"><a href="categories/category.cfm?type_id=2">Percussion</a></li>
		  <li class="inst"><a href="categories/category.cfm?type_id=2">Piano</a></li>
		  <li cl><a href="categories/category.cfm?type_id=2">Guitar</a></li>
		</ul>
	  </li>
	  <li><a class="MenuBarItemSubmenu" href="categories/category.cfm?type_id=3">Dancers</a>
		  <ul>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Jazz</a>			  </li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Ballet</a></li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Hip Hop</a></li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Modern</a></li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Tap</a></li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Swing</a></li>
			<li class="danc"><a href="categories/category.cfm?type_id=3">Ballroom</a></li>
		  </ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=4" class="MenuBarItemSubmenu">Actor</a>
		<ul>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Male</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Female</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Theatre</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Musical Theatre</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Improv</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Comedy</a></li>
		  <li class="acto"><a href="categories/category.cfm?type_id=4">Shake- spearian</a></li>
		</ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=5" class="MenuBarItemSubmenu">Composers/Arrangers</a>
		<ul>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Show Choir</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Musical Theatre</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Marching Band</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Choral</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Instrumental</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Strings</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Bands</a></li>
		  <li class="comp"><a href="categories/category.cfm?type_id=5">Religious</a></li>
		</ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=6" class="MenuBarItemSubmenu">Choreographers</a>
		<ul>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Show Choir</a></li>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Musical Theatre</a></li>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Marching Band</a></li>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Dance Team</a></li>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Cheer</a></li>
		  <li class="chor"><a href="categories/category.cfm?type_id=6">Solo Dance</a></li>
		</ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=7" class="MenuBarItemSubmenu">Clinicians/Judges</a>
		<ul>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Show Choir</a></li>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Choral</a></li>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Instrumental</a></li>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Dance</a></li>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Theatre</a></li>
		  <li class="clin"><a href="categories/category.cfm?type_id=7">Variety</a></li>
		</ul>
	  </li>
	</ul>
  </div>
  
  <div id="btmn">
<ul id="MenuBar2" class="MenuBarHorizontal">
	  <li><a class="MenuBarItemSubmenu" href="categories/category.cfm?type_id=8">Writers</a>
		  <ul>
			<li class="writ"><a href="categories/category.cfm?type_id=8">Theatre</a></li>
			<li class="writ"><a href="categories/category.cfm?type_id=8">Film</a></li>
			<li class="writ"><a href="categories/category.cfm?type_id=8">Television</a></li>
			<li class="writ"><a href="categories/category.cfm?type_id=8">Musical Theatre</a></li>
		  </ul>
	</li>
	  <li><a href="categories/category.cfm?type_id=9" class="MenuBarItemSubmenu">Technicians</a>
		<ul>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Light</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Sound</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Studio</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Costumes</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Stage Crew</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Set</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">D.J.'s</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Camera</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Editing</a></li>
		  <li class="tech"><a href="categories/category.cfm?type_id=9">Mixing</a></li>
		</ul>
	  </li>
	  <li><a class="MenuBarItemSubmenu" href="categories/category.cfm?type_id=10">Coaches/Lessons</a>
		  <ul>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Voices</a>			  </li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">WoodWinds</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Brass</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Strings</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Percussion</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Piano</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Guitar</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Dance</a></li>
			<li class="coac"><a href="categories/category.cfm?type_id=10">Acting</a></li>
		  </ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=11" class="MenuBarItemSubmenu">Directors/Managers/Producers</a>
		<ul>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Directors</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Conductors</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Film</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Theatre</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Bands &amp; Ensembles</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Managers</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Producers</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Agents</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Studio Projects</a></li>
		  <li class="dire"><a href="categories/category.cfm?type_id=11">Live Events</a></li>
		</ul>
	  </li>
	  <li><a href="categories/category.cfm?type_id=12" class="MenuBarItemSubmenu">Bands &amp; Ensembles</a>
		<ul>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Choral</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Instrumental</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Rock</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Country</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Acapella</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Barbershop</a></li>
		  <li class="band"><a href="categories/category.cfm?type_id=12">Religious</a></li>
		</ul>
	  </li>
  </ul>
</div>
  
	
  </div>
   <div id="create">
<p>Become A Member!</p>
<p><a href="profile_member.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('profile','','createprofilebtn_rollover.png',1)"><img src="createprofilebtn.png" alt="Create Profiles" name="profile" width="286" height="150" border="0" id="profile" /></a>
<cfif isDefined("URL.loginfailed")><p>Login Failed</p></cfif>
<form action="<cfoutput>#MM_loginAction#</cfoutput>" method="POST" name="loginform" id="loginform">
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Email:<input name="email" type="text" size="15" maxlength="30" /></p><p>Password:
  <input name="password" type="password" size="15" maxlength="30"/>
</p>
<input name="loginSubmit" type="submit" value="Login" />
<p class="small">Forget Password?</p>
<p class="small"><a href="profile_member.cfm">Register</a></p>
</form>
</div>
<div id="search">
<p class="centeredtext">Search for Profiles associated with these</p>
<p class="popgroup"><img src="populartext.png" alt="Popular Groups" /></p>
<br />
<p><a href="Profile_Search.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('marching','','marchingband_rollover.png',1)"><img src="marchingband_plain.png" alt="Marching Band" name="marching" width="150" height="30" border="0" id="marching" /></a><a href="Profile_Search.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('show','','showchoir_rollover.png',1)"><img src="showchoir_plain.png" alt="Show Choir" name="show" width="150" height="30" border="0" id="show" /></a><a href="Profile_Search.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Musical Theatre','','musicaltheatre_rollover.png',1)"><img src="musicaltheatre_plain.png" alt="Musical Theatre" name="Musical Theatre" width="150" height="30" border="0" id="Musical Theatre" /></a></p>
<p class="centeredtext">View the full Group List</p>
<br />
<p><a href="events.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('events','','searcheventsbtn_rollover.png',1)"><img src="searcheventsbtn.png" alt="Search Events Competitions, Festivals, and More" name="events" width="286" height="150" border="0" id="events" /></a><a href="venues.cfm" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('venues','','searchvenuesbtn_rollover.png',1)"><img src="searchvenuesbtn.png" alt="Search Venues Get contact info for theaters and event sites" name="venues" width="286" height="150" border="0" id="venues" /></a></p>
</div>
	<!-- end #mainContent -->
</div>
  
  <!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats -->
  <cfinclude template="includes/footer.cfm">
  <!-- end #container -->
</div>
  
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
//-->
</script>
</body>
</html>



It works perfectly on my local computer, once uploaded, I can't get past the first page. The user credentials are all in the database, the database name is the same as the one being used on my local computer. It redirects me to the login failed page when I enter the correct credentials.

Is This A Good Question/Topic? 0
  • +

Replies To: User Authentication not working on site

#2 SleepingInChapel  Icon User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 59
  • Joined: 02-January 09

Re: User Authentication not working on site

Posted 04 January 2009 - 08:10 PM

View PostOWL, on 5 Dec, 2008 - 08:09 PM, said:

It works perfectly on my local computer, once uploaded, I can't get past the first page. The user credentials are all in the database, the database name is the same as the one being used on my local computer. It redirects me to the login failed page when I enter the correct credentials.


If everything is working fine on your local computer (I assume you're using ColdFusion developer) then I only thing I can guess is that you haven't defined your datasource name in ColdFusion administrator on the remote side.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1