"._KSYZYONETIM.""; echo "

"; echo "" ."" ."" ."" .""; echo "

"._KYAZYONETIM."

"._KYYAZAREKLE."

"._KOSEYAZIEKLE."

"._ADMINMENU."

"; CloseTable(); echo "
"; } function koseyazilari() { global $language, $admin, $aid, $prefix, $db, $sitename; $result = $db->sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'"); list($radminsuper) = $db->sql_fetchrow($result); $radminsuper = intval($radminsuper); include("header.php"); koseyazimenu(); echo "
"; OpenTable(); echo ""._LAST." 10 "._STANDART."
"; $result6 = $db->sql_query("SELECT sid, aid, title, time, topic, alanguage FROM ".$prefix."_kose_yazilari $queryalang ORDER BY time DESC LIMIT 0,10"); echo ""; while ($row6 = $db->sql_fetchrow($result6)) { $sid = intval($row6['sid']); $aid = $row6['aid']; $said = substr("$aid", 0,25); $title = $row6['title']; $time = $row6['time']; $topic = $row6['topic']; $informant = $row6['informant']; $alanguage = $row6['alanguage']; $row7 = $db->sql_fetchrow($db->sql_query("SELECT yazaradi FROM ".$prefix."_kose_yazarlari WHERE yazarno='$topic'")); $yazaradi = $row7['yazaradi']; if ($alanguage == "") { $alanguage = ""._ALL.""; } formatTimestamp($time); echo ""; } else { echo ""; } } else { echo ""; } } echo "

$sid" ."	$title" ."	$yazaradi"; if (($aid == $said) OR ($radminsuper==1)) { if (($aid == $said) OR ($radminsuper==1)) { echo "	("._DUZENLE."-"._SIL.")" ."
("._KYKY.")" ."

"; if (($aid == $said) OR ($radminsuper==1)) { echo "" ."

" .""._YAZINO.": " ."" .""._DUZENLE."" .""._SIL."" ."" ."" ."

"; } CloseTable(); include ("footer.php"); } function yaziduzenle($sid) { global $user, $bgcolor1, $bgcolor2, $aid, $prefix, $db, $multilingual; $aid = substr("$aid", 0,25); $result = $db->sql_query("select radminsuper from ".$prefix."_authors where aid='$aid'"); list($radminsuper) = $db->sql_fetchrow($result); $radminsuper = intval($radminsuper); $result2 = $db->sql_query("select aid from ".$prefix."_kose_yazilari where sid='$sid'"); list($aaid) = $db->sql_fetchrow($result2); $aaid = substr("$aaid", 0,25); if (($aaid == $aid) OR ($radminsuper == 1)) { include ('header.php'); koseyazimenu(); echo "
"; $result = $db->sql_query("SELECT catid, title, bodytext, topic, notes, alanguage FROM ".$prefix."_kose_yazilari where sid='$sid'"); list($catid, $subject, $bodytext, $topic, $notes, $alanguage) = $db->sql_fetchrow($result); $catid = intval($catid); $subject = stripslashes($subject); $bodytext = stripslashes($bodytext); $notes = stripslashes($notes); $result2=$db->sql_query("select yazarresim from ".$prefix."_kose_yazarlari where yazarno='$topic'"); list($yazarresim) = $db->sql_fetchrow($result2); OpenTable(); echo ""._KOSEYAZIDUZENLE."
" ."

" ." " .""; themepreview($subject, $bodytext, $notes); echo "

" ."

" .""._BASLIK."
" ."

" .""._YAZAR." "; $toplist = $db->sql_query("select yazarno, yazarmail from ".$prefix."_kose_yazarlari order by yazarmail"); echo ""._TUMYAZARLAR."\n"; while(list($yazarno, $topics) = $db->sql_fetchrow($toplist)) { $yazarno = intval($yazarno); if ($yazarno==$topic) { $sel = "selected "; } echo "$topics\n"; $sel = ""; } echo ""; echo "

"; $cat = $catid; echo "
"; if ($multilingual == 1) { echo "
"._DIL.":" .""; $handle=opendir('language'); while ($file = readdir($handle)) { if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) { $langFound = $matches[1]; $languageslist .= "$langFound "; } } closedir($handle); $languageslist = explode(" ", $languageslist); sort($languageslist); for ($i=0; $i < sizeof($languageslist); $i++) { if($languageslist[$i]!="") { echo "".ucfirst($languageslist[$i])."\n"; } } if ($alanguage == "") { $sellang = "selected"; } else { $sellang = ""; } echo ""._ALL.""; } else { echo ""; } echo "


