Add node_access API compatibility

ec - January 9, 2006 - 17:59
Project:Similar Entries
Version:4.6.x-1.x-dev
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active
Description

Hello,
Similar seems not to be working with node_acess API. In function _similar_content() I need to add db_rewrite_sql(). Just replace

$result = db_query_range('SELECT n.nid, n.title , match(n.body, n.title) AGAINST ("%s") AS score FROM {node} n WHERE MATCH(n.body, n.title) AGAINST ("%s") AND n.nid <> %d ORDER BY score DESC', $text, $text, $similar_node_nid, 0, 5);

with

$result = db_query_range(db_rewrite_sql('SELECT n.nid, n.title , match(n.body, n.title) AGAINST ("%s") AS score FROM {node} n WHERE MATCH(n.body, n.title) AGAINST ("%s") AND n.nid <> %d ORDER BY score DESC'), $text, $text, $similar_node_nid, 0, 5);.

Hope, this help.
eric

#1

ec - January 9, 2006 - 18:01
Priority:critical» normal

sorry, set it to normal. and may be it could apply for 4.7 ?

#2

deekayen - April 14, 2006 - 09:41

I don't understand what exactly db_rewrite_sql() would add in functionality. db_query_range() already does some rewriting. Do you mind elaborating on the need for this change?

#3

ec - May 9, 2006 - 16:58

Hy, db_rewrite_sql() takes care of permissions and let you see only the pots you have the right to see. It's usefull for ewample if you use thinks like og or tac to keep some posts private. eric

#4

ec - May 17, 2006 - 16:04

try to do the same thing for 4.7 but the query doesn't work anymore !! any idea ? regards, eric.

 
 

Drupal is a registered trademark of Dries Buytaert.