<?
?>
<div class="denhaber">

<?
$addrr=$_SERVER['REQUEST_URI'];

include("lotohdata.php");


mysql_connect("localhost","$db","Sanane777") or die ("MySQL'e bağlanamadım");
mysql_select_db("$tb") or die ("MySQL'de veritabanını bulamadım");
$file="haberler1";

mysql_query("SET NAMES 'UTF8'");

if (stripos($addrr,"sayisal-loto")){
	
$tablo="SELECT * FROM $file where kategori='sayisal' or kategori='topic' ORDER BY numara";
$sorgu=mysql_query($tablo);
$sayia=mysql_num_rows($sorgu);
$bilgi=mysql_num_rows($sorgu);
}

else if (stripos($addrr,"sans-topu")){
	
	$tablo="SELECT * FROM $file where kategori='sanstopu' or kategori='topic' ORDER BY numara";
$sorgu=mysql_query($tablo);
$sayia=mysql_num_rows($sorgu);
$bilgi=mysql_num_rows($sorgu);
}

else if (stripos($addrr,"super-loto")){
	
	$tablo="SELECT * FROM $file where kategori='super' or kategori='topic' ORDER BY numara";
$sorgu=mysql_query($tablo);
$sayia=mysql_num_rows($sorgu);
$bilgi=mysql_num_rows($sorgu);
}

else if (stripos($addrr,"on-numara")){
	
	$tablo="SELECT * FROM $file where kategori='on' or kategori='topic' ORDER BY numara";
$sorgu=mysql_query($tablo);
$sayia=mysql_num_rows($sorgu);
$bilgi=mysql_num_rows($sorgu);
}

else{
$tablo="SELECT * FROM $file ORDER BY numara";
$sorgu=mysql_query($tablo);
$sayia=mysql_num_rows($sorgu);
$bilgi=mysql_num_rows($sorgu);
}

$sayacajax=1;
if ($sayia<14){
$sayac=$sayia-1;
$sayia=-1;
}
else{
$sayac=$sayia-1;
$sayia=$sayac-15;
}
$tp="0";
while($sayac > $sayia){
$no = array (
3=> @mysql_result($sorgu, $sayac, "numara"),
);
	if ($numara==$no[3]){$sayac--;$sayia--;}
$no = array (
1=> @mysql_result($sorgu, $sayac, "tarihsaat"),
2=> @mysql_result($sorgu, $sayac, "baslik"),
3=> @mysql_result($sorgu, $sayac, "numara"),
4=> @mysql_result($sorgu, $sayac, "baslika"),
);

if ($tp=="0"){

}
$ack1=$no[2];


$ack1 = ereg_replace(",","",$ack1);
$ack1 = ereg_replace("ş","s",$ack1);
$ack1 = ereg_replace("ğ","g",$ack1);
$ack1 = ereg_replace("ı","i",$ack1);
$ack1 = ereg_replace("ü","u",$ack1);
$ack1 = ereg_replace("ö","o",$ack1);
$ack1 = ereg_replace("ç","c",$ack1);
$ack1 = ereg_replace("Ş","S",$ack1);
$ack1 = ereg_replace("О","G",$ack1);
$ack1 = ereg_replace("İ","I",$ack1);
$ack1 = ereg_replace("Ü","U",$ack1);
$ack1 = ereg_replace("Ö","O",$ack1);
$ack1 = ereg_replace("Ç","C",$ack1);


$bolun=split(" ",$ack1);
$ack1="";



for ($sayy = 0; $sayy < 6; $sayy++)
{

if ($sayy==0){$ack1=$bolun[$sayy];}

else{$ack1="$ack1-$bolun[$sayy]";}

}




$gecdos="B.jpg";
$gecdos1="A.jpg";
$dosya="$ddizin$no[3]$gecdos";

if (file_exists("$dosya"))
{

$dosya="/haberresim/$no[3]$gecdos";
}
else{

$dosya1="/home/lotom/public_html/haberresim/$no[3]$gecdos1";
$dosya="/home/lotom/public_html/haberresim/$no[3]$gecdos";
header('Content-Type: image/jpeg');

$yukseklik = 136;
$genislik = 220;
$hedef = imagecreatetruecolor($genislik, $yukseklik);
$kaynak = imagecreatefromjpeg($dosya1);
list($mevcutGenislik, $mevcutYukseklik) = getimagesize($dosya1);
imagecopyresampled($hedef, $kaynak, 0, 0, 0, 0, $genislik, $yukseklik, $mevcutGenislik, $mevcutYukseklik);
imagejpeg($hedef, $dosya, 70);
 
}




?>

<div class="denhabered">
<div class="denhabered1"><p><a title="<? echo $no[2];?>" href="https://www.lotom.net/<?echo $ack1;?>-<?echo "h$no[3]";?>/"><? echo $no[2];?></a></p></div>
<div class="denhabered1"><a  href="https://www.lotom.net/<?echo $ack1;?>-<?echo "h$no[3]";?>/">
<div class="reskt3"><img alt="<?echo $no[2];?>" src="https://www.lotom.net<?echo $dosya;?>" width="220" height="136"></div></a></div>
<div class="denhabered2"><p><?echo substr($no[4],0,300);?></p></div>
</div>
<?
$sayacajax++;
$sayac--;
}
?>
<div class="temizle"></div>
</div>

<div class="temizle"></div>