From 2d68d866271f9380afd4bd324ee989fc62c8adc9 Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Mon, 31 Aug 2009 15:41:13 +0000
Subject: [PATCH] fixed bug with closed notes appearing in (View All)

---
 interface/main/authorizations/authorizations.php | 2 +-
 library/pnotes.inc                               | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/interface/main/authorizations/authorizations.php b/interface/main/authorizations/authorizations.php
index a2d9a1fd9..671c170f8 100644
--- a/interface/main/authorizations/authorizations.php
+++ b/interface/main/authorizations/authorizations.php
@@ -95,7 +95,7 @@ $_GET['show_all']=='yes' ? $lnkvar="'authorizations.php?show_all=no' name='Just
 <div id="pnotes">
 <?php
 // Retrieve all active notes addressed to me (or to anybody)
-$_GET['show_all']=='yes' ? $usrvar='' : $usrvar=$_SESSION['authUser'] ; 
+$_GET['show_all']=='yes' ? $usrvar='_%' : $usrvar=$_SESSION['authUser'] ; 
 if ($result=getPnotesByDate("", 1, "id,date,body,pid,user,title,assigned_to", '%', "all", 0, $usrvar))
 {
   echo "<table border='0'>\n";
diff --git a/library/pnotes.inc b/library/pnotes.inc
index 90c851be4..3fc932841 100644
--- a/library/pnotes.inc
+++ b/library/pnotes.inc
@@ -19,7 +19,7 @@ function getPnotesByDate($date, $activity = "1", $cols = "*", $pid = "%",
   if ($activity != "all")
     $sql .= "AND activity = '$activity' ";
   if ($username)
-    $sql .= "AND assigned_to = '$username' ";
+    $sql .= "AND assigned_to LIKE '$username' ";
   $sql .= "ORDER BY date DESC";
   if($limit != "all")
     $sql .= " LIMIT $start, $limit";
-- 
2.11.4.GIT