Preview the first post in a thread first (beta defunct).

One of the things that will happen when you put your mouse pointer on to a hyperlink is put text in a popup box if you put this information into a title line.

For example:

< a href="http://www.yourplace.com" title="your text here">Here ya go< /a >

(the above is just an example to play with without the spaces in the brakets to see how this works)

At any rate. In your forumdisplay.php file right above:

eval("\$forumdisplaybits .= \"".gettemplate('forumdisplaybit')."\";");

put

$post=$DB_site->query_first("SELECT pagetext FROM post WHERE threadid=$thread[threadid] ORDER BY postid");
    $page=iif(strlen($post[pagetext])>500,substr($post[pagetext],0,500)."...",$post[pagetext]);
    $page=bbcodeparse2($page,1,1,1,1); 
    $page=strip_tags($page);

Then in your forumdisplaybit template

look for

<a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread[title]</a>

and replace this with:

<a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]" title="$page">$thread[title]</a>

The next time you get on your board and open the forumdisplay.php file and list the thread titles in your forums if you put your mouse pointer on the hyperlink to the post you will get a brief display of the first post in the thread to use as a preview.

You can play around with the order size of the pagetext from 500 to whatever you want to have displayed.

If anyone can think of anything to add to this please do. I guarantee I am a very limited coder.

Many thanks go to Chen and Bira for helping me with the coding.

Parker

[Freddie Bingham]

PHP Code:

$page = iif( strlen($message>500),substr($message,0,500).'...',$message); 


[Parker Clack]

freddie:

Thanks. But I still get the parse error at the line it is on.

BTW, will this way show old text messages that have already been written or only new posts that have been written since putting this in?

Parker

[freakyshiat]

so is there a more efficeint way of doing this?

[Parker Clack]

Well:

As stated this was too much of a demand on my server so if you have a large board I would not use this.

Anyone have a way to doing this more efficiently?

Parker

[bira]

Parker a couple more comments:

1) "$page = $thread[preview];" is redundent. place title="$thread[preview]" in your template.


2) you didn't strip out the bbcodes first, before doing strip_tags.

this:

$page = iif(strlen($message)>500,substr($message,0,500).'...',$message);
$page=strip_tags($page);

Should be:

$page = iif(strlen($message)>500,substr($message,0,500).'...',$message);
[high]$page=bbcodepase($page);[/high]
$page=strip_tags($page);

[bira]

Ah. Small problem that needs to be looked at.

1) If, for example, the first 500 characters of the opening post include something that you as an admin edit out - they will continue to appear in the preview.

2) If, for example, you split a thread then
---> a) the newly created thread will not have a preview; and
---> b) if you, for example, split the thread so as to remove the first post (say, to your trashcan forum), the that post will continue to exist in the 'preview'.


What needs to be done, is adding an additional hack code to the editpost script and the splitting action script. In both cases, when a thread is updated, the 'preview' must be updated as well.

I'm off to sleep now. I'll see if I can help you when I wake up, if that will be needed

[bira]

OK, the necessary add-ons

1) Open root/editpost.php, find:

  if ($isfirst and $title!="" and $postinfo[dateline]+$editthreadtitlelimit*60>time()) {
    $DB_site->query("UPDATE thread SET title='".addslashes(htmlspecialchars($title))."' WHERE threadid=$threadinfo[threadid]");
    //$title="";
  }

AFTER it ADD:

  if ($isfirst) {
	$page = iif(strlen($message)>500,substr($message,0,500).'...',$message);
	$page = bbcodeparse($page);
	$page = strip_tags($page);
    $DB_site->query("UPDATE thread SET preview='".addslashes(htmlspecialchars($page))."' WHERE threadid=$threadinfo[threadid]");
  }

Save and upload. This will ensure the 'preview' is also updated when the first post is edited.


2) open root/postings.php.

a) find:

  $DB_site->query("UPDATE thread SET title='".addslashes(htmlspecialchars($title))."',notes='".addslashes($threadinfo[notes])."'$pollcode WHERE threadid='$threadid'");

Replace is with (changes marked in high):

[high]  $getfirstpost=$DB_site->query_first("SELECT pagetext FROM post WHERE threadid=$threadid ORDER BY dateline LIMIT 1");
  $page = iif(strlen($getfirstpost[pagetext])>500,substr($getfirstpost[pagetext],0,500).'...',$getfirstpost[pagetext]);
  $page = bbcodeparse($page);
  $page = strip_tags($page);[/high]
  $DB_site->query("UPDATE thread SET title='".addslashes(htmlspecialchars($title))."',notes='".addslashes($threadinfo[notes])."'[high],preview='".addslashes(htmlspecialchars($page))."'[/high]$pollcode WHERE threadid='$threadid'");

This will ensure the 'preview' is updated when a thread is merged, to correctly reflect the new 1st post.

b) find:

  // Update first post in each thread as title information in relation to the sames words being in the first post may have changed now.
  $getfirstpost=$DB_site->query_first("SELECT postid FROM post WHERE threadid=$threadid ORDER BY dateline LIMIT 1");
  $DB_site->query("DELETE FROM searchindex WHERE postid=$getfirstpost[postid]");
  indexpost($getfirstpost[postid]);

  $getfirstpost=$DB_site->query_first("SELECT postid FROM post WHERE threadid=$newthreadid ORDER BY dateline LIMIT 1");
  $DB_site->query("DELETE FROM searchindex WHERE postid=$getfirstpost[postid]");
  indexpost($getfirstpost[postid]);

Replace it with (changes marked in high):

  // Update first post in each thread as title information in relation to the sames words being in the first post may have changed now.
  $getfirstpost=$DB_site->query_first("SELECT postid,[high]pagetext[/high] FROM post WHERE threadid=$threadid ORDER BY dateline LIMIT 1");
  $DB_site->query("DELETE FROM searchindex WHERE postid=$getfirstpost[postid]");
  indexpost($getfirstpost[postid]);
[high]  $page = iif(strlen($getfirstpost[pagetext])>500,substr($getfirstpost[pagetext],0,500).'...',$getfirstpost[pagetext]);
  $page = bbcodeparse($page);
  $page = strip_tags($page);
  $DB_site->query("UPDATE thread SET preview='".addslashes(htmlspecialchars($page))."' WHERE threadid='$threadid'");
  unset($page);[/high]

  $getfirstpost=$DB_site->query_first("SELECT postid,[high]pagetext[/high] FROM post WHERE threadid=$newthreadid ORDER BY dateline LIMIT 1");
  $DB_site->query("DELETE FROM searchindex WHERE postid=$getfirstpost[postid]");
  indexpost($getfirstpost[postid]);
[high]  $page = iif(strlen($getfirstpost[pagetext])>500,substr($getfirstpost[pagetext],0,500).'...',$getfirstpost[pagetext]);
  $page = bbcodeparse($page);
  $page = strip_tags($page);
  $DB_site->query("UPDATE thread SET preview='".addslashes(htmlspecialchars($page))."' WHERE threadid='$newthreadid'");
  unset($page);[/high]

This will ensure the 'preview' is updated for both threads, old and new, after splitting a thread in two.

Very nice hack Parker - I personally will use it a lot!!!

Thanks,

Bira

[bira]

This hack was released in full and can be found here. Don't use instructions in this thread - go to the 'Full Release' one.

Thanks