require_once("../php_fej.php");
$ip=@trim(addslashes($REMOTE_ADDR));
$ref=@strtolower($HTTP_REFERER);
$index="";
$hiba="";
$uzenet="";
$mai_datum=date("Y.m.d");
$ekod=@trim(htmlspecialchars(strip_tags($ekod)));
$rows=mysqli_query($con, "SELECT id, erv_dat FROM ".$tag."ugyfel WHERE (bem_dat>='".$mai_datum."' OR fpws!='') AND torolt='N' AND ek_mail='I' AND email='".@trim(strtolower(htmlspecialchars($ekod)))."';");
if(@round(mysqli_num_rows($rows))>0){
$row=@mysqli_fetch_object($rows);
$index="ok";
$erv_dat=@trim($row->erv_dat);
$log_uid=@round($row->id);
}else{
$hiba="Hibás e-mail cím, belépés csak tagjaink részére megengedett!
";
//$ekod="";
$index="";
}
?>
$mai_datum=date("Y.m.d");
$rows=mysqli_query($con, "SELECT COUNT(ado) as mind FROM ".$tag."ugyfel WHERE torolt='N' AND _mod='R' AND fpws!='' AND erv_dat>'".$mai_datum."' AND fc_id<1;");
$row=@mysqli_fetch_object($rows);
$t_ossz=@round($row->mind);
@mysqli_free_result($rows);
$rows=mysqli_query($con, "SELECT SUM(osszeg) as ossz FROM ".$tag."szamlak as sz LEFT JOIN ".$tag."ugyfel as uf ON ceg_ado=c_ado AND tart_ado=ado WHERE sz.torolt='N' AND sz.publikus='I' AND uf.torolt='N' AND uf.publikus='I' GROUP BY uf.publikus;");
$row=@mysqli_fetch_object($rows);
$sz_ossz=@number_format($row->ossz,0,'',' ');
?>