push EVERY repo request back to git-http-backend cause it knows how to

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

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 17bbb0a..b94b4ca 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -667,6 +667,7 @@ function gwvpmini_GetUserNameFromEmail($email)
 \r
        return $retval;\r
 }
+
 function gwvpmini_GetOwnedRepos($username)\r
 {
        /*
@@ -693,6 +694,7 @@ function gwvpmini_GetOwnedRepos($username)
                $retval[$id]["name"] = $row["repos_name"];
                $retval[$id]["desc"] = $row["repos_description"];
                $retval[$id]["id"] = $row["repos_id"];
+               $retval[$id]["status"] = $row["repos_status"];
                error_log(print_r($row, true));
        }
        
@@ -700,6 +702,43 @@ function gwvpmini_GetOwnedRepos($username)
        return $retval;\r
 }
 
+function gwvpmini_GetContributedRepos($username)\r
+{\r
+       /*\r
+        *      CREATE TABLE "repos" (\r
+                       "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,\r
+                       "repos_name" TEXT,\r
+                       "repos_description" TEXT,\r
+                       "repos_owner" INTEGER\r
+        )';\r
+\r
+       */\r
+       $conn = gwvpmini_ConnectDB();\r
+\r
+\r
+       $uid = gwvpmini_GetUserId($username);\r
+       $sql = "select repos_id,repos_description,repos_perms,repos_owernid,repos_status from repos";\r
+       $res = $conn->query($sql);\r
+       if($username == "") return false;\r
+\r
+       $retval = false;
+       $rids = null;
+       $i = 0;\r
+       foreach($res as $row) {
+               $perms = unserialize(base64_decode($row["repos_perms"]));
+               if(isset($perms["$uid"])) if($perms["$uid"] > 1) {
+                       $rids[$i]["id"] = $row["repos_id"];
+                       $rids[$i]["desc"] = $row["repos_description"];
+                       $rids[$i]["ownerid"] = $row["repos_ownerid"];
+                       $rids[$i]["status"] = $row["repos_status"];
+                       $i++;
+               }
+       }\r
+\r
+       error_log(print_r($retval, true));\r
+       return $retval;\r
+}
+
 function gwvpmini_userLevel($id)
 {
        $conn = gwvpmini_ConnectDB();