|
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 |
|
|---|