";
echo "Anasayfa";
if($village_code>0){
$bass=$db->sql("select village_name from $table_info where unique_code='$village_code'");
$cat=$db->sql("select main_name from $table_main where unique_code='$category_code'");
$degisken=$bass;
$boluk = explode(" ", $bass);
$bas ="$boluk[0] $boluk[1] ...";
echo "$bolum";
echo "$cat";
echo "$bas";
}elseif($category_code>0){
$cat=$db->sql("select main_name from $table_main where unique_code='$category_code'");
echo "$bolum";
echo "$cat";
}else {
echo "$bolum";
}
echo "
";
echo "";
if($village_code>0){
echo "";
echo "
";
echo "
";
if($village_code>0){
$cont=$db->sqllistrow("select * from village_info where unique_code='$village_code'");
foreach($cont as $key=>$deger){
$cat=$db->sql("select main_name from village_main where unique_code='$deger[category_code]'");
$baslik=$deger[village_name];
$spot=$deger[village_spot];
$metin=$deger[village_content];
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
echo "
";
echo "
$baslik
";
$puye=$db->sql("select pic_src from member_info where id='$deger[member]'");
$pics = mysql_query("select * from village_pic where village_code='$deger[unique_code]' and category_code='$deger[category_code]' and active='1'");
$picnm = mysql_num_rows($pics);
if($picnm==1){
$pic=$db->sql("select pic_src from village_pic where village_code='$deger[unique_code]' and category_code='$deger[category_code]' and active='1'");
echo "
";
if($village_code>0){
$nots = mysql_query("select * from village_pic where village_code='$village_code' and active='1'");
$pnum = mysql_num_rows($nots);
if($pnum>1){
echo "
";
echo "";
//
Görseller / $scal
$cont=$db->sqllistrow("select * from village_info where unique_code='$village_code'");
foreach($cont as $key=>$deger){
$pcontent=$db->sqllistrow("select * from village_pic where village_code='$deger[unique_code]' and active='1' order by id asc");
foreach($pcontent as $key=>$value){
$baslik=$value[pic_name];
if($scal>1440){
if($pnum==2){
$w="50";
$wi="380";
$he="300";
}elseif($pnum==3){
$w="20";
$wi="180";
$he="120";
}else{
$w="20";
$wi="180";
$he="120";
}
}elseif($scal<1440){
$w="33";
$wi="180";
$he="120";
}
if($metin==Null){
echo "
";
echo "
";
echo "
";
}else{
echo "
";
echo "
";
echo "
";
}
}
}
echo "
";
}
}
echo "
";
echo "
";
if($village_code>0){
$notv = mysql_query("select * from village_video where village_code='$village_code' and active='1'");
$vnum = mysql_num_rows($notv);
if($vnum>0){
echo "
";
//echo "
Video / $scal
";
echo "";
$cont=$db->sqllistrow("select * from village_info where unique_code='$village_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[village_name];
$vnt=$db->sqllistrow("select * from village_video where village_code='$deger[unique_code]' and active='1' order by id desc");
foreach($vnt as $key=>$value){
$pname=$value[video_name];
$dizi = explode('.',$value[video_src]);
$eleman = count($dizi) -1;
$uzanti = $dizi["$eleman"];
include "video_inc.php";
if($scal>1440){
if($vnum==1){
$w="100";
$wi="625";
$he="460";
}elseif($vnum==2){
$w="50";
$wi="480";
$he="360";
}else{
$w="50";
$wi="480";
$he="360";
}
}else{
$w="100";
$wi="625";
$he="460";
}
$foto=$db->sql("select pic_src from village_pic where village_code='$value[village_code]' and active='1'");
if($foto>0){
echo "
";
$cmnt = mysql_query("select * from village_comment where village_code='$village_code' and active='1'");
$cnum = mysql_num_rows($cmnt);
if($vnum>0){
echo "
";
echo "
Yorumlar
";
echo "
";
$comms=$db->sqllistrow("select * from village_comment where category_code='$category_code' and village_code='$village_code' and active= '1' order by id desc");
foreach($comms as $key=>$deger){
$baslik="$deger[comment_name]";
$metin = nl2br($deger[comment_content]);
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_comment where unique_code='$deger[unique_code]'");
$yazar=$db->sqlrow("select * from member_info where id='$deger[member]'");
echo "
$baslik
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
$photo=$db->sqllistrow("select * from member_info where id='$deger[member]'");
foreach($photo as $key=>$valpic){
if($i==0){
echo "
";
if($village_code>0){
$notf = mysql_query("select * from village_file where village_code='$village_code' and active='1'");
$fnum = mysql_num_rows($notf);
if($fnum>0){
echo "
";
$cont=$db->sqllistrow("select * from village_info where unique_code='$village_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[village_name];
echo "
Ek Dosyalar
";
echo "
";
echo "
";
echo "
";
$fnt=$db->sqllistrow("select * from village_file where village_code='$deger[unique_code]' and active='1' order by id desc");
foreach($fnt as $key=>$value){
$fname=$value[village_name];
$fsrc=$value[village_src];
$ext = substr(strstr($value[village_src], '.'),1,10);
include "file_inc.php";
echo "
";
$category=$db->sqllistrow("select * from village_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$village=$db->sqllistrow("select * from village_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($village as $key=>$deger){
$baslik = StrToBuyuk($deger[village_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
$category=$db->sqllistrow("select unique_code,main_name from village_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$village=$db->sqllistrow("select * from village_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($village as $key=>$deger){
$baslik = StrToBuyuk($deger[village_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
$category=$db->sqllistrow("select unique_code,main_name from village_main where unique_code and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
$village=$db->sqllistrow("select * from village_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 0,1");
foreach($village as $key=>$deger){
$baslik="$deger[village_name]";
$metin=explode('.',$deger[village_content]);
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_info where unique_code='$deger[unique_code]'");
echo "
";
$photo=$db->sqllistrow("select * from village_pic where village_code='$deger[unique_code]' and active='1' order by id asc limit 0,1");
foreach($photo as $key=>$valpic){
echo "
";
$village=$db->sqllistrow("select * from village_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 1,10");
foreach($village as $key=>$deger){
$baslik = StrToBuyuk($deger[village_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from village_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "