Latest Posts on site home page

[damsprivate]

- edited wrong post sry -

is there any diffrence where latest post if i put it in my template folder ?

[naijababy]

Thanks for the mod but I can't get it to work. I tried the code posted on the first page and all I get is a box and code on my html. I'd like to post in on the left side of my main.html page. The page has css. do i need to modify that as well? Where and how do I post this exactly?

thanks for your help guys and gals.

Here's the site. http://www.eyecityfront.com/main.html

[Bob_La_Londe]

Home page? You create a php file with the code listed. Then you use SSI to inlcude that file in the home page in the area you want.

[phpaaa]

Code: Select all

 <?php

    // How Many Topics you want to display?
    $topicnumber = 10;
    // Scrolling towards up or down?
    $scroll = "up";
    // Change this to your phpBB path
    $urlPath = "/forum";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die("Query failed");									
 
    print "<marquee id=\"recent_topics\" behavior=\"scroll\" direction=\"$scroll\" height=\"170\" scrolldelay=\"100\" scrollamount=\"2\" onMouseOver=\"document.all.recent_topics.stop()\" onMouseOut=\"document.all.recent_topics.start()\">
    <table cellpadding='3' cellSpacing='2' width='100%'>";
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 
    echo  "<tr valign='top'><td><font face=\"Tahoma\" size=\"1\"><font color=\"#FFCC00\"><b><a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" TARGET=\"_blank\">" .
    $row["topic_title"] .
    "</a></td></font></b><td><font face=\"Tahoma\" size=\"1\"><font color=\"#C0C0C0\"> by: <a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\" TARGET=\"_blank\">" .
    $row["username"] .
    "</td><td><font face=\"tahoma\" size=\"1\"><font color=\"#C0C0C0\">" .
    date('F j, Y, g:i a', $row["post_time"]) .
    "</td></tr></font>";
    }
    print "</table></marquee>";
    mysql_free_result($result);
    mysql_close($link);
    ?>

I save the above code as a testing file "test.php" and put it to the root folder of my folder.
I type in http://www.mywebsite.com/forum/test.php and press enter

YES, i saw a white page with scrolling latest topics ... MY PROBLEM ARE

when my topic contain chinese character, they all become "???????"

another minor problem is when i run it by typing "forum.mywebsite.com/test.php" but not "www.mywebsite.com/forum/test.php", it will to directed to a wrong page ~~> forum.mywebsite.com/forum/viewtopic.php?f=2 ...

WELL, the most important PROBLEM is HOW could i use this code, for example i want to put this on the "right side" or "bottom" of a html page (with other contents in the same page), just like inserting a small image? OR insert it in the index page of my forum ? I saw many people ask u this question but saw no answers. COULD U please give me some code example ?

ANYWAY, thank for your post. I just switched to phpbb3 and spend days looking for a MOD which could display a scrolling 10 active topics on the index (i've installed such a MOD in my bb2 forum). Though i can't find any similiar MOD in bb3, i think your post might achieve simliar purpose. I look forward to your answer.

Many Thank again.

[phpaaa]

anybody body here ?

[katib]

Hello
THank you very much wireaudio
I see no one

Let's see if i understand right.

You want a latest 10 active topics, NOT POSTS.
Or do you want the latest "x" active topics for ALL forums combined?
Are there any "hidden" forums you do not want info shown from?
(

Yes I want the latest "x" active topics for ALL forums combined, with forum id=3 for moderators only

Relative to the page you want the information on, where is the forum located?
Ex: If your page is in http://www.yoursite.com
and foum is in http://www.yoursite.com/forum/
the relative path would be "forum/"
(

I want it on overallheader on my forum
Also I want it scrolling form like news on TV !!
using <marquee> code

[phpaaa]

???? how to solve the language problem ? all chinese, japanese ... non-english characters became " ?????????"

[phpaaa]

THIS topic is closed ????? why nobody answer me ?????

[mkursat]

i think they used it at a phpbb forum at
http://www.maymuncuk.org joomla home page.

one with scrolling others from various topics.

[mtrs]

That is a joomla extension, different.

[phpaaa]

[quote="phpaaa"]THIS topic is closed ????? why nobody answer me ????? [/quote]

[Chaos-Zero]

I really need this code too. All of above codes didnt work for me. If i place them on to my website, my whole lay out will be messed up. Isnt there just a html code for this?

[grotevoet]

"Just HTML" will not do, as you need to use something that understands permissions. And something that recognizes/processes non-Latin1 characters.

Someone mentioned NV recent topics at the beginning of this topic, and someone replied that you could not use that on your front page. But I did, so it can be done (and is not difficult!) - check http://www.nsu.nl/ for an example.

In the installation set of NV Recent Topics there is a contrib/Addons/add_any_page/ folder with instructions. You can use the ACP to configure it (turn on/off, configure number of topics).

Marc

[marian0810]

Do you think it's possible to use that on more than one page, allowing different forum_ids to be shown for each page?

[phpaaa]

ooooh ... i finally fix the non-english character problem (have to add several new program lines) ...

i successfully inserted the php in a html page ... by using the following ...

<HTML>
<head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><title> </title></head>
<body bgcolor=#000000 link="#000000" vlink="#000000" alink="000000">

testing TOPIC RESULT
<? include("test.php"); ?>

</body>
</html>

BUT i also want to insert this PHP in another (my friend's) website. It's not the place my forum is hosting ... i tried to change the folder location in my test.php to be "http://www.mywebsite.com/forum" and also the line in my html to be <? include("http://www.mywebsite.com/forum/test.php"); ?> ... it didn't work ... i just saw a blank page ...