ikan Uploader :
Directory : /var/www/html/chalkbank.com/cronjobs/
Upload File : |
| Current File : /var/www/html/chalkbank.com/cronjobs/qbankCron.php |
<?php
//error_reporting(E_ALL);
define('DB_SERVER', "shardauniversity.cluster-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();
}
//
$gap=20; // change this to change the time in minutes, This is the time for which active users are collected.
$tm=date ("Y-m-d H:i:s", mktime (date("H"),date("i")-$gap,date("s"),date("m"),date("d"),date("Y")));
//// Let us update the table and set the status to OFF
////for the users who have not interacted with
////pages in last 10 minutes ( set by $gap variable above ) ///
$sqlqs = "UPDATE plus_login SET status='OFF' WHERE tm < '$tm'";
mysqli_query($conn, $sqlqs);
$currentDate = date('Y-m-d H:i:s');
//$myDate = date("Y-m-d", strtotime( date( "Y-m-d", strtotime( date("Y-m-d") ) )."-1 month" ));
$myDate = date('Y-m-d', strtotime('-10 days', strtotime($currentDate)));
$myDate = $myDate. ' 00:00:00'; //die;
//$sql = "select qid,no_time_served,no_time_corrected from `savsoft_qbank` where no_time_corrected>0 order by qid desc limit 3000";
$sql = "select qid,no_time_served,no_time_corrected from `savsoft_qbank` where no_time_corrected>0 AND (mdate>='".$myDate."' AND mdate<='".$currentDate."') order by qid desc limit 1000";
$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)) {
$qid = $row['qid'];
$level = '';
if($row['no_time_served']>0)
{
$perc=($row['no_time_corrected']/$row['no_time_served'])*100;
$tmpperc = intval($perc);
$level = '';
if($tmpperc<=29){
$level = 'Complex';
} else if($tmpperc<=59 && $tmpperc>=30){
$level = 'Medium';
} else if($tmpperc>=60){
$level = 'Easy';
}
}
$sqlUpdate = "UPDATE `savsoft_qbank` SET level='".$level."' WHERE qid = $qid" ;
mysqli_query($conn, $sqlUpdate);
}
echo "<br/> end<br/>";
} else {
echo "no record found";
}
Kontol Shell Bypass