File: /var/www/content-sp/work-sp/nqb_question_edit_dummy.php
<?php
include_once('header.php');
// ini_set('display_errors',1);
// ini_set('display_startup_errors',1);
// error_reporting(E_ALL);
//check edit permissions
$fileName = 'nqb_question_edit';//str_replace('.php', '', basename($_SERVER['REQUEST_URI'], '?' . $_SERVER['QUERY_STRING']));
if (in_array($fileName, $pageArray)) {
echo "Yes";
$adminId = $editor_id;
$curDate = date('Y-m-d H:i:s');
$SP_MEDIUM = 'csp_sp_medium';
$TT_PREVIOUS_EXAM_TABLE = 'csp_sp_previous_exam';
$SP_MASTER_CATEGORY = 'csp_sp_master_category';
$SP_QUESTION = 'csp_sp_question';
$SP_MASTER_LEVEL = 'csp_sp_master_level';
$SP_QUESTION_DIFFICULTY = 'csp_sp_question_difficulty';
$SP_MASTER_STRUCTURE = 'csp_sp_master_structure';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$quesId = $_REQUEST['quesId'];
$mType = $_REQUEST['mType'];
include 'str_replace_type.php';
$allMedium = $conn->query("SELECT medium_id,medium_name from $SP_MEDIUM");
$allPreExams = $conn->query("SELECT id, exam_name, status from $TT_PREVIOUS_EXAM_TABLE where status = '1' ");
$allMaster = $conn->query("SELECT mc.master_id, mc.master_name from $SP_MASTER_CATEGORY as mc order by mc.master_id");
$allLevel = $conn->query("SELECT level_name,description from $SP_MASTER_LEVEL where status='1'");
$allDifficulty = $conn->query("SELECT difficulty,description from $SP_QUESTION_DIFFICULTY where status='1'");
?>
<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",
});
function validateForm() {
if (jQuery('#sbtpc_master').val() == "") {
alert("Select Master Subject");
jQuery('#sbtpc_master').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#sbtpc_subject').val() == "") {
alert("Select Subject");
jQuery('#sbtpc_subject').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#ques_level').val() == "") {
alert("Select Question Level");
jQuery('#ques_level').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery('#ques_difficulty').val() == "") {
alert("Select Question Difficulty");
jQuery('#ques_difficulty').focus();
jQuery(":focus").css("background-color", "#f1d9d9");
return false;
}
if (jQuery("input[name='ques_of']:checked").length == 0) {
alert("Select Question Repository");
return false;
}
}
jQuery.noConflict();
jQuery(document).ready(function() {
siteUrl = jQuery("#site_url").val();
// *******************************
jQuery('#btn_back').on('click', function() {
close();
});
});
</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/contentsp_photos/';
/**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_edit'])) {
$question_id = $_REQUEST['question_id'];
$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'];
$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);
$prev_exam_name = $_REQUEST['prev_exam_name'];
$prev_exam_year = $_REQUEST['prev_exam_year'];
$prev_exam_shift = $_REQUEST['prev_exam_shift'];
$medium = $_REQUEST['medium'];
$master_id = $_REQUEST['sbtpc_master'];
$subject_id = $_REQUEST['sbtpc_subject'];
$topic_id = $_REQUEST['sbtpc_topic'];
$sub_topic = $_REQUEST['sub_topic'];
$total_option = $_REQUEST['total_option'];
$ques_level = $_REQUEST['ques_level'];
$ques_difficulty = $_REQUEST['ques_difficulty'];
$ques_state = $_REQUEST['ques_state'];
$ques_of = explode(',', $_REQUEST['ques_of']);
$quesOfjson = json_encode($ques_of, JSON_UNESCAPED_UNICODE);
$sys_id = sprintf('%03d', $master_id) . '-' . sprintf('%04d', $subject_id) . '-' . sprintf('%05d', $topic_id) . '-' . sprintf('%06d', $sub_topic) . '-' . time() . '-' . rand('1000', '9999');
if ($ques_state == '3' || $ques_state == '4') {
$prfQuery = ",last_proofread_by='$adminId',last_proofread_date='$curDate'";
} else {
$prfQuery = '';
}
if ($correctAnswer != '') {
$updateQuery = "UPDATE $SP_QUESTION set master_id='$master_id', subject_id='$subject_id', topic_id='$topic_id',sub_topic_id='$sub_topic',sys_id='$sys_id',level_name='$ques_level', difficulty='$ques_difficulty', medium_id='$medium', no_of_option='$total_option', question_instruction='$instructionQ', question_statement='$questionQ', option_1='$ans1Q', option_2='$ans2Q', option_3='$ans3Q', option_4='$ans4Q', option_5='$ans5Q', correct_answer='$correctAnswer', question_solution='$question_solutionQ',previous_exam_year='$prev_exam_year', previous_exam_name='$prev_exam_name',exam_shift='$prev_exam_shift', status='$ques_state',question_of='$quesOfjson',last_update_by='$adminId' $prfQuery where question_id = '$question_id' ";
if ($conn->query($updateQuery)) {
//insert for history
$insertHistory = $conn->query("INSERT into $SP_QUES_HISTORY set medium_id='$medium', question_id='$question_id',action='$ques_state',action_by='$adminId', action_date='$curDate'");
$message = "Question updated successfully";
} else {
$message = $conn->error;
}
} else {
$message = "Error : Please select correct answer radio button";
}
}
if (isset($_REQUEST['search_question'])) {
$qid = $_REQUEST['search_term'];
$hisID = $qid;
$getDataQuery = $conn->query("SELECT * FROM $SP_QUESTION where question_id='$qid'");
} else {
$getDataQuery = $conn->query("SELECT * FROM $SP_QUESTION where question_id='$quesId'");
$hisID = $quesId;
}
$allData = $getDataQuery->fetch_assoc();
//009-0883-00885-000000-1616663855-7453
// $getSysId = $allData['sys_id'];
// $fetchIds = explode('-',$getSysId);
// $sub_topic_id = $fetchIds[3];
/***question of which server */
$ft_ques_of = json_decode($allData['question_of']);
?>
<div class="page-inner">
<div class="page-title">
<h3>Question Bank</h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="dashboard">Home</a></li>
<li><a href="nqb_questions_list">Question List</a></li>
<li class="active">Edit Questions</li>
</ol>
</div>
</div>
<div id="main-wrapper">
<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">
Question Id:
<input type="text" id="search_term" name="search_term" class="form-control search_term" value="<?php echo $quesId; ?>" style="width: 55em;" />
<button class="btn btn-success" type="submit" name="search_question">Search</button>
</form>
</div>
</div>
<label class="error" style="display: block;">
<?php if (isset($msg)) {
echo $msg;
} ?>
</label>
</div>
<?php
if ($allData['question_id'] != '') {
?>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Edit 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" id="addQues" name="addQues" value="yes" />
<input id="site_url" type="hidden" value="<?php echo $_SERVER['HTTP_HOST']; ?>" name="site_url" />
<input type="hidden" name="question_id" value="<?php echo $allData['question_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 if (isset($allData['question_instruction'])) {
$question_instruction = str_replace('../', $root_link, $allData['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, $allData['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>
<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 if ($allData['correct_answer'] == '1') {
echo "checked";
} ?> />
</td>
<td>
<textarea name="ans_1" id="ans_1">
<?php
$option_1 = str_replace('../', $root_link, $allData['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 if ($allData['correct_answer'] == '2') {
echo "checked";
} ?> />
</td>
<td>
<textarea name="ans_2" id="ans_2">
<?php
$option_2 = str_replace('../', $root_link, $allData['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 if ($allData['correct_answer'] == '3') {
echo "checked";
} ?> />
</td>
<td>
<textarea name="ans_3" id="ans_3">
<?php
$option_3 = str_replace('../', $root_link, $allData['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 if ($allData['correct_answer'] == '4') {
echo "checked";
} ?> />
</td>
<td>
<textarea name="ans_4" id="ans_4">
<?php
$option_4 = str_replace('../', $root_link, $allData['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 if ($allData['correct_answer'] == '5') {
echo "checked";
} ?> />
</td>
<td>
<textarea name="ans_5" id="ans_5">
<?php
$option_5 = str_replace('../', $root_link, $allData['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, $allData['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">Previous Exam Detail</label>
<div class="col-sm-3">
<select id="prev_exam_name" name="prev_exam_name" class="form-control m-b-sm">
<option value="">--Select Exam--</option>
<?php while ($preExam = $allPreExams->fetch_assoc()) { ?>
<option <?php if ($allData['previous_exam_name'] == $preExam['exam_name']) echo "selected"; ?> value="<?php echo $preExam['exam_name'] ?>"><?php echo $preExam['exam_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-sm-3">
<input type="text" value="<?php if (isset($allData['previous_exam_year'])) {
echo $allData['previous_exam_year'];
} ?>" name="prev_exam_year" placeholder="Previous Exam Year" class="form-control" />
</div>
<div class="col-sm-3">
<input type="text" value="<?php if (isset($allData['exam_shift'])) {
echo $allData['exam_shift'];
} ?>" name="prev_exam_shift" placeholder="Any Exam Shift" class="form-control" />
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">No. of Option</label>
<div class="col-sm-9">
<input type="text" class="form-control" name="total_option" value="<?php echo $allData['no_of_option']; ?>" placeholder="No. of option in question" />
</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">
<select id="medium" name="medium" class="form-control m-b-sm">
<?php while ($md = $allMedium->fetch_assoc()) { ?>
<option <?php if (isset($allData['medium_id'])) {
if ($allData['medium_id'] == $md['medium_id']) echo 'selected="true"';
} ?> value="<?php echo $md['medium_id'] ?>"><?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">Level:</label>
<div class="col-sm-9">
<select name="ques_level" id="ques_level" class="form-control">
<option value="">--level--</option>
<?php while ($l = $allLevel->fetch_assoc()) { ?>
<option <?php if ($allData['level_name'] == $l['level_name']) echo "selected"; ?> value="<?php echo $l['level_name']; ?>"><?php echo $l['description']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Difficulty:</label>
<div class="col-sm-9">
<select name="ques_difficulty" id="ques_difficulty" class="form-control">
<option value="">--difficulty--</option>
<?php while ($d = $allDifficulty->fetch_assoc()) { ?>
<option <?php if ($allData['difficulty'] == $d['difficulty']) echo "selected"; ?> value="<?php echo $d['difficulty']; ?>"><?php echo $d['description']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group" style="float:left; width:100%;">
<label for="input-Default" class="col-sm-3 control-label">Select Master:</label>
<div class="col-sm-9">
<select name="sbtpc_master" id="sbtpc_master" class="form-control">
<option value="">--master--</option>
<?php while ($ms = $allMaster->fetch_assoc()) { ?>
<option <?php if ($allData['master_id'] == $ms['master_id']) echo "selected"; ?> value="<?php echo $ms['master_id']; ?>"><?php echo $ms['master_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">Select Subject:</label>
<div class="col-sm-9">
<select name="sbtpc_subject" id="sbtpc_subject" class="form-control">
<option value="">--subject--</option>
<?php if ($allData['subject_id'] != 0) {
$mId = $allData['master_id'];
$getAllMasterSubject = $conn->query("select sub_id, category_name from $SP_MASTER_STRUCTURE where parent_id='0' and master_id='$mId'");
?>
<?php while ($mss = $getAllMasterSubject->fetch_assoc()) { ?>
<option <?php if ($allData['subject_id'] == $mss['sub_id']) echo "selected"; ?> value="<?php echo $mss['sub_id']; ?>"><?php echo $mss['category_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">Select Topic:</label>
<div class="col-sm-9">
<select name="sbtpc_topic" id="sbtpc_topic" class="form-control">
<option value="">--topic--</option>
<?php if ($allData['topic_id'] != 0) {
$sId = $allData['subject_id'];
$getAllTopic = $conn->query("select sub_id, category_name from $SP_MASTER_STRUCTURE where parent_id='$sId'");
?>
<?php while ($tpc = $getAllTopic->fetch_assoc()) { ?>
<option <?php if ($allData['topic_id'] == $tpc['sub_id']) echo "selected"; ?> value="<?php echo $tpc['sub_id']; ?>"><?php echo $tpc['category_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">Select Sub Topic:<span id="sub2pic"></span></label>
<input type="hidden" name="sub2pic_count" id="sub2pic_count" value="">
<div class="col-sm-9">
<select name="sub_topic" id="sub_topic" class="form-control">
<option value="">--sub topic--</option>
<?php if ($allData['sub_topic_id'] != 0 && $allData['sub_topic_id'] != '') {
$tId = $allData['topic_id'];
$getAllSubTopic = $conn->query("select sub_id, category_name from $SP_MASTER_STRUCTURE where parent_id='$tId'");
?>
<?php while ($subTpc = $getAllSubTopic->fetch_assoc()) { ?>
<option <?php if ($allData['sub_topic_id'] == $subTpc['sub_id']) echo "selected"; ?> value="<?php echo $subTpc['sub_id']; ?>"><?php echo $subTpc['category_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 $allData['status'] == '0' ? 'selected' : '' ?>>Expire</option>
<option value="1" <?php echo $allData['status'] == '1' ? 'selected' : '' ?>>Draft</option>
<option value="2" <?php echo $allData['status'] == '2' ? 'selected' : '' ?>>Add</option>
<option value="3" <?php echo $allData['status'] == '3' ? 'selected' : '' ?>>Proof Read</option>
<option value="4" <?php echo $allData['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_edit">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>
</div>
</div>
<script type="text/javascript">
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery('#sbtpc_master').on('change', function() {
var mid = jQuery("#sbtpc_master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + mid + "&type=master";
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sbtpc_subject").html(data);
});
});
jQuery('#sbtpc_subject').on('change', function() {
var subId = jQuery("#sbtpc_subject").val();
var mid = jQuery("#sbtpc_master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + subId + "&type=topic&m=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sbtpc_topic").html(data);
});
});
jQuery('#sbtpc_topic').on('change', function() {
var subId = jQuery("#sbtpc_topic").val();
var mid = jQuery("#sbtpc_master").val();
var loadUrl = "ajax_call/nqb_master_topics.php?eid=" + subId + "&type=subtopic&m=" + mid;
var jqxhr = jQuery.get(loadUrl);
jqxhr.success(function(data) {
jQuery("#sub_topic").html(data);
var len = jQuery("#sub_topic option").length;
//jQuery("#sub2pic").text(len);
document.getElementById("sub2pic").innerHTML = "(" + len + ")";
document.getElementById("sub2pic_count").value = len;
});
});
});
//sbtpc_master
//sbtpc_subject
//sbtpc_topic
</script>
<?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');
?>