phpbb hack
DavsJeg forsøger at bruge nedenstående script til på, forsiden af mit site at vise de nyeste posts i mit phpBB-forum. Jeg kan dog ikke få det til at virker - det kommer ingen fejlmeddelse, men intet bliver vist.
Andre forslag til hvordan opgaven kan løses modtages gerne!
M.v.h. Søren
$ServerPath = "/var/www/html/xx/forum/config.php"; //- Not Not Include Closing \ Mark!
$urlPath = "http://www.xx.dk/forum"; //- Not Not Include Closing \ Mark!
$PostNumber = "10"; // How Many "X" Posts To Display
$type = "posts"; // Display "posts" or "topics"
//-----------------[ DO NOT EDIT BELOW HERE ]-------------------------
include_once("$ServerPath");
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection");
@mysql_select_db("$dbname",$db) or die("here we die");
if($type == "phpbb_posts")
$sql = ("SELECT t.topic_title, t.topic_id, f.forum_id FROM topics t, forums f, posts p
WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id ORDER BY post_id DESC LIMIT $PostNumber")
or die(mysql_error());
else
$sql = ("SELECT t.topic_title, t.topic_id, f.forum_id FROM topics t, forums f
WHERE f.forum_id = t.forum_id ORDER BY topic_time DESC LIMIT $PostNumber")or die(mysql_error());
if($r = mysql_query($sql, $db)) {
while($m = mysql_fetch_array($r)) {
$j = stripslashes($m[topic_title]);
$k = substr($j, 0, 20) . "...";
echo "-<a title=\"$m[topic_title]\" href=\"$urlpath/viewtopic.php?t=$m[topic_id]&sid=$m[forum_id]\">$k</a><br>";
}
}
?>
