[release] Last news event on forumhome

[filburt1]

Author: filburt1
Description: Displays (including links where appropriate) the title, author, and number of posts of the last thread of the forum of your choice on forumhome.
Demo: http://www.webdesignforums.net/?styleid=3
Screenshot: http://www.vbulletintemplates.com/mods/attachment.php?s=&postid=14293

If you install this mod then please click here (misc.php?s=&action=install&threadid=1787)

This adds one query to forumhome only.

[filburt1]

Screenshot:

[Tony G]

Nice mod. :)

[LoRDsTaR]

yeah, very nice mod!!

[imported_TMG1]

What's happening at TMG Message Boards?
Last news event: by with no replies.

but on the calendar it has Halloween, so it aint working.

[Brad]

This is based on forumid, not the calendar.

[imported_TMG1]

im still not sure how it really works :(

[filburt1]

It queries the database, pretty simple.

[imported_TMG1]

In english for dumbasses like me lol

[filburt1]

As the instructions say the only thing you have to change in the script is $newsforumid; you change it to the id of the forum you want the script to grab the news from. Since I don't see any news or annoucements forum I don't see how you could use this template edit...

[imported_TMG1]

you should make one that takes news from the calendar that would be tight. this is a good mod tho but not what i thought

[filburt1]

Displays (including links where appropriate) the title, author, and number of posts of the last thread of the forum of your choice on forumhome

Sounds clear to me :p

Check out the lounge though.

[csthiang]

Originally posted by filburt1
As the instructions say the only thing you have to change in the script is $newsforumid; you change it to the id of the forum you want the script to grab the news from. Since I don't see any news or annoucements forum I don't see how you could use this template edit...
How do I know what is my $newsforumid ??

[filburt1]

View the forum you want; the forumid is the number in the URL that follows &forumid= .

[csthiang]

Originally posted by filburt1
View the forum you want; the forumid is the number in the URL that follows &forumid= .
Still cannot,only the heading shows,it did not even show the cannot get event message when I input the wrong $newsforumid

[filburt1]

Did you make $newsforumid = 6?

[Aaron1]

This is a great mod, thank u! I pressed install!

Is it also possible, to have 2 or 3 latest postings items on the homepage?

[filburt1]

It's possible but requires modification of the query and other code in phpinclude.

[Aaron1]

Is it hard to do?

But that would be cool, to have the top 3 latest postings (from your selected forum) on your homepage.

I added views and lastposter to it aswell. Take a look if you want.
Hmm, i will add a txt file.

[stark427]

Thats a great mod Filburt :)

I have a forum where the members write live reviews.... and I will probably install the mod changing it to :"Latest Live Reviews"

Is there any possibility this can be converted so that it will recognise the topics from the subforums of a forum? What I mean is this:

I have a main forum called : SPA reviews. Within that, I have 3 subforums.
1) Concerts
2) Album reviews
3) Interviews

the main forum is closed for writing... so when I enter the ID of this forum... it does not find any thread - 100% logical.
Is there a way it could take threads from the 3 subforums - which the main forum is comprised of?

Also one question : this mod adds one query at the forumhome. Is that going to be bad for the server loads? Im running my board on a shared server... so I'm kind of afraid :)

thanx in advance
clicked "install"

stark

[filburt1]

It is possible to recognize subforums but (just remembering the schema from my head) would require additional queries.

One extra query on forumhome on a shared server isn't a big deal with the normal number of queries there, it's if you add, say, 10 more, than you should be worried.

[imported_Eternale]

hmm it dont work for me, i did everything right

[filburt1]

Well obviously you didn't ;)

How doesn't it work?

[filburt1]

Originally posted by Eternale
hmm it dont work for me, i did everything right

FYI your site in your profile links to a porn site so I'd suggest you yank that out of your profile now.

[imported_Eternale]

LOL my bad it was a Old site i had. I had a attachment guess it didnt work, il try it agian

[imported_Eternale]

Here it should work now :D

[filburt1]

Did you put all the necessary code in phpinclude?

[stark427]

Mine works great. :)
I did some tweaks on the code (simple things) to change the appearance a bit , and here it is :

[Smoothie]

Nice one! Installs...

[Red Shadow]

yours has multiple pages on it, how do u do that?

[Sanctum]

simple sweet and no vbportal necessary. Thanks for the submission ...install :)

[Smoothie]

Hey filburt, I know this has been asked, but have you looked into getting more than one news event displayed? Like maybe the 5?

[filburt1]

It can be done (change LIMIT 1 to LIMIT 5 and then put parts of the code in a for loop) but I don't have the time.

[NickieNonstop]

Nice one Filburt! But is it also possible to display the body/contents of the newspost?

[filburt1]

Not without using an additional query.

[NickieNonstop]

Can you tell me how to setup this query?

[stark427]

Filburt

I have not been using the reply count and userinfo status at the $lastnews

which means that my $lastnews is :



$lastnews = "Last news event: <a href=\"showthread.php?s=$shash&threadid=$threadid\">$title</a>"


So I guess there are some lines at the following code - to be included at the phpincluded that are not needed in my case, right?
Could you please tell me which of them are not needed so that I could remove them?

(I guess these lines being there is no harm, but If I can remove any code I don't need from the template, I would be glad to do it ) :)

don't post attached file contents --filburt1

thanx in advance