addded user details to top of repo view

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

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 3f63804..f87751c 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -241,6 +241,52 @@ function gwvpmini_GetRepoId($reponame)
        return $retval;
 }
 \r
+function gwvpmini_GetRepoOwnerDetailsFromName($reponame)\r
+{\r
+\r
+       /*\r
+        *      $reposql = '\r
+       CREATE TABLE "repos" (\r
+                       "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,\r
+                       "repos_name" TEXT,\r
+                       "repos_description" TEXT,\r
+                       "repos_owner" INTEGER\r
+       )';
+       
+               "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)\r
+\r
+       */\r
+\r
+       $conn = gwvpmini_ConnectDB();\r
+\r
+       $sql = "select users.* from repos,users where repos_name='$reponame' and repos_owner=user_id";\r
+\r
+       $res = $conn->query($sql);\r
+\r
+       $retval = -1;\r
+       if(!$res) return -1;\r
+       foreach($res as $row) {
+               $retval = array();
+               error_log("STUFF2: ".print_r($row,true));\r
+               $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"];\r
+       }\r
+\r
+       return $retval;\r
+}\r
 \r
 function gwvpmini_setConfigVal($confname, $confval)\r
 {\r