} else if($email != null) {\r
$res = $conn->query("select * from users where user_email='$email'");\r
} else if($id != null) {\r
- $res = $conn->query("select * from users where users_id='$id'");\r
+ $res = $conn->query("select * from users where user_id='$id'");\r
} else return false;\r
\r
$returns = false;\r
\r
return $returns;\r
\r
+}
+
+
+function gwvpmini_getRepo($ownerid=null, $name=null, $id=null)\r
+{\r
+ $conn = gwvpmini_ConnectDB();
+
+ /*
+ * $reposql = '
+ CREATE TABLE "repos" (
+ "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+ "repos_name" TEXT,
+ "repos_description" TEXT,
+ "repos_owner" INTEGER,
+ "repos_readperms" TEXT,
+ UNIQUE(repos_name)
+ )';
+
+ */\r
+\r
+ if($ownerid != null) {\r
+ $res = $conn->query("select * from repos where repos_owner='$ownerid'");\r
+ } else if($name != null) {\r
+ $res = $conn->query("select * from repos where repos_name='$name'");\r
+ } else if($id != null) {\r
+ $res = $conn->query("select * from repos where repos_id='$id'");\r
+ } else return false;\r
+\r
+ $returns = false;
+ if(!$res) return false;\r
+ foreach($res as $u_res) {\r
+ $returns["id"] = $u_res["repos_id"];\r
+ $returns["name"] = $u_res["repos_name"];\r
+ $returns["desc"] = $u_res["repos_description"];\r
+ $returns["ownerid"] = $u_res["repos_owner"];
+ $returns["status"] = $u_res["repos_status"];\r
+ }\r
+\r
+ return $returns;\r
+\r
+}
+
+// $rid = repo id
+// $uid = user id (a for "anyone", r for "registered")
+// $acc = 0 or 1, 0 = no access, 1 = read access, 2 = write
+// first part of ths is the "base" repo permissions
+// this is spec'd as b:t where t = a (anyone can read), r (only registered can read) or x (explicit read perms)
+function gwvpmini_ChangeRepoPerm($rid, $uid, $acc)
+{
+ $conn = gwvpmini_ConnectDB();
+
+ $sql = "select repos_perms from repos where repos_id='$rid'";
+
+ $res = $conn->query($sql);
+
+ error_log("CHANGEREPOPERMS: call with $rid, $uid, $acc");
+
+ $cperms_t = "";
+ foreach($res as $row) {
+ $cperms_t = $row[0];
+ }
+
+ if($cperms_t === false) return false;
+
+ $permsarray = array();
+ if($cperms_t == "") {
+ $permsarray[$uid] = $acc;
+ } else {
+ $permsarray = unserialize(base64_decode($cperms_t));
+ $permsarray[$uid] = $acc;
+ }
+
+ // check if base is now r or a, we can drop any 1's
+ if($permsarray["b"] == "a" || $permsarray["b"] == "r") {
+ foreach($permsarray as $key => $val) {
+ if($val == 1) {
+ unset($permsarray[$key]);
+ }
+ }
+ }
+
+ $encperms = base64_encode(serialize($permsarray));
+
+ $sql = "update repos set repos_perms='$encperms' where repos_id='$rid'";\r
+
+ $conn->query($sql);
+
+}
+
+//returns 0 for none, 1 for read, 2 for writes
+function gwvpmini_GetRepoPerm($rid, $uid)
+{
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ $dets = gwvpmini_getRepo(null, null, $rid);
+
+ $sql = "select repos_perms from repos where repos_id='$rid'";\r
+ \r
+ $res = $conn->query($sql);
+
+ error_log("PERMCHECK: FUCK U! $sql");\r
+ \r
+ $cperms_t = false;\r
+ if($res !== false) foreach($res as $row) {\r
+ $cperms_t = $row[0];\r
+ }\r
+ \r
+ if($cperms_t === false) return 0;
+
+ error_log("PERMSCHECK $rid, $uid:".print_r($dets, true));\r
+ \r
+ if($dets === false) return 0;
+
+ if($dets["ownerid"] == $uid) return 2;\r
+ \r
+ $permsarray = unserialize(base64_decode($cperms_t));
+
+ error_log("PERMSARRAY: ".print_r($permsarray,true));
+
+
+ $perm = 0;
+ if($uid != "a") {
+ if(isset($permsarray[$uid])) {
+ $perm = $permsarray[$uid];
+ } else if($permsarray["b"] == "a" ||$permsarray["b"] == "r") {
+ $perm = 1;
+ }
+ } else {
+ if($permsarray["b"] == "a") $perm = 1;
+ }
+
+ return $perm;\r
+
+}
+
+function gwvpmini_RemoveRepoDB($id)
+{
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ if($id < 0) return;\r
+ \r
+ $sql = "delete from repos where repos_id='$id'";\r
+ \r
+ return $conn->query($sql);\r
+
+}
+
+function gwvpmini_RemoveUser($uid)
+{
+ $conn = gwvpmini_ConnectDB();\r
+
+ if($uid < 0) return;
+
+ $sql = "delete from users where user_id='$uid'";
+
+ return $conn->query($sql);
+}
+
+function gwvpmini_DisableUser($uid)\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ if($uid < 0) return;\r
+\r
+ $sql = "update users set user_status=1 where user_id='$uid'";\r
+\r
+ return $conn->query($sql);\r
+}\r
+\r
+function gwvpmini_EnableUser($uid)\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ if($uid < 0) return;\r
+\r
+ $sql = "update users set user_status=0 where user_id='$uid'";\r
+\r
+ return $conn->query($sql);\r
+}\r
+\r
+function gwvpmini_DisableRepo($rid)
+{
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ if($rid < 0) return;\r
+ \r
+ $sql = "update repos set repos_status=1 where repos_id='$rid'";\r
+ \r
+ return $conn->query($sql);
}\r
+function gwvpmini_EnableRepo($rid)\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ if($rid < 0) return;
+
+ $sql = "update repos set repos_status=0 where repos_id='$rid'";
+ \r
+ return $conn->query($sql);\r
+}\r
+\r
+
function gwvpmini_ConnectDB()\r
{\r
global $WEB_ROOT_FS, $BASE_URL, $data_directory, $db_type, $db_name, $DB_CONNECTION;\r
}\r
\r
return $DB_CONNECTION;\r
+}
+
+function gwvpmini_UpdateStatusFromConfirm($confirmhash)
+{
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ $sql = "select count(*) from users where user_status='2:$confirmhash'";
+
+ $res = $conn->query($sql);
+
+ if(!$res) return false;
+
+ foreach($res as $row) {
+ $retval = $row[0];
+ }
+
+ if($retval > 0) {
+ $sql = "update users set user_status='0' where user_status='2:$confirmhash'";
+ return $conn->query($sql);
+ } else return false;
+}
+
+
+function gwvpmini_AddUser($username, $password, $fullname, $email, $desc, $level, $status)
+{
+ \r
+
+ \r
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ $sql = "insert into 'users' values ( null, '$fullname', '".sha1($password)."', '$username', '$email', '$desc', '$level', '$status')";\r
+ \r
+ $res = $conn->query($sql);
+ if(!$res) return -1;
+
+ $sql = "select user_id from users where user_username='$username'";\r
+ $res = $conn->query($sql);\r
+ if(!$res) return -1;\r
+
+ $retval = -1;
+ foreach($res as $row) {
+ $retval = $row[0];
+ }
+
+ return $retval;
}\r
"user_email" TEXT,\r
"user_desc" TEXT,
"user_level" TEXT,\r
- "user_status" TEXT\r
+ "user_status" TEXT,
+ UNIQUE(user_username)\r
)';\r
\r
$initialuser_admin = '
"repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,\r
"repos_name" TEXT,\r
"repos_description" TEXT,\r
- "repos_owner" INTEGER\r
+ "repos_owner" INTEGER,
+ "repos_perms" TEXT,
+ "repos_status" TEXT,
+ UNIQUE(repos_name)\r
)';\r
\r
// this looks like null, <repoid>, <read|visible|write>, user:<uid>|group:<gid>|authed|anon\r
$retval = -1;
if(!$res) return -1;
foreach($res as $row) {
- $reval = (int)$row[0];
+ $retval = (int)$row[0];
}
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
*/\r
gwvpmini_eraseConfigVal($confname);\r
\r
- $conn = gwvpmini_ConnectDB();\r
+ $conn = gwvpmini_ConnectDB();
+
+ $sql = "delete from config where config_name='$confname'";
+ $conn->query($sql);\r
\r
$sql = "insert into config values('$confname', '$confval')";\r
\r
error_log("addrepo in db for $name, $desc, $ownerid");
$conn = gwvpmini_ConnectDB();\r
+
+ $perms["b"] = "a";
+
+ $encperms = base64_encode(serialize($perms));
\r
- $sql = "insert into repos values (null, '$name', '$desc', '$ownerid')";\r
+ $sql = "insert into repos values (null, '$name', '$desc', '$ownerid', '$encperms', 0)";\r
\r
$conn->query($sql);\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
{
/*
*/
$conn = gwvpmini_ConnectDB();
+
$uid = gwvpmini_GetUserId($username);
$sql = "select * from repos where repos_owner='$uid'";
- error_log("owned repos sql $sql");
+ error_log("owned repos sql $sql for username $username");
$res = $conn->query($sql);
+ if($username == "") return false;\r
$retval = false;
foreach($res as $row) {
$id = $row["repos_id"];
$retval[$id]["name"] = $row["repos_name"];
$retval[$id]["desc"] = $row["repos_description"];
+ $retval[$id]["id"] = $row["repos_id"];
error_log(print_r($row, true));
}
return $lev;
}
-function gwvpmini_GetUsers()
+function gwvpmini_GetUsers($startat = 0, $num = 10)
{
$conn = gwvpmini_ConnectDB();
*/\r
\r
- $sql = "select * from users";
+ $sql = "select * from users where user_id>='$startat' order by user_id asc limit $num";
$res = $conn->query($sql);
$retval[$id]["desc"] = $row["user_desc"];
$retval[$id]["level"] = $row["user_level"];
$retval[$id]["status"] = $row["user_status"];
+ $retval[$id]["id"] = $row["user_id"];
}
return $retval;
}\r
+function gwvpmini_findPeopleLike($search)\r
+{\r
+ $conn = gwvpmini_ConnectDB();
+
+ $sql = "select * from users where user_username like '%$search%' or user_full_name like '%$search%'";\r
+ \r
+ $res = $conn->query($sql);
+
+ if(!$res) {
+ error_log("SERACHUSER: $sql returned false");
+ return false;
+ } else {
+ error_log("SERACHUSER: $sql returned true");
+ }\r
+ \r
+ $retval = false;\r
+ foreach($res as $row) {\r
+ $id = $row["user_id"];\r
+ $retval[$id]["fullname"] = $row["user_full_name"];\r
+ $retval[$id]["username"] = $row["user_username"];\r
+ $retval[$id]["email"] = $row["user_email"];\r
+ $retval[$id]["desc"] = $row["user_desc"];\r
+ $retval[$id]["level"] = $row["user_level"];\r
+ $retval[$id]["status"] = $row["user_status"];\r
+ $retval[$id]["id"] = $row["user_id"];\r
+ }\r
+
+ error_log("SEARCHUSER: array is ".print_r($retval, true));\r
+ return $retval;
+}
+
+function gwvpmini_GetRepos($startat=0, $num=200)\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+ \r
+ /*\r
+ * CREATE TABLE "repos" (
+ "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+ "repos_name" TEXT,
+ "repos_description" TEXT,
+ "repos_owner" INTEGER
+ )';
+ \r
+ */\r
+ \r
+ $sql = "select * from repos where repos_id > '$startat' order by repos_id asc limit $num";\r
+ \r
+ $res = $conn->query($sql);\r
+ \r
+ $retval = false;\r
+ foreach($res as $row) {\r
+ $id = $row["repos_id"];\r
+ $retval[$id]["name"] = $row["repos_name"];\r
+ $retval[$id]["desc"] = $row["repos_description"];\r
+ $retval[$id]["owner"] = $row["repos_owner"];\r
+ $retval[$id]["id"] = $row["repos_id"];
+ $retval[$id]["status"] = $row["repos_status"];
+ }\r
+ \r
+ return $retval;\r
+ \r
+ \r
+}\r
+
+function gwvpmini_findReposLike($search)\r
+{\r
+ $conn = gwvpmini_ConnectDB();
+
+ /*
+ * CREATE TABLE "repos" (
+ "repos_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+ "repos_name" TEXT,
+ "repos_description" TEXT,
+ "repos_owner" INTEGER
+ )';
+
+ */
+
+ $sql = "select * from repos where repos_name like '%$search%' or repos_description like '%$search%'";
+
+ $res = $conn->query($sql);
+
+ if(!$res) return false;
+
+ $retval = false;
+ foreach($res as $row) {
+ $id = $row["repos_id"];
+ $retval[$id]["name"] = $row["repos_name"];
+ $retval[$id]["desc"] = $row["repos_description"];
+ $retval[$id]["owner"] = $row["repos_owner"];
+ $retval[$id]["id"] = $row["repos_id"];
+ $retval[$id]["status"] = $row["repos_status"];
+ }
+
+ return $retval;
+ \r
+}\r
+\r
+function gwvpmini_GetNRepos()
+{
+ $conn = gwvpmini_ConnectDB();
+
+ $sql = "select count(*) from repos";
+
+ $res = $conn->query($sql);
+
+ $retval = -1;
+ foreach($res as $row) {
+ $retval = $row[0];
+ }
+
+ return $retval;
+}
+
+\r
+function gwvpmini_GetNUsers()\r
+{\r
+ $conn = gwvpmini_ConnectDB();\r
+\r
+ $sql = "select count(*) from users";\r
+\r
+ $res = $conn->query($sql);\r
+\r
+ $retval = -1;\r
+ foreach($res as $row) {\r
+ $retval = $row[0];\r
+ }\r
+\r
+ return $retval;\r
+}\r
+
?>
\ No newline at end of file
projects / gwvp-mini.git / blobdiff