more array munging

[quix0rs-gnu-social.git] / classes / Profile.php

diff --git a/classes/Profile.php b/classes/Profile.php
index 000590a98fa34380a92a9934fa1669e85718a52e..5f88caf2c41dea018614fd772b9365ff1d31f57c 100644 (file)
--- a/classes/Profile.php
+++ b/classes/Profile.php
@@ -31,12 +31,12 @@ class Profile extends DB_DataObject
 
     public $__table = 'profile';                         // table name
     public $id;                              // int(4)  primary_key not_null
-    public $nickname;                        // varchar(64)   not_null
-    public $fullname;                        // varchar(255)  
+    public $nickname;                        // varchar(64)  multiple_key not_null
+    public $fullname;                        // varchar(255)  multiple_key
     public $profileurl;                      // varchar(255)  
-    public $homepage;                        // varchar(255)  
-    public $bio;                             // varchar(140)  
-    public $location;                        // varchar(255)  
+    public $homepage;                        // varchar(255)  multiple_key
+    public $bio;                             // varchar(140)  multiple_key
+    public $location;                        // varchar(255)  multiple_key
     public $created;                         // datetime()   not_null
     public $modified;                        // timestamp()   not_null default_CURRENT_TIMESTAMP
 
@@ -133,8 +133,23 @@ class Profile extends DB_DataObject
                }
                return true;
        }
-       
+
        function getBestName() {
                return ($this->fullname) ? $this->fullname : $this->nickname;
        }
+
+    # Get latest notice on or before date; default now
+       function getCurrentNotice($dt=NULL) {
+               $notice = new Notice();
+               $notice->profile_id = $this->id;
+               if ($dt) {
+                       $notice->whereAdd('created < "' . $dt . '"');
+               }
+               $notice->orderBy('created DESC, notice.id DESC');
+               $notice->limit(1);
+               if ($notice->find(true)) {
+                       return $notice;
+               }
+               return NULL;
+       }
 }