" .""._KOSEYAZIYAZIN."
" ."$bodytext
" .""._LINKEKLEDINIZMI."

" .""._NOTLAR."
" ."$notes

" ."" ."" ."" ."

"; CloseTable(); include ('footer.php'); } else { include ('header.php'); OpenTable(); echo ""._KSYZYONETIM.""; CloseTable(); echo "
"; OpenTable(); echo ""._YETKIYOK."

" .""._YETKIYOK2."

" .""._GOBACK.""; CloseTable(); include("footer.php"); } } function yazidegistir($sid, $subject, $bodytext, $topic, $notes, $catid, $alanguage, $acomm, $assotop) { global $aid, $ultramode, $prefix, $db; for ($i=0; $isql_query("select radminsuper from ".$prefix."_authors where aid='$aid'"); list($radminsuper) = $db->sql_fetchrow($result); $radminsuper = intval($radminsuper); $result2 = $db->sql_query("select aid from ".$prefix."_kose_yazilari where sid='$sid'"); list($aaid) = $db->sql_fetchrow($result2); $aaid = substr("$aaid", 0,25); if (($aaid == $aid) OR ($radminsuper == 1)) { $subject = stripslashes(FixQuotes($subject)); $bodytext = stripslashes(FixQuotes($bodytext)); $notes = stripslashes(FixQuotes($notes)); $db->sql_query("update ".$prefix."_kose_yazilari set catid='$catid', title='$subject', bodytext='$bodytext', topic='$topic', notes='$notes', alanguage='$alanguage', acomm='$acomm', associated='$associated' where sid='$sid'"); if ($ultramode) { ultramode(); } Header("Location: admin.php?op=yazaryonetim"); } } function yaziekle() { global $prefix, $db, $language, $multilingual; include ('header.php'); koseyazimenu(); echo "
"; OpenTable(); echo ""._KOSEYAZIEKLE."

" ."

" .""._BASLIK."
" ."

" .""._YAZAR." "; $toplist = $db->sql_query("select yazarno, yazaradi from ".$prefix."_kose_yazarlari order by yazaradi"); echo ""; echo ""._YAZARSECIN."\n"; while(list($yazarno, $topics) = $db->sql_fetchrow($toplist)) { $yazarno = intval($yazarno); if ($yazarno == $topic) { $sel = "selected "; } echo "$topics\n"; $sel = ""; } echo "

"; $sql = "SELECT yazarno, yazarmail FROM ".$prefix."_kose_yazarlari ORDER BY yazarmail"; $result = $db->sql_query($sql); while ($row = $db->sql_fetchrow($result)) { if ($a == 3) { echo ""; $a = 0; } $a++; } $cat = 0; if ($multilingual == 1) { echo "
"._LANGUAGE.": " .""; $handle=opendir('language'); while ($file = readdir($handle)) { if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) { $langFound = $matches[1]; $languageslist .= "$langFound "; } } closedir($handle); $languageslist = explode(" ", $languageslist); sort($languageslist); for ($i=0; $i < sizeof($languageslist); $i++) { if($languageslist[$i]!="") { echo "".ucfirst($languageslist[$i])."\n"; } } echo ""._ALL.""; } else { echo ""; } echo "

"._KOSEYAZIYAZIN."
" ."
" .""._LINKEKLEDINIZMI.""; echo "

" ."" .""._ONIZLEME."" .""._YOLLA."" ."" .""; CloseTable(); echo "
"; echo "

"; include ('footer.php'); } function yazionizleme($year, $day, $month, $hour, $min, $subject, $bodytext, $topic, $catid, $alanguage) { global $user, $bgcolor1, $bgcolor2, $prefix, $db, $alanguage, $multilingual; include ('header.php'); if ($topic<1) { $topic = 1; } koseyazimenu(); echo "
"; OpenTable(); echo ""._ONIZLEME."

" ."

" .""; $subject = stripslashes($subject); $subject = ereg_replace("\"", "''", $subject); $bodytext = stripslashes($bodytext); $result=$db->sql_query("select yazarresim from ".$prefix."_kose_yazarlari where yazarno='$topic'"); list($yazarresim) = $db->sql_fetchrow($result); echo "

" ." " .""; themepreview($subject, $bodytext); echo "

" ."

"._BASLIK."
" ."

