<?
####CHECK FOR SESSION
INCLUDE "../../secure/session.php";
#####ADD TO STATS COUNTER

 if($LOGGEDONUSERVARI != 'TRUE'){
	  include "members.php";
	  exit();}
	  
	$rhino_venue = $HTTP_POST_VARS['venue'];
		$rhino_save = $HTTP_POST_VARS['sendrequest'];
		$rhino_company = $HTTP_POST_VARS['company'];
		$rhino_pub = $HTTP_POST_VARS['publ'];
		$rhino_pri = $HTTP_POST_VARS['priv'];
		$rhino_perf = $HTTP_POST_VARS['perf'];
		$rhino_date = $HTTP_POST_VARS['dater'];
		$rhino_time = $HTTP_POST_VARS['timer'];	
		$rhino_time2 = $HTTP_POST_VARS['timer2'];	 
				$srp = $HTTP_POST_VARS['srp'];
 
		
			if ($rhino_save=='Send Proposal'){
		$CONFI= "UPDATE licenses Set Sent='Yes' WHERE SRP ='$srp'";
  mysql_query($CONFI);

  include "licensesent.php";
   ####LOG CODE
$log_msg = $_SESSION[‘session_playwright_name’].' sent a license request - SRP: '.$srp;
include "../../secure/backuplog.php";
####
    exit();
  }
  
  
##IF PAGE IS LICENSE DETAIL CHECK ACCESS RIGHTS
  $viewlicense = $HTTP_GET_VARS['license'];
  if ($viewlicense!=''){  
 $SQL = "SELECT * FROM licenses WHERE playwright_unq = '$_SESSION[‘session_playwright_unq’]' AND Sent='Yes' AND Unq='$viewlicense'";
	 $result = mysql_query($SQL);	
	 $numRows = mysql_num_rows($result);
	if ($numRows=='0'){$CHECKFORSENDER="TRUE";}else{$RECIEVERTRUE='TRUE';
	$ACCESSTRUE='TRUE';}
	 }
 if ($CHECKFORSENDER=='TRUE'){  
 $SQL = "SELECT * FROM licenses WHERE user_unq = '$_SESSION[‘session_playwright_unq’]' AND Unq='$viewlicense'";
	 $result = mysql_query($SQL);	
	 $numRows = mysql_num_rows($result);
	if ($numRows=='0'){}else{$SENDERTRUE='TRUE';
		$ACCESSTRUE='TRUE';}
	 }	 
