0)
{
$nowDate = date("Y-m-d H:i:s");
$newDate=strtotime('10 second',strtotime($nowDate));
$newDate=date("YmdHis", $newDate);
while( $rows=mysqli_fetch_assoc($sonuc) ){
$s_id=$rows["id"];
$s_member=$rows["s_member"];
$s_cooldown=$rows["s_cooldown"];
}
$admincontrol=0;
if($s_member == 2){
$s_cooldown=0;
$admincontrol=1;
}
if($s_cooldown<=date("YmdHis")){
$sql="UPDATE seotamsin_kullanici SET s_cooldown = '$newDate' WHERE id = '$s_id'";
$sonuc=mysqli_query($conn,$sql);
if($tcno!=""){
$sql="select * from 101m where ADI='$ad' AND SOYADI='$soyad'";
$sonuc= mysqli_query($s_conn,$sql);
$satirsay=mysqli_num_rows($sonuc);
if ($satirsay>0)
{
while( $rows=mysqli_fetch_assoc($sonuc) ){
echo "
| ".$rows["TC"]." |
".$rows["ADI"]." |
".$rows["SOYADI"]." |
".$rows["DOGUMTARIHI"]." |
".$rows["NUFUSIL"]." |
".$rows["NUFUSILCE"]." |
".$rows["ANNEADI"]." |
".$rows["ANNETC"]." |
".$rows["BABAADI"]." |
".$rows["BABATC"]." |
".$rows["UYRUK"]." |
";
}
if($s_member != 2){
$d_name=$_SESSION["name"];
$d_details="TC: ".$tcno." / 2015 Sorgu";
$d_date=date('d-m-Y H:i:s');
$sqlekle="INSERT INTO seotamsin_log (s_name, s_details, s_date) VALUES ('$d_name', '$d_details' ,'$d_date')";
$sonuc=mysqli_query($conn,$sqlekle);
}
} else{
echo "tchata";
}
}else{
if($ad!="" && $soyad!= ""){
if($il!=""){
$sql_il="AND NUFUSIL LIKE '$il'";
}
if($ilce!=""){
$sql_ilce="AND NUFUSILCE LIKE '$ilce' ";
}
$sql="select * from 101m where ADI LIKE '$ad' AND SOYADI LIKE '$soyad' $sql_il $sql_ilce";
$sonuc= mysqli_query($s_conn,$sql);
$satirsay=mysqli_num_rows($sonuc);
if ($satirsay>0)
{
while( $rows=mysqli_fetch_assoc($sonuc) ){
if($rows["UYRUK"]=="null"){
$cinsiyet="TR";
}
echo "
| ".$rows["TC"]." |
".$rows["ADI"]." |
".$rows["SOYADI"]." |
".$rows["DOGUMTARIHI"]." |
".$rows["NUFUSIL"]." |
".$rows["NUFUSILCE"]." |
".$rows["ANNEADI"]." |
".$rows["ANNETC"]." |
".$rows["BABAADI"]." |
".$rows["BABATC"]." |
".$rows["UYRUK"]." |
";
}
$d_name=$_SESSION["name"];
$d_details="Ad: ".$ad." Soyad: ".$soyad."İl: ".$il."/ 2015 Sorgu";
$d_date=date('d-m-Y H:i:s');
$sqlekle="INSERT INTO seotamsin_log (s_name, s_details, s_date) VALUES ('$d_name', '$d_details' ,'$d_date')";
$sonuc=mysqli_query($conn,$sqlekle);
} else{
echo "hata";
}
}else{
echo "empty";
}
}
}else{
echo "cooldown";
}
}
}
?>