added repo remove from admin page

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

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index d75ebcd..00f20b1 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -55,6 +55,57 @@ 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