Quote:
Originally Posted by Club3G
I run this on three sites and I love it - by far the best portal software of ANY forum sw out there.
I use a standard post for my front page to show the news, in a hidden forum. I assume a lot of people do it this way. On http://www.club3g.com I have a 'Car of the Month' feature that's pretty static - I just edit the post once a month and I'm golden.
However on http://www.sevenstring.org, I use it for Artist Interviews and Album Reviews. I have a hidden Forum that contains one sticky post that I use for the news. Thing is, I have almost ten reviews/interviews and they're all pretty relevant. I'd LOVE a way to randomize which post gets shown on the front page, so it cycles between, say, all of the posts in a specified forum.
Is this something doable? Thanks!
|
Quite easy:
Code:
select * from thread where forumid=X order by rand() limit 1;
You'd obviously have to incoporate the users table and the post table and so on - but if you look at the "Get News" section in vBindex you could clone it, modify the SQL to ORDER BY RAND() LIMIT 1 and you're all set to go
You could even add a new template specifically for this section and just change the fetch_template('vbindex_newsbit') to whatever the new one is.
Hope this helps,
Delphy