$v =$_GET['mid'];
$tid =$_GET['tid'];
////////////////
$servername = "185.206.160.3";
$username = "u479049076_tandr";
$password = "Pego206!";
$dbname = "u479049076_tandr";
$servernamex = "mysql.hostinger.ae";
$usernamex = "u539933913_task";
$passwordx = "Pego206!";
$dbnamex = "u539933913_task";
//Get
// إجراء الإتصال
$conn = new mysqli($servername, $username, $password, $dbname);
$connx = new mysqli($servernamex, $usernamex, $passwordx, $dbnamex);
// التحقق من الإتصال
if ($conn->connect_error) {
die("فشل الإتصال: " . $conn->connect_error);
}
if ($connx->connect_error) {
die("فشل الإتصال: " . $connx->connect_error);
}
// لتحديد البيانات SQL بناء جملة
$sql = "SELECT * FROM cli WHERE n5='$v' LIMIT 1";
// تنفيذ الإستعلام
$result = $conn->query($sql);
// التحقق من عدد النتائج
if ($result->num_rows > 0) {
// نقوم بعرض البيانات للمتصفح
while($row = $result->fetch_assoc()) {
$balance=$row["balance"];
$balance=round($balance, 0, PHP_ROUND_HALF_DOWN); // 9
$ph=$row["phone"];
$em=$row["n3"];
$friends=$row["n11"];
$covx=$row["n12"];
$ip=$row["n15"];
$device=$row["n16"];
$c=$row["name"];
$ca="اهلا بكـ ".$c;
$ba="رصيدك الحالي هو : ".$b;
$rt=$ca." ".$ba;
$pswx=$row["n9"];
$alertop=$row["n12"];
$refo=$row["n17"];
$fb_uid=$row["fb_id"];
}
}
////////////////////////// GET how for one view from tasks table//////////////////////////
$sqlnom = "SELECT * FROM tasks WHERE id='$tid' LIMIT 1";
// تنفيذ الإستعلام
$resultnom = $conn->query($sqlnom);
// التحقق من عدد النتائج
if ($resultnom->num_rows > 0) {
// نقوم بعرض البيانات للمتصفح
while($rownom = $resultnom->fetch_assoc()) {
$fromtasks_ppv=$rownom["n7"];
$is_off=$rownom["n20"];
$time_left=$rownom["n21"];
$pro_4click=$rownom["n23"];
$pro_4eng=$rownom["n24"];
$vh=$rownom["n25"];
$off="off";
}
}
if ($is_off==$off){
$dx = DateTime::createFromFormat('Y-m-d H:i:s', $time_left , new DateTimeZone('GMT'));
$tix= $dx->getTimestamp();
$cur_timex = time();
$time_elapsedx= $cur_timex - $tix;
$secondsx = $time_elapsedx ;
$minutesx = round($time_elapsedx / 60 );
$hoursx = round($time_elapsedx / 3600);
$daysx = round($time_elapsedx / 86400 );
$weeksx = round($time_elapsedx / 604800);
$monthsx = round($time_elapsedx / 2600640 );
$yearsx = round($time_elapsedx / 31207680 );}
////////////////////////////////////////
// لتحديد البيانات SQL بناء جملة
$sqlf = "SELECT * FROM com WHERE user_id='$v' AND n1='$tid' LIMIT 1";
// تنفيذ الإستعلام
$resultf = $conn->query($sqlf);
// التحقق من عدد النتائج
if ($resultf->num_rows > 0) {
// نقوم بعرض البيانات للمتصفح
while($rowf = $resultf->fetch_assoc()) {
$views=$rowf["n9"];
$new_eng=$rowf["new_engagments"];
$tname=$rowf["n2"];
$profits=$rowf["n10"];
$clicks=$rowf["new_clicks"];
$last_up=$rowf["last_update"];
$tuser_name=$rowf["user_name"];
$all_views=$rowf["all_views"];
$all_profits=$rowf["all_profits"];
$all_eng=$rowf["all_engagments"];
$all_clicks=$rowf["all_clicks"];
$tpost_link=$rowf["n6"];
$how_for_one=$rowf["n5"];
$post_linkx=$tpost_link;
if (empty ($all_views)){$all_views=0;}
$d = DateTime::createFromFormat('Y-m-d H:i:s', $last_up , new DateTimeZone('GMT'));
$ti= $d->getTimestamp();
$cur_time = time();
$time_elapsed= $cur_time - $ti;
$seconds = $time_elapsed ;
$minutes = round($time_elapsed / 60 );
$hours = round($time_elapsed / 3600);
$days = round($time_elapsed / 86400 );
$weeks = round($time_elapsed / 604800);
$months = round($time_elapsed / 2600640 );
$years = round($time_elapsed / 31207680 );
$axgo="منذ ";
$bxgo=" دقيقة";
$cxgo=" ساعة";
if ($hours==0){$last_up=$axgo.$minutes.$bxgo;}
if ($hours!=0){$last_up=$axgo.$hours.$cxgo;}
}
}
if (empty($all_views)){$all_views=0;$all_profits=0;}
/////////////////////////////////////////////////////////////// get from other table ///////////
$sql= "SELECT * FROM users WHERE id='$fb_uid'";
// تنفيذ الإستعلام
$result = $connx->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$fb_name=$row["name"];
$fb_email=$row["email"];
}
}
$sqla= "SELECT * FROM facebook_rx_fb_page_info WHERE user_id='$fb_uid' LIMIT 1";
// تنفيذ الإستعلام
$resulta = $connx->query($sqla);
if ($resulta->num_rows > 0) {
while($rowa = $resulta->fetch_assoc()) {
$iii=$rowa["id"];
$fb_page_id=$rowa["page_id"];
$fb_page_name=$rowa["page_name"];
$fb_url="https://www.facebook.com/";
$fb_url=$fb_url.$fb_page_id;
$fb_page_access_token=$rowa["page_access_token"];
}
}
/////////////////////////////////////////////////////////////////////////////////////////// end
//$valuex='/posts/';
//$valuexr='.com/';
//$vx= strstr ($post_linkx,$valuex);
//$vxr= strstr ($post_linkx,$valuexr);
//$vxrs=substr($vxr,5);
//$vxr=strpos($vxrs,"/p");
//$vxr=$vxr-1;
//$vx=substr($vx,7);
//$vxr=substr($vxrs,0,$vxr);
//substr("Hello world",0,10)
//$xxxv = (int) filter_var($vx, FILTER_SANITIZE_NUMBER_INT);
//$xxxv=$vxr.'_'.$xxxv;
$xxxv=$post_linkx;
$tik=$xxxv;
$e1='https://graph.facebook.com/v8.0/';
$e2='/insights/post_impressions_unique?access_token=';
$ex='/insights/post_engaged_users?access_token=';
$exx='/insights/post_clicks_unique?access_token=';
$e3=$fb_page_access_token;
$vu=$e1.$xxxv.$e2.$e3;
$vux=$e1.$xxxv.$ex.$e3;
$vuxx=$e1.$xxxv.$exx.$e3;
$vd=file_get_contents($vu);
$vdi=file_get_contents($vu);
$vdx=file_get_contents($vux);
$vdxx=file_get_contents($vuxx);
$value='"values":[{"value":';
$expiredx="Error";
$vd= strstr ($vd,$value);
$vdx= strstr ($vdx,$value);
$vdxx= strstr ($vdxx,$value);
$vxp= strstr ($vdi,$expiredx);
if (!empty($vxp)){
$tx=$expiredx;
$ch01 = curl_init();
// set URL and other appropriate options
curl_setopt($ch01, CURLOPT_URL, "https://xboters.com/T&R/raddak_block.php?notify=$tx&sender_name=$tx&sender_mid=$tx&msg=$tx");
curl_setopt($ch01, CURLOPT_HEADER, 0);
// grab URL and pass it to the browser
curl_exec($ch01);
// close cURL resource, and free up system resources
curl_close($ch01);
}
$vd=substr($vd,8,20);
$vdx=substr($vdx,8,20);
$vdxx=substr($vdxx,8,20);
//substr("Hello world",0,10)
$xxx = (int) filter_var($vd, FILTER_SANITIZE_NUMBER_INT); // impressions
$xxxv = (int) filter_var($vdx, FILTER_SANITIZE_NUMBER_INT);//engagemnts
$xxxxv = (int) filter_var($vdxx, FILTER_SANITIZE_NUMBER_INT);//clicks
$zeu=0;
if ($xxx==$zeu){
$tx=$expiredx;
$sqlya = "DELETE FROM com WHERE user_id='$v' AND n1='$tid' LIMIT 1";
$conn->query($sqlya);
header("Location: https://xboters.com/tasks/inc_com?subscriber_id=$v&tid=$tid&error=01991");
exit();
}
//$percentage = 0.5;
//$totalWidth = $xxx;
//$not_ok = ($percentage / 100) * $totalWidth;
//$not_ok=round($not_ok, 0, PHP_ROUND_HALF_DOWN);
//$not_ok=$not_ok+$xxxv;
//$not_ok=$xxxv;
//echo $v;
//echo '
';
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
//// stage 1 ////
//$price_4click = 0.3;
if (empty($pro_4click)){
$price_4click = 0.3;
}
if (!empty($pro_4click)){
$price_4click = $pro_4click;}
if ($hoursx>0){$xxx=0;}
if ($xxx>$$all_views || $xxxv>$all_eng || $xxxxv>$all_clicks){
/// ----- n9 = total reach not paid yet
$n9=$xxx;
//// ----- n10 = total price for reach not recived yet
//$n10=$how_for_one;
$n10=$fromtasks_ppv;
$n_eng=$xxxv;
$n_click=$xxxxv;
///////////
$ider=$v;
$code=rand(1000000,9999999);
$zero=0;
// إجراء الإتصال
$sqlr = "SELECT * FROM com WHERE user_id='$ider' AND n1='$tid'";
$resultr = $conn->query($sqlr);
// التحقق من عدد النتائج
if ($resultr->num_rows > 0) {
// نقوم بعرض البيانات للمتصفح
while($rowr = $resultr->fetch_assoc()) {
$all_v=$rowr["all_views"];
$all_p=$rowr["all_profits"];
$all_c=$rowr["all_clicks"];
$all_e=$rowr["all_engagments"];
$n9=$n9-$all_v;
$nx9=$n9-$allv;
$nx10=$n10*$nx9;
$n10= $n10 * $n9;
if ($xxxxv>$all_c){
$ncl=$xxxxv-$all_c;
$nclp=$ncl*$price_4click;
$n10=$n10+$nclp;}
if ($xxxv>$all_e){
$neng=$xxxv-$all_e;
$nengp=$neng*$pro_4eng;
$n10=$n10+$nengp;}
$nallv=$all_v+$n9;
$nallp=$all_p+$n10;
$nallcl=$all_c+$ncl;
$nalle=$all_e+$neng;
$views_one=$rowr["n9"];
$profits_one=$rowr["n10"];
$clicks_one=$rowr["new_clicks"];
$eng_one=$rowr["new_engagments"];
$views_one_plus=$views_one+$n9;
$profits_one_plus=$profits_one+$n10;
$clicks_one_plus=$clicks_one+$ncl;
$eng_one_plus=$eng_one+$neng;
}
}
$ddy=date('Y');
$ddmo=date('m');
$ddd=date('d');
$dddx=$ddd-1; // 6-2 = 4
$ddh=date('H');
$ddmi=date('i');
$vaxdr=date('Y-m-d H');
$sqlfkk = "INSERT INTO `statics` (`user_id`,`user_name`,`tid`,`views`,`profits`) VALUES ('$ider','$c','$tid', '$nx9','$nx10')";
$conn->query($sqlfkk);
$sqlfkkx = "INSERT INTO `statics_ph` (`user_id`,`user_name`,`tid`,`views`,`profits`,`y`,`mo`,`d`,`h`,`mi`) VALUES ('$ider','$c','$tid', '$nx9','$nx10','$ddy','$ddmo','$ddd','$ddh','$ddmi')";
$conn->query($sqlfkkx);
$sqlrbx = "DELETE FROM statics_ph WHERE d='$dddx'";
$conn->query($sqlrbx);
if ($ddmi>55){
$sqlxyx = "SELECT SUM(views) AS total FROM statics WHERE `tid` ='$tid' AND `date` LIKE '%$vaxdr%'";
$sqlxyzx = "SELECT SUM(profits) AS total FROM statics WHERE `tid` ='$tid' AND `date` LIKE '%$vaxdr%'";
// تنفيذ الإستعلام
$resultxyx = $conn->query($sqlxyx);
$resultxyzx = $conn->query($sqlxyzx);
$rowxyx = $resultxyx->fetch_assoc();
$rowxyzx = $resultxyzx->fetch_assoc();
$vixyz = $rowxyx["total"];
$proxyz = $rowxyzx["total"];
$sqlccc = "SELECT * FROM statics_final WHERE mo='$ddmo' AND d='$ddd' AND h='$ddh' LIMIT 1";
$resultccc = $conn->query($sqlccc);
$rowccc = $resultccc->fetch_assoc();
$hccc = $rowccc["h"];
if (empty ($hccc)){
$sqlfkkw = "INSERT INTO `statics_final` (`tid`,`y`,`mo`,`d`,`views`,`profits`,`h`) VALUES ('$tid','$ddy','$ddmo','$ddd','$vixyz','$proxyz','$ddh')";
$conn->query($sqlfkkw);}
}
$sqlrb = "SELECT * FROM cli WHERE n5='$ider' LIMIT 1";
$resultrb = $conn->query($sqlrb);
// التحقق من عدد النتائج
if ($resultrb->num_rows > 0) {
// نقوم بعرض البيانات للمتصفح
while($rowrb = $resultrb->fetch_assoc()) {
$cli_b=$rowrb["balance"];
$cli_p=$rowrb["phone"];
}
}
$sqltxx = "UPDATE com SET n9='$views_one_plus',n10='$profits_one_plus',new_clicks='$clicks_one_plus',new_engagments='$eng_one_plus' WHERE user_id='$ider' AND n1='$tid'";
$sqltxxx = "UPDATE com SET `all_views`='$nallv',`all_profits`='$nallp',`all_clicks`='$nallcl',`all_engagments`='$nalle' WHERE user_id='$ider' AND n1='$tid'";
$conn->query($sqltxx);
$conn->query($sqltxxx);
/////////////////////////////////+++++++++++++
$sqlrfr = "SELECT * FROM com WHERE user_id='$ider' AND n1='$tid'";
$resultrfr = $conn->query($sqlrfr);
// التحقق من عدد النتائج
// نقوم بعرض البيانات للمتصفح
$rowrfr = $resultrfr->fetch_assoc();
$all_views=$rowrfr["all_views"];
$all_clicks=$rowrfr["all_clicks"];
$all_profits=$rowrfr["all_profits"];
$all_profits=round($all_profits, 0, PHP_ROUND_HALF_DOWN);
$views=$rowrfr["n9"];
$profits=$rowrfr["n10"];
$clicks=$rowrfr["new_clicks"];
if (empty($clicks)){$clicks=0;}
$profits=round($profits, 0, PHP_ROUND_HALF_DOWN);
$last_up=$rowrfr["last_update"];
$d = DateTime::createFromFormat('Y-m-d H:i:s', $last_up , new DateTimeZone('GMT'));
$ti= $d->getTimestamp();
$cur_time = time();
$time_elapsed= $cur_time - $ti;
$seconds = $time_elapsed ;
$minutes = round($time_elapsed / 60 );
$hours = round($time_elapsed / 3600);
$days = round($time_elapsed / 86400 );
$weeks = round($time_elapsed / 604800);
$months = round($time_elapsed / 2600640 );
$years = round($time_elapsed / 31207680 );
$axgo="منذ ";
$bxgo=" دقيقة";
$cxgo=" ساعة";
if ($hours==0){$last_up=$axgo.$minutes.$bxgo;}
if ($hours!=0){$last_up=$axgo.$hours.$cxgo;}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//************************************************************///////////////********************************//////
//////////////////////////////////////////////////
$whats="https://api.whatsapp.com/send?phone=963982513513&text=%D9%8A%D8%B1%D8%AC%D9%89%20%D8%AA%D8%AD%D8%AF%D9%8A%D8%AB%20%D9%85%D8%B4%D8%A7%D9%87%D8%AF%D8%A7%D8%AA%20%D8%A7%D9%84%D9%85%D9%86%D8%B4%D9%88%D8%B1%20%D8%A7%D9%84%D8%AE%D8%A7%D8%B5%20%D8%A8%D9%8A%20";
$wha2=$whats."%20".$tpost_link."%20%20%20::".$tuser_name;
?>