X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=classes%2FProfile.php;h=5f88caf2c41dea018614fd772b9365ff1d31f57c;hb=fe77b3445c5721f81e99b292f06f4ff3ab823022;hp=000590a98fa34380a92a9934fa1669e85718a52e;hpb=c02a01914ab67c2bc25850034a75ee1046fd6870;p=quix0rs-gnu-social.git

diff --git a/classes/Profile.php b/classes/Profile.php
index 000590a98f..5f88caf2c4 100644
--- 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;
+	}
 }