Recently Added Posts

[T3XT3]

[quote name='Μichael' date='19 October 2009 - 03:04 PM' timestamp='1255961066' post='1868755']
The reason that wouldn't function is that your idea does nothing to check permissions. Exactly which posts do you propose should be stored in this table?
Of course every post. Maybe add another column with the group IDs of the groups who have permission to see it or the forum the topic/post is stored in and increase the number of the stored posts to 50. That way you could possibly check the permissions.

But you are the creative geniuses, not I... :unsure:

[T3XT3]

Or just another suggestion:

In a newly added first table will be saved the last 10 posts for every user group / permission set (add a column group_ID). 10 entries for every group ID. In another table will be saved the last update of the first table for every user group. So: every time when a user loads the sidebar, first it will be checked how long ago was the first table for this group (the user belongs to) updated on basis of the second table. If it is over 5 minutes ago, the resource intensive query will be done in respect of the permissions of the user group. The 10 old entries of this group will be deleted from the first table, data of the 10 newest entries inserted. The last update time in the second table will be updated. For the next five minutes every member of this specific group will draw the data of the last 10 posts from the first table. The next intensive query will be in 5 minutes.

Means: Every group will every 5 minutes strain the database a bit.

[Donkerrood]

On our forums We have scaled the recently added posts down to a one-line per topic list, based on this
SELECT required_info FROM topics ORDER BY last_post DESC LIMIT 0,10
and a check whether the topic is visible to the user or not.

That's it, we do not include user info, but only the time of the post and the topic title..

[T3XT3]

Nice idea! Well - who is making the mods now to all of these suggestions?

[ikillbill]

I don't think resources should be the issue as you could set it up like Drupal or like RSS function with proper caching system


only pull posts every XX minutes


We setup to let drupal to pull IPB forum posts every 120 minutes, not big deal on server resources really

[Michael]

On those sites where resources would be an issue (ie. really busy ones), it doesn't make sense to show a block that would potentially have old cached data, you'd want real-time fresh results since it's going to change so often.

[3DKiwi]

Update: I'm up and running with a Recent Posts block. With the input of a couple of members I've got a recent posts block on my Portal front page that update recent posts every 60 seconds. So far there have been no CPU resource issues. Those interested can find out a bit more here. The IP Content system was used to create a feed. It's then just a matter of placing the generated Recent Post tag in your skins whereever you want the block to go.

Those wanting the block to update in real time can have that if they wish. It's also very easy to create a recent topics block where you control over the number of recent topics to display in the block.

3DKiwi

[Mat Barrie]

[quote name='Μichael' date='24 October 2009 - 12:18 AM' timestamp='1256300289' post='1870462']
On those sites where resources would be an issue (ie. really busy ones), it doesn't make sense to show a block that would potentially have old cached data, you'd want real-time fresh results since it's going to change so often.


Hah. I just found out that some crazies do it anyway. There's clearly demand still - even with massive corporates ;)

3DKiwi, {parse block} works in the IPB skin templates too?!? Huh. Must try that.

[3DKiwi]

I run a reasonably active board and I'm not experiencing any resource issues. (dedicated server) I was with the recent posts hook in the resources section here and had to uninstall it. I have mine refreshing every 60 seconds. I could probably have it updating on demand and not have any problems.

3DKiwi

[Ocean West]

I don't want a block of this info but actually i want a page that pulls the details, of Recent activity, New Content.

But be able to step back thru dates.

This is a mod i have on my site (other forum software ) and can't for the life figure out were to begin on how to adapt it on IPB

http://www.screencast.com/users/oceanwest/folders/Jing/media/017e87dd-062c-4f03-bc8c-bc968bf74ab5

http://fmforums.com/forum/recent_activity.php?type/posts/

[optrexnz]

[quote name='Stephen D' date='10 November 2009 - 04:52 AM' timestamp='1257828743' post='1877683']
I don't want a block of this info but actually i want a page that pulls the details, of Recent activity, New Content.

But be able to step back thru dates.

This is a mod i have on my site (other forum software ) and can't for the life figure out were to begin on how to adapt it on IPB