IF ($ACCESSTRUE!='TRUE'){$viewlicense='';}
IF ($ACCESSTRUE=='TRUE'){
if($SENDERTRUE=='TRUE'){$OPENFOR='SENDER';}
if($RECIEVERTRUE=='TRUE'){$OPENFOR='RECIEVER';}

##########CHECK FOR ACTIONS

$SQL = "SELECT * FROM licenses WHERE Unq = '$viewlicense'";
 	 $result = mysql_query($SQL);
	 $db_field = mysql_fetch_assoc($result);
	  $licenseunq = $db_field['Unq'];
	  $licensevalid = $db_field['Valid'];
	  $licensesrp = $db_field['SRP'];
	     if ($licensevalid=='Yes'){$STATUS = 'APPROVED';}

if($OPENFOR=='SENDER'){
  $useraction = $HTTP_GET_VARS['action'];
}
if($OPENFOR=='RECIEVER'){
  $playwaction = $HTTP_GET_VARS['action'];
}
###IF HIDE
if ($useraction=='hide'){
$SQL = "UPDATE licenses SET user_hide= 'Yes' WHERE Unq = '$viewlicense'";
	  mysql_query($SQL);
	   include "licensehide.php";
  exit();	
}
if ($useraction=='kill'){
IF ($STATUS != 'APPROVED'){
$SQL = "DELETE FROM licenses WHERE Unq = '$viewlicense'";
	  mysql_query($SQL);
	  $SQL = "DELETE FROM licensedates WHERE SRP = '$licensesrp'";
	  mysql_query($SQL);
	 include "license.php";
	  	}
}
if ($useraction=='edit'){
IF ($STATUS != 'APPROVED'){
echo "EDIT";
}
}
if ($playwaction=='hide'){
$SQL = "UPDATE licenses SET playwright_hide= 'Yes' WHERE Unq = '$viewlicense'";
	  mysql_query($SQL);
	   include "licensehide.php";
	     exit();		
}
if ($playwaction=='reject'){
IF ($STATUS != 'APPROVED'){
$SQL = "UPDATE licenses SET Valid= 'No' WHERE Unq = '$viewlicense'";
	  mysql_query($SQL);	
	   $CONFI= "UPDATE licenses Set user_hide='' WHERE SRP ='$viewlicense'";
  mysql_query($CONFI);
    ####LOG CODE
$log_msg = $_SESSION[‘session_playwright_name’].' rejected license request - SRP: '.$viewlicense;
include "../../secure/backuplog.php";
####
}
}
if ($playwaction=='accept'){
$SQL = "UPDATE licenses SET Valid= 'Yes' WHERE Unq = '$viewlicense'";
	  mysql_query($SQL);
  $CONFI= "UPDATE licenses Set user_hide='' WHERE SRP ='$viewlicense'";
  mysql_query($CONFI);
      ####LOG CODE
$log_msg = $_SESSION[‘session_playwright_name’].' accepted license request - SRP: '.$viewlicense;
include "../../secure/backuplog.php";
####
	  #RETRIEVE VISITOR DATA
	 $SQL = "SELECT * FROM stats WHERE Unq = '3'";
	 $result = mysql_query($SQL);	
 	 $db_field = mysql_fetch_assoc($result);
	 $CHECKIT = $db_field['Visitors'];

	#ADD 1 TO RAW HITS
	 $NEWHIT = $CHECKIT + 1;
	
	#SAVE NEW VALUE
	  $SQL = "UPDATE stats SET Visitors = '$NEWHIT' WHERE Unq = '3'";
	  mysql_query($SQL);	
}


$SQL = "SELECT * FROM licenses WHERE Unq = '$viewlicense'";
 	 $result = mysql_query($SQL);
	 $db_field = mysql_fetch_assoc($result);
	  $licenseunq = $db_field['Unq'];
	  $licensevalid = $db_field['Valid'];
	  $licensesrp = $db_field['SRP'];
	  $licensepsrp = $db_field['PrintSRP'];
  	  $licensetitle = $db_field['Title'];
  	  $licensewriter = $db_field['Playwright'];
	  $licensevenue = $db_field['Venue'];
	  $licensecompany = $db_field['Company'];
	  $licensecontact = $db_field['ContactName'];
	  $licenseterms = $db_field['Public_Terms'];
	  $licensetermsp = $db_field['Private_Terms'];
	  $licensesent = $db_field['Sent'];
	   $licenseuu = $db_field['user_unq'];
	    $licensepwu = $db_field['playwright_unq'];

	 }
####RAW HITS
	INCLUDE "../../secure/connectiondetails.php";
	  