" .""._YAZAR.""; $toplist = $db->sql_query("select yazarno, yazaradi from ".$prefix."_kose_yazarlari order by yazaradi"); echo ""._TUMYAZARLAR."\n"; while(list($yazarno, $topics) = $db->sql_fetchrow($toplist)) { $yazarno = intval($yazarno); if ($yazarno==$topic) { $sel = "selected "; } echo "$topics\n"; $sel = ""; } echo "

"; $cat = $catid; echo "
"; if ($multilingual == 1) { echo "
"._LANGUAGE.": " .""; $handle=opendir('language'); while ($file = readdir($handle)) { if (preg_match("/^lang\-(.+)\.php/", $file, $matches)) { $langFound = $matches[1]; $languageslist .= "$langFound "; } } closedir($handle); $languageslist = explode(" ", $languageslist); sort($languageslist); for ($i=0; $i < sizeof($languageslist); $i++) { if($languageslist[$i]!="") { echo "".ucfirst($languageslist[$i])."\n"; } } if ($alanguage == "") { $sellang = "selected"; } else { $sellang = ""; } echo ""._ALL.""; } else { echo ""; } echo "

"._KOSEYAZIYAZIN."
" ."$bodytext

"; echo "

" ."" .""._ONIZLEME."" .""._YOLLA."" ."" .""; CloseTable(); echo "
"; echo "

"; include ('footer.php'); } function yaziyigonder($automated, $year, $day, $month, $hour, $min, $subject, $bodytext, $topic, $catid, $alanguage) { global $ultramode, $aid, $prefix, $db; $subject = stripslashes(FixQuotes($subject)); $bodytext = stripslashes(FixQuotes($bodytext)); $result = $db->sql_query("insert into ".$prefix."_kose_yazilari values (NULL, '$topic', '$subject', '$bodytext', '0', '$alanguage', '$catid', '$aid', now(), '$aid', '$notes', '$acomm', '0', '0', '$associated', '0')"); $result = $db->sql_query("select sid from ".$prefix."_kose_yazilari WHERE title='$subject' order by time DESC limit 0,1"); list($artid) = $db->sql_fetchrow($result); $artid = intval($artid); $result = $db->sql_query("update ".$prefix."_authors set counter=counter+1 where aid='$aid'"); if ($ultramode) { ultramode(); } Header("Location: admin.php?op=yaziekle"); } function koseyazisil($sid, $ok=0) { global $ultramode, $aid, $prefix, $db; $aid = substr("$aid", 0,25); $result = $db->sql_query("select counter, radminsuper from ".$prefix."_authors where aid='$aid'"); list($counter, $radminsuper) = $db->sql_fetchrow($result); $radminsuper = intval($radminsuper); $counter = intval($counter); $sid = intval($sid); $result2 = $db->sql_query("select aid from ".$prefix."_kose_yazilari where sid='$sid'"); list($aaid) = $db->sql_fetchrow($result2); $aaid = substr("$aaid", 0,25); if (($aaid == $aid) OR ($radminsuper == 1)) { if($ok) { $counter--; $db->sql_query("DELETE FROM ".$prefix."_kose_yazilari where sid='$sid'"); $db->sql_query("DELETE FROM ".$prefix."_kose_yazi_yorumlar where sid='$sid'"); $result = $db->sql_query("update ".$prefix."_authors set counter='$counter' where aid='$aid'"); if ($ultramode) { ultramode(); } Header("Location: admin.php?op=koseyazilari"); } else { include("header.php"); koseyazimenu(); echo "
"; OpenTable(); echo " $sid "._KYYAZISIL.""; echo "

[ "._NO." | "._YES." ]"; CloseTable(); include("footer.php"); } } else { include ('header.php'); koseyazimenu(); echo "
"; OpenTable(); echo ""._NOTAUTHORIZED1."

" .""._NOTAUTHORIZED2."

