root/feedmelinks/_deprecated/isPrivateLinkFunc

Revision 409, 0.7 kB (checked in by hirokai, 4 years ago)

feh

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1 #FIXME DEBUG THIS CONNECTION BULLSHIT
2 function isPrivateLink( $argID ) {
3     $con_isPrivateLink = mysql_connect();
4     mysql_selectdb( getDBName() );
5
6     $qs = "
7       SELECT COUNT(*)
8         FROM links
9           LEFT JOIN linksCategoriesXRef
10             ON links.ID = linksCategoriesXRef.linkID
11           LEFT JOIN linksGroups
12             ON linksGroups.ID = linksCategoriesXRef.catID
13           WHERE
14             links.ID = $argID
15             AND
16               (links.isPrivate IS NOT NULL
17                 OR
18                 (linksGroups.name NOT LIKE 'p/%' AND linksGroups.name NOT LIKE 'p%%F%')
19               );";
20
21   $q = mysql_query( $qs );
22   $count = $q ? mysql_result($q,0) : 0;
23   conClose( $con_isPrivateLink );
24   return $count;
25 }
26
Note: See TracBrowser for help on using the browser.