Its a nightmare in pastel! but permission management on repos now

[gwvp.git] / gwvplib / gwvpdatabase.php

diff --git a/gwvplib/gwvpdatabase.php b/gwvplib/gwvpdatabase.php
index 28d2832..82533cb 100644 (file)
--- a/gwvplib/gwvpdatabase.php
+++ b/gwvplib/gwvpdatabase.php
@@ -710,6 +710,27 @@ function gwvp_IsGroupMember($email, $groupname)
        if($result == 1) return true;
 }
 
+function gwvp_IsGroupAdmin($groupname = null, $gid = null)
+{
+       $conn = gwvp_ConnectDB();
+       
+       if($groupname != null) {
+               $sql = "select groups_is_admin from groups where groups_name='$groupname'";
+       } else if($gid != null) {
+               $sql = "select groups_is_admin from groups where groups_id='$gid'";
+       } else return false;
+       
+       $res = $conn->query($sql);
+       
+       $return = false;
+       foreach($res as $u_res) {
+               if($u_res["groups_is_admin"] == "1") $return = true;
+       }
+       
+       return $return;
+}
+
+
 function gwvp_IsUserAdmin($email=null, $username = null, $userid = null)
 {
        $conn = gwvp_ConnectDB();
@@ -836,6 +857,25 @@ function gwvp_ModifyGroup($groupid, $groupname = null, $group_is_admin = null, $
        return true;
 }
 
+function gwvp_GetRepo($rid)
+{
+       $conn = gwvp_ConnectDB();
+       
+       $sql = "select * from repos where repos_id='$rid'";
+       
+       $res = $conn->query($sql);
+       
+       $return = false;
+       foreach($res as $u_res) {
+               $return["id"] = $u_res["repos_id"];
+               $return["name"] = $u_res["repos_name"];
+               $return["description"] = $u_res["repos_description"];
+               $return["owner"] = $u_res["repos_owner"];
+       }
+       
+       return $return;
+}
+
 function gwvp_GetRepoList()
 {
        $conn = gwvp_ConnectDB();
@@ -937,7 +977,7 @@ function gwvp_getRepoPermissions($repoid)
        $returns = false;
        $rn = 0;
        foreach($res as $perm) {
-               $returns[$rn]["permid"] = $perm["repoperms_id"];
+               $returns[$rn]["id"] = $perm["repoperms_id"];
                $returns[$rn]["type"] = $perm["repoperms_type"];
                $returns[$rn]["ref"] = $perm["repoperms_ref"];
                $rn++;
@@ -946,10 +986,21 @@ function gwvp_getRepoPermissions($repoid)
        return $returns;
 }
 
+function gwvp_removeRepoPermission($permid)
+{
+       $conn = gwvp_ConnectDB();
+       
+       $sql = "delete from repoperms where repoperms_id='$permid'";
+       error_log("attempting: \"$sql\"");
+       
+       return $conn->query($sql);
+}
+
 function gwvp_addRepoPermission($repoid, $permtype, $permref)
 {
        $conn = gwvp_ConnectDB();
        
+       error_log("PERMS: $repoid, $permtype, $permref");
        $sql = "insert into repoperms values(null, '$repoid', '$permtype', '$permref')";
        
        return $conn->query($sql);