I would much rather help someone that is at least trying to do it on their own then just write it for someone.
The problem you have here is that you are trying to connect to the MySQL db on your own, let the vB engine do that. If you look in admin/db_mysql.php there is already a class designed for this, (Plus if you look in any vB file you can see this being used). Whenever you load the global.php several things happen automatically. First as persistant connection is opened to the db server, so no need for that. Next variables are for who the person is and session stuff. When reading through the files be sure you also read through any included files. What I did when I began writing the hacks (granted I only started two weeks ago) I printed out all the common files, global.php, functions.php, session.php and then the index.php from the forum dir. Then I just started at the global.php and read through. If I came to a new function that wasn't a PHP function I found that function definition and parsed it in my mind. Doing this will just give you a general understanding of how it all works.
Now what you are trying to do would be changed to this.
PHP Code:
<?php
chdir( "./forum");
require( "./global.php");
chdir( ".." );
/* Note: anytime you include global.php you must include it at the beginning
before any output it sent. The way around this would be to set output buffering
in the php.ini file, however a better practice would be to just get in the habbit of
including it before you send any PHP or HTML output. */
?>
<HTML>
<BODY>
<?php
$recentThreads = $DB_site->query( "
SELECT threadid, dateline, title
FROM thread
WHERE visible=1 AND open=1 AND dateline!=4294967295
ORDER BY dateline DESC LIMIT 5"
);
while ( $thread = $DB_site->fetch_array( $recentThreads ))
{
$output .= "<a href=\"/forum/showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]\">$thread[title]</a><br>";
}
dooutput( $output );
?>
</BODY>
</HTML>
Now this is still incomplete. You would want to add permissions checking to the thread, look at the forumdisplay.php and index.php files. You will want to first check the user has permission on the forum the thread is in (use the forumid element of the thread table) and then make sure the thread is visible ( visible element of the thread table).
03-04-2001, 12:06 PM
Threaded Mode