X-Git-Url: http://git.pjr.cc/?p=gwvp.git;a=blobdiff_plain;f=gwvplib%2Fgwvpdatabase.php;h=7338e686eab0efd8cc6ffa9991ce6af51b0439d4;hp=a79adb0eb360f210d4e70b3e41d9b1f0f194ec16;hb=5e67e4fe3908ac2cfffced7f462e4f373d1cdbf1;hpb=74399e0d5226d43656c618451b4e6fc06702e5ab

diff --git a/gwvplib/gwvpdatabase.php b/gwvplib/gwvpdatabase.php
index a79adb0..7338e68 100644
--- a/gwvplib/gwvpdatabase.php
+++ b/gwvplib/gwvpdatabase.php
@@ -79,6 +79,77 @@ function gwvp_dbCreateSQLiteStructure($dbloc)
 	$DB_CONNECTION->query($groupmemsql);
 }
 
+function gwvp_forceDisconnect()
+{
+	
+	global $DB_CONNECTION;
+	
+	$DB_CONNECTION = false;
+}
+
+
+function gwvp_getConfigVal($confname)
+{
+	/*
+	 * 	$configsql = '
+		CREATE TABLE "config" (
+	    "config_name" TEXT,
+	    "config_value" TEXT
+		)';
+
+	 */
+	
+	$conn = gwvp_ConnectDB();
+	
+	$sql = "select * from config where config_name='$confname'";
+	
+	$res = $conn->query($sql);
+	
+	$return = null;
+	foreach($res as $val) {
+		$return = $val;
+	}
+	
+}
+
+function gwvp_eraseConfigVal($confname)
+{
+	/*
+	 * 	$configsql = '
+		CREATE TABLE "config" (
+	    "config_name" TEXT,
+	    "config_value" TEXT
+		)';
+
+	 */
+	
+	$conn = gwvp_ConnectDB();
+	
+	$sql = "delete from config where config_name='$confname'";
+	
+	return $conn->query($sql);
+}
+
+function gwvp_setConfigVal($confname, $confval)
+{
+	/*
+	 * 	$configsql = '
+		CREATE TABLE "config" (
+	    "config_name" TEXT,
+	    "config_value" TEXT
+		)';
+
+	 */
+	gwvp_eraseConfigVal($confname);
+
+	$conn = gwvp_ConnectDB();
+	
+	$sql = "insert into config values('$confname', '$confval')";
+	
+	return $conn->query($sql);
+}
+
+
 function gwvp_isDBSetup()
 {
 	// for sqlite, we just check if the db exists, for everyone else, we check for a conneciton and go yay or nay
@@ -442,6 +513,44 @@ function gwvp_getUserEmail($id)
 	return $return;
 }
 
+function gwvp_deleteGroupMemberByID($uid, $gid)
+{
+	$conn = gwvp_ConnectDB();
+
+	/*
+	 * 		CREATE TABLE "group_membership" (
+	 "groupmember_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+	 "groupmember_groupid" INTEGER,
+	 "groupmember_userid" INTEGER
+
+	 */
+	$sql = "delete from group_membership where groupmember_groupid='$gid' and  groupmember_userid='$uid'";
+
+	$conn->query($sql);
+
+	return true;
+}
+
+
+function gwvp_addGroupMemberByID($uid, $gid)
+{
+	$conn = gwvp_ConnectDB();
+
+	/*
+	 * 		CREATE TABLE "group_membership" (
+	 "groupmember_id" INTEGER PRIMARY KEY AUTOINCREMENT,
+	 "groupmember_groupid" INTEGER,
+	 "groupmember_userid" INTEGER
+
+	 */
+	$sql = "insert into group_membership values (null, '$gid', '$uid')";
+
+	$conn->query($sql);
+
+	return true;
+}
+
+
 function gwvp_addGroupMember($email, $groupname)
 {
 	$conn = gwvp_ConnectDB();
@@ -456,7 +565,7 @@ function gwvp_addGroupMember($email, $groupname)
 	 "groupmember_userid" INTEGER
 
 	 */
-	if($uid!=false&&$gid!=false) $sql = "insert into group_membership values (null, '$gid', '$uid')";
+	if($uid!=false&&$gid!=false) gwvp_addGroupMemberByID($uid, $gid);
 	else return false;
 
 	$conn->query($sql);
@@ -511,7 +620,7 @@ function gwvp_IsUserAdmin($email=null, $username = null)
 		$rn++;
 	}
 
-	foreach($gid as $gid_t) {
+	if($gid !== false) foreach($gid as $gid_t) {
 		/*
 		 * 		CREATE TABLE groups (
 		 "groups_id" INTEGER,