<?php
//
// +---------------------------------------------------------------------------+
// | NizipRehber Haber Portalı v1.0 [ nrnews_v1.0 ] |
// +---------------------------------------------------------------------------+
// | |
// | Gereksininimleri : PHP 4 veya üzeri, GD2+ kütüphanesi |
// | |
// +---------------------------------------------------------------------------+
// | |
// | Geliştirici : Mahmut ÖZDEMİR |
// | E-posta : mahmuttt88 {at} yahoo {dot} com |
// | Web adresi : http://www.mahmutozdemir.org/ |
// | Tel : +90 5373622826 / +90 5457604888 / +90 5543184701 |
// | |
// +---------------------------------------------------------------------------+
// | |
// | Copyright (C) 2007 |
// | |
// | Bu Yazılım ÜCRETSİZ DEĞİLDİR. Yazılımın Tüm Hakları Mahmut ÖZDEMİR'e |
// | aittir. |
// | |
// +---------------------------------------------------------------------------+
//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//~~~~~~~~~~~~~ Üst Çağırılıyor ~~~~~~~~~~//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
include("header.php");
?>
<?php
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//~~~~~~~~~~~~~ Yazı Sorgusu ~~~~~~~~~~~~~//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
$article_id = intval($_GET['article_id']);
$db->write_query("UPDATE articles set hits = hits + 1 where article_id = $article_id");
$query = $db->read_query("
SELECT article.title, article.article, article.date, article.author_id,
article.hits, author.name, author.image, author.email
FROM articles as article, authors as author
WHERE article.author_id = author.author_id
AND article.active = 'Y'
AND article.article_id = $article_id
") or die($db->sql_error());
$articleDetail = $db->sql_fetcharray($query);
?>
<table class="body" width="770" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="leftright">
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="120" valign="top" style="background:#EFEFEF;">
<?php
include("left.php");
?>
</td>
<td width="490" valign="top" class="centerColumn">
<!-- Orta Kısım -->
<div id="font_tools">
<div class="tools">
<div class="fonts">
Karakter boyutu :
<img style="cursor: pointer;" src="images/font_01.gif" align="absmiddle" onClick="return changeSize('text_detail', '12', 'content')" alt="12 Punto"/>
<img style="cursor: pointer;" src="images/font_02.gif" align="absmiddle" onClick="return changeSize('text_detail', '14', 'content')" alt="14 Punto"/>
<img style="cursor: pointer;" src="images/font_03.gif" align="absmiddle" onClick="return changeSize('text_detail', '16', 'content')" alt="16 Punto"/>
<img style="cursor: pointer;" src="images/font_04.gif" align="absmiddle" onClick="return changeSize('text_detail', '18', 'content')" alt="18 Punto"/>
</div>
<div class="goback"><img src="images/back_red.gif" align="absmiddle" /> <a href="./index.php">Ana sayfaya Dön</a></div>
</div></div>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<div id="article_detail">
<div class="author_image">
<div><img src="images/authors/<?=$articleDetail[image]?>" width="150" height="170" /></div>
<div class="about"><b><?=stripslashes($articleDetail[name])?></b></div>
<div class="about"><?=stripslashes($articleDetail[email])?></div>
</div>
<div class="title"><?=stripslashes($articleDetail[title])?></div>
<div class="br1pxdot"><img src="images/spacer.gif" /></div>
<div class="date"><?php echo time_to_now($articleDetail[date]);?></div>
<div class="br1pxdot"><img src="images/spacer.gif" /></div>
<div class="detail content_12" id="text_detail"><?=stripslashes($articleDetail[article])?></div>
<div class="read_count">Bu yazı toplam <?=$articleDetail[hits]?> defa okundu.</div>
</div>
<script type="text/javascript">changeTarget(document.getElementById("text_detail"))</script>
</td>
</tr>
<tr>
<td>
<select style="width:100%; font: 100 12px Arial, Helvetica, sans-serif; color:#666666" onchange="return changeArticle(this.value);">
<option>-- Yazara Ait Diğer Köşe Yazıları --</option>
<?php
$query = $db->read_query("
SELECT article_id, title, date
FROM articles
WHERE author_id = '$articleDetail[author_id]'
AND article_id <> $article_id
AND active = 'Y'
ORDER BY date DESC
") or die($db->sql_error());
while($row = $db->sql_fetcharray($query)){
?>
<option value="<?=$row[article_id]?>"><?=date("d.m.Y",$row[date])?> - <?=stripslashes($row[title])?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>
<!-- Ara Çizgiler -->
<div class="center_line"><img src="images/spacer.gif" height="5" /></div>
<!-- Yazı Araçları -->
<div id="textTools">
<div class="item"><img src="images/comment_add.gif" align="absmiddle" /> <a href="javascrit:;" onClick="return openPopUp_520x390('comment_add.php?id=<?=$article_id?>&type=article','');">Yorum Ekle</a> </div>
<div class="item"><img src="images/print.gif" align="absmiddle" /> <a target="_blank" href="article_print.php?article_id=<?=$article_id?>">Yazdır </a></div>
<div class="item"><img src="images/up.gif" align="absmiddle" /> <a href="#top">Yukarı Çık</a> </div>
</div>
<!-- Ara Çizgiler -->
<div class="center_line"><img src="images/spacer.gif" height="5" /></div>
</td>
</tr>
<?php
$query = $db->write_query("
SELECT name, title, comment, date
FROM comments
WHERE id = $article_id
AND type = 'article'
AND active = 'Y'
ORDER BY date DESC
") or die($db->sql_error());
$total_comments = $db->sql_numrows($query);
if(!$total_comments){
echo "<tr><td>Bu Yazıya Henüz Yorum Eklenmemiş.</td></tr>";
}
$query = $db->read_query("
SELECT name, title, comment, date
FROM comments
WHERE id = $article_id
AND type = 'article'
AND active = 'Y'
ORDER BY date DESC
LIMIT 3
") or die($db->sql_error());
while($row = $db->sql_fetcharray($query)){
?>
<tr>
<td id="comments">
<div class="comment">
<div class="name"><?php echo stripslashes($row[name]);?></div>
<div class="title"><?php echo stripslashes($row[title]);?></div>
<div class="comment"><?php echo stripslashes($row[comment]);?></div>
<div class="date"><?php echo time_to_now($row[date]);?></div>
</div></td>
</tr>
<?php
}
if($total_comments>3){
?>
<tr id="comments">
<td class="allComments"><a href="javascript:;" onclick="return openPopUp_520x390('comments.php?id=<?=$article_id?>&type=article','');">Tüm Yorumları Göster(<?=$total_comments?>)</a></td>
</tr>
<?php
}
?>
</table>
<!-- //Orta Kısım -->
</td>
<td width="150" valign="top" style="background:#EFEFEF;">
<?php
include("right.php");
?>
</td>
</tr>
</table></td>
</tr>
</table>
<?php
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//~~~~~~~~~~~~~ Alt Çağırılıyor ~~~~~~~~~~//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
include("footer.php");
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
//~~~~~~~~~~~~~ MySQL Kapatılıyor ~~~~~~~~//
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~//
$db->sql_close();
?>
İlgilenirsen sevinirim