Page 1 of 1
PHPBB грешно време!
Posted: 22 Jan 2019, 04:29
by Sithy
Re: PHPBB грешно време!
Posted: 22 Jan 2019, 11:51
by iVoka
С коя функция изкарваш датата?
Re: PHPBB грешно време!
Posted: 31 Jan 2019, 08:50
by Sithy
Също и не ми извежда автор, не знам защо eто кода:
Code: Select all
<?php
$results = mysql_result(mysql_query("SELECT COUNT(`topic_id`) FROM `$bb_db`.phpbb_topics WHERE forum_id='$newsid'"), 0);
if ($results > 0) {
$pagination = pagination($results, array(
'per_page' => 5, // Резултати на страница.
'get_vars' => array(
'p' => (int) @$_GET['p']
)
));
$sql = mysql_query("SELECT t.topic_id, t.topic_posts_approved, t.topic_title, t.topic_last_post_id, t.forum_id, p.enable_smilies, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid, p.enable_bbcode, p.post_id, p.post_text, p.poster_id, p.post_time, u.user_colour, u.user_id, u.username
FROM `$bb_db`." . $bb_prefix . "_topics t, `$bb_db`." . $bb_prefix . "_forums f, `$bb_db`." . $bb_prefix . "_posts p, `$bb_db`." . $bb_prefix . "_users u
WHERE
t.forum_id = $newsid AND
f.forum_id = t.forum_id AND
t.topic_id = p.topic_id AND
p.post_id = t.topic_first_post_id AND
p.poster_id = u.user_id
ORDER BY p.topic_id DESC LIMIT {$pagination['limit']['first']}, {$pagination['limit']['second']}") or die(mysql_error());
while ($row = mysql_fetch_array($sql, MYSQL_ASSOC)) {
$title = $row['topic_title'];
$text = generate_text_for_display($row['post_text'], $row['bbcode_uid'], $row['bbcode_bitfield'], 7, true, true, true);
$author = $row['topic_first_poster_name'];
$views = $row['topic_views'];
$data = date("d.m.Y - H:i:s", $row['topic_time']);
echo '
<div class="forum" style="width:588px;padding-bottom:12px">
<div class="newshead" style="height:30px;display:none">
<span style="float:left;padding:6px 10px">29.10.2012 um 17:50 Uhr</span>
</div>
<div style="width:150px;float:left;padding:5px"><img src="/img/picture-13.jpg" style="margin:-3px 0 0 -3px" alt="" /></div>
<div style="width:415px;float:right;padding:5px">
<center><div class="newstitle" style="height:16px;padding:0 0 14px 0;overflow:hidden"><h1>'.$title.'</h1></div></center>
<div style="height:128px;overflow:hidden">'.$text.'<br />
<br />
</div>
</div>
<div class="news_bottom">
<span style="float:left">'.$data.' <a href="#" >'$author'</a></span>
<div class="news_button">
<span class="readmore"><a href="forum/viewforum.php?f=2">Виж повече!</a></span>
</div>
</div>
</div>
';
}
} else {
echo "
Няма добавени новини
<br />
Все още няма добавени новини";
}
?>
Re: PHPBB грешно време!
Posted: 13 Oct 2019, 15:11
by Jeff
Коя версия на phpbb използваш?