check whether user is enabled

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

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index cf3e0fd..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
@@ -53,8 +53,42 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
 \r
        return $returns;\r
 \r
+}
+
+function gwvpmini_RemoveUser($uid)
+{
+       $conn = gwvpmini_ConnectDB();\r
+       
+       if($uid < 0) return;
+       
+       $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
@@ -86,6 +120,27 @@ function gwvpmini_ConnectDB()
        return $DB_CONNECTION;\r
 }
 
+function gwvpmini_UpdateStatusFromConfirm($confirmhash)
+{
+       $conn = gwvpmini_ConnectDB();\r
+       \r
+       $sql = "select count(*) from users where user_status='2:$confirmhash'";
+       
+       $res = $conn->query($sql);
+       
+       if(!$res) return false;
+       
+       foreach($res as $row) {
+               $retval = $row[0];
+       }
+       
+       if($retval > 0) {
+               $sql = "update users set user_status='0' where user_status='2:$confirmhash'";
+               return $conn->query($sql);
+       } else return false;
+}
+
+
 function gwvpmini_AddUser($username, $password, $fullname, $email, $desc, $level, $status)
 {
        \r
@@ -330,7 +385,10 @@ function gwvpmini_setConfigVal($confname, $confval)
        */\r
        gwvpmini_eraseConfigVal($confname);\r
 \r
-       $conn = gwvpmini_ConnectDB();\r
+       $conn = gwvpmini_ConnectDB();
+       
+       $sql = "delete from config where config_name='$confname'";
+       $conn->query($sql);\r
 \r
        $sql = "insert into config values('$confname', '$confval')";\r
 \r
@@ -447,7 +505,7 @@ function gwvpmini_GetUsers($startat = 0, $num = 10)
 
         */\r
        \r
-       $sql = "select * from users where user_id>'$startat' order by user_id asc limit $num";
+       $sql = "select * from users where user_id>='$startat' order by user_id asc limit $num";
        
        $res = $conn->query($sql);