ikan Uploader :
Directory : /var/www/html/chalkbank.com/cronjobs/
Upload File : |
| Current File : /var/www/html/chalkbank.com/cronjobs/assignQuizCron.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();
}
//return false;
$new_time = time();
$group_id = '37';
$admin_id = '9074';
$quiz_id = '65';
$assigned_group_id = '72';
if($_GET['gid']>0){
$sql = "select * from savsoft_users where gid ='".$_GET['gid']."' limit 0,1000";
} else if($_GET['uid']) {
$sql = "select * from savsoft_users where uid ='".$_GET['uid']."' limit 0,10";
} else {
$sql = "select * from savsoft_users where gid IN(35,40,41,42,43,44,50,51) limit 0,1000";
}
return false;
//$sql = "select * from savsoft_users where gid IN(36) limit 0,500";
//$sql = "select * from savsoft_users where uid='8309' limit 0,100";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo ("total count - " . mysqli_num_rows($result) . "<br/>");
$k=0;
while ($row = mysqli_fetch_assoc($result))
{
$uid = $row['uid'];
$gid = $assigned_group_id;
$admin_id = $admin_id;
$queryqb = mysqli_query($conn,"select * from savsoft_quiz_registration where uid='$uid' AND qid = '".$quiz_id."' AND gid='".$assigned_group_id."'");
$results = mysqli_fetch_assoc($queryqb);
if(empty($results))
{
$sqlIns = "INSERT INTO `savsoft_quiz_registration` SET uid='".$uid."',gid='".$assigned_group_id."', admin_id='".$admin_id."',qid='".$quiz_id."',created='".date('Y-m-d H:i:s')."',modified_on='".date('Y-m-d H:i:s')."'";
mysqli_query($conn, $sqlIns);
$k++;
}
}
echo "<br/> $k end<br/>";
} else {
echo "no record found";
}
Kontol Shell Bypass