Changeset 1309

Show
Ignore:
Timestamp:
02/05/07 15:56:41 (1 year ago)
Author:
jm3
Message:

even public links by snuffed splinkers are now hidden from search

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • feedmelinks/search.php

    r1265 r1309  
    3737                                        "SELECT * from links WHERE lcase(name) LIKE '%$searchTerm%' AND submitter='$sessionUserId' ORDER BY createDate DESC" 
    3838                                        # this query needs to pull from the master query, but the column names are different... 
    39                                         : "SELECT * from links WHERE lcase(name) LIKE '%$searchTerm%' AND (isPrivate is NULL OR submitter = '$u') ORDER BY createDate DESC"; 
     39                                        : "SELECT * FROM links, linksUsers WHERE links.submitter = linksUsers.userid AND linksUsers.snuffed IS NULL AND lcase(links.name) LIKE '%$searchTerm%' AND (links.isPrivate is NULL OR links.submitter = '$u') ORDER BY createDate DESC"; 
    4040                else if( $search_only == "users" ) 
    41                         $qs = "SELECT * from linksUsers WHERE lcase(userid) LIKE '%$searchTerm%' ORDER BY userid;"; 
     41                        $qs = "SELECT * from linksUsers WHERE lcase(userid) LIKE '%$searchTerm%' and snuffed is NULL ORDER BY userid;"; 
    4242                else if( $search_only == "tags" ) 
    4343                        $qs = "SELECT * FROM linksGroups WHERE name LIKE '%$searchTerm%' AND (isPrivate IS NULL OR userid = '$u') ORDER BY name;";