X-Git-Url: http://git.pjr.cc/?p=gwvp.git;a=blobdiff_plain;f=gwvplib%2Fgwvpdatabase.php;fp=gwvplib%2Fgwvpdatabase.php;h=82533cbcd9c7217218aef1478909de80ddc6df60;hp=28d2832eba7b171d6b3d6d0bfd9634277c934290;hb=bdb63bf22c9310fd5d2050d59eb79f8312deca2b;hpb=5d5e0ef454ba3bb0ce2eafd5612ab5f91c4e0d99 diff --git a/gwvplib/gwvpdatabase.php b/gwvplib/gwvpdatabase.php index 28d2832..82533cb 100644 --- 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);