X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=5ce6b9a1c0305209b911728fbf0fee1dbfc76d9f;hp=cf3e0fd8ffd7b8f0e9479dbd8569ea5f16f899ab;hb=e39e4b8b84f6f8662af51b3b57c333dff0e3945b;hpb=d179625f4cf5e9dea9e63b33ad6db0d2f8f999c3

diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php
index cf3e0fd..5ce6b9a 100644
--- a/gwvpmini/gwvpmini_db.php
+++ b/gwvpmini/gwvpmini_db.php
@@ -53,6 +53,17 @@ function gwvpmini_getUser($username=null, $email=null, $id=null)
 
 	return $returns;
 
+}
+
+function gwvpmini_RemoveUser($uid)
+{
+	$conn = gwvpmini_ConnectDB();
+	
+	if($uid < 0) return;
+	
+	$sql = "delete from users where user_id='$uid'";
+	
+	return $conn->query($sql);
 }
 
 function gwvpmini_ConnectDB()
@@ -86,6 +97,27 @@ function gwvpmini_ConnectDB()
 	return $DB_CONNECTION;
 }
 
+function gwvpmini_UpdateStatusFromConfirm($confirmhash)
+{
+	$conn = gwvpmini_ConnectDB();
+	
+	$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)
 {
 	
@@ -330,7 +362,10 @@ function gwvpmini_setConfigVal($confname, $confval)
 	*/
 	gwvpmini_eraseConfigVal($confname);
 
-	$conn = gwvpmini_ConnectDB();
+	$conn = gwvpmini_ConnectDB();
+	
+	$sql = "delete from config where config_name='$confname'";
+	$conn->query($sql);
 
 	$sql = "insert into config values('$confname', '$confval')";
 
@@ -447,7 +482,7 @@ function gwvpmini_GetUsers($startat = 0, $num = 10)
 
 	 */
 	
-	$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);