phpBB latest post script.

**Nightmare** · 08-20-2009 07:19 PM

Okay, Maybe you guys know better than me, with google searches and such. But I honestly couldn't find a really easy copy and code code for 10 most recent topics. So I coded this and here you go.
Its basic, I know. If it was too advanced people would come here and be confused, I prefer releasing code people can copy, paste, and thank.

#Class_MySQL.php

PHP Code:


<?php



class C_MySQL 

{

    function Query( $sql )

        {

            mysql_connect( "dbhost", "dbuser", "dbpassword" );

            mysql_select_db( databasename );

            return mysql_query ( $sql );

        }

}

?>

#TopTen.php

PHP Code:


<?php

require_once("class_mysql.php");

$sql = new C_MySQL;

echo "<body link=blue vlink=blue alink=blue>";

$result = $sql->Query("SELECT `forum_id`, `topic_id` , `topic_title` , `topic_poster` , `topic_time` FROM `phpbb_topics` ORDER BY topic_time DESC LIMIT 10");

if ( mysql_num_rows( $result ) > 0 )

{

    while ( $row = mysql_fetch_array( $result ) )

    {

        echo "<font face=Verdana><a href=your_site_url/your_forum_folder/viewtopic.php?f=". $row['forum_id'] . "&t=" . $row['topic_id'] . ">" . $row['topic_title']. "</a>";

        echo "<br>";

    }

}

else

{

    die(mysql_error());

}



?>

**Smitty** · 09-12-2009 07:36 PM

Originally Posted by Nightmare

Okay, Maybe you guys know better than me, with google searches and such....

Not a bad little script here Nightmare; you should make a little write up for it, to show people how it works. Possibly show them how you've figured out what tables to look for in the database, and such.

**Nightmare** · 09-24-2009 06:35 PM

I r look in the database and it r seem logical which tables to use <3phpmyadmin

Thread: phpBB latest post script.

LinkBack

Thread Tools

Display