// https://lezzetler.com/fototarif.php?g=revani

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\ TOPLAM TARİF ADEDİ SORGUSU

$sql = "SELECT  f.forum_id AS forum_id, f.auth_post, t.topic_title, t.topic_extra
		FROM " . TOPICS_TABLE . " t
		LEFT OUTER JOIN " . FORUMS_TABLE . " f ON f.forum_id = t.forum_id
		WHERE CONVERT(topic_title USING utf8) LIKE '%$sebze%'
		AND f.auth_post = '1'
		$ilkharfsorgu
		$fotografli";

$result = $db->sql_query($sql);
$topics_count = mysqli_num_rows($result);

$filename = "images/banner/". $sebze . ".jpg";

if (file_exists($filename))
{
$forum_banner = "<img border='0' src='images/banner/" . $sebze . ".jpg' alt='" . $sebze . " tarifleri' width='400' height='100'>";
} else {
$forum_banner = "<img style=\"'float:left'; border='0'; background-image:url('" . $forum_foto . "'); width:400px; height:100px; background-repeat:no-repeat; background-position:0px -150px;\">";
}

$page_title = $ilkbaslik . $forum_name . " - lezzetler.com";
$meta_description = "Kategorilenmiş " . $topics_count . " adet " . $ilkbaslik . " " . $sebze . " Tarifleri bulunuyor. Bu tariflere yorum yazılabilir, oy kullanabilirsiniz.";
$sebze_keywords = " " . isset($ilkbaslik);

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array("body" => "genel_body.tpl"));
$menu = make_menu($bolum);

$template->assign_vars(array(
"ACIK_GOVDE" => $aciklama,
"TUR2" => $ilkbaslik . $forum_name,
"ALFABETIKDIZILIM" => $alfabetikdizilim,
"LINK" => $forum_link . "-tarifleri",
"ONCE" => $once  ?? "",
"SONRA" => $sonra  ?? "",
"SEKME1" => "<li id='" . @$gelen1 . "'><a href='/" . $_GET['m'] . "-tarifleri'>" . $forum_name . "</a></li>",
"SEKME2" => "<li id='" . @$gelen2 . "'><a href='/" . $_GET['m'] . "-tarifleri2'>En çok bakılanlar</a></li>",
"SEKME3" => "<li id='" . @$gelen3 . "'><a href='/" . $_GET['m'] . "-tarifleri3'>En çok tekrarı olanlar</a></li>",
"SEKME4" => "<li id='" . @$gelen4 . "'><a href='/" . $_GET['m'] . "-tarifleri4'>Fotoğraflılar</a></li>",
"ADET" => number_format($topics_count),
"BASLIK2" => $sebze)
);

//\\//\\//\\//\\//\\//\\//\\//\\//\\//\\ ANA LISTELEME SORGUSU

$sql = "SELECT  f.forum_id AS forum_id, f.auth_post, f.forum_name, t.topic_id, t.topic_title, t.topic_extra, t.topic_views, t.topic_time, t.topic_replies, t.topic_last_post_id
		FROM " . TOPICS_TABLE . " t
		LEFT OUTER JOIN " . FORUMS_TABLE . " f ON f.forum_id = t.forum_id
		WHERE f.auth_post = '1'
		AND CONVERT(t.topic_title USING utf8) LIKE '%$sebze%'
	        $ilkharfsorgu
		$fotografli
		ORDER BY $order_tipi $post_order
		LIMIT $start, " . $board_config['topics_per_page'];

$result = $db->sql_query($sql);

		while($row = $db->sql_fetchrow($result))
		{

$last_post_time = create_date($board_config['default_dateformat'], $row['topic_time'], $board_config['board_timezone']);
$forum = $row['forum_name'];
$topic_extra = $row['topic_extra'];

if ($topic_extra == "")
{
$topic_extra = "https://lezzetler.com/images/seffaf.gif";
}
		$template->assign_block_vars('topicrow', array(
		"TOPIC_TITLE" => $row['topic_title'],
		"RESIM" => $topic_extra,
		"VIEWS" => number_format($row['topic_views']) . " defa bakıldı.",
		"REPLIES" => $row['topic_replies']+1 . " adet",
		"FORUM" => "Bölüm: " . $forum,
		"LAST_POST_TIME" => $last_post_time,
		'U_VIEW_TOPIC' => "/" . make_url_friendly($row['topic_title']) . "-vt" . $row['topic_id']));
}

$template->assign_vars(array('PAGINATION' => sayfala($_GET['m'] . "-tarifleri" . $g . @$ilkharf, $topics_count, $board_config['topics_per_page'], $start)));

         $template->pparse('body');
         include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>