http://www.screencast.com/users/oceanwest/folders/Jing/media/017e87dd-062c-4f03-bc8c-bc968bf74ab5

http://fmforums.com/forum/recent_activity.php?type/posts/


Stephen, there are feeds built into IP Content. Create the page and just change the template to display how you want it too.

see

http://www.nzweather.net/stephentopics.html topics test
http://www.nzweather.net/stephenposts.html posts test

failing that do what I suggested in your other post and have links to the active topics searches at the bottom of the main index page
http://community.invisionpower.com/index.php?app=core&module=search&do=active

[Ocean West]

[quote name='optrexnz' date='09 November 2009 - 11:50 PM' timestamp='1257839402' post='1877707']
Stephen, there are feeds built into IP Content. Create the page and just change the template to display how you want it too.

see

http://www.nzweather.net/stephentopics.html topics test
http://www.nzweather.net/stephenposts.html posts test

failing that do what I suggested in your other post and have links to the active topics searches at the bottom of the main index page
http://community.invisionpower.com/index.php?app=core&module=search&do=active


thanks for the links but the "feed" is - please take no offense - just 'ugly' and does't even resemble a forum but rather a "rss reader" i wish for a more integrated user experience one that they are familiar with in regards graphical interface they face with when they read the forums in a hierarchal method, form the TOP DOWN - Category - Forum - Subforum - Topic - Reply....

My wish is for more interactive approach users being able to tangibly choose and display data as requested. After all the content of the site is database and should be able to be displayed in a fashion that users are expecting -reverse chronological order - non in a structured fashion. There are different users that use forums one that is topic driven and can circumnavigate a sites hierarchy, to zero into their desired destination. And then their the power users who want to consume all content as it comes in regardless where - either as their duties a moderator or just because that is the way we've done it for nearly a decade and that's why i wish to keep it ;)

The link at the bottom is a step closer in getting some of the information - however i am getting frustrated trying to understand the entire underpinnings of the engine as it is - to no fault of yours or IPS it just VERRY different architecturally structured engine from what i am use to. So please, forgive me if I am a bit out of sorts, but I am trying shift not only a site over but understand if I can even provide feature enhancements as I haven't yet found the "Dummy's Guide™ To Hacking IPBoard™" ( tongue firmly planted in cheek )

sd

[optrexnz]

[quote name='Stephen D' date='10 November 2009 - 10:13 AM' timestamp='1257848019' post='1877722']
thanks for the links but the "feed" is - please take no offense - just 'ugly' and does't even resemble a forum but rather a "rss reader" i wish for a more integrated user experience one that they are familiar with in regards graphical interface they face with when they read the forums in a hierarchal method, form the TOP DOWN - Category - Forum - Subforum - Topic - Reply....


no worries about that. It's taken me 6 months to get to this stage after moving from another forum software so I know exactly where you are coming from. The feed view is generated from a basic template.



Its basically a case of editing here to get it to view how you want it too, granted thats the hard part, but I am sure that there would be plenty of help and you would get to understand the engine more. Due to version 3 not being that old there is no dummies guide yet, but as you can see more and more people are having a go as the weeks go by.

The page http://www.nzweather.net/links.html?category=7 is created in IP.Content too as as you can see at the bottom there are filters and sorting options, so its definately a possible ;)

<div class='general_box'>

	<h3>{$title}</h3>

	<ul class='hfeed'>

		<if test="is_array( $records ) && count( $records )">

		{parse striping="feed_striping" classes="row1,row2 altrow"}

		<foreach loop="$records as $r">

		<li class='hentry {parse striping="feed_striping"}'><a href='{$r['url']}' rel='bookmark' title='{$r['title']}'>{$r['title']}</a>

			<br /><span class='date'><abbr class="published" title="{parse expression="date( 'c', $r['date'] )"}">{parse date="$r['date']" format="short"}</abbr></span>

			<span class='desctext'>{IPSText::truncate( strip_tags($r['content']), 200 )}</span>

		</li>

		</foreach>

		</if>

	</ul>

</div>

<br />