- Kod: Tümünü seç
<?php
/*
*
* @name recent.php
* @copyright (c) Canver Software - www.canversoft.net
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/* Yazan: Sevdin Filiz
Bu kodların çalışması için phpBB3 sistemine göreceli olarak erişim gerekmektedir.
Kullanılabilir: phpBB3 dizinine eşdeğer seviyedeki bir dizinde veya içiresindeki herhangi bir dizinde, phpBB3 dizinin bir üst seviyesinde.
Kullanılamaz: phpBB3'den farklı bir sunucuda çalışmaz.
$phpbb_root_path değişkeni phpBB3'ün kurulu olduğu dizini göstermeli.
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="tr" xml:lang="tr">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="content-language" content="tr" />
<meta name="author" content="Canver Software" />
<title>sayfa başlığı</title>
</head>
<body>
<style>
a:link,
a:visited {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #496c9f;
text-decoration: none;
}
a:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #496c9f;
text-decoration: underline;
}
a:active {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #496c9f;
text-decoration: none;
}
</style>
<?php
/**
* @ignore
*/
define('IN_PHPBB', true);
$phpbb_root_path = './'; // phpBB3'ün kurulu olduğu dizin
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// + setup
$config['exclude_forums'] = ''; // exclude forums id
$config['max_topics'] = '19'; // last xx topic
$config['new_img'] = 'styles/dark-shines/imageset/icon_back_top.gif'; // new image location
// - setup
//
// Exclude forums
//
$sql_where = '';
if ($config['exclude_forums'])
{
$exclude_forums = explode(',', $config['exclude_forums']);
foreach ($exclude_forums as $i => $id)
{
if ($id > 0)
{
$sql_where .= ' AND t.forum_id != ' . trim($id);
}
}
}
//
// Recent topic (only show normal topic)
//
/*
$sql = 'SELECT t.topic_title, t.forum_id, t.topic_id, f.forum_id, f.forum_name, f.forum_image, t.topic_replies
FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f
WHERE t.topic_status <> 2
AND t.topic_approved = 1
AND t.topic_type = 0
AND t.forum_id = f.forum_id
' . $sql_where . '
ORDER BY t.topic_last_post_time DESC';
$result = $db->sql_query_limit($sql, $config['max_topics']);
*/
$forum_list = array(35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74); //Sadece bu dizideki forum_id degerleri olan forumlardan konu cekmek istiyoruz
$sql = 'SELECT t.topic_title, t.forum_id, t.topic_id, f.forum_id, f.forum_name, f.forum_image, t.topic_replies
FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f
WHERE t.topic_status <> 2
AND t.topic_approved = 1
AND t.topic_type = 0
AND t.forum_id = f.forum_id
AND ' . $db->sql_in_set('t.forum_id', $forum_list) . '
' . $sql_where . '
ORDER BY t.topic_time DESC';
$result = $db->sql_query_limit($sql, $config['max_topics']);
?>
<table border="0" cellpadding="1" cellspacing="1" width="860">
<tr>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">A</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">B</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">C</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Ç</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">D</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">E</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">F</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">G</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">H</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">I</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">İ</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">J</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">K</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">L</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">M</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">N</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">O</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Ö</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">P</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Q</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">R</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">S</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Ş</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">T</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">U</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Ü</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">V</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">W</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">X</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Y</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">Z</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">1</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">2</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">3</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">4</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">5</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">6</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">7</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">8</font></th>
<th align="center" bgcolor="#272727"><font color="#719797" size="2">9</font></th>
</table>
<BR><BR><BR>
<table border="0" cellpadding="1" cellspacing="1" width="860">
<tr>
<th align="left" bgcolor="#272727"><font color="#719797" size="2">Yeni Eklenenler</font></th>
<th align="left" bgcolor="#272727"><font color="#719797" size="2">Popüler Olanlar</font></th>
</table>
<table border="0" cellpadding="1" cellspacing="1" width="860">
<tr>
<th align="center" bgcolor="#272727" width="330"><font color="#719797" size="2">Başlık</font></th>
<th align="center" bgcolor="#272727" width="80"><font color="#719797" size="2">Yazar</font></th>
<th align="center" bgcolor="#272727" width="330"><font color="#719797" size="2">Başlık</font></th>
<th align="center" bgcolor="#272727" width="80"><font color="#719797" size="2">Yazar</font></th>
<?php
while( ($row = $db->sql_fetchrow($result)) && ($row['topic_title'] != '') )
{
// auto auth
if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{
?>
<tr>
<td bgcolor="#000000" align="left"><font face="verdana" color="#719797" size="1">
<?php
if ( ! $row['topic_replies'] )
{
?>
<img src="<?=$config['new_img'];?>" alt="Yeni" />
<?php
}
?>
<a href="<?=append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id'])?>"><?=censor_text($row['topic_title']); ?></a> </font></a></td>
<td bgcolor="#000000" align="left"><div align="center"><font face="verdana" color="#719797" size="1"><a href="<?=append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id'])?>"><?=censor_text($row['forum_name']); ?></a></div></td>
<td bgcolor="#000000" align="left"><div align="left"><font face="verdana" color="#719797" size="1">
<?php
if ( ! $row['topic_replies'] )
{
?>
<img src="<?=$config['new_img'];?>" alt="Yeni" />
<?php
}
?>
<a href="<?=append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id'])?>"><?=censor_text($row['topic_title']); ?>
</a></div></td>
<td bgcolor="#000000" align="left"><font face="verdana" color="#719797" size="1"><div align="center">
<?php
if ($row['forum_image'])
{
?>
<a href="<?=append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $row['forum_id'])?>"><img src="<?=$phpbb_root_path . $row['forum_image'];?>" alt="<?=censor_text($row['forum_name']); ?>" border="0" /></a>
<?php
}
?>
</div></td>
<?php
}
}
$db->sql_freeresult($result);
?>
</table>
</body>
</html>
Bu konu hakkında yardımcı ola bılırmısınız.... egerkı bu olursa ben bunu harıcı sayfada gosterecegım... alfabe kısmı olmasada olur acıkcası ben onları elle gıre bılırım uzantıları ama kı dıger kısımlar hakkında fazla bılgım olmadıgı ıcın anca karakter falan degıstıre bıldım acıkcası....