Clan Themes, We Make Clans Look Good!

PHP Web Host - Quality Web Hosting For All PHP Applications

www.clan-themes.co.uk :: View topic - Help with code, new forum posts

Welcome To Clan Themes
	As the board grows please remember the Search Option and we hope you find our community useful. We also monitor Private Messages to stop members from abusing our sites system. If you are asking for assistance please provide your site link and nuke version, Thanks.

Help with code, new forum posts

10 Replies / 931 Views


www.clan-themes.co.uk Forum Index » PHPBB	View previous topic :: View next topic

kardson
Reputation: 0.8
Local time: 4:19 PM
Location: Michigan

Status: Offline
0.03 posts per day
Medals: 0

Joined: Apr 28, 2008
Last Visit: 07 May 2008
Posts: 7
Points: 250

Help with code, new forum posts Posted: Fri May 02, 2008 1:51 pm

Im having a hard time figuring out how to do the following.

I want to grab the new forum posts and put them in an arrary and then display them.
This I have working, The problem is. I do not want it to show the same topic more than once.
Right now if someone posts 3 times in the same topic, it will show that topic 3 times in the block

Code:

// How many posts to display
$PostNumber = "3";

// How many characters from the title to display (0 = show complete title)
$PostLength = "0";

$query = "SELECT *
FROM nuke_bbposts, nuke_users, nuke_bbtopics, nuke_bbforums
WHERE nuke_bbposts.topic_id=nuke_bbtopics.topic_id
AND nuke_bbposts.forum_id=nuke_bbforums.forum_id
AND nuke_bbposts.poster_id=nuke_users.user_id
AND nuke_bbforums.forum_id!=7
ORDER BY post_time DESC LIMIT $PostNumber";

$content .= " ";

$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {

$topic_title = stripslashes($row[topic_title]);

if($PostLength){
$topic_title = substr($topic_title, 0, $PostLength) . "...";
}

$content .= "$row[forum_name] ";
$content .= "<a title=\"$row[topic_title]\" href=\"$urlPath/viewtopic.php?t=$row[topic_id]&sid=$row[forum_id]\">$topic_title</a> ";
$content .= "By: $row[username] ";
$content .= " ";

}

Thanks for any help, it is appreciated.

Untergang
Reputation: 603
votes: 5
Local time: 10:19 PM
Location: Lommel

Status: Offline
0.49 posts per day
Medals: 0

Joined: May 08, 2007
Last Visit: 01 Dec 2008
Posts: 285
Points: 9225

Re: Help with code, new forum posts Posted: Fri May 02, 2008 6:19 pm

You have to order the wars by topic_last_post_id
So the query becomes like this:

Code:

$query = "SELECT *
FROM nuke_bbposts, nuke_users, nuke_bbtopics, nuke_bbforums
WHERE nuke_bbposts.topic_id=nuke_bbtopics.topic_id
AND nuke_bbposts.forum_id=nuke_bbforums.forum_id
AND nuke_bbposts.poster_id=nuke_users.user_id
AND nuke_bbforums.forum_id!=7
ORDER BY topic_last_post_id DESC LIMIT $PostNumber";

kardson
Reputation: 0.8
Local time: 4:19 PM
Location: Michigan

Status: Offline
0.03 posts per day
Medals: 0

Joined: Apr 28, 2008
Last Visit: 07 May 2008
Posts: 7
Points: 250

Help with code, new forum posts Posted: Fri May 02, 2008 7:50 pm

Doesn't appear to be as simple as that.

It does still list them in order, but it still lists the same topic multiple times if the last posts were on the same topic.

I need to find a way to limit it listing the same forum topic id just once

here the the current code
is there a way to only have it list the most recent post on a forum topic just once within the array.
Or would it be an IF statement before outputting the $content

Code:

// How many posts to display
$PostNumber = "3";

// How many characters from the title to display (0 = show complete title)
$PostLength = "14";

$query = "SELECT *
FROM nuke_bbposts, nuke_users, nuke_bbtopics, nuke_bbforums
WHERE nuke_bbposts.topic_id=nuke_bbtopics.topic_id
AND nuke_bbposts.forum_id=nuke_bbforums.forum_id
AND nuke_bbposts.poster_id=nuke_users.user_id
AND nuke_bbforums.forum_id!=7
ORDER BY topic_last_post_id DESC LIMIT $PostNumber";

$content .= " ";

$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {

$topic_title = stripslashes($row[topic_title]);

if($PostLength){
$topic_title = substr($topic_title, 0, $PostLength) . "...";
}

$content .= "$row[forum_name] ";
$content .= "<a title=\"$row[topic_title]\" href=\"$urlPath&file=viewtopic&t=$row[topic_id]&sid=$row[forum_id]\">$topic_title</a> ";
$content .= "By: $row[username] ";
$content .= " ";

}

