'Your Post' icon

[Roundboy]

How about a little icon that shows you what posts you have added to..
useful on big boards to see what disscussons you are in.

[Stud Muffin]

I think this was discussed before and would put too much stress on servers due to the amount of database queries needed.

[Roundboy]

hmm... I am thinking about codingthis and trying it..

I can't imagine it being any more of a hit since you are checking if the topic / posts have been read by you or not..

has it only been talked about and shot down.. or actually tested and shot down?

no need to re-invent the wheel

[Nemesis]

put this in messageindex.php

Code Select Expand

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


[Roundboy]

hmmm.. that works like a charm..

I did modify it to display a small .gif file instead..

so far.. no hit..

http://www.lansynergy.com/forum/index.php

[Jack.R.Abbit]

I don't know if it is better or not but I've written a slightly different version of this that does not require an additional query for each message.  What this does is query once to get a list of all topics you have posted to.  Then instead of querying each time for each message, it just checks if it is in your list.  I suppose this is trading many queries for a slice of memory but someone else will haveto decide if that is better or not.

A good place for this code is right before we enter the "Begin printing the message index for current board." blocK (the one the previously posted code went into).  This is what makes the unique list of topics you have posted to.

Code Select Expand

// get list of topics user has posted in
$postresult = mysql_query( "SELECT DISTINCT ID_TOPIC FROM {$db_prefix}messages WHERE ID_MEMBER = '7$ID_MEMBER'");
$poststack = array();
while ($row = mysql_fetch_row($postresult)) {
   array_push ($poststack, $row[0]);
}

This bit of code would go where you would have put the previously posted code.  Instead of makeing a query to check your status, it just checks to see if it is on your list.

Code Select Expand

// check if user has posted in this thread
if(in_array($mnum,$poststack))
  $msub = "<strong>".$msub."</strong>";

-Jack