http://bbpress.org/forums/ bbPress support forums Topic: 1st line of the first post in a topic? en Tue, 02 Dec 2008 06:05:41 +0000 http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-3097 Thu, 11 Jan 2007 15:38:20 +0000 ardentfrost 3097@http://bbpress.org/forums/ <p><code>$first_post = $bbdb-&gt;get_results(&quot;SELECT * FROM $bbdb-&gt;posts WHERE topic_id = $topic-&gt;topic_id AND post_position = 1&quot;);</code></p> <p>That will give you the post OBJECT... from there you can pull out the text like this:</p> <p><code>echo $first_post-&gt;post_text;</code></p> <p>Or since it seems you want to pull out just the first little bit, just use a php string function to make it look and act like you want it to.</p> <p>It's not the most eloquent method, but it's certainly simple. </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-3090 Thu, 11 Jan 2007 01:01:40 +0000 nateolson 3090@http://bbpress.org/forums/ <p>Sorry, phollo, can't offer any meaningful help here, but I did just want to say that I'm interested in seeing your results. </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-3062 Tue, 09 Jan 2007 12:45:29 +0000 phollo 3062@http://bbpress.org/forums/ <p>guys, any other suggestion? :s </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-3010 Sun, 07 Jan 2007 19:20:45 +0000 phollo 3010@http://bbpress.org/forums/ <p>..<br /> by declaring <em>$bb_post = $bb_post[0];</em> i assume <em>$bb_post</em> is an array. now, since i see appearing the last post of a topic i tried to substitute that line with <em>$bb_post = end($bb_post)</em>, thinking that maybe the actual first post stayed at the end of the array; i still get the last post though.. any other suggestion? </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2998 Sun, 07 Jan 2007 17:32:03 +0000 phollo 2998@http://bbpress.org/forums/ <p>so1o, thanks, that looks better, but it grabs the last post of the topic, not the first one.. </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2996 Sun, 07 Jan 2007 16:55:38 +0000 Null 2996@http://bbpress.org/forums/ <p>Is there also a way to get a link to the first REPLY in a post? There is a link option to go to the last reply, but i wanta link ti the first reply. So the sec post (if you see them all as posts) </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2994 Sun, 07 Jan 2007 16:30:23 +0000 so1o 2994@http://bbpress.org/forums/ <p>ok..<br /> try this plugin</p> <p><code>&lt;?php<br /> function your_function_name($where) {<br /> global $topic;<br /> if ($topic) <br /> return $where . &#39; AND topic_id = &#39; . $topic-&gt;topic_id;<br /> else<br /> return $where;<br /> }<br /> function get_first_post_of_current_topic() {<br /> global $bb_post;<br /> add_filter(&#39;get_latest_posts_where&#39;,&#39;your_function_name&#39;);<br /> $bb_post = get_latest_posts(1);<br /> if(count($bb_post) == 1 ) {<br /> $bb_post = $bb_post[0];<br /> post_text();<br /> }<br /> }<br /> ?&gt;</code></p> <p>where you want call get_first_post_of_current_topic(); </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2990 Sun, 07 Jan 2007 13:36:35 +0000 phollo 2990@http://bbpress.org/forums/ <p>so1o thanks for the hint, but unfortunately i don't get any result.. </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2966 Sun, 07 Jan 2007 00:33:55 +0000 so1o 2966@http://bbpress.org/forums/ <p>try this..<br /> create a plugin with this code.. </p> <p><code>function your_function_name($where) {<br /> global $topic;<br /> return $where . &#39; AND topic_id = &#39; . $topic-&gt;topic_id;<br /> }<br /> function get_first_post_of_current_topic() {<br /> add_filter(&#39;get_latest_posts_where&#39;,&#39;your_function_name&#39;);<br /> get_latest_posts(1);<br /> }</code></p> <p>call get_first_post_of_current_topic in the loop where you show tipc name.<br /> let me know if works.. this is just a hunch</p> <p>cheers </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2962 Sat, 06 Jan 2007 22:35:17 +0000 Null 2962@http://bbpress.org/forums/ <p>You mean you want the first X characters or words from a first post?</p> <p>This is possible. I am playing with this myself so users of my bbPortal plugin can use a read more button on the portal if they want to. It wil count the first 100 words and then ad a read more link.</p> <p>Think this is something you want (without the read more link). This can be done with a plugin and a new function. I haven't got something working yet else I would post it here... </p> http://bbpress.org/forums/topic/1st-line-of-the-first-post-in-a-topic#post-2960 Sat, 06 Jan 2007 22:19:22 +0000 phollo 2960@http://bbpress.org/forums/ <p>Hi guys,</p> <p>Is there a way i can get the first "n" characters of the first post in a topic so i can make them appear in the forum main page, under each topic's title?</p> <p>Thanks!<br /> :)phollo </p>