DreAdeDcoRpSE
Reputation: 738.9
votes: 5
Local time: 4:19 PM
Location: Back of your Mind

Status: Offline
1.13 posts per day
Medals: 2 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 04 Dec 2008
Posts: 497
Points: 11478

Help with code, new forum posts Posted: Fri May 02, 2008 8:31 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0

I am a little lost on what you are trying to do, are you trying to create a block to display the last few post that were made?

Or trying to add it to the forums?

Donations for custom work is appreciated at [HS]

kardson
Reputation: 0.8
Local time: 4:19 PM
Location: Michigan

Status: Offline
0.03 posts per day
Medals: 0

Joined: Apr 28, 2008
Last Visit: 07 May 2008
Posts: 7
Points: 250

Help with code, new forum posts Posted: Fri May 02, 2008 8:39 pm

It's for a block on my main page of the phpnuke site.
Such that it displays the most recent posts from the forums module.
But I do not want it to display the same topic twice, if those are the last 2 posts.

So the Block Looks like

Topic 1
Topic 2
Topic 3

not like

Topic 1
Topic 2
Topic 1

or

Topic 2
Topic 2
Topic 1

So I need to find a way to remove all but the most recent instance of each Forum Topic, and im not quite sure how to pull that off.

DreAdeDcoRpSE
Reputation: 738.9
votes: 5
Local time: 4:19 PM
Location: Back of your Mind

Status: Offline
1.13 posts per day
Medals: 2 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 04 Dec 2008
Posts: 497
Points: 11478

Help with code, new forum posts Posted: Fri May 02, 2008 11:23 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0

I do have a block that will display that last 5 post of your forums on your main page if you want it. You can see it working on my site.

Click my banner to see it.

Untergang
Reputation: 603
votes: 5
Local time: 10:19 PM
Location: Lommel

Status: Offline
0.49 posts per day
Medals: 0

Joined: May 08, 2007
Last Visit: 01 Dec 2008
Posts: 285
Points: 9225

Re: Help with code, new forum posts Posted: Sat May 03, 2008 9:07 am

Try this one
This one should work

Code:

$query = "SELECT * FROM nuke_bbtopics ORDER BY topic_last_post_id DESC LIMIT 0,$PostNumber";

mia_undertaker
Reputation: 452
Local time: 4:19 PM

Status: Offline
0.08 posts per day
Medals: 0

Joined: Jun 03, 2007
Last Visit: 29 Oct 2008
Posts: 43
Points: 766

Help with code, new forum posts Posted: Sat May 03, 2008 10:08 am
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

I think you could also use this:

Code:

$query = "SELECT *
FROM nuke_bbposts, nuke_users, nuke_bbtopics, nuke_bbforums
WHERE nuke_bbposts.topic_id=nuke_bbtopics.topic_id
AND nuke_bbposts.forum_id=nuke_bbforums.forum_id
AND nuke_bbposts.poster_id=nuke_users.user_id
AND nuke_bbforums.forum_id!=7
GROUP BY topic_last_post_id DESC LIMIT $PostNumber";

Then it will only give you one topic.

[MIA] UnderTaker
www.MIAClan.net

DreAdeDcoRpSE
Reputation: 738.9
votes: 5
Local time: 4:19 PM
Location: Back of your Mind

Status: Offline
1.13 posts per day
Medals: 2 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 04 Dec 2008
Posts: 497
Points: 11478

Help with code, new forum posts Posted: Sat May 03, 2008 12:12 pm
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0

Or you can just use this block in this post.

http://www.clan-themes.co.uk/ftopict-3547.html

Retard

mia_undertaker
Reputation: 452
Local time: 4:19 PM

Status: Offline
0.08 posts per day
Medals: 0

Joined: Jun 03, 2007
Last Visit: 29 Oct 2008
Posts: 43
Points: 766

Help with code, new forum posts Posted: Sat May 03, 2008 7:11 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

LOL. That would always be an option.

I am using the advanced forum block myself.

UnderTaker
www.MIAClan.net

DreAdeDcoRpSE
Reputation: 738.9
votes: 5
Local time: 4:19 PM
Location: Back of your Mind

Status: Offline
1.13 posts per day
Medals: 2 (View more...)

Forums Moderator

Joined: Sep 22, 2007
Last Visit: 04 Dec 2008
Posts: 497
Points: 11478

Help with code, new forum posts Posted: Sun May 04, 2008 7:09 am
Shop Purchases:Enemy Territory Theme (Aviator) for PHP Nuke · Clan Roster 2.0

Both of them work great, I just upgraded mine a few days ago.