added user registration confirmation, email "from" setting, lots of

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

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index cf3e0fd..5ce6b9a 100644 (file)
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -53,6 +53,17 @@ 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);
 }\r
 
 function gwvpmini_ConnectDB()\r
@@ -86,6 +97,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 +362,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 +482,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);