X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=d75ebcd93eaacd0a0b55809d1495ea0a3c2122cd;hp=5ce6b9a1c0305209b911728fbf0fee1dbfc76d9f;hb=b465be6b98b6bc09b37bba18aa65251fdd224555;hpb=f8e168861e54735c5893f4f7f8908fdbba1876f0 diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php index 5ce6b9a..d75ebcd 100644 --- 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) { $res = $conn->query("select * from users where user_email='$email'"); } else if($id != null) { - $res = $conn->query("select * from users where users_id='$id'"); + $res = $conn->query("select * from users where user_id='$id'"); } else return false; $returns = false; @@ -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(); + + if($uid < 0) return; + + $sql = "update users set user_status=1 where user_id='$uid'"; + + return $conn->query($sql); } +function gwvpmini_EnableUser($uid) +{ + $conn = gwvpmini_ConnectDB(); + + if($uid < 0) return; + + $sql = "update users set user_status=0 where user_id='$uid'"; + + return $conn->query($sql); +} + + function gwvpmini_ConnectDB() { global $WEB_ROOT_FS, $BASE_URL, $data_directory, $db_type, $db_name, $DB_CONNECTION;