Disable/enable user switch

[gwvp-mini.git] / gwvpmini / gwvpmini_db.php

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index 5ce6b9a..d75ebcd 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -37,7 +37,7 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
        } 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
@@ -64,8 +64,31 @@ function gwvpmini_RemoveUser($uid)
        $sql = "delete from users where user_id='$uid'";
        
        return $conn->query($sql);
+}
+
+function gwvpmini_DisableUser($uid)
+{
+       $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
 
+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_ConnectDB()\r
 {\r
        global $WEB_ROOT_FS, $BASE_URL, $data_directory, $db_type, $db_name, $DB_CONNECTION;\r