return $retval;
}
+
+function gwvpmini_GetRepoDescFromName($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
+ )';\r
+\r
+ */\r
+\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ $sql = "select repos_description from repos where repos_name='$reponame'";
+ error_log("desc for name sql: $sql");\r
+\r
+ $res = $conn->query($sql);\r
+\r
+ $retval = -1;\r
+ if(!$res) return -1;\r
+ foreach($res as $row) {\r
+ $retval = $row[0];\r
+ }\r
+\r
+ return $retval;\r
+}
+\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
return $retval;
}
+function gwvpmini_GetUserNameFromEmail($email)\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ $sql = "select user_username from users where user_email='$email'";\r
+\r
+ error_log("username sql $sql");\r
+\r
+ $res = $conn->query($sql);\r
+\r
+ $retval = false;\r
+ foreach($res as $row) {\r
+ $retval = $row[0];\r
+ }\r
+\r
+ return $retval;\r
+}
function gwvpmini_GetOwnedRepos($username)\r
{
/*