File: /var/www/content-sp/work-sp/nqb_question_edit_secondary_live.php
<?php
include_once('nqb_immediatelyedit_section.php');
// ini_set('display_errors',1);
// ini_set('display_startup_errors',1);
// error_reporting(E_ALL);
//check edit permissions
$fileName = 'nqb_question_edit_primary_live';
if (in_array($fileName, $pageArray)) {
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$SP_MEDIUM = 'csp_sp_medium';
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$allMedium = $conn->query("SELECT medium_id,medium_name from $SP_MEDIUM order by medium_id");
/***search question */
if (isset($_REQUEST['search_question'])) {
$ques_mtype = $_REQUEST['ques_mtype'];
$search_term = $_REQUEST['search_term'];
$medium_id = $_REQUEST['medium_id'];
$_SESSION['ques_mtype_sec'] = $ques_mtype;
$_SESSION['imm_quesid_sec'] = $search_term;
$_SESSION['imm_medium_id'] = $medium_id;
}
if (!empty($_SESSION['imm_quesid_sec'])) {
$quesId = $_SESSION['imm_quesid_sec'];
$med_id = $_SESSION['imm_medium_id'];
$mType = $_SESSION['ques_mtype_sec'];
include 'str_replace_type.php';
?>
<meta http-equiv="Content-Language" content="hi">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src='/tiny_mce_<?php echo $mType; ?>/jscripts/tiny_mce/tinymce.min.js'></script>
<script type="text/javascript">
tinymce.init({
selector: "textarea",
theme: 'silver',
plugins: "save ,tiny_mce_wiris, pagebreak, image, lists, table, fullscreen, spellchecker, link, anchor, charmap, code, paste",
toolbar: "save newdocument | bold italic underline strikethrough | alignleft aligncenter alignright alignjustify | formatselect |fontselect | fontsizeselect | cut copy paste | bullist numlist | | outdent indent blockquote | undo redo | link unlink anchor | forecolor backcolor | table | hr removeformat | superscript subscript spellchecker pagebreak | tiny_mce_wiris_formulaEditor tiny_mce_wiris_formulaEditorChemistry charmap image | fullscreen code help",
});
jQuery.noConflict();
jQuery(document).ready(function() {
siteUrl = jQuery("#site_url").val();
// *******************************
jQuery('#btn_back').on('click', function() {
close();
});
});
function validateForm() {
if (jQuery('#exist_medium').val() == jQuery('#medium').val()) {
alert("Please Select different medium");
return false;
}
if (jQuery("input[name='ques_of']:checked").length == 0) {
alert("Select Question Repository");
return false;
}
}
</script>
<style>
.modal-backdrop {
z-index: 999 !important;
}
.form-group {
margin-bottom: 10px;
margin-top: 10px;
}
label {
font-size: 16px;
}
.form-control {
font-weight: bold;
}
.radio_ans {
top: -5px;
left: 10px;
height: 25px !important;
width: 25px !important;
background-color: #eee;
border-radius: 50%;
position: relative !important;
opacity: 1 !important;
}
.panel-body #frmaddQues div.form-group div.tox.tox-tinymce {
height: 396px !important;
}
.panel-body #frmaddQues div.form-group div.tox.tox-tinymce.tox-fullscreen {
height: 100% !important;
}
</style>
<?php
$protocol = ((!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off') || $_SERVER['SERVER_PORT'] == 443) ? "https://" : "http://";
$root_link = $protocol . $_SERVER['HTTP_HOST'] . '/';
$tinyMcefolder = '../tiny_mce_' . $mType;
$uploadFolder = '../uploads/tet_admin_photos_' . $mType . '/';
/**str eplace for form submit */
$submitSpacearray = array($tinyMcefolder, $uploadFolder, '../old_tinymcesp', "'");
$submitReplace = array("../wp-content/plugins/tet-india/files/tinymce_new", "/wp-content/uploads/tet_admin_photos/", "../wp-content/plugins/tet-india/files/tinymce", "''");
if (isset($_REQUEST['btn_update'])) {
$ques_ref_id = $_REQUEST['ques_ref_id'];
$question_id_org = $_REQUEST['question_id_org'];
$instruction = isset($_POST['instruction']) ? ((trim($_REQUEST['instruction']))) : "";
$instructionQ = str_replace($submitSpacearray, $submitReplace, $instruction);
$question = isset($_POST['question']) ? (($_POST['question'])) : "";
$questionQ = str_replace($submitSpacearray, $submitReplace, $question);
$correctAnswer = $_POST['radio_ans'];
$orginal_answer = $_POST['orginal_answer'];
$ans1 = isset($_POST['ans_1']) ? (($_POST['ans_1'])) : "";
$ans1Q = str_replace($submitSpacearray, $submitReplace, $ans1);
$ans2 = isset($_POST['ans_2']) ? (($_POST['ans_2'])) : "";
$ans2Q = str_replace($submitSpacearray, $submitReplace, $ans2);
$ans3 = isset($_POST['ans_3']) ? (($_POST['ans_3'])) : "";
$ans3Q = str_replace($submitSpacearray, $submitReplace, $ans3);
$ans4 = isset($_POST['ans_4']) ? (($_POST['ans_4'])) : "";
$ans4Q = str_replace($submitSpacearray, $submitReplace, $ans4);
$ans5 = isset($_POST['ans_5']) ? (($_POST['ans_5'])) : "";
$ans5Q = str_replace($submitSpacearray, $submitReplace, $ans5);
$question_solution = $_REQUEST['solution'];
$question_solutionQ = str_replace($submitSpacearray, $submitReplace, $question_solution);
$medium = $_REQUEST['medium'];
$active_solution = $_REQUEST['active_solution'];
$status = $_REQUEST['ques_state'];
$ques_of = explode(',', $_REQUEST['ques_of']);
$quesOfjson = json_encode($ques_of, JSON_UNESCAPED_UNICODE);
if ($status == '3' || $status == '4') {
$prfQuery = ",last_proofread_by='$adminId',last_proofread_date='$curDate'";
} else {
$prfQuery = '';
}
if ($ques_ref_id != '' && $ques_ref_id != '0') {
if ($correctAnswer != '') {
if ($orginal_answer != $correctAnswer) {
$conn->query("UPDATE $SP_QUESTION set correct_answer='$correctAnswer' where question_id='$question_id_org'");
$message = "<br>Warning : Correct answer updated";
}
$updateQuery = "UPDATE $SP_QUESTION_MEDIUM_WISE set medium_id='$medium', question_instruction='$instructionQ', question_statement='$questionQ', option_1='$ans1Q', option_2='$ans2Q', option_3='$ans3Q', option_4='$ans4Q', option_5='$ans5Q', question_solution='$question_solutionQ', active_solution='$active_solution',status='$status',last_update_by='$adminId' $prfQuery where id='$ques_ref_id'";
if ($conn->query($updateQuery)) {
$message = 'Question Updated successfully';
$insert3Status = $conn->query("INSERT into $SP_QUES_HISTORY set medium_id='$medium', question_id='$question_id_org', ref_id='$ques_ref_id', action='$status', action_by='$adminId', action_date='$curDate'");
$updateQuesof = $conn->query("UPDATE $SP_QUESTION set question_of='$quesOfjson' where question_id='$question_id_org'");
include_once 'transfer_config.php';
if ((sizeof($ques_of) == '1') && (in_array('sarkari-pariksha', $ques_of))) {
$updateToSp = "REPLACE into h7382406836182.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ques_ref_id' and medium_id='$medium'";
$runQUery = $conn->query($updateToSp);
$message .= $conn->error;
} else if ((sizeof($ques_of) == '1') && (in_array('csc-olympiad', $ques_of))) {
$updateToOly = "REPLACE into cscolydb.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ques_ref_id' and medium_id='$medium'";
$runQUeryOly = $conn->query($updateToOly);
$message .= $conn->error;
} else if ((sizeof($ques_of) == '2')) {
$updateToSp = "REPLACE into h7382406836182.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ques_ref_id' and medium_id='$medium'";
$runQUery = $conn->query($updateToSp);
$updateToOly = "REPLACE into cscolydb.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ques_ref_id' and medium_id='$medium'";
$runQUeryOly = $conn->query($updateToOly);
$message .= $conn->error;
}
} else {
$message = 'Error ' . $conn->error;
}
} else {
$message = "Error : Please select correct answer radio button";
}
} else {
$message = "Error : something went wrong";
}
}
/**form data */
$getQuestion = $conn->query("SELECT qm.id,qm.question_id,qm.medium_id,qm.question_instruction,qm.question_statement,qm.option_1,qm.option_2,qm.option_3,qm.option_4,qm.option_5,qm.question_solution,qm.status,q.correct_answer,q.medium_id as exist,qm.active_solution,q.question_of from $SP_QUESTION_MEDIUM_WISE as qm left join $SP_QUESTION as q on q.question_id=qm.question_id where qm.question_id='$quesId' and qm.medium_id='$med_id'");
$secQues = $getQuestion->fetch_assoc();
$correct_answer = $secQues['correct_answer'];
$exist_medium = $secQues['exist'];
$qStatus = $secQues['status'];
$ref_id = $secQues['id'];
$qmMedium = $secQues['medium_id'];
/***question of which server */
$ft_ques_of = json_decode($secQues['question_of']);
}
?>
<script>
function validateSearch() {
if (jQuery('#ques_mtype').val() == "") {
alert("Please select SP or Olympiad from dropdown");
return false;
}
if (jQuery('#search_term').val() == "") {
alert("Please enter question id");
return false;
}
if (jQuery.isNumeric(jQuery('#search_term').val())) {
return true;
} else {
alert("Please enter question id numeric");
return false;
}
}
</script>
<div class="row">
<div class="col-md-12">
<div class="panel panel-white">
<div class="panel-heading clearfix">
<h4 class="panel-title"></h4>
</div>
<div class="panel-body">
<form class="form-inline" method="post" onsubmit="return validateSearch();">
<div class="form-group">
<select name="ques_mtype" id="ques_mtype" class="form-control">
<option value="">SP or Oly</option>
<option value="sp">SP</option>
<option value="oly">OLY</option>
</select>
<select name="medium_id" id="medium_id" class="form-control">
<option value="1">Select Medium</option>
<?php foreach ($allMedium as $e) { ?>
<option value="<?php echo $e['medium_id']; ?>"><?php echo $e['medium_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<input type="text" id="search_term" name="search_term" class="form-control search_term" value="<?php if (!empty($_SESSION['imm_quesid_sec'])) {
echo $_SESSION['imm_quesid_sec'];
} ?>" style="width: 55em;" placeholder="enter question id" required />
</div>
<button class="btn btn-success" type="submit" name="search_question">Search</button>
</form>
</div>
</div>
</div>
<?php if (!empty($_SESSION['imm_quesid_sec'])) {
if ($secQues['question_id'] != '') {
?>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Translate Question</h4>
</div>
<label class="error" style="display: block;">
<?php if (isset($message)) {
echo $message;
} ?>
</label>
<div class="panel-body">
<form id="frmaddQues" method="post" action="" onsubmit="return validateForm();">
<input type="hidden" name="question_id_org" value="<?php echo $secQues['question_id']; ?>">
<input type="hidden" name="ques_ref_id" value="<?php echo $ref_id; ?>">
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Instructions</label>
<div class="col-sm-9">
<textarea name="instruction" id="instruction">
<?php
$question_instruction = str_replace('../', $root_link, $secQues['question_instruction']);
$question_instruction = str_replace($spaceArray, $replaceSpaceArray, $question_instruction);
echo $question_instruction;
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Statement</label>
<div class="col-sm-9">
<textarea name="question" id="question">
<?php
$question_statement = str_replace('../', $root_link, $secQues['question_statement']);
$question_statement = str_replace($spaceArray, $replaceSpaceArray, $question_statement);
echo htmlspecialchars($question_statement);
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Options & Answer</label>
<input type="hidden" name="orginal_answer" value="<?php echo $correct_answer; ?>" />
<table border="1" style="text-align: center;vertical-align: top">
<tr>
<td style="text-align: center;">Sl. No</td>
<td style="text-align: center;">Correct Answer</td>
<td style="text-align: center;">Answer</td>
</tr>
<tr>
<td>1</td>
<td>
<input type="radio" value="1" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 1 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_1" id="ans_1">
<?php
$option_1 = str_replace('../', $root_link, $secQues['option_1']);
$option_1 = str_replace($spaceArray, $replaceSpaceArray, $option_1);
echo htmlspecialchars($option_1);
?>
</textarea>
</td>
</tr>
<tr>
<td>2</td>
<td>
<input type="radio" value="2" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 2 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_2" id="ans_2">
<?php
$option_2 = str_replace('../', $root_link, $secQues['option_2']);
$option_2 = str_replace($spaceArray, $replaceSpaceArray, $option_2);
echo htmlspecialchars($option_2);
?>
</textarea>
</td>
</tr>
<tr>
<td>3</td>
<td>
<input type="radio" value="3" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 3 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_3" id="ans_3">
<?php
$option_3 = str_replace('../', $root_link, $secQues['option_3']);
$option_3 = str_replace($spaceArray, $replaceSpaceArray, $option_3);
echo htmlspecialchars($option_3);
?>
</textarea>
</td>
</tr>
<tr>
<td>4</td>
<td>
<input type="radio" value="4" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 4 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_4" id="ans_4">
<?php
$option_4 = str_replace('../', $root_link, $secQues['option_4']);
$option_4 = str_replace($spaceArray, $replaceSpaceArray, $option_4);
echo htmlspecialchars($option_4);
?>
</textarea>
</td>
</tr>
<tr>
<td>5</td>
<td>
<input type="radio" value="5" name="radio_ans" class="radio_ans" <?php echo $correct_answer == 5 ? 'checked' : ''; ?> />
</td>
<td>
<textarea name="ans_5" id="ans_5">
<?php
$option_5 = str_replace('../', $root_link, $secQues['option_5']);
$option_5 = str_replace($spaceArray, $replaceSpaceArray, $option_5);
echo htmlspecialchars($option_5);
?>
</textarea>
</td>
</tr>
</table>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Solution</label>
<div class="col-sm-9">
<textarea name="solution" id="solution">
<?php
$question_solution = str_replace('../', $root_link, $secQues['question_solution']);
$question_solution = str_replace($spaceArray, $replaceSpaceArray, $question_solution);
echo htmlspecialchars($question_solution);
?>
</textarea>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Active Solution</label>
<div class="col-sm-9">
<select class="form-control" name="active_solution">
<option value="N" <?php if ($secQues['active_solution'] == 'N') {
echo "selected";
} ?>>No
</option>
<option value="Y" <?php if ($secQues['active_solution'] == 'Y') {
echo "selected";
} ?>>Yes
</option>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Medium</label>
<div class="col-sm-9">
<input type="hidden" value="<?php echo $exist_medium; ?>" id="exist_medium">
<select id="medium" name="medium" class="form-control m-b-sm">
<?php foreach ($allMedium as $md) { ?>
<option value="<?php echo $md['medium_id'] ?>" <?php if ($secQues['medium_id'] == $md['medium_id']) {
echo 'selected="true"';
} ?>>
<?php echo $md['medium_name'] ?>
</option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Status:</label>
<div class="col-sm-9">
<select name="ques_state" id="ques_state" class="form-control">
<option value="0" <?php echo $secQues['status'] == '0' ? 'selected' : '' ?>>Expire</option>
<option value="1" <?php echo $secQues['status'] == '1' ? 'selected' : '' ?>>Draft</option>
<option value="2" <?php echo $secQues['status'] == '2' ? 'selected' : '' ?>>Add</option>
<option value="3" <?php echo $secQues['status'] == '3' ? 'selected' : '' ?>>Proof Read</option>
<option value="4" <?php echo $secQues['status'] == '4' ? 'selected' : '' ?>>ProofRead & Active</option>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Question Repository<span class="badge badge-danger">(required*)</span></label>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="sarkari-pariksha" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '1') && (in_array('sarkari-pariksha', $ft_ques_of))) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">Sarkari Pariksha</label>
</div>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="csc-olympiad" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '1') && (in_array('csc-olympiad', $ft_ques_of))) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">CSC Olympiad</label>
</div>
<div class="col-sm-3">
<input type="radio" name="ques_of" value="sarkari-pariksha,csc-olympiad" class="form-control" <?php if (is_array($ft_ques_of)) {
if ((sizeof($ft_ques_of) == '2')) echo 'checked';
} ?> />
<label class="control-label" for="exampleInputName">Both Repository</label>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label"> </label>
<div class="col-sm-9">
<button type="submit" class="btn btn-primary" name="btn_update">Update</button>
<input type="button" class="btn btn-info" id="btn_back" name="btn_back" value="No change << go back to list" />
</div>
</div>
</form>
</div>
</div>
<!--panel info-->
</div>
<?php } else {
echo "NO question found";
}
}
?>
<div class="page-footer">
<p class="no-s">Graposs Connect ©</p>
</div>
</div>
<?php
} else {
echo "<script type='text/javascript'>alert('You dont have access to edit question');</script>";
echo "<script type='text/javascript'>location.href='/work-sp';</script>";
}
include_once('footer.php');
?>