boardom

[GamerZ]

I have created a related stories feature that will automatic such the headlines and display 5 related stories(default).

Copy the function and put it inside b2template.functions.php

If you want to exclude some search word, just add it in the $exclude array.

To use it just use [php:1:388f58132d]<?php relatedstories(); ?>[/php:1:388f58132d] outside b2 loop.


If you want 10 related stories just add in 10 which becomes[php:1:388f58132d]<?php relatedstories(10); ?>[/php:1:388f58132d]

Here is the function:
[php:1:388f58132d]
function relatedstories($howmanystories=5) {
global $tableposts, $siteurl,$blogfilename, $id, $querystring_start, $querystring_equal, $querystring_separator;
$titlesearch = get_the_title();
$exclude = array ("A", "Are", "Do", "It", "Its", "Is", "In", "I", "My", "The", "To", "With", "You");
$qry = "SELECT DISTINCT ID, DATE_FORMAT(post_date, '%e/%c/%y'), post_content, post_title FROM $tableposts WHERE (";
$titlesearch = preg_replace('/, +/', '', $titlesearch);
$titlesearch = trim($titlesearch);
$words = explode (" ", $titlesearch);
$words = array_diff($words,$exclude);
foreach ($words as $word) {
$qry .= "(post_content LIKE '%$word%' OR post_title LIKE '%$word%') OR ";
}
$qry = substr ($qry, 0, strlen ($qry) - 4);
$qry .= ") AND (ID != $id) ORDER BY post_date DESC LIMIT $howmanystories";
$sql = mysql_query($qry);
while ($relatedstories = mysql_fetch_row($sql)) {
echo "<b>»</b> <a href=\"".$siteurl."/".$blogfilename.$querystring_start."p".$querystring_equal.$relatedstories[0].$querystring_separator."c".$querystring_equal."1\">";
echo stripslashes($relatedstories[3]) ."</a>";
echo " (".$relatedstories[1].")";
echo "<br>";
}
}
[/php:1:388f58132d]
_________________

++ GamerZ.Per.Sg - Complex Simplicity

[turtelina]

Hi Gamerz,

I installed it. It´s awesome!!! Thank you so much for sharing it!

[GamerZ]

[JEDOK]

it's a nice idea and works fine. but, there is just one bug.

if the title is consisted of the excluded words(words in $exclude array) only, the error occur

example: when i put "I", "love", "you" in $exclude array and write a post titled "I love you", then,

[GamerZ]

[Cyberian75]

I don't understand the concept of this hack. Related stories of what?
_________________
Michael P.

[BDKR]

Cool hack!

[dtdgoomba]

i think the hack finds stories within your site that are 'related' to your current post by finding similar phrases/words in other posts? Is that it?

[Cyberian75]

Oh, I guess it uses the latest post. Yeah? What a great idea . . .
_________________
Michael P.

[GamerZ]

it just seacrh thru the DB for content or title tt matches the current blog subject and displays it in order of date.

You can exclude some words tt dun want to be searched
_________________

++ GamerZ.Per.Sg - Complex Simplicity

[annia]

i love that hack :) it works good for me

[Cyberian75]

I get . . .

[GamerZ]

[Cyberian75]

At line 17 of your function...
_________________
Michael P.

[GamerZ]