"; //$turnoffsql="UPDATE `se_users` SET `se_users`.`user_pdp_evc` = 0 WHERE `se_users`.`user_email` = '".$u_mail."' Limit 1"; //$turnoffresult= mysql_query($turnoffsql) or $em=$em.mysql_error(); //echo $em." any error
"; //echo $turnoffsql."
"; //} //exit(); function getUrlContent($url){ $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5); curl_setopt($ch, CURLOPT_TIMEOUT, 5); $data = curl_exec($ch); $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); return ($httpcode>=200 && $httpcode<300) ? $data : false; } function is_temp_mail($mail, $dlist) { $mail_domains_ko = $dlist; foreach($mail_domains_ko as $ko_mail) { list(, $mail_domain) = explode('@', $mail); if(strcasecmp($mail_domain, trim($ko_mail)) == 0) { return TRUE; } } return FALSE; } function time_diff_conv($start, $s) { $t = array( //suffixes 'd' => 86400, 'h' => 3600, 'm' => 60, ); $s = abs($s - $start); foreach($t as $key => &$val) { $$key = floor($s/$val); $s -= ($$key*$val); $string .= ($$key==0) ? '' : $$key . "$key "; } return $string . $s. 's'; } function is_int_val($data) { if (is_int($data) === true) return true; elseif (is_string($data) === true && is_numeric($data) === true) { return (strpos($data, '.') === false); } return false; } //Written by Philip Poremba 05/02/2012 $dbcon=dbconnect2(); // connect to bateworld db $domail=0; if(isset($_POST["mailsub"])) { if($_POST["mailsub"]==1) { $thesql="SELECT `mail_accounts`.`username`, `mail_accounts`.`password`, `mail_accounts`.`host`, `mail_accounts`.`port` FROM `mail_accounts` WHERE `mail_accounts`.`maid`= 1"; $theresult=mysql_query($thesql) or $em=$em.mysql_error(); $m=mysql_fetch_assoc($theresult); $smtpusername=$m["username"]; $smtppassword=$m["password"]; $domail=1; $thetemplate=file_get_contents ("http://bateworld.com/mailservices/email/cybersocket-award.html"); } } $em=""; $_SESSION["user_uri"]="/mailservices/bateworld/users.php"; $_SESSION["pagename"]="B8World Users"; $_SESSION["the_section_location"] = "/mailservices/bateworld/users.php"; $_SESSION["the_section_container"]="section_content"; $_SESSION["the_tab"]="one"; $_SESSION["se_user_id"]=""; if(!isset($_SESSION["se_user_limit"])) {$_SESSION["se_user_limit"]=20;} if(!isset($_SESSION["se_user_enabled"])) {$_SESSION["se_user_enabled"]="";} if(!isset($_SESSION["se_user_uid"])) {$_SESSION["se_user_uid"]="";} if(!isset($_SESSION["user_level_id"])) {$_SESSION["user_level_id"]="";} if(!isset($_SESSION["se_user_offset"])) {$_SESSION["se_user_offset"]=0;} if(!isset($_SESSION["se_user_searchstring"])){$_SESSION["se_user_searchstring"]="";} if(!isset($_SESSION["se_user_inactive"])){$_SESSION["se_user_inactive"]="";} if(!isset($_SESSION["se_user_modifyer"])){$_SESSION["se_user_modifyer"]="lt";} if(!isset($_SESSION["se_user_evc"])){$_SESSION["se_user_evc"]="";}; if(!isset($_SESSION["se_user_username"])){$_SESSION["se_user_username"]="";} if(!isset($_SESSION["ip_lastactive"])){$_SESSION["ip_lastactive"]="";} if(isset($_POST["modifyer"])){$_SESSION["se_user_modifyer"]=$_POST["modifyer"];} if($domail==0){ if(isset($_POST["gosearch"])){$_SESSION["se_user_offset"]=0;} if(isset($offset)){$_SESSION["se_user_offset"]=$offset;} if(isset($_POST["limit"])){$_SESSION["se_user_limit"]=$_POST["limit"];$_SESSION["se_user_offset"]=0;} } $limit=$_SESSION["se_user_limit"]; $offset=$_SESSION["se_user_offset"]; $conda=" WHERE 0<1 "; //AND (floor((`se_semods_userplans`.`userplan_expiredate` - UNIX_TIMESTAMP()) / (60*60*24))) > 0 and (floor((`se_semods_userplans`.`userplan_expiredate` - UNIX_TIMESTAMP()) / (60*60*24))) < 5 AND `se_semods_userplans`.`userplan_plan_id` <> 4 AND `se_users`.`user_enabled` = 1 if(isset($_POST["searchstring"])) { $_SESSION["se_user_searchstring"]=$_POST["searchstring"]; } if($_SESSION["se_user_searchstring"] != "") { $condb=" AND user_email like '%".$_SESSION["se_user_searchstring"]."%'"; } else { $condb=""; } if(isset($_POST["inactive"])) { if(is_int_val($_POST["inactive"])) { $_SESSION["se_user_inactive"]=$_POST["inactive"]; } else{ $_SESSION["se_user_inactive"]=""; } } if($_SESSION["se_user_inactive"] != "") { if($_SESSION["se_user_modifyer"]=="gt") { $condc=" AND (floor((UNIX_TIMESTAMP()-`se_users`.`user_lastlogindate`) / (60*60*24))) > ".$_SESSION["se_user_inactive"].""; } elseif ($_SESSION["se_user_modifyer"]=="lt") { $condc=" AND (floor((UNIX_TIMESTAMP()-`se_users`.`user_lastlogindate`) / (60*60*24))) < ".$_SESSION["se_user_inactive"].""; } elseif ($_SESSION["se_user_modifyer"]=="eq") { $condc=" AND (floor((UNIX_TIMESTAMP()-`se_users`.`user_lastlogindate`) / (60*60*24))) = ".$_SESSION["se_user_inactive"].""; } } else { $condc=""; } if(isset($_POST["evc"])) { if($_POST["evc"]=="") { $_SESSION["se_user_evc"]=""; } else { $_SESSION["se_user_evc"]=$_POST["evc"]; } } if($_SESSION["se_user_evc"]=="") { $condd=""; } else { if($_SESSION["se_user_evc"]==7){ $condd=" AND (`se_users`.`user_pdp_evc`= 1 OR `se_users`.`user_pdp_evc` = 3 OR `se_users`.`user_pdp_evc` = 5) "; } else { $condd=" AND `se_users`.`user_pdp_evc` = ".$_SESSION["se_user_evc"]." "; } } if(isset($_POST["uid"])) { $_SESSION["se_user_uid"]=$_POST["uid"]; } if($_SESSION["se_user_uid"] != "") { $conde=" AND `se_users`.`user_id` = ".$_SESSION["se_user_uid"]." "; } else { $conde=""; } if(isset($_POST["ulid"])) { $_SESSION["user_level_id"]=$_POST["ulid"]; } if($_SESSION["user_level_id"] != "") { if($_SESSION["user_level_id"] < 6) { $condf=" AND `se_users`.`user_level_id` = ".$_SESSION["user_level_id"]." "; } else { $condf=" AND ((floor((UNIX_TIMESTAMP()-`se_users`.`user_signupdate`) / (60*60*24))) <= 7) AND `se_users`.`user_level_id` = 2"; } } else { $condf=""; } if(isset($_POST["user_username"])) { $_SESSION["se_user_username"]=$_POST["user_username"]; } if($_SESSION["se_user_username"] != "") { $condg=" AND `se_users`.`user_username` LIKE '%".$_SESSION["se_user_username"]."%' "; } else { $condg=""; } if(isset($_POST["user_enabled"])) { $_SESSION["se_user_enabled"]=$_POST["user_enabled"]; } if($_SESSION["se_user_enabled"] != "") { $condh=" AND `se_users`.`user_enabled` = ".$_SESSION["se_user_enabled"]." "; } else { $condh=""; } if(isset($_POST["ip_lastactive"])) { $_SESSION["ip_lastactive"]=$_POST["ip_lastactive"]; } if($_SESSION["ip_lastactive"] != "") { $condi=" AND `se_users`.`user_ip_lastactive` LIKE '%".$_SESSION["ip_lastactive"]."%' "; } else { $condi=""; } $condj=" AND (`se_users`.`user_lastlogindate` - `se_users`.`user_signupdate`) < 86400"; $condj=""; $condx=" AND (floor((`se_semods_userplans`.`userplan_expiredate` - UNIX_TIMESTAMP()) / (60*60*24))) < 0"; $condx=""; $condz=" AND ((floor((UNIX_TIMESTAMP()-`se_users`.`user_signupdate`) / (60*60*24))) >= 7) AND `se_users`.`user_email` not like '%.ca%' "; $condz=""; $condx=" AND floor(DATEDIFF(NOW(),`se_profilevalues`.`profilevalue_4`) / 365.25) > 80"; $condx=" AND `se_users`.`user_pdp_optout` = 1"; $condx=""; $sql="SELECT `se_users`.`user_id`, `se_users`.`user_level_id`, `se_users`.`user_email`, `se_users`.`user_newemail`, `se_users`.`user_fname`, `se_users`.`user_lname`, `se_users`.`user_username`, `se_users`.`user_language_id`, `se_users`.`user_signupdate`, `se_users`.`user_lastlogindate`, `se_users`.`user_lastactive`, `se_users`.`user_ip_lastactive`, `se_users`.`user_privacy`, `se_users`.`user_enabled`, (floor((UNIX_TIMESTAMP()-`se_users`.`user_lastlogindate`) / (60*60*24))) AS `daysinactive`, (floor((UNIX_TIMESTAMP()-`se_users`.`user_signupdate`) / (60*60*24))) AS `newmembers`, `se_users`.`user_lastlogindate` - `se_users`.`user_signupdate` AS `oneday`, `se_users`.`user_hasnotifys`, `se_users`.`user_pdp_evc`, `se_users`.`user_pdp_optout`, `se_profilevalues`.`profilevalue_4` AS `birthday`, `se_semods_userplans`.`userplan_expiredate`, (floor((`se_semods_userplans`.`userplan_expiredate` - UNIX_TIMESTAMP()) / (60*60*24))) AS `expiredays`, `se_semods_userplans`.`userplan_plan_id`, floor((DATEDIFF( NOW(),`se_profilevalues`.`profilevalue_4`) / 365.25)) AS `Age` FROM `se_users` Left Outer Join `se_profilevalues` ON `se_profilevalues`.`profilevalue_user_id` = `se_users`.`user_id` Left Outer Join `se_semods_userplans` ON `se_semods_userplans`.`userplan_user_id` = `se_users`.`user_id` ".$conda.$condb.$condc.$condd.$conde.$condf.$condg.$condh.$condi.$condj.$condx." ORDER BY `se_users`.`user_id` ASC LIMIT ".$limit." OFFSET ".$offset; $result= mysql_query($sql) or $em=$em.mysql_error(); echo $sql; echo $em; $sql2="SELECT count(`se_users`.`user_id`) AS cuid FROM `se_users` Left Outer Join `se_profilevalues` ON `se_profilevalues`.`profilevalue_user_id` = `se_users`.`user_id` Left Outer Join `se_semods_userplans` ON `se_semods_userplans`.`userplan_user_id` = `se_users`.`user_id` ".$conda.$condb.$condc.$condd.$conde.$condf.$condg.$condh.$condi.$condj.$condx; $rcount=mysql_query($sql2); $thecount = mysql_result($rcount,0); mysql_free_result($rcount); ?>
" onfocus="clearinput('search','se_user_searchstring');" onblur="resetinput('search','se_user_searchstring');" onkeypress="submitenter()" /> " size="12" maxlength="32" /> " size="1" maxlength="4" style="text-align:right;" /> " size="10" maxlength="64" style="text-align:right;" />
"; $account_on=""; if($row["user_enabled"]==1){$account_on=" checked=\"checked\"";} echo ""; $checked=""; echo ""; if($row["user_pdp_evc"]==5) { //$sqlupevc="UPDATE se_users SET user_pdp_evc = 3 WHERE user_email = '".$row["user_email"]."'"; // $qupevc=mysql_query($sqlupevc) or $em=$em.mysql_error(); } if($row["user_pdp_optout"] == 0){$optin="Yes";} else {$optin="No";} echo ""; echo ""; if(is_temp_mail($row["user_email"], $_SESSION["dealist"])){ $tempemail="TEMP"; echo ""; //$sqlupevc="UPDATE se_users SET user_pdp_evc = 0 WHERE user_email = '".$row["user_email"]."'"; //$qupevc=mysql_query($sqlupevc) or $em=$em.mysql_error(); } else { $tempemail="NOT TEMP"; echo ""; } echo ""; $signup=date("m.d.y",$row["user_signupdate"]); echo ""; $lastlogin=date("m.d.y",$row["user_lastlogindate"]); $diff=abs(time() - $row["user_lastlogindate"]); //$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); echo ""; echo ""; if($row["daysinactive"] > 365) { //$sqlupinactive="UPDATE se_users SET user_enabled = 0, user_pdp_evc = 0 WHERE user_id = ".$row["user_id"]." "; //$qupinactive=mysql_query($sqlupinactive) or $em=$em.mysql_error(); } $mp=""; if($row["user_level_id"]==1) { $mp="Basic"; } if($row["user_level_id"]==2) { $mp="Premium"; $expires_days=$row["userplan_expiredate"] - time(); //$expires_days = floor(($expires_days - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); } if($row["user_level_id"]==5) { $mp="New Basic"; } $expires=date("m.d.Y",$row["userplan_expiredate"]); echo ""; $bday=strtotime($row["birthday"]); $bm=date("m",$bday); $bd=date("d",$bday); $m=date("m",time()); $d=date("d",time()); if($bd!=$d && $bm!=$m) { } echo ""; echo ''; //echo ''; $smtp_validate=""; if($row["user_enabled"]<=0) { $evalid=getUrlContent("http://apilayer.net/api/check?access_key=03393a1af77497a8aaef46f4786c5a4f&email=".$row["user_email"].""); $obj = json_decode($evalid); if($obj->{'smtp_check'} === false) { $smtp_validate="NO"; } else { $smtp_validate="YES"; } } echo "'; echo ""; } mysql_free_result($result); if($rownum==0) { echo ""; echo ""; echo ""; } ?>
On/Off EV2C OPTIN Username Email ID Sign Up Last Login Inactive Level Birthday ip Address
".$row["user_pdp_evc"]."".$optin."".$row["user_username"]."".$row["user_email"]." ".$tempemail."".$row["user_email"]." ".$tempemail."".$row["user_id"]."".$signup."".$lastlogin."".$row["daysinactive"]." days".$mp." ".$row["user_level_id"]."".$row["birthday"]."---".$row["Age"].""; echo "'.$row["user_ip_lastactive"].''.$expires.'sssssss'.$row["expiredays"].'"; if($smtp_validate=="YES") { echo "Valid Email"; } else { echo "not valid"; } $themailsent=""; if($domail==1) { if($row["user_enabled"]==1) { if($row["user_pdp_evc"]== 1 || $row["user_pdp_evc"] == 3 || $row["user_pdp_evc"] == 5) { if($optin=="Yes") { if(strpos($row["user_email"], "verizon")===false && strpos($row["user_email"], "comcast")===false && strpos($row["user_email"], "aol")===false && strpos($row["user_email"], "hotmail")===false ) { ini_set('display_errors','On'); include "/home/bateworldcom/public_html/mailservices/bateworld/mail/cybersocket_mail.php"; echo "".$themailsent." "; } else { echo "verizon"; } } } } } //rights will determine this echo $row["user_pdp_optout"]; echo "---"; echo " "; echo 'Account Settings
No Records Returned.