function get_news($db)
{
$sql = "SELECT t.topic_id, topic_poster, p.post_text, u.username, u.user_email, t.topic_time, t.topic_posts_approved, t.topic_title, t.forum_id\n" . "FROM phpbb3_topics AS t, phpbb3_users AS u, phpbb3_posts AS p\n" . "WHERE(t.forum_id = 2 or t.forum_id = 38) AND t.topic_poster = u.user_id AND t.topic_id = p.topic_id AND t.topic_time = p.post_time\n" . "ORDER BY t.topic_time DESC\n" . "LIMIT 5";
$res = mysqli_query($db, $sql);
$newstemplate = file_get_contents('templates/newsitem.html');
$news = "";
$newskeys = array('#HEADLINE#', '#BODY#', '#POSTER#', '#POSTDATE#');
while ($row = mysqli_fetch_array($res)) {
if ($row['forum_id'] == 38) {
if (preg_match('/^\\[(game|map|engine|website|misc)\\] (.*)$/', $row['topic_title'], $arr) === FALSE) {
continue;
}
if (sizeof($arr) == 0) {
continue;
}
$title = $arr[1] . ": " . htmlspecialchars_decode($arr[2]);
} else {
$title = $row['topic_title'];
}
$postlink = '/phpbb/viewtopic.php?t=' . $row['topic_id'];
$title = makelink($postlink, $title);
$newstext = link_replace(parse_bbcode($row['post_text']));
$poster = $row['username'];
$postdate = date("Y-m-d H:i", $row['topic_time']);
$newsdata = array($title, $newstext, $poster, $postdate);
$news .= str_replace($newskeys, $newsdata, $newstemplate);
}
return $news;
}
function get_news()
{
$sql = "SELECT t.topic_id, topic_poster, p.post_text, u.username, u.user_email, t.topic_time, t.topic_posts_approved, t.topic_title, t.forum_id\n" . "FROM phpbb3_topics AS t, phpbb3_users AS u, phpbb3_posts AS p\n" . "WHERE(t.forum_id = 2 or t.forum_id = 38) AND t.topic_poster = u.user_id AND t.topic_id = p.topic_id AND t.topic_time = p.post_time\n" . "ORDER BY t.topic_time DESC\n" . "LIMIT 10";
$res = mysqli_query($sql);
$newstemplate = file_get_contents('templates/newsitem.html');
$news = "";
$newskeys = array('#HEADLINE#', '#BODY#', '#POSTER#', '#POSTDATE#', '#COMMENTS#');
$i = 0;
while ($row = mysqli_fetch_array($res)) {
if ($row['forum_id'] == 38) {
if (preg_match('/^\\[(game|map|engine|website|misc)\\] (.*)$/', $row['topic_title'], $arr) === FALSE) {
continue;
}
if (sizeof($arr) == 0) {
continue;
}
$title = $arr[1] . ": " . htmlspecialchars_decode($arr[2]);
} else {
$title = $row['topic_title'];
}
$newstext = link_replace(parse_bbcode($row['post_text']));
$poster = '<a href="/phpbb/memberlist.php?mode=viewprofile&u=' . $row['topic_poster'] . '">' . $row['username'] . '</a>';
$postdate = date("Y-m-d H:i", $row['topic_time']);
$comments = '<a href="/phpbb/viewtopic.php?t=' . $row['topic_id'] . '">' . $row['topic_posts_approved'] . ' comments</a>.';
$newsdata = array($title, $newstext, $poster, $postdate, $comments);
$news .= str_replace($newskeys, $newsdata, $newstemplate);
$i++;
if ($i >= 5) {
break;
}
}
return $news;
}
