Changeset 330
- Timestamp:
- 06/23/08 18:33:00 (5 months ago)
- Files:
-
- notification/lib.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
notification/lib.php
r286 r330 31 31 $posts_checked = ''; 32 32 $posts_and_comments_checked = ''; 33 myuserid = $_SESSION['userid']; 33 34 $query = <<< END 34 35 SELECT n.comment_notification AS comment_notification 35 36 FROM {$CFG->prefix}notifications n INNER JOIN {$CFG->prefix}notification_objects no ON(no.ident = n.notification_object_id) 36 37 WHERE no.owner = $pg_owner AND no.object_type = '{$item->object_type}' 38 AND n.owner = $myuserid 37 39 END; 38 40 $results = get_record_sql($query); … … 142 144 SELECT n.ident FROM {$CFG->prefix}notifications n 143 145 INNER JOIN 144 {$CFG->prefix}notification s no146 {$CFG->prefix}notification_objects no 145 147 ON (no.ident = n.notification_object_id) 146 148 WHERE no.owner = $object_owner
