Show whats going on in forum

nipe

Hi,

I forund a free forum script online. Now I would like to show on my frontpage the latest post and link to the post.

It lshould show this:

Title
name
Texst (max 100 string)
date and time

I have succeded in this to some extent... If the latest post is a reply then I would like it to show the title of the parent post. The db is made so that if it's not a thread but a reply then it gets a parent value that matches the id of the parent. If it's a new thread the parent gets a value of 0.

I come along way considering my low programming skills. I have come so far

If its a new thread (parent = 0) then it shows just fine.

However if its a new reply (parent = id for the thread commented) I can only make it show like this

Name
Tekst (max 100 string)
Date and time
Title

Apparently my coding is not that good because I'm not able to show the new reply's parent title on the top. Whatever I try it dosent work.

PLEASE HELP ME!

My code looks like this:
==================START OF CODE=============================
<?php
function cut($str,$size=99){
if(strlen($str) > $size){
$str = substr($str, 0, $size)."...";
}
return $str;
}
?>
<?php
include('config.php');
$q = mysql_query("SELECT name,message,id,header,parent,date_format(date, '%d-%m/%H:%i') AS date FROM bkforum ORDER BY id DESC LIMIT 1") or die(mysql_error());
while($r = mysql_fetch_array($q)){
if ($r[parent] == 0) {
echo "<a href='laes.php?id=$r[id]'>$r[header]</a> ";
echo "Af " . $r['name'] . ": " ;
echo cut($r['message']);
echo " (" . $r['date'] . ")" ;
} else {
include('config.php');
$q = mysql_query("SELECT name,message,id,header,parent,date_format(date, '%d-%m/%H:%i') AS date FROM bkforum ORDER BY id DESC LIMIT 1") or die(mysql_error());
while($r = mysql_fetch_array($q)){
echo " $na" ;
echo "<a href='laes.php?id=$r[parent]'> Overskrift Af " . $r['name'] . ": " . cut($r['message']) . " (" . $r['date'] . ")</a>";
$np = $r[parent] ;
$query = mysql_query("SELECT id,header,message,name,DATE_FORMAT(date,'%e/%c-%y %T') AS id FROM bkforum WHERE id = $np ORDER BY id DESC LIMIT 1") or die(mysql_error());
if (mysql_num_rows($query) == 0) {
echo 'Der er ingen tråde i forummet! ';
} else {

while($row = mysql_fetch_assoc($query)) {
	$na = $row[header] ;
	echo "<br><b>$na</b>" ;
}

}
}
}
}

?>
======================END OF CODE=========================

dougal85

For a start can you put your PHP code between [ p h p ] and [ / p h p ]

You could always do a SELECT from the database ordered by the ID. Assuming that the biggest ID is the newest post...

nipe

As far As I know thats what I'm doing here:

AS date FROM bkforum ORDER BY id DESC LIMIT 1")

The prob is when the newest id is a reply and therefore has no headline - I then have to take the parents id - all this I have done but its done in a order that dosent allow me to put the title of the thread on the top if its a reply and not a new thread.

With regards to the php brackets what will it do? - all my coding works - its just a matter of ordering the output that seems to confuse me, because I first find the newest post and then from this post if its not a thread (parent =0) then tries to figure out what title belongs to reply - what i do is I call the parent number which is the id of the original post and saves it as $np = $r[parent] ; I then use this in the query FROM bkforum WHERE id = $np ORDER BY id DESC LIMIT 1") in order to find the heading from the original post. It works but its a wild guess and seems impossible for me to get in the order so it stands like this

Title
name
Texst (max 100 string)
date and time

instead of

name
Texst (max 100 string)
date and time
Title

halojoy

nipe wrote:
With regards to the php brackets what will it do?
- all my coding works - its just a matter of

This is what it will do, in this forum.

It makes us easier see , in Colours what your code is like, any errors etc. etc:
So use our forums PHP tags, please:
php
...code ...
/php

thanks!

<?php
function cut($str,$size=99){
if(strlen($str) > $size){
$str = substr($str, 0, $size)."...";
}
return $str;
}
?>
<?php
include('config.php');
$q = mysql_query("SELECT name,message,id,header,parent,date_format(date, '%d-%m/%H:%i') AS date FROM bkforum ORDER BY id DESC LIMIT 1") or die(mysql_error());
while($r = mysql_fetch_array($q)){
if ($r[parent] == 0) {
echo "<b><a href='laes.php?id=$r[id]'>$r[header]</a></b><br>";
echo "<i>Af " . $r['name'] . "</i>:<br />" ;
echo cut($r['message']);
echo "<br />(" . $r['date'] . ")" ;
} else {
include('config.php');
$q = mysql_query("SELECT name,message,id,header,parent,date_format(date, '%d-%m/%H:%i') AS date FROM bkforum ORDER BY id DESC LIMIT 1") or die(mysql_error());
while($r = mysql_fetch_array($q)){
echo "<br><b>$na</b>" ;
echo "<a href='laes.php?id=$r[parent]'> Overskrift<br>Af " . $r['name'] . ":<br>" . cut($r['message']) . "<br>(" . $r['date'] . ")</a>";
$np = $r[parent] ;
$query = mysql_query("SELECT id,header,message,name,DATE_FORMAT(date,'%e/%c-%y %T') AS id FROM bkforum WHERE id = $np ORDER BY id DESC LIMIT 1") or die(mysql_error());
if (mysql_num_rows($query) == 0) {
echo 'Der er ingen tråde i forummet!<br>';
} else {

while($row = mysql_fetch_assoc($query)) {
$na = $row[header] ;
echo "<br><b>$na</b>" ;
}
}
}
}
}


?>

bpat1434

If may interject. Perhaps you should look at other forum software. I know SMF has a script with functions made specifically for this purpose (see example). That front-page is specifically posts and data about the forum, nothing more. And it's all with included functions from SMF itself.

I'm not sure if phpBB has anything like this, but I would expect it does; or, there's a mod for it.

halojoy

bpat1434 wrote:
If may interject. Perhaps you should look at other forum software. I know SMF has a script with functions made specifically for this purpose (see example). That front-page is specifically posts and data about the forum, nothing more. And it's all with included functions from SMF itself.

I'm not sure if phpBB has anything like this, but I would expect it does; or, there's a mod for it.

Yes, probably quite many mods or scripts to do it, in phpBB.
A quick search:phpbb "last posts" OR "latest posts" Google
.. gives even a 'Standalone Script' for this.
It is said Work in BOTH phpBB2 and The new better phpBB3
Link to that one script:
Latest-posts. Standalone For-phpbb3-and-phpbb2

halojoy