ikan Uploader :
Directory : /var/www/html/chalkbank.com/cronjobs/
Upload File : |
| Current File : /var/www/html/chalkbank.com/cronjobs/resultsCron.php |
<?php
//error_reporting(E_ALL);
define('DB_SERVER', "shardauniversitywriter.cluster-custom-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com");
define('DB_USERNAME', "quizbyte_user");
define('DB_PASSWORD', "quiz@byte121!");
define('DB_DATABASE', "shardaac_quizbyte_db");
define('COMPANY', "ShardaTech pvt ltd.");
/* Connect to MySQL and select the database. */
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if (!$conn) {
mysqli_connect_error();
}
$new_time = time();
//$sql = "select rid from savsoft_result where result_status='Open' limit 0,100";
$sql = "select savsoft_result.rid from savsoft_result join savsoft_quiz on savsoft_result.quid=savsoft_quiz.quid where result_status='Open' AND savsoft_quiz.end_date<$new_time limit 0,100";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo ("total count - " . mysqli_num_rows($result) . "<br/>");
while ($row = mysqli_fetch_assoc($result)) {
$rid = $row['rid'];
$query=mysqli_query($conn,"select * from savsoft_result join savsoft_quiz on savsoft_result.quid=savsoft_quiz.quid where savsoft_result.rid='$rid'");
$quiz = mysqli_fetch_assoc($query);
if($quiz['rid'])
{
$score_ind=explode(',',$quiz['score_individual']);
$r_qids=explode(',',$quiz['r_qids']);
$qids_perf=array();
$marks=0;
$correct_score=$quiz['correct_score'];
$end_time=$quiz['end_date'];
$incorrect_score=$quiz['incorrect_score'];
$total_time=array_sum(explode(',',$quiz['individual_time']));
if($total_time==0) {
$total_time = $quiz['duration']*60;
}
$manual_valuation=0;
foreach($score_ind as $mk => $score){
$qids_perf[$r_qids[$mk]]=$score;
if($score == 1){
$marks+=$correct_score;
}
if($score == 2){
$marks+=$incorrect_score;
}
if($score == 3){
$manual_valuation=1;
}
}
$percentage_obtained=($marks/$quiz['total_quiz_questions'])*100;
if($percentage_obtained >= $quiz['pass_percentage']){
$qr='Pass';
}else{
$qr='Fail';
}
$userdata=array(
'total_time'=>$total_time,
'end_time'=>$end_time,
'score_obtained'=>$marks,
'percentage_obtained'=>$percentage_obtained,
'manual_valuation'=>$manual_valuation
);
if($manual_valuation == 1){
$userdata['result_status']='Pending';
}else{
$userdata['result_status']=$qr;
}
$sqlUpdate = "UPDATE `savsoft_result` SET total_time='".$userdata['total_time']."',end_time='".$userdata['end_time']."', score_obtained='".$userdata['score_obtained']."',percentage_obtained='".$userdata['percentage_obtained']."',manual_valuation='".$userdata['manual_valuation']."',result_status='".$userdata['result_status']."' WHERE rid = $rid" ;
mysqli_query($conn, $sqlUpdate);
// Save Result In Leaderboard
add_leaderboard($rid, $conn);
foreach($qids_perf as $qp => $qpval){
$crin="";
if($qpval=='0'){
$crin=", no_time_unattempted=(no_time_unattempted +1) ";
}else if($qpval=='1'){
$crin=", no_time_corrected=(no_time_corrected +1)";
}else if($qpval=='2'){
$crin=", no_time_incorrected=(no_time_incorrected +1)";
}
$query_qp="update savsoft_qbank set no_time_served=(no_time_served +1) $crin where qid='$qp' ";
mysqli_query($conn, $query_qp);
}
}
}
echo "<br/> end<br/>";
} else {
echo "no record found";
}
/*
* function : add_leaderboard
*/
function add_leaderboard($rid,$conn){
$querylqry = mysqli_query($conn,"select savsoft_result.*,savsoft_users.*,savsoft_quiz.* from savsoft_result, savsoft_users, savsoft_quiz where savsoft_users.uid=savsoft_result.uid and savsoft_quiz.quid=savsoft_result.quid and savsoft_result.rid='$rid'");
$qresults = mysqli_fetch_assoc($querylqry);
$quid = $qresults['quid'];
$uid = $qresults['uid'];
$score_obtained = $qresults['score_obtained'];
$percentage_obtained = $qresults['percentage_obtained'];
$total_time = $qresults['total_time'];
$end_time = $qresults['end_time'];
$queryqb = mysqli_query($conn,"select * from savsoft_leaderboard where uid='$uid' AND quid = '$quid'");
$results = mysqli_fetch_assoc($queryqb);
$userdata='';
if(empty($results))
{
$userdata=array(
'uid'=>$uid,
'quid'=>$quid,
'rid'=>$rid,
'score_obtained'=>$score_obtained,
'total_time'=>$total_time,
'percentage_obtained'=>$percentage_obtained,
'profile_image'=>$logged_in['profie_image'],
'attempted_ip'=>$_SERVER['REMOTE_ADDR'],
'createdon'=>date('Y-m-d H:i:s',$end_time)
);
$query_insqp="INSERT INTO savsoft_leaderboard SET total_time='".$userdata['total_time']."',uid='".$userdata['uid']."',quid='".$userdata['quid']."',createdon='".$userdata['createdon']."',profile_image='".$userdata['profile_image']."',score_obtained='".$userdata['score_obtained']."',attempted_ip='".$userdata['attempted_ip']."',percentage_obtained='".$userdata['percentage_obtained']."',rid='".$userdata['rid']."'";
mysqli_query($conn, $query_insqp);
} else {
$userdata=array(
'rid'=>$rid,
'total_time'=>$total_time,
'score_obtained'=>$score_obtained,
'percentage_obtained'=>$percentage_obtained,
'attempted_ip'=>$_SERVER['REMOTE_ADDR'],
'profile_image'=>$logged_in['profie_image'],
'modifiedon'=>date('Y-m-d H:i:s')
);
// print_r($userdata); die;
if($score_obtained>$result['score_obtained'] && $percentage_obtained>$result['percentage_obtained']){
$query_nqp="update savsoft_leaderboard SET total_time='".$userdata['total_time']."',modifiedon='".$userdata['modifiedon']."',profile_image='".$userdata['profile_image']."',score_obtained='".$userdata['score_obtained']."',attempted_ip='".$userdata['attempted_ip']."',percentage_obtained='".$userdata['percentage_obtained']."',rid='".$userdata['rid']."' where uid='$uid' AND quid='$quid' ";
mysqli_query($conn, $query_nqp);
}
//echo $this->db->last_query(); die;
}
}
Kontol Shell Bypass