X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=b94b4cafcec7dfa83aba973c09199b620c9e2fb4;hp=17bbb0a153e8c9ba20e9cffde0047c73d17033e2;hb=ee03efce23152f2c09b293c9013d83da8a42ff9f;hpb=755b11a472bc4309d48af8f444deb0b6348cdc10

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 17bbb0a..b94b4ca 100644
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -667,6 +667,7 @@ function gwvpmini_GetUserNameFromEmail($email)
 
 	return $retval;
 }
+
 function gwvpmini_GetOwnedRepos($username)
 {
 	/*
@@ -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;
 }
 
+function gwvpmini_GetContributedRepos($username)
+{
+	/*
+	 * 	CREATE TABLE "repos" (
+	 		"repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+	 		"repos_name" TEXT,
+	 		"repos_description" TEXT,
+	 		"repos_owner" INTEGER
+	 )';
+
+	*/
+	$conn = gwvpmini_ConnectDB();
+
+
+	$uid = gwvpmini_GetUserId($username);
+	$sql = "select repos_id,repos_description,repos_perms,repos_owernid,repos_status from repos";
+	$res = $conn->query($sql);
+	if($username == "") return false;
+
+	$retval = false;
+	$rids = null;
+	$i = 0;
+	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++;
+		}
+	}
+
+	error_log(print_r($retval, true));
+	return $retval;
+}
+
 function gwvpmini_userLevel($id)
 {
 	$conn = gwvpmini_ConnectDB();