";
//$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);
?>