From 83f3c4114164617f48f3b013027f9079ddc2675c Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Mon, 2 Jan 2006 01:06:06 +0000 Subject: updated registration mojo thx pb1dft also some fluf updates --- lib/class/access.class.php | 3 +++ lib/class/album.class.php | 5 +++-- lib/class/artist.class.php | 2 +- lib/class/catalog.class.php | 3 +++ lib/class/error.class.php | 2 +- lib/class/genre.class.php | 2 +- lib/class/playlist.class.php | 2 +- lib/class/rating.class.php | 2 +- lib/class/song.class.php | 2 +- lib/class/stream.class.php | 2 +- lib/class/update.class.php | 2 +- lib/class/user.class.php | 33 +++++++++++++++++++++++++++++---- lib/class/view.class.php | 2 +- 13 files changed, 47 insertions(+), 15 deletions(-) (limited to 'lib/class') diff --git a/lib/class/access.class.php b/lib/class/access.class.php index 85fc3a81..8a0ad168 100644 --- a/lib/class/access.class.php +++ b/lib/class/access.class.php @@ -1,6 +1,9 @@ offset_limit = $info->offset_limit; $this->email = $info->email; $this->last_seen = $info->last_seen; + $this->reg_date = $info->reg_date; + $this->validation = $info->validation; $this->set_preferences(); // Make sure the Full name is always filled @@ -476,10 +480,9 @@ class User { $username = sql_escape($username); $fullname = sql_escape($fullname); $email = sql_escape($email); - /* Now Insert this new user */ - $sql = "INSERT INTO user (username, fullname, email, password, access) VALUES" . - " ('$username','$fullname','$email',PASSWORD('$password'),'$access')"; + $sql = "INSERT INTO user (username, fullname, email, password, access, reg_date) VALUES" . + " ('$username','$fullname','$email',PASSWORD('$password'),'$access', unix_timestamp())"; $db_results = mysql_query($sql, dbh()); if (!$db_results) { return false; } @@ -737,9 +740,31 @@ class User { @description calcs difference between now and last_seen if less than delay, we consider them still online */ + function is_online( $delay = 1200 ) { return time() - $this->last_seen <= $delay; } + /*! + @function get_user_validation + @check if user exists before activation can be done. + */ + function get_user_validation($username,$validation){ + $sql = "SELECT validation FROM user where username='$username'"; + $db_results = mysql_query($sql, dbh()); + $row = mysql_fetch_array($db_results); + $val = $row[validation]; + return $val; + } // get_user_validation + + /*! + @function activate_user + @activates the user from public_registration + */ + function activate_user($username) { + $sql = "UPDATE user SET disabled='0' WHERE username='$username'"; + $db_results = mysql_query($sql, dbh()); + } // activate_user } //end class + ?> diff --git a/lib/class/view.class.php b/lib/class/view.class.php index 112148ad..afc81b22 100644 --- a/lib/class/view.class.php +++ b/lib/class/view.class.php @@ -1,7 +1,7 @@