getting basic search functionality working

[gwvp-mini.git] / gwvpmini / gwvpmini_db.php

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 00f20b1..1995e7d 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -55,6 +55,7 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
 \r
 }
 
+
 function gwvpmini_getRepo($ownerid=null, $name=null, $id=null)\r
 {\r
        $conn = gwvpmini_ConnectDB();
@@ -505,16 +506,19 @@ function gwvpmini_GetOwnedRepos($username)
         */
        $conn = gwvpmini_ConnectDB();
        
+       
        $uid = gwvpmini_GetUserId($username);
        $sql = "select * from repos where repos_owner='$uid'";
-       error_log("owned repos sql $sql");
+       error_log("owned repos sql $sql for username $username");
        $res = $conn->query($sql);
+       if($username == "") return false;\r
        
        $retval = false;
        foreach($res as $row) {
                $id = $row["repos_id"];
                $retval[$id]["name"] = $row["repos_name"];
                $retval[$id]["desc"] = $row["repos_description"];
+               $retval[$id]["id"] = $row["repos_id"];
                error_log(print_r($row, true));
        }
        
@@ -569,11 +573,43 @@ function gwvpmini_GetUsers($startat = 0, $num = 10)
                $retval[$id]["desc"] = $row["user_desc"];
                $retval[$id]["level"] = $row["user_level"];
                $retval[$id]["status"] = $row["user_status"];
+               $retval[$id]["id"] = $row["user_id"];
        }
        
        return $retval;
 }\r
 
+function gwvp_findPeopleLike($search)\r
+{\r
+       $conn = gwvpmini_ConnectDB();
+       
+       $sql = "select * from users where user_username like '%$search%' or user_full_name like '%$search%'";\r
+       \r
+       $res = $conn->query($sql);
+       
+       if(!$res) {
+               error_log("SERACHUSER: $sql returned false");
+               return false;
+       } else {
+               error_log("SERACHUSER: $sql returned true");
+       }\r
+       \r
+       $retval = false;\r
+       foreach($res as $row) {\r
+               $id = $row["user_id"];\r
+               $retval[$id]["fullname"] = $row["user_full_name"];\r
+               $retval[$id]["username"] = $row["user_username"];\r
+               $retval[$id]["email"] = $row["user_email"];\r
+               $retval[$id]["desc"] = $row["user_desc"];\r
+               $retval[$id]["level"] = $row["user_level"];\r
+               $retval[$id]["status"] = $row["user_status"];\r
+               $retval[$id]["id"] = $row["user_id"];\r
+       }\r
+       
+       error_log("SEARCHUSER: array is ".print_r($retval, true));\r
+       return $retval;
+}
+
 function gwvpmini_GetRepos($startat=0, $num=200)\r
 {\r
        $conn = gwvpmini_ConnectDB();\r
@@ -598,6 +634,7 @@ function gwvpmini_GetRepos($startat=0, $num=200)
                $retval[$id]["name"] = $row["repos_name"];\r
                $retval[$id]["desc"] = $row["repos_description"];\r
                $retval[$id]["owner"] = $row["repos_owner"];\r
+               $retval[$id]["id"] = $row["repos_id"];
        }\r
        \r
        return $retval;\r
@@ -605,6 +642,39 @@ function gwvpmini_GetRepos($startat=0, $num=200)
        \r
 }\r
 
+function gwvp_findReposLike($search)\r
+{\r
+       $conn = gwvpmini_ConnectDB();
+       
+       /*
+        *      CREATE TABLE "repos" (
+       "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+       "repos_name" TEXT,
+       "repos_description" TEXT,
+       "repos_owner" INTEGER
+       )';
+       
+                       */
+       
+       $sql = "select * from repos where repos_name like '%$search%' or repos_description like '%$search%'";
+       
+       $res = $conn->query($sql);
+       
+       if(!$res) return false;
+       
+       $retval = false;
+       foreach($res as $row) {
+               $id = $row["repos_id"];
+               $retval[$id]["name"] = $row["repos_name"];
+               $retval[$id]["desc"] = $row["repos_description"];
+               $retval[$id]["owner"] = $row["repos_owner"];
+               $retval[$id]["id"] = $row["repos_id"];
+       }
+       
+       return $retval;
+       \r
+}\r
+\r
 function gwvpmini_GetNRepos()
 {
        $conn = gwvpmini_ConnectDB();