?>
<!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=iso-8859-1" />
<title>StageRights.com</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<head>
<script language="javascript" src="calendar.js"></script>
</head>
<style type="text/css">
<!--
#headingtxt_l {
	position:absolute;
	width:234px;
	height:115px;
	z-index:1;
	left: 272px;
	top: 38px;
}
.style9 {color: #FF0000}
-->
</style>
</head>
<body>
<div id="topPan">
	<a href="index.php"><img src="images/logo.jpg" alt="Stagerights.com" width="214" height="100" border="0"  class="logo" title="Stagerights.com"/></a>
	<a href="index.php"><img src="images/logotext.jpg" alt="Stagerights.com" width="389" height="100" border="0"  class="logotext" title="Stagerights.com"/></a>
	<p>&nbsp;</p>
		
    <div id="topMenuPan">
	  <div id="topMenuLeftPan"></div>
	  
	  <div id="topMenuMiddlePan">
	  	<ul>
			<? if ($LOGGEDONUSERVARI == 'TRUE'){echo '<li><a href="index.php">Manager</a></li>';}else{echo '<li><a href="index.php">Home</a></li>';} ?>
			<? if ($LOGGEDONUSERVARI == 'TRUE'){echo '<li><a href="editprofile.php">Profile</a></li>';}else{echo '<li><a href="about.php">About us</a></li>';} ?>
			<li class="home">License</li>
			<li><a href="search.php">Search</a></li>
			<? if ($LOGGEDONUSERVARI == 'TRUE'){echo '';}else{echo '<li><a href="members.php">Members</a></li>';} ?>
			<li><a href="shows.php">Shows</a></li>
			<li><a href="faq.php">FAQ</a></li>
			<li><a href="contact.php">Contact</a></li>
<? if ($LOGGEDONUSERVARI == 'TRUE'){echo '<li><a href="logout.php">Logout</a></li>';}else{echo '';} ?>			

		</ul>
	  </div>
	  <div id="topMenuRightPan"></div>
	</div>
</div>

<div id="bodyPan">
  <div id="bodyLeftPan">
  
  <?
  IF ($licensesent!='Yes'){$STATUS = 'Not Sent';}
   IF ($licensesent=='Yes'){$STATUS = 'Sent';
   if ($licensevalid=='Yes'){$STATUS = 'Approved';}
   if ($licensevalid=='No'){$STATUS = 'Rejected';}
   if ($licensevalid==''){$STATUS = 'Awaiting Response';}   
   }
if ($STATUS=='Approved'){$Proposal='License';}ELSE{$Proposal='Proposal';}
  
  ?>
   	<h2><span>StageRights</span> <? ECHO $Proposal?> </h2><? 
	if ($OPENFOR=='SENDER'){	echo '<h2><span>Status</span>  - '.$STATUS,'</h2>'; }
	if ($OPENFOR=='RECIEVER'){
	if ($STATUS == 'Approved'){	echo '<h2><span>Status</span>  - '.$STATUS,'</h2>'; }
	if ($STATUS == 'Rejected'){	echo '<h2><span>Status</span>  - '.$STATUS,'</h2>'; }
	}?>
	<?
	###
	IF ($ACCESSTRUE=='TRUE'){
	if ($OPENFOR=='SENDER'){
	if ($STATUS=='Approved'){	echo '
	<p>
    <p>Permission has been granted for you to peform this script based on the details below: 
	<p>
    <p>SRP#:'.$licensepsrp ; }
	}
	if ($OPENFOR=='RECIEVER'){
	if ($STATUS=='Approved'){	echo '
	<p>
    <p>
	<p>
    <p>SRP#:'.$licensepsrp ; }
	}
	echo '
	<p>
    <p>Show: '.$licensetitle.'   
    <p>Written by: '.$licensewriter.'    
    <p>
	<p>
    <p>Venue: '.$licensevenue.'    
    <p>Performed by: '.$licensecompany.'   
    <p>Rights granted to: '.$licensecontact.'    
    <p>
	<p>
    <p>With the following publically agreed terms:    
    <p>'.$licenseterms.'    
    <p>
	<p>And the following privately agreed terms:    
    <p>'.$licensetermsp.'  
	<p> 
    <p>Scheduled Performances:';
	
	$SQL = "SELECT * FROM licensedates WHERE SRP = '$licensesrp' ORDER by Date";
	$result = mysql_query($SQL);
	while ($db_field = mysql_fetch_assoc($result)){
	  $licensedate = $db_field['Date'];
	  $licensetime = $db_field['Time'];
 echo ' <p>'.$licensedate.' At '.$licensetime.'<br>';}   
 echo ' <p>
    <p> ';}
	
	IF ($ACCESSTRUE!='TRUE'){
	$applyscript = $HTTP_GET_VARS['script'];
	if ($applyscript==''){
	echo '<p>
    <p>There has been an error. Please let us know what you were doing which may have caused the error.: 
	';}
	#########
	if ($applyscript!=''){
	$FINDIT12 = "SELECT * FROM Scripts_Confirmed WHERE Unq = '$applyscript' AND Confirmed = 'Y'"; 
    $result102 = mysql_query($FINDIT12);
    $numRows = mysql_num_rows($result102);
	if($numRows == '0'){
	echo '<p>
    <p>That script was not found.: 
	';
	$CONTINUE='FALSE';
	}
	$db_field = mysql_fetch_assoc($result102);
	$userreadstat = $db_field['user_read'];}
	
	if($CONTINUE!='FALSE'){
	if ($userreadstat=='full'){$EVERYTHINOK='TRUE';}
	if ($EVERYTHINOK!='TRUE'){
	$FINDIT12 = "SELECT * FROM permissions WHERE User_unq = '$_SESSION[‘session_playwright_unq’]' AND Script_unq = '$applyscript' AND Accepted='Yes'"; 
    $result102 = mysql_query($FINDIT12);
	$db_field = mysql_fetch_assoc($result102);
	$usernewrule = $db_field['Bypass'];
	if ($usernewrule=='full'){$EVERYTHINOK='TRUE';}
	if ($EVERYTHINOK!='TRUE'){
	echo '<p>
    <p>You need to have permission to read the full script before requesting to perform it.: 
	';}}
	
 
		}
	
	
	########
	}
	###
		if ($EVERYTHINOK=='TRUE'){
		#########################################################################
		$SQL = "SELECT * FROM Scripts_Confirmed WHERE Unq = '$applyscript'";
 	 $result = mysql_query($SQL);
	 $db_field = mysql_fetch_assoc($result);
	  $licenseunq = $db_field['Unq'];
	  $licensetitle = $db_field['Title'];
  	  $licensewriter = $db_field['Playwright'];
      $licensepwu = $db_field['PlayWright_Unq'];
		
		$rhino = $HTTP_POST_VARS['rhino'];
		$srp = $HTTP_POST_VARS['srp'];
		if ($rhino=='SENT'){
		##make SRP#
		if($srp==''){
				$totalChar = 5;
$salt = "1234567890";  // salt to select chars from 
srand((double)microtime()*1000000); // start the random generator 
$password=""; // set the inital variable 
for ($i=0;$i<$totalChar;$i++)  // loop and create password 
            $password = $password . substr ($salt, rand() % strlen($salt), 1); 
$password = $password;	
		$srp2 = $_SESSION[‘session_playwright_unq’].'-'.$password.'-'.$applyscript;
		$srp = $_SESSION[‘session_playwright_unq’].$password.$applyscript;
###insert license
$SQL = "INSERT INTO licenses (
`Unq` ,
`SRP` ,
`Title` ,
`Playwright` ,
`Venue` ,
`Company` ,
`ContactName` ,
`Username` ,
`Telephone` ,
`Public_Terms` ,
`Private_Terms` ,
`Valid` ,
`PrintSRP` ,
`Sent` ,
`playwright_unq` ,
`user_unq` ,
`script_unq` ,
`playwright_hide` ,
`user_hide` 
)
VALUES (
NULL , '$srp', '$licensetitle', '$licensewriter', '$rhino_venue', '$rhino_perf', '$_SESSION[‘session_playwright_name’]', '$_SESSION[‘session_username’]', '', '$rhino_pub', '$rhino_pri', '', '$srp2', 'No', '$licensepwu', '$_SESSION[‘session_playwright_unq’]', '$licenseunq', '', ''
)";
 mysql_query($SQL);		

##################		
		}
###insert dates

		$rhino_vadd = $HTTP_POST_VARS['Add'];
		if($rhino_vadd=='Add'){
		$rhino_date = $HTTP_POST_VARS['dater'];
		$theDate = isset($_REQUEST["date1"]) ? $_REQUEST["date1"] : "";

$date = $theDate;
$day = substr($date, -2);
	$day = ereg_replace("-", "", $day );
	$month = substr($date, 4,3);
	$month = ereg_replace("-", "", $month );
	$year= substr($date, 0,4);

$newdate= $day.'-'.$month.'-'.$year;
$rhino_time = $HTTP_POST_VARS['timer'];
$rhino_time2 = $HTTP_POST_VARS['timer2'];
if ($rhino_time <= '11'){
$rhino_time3 = 'AM';}
if ($rhino_time >= '12'){
$rhino_time3 = 'PM';}

$rhino_time = $rhino_time.':'.$rhino_time2.$rhino_time3;
$SQL="INSERT INTO licensedates (
`Unq` ,
`SRP` ,
`Date` ,
`Time` 
)
VALUES (
NULL , '$srp', '$newdate', '$rhino_time'
)";
 mysql_query($SQL);	
$SQL = "UPDATE licenses SET Venue = '$rhino_venue' WHERE SRP = '$srp'";
 mysql_query($SQL);	
$SQL = "UPDATE licenses SET Company = '$rhino_company' WHERE SRP = '$srp'";
 mysql_query($SQL);	
$SQL = "UPDATE licenses SET Public_Terms = '$rhino_pub' WHERE SRP = '$srp'";
 mysql_query($SQL);	
$SQL = "UPDATE licenses SET Private_Terms = '$rhino_pri' WHERE SRP = '$srp'";
 mysql_query($SQL);	

 	}
###############		
		}
		$rhino_venue = $HTTP_POST_VARS['venue'];
		$rhino_save = $HTTP_POST_VARS['Send Proposal'];
		$rhino_company = $HTTP_POST_VARS['company'];
		$rhino_pub = $HTTP_POST_VARS['publ'];
		$rhino_pri = $HTTP_POST_VARS['priv'];
		$rhino_perf = $HTTP_POST_VARS['perf'];
		$rhino_date = $HTTP_POST_VARS['dater'];
		$rhino_time = $HTTP_POST_VARS['timer'];
		
		if ($rhino_save=='TRUE'){
		$CONFI= "UPDATE licenses Set Sent='Yes' WHERE SRP ='$srp'";
  mysql_query($CONFI);
		}
echo '		<form name="form1" action="rightsrequest.php?script='.$applyscript.'" method="post" >
		<p>';
#####################
if($rhino!='')
	{
     $SQL = "SELECT * FROM licensedates WHERE SRP = '$srp'";
	 $result = mysql_query($SQL);
	 $mynumrows = mysql_num_rows($result); 	
	  $mynumrowsa = $mynumrows + 1;
    if($mynumrows>=$rhino_perf){$BUTTON='ON';}else{
	echo '<p>Enter date and time for show number '.$mynumrowsa.'<p>';
	############
	require_once('classes/tc_calendar.php');
//instantiate class and set properties
$myCalendar = new tc_calendar("date1", true);$myCalendar->setIcon("images/iconCalendar.gif");
$a = date('d');
$b = date('m');
$c = date('Y');
$myCalendar->setDate($a, $b, $c);
//output the calendar$myCalendar->writeScript();	 
$myCalendar->writeScript();

	############
	
	
	echo '</p><p><select name="timer">
	<option value="00">00</option>
	<option value="01">01</option>
	<option value="02">02</option>
	<option value="03">03</option>
	<option value="04">04</option>
	<option value="05">05</option>
	<option value="06">06</option>
	<option value="07">07</option>
	<option value="08">08</option>
	<option value="09">09</option>
	<option value="10">10</option>
	<option value="11">11</option>	
	<option value="12">12</option>	
    <option value="13">13</option>
	<option value="14">14</option>
	<option value="15">15</option>
	<option value="16">16</option>
	<option value="17">17</option>
	<option value="18">18</option>
	<option value="19">19</option>
	<option value="20">20</option>
	<option value="21">21</option>
	<option value="22">22</option>
	<option value="23">23</option>
	</select>
	<select name="timer2">
	<option value="00">00</option>
	<option value="05">05</option>
	<option value="10">10</option>
	<option value="15">15</option>
	<option value="20">20</option>
	<option value="25">25</option>
	<option value="30">30</option>
	<option value="35">35</option>
	<option value="40">40</option>
	<option value="45">45</option>
	<option value="50">50</option>
	<option value="55">55</option>	
	
	</select>
	
	<input name="Add" class="red" type="submit" value="Add" />';}
	}
	$SQL = "SELECT * FROM licensedates WHERE SRP = '$srp'";
	 $result = mysql_query($SQL);
	 $tho = 0;
	 while($db_field = mysql_fetch_assoc($result)){
	 $lidat = $db_field['Date'];
	 $litim = $db_field['Time'];
	 $tho = $tho + 1;
	 Echo '<p> S#'.$tho.'  -  '.$lidat.'  -  '.$litim;
	 }


#####################		
		
		
if($rhino!='') {echo '<p>&nbsp;</p>';} else{echo '    <p>Complete the Stage Rights application below:';}
echo '	<p>
    <p>Show: '.$licensetitle.'   
    <p>Written by: '.$licensewriter.'    
    <p>Your Name: '.$_SESSION[‘session_playwright_name’].'  
	<p>
	<p>
    <p>Enter the Venue:  <p><input type="text" name="venue" value="'.$rhino_venue.'"> 
    <p>Performed by:   <p><input type="text" name="company" value="'.$rhino_company.'" > 
    <p>
	<p>
    <p>Enter any terms viewable by the public:     
    <p><textarea name="publ" cols="40" rows="5">'.$rhino_pub.'</textarea> 
    <p>
	<p>Enter any terms not viewable by the public:    
    <p><textarea name="priv" cols="40" rows="5">'.$rhino_pri.'</textarea> 
    <p>';
	
	if ($rhino_perf==''){
	echo'	
    <p>How many performances would you like to do?
	<p> <select name="perf" onchange=form1.submit()>
	<option value="0" selected="selected">0</option>
	<option value="1">1</option>
	<option value="2">2</option>
	<option value="3">3</option>
	<option value="4">4</option>
	<option value="5">5</option>
	<option value="6">6</option>
	<option value="7">7</option>
	<option value="8">8</option>
	<option value="9">9</option>
	<option value="10">10</option>
	<option value="11">11</option>
	<option value="12">12</option>
	<option value="13">13</option>
	<option value="14">14</option>
	<option value="15">15</option>
	</select>';}
	if ($rhino_perf!=''){
	echo '	<input type="hidden" name="perf" value="'.$rhino_perf.'">';
	echo '	<input type="hidden" name="srp" value="'.$srp.'">';
	
	echo '
	 <p>Number of shows you want to do:
	<p>'.$rhino_perf.'
	';
	}
	if($rhino!='')
	{
     $SQL = "SELECT * FROM licensedates WHERE SRP = '$srp'";
	 $result = mysql_query($SQL);
	 $mynumrows = mysql_num_rows($result); 	
    if($mynumrows>=$rhino_perf){$BUTTON='ON';}else{
	}
	}
	$SQL = "SELECT * FROM licensedates WHERE SRP = '$srp'";
	 $result = mysql_query($SQL);
	 $tho = 0;
	 while($db_field = mysql_fetch_assoc($result)){
	 $lidat = $db_field['Date'];
	 $litim = $db_field['Time'];
	 $tho = $tho + 1;
	 }
	  
	
	 if($BUTTON=='ON'){echo '<p><p><input name="sendrequest" class="red" type="submit" value="Send Proposal" />';}
	echo'
	
	<input type="hidden" name="rhino" value="SENT">
	</form>';}
	

		#########################################################################
		
	?>
  </div>
  <div id="bodyRightPan">
  <?
  ####MAKE ACTIONS BOX
  IF ($ACCESSTRUE=='TRUE'){
####CHECK IF User
if($OPENFOR=='SENDER'){
##Requests Box
echo '<h2><span>'.$Proposal.'</span> Actions</h2>
	<ul>';
	 echo '<li><a href="rightsrequest.php?action=hide&license='.$licenseunq.'">Hide '.$Proposal.'</a> </li>';
if ($STATUS!='Approved'){	 
#\echo '<li><a href="rightsrequest.php?action=edit&license='.$licenseunq.'">Edit '.$Proposal.'</a> </li>';
	 echo '<li><a href="rightsrequest.php?action=kill&license='.$licenseunq.'">Delete '.$Proposal.'</a> </li>';}
	  echo '<li><a href="message.php?sendto='.$licensepwu.'">Contact Playwright</a> </li>';

	echo'	</ul>';
	 }
	 if($OPENFOR=='RECIEVER'){
##Requests Box
echo '<h2><span>'.$Proposal.'</span> Actions</h2>
	<ul>';
	IF ($licensevalid==''){}ELSE{	 echo '<li><a href="rightsrequest.php?action=hide&license='.$licenseunq.'">Hide '.$Proposal.'</a> </li>';}
		if ($STATUS!='Approved'){
		if ($STATUS=='Rejected'){}else{
	 echo '<li><a href="rightsrequest.php?action=reject&license='.$licenseunq.'">Reject '.$Proposal.'</a> </li>';}
	 echo '<li><a href="rightsrequest.php?action=accept&license='.$licenseunq.'">Accept '.$Proposal.'</a> </li>';}
	 echo '<li><a href="message.php?sendto='.$licenseuu.'">Contact User</a> </li>';

	echo'	</ul>';
	 }

}##  
  
  
  ####
  ?>
  
<?
####CHECK IF PLAYWRIGHT
if($_SESSION[‘sess_account_type’]=='Playwright'){
##Requests Box
echo '<h2><span>License</span> Requests</h2>
	<ul>';
	 $SQL = "SELECT * FROM licenses WHERE playwright_unq = '$_SESSION[‘session_playwright_unq’]' AND Sent='Yes' AND playwright_hide != 'Yes'";
	 $result = mysql_query($SQL);	
 	 while ($db_field = mysql_fetch_assoc($result)) {
	 $lcTitle = $db_field['Title'];
	 $lcUnq = $db_field['Unq'];
	 echo '<li><a href="rightsrequest.php?license='.$lcUnq.'">'.$lcTitle.'</a> </li>';
	 }
		 
echo'	</ul>';
}##
?>  	
	
	
	<h2><span>My</span> Requests</h2>
<?
echo '	<ul>';
	 $SQL = "SELECT * FROM licenses WHERE user_unq = '$_SESSION[‘session_playwright_unq’]' AND user_hide != 'Yes' ORDER BY Sent";
	 $result = mysql_query($SQL);	
 	 while ($db_field = mysql_fetch_assoc($result)) {
	 $lcTitle = $db_field['Title'];
	 $lcUnq = $db_field['Unq'];
	 echo '<li><a href="rightsrequest.php?license='.$lcUnq.'">'.$lcTitle.'</a> </li>';
	 }
	echo'	</ul>';
?>
		<h2><span>License</span> Checker </h2>
	<ul>
	  <li>Enter SRP # </li> 
		<li><form action='license.php' method='post'>
	      <input type="text" name="srpnumber" /> 
		  <input class="red" type="submit" name="action" value="Check">
	      </form>
		</li>
		<li></li>
	</ul>
  </div>
</div>

<div id="footermainPan">
  <div id="footerPan">
   	<? if ($LOGGEDONUSERVARI == 'TRUE'){echo '
	  <ul>
		<li><a href="index.php">Manager</a>| </li>
		<li><a href="editprofile.php">Profile</a>| </li>
		<li><a href="license.php">License</a>| </li>
		<li><a href="search.php">Search</a>| </li>
		<li><a href="shows.php">Shows</a>| </li>
		<li><a href="faq.php">FAQ</a>| </li>
		<li><a href="contact.php">Contact</a> </li>
		<li><a href="logout.php">Log Out</a> </li>
	</ul>';}else{echo '
	  <ul>
		<li><a href="index.php">Home</a>| </li>
		<li><a href="about.php">About us</a>| </li>
		<li><a href="license.php">License</a>| </li>
		<li><a href="search.php">Search</a>| </li>
		<li><a href="members.php">Members</a>| </li>
		<li><a href="shows.php">Shows</a>| </li>
		<li><a href="faq.php">FAQ</a>| </li>
		<li><a href="contact.php">Contact</a> </li>
	</ul>';}
	
	
	?>
	<p class="copyright">© <a href="http://www.pyronox.com">Pyronox Ltd</a>. All right reserved.</p>
	<ul class="templateworld">
  	<li>design by:</li>
	<li><a href="http://www.templateworld.com" target="_blank">Template World</a></li>
 </ul>
  </div>
</div>
</body>
</html>