$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
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();
"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);
$rn++;
}
- foreach($gid as $gid_t) {
+ if($gid !== false) foreach($gid as $gid_t) {
/*
* CREATE TABLE groups (
"groups_id" INTEGER,