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 5ce6b9a..1995e7d 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -37,7 +37,7 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
        } else if($email != null) {\r
                $res = $conn->query("select * from users where user_email='$email'");\r
        } else if($id != null) {\r
-               $res = $conn->query("select * from users where users_id='$id'");\r
+               $res = $conn->query("select * from users where user_id='$id'");\r
        } else return false;\r
 \r
        $returns = false;\r
@@ -55,6 +55,58 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
 \r
 }
 
+
+function gwvpmini_getRepo($ownerid=null, $name=null, $id=null)\r
+{\r
+       $conn = gwvpmini_ConnectDB();
+       
+       /*
+        *      $reposql = '
+       CREATE TABLE "repos" (
+       "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+       "repos_name" TEXT,
+       "repos_description" TEXT,
+       "repos_owner" INTEGER,
+       "repos_readperms" TEXT,
+       UNIQUE(repos_name)
+       )';
+
+        */\r
+\r
+       if($ownerid != null) {\r
+               $res = $conn->query("select * from repos where repos_owner='$ownerid'");\r
+       } else if($name != null) {\r
+               $res = $conn->query("select * from repos where repos_name='$name'");\r
+       } else if($id != null) {\r
+               $res = $conn->query("select * from repos where repos_id='$id'");\r
+       } else return false;\r
+\r
+       $returns = false;
+       if(!$res) return false;\r
+       foreach($res as $u_res) {\r
+               $returns["id"] = $u_res["repos_id"];\r
+               $returns["name"] = $u_res["repos_name"];\r
+               $returns["desc"] = $u_res["repos_description"];\r
+               $returns["ownerid"] = $u_res["repos_owner"];\r
+               $returns["perms"] = $u_res["repos_readperms"];\r
+       }\r
+\r
+       return $returns;\r
+\r
+}
+
+function gwvpmini_RemoveRepoDB($id)
+{
+       $conn = gwvpmini_ConnectDB();\r
+       \r
+       if($id < 0) return;\r
+       \r
+       $sql = "delete from repos where repos_id='$id'";\r
+       \r
+       return $conn->query($sql);\r
+       
+}
+
 function gwvpmini_RemoveUser($uid)
 {
        $conn = gwvpmini_ConnectDB();\r
@@ -64,7 +116,30 @@ function gwvpmini_RemoveUser($uid)
        $sql = "delete from users where user_id='$uid'";
        
        return $conn->query($sql);
+}
+
+function gwvpmini_DisableUser($uid)
+{
+       $conn = gwvpmini_ConnectDB();\r
+       \r
+       if($uid < 0) return;\r
+       \r
+       $sql = "update users set user_status=1 where user_id='$uid'";\r
+       \r
+       return $conn->query($sql);
+}\r
+
+function gwvpmini_EnableUser($uid)\r
+{\r
+       $conn = gwvpmini_ConnectDB();\r
+\r
+       if($uid < 0) return;\r
+\r
+       $sql = "update users set user_status=0 where user_id='$uid'";\r
+\r
+       return $conn->query($sql);\r
 }\r
+\r
 
 function gwvpmini_ConnectDB()\r
 {\r
@@ -431,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));
        }
        
@@ -495,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
@@ -524,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
@@ -531,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();