deleteproposal.php

<?php

$language="enus";
include_once("js/jquery/RichTextEditor/locale/".$language.".php");
function getLabel($key,$language){
   global $label;
   return $label[$language][$key];
}

$headcommands='
<link rel="Stylesheet" type="text/css" href="js/jquery/RichTextEditor/css/jqrte.css" />
<link type="text/css" href="js/jquery/RichTextEditor/css/jqpopup.css" rel="Stylesheet"/>
<link rel="stylesheet" href="js/jquery/RichTextEditor/css/jqcp.css" type="text/css"/>
<!-- <link type="text/css" href="widgets.css" rel="stylesheet" /> -->

<script type="text/javascript" src="js/jquery/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="js/jquery/jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="js/jquery/jquery.bgiframe.min.js"></script>
<script type="text/javascript" src="js/jquery/RichTextEditor/jqDnR.min.js"></script>
<script type="text/javascript" src="js/jquery/jquery.jqpopup.min.js"></script>
<script type="text/javascript" src="js/jquery/RichTextEditor/jquery.jqcp.min.js"></script>
<script type="text/javascript" src="js/jquery/RichTextEditor/jquery.jqrte.min.js"></script>
	<script type="text/javascript">
	$(function() {
		$("#abstract_panel").accordion({
			collapsible: true,
			autoHeight: false,
			active: false
		});
	});
	</script>';

include('header.php');