" .""._GOBACK.""; CloseTable(); include("footer.php"); } } function kyazialtyorumsil($tid) { global $prefix, $db; $tid = intval($tid); $result = $db->sql_query("SELECT tid from " . $prefix . "_kose_yazi_yorumlar where pid='$tid'"); $numrows = $db->sql_numrows($result); if($numrows>0) { while ($row = $db->sql_fetchrow($result)) { $stid = intval($row['tid']); kyazialtyorumsil($stid); $stid = intval($stid); $db->sql_query("delete from " . $prefix . "_kose_yazi_yorumlar where tid='$stid'"); } } $db->sql_query("delete from " . $prefix . "_kose_yazi_yorumlar where tid='$tid'"); } function kyaziyorumsil ($tid, $sid, $ok=0) { global $ultramode, $prefix, $db; if($ok) { $tid = intval($tid); $result = $db->sql_query("SELECT date from " . $prefix . "_kose_yazi_yorumlar where pid='$tid'"); $numresults = $db->sql_numrows($result); $sid = intval($sid); $db->sql_query("update " . $prefix . "_kose_yazilari set comments=comments-1-'$numresults' where sid='$sid'"); /* Call recursive delete function to delete the comment and all its childs */ kyazialtyorumsil($tid); if ($ultramode) { ultramode(); } Header("Location: modules.php?name=Kose_Yazilari&file=yazi_oku&sid=$sid"); } else { include("header.php"); koseyazimenu(); OpenTable(); echo "" . _KYYORUMSIL . ""; CloseTable(); echo "
"; OpenTable(); echo "" . _KYYORUMSILONAY . ""; echo "

[ " . _NO . " | " . _YES . " ]"; CloseTable(); include("footer.php"); } } function yazaryonetim() { global $prefix, $db; include("header.php"); koseyazimenu(); echo "
"; OpenTable(); echo ""._KOSEYAZARLARI . "
"._YZDUZENLE . "
" .""; $count = 0; $result = $db->sql_query("SELECT yazarno, yazaradi, yazarresim, yazarmail from " . $prefix . "_kose_yazarlari order by yazaradi"); while ($row = $db->sql_fetchrow($result)) { $yazarno = intval($row['yazarno']); $yazaradi = $row['yazaradi']; $yazarresim = $row['yazarresim']; $yazarmail = $row['yazarmail']; echo ""; $count++; if ($count == 5) { echo ""; $count = 0; } } echo "

" ." " ."$yazaradi

"; CloseTable(); echo "
"; include("footer.php"); } function koseyazarekle() { global $prefix, $db; include("header.php"); koseyazimenu(); echo "
"; echo "
"; OpenTable(); echo ""._KYYAZAREKLE . "
" ."

" .""._YAZARADI . ":
"._YAZARADI1 . "
" ."" ."

" .""._YAZARMAIL . ":
"._YAZARMAIL1 . "
" ."" ."

" .""._YAZARRESIM . ":
"._YAZARRESIM1 . "
" .""; $path1 = explode ("/", "images/kose_yazilari/"); $path = "$path1[0]/$path1[1]"; $handle=opendir($path); while ($file = readdir($handle)) { if ( (ereg("^([_0-9a-zA-Z]+)([.]{1})([_0-9a-zA-Z]{3})$",$file)) AND $file != "resimyok.gif") { $tlist .= "$file "; } } closedir($handle); $tlist = explode(" ", $tlist); sort($tlist); for ($i=0; $i < sizeof($tlist); $i++) { if($tlist[$i]!="") { echo "$tlist[$i]\n"; } } echo "

" ."" ."" ."

"; CloseTable(); include("footer.php"); } function yazarduzenle($yazarno) { global $prefix, $db; include("header.php"); koseyazimenu(); echo "
"; OpenTable(); $yazarno = intval($yazarno); $row = $db->sql_fetchrow($db->sql_query("SELECT yazarno, yazaradi, yazarresim, yazarmail from ".$prefix . "_kose_yazarlari where yazarno='$yazarno'")); $yazarno = intval($row['yazarno']); $yazaradi = $row['yazaradi']; $yazarresim = $row['yazarresim']; $yazarmail = $row['yazarmail']; echo "" .""._YAZARDUZENLE . ": $yazaradi" ."

" ."

" .""._YAZARADI . ":
"._YAZARADI1 . "
" ."" ."

" .""._YAZARMAIL . ":
"._YAZARMAIL1 . "
" ."" ."

" .""._YAZARRESIM . ":
"._YAZARRESIM1 . "
" .""; $path1 = explode ("/", "images/kose_yazilari/"); $path = "$path1[0]/$path1[1]"; $handle=opendir($path); while ($file = readdir($handle)) { if ( (ereg("^([_0-9a-zA-Z]+)([.]{1})([_0-9a-zA-Z]{3})$",$file)) AND $file != "resimyok.gif") { $tlist .= "$file "; } } closedir($handle); $tlist = explode(" ", $tlist); sort($tlist); for ($i=0; $i < sizeof($tlist); $i++) { if($tlist[$i]!="") { if ($yazarresim == $tlist[$i]) { $sel = "selected"; } else { $sel = ""; } echo "$tlist[$i]\n"; } } echo "

"; echo "

