[aaronpais]

In my implementation of Pligg (v9.5), my tags are separated by a space (not by a comma). So, the related stories tab is empty.

Can someone advise as to what needs to be changed in the code to make it work?

I suspect the function added to the html1.php file needs to be changed. Here it is:

---
function related_stories($storyid, $related_tags, $category){
// this returns similar stories based on tags in common and in the same category
global $db;
$related_tags="'".str_replace(",","', '",addslashes($related_tags))."'"; //

// Select 10 stories that share tags with the current story and order them by number of tags they share
$sql = "SELECT ".table_links.".link_title, ".table_links.".link_title_url, COUNT( ".table_tags.".tag_link_id ) AS relevance, ".table_tags.".tag_link_id FROM ".table_tags.", ".table_links." WHERE ".table_tags.".tag_words IN ( ".$related_tags." ) AND ".table_tags.".tag_link_id = ".table_links.".link_id AND ".table_links.".link_status != 'discard' AND NOT ".table_links.".link_id = ".$storyid;
//comment the following line out if you want this to work accross categories
//$sql.= " AND ".table_links.".link_category = ".$category;
$sql.= " GROUP BY ".table_tags.".tag_link_id, ".table_links.".link_title, ".table_links.".link_title_url ORDER BY relevance DESC LIMIT 10";
$related_stories = mysql_query($sql);
$related_story = array();
while ($rows = mysql_fetch_array ($related_stories, MYSQL_ASSOC)) array_push ($related_story, $rows);
return $related_story;
}

---

Thx
-A

[tbones]

This is a general problem: Related Stories

[aaronpais]

I took a stab at the first part of the query.

Replace

PHP Code:

$related_tags="'".str_replace(",","', '",addslashes($related_tags))."'"; // 


with

PHP Code:

$related_tags="'".str_replace(" ","', '",addslashes($related_tags))."'"; // 


This should convert the spaces in the tags into comma separated tags. The related stories tab is still blank for me. Any SQL experts here?

I am on Pligg v9.5

Thx
-A

[aaronpais]

Ash, need your help. I just realized that I have to add commas between my tags based on the design of Pligg.

My tags is a copy of my title

In submit_step_3.tpl, I changed line 59

PHP Code:

$linkres->tags = tags_normalize_string(strip_tags(trim($_POST['title']))); 


so my tags is a copy of my title. I now need to replace the space in the tags with a comma. Would the following tweak work, Ash?

PHP Code:

$linkres->tags = tags_normalize_string(strip_tags(trim($_POST['str_replace(" ", ", ", $linkres->tags);']))); 


Thx
-A

[AshDigg]

I don't know if it will work, but there is a problem with the code

PHP Code:

trim($_POST['str_replace(" ", ", ", $linkres->tags);']) 


should be

PHP Code:

trim(str_replace(" ", ", ", $linkres->tags)) 


you don't need the $_POST or the extra ;

[aaronpais]

Thx. It is resolved....