X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=f87751c2b624bbd326a2f6d50e0a4b83454b82c1;hp=3f6380439c63ced4796cd7871fa50bd61b758a67;hb=2665125c8ddb042dcd87e804bf63b79cc423da0e;hpb=75cc0009dc451b541228e9222e19b4b6d5659065

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 3f63804..f87751c 100644
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -241,6 +241,52 @@ function gwvpmini_GetRepoId($reponame)
 	return $retval;
 }
 
+function gwvpmini_GetRepoOwnerDetailsFromName($reponame)
+{
+
+	/*
+	 * 	$reposql = '
+	CREATE TABLE "repos" (
+			"repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+			"repos_name" TEXT,
+			"repos_description" TEXT,
+			"repos_owner" INTEGER
+	)';
+	
+		"user_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+	"user_full_name" TEXT,
+	"user_password" TEXT,
+	"user_username" TEXT,
+	"user_email" TEXT,
+	"user_desc" TEXT,
+	"user_level" TEXT,
+	"user_status" TEXT,
+	UNIQUE(user_username)
+
+	*/
+
+	$conn = gwvpmini_ConnectDB();
+
+	$sql = "select users.* from repos,users where repos_name='$reponame' and repos_owner=user_id";
+
+	$res = $conn->query($sql);
+
+	$retval = -1;
+	if(!$res) return -1;
+	foreach($res as $row) {
+		$retval = array();
+		error_log("STUFF2: ".print_r($row,true));
+		$retval["id"] = $row["user_id"];
+		$retval["fullname"] = $row["user_full_name"];
+		$retval["username"] = $row["user_username"];
+		$retval["email"] = $row["user_email"];
+		$retval["desc"] = $row["user_desc"];
+		$retval["level"] = $row["user_level"];
+		$retval["status"] = $row["user_status"];
+	}
+
+	return $retval;
+}
 
 function gwvpmini_setConfigVal($confname, $confval)
 {