X-Git-Url: https://dev.renevier.net/?a=blobdiff_plain;f=inc%2Fdb%2Fanydb.php;h=bb80032a274eb3e4b898728f24f80c2e3c29b394;hb=e4a4e5149d55cf01a86f26392c52fdca803654ce;hp=c88367a46277fb081309b020288e58eed88a6647;hpb=57511b4efd7402ef58de66ac1fe2c01ed1b1d7b5;p=syp.git

diff --git a/inc/db/anydb.php b/inc/db/anydb.php
index c88367a..bb80032 100644
--- a/inc/db/anydb.php
+++ b/inc/db/anydb.php
@@ -9,10 +9,11 @@ class feature {
     private $imgpath = null;
     private $title = null;
     private $description = null;
+    private $date = 0;
 
     const err_lonlat_invalid = 1;
 
-    function __construct ($id, $lon, $lat, $imgpath, $title, $description) {
+    function __construct ($id, $lon, $lat, $imgpath, $title, $description, $date) {
         $this->imgpath = $imgpath;
 
         // id
@@ -26,6 +27,9 @@ class feature {
         // description
         $this->description = $description;
 
+        // date
+        $this->date = $date;
+
         // longitude
         if (!isset ($lon) || !is_numeric ($lon) ||
              ($lon < -180) || ($lon > 180)) {
@@ -69,10 +73,10 @@ interface anydbConnection {
     public function users_table_exists();
 
     /*
-     * create users table; if $error_if_exists is true; throws an err_query
-     * error in case users table already exists.
+     * create users table; 
+     * throws an err_query error in case users table already exists.
      */
-    public function create_users_table($error_if_exists);
+    public function create_users_table();
 
     /*
      * return true if items table already exists
@@ -80,10 +84,10 @@ interface anydbConnection {
     public function items_table_exists();
 
     /*
-     * create items table; if $error_if_exists is true; throws an err_query
-     * error in case items table already exists.
+     * create items table;
+     * throws an err_query error in case items table already exists.
      */
-    public function create_items_table($error_if_exists);
+    public function create_items_table();
 
     /*
      * set password $pwd for user $usrname. If $usrname does not exist, create
@@ -118,6 +122,12 @@ interface anydbConnection {
      */
     public function listfeatures();
 
+    /*
+     * returns the most recent features sorted by date. If $num_features is not
+     * defined or is null, returns all features sorted by date.
+     */
+    public function mostrecentfeatures($num_features);
+
     /*
      * returns true if a feature with imgpath exists
      */