Radi sve! Nesto sam dodavao brisao ovo ono...
Napravio sam i skriptu koja prikazuje zadnje postove pa sve to skupa izgleda ovako.
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './testforum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$total_posts = get_db_stat('postcount');
$total_users = get_db_stat('usercount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];
$localhost = "localhost";
$username = "username";
$password = "pass";
$database_name = "ime_baze";
$url = "forum url"; // url do foruma
$ppath = "config"; // url do config filea od foruma
if(empty($count))
$count = "4"; //broj tema koje se prikazuju
include_once("$ppath");
$db = @mysql_connect("$localhost", "$username", "$password") or die("Nemogu spojiti s bazom");
@mysql_select_db("$database_name",$db) or die("Krivo ime baze");
$query="SELECT * FROM phpbb_topics ORDER BY `topic_id` DESC LIMIT 0, $count";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$topicid = "$row[topic_id]";
$title = "$row[topic_title]";
$forumid = "$row[forum_id]";
$replies = "$row[topic_replies]";
//ispis, promjenite URL
echo
"<a title=\"$title\" href=\"http://www.viktor.area85.net/testforum/viewtopic.php?t=$topicid&sid=$forumid\">$title</a> (<b>$replies</b>)<br>";
}
echo "Postova: $total_posts<br>";
echo "Usera: $total_users<br>";
echo "Najnoviji user: $newest_user<br>";
?>
<body>
</body>
</html>
phpBB varijable pitanje
