";
echo "Anasayfa";
if($record_code>0){
$bass=$db->sql("select record_name from $table_info where unique_code='$record_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 "";
echo "";
echo "
";
echo "
";
if($record_code>0){
if($record_code>0){
$cont=$db->sqllistrow("select * from $table_info where unique_code='$record_code'");
foreach($cont as $key=>$deger){
$cat=$db->sql("select main_name from $table_main where unique_code='$deger[category_code]'");
$baslik=$deger[record_name];
$spot=$deger[corporate_spot];
$metin=$deger[record_content];
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from $table_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 $table_media where record_code='$deger[unique_code]' and category_code='$deger[category_code]' and active='1' and media_desc='1'");
$picnm = mysql_num_rows($pics);
if($picnm==1){
$pic=$db->sql("select media_src from $table_media where record_code='$deger[unique_code]' and category_code='$deger[category_code]' and active='1' and media_desc='1'");
echo "
";
if($record_code>0){
$nots = mysql_query("select * from $table_media where record_code='$record_code' and active='1' and media_desc='1'");
$pnum = mysql_num_rows($nots);
if($pnum>1){
echo "
";
echo "";
//
Görseller / $scal
$cont=$db->sqllistrow("select * from $table_info where unique_code='$record_code'");
foreach($cont as $key=>$deger){
$pcontent=$db->sqllistrow("select * from $table_media where record_code='$deger[unique_code]' and active='1' and media_desc='1' order by id asc");
foreach($pcontent as $key=>$value){
$baslik=$value[media_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($record_code>0){
$notv = mysql_query("select * from $table_media where record_code='$record_code' and active='1' and media_desc='2'");
$vnum = mysql_num_rows($notv);
if($vnum>0){
echo "
";
//echo "
Video / $scal
";
echo "";
$cont=$db->sqllistrow("select * from $table_info where unique_code='$record_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[record_name];
$vnt=$db->sqllistrow("select * from $table_media where record_code='$deger[unique_code]' and active='1' and media_desc='2' order by id desc");
foreach($vnt as $key=>$value){
$pname=$value[video_name];
$dizi = explode('.',$value[media_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 media_src from $table_media where record_code='$value[record_code]' and active='1' and media_desc='1'");
if($foto>0){
echo "
";
if($record_code>0){
$notf = mysql_query("select * from $table_media where record_code='$record_code' and active='1' and media_desc='3'");
$fnum = mysql_num_rows($notf);
if($fnum>0){
echo "
";
$cont=$db->sqllistrow("select * from $table_info where unique_code='$record_code'");
foreach($cont as $key=>$deger){
$baslik=$deger[record_name];
echo "
Ek Dosyalar
";
echo "
";
echo "
";
echo "
";
$fnt=$db->sqllistrow("select * from $table_media where record_code='$deger[unique_code]' and active='1' and media_desc='3' order by id desc");
foreach($fnt as $key=>$value){
$fname=$value[record_name];
$fsrc=$value[corporate_src];
$ext = substr(strstr($value[corporate_src], '.'),1,10);
include "file_inc.php";
echo "
";
$cmnt = mysql_query("select * from $table_comment where record_code='$record_code' and active='1'");
$cnum = mysql_num_rows($cmnt);
if($vnum>0){
echo "
";
echo "
Yorumlar
";
echo "
";
$comms=$db->sqllistrow("select * from $table_comment where category_code='$category_code' and record_code='$record_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 $table_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 "
";
$category=$db->sqllistrow("select * from $table_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$corporate=$db->sqllistrow("select * from $table_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($corporate as $key=>$deger){
$baslik = StrToBuyuk($deger[record_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from $table_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 * from $table_main where unique_code='$category_code' and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
echo "
";
$corporate=$db->sqllistrow("select * from $table_info where category_code='$value[unique_code]' and active= '1' order by id desc");
foreach($corporate as $key=>$deger){
$baslik = StrToBuyuk($deger[record_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from $table_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where member='$member_id'");
foreach($uye as $key=>$value){
$metin = nl2br($value[tmember_info]);
echo "$value[member_fullname]
".$db->convert_date_tr($value[rec_date])."
";
}
echo "";
echo "
Üye Tanıtım Bilgim : $metin Doğum Yeri ve Tarihi : $value[member_birthplace] $value[member_birthdate] Baba ve Anne Adı : $value[father_name] ve $value[mother_name] İş ve Görevi : $value[member_job] - $value[member_task] İş Telefonu : $value[job_phone] E-Mail : $value[member_email] Adres : $value[member_address] İlçe : $value[member_district] Şehir : $value[member_city]
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='1'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YÖNETİM KURULU BAŞKANI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='2'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN YARDIMCISI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='3'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN YARDIMCISI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='4'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name MUHASİP ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='5'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name GENEL SEKRETER
";
}
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status order by dernek_status asc limit 5,2");
foreach($uye as $key=>$value){
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='8'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='9'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='10'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='12'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='8'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='13'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='14'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
}elseif($dernek==disiplin){
echo "
";
echo "
DİSİPLİN VE ONUR KURULU
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='15'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name DİSİPLİN VE ONUR KURULU BAŞKANI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='16'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name DİSİPLİN VE ONUR KURULU ÜYESİ
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='17'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name DİSİPLİN VE ONUR KURULU ÜYESİ
";
}
echo "
";
echo "
";
}elseif($dernek==denetleme){
echo "
";
echo "
DENETLEME KURULU
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='18'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ÜYE
";
}
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status order by dernek_status asc limit 18,2");
foreach($uye as $key=>$value){
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='19'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ÜYE
";
}
echo "
";
**/
echo "
DENETLEME KURULU YEDEK ÜYELER
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='21'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='22'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='23'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name YEDEK ÜYE
";
}
echo "
";
echo "
";
}elseif($dernek==kadin){
echo "
";
echo "
KADIN KOLLARI
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='25'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='26'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN YARDIMCISI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='27'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name MUHASİP ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='28'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name SEKRETER
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='29'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ÜYE
";
}
echo "
";
echo "
";
}elseif($dernek==genclik){
echo "
";
echo "
GENÇLİK KOLLARI
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='30'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='31'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BAŞKAN YARDIMCISI
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='32'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name MUHASİP ÜYE
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='33'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name SEKRETER
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='34'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ÜYE
";
}
echo "
";
echo "
";
}elseif($dernek==temsilci){
echo "
";
echo "
TEMSİLCİ LİSTESİ
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='35'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ARTVİN
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='36'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name ANKARA
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='37'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name BURSA
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='38'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name İNEGÖL
";
}
echo "
";
echo "
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='39'");
foreach($uye as $key=>$value){
$name = StrToBuyuk($value[member_fullname]);
echo "
";
echo "
$name İZMİR
";
}
echo "
";
echo "
";
}elseif($dernek==onursal){
echo "
";
echo "
ONURSAL ÜYELER
";
$uye=$db->sqllistrow("select * from dernek_member where dernek_status='24'");
foreach($uye as $key=>$value){
echo "
";
//////////////////////////////////// DERNEK KURUMSAL LİSTE LİNKLERİ ////////////////////////////////////
$category=$db->sqllistrow("select * from $table_main where unique_code and active='1' order by id asc");
foreach($category as $key=>$value){
$cbaslik = StrToBuyuk($value[main_name]) . "";
$corporate=$db->sqllistrow("select * from $table_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 0,1");
foreach($corporate as $key=>$deger){
$baslik="$deger[record_name]";
$metin=explode('.',$deger[record_content]);
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from $table_info where unique_code='$deger[unique_code]'");
echo "
";
$photo=$db->sqllistrow("select * from $table_media where record_code='$deger[unique_code]' and active='1' order by id asc limit 0,1");
foreach($photo as $key=>$valpic){
echo "
";
$corporate=$db->sqllistrow("select * from $table_info where category_code='$value[unique_code]' and active= '1' order by id desc limit 1,10");
foreach($corporate as $key=>$deger){
$baslik = StrToBuyuk($deger[record_name]) . "";
$tarih=$db->sql("select from_unixtime($deger[unique_code]) from $table_info where unique_code='$deger[unique_code]'");
$uye=$db->sql("select member_fullname from member_info where id='$deger[member]'");
echo "