"if posted" indicator

[arwen8]

I've recently migrated from YaBB Gold to SE- and had been using a "bold if posted" mod on the old board.  It was useful- highlighting the threads that a member had posted to... and I miss it.

I've searched for mention of a similiar mod for SE, but haven't seen anything (unless its called something completely different).

If such a mod exists, could someone refer me to it?

If one doesn't exist, I would like to try my hand at putting it together, but could use a little help with the PHP... which I will post separately in the PHP help forum.  

Thanks in advance!  

[David]

Would this replace the new indicator?

[arwen8]

Would this replace the new indicator?

No.  The "new" indicator would still mark all threads containing new messages... this would just highlight the threads (w/ new messages or not) that a member had posted to.

Sounds like a goofy little thing, but it IS handy to have the thread list load and have some sort of visual reminder of which ones you've been participating in.

I figure the same general logic that is used to indicate the new threads could be applied to this.  Though instead of cross-referencing with the logTime, it would simply need to connect member name with thread ID... and if they had posted to it, the thread title would show in bold (or with an image- maybe a dotfolder image)... if not, it would show in normal text.

But I've only been working with PHP for about a week now, so am not quite sure how to make it happen.  Yet, anyway.  

[David]

NOw I understand what you mean.  Like vB does where it puts a dot on the post icon.

[arwen8]

NOw I understand what you mean.  Like vB does where it puts a dot on the post icon.

Exactly.  Like I said... goofy little feature, but very helpful- and surely not too hard to do.  It'll be my weekend project- unless someone beats me to it.

[Gobalopper]

This should do it:

Code Select Expand

               // check if user has posted in this thread
                $postcheck = mysql_query( "SELECT ID_MSG FROM yabb_messages WHERE ID_TOPIC = '$mnum' AND ID_MEMBER = '$ID_MEMBER' LIMIT 1" );
                if( mysql_fetch_array( $postcheck ) ) {
                  $msub = "<strong>".$msub."</strong>";
                }

[arwen8]

This should do it:

Code Select Expand

               // check if user has posted in this thread
                $postcheck = mysql_query( "SELECT ID_MSG FROM yabb_messages WHERE ID_TOPIC = '$mnum' AND ID_MEMBER = '$ID_MEMBER' LIMIT 1" );
                if( mysql_fetch_array( $postcheck ) ) {
                  $msub = "<strong>".$msub."</strong>";
                }

NICE!!!!  You're a beautiful person- thank you!  

Just a note to anyone else who might want to use it... it goes in messageindex.php and you might have to change the "yabb_messages" to "whatever_messages" if you've given your database fields a different prefix.

And again- thank you!  

[Gobalopper]

Oops I forgot about that. yabb_messages could also be {$db_prefix}messages. That will work regardless what you have called your tables.

[sylvester]

so, if there are 50 topics shown @ the message-index, it will use 50(FIFTY) extra mysql-queries. That isn't nice

[Nemesis]

Welcome to the modding zone... Where all the queires you can save is a life saver!

[arwen8]

so, if there are 50 topics shown @ the message-index, it will use 50(FIFTY) extra mysql-queries. That isn't nice

Wow!  Do people actually set their boards to display that many topics?  

But yeah... I don't imagine that this feature would be practical for a large board- or for one that allows guest posting.

My board is small and doesn't have guest access, however.  Also, I keep things streamlined and have removed a lot of non-essential features for the sake of both speed and being gentle on the server.

So it's not an issue in my case... but it's good that folks with bigger full-featured boards consider the implications of using this mod on their own boards.

 

[sylvester]

so, if there are 50 topics shown @ the message-index, it will use 50(FIFTY) extra mysql-queries. That isn't nice

Wow!  Do people actually set their boards to display that many topics?  

But yeah... I don't imagine that this feature would be practical for a large board- or for one that allows guest posting.

My board is small and doesn't have guest access, however.  Also, I keep things streamlined and have removed a lot of non-essential features for the sake of both speed and being gentle on the server.

So it's not an issue in my case... but it's good that folks with bigger full-featured boards consider the implications of using this mod on their own boards.

 

ok, let's say you show 10 topics, then it will use 10 queries ONLY to check if you've posted in that topic or not.  

[arwen8]

ok, let's say you show 10 topics, then it will use 10 queries ONLY to check if you've posted in that topic or not.  

LOL!  Well... all I can say is that if it disturbs you so much, then you shouldn't use it!  

But as I said, my board is small (average of about 6-7 users at a time and most ever simultaneous users being 17), so I'm not exactly frying the server with this.

To each, her own... right?  

[sylvester]

To each, her own... right?  

Right
Suit yourself
_{End of discussion}

[groundup]

what you don't understand is that there is about 20 queries for the messageindex.  Using another 10 could pose a large load on your server.  The admin area uses 32, but people don't use that every minute.