#$userid=isloggedin();
#if (isAdmin($userid))
if ($userid)
{	
	$proposal = fetchValidIntValFromPostWithKey('p');
	if ($proposal === false)
	{
		header("Location: error_page.php");
		exit;
	}
	
	$sql = "SELECT proposals.blurb, proposals.experimentid, proposals.abstract FROM proposals, questions WHERE proposals.id = ".$proposal." and proposals.experimentid = questions.id and questions.roundid = proposals.roundid and questions.phase = 0  ";
	$response = mysql_query($sql);
	while ($row = mysql_fetch_array($response))
	{		
		$blurb =	$row[0];
		$question = $row[1];
		$abstract = $row[2];
				
		$sql = "DELETE FROM proposals WHERE  proposals.id = " . $proposal . " ";
		mysql_query($sql);
		
		// Delete any defines relation (actually should be ALL relations) for this proposal
		if ($originalproposal = getMutatedRelationFrom($proposal))
		{
			deleteProposalRelation($originalproposal, $proposal, 'derives');
		}

		?>
		<div id="actionbox">
			<h2><?=$VGA_CONTENT['prop_ans_txt']?></h2>
			<p><?=$VGA_CONTENT['prop_del_txt']?></p>
		
			<form method="POST" action="newproposaltake.php">			
     				
     				
     				<div id="editor_panel">
				<!-- Input Proposal start -->
				<div id="abstract_panel">
					<h3><span></span><a href="#" id="abstract_title"><?=$VGA_CONTENT['abs_opt_link']?></a></h3>
					<div id="p_abstract_RTE">
						      <textarea id="abstract" name="abstract" class="jqrte_popup" rows="250" cols="70"></textarea>
						      <?php
							$RTE_TextLimit_abstract = MAX_LEN_PROPOSAL_ABSTRACT;//500;
							 include_once("js/jquery/RichTextEditor/content_editor_abstract.php");
							?>
<script type="text/javascript">
$(document).ready(function() {
try{
	    $("#abstract_rte").jqrte();
	    $("#abstract_rte").jqrte_setIcon();
	    $("#abstract_rte").jqrte_setContent();
	    var limit = <?= empty($RTE_TextLimit_abstract) ? 'null' : $RTE_TextLimit_abstract; ?>;
	    if (limit) {
		$("#abstract_rte").data('maxlength', limit);
	    }
	    var prop_abstract = <?= empty($abstract) ? 'null' : json_encode($abstract); ?>;

	    if (prop_abstract)
	    {
		$("#abstract_panel").accordion("activate", 0);
	    }
	    
	    if (prop_abstract) {
		setTimeout(function() {
			$("#abstract_rte").contents().find("body").html(prop_abstract);
		}, 250);
		setTimeout(function() {
		    $("#abstract_rte").jqrte_updateContent();
		}, 250);
	    }
	    else
	    {
		$("#abstract_rte").data('content_length', 0)
	    }
  }
  catch(e){}
 });
</script>
					</div> <!-- p_abstract_RTE -->
				</div> <!-- abstract_panel -->
				
			     <div id="proposal_RTE">
			       <textarea id="content" name="blurb" class="jqrte_popup" rows="500" cols="70"></textarea>
			      <?php
			         $RTE_TextLimit_content = MAX_LEN_PROPOSAL_BLURB;//1000;
			         include_once("js/jquery/RichTextEditor/content_editor_proposal.php");
			         include_once("js/jquery/RichTextEditor/editor.php");
			      ?>
				<input type="hidden" name="question" id="question" value="<?php echo $question; ?>" />
				<?php if ($originalproposal) : ?>
				<input type="hidden" name="origpid" id="origpid" value="<?php echo $originalproposal; ?>" />
				<input type="hidden" name="mutate" id="mutate" value="" />
				<?php endif ?>
				<input type="submit" name="submit" id="submit" value="<?=$VGA_CONTENT['create_proposal_button']?>" disabled="disabled"/>
				</div> <!-- proposal_RTE -->
				</div> <!-- editor_panel -->
				
			<!-- </form> -->
			<script type="text/javascript">
			$(document).ready(function() {
				
				var checklength = function (len) {
					var title = $("#abstract_title");
					var abstract_length = $("#abstract_rte").data('content_length');
					var content_length =  $("#content_rte").data('content_length');
					
					if ((content_length  > 0 && content_length <= limit && abstract_length <= limit_abs) || (content_length  > 0 && abstract_length > 0 && abstract_length <= limit_abs))
					{
						$("input[value=Create proposal]").removeAttr("disabled");
					}
					else 
					{
						$("input[value=Create proposal]").attr("disabled","disabled");
					}
					
					if (content_length  > limit)
					{
						title.html("<?=$VGA_CONTENT['abstract_req_ex_txt']?>:");
						title.css("color", "green"); 
						title.css("font-weight", "bold"); 
						$("#content_rte_chars_msg").html("<?=$VGA_CONTENT['abstract_req_txt']?>");
					}
					else if ( content_length  <= limit )
					{
						title.html("<?=$VGA_CONTENT['abs_opt_link']?>");
						title.css("color", "black"); 
						title.css("font-weight", "normal"); 
						$("#content_rte_chars_msg").html("");
					}
				} 
				
				try{
					var content_box = $("#content_rte");
					content_box.jqrte();
					content_box.jqrte_setIcon();
					//content_box.jqrte_setContent();
					var limit_abs = <?= empty($RTE_TextLimit_abstract) ? 'null' : $RTE_TextLimit_abstract; ?>;
					var limit = <?= empty($RTE_TextLimit_content) ? 'null' : $RTE_TextLimit_content; ?>;
					if (limit) {
						content_box.data('maxlength', limit);
						content_box.data('callback', checklength);
						$("#abstract_rte").data('callback', checklength);
					}
					var prop_content = <?= empty($blurb) ? 'null' : json_encode($blurb); ?>;

					if (prop_content) {
						setTimeout(function() {
							content_box.contents().find("body").html(prop_content);
						}, 250);

						setTimeout(function() {
						    content_box.jqrte_updateContent();
						}, 250);
					}
				}
				catch(e){
					alert("An exception occurred in the script. Error name: " + e.name  + ". Error message: " + e.message);
				}
			});
			</script>
		<!-- Input Proposal end -->
			</form>
			
			<br /><br /><br />
		</div>

		
		<?php
	}
	
}
else
{
		header("Location: login.php");
}
include('footer.php');
?>