New Topic/Question
Reply
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 & 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 & 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> 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.
MultiQuote
| 