";
if($academics_code>0){
$cont=$db->sqllistrow("select * from academics_info where unique_code='$academics_code'");
foreach($cont as $key=>$deger){
$cat=$db->sql("select main_name from academics_main where unique_code='$deger[category_code]'");
$baslik=$deger[academics_name];
$spot=$deger[academics_spot];
$metin=$deger[academics_content];
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_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 academics_pic where academics_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 academics_pic where academics_code='$deger[unique_code]' and category_code='$deger[category_code]' and active='1'");
echo "
";
if($academics_code>0){
$nots = mysql_query("select * from academics_pic where academics_code='$academics_code' and active='1'");
$pnum = mysql_num_rows($nots);
if($pnum>1){
echo "
";
echo "";
//
Görseller / $scal
$cont=$db->sqllistrow("select * from academics_info where unique_code='$academics_code'");
foreach($cont as $key=>$deger){
$pcontent=$db->sqllistrow("select * from academics_pic where academics_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($academics_code>0){
$notv = mysql_query("select * from academics_video where academics_code='$academics_code' and active='1'");
$vnum = mysql_num_rows($notv);
if($vnum>0){
echo "
";
//echo "
Video / $scal
";
echo "";
$cont=$db->sqllistrow("select * from academics_info where unique_code='$academics_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[academics_name];
$vnt=$db->sqllistrow("select * from academics_video where academics_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 academics_pic where academics_code='$value[academics_code]' and active='1'");
if($foto>0){
echo "
";
$cmnt = mysql_query("select * from academics_comment where academics_code='$academics_code' and active='1'");
$cnum = mysql_num_rows($cmnt);
if($vnum>0){
echo "
";
echo "
Yorumlar
";
echo "
";
$comms=$db->sqllistrow("select * from academics_comment where category_code='$category_code' and academics_code='$academics_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 academics_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($academics_code>0){
$notf = mysql_query("select * from academics_file where academics_code='$academics_code' and active='1'");
$fnum = mysql_num_rows($notf);
if($fnum>0){
echo "
";
$cont=$db->sqllistrow("select * from academics_info where unique_code='$academics_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[academics_name];
echo "
Ek Dosyalar
";
echo "
";
echo "
";
echo "
";
$fnt=$db->sqllistrow("select * from academics_file where academics_code='$deger[unique_code]' and active='1' order by id desc");
foreach($fnt as $key=>$value){
$fname=$value[academics_name];
$fsrc=$value[academics_src];
$ext = substr(strstr($value[academics_src], '.'),1,10);
include "file_inc.php";
echo "
";
$category=$db->sqllistrow("select * from academics_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$academics=$db->sqllistrow("select * from academics_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($academics as $key=>$deger){
$baslik = StrToBuyuk($deger[academics_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
echo "";
/**
if($category_code>0){
$cats=$db->sqllistrow("select * from academics_main where unique_code='$category_code' and active='1'");
}else{
$cats=$db->sqllistrow("select * from academics_main where active='1'");
}
foreach($cats as $key=>$value){
$category=$value[main_name];
echo "
$category / Başlıklar
";
echo "
";
$cont=$db->sqllistrow("select * from academics_info where category_code='$value[unique_code]' and active='1' order by id asc");
$a=0;
foreach($cont as $key=>$deger){
$a=$a+1;
$baslik=$deger[academics_name];
$day = date("d", date("$deger[unique_code]"));
$month = date("m", date("$deger[unique_code]"));
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_info where unique_code='$deger[unique_code]'");
echo "
";
echo "";
}elseif($category_code>0){
$category=$db->sqllistrow("select unique_code,main_name from academics_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$academics=$db->sqllistrow("select * from academics_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($academics as $key=>$deger){
$baslik = StrToBuyuk($deger[academics_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
}
}else{
$category=$db->sqllistrow("select unique_code,main_name from academics_main where unique_code and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
$academics=$db->sqllistrow("select * from academics_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 0,1");
foreach($academics as $key=>$deger){
$baslik="$deger[academics_name]";
$metin=explode('.',$deger[academics_content]);
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_info where unique_code='$deger[unique_code]'");
echo "
";
$photo=$db->sqllistrow("select * from academics_pic where academics_code='$deger[unique_code]' and active='1' order by id asc limit 0,1");
foreach($photo as $key=>$valpic){
echo "
";
$academics=$db->sqllistrow("select * from academics_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 1,10");
foreach($academics as $key=>$deger){
$baslik = StrToBuyuk($deger[academics_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from academics_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "