<?php
$dt=signin($_POST);
echo json_encode($dt);

function signin($js){
  global $ar,$db;
  $dt=array();
  //$dt['js']=$js;
  
  $email2 =$js['email'];  
  $em=explode('@',$email2);
  $m1 = preg_replace("/[^A-Za-z0-9]/","",$em[0]);
  
  if($m1!='' && $em[1]!='') {
    $email=$m1."@".$em[1];
    //cek email dobel
    $sql9="SELECT id,nama_member from `member` where email='".$email."'";
    //$dt['sql'][0]=$sql9;
    
    $res9=mysqli_query($db,$sql9);
    if(mysqli_num_rows($res9)==0) {
      $dt['error']=true;
      $dt['message']="Email '".$email."' tidak terdaftar";    
      //$dt['info'][0]="Email '".$email."' belum terdaftar";    
    } else {
      //$dt['message']="Email '".$email."' belum terdaftar";    
      //cek username
      if(mysqli_num_rows($res9)==1) {

        //$dt['info'][1]="Email '".$email."' terdaftar";    

        $sql8="SELECT id,uid,nama_member,first_name,last_name,tanggal_daftar,confirm_email,confirm_token,gelar,no_telp,sex,dob,alamat,rt,rw,kodepos,kecamatan,kabupaten,email,img from `member` where `email`='".$email."' and `password`='".md5($js['password'])."' and `acc`=1";
        //$dt['sql'][1]=$sql8;
        $res8=mysqli_query($db,$sql8);
        if(mysqli_num_rows($res8)==0) {
          $dt['message']="Email '".$email."' benar, password salah";    
          //$dt['info'][2]="Email '".$email."' terdaftar, password salah";    
          $dt['error']=true;
        } else {
          $r8=mysqli_fetch_assoc($res8);
          $dt['success']=true;
          $dt['member']['data']=$r8;
          $dt['member']['data']['image']=$ar['img_url']."".$r8['img'];
          
          $sql9="SELECT * from `files` where modul='member' and item_id=".$r8['id']." order by id desc";
          $res9=mysqli_query($db,$sql9);
          if(mysqli_num_rows($res9)>0) {
            $c=0;
            while($r9=mysqli_fetch_assoc($res9)) {
              //$dt['img']['data'][$c]['id']=$r9['id'];
              $dt['img']['data'][$c]['url']['small']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/small/".$r9['url'];
              $dt['img']['data'][$c]['url']['medium']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/medium/".$r9['url'];
              $dt['img']['data'][$c]['url']['big']=$ar['img_url']."".$r9['modul']."/".$r9['path']."/".$r9['seq']."/image/big/".$r9['url'];
              $c++;
            }
          } else {
              $dt['img']['data'][0]['url']['small']=$ar['img_url']."member/user.png";
              $dt['img']['data'][0]['url']['medium']=$ar['img_url']."member/user.png";
              $dt['img']['data'][0]['url']['big']=$ar['img_url']."member/user.png";
          }
          $dt['img']['count']=$c;  
        }
      }
    }
  }
  return $dt;
  $db->close();
}

?>