" ."" ."" ." [ "._DELETE . " ]" ."

"; CloseTable(); include("footer.php"); } function yazarekle($yazaradi, $yazarresim, $yazarmail) { global $prefix, $db; $yazaradi = stripslashes(FixQuotes($yazaradi)); $yazarresim = stripslashes(FixQuotes($yazarresim)); $yazarmail = stripslashes(FixQuotes($yazarmail)); $db->sql_query("INSERT INTO ".$prefix . "_kose_yazarlari VALUES (NULL,'$yazaradi','$yazarresim','$yazarmail','0')"); Header("Location: admin.php?op=yazaryonetim#Add"); } function yazardegistir($yazarno, $yazaradi, $yazarresim, $yazarmail) { global $prefix, $db; $yazaradi = stripslashes(FixQuotes($yazaradi)); $yazarresim = stripslashes(FixQuotes($yazarresim)); $yazarmail = stripslashes(FixQuotes($yazarmail)); $yazarno = intval($yazarno); $db->sql_query("update ".$prefix . "_kose_yazarlari set yazaradi='$yazaradi', yazarresim='$yazarresim', yazarmail='$yazarmail' where yazarno='$yazarno'"); Header("Location: admin.php?op=yazarduzenle&yazarno=$yazarno"); } function yazarsil($yazarno, $ok=0) { global $prefix, $db; $yazarno = intval($yazarno); if ($ok==1) { $row = $db->sql_fetchrow($db->sql_query("SELECT sid from " . $prefix . "_kose_yazilari where topic='$yazarno'")); $sid = intval($row['sid']); $db->sql_query("delete from " . $prefix . "_kose_yazilari where topic='$yazarno'"); $db->sql_query("delete from " . $prefix . "_kose_yazarlari where yazarno='$yazarno'"); $row2 = $db->sql_fetchrow($db->sql_query("SELECT sid from " . $prefix . "_kose_yazi_yorumlar where sid='$sid'")); $sid = intval($row2['sid']); $db->sql_query("delete from " . $prefix . "_kose_yazi_yorumlar where sid='$sid'"); Header("Location: admin.php?op=yazaryonetim"); } else { global $yazarresim; include("header.php"); koseyazimenu(); echo "
"; $row3 = $db->sql_fetchrow($db->sql_query("SELECT yazarresim, yazaradi from " . $prefix . "_kose_yazarlari where yazarno='$yazarno'")); $yazarresim = $row3['yazarresim']; $yazaradi = $row3['yazaradi']; OpenTable(); echo "

" ."" . _YAZARISIL . " $yazaradi

" ."" . _YAZARSILDIKKAT . " $yazaradi
" ."" . _YAZARSILDIKKAT1 . "

" ."[ " . _NO . " | " . _YES . " ]

"; CloseTable(); include("footer.php"); } } switch($op) { case "onizleme": yazionizle($year, $day, $month, $hour, $min, $qid, $uid, $author, $subject, $bodytext, $topic, $notes, $catid, $alanguage); break; case "yazigonder": yazigonder($year, $day, $month, $hour, $min, $qid, $uid, $author, $subject, $bodytext, $topic, $notes, $catid, $alanguage); break; case "yaziduzenle": yaziduzenle($sid); break; case "yazikaldir": yazikaldir($sid, $ok); break; case "yazidegistir": yazidegistir($sid, $subject, $bodytext, $topic, $notes, $catid); break; case "yaziekle": yaziekle($sid); break; case "yazionizleme": yazionizleme($year, $day, $month, $hour, $min, $subject, $bodytext, $topic, $catid, $alanguage); break; case "yaziyigonder": yaziyigonder($automated, $year, $day, $month, $hour, $min, $subject, $bodytext, $topic, $catid, $alanguage); break; case "yazaryonetim": yazaryonetim(); break; case "koseyazarekle": koseyazarekle(); break; case "yazarduzenle": yazarduzenle($yazarno); break; case "yazarekle": yazarekle($yazaradi, $yazarresim, $yazarmail); break; case "koseyazisil": koseyazisil($sid, $ok); break; case "kyaziyorumsil": kyaziyorumsil ($tid, $sid, $ok); break; case "kyazialtyorumsil": kyazialtyorumsil($tid); break; case "yazarsil": yazarsil($yazarno, $ok); break; case "yazardegistir": yazardegistir($yazarno, $yazaradi, $yazarresim, $yazarmail); break; case "koseyazilari": koseyazilari(); break; case "koseyazimenu": koseyazimenu(); break; } ?>