X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=classes%2Fpref%2Fusers.php;h=a9c3689fdeaf2ca2ebc6136595905cc9e539ea11;hb=6322ac79a020ab584d412d782d62b2ee77d7c6cf;hp=bd2fff735346e624da8a2553132f1001d10fd1d5;hpb=aca75cb5cb323535099c7aef46a78ea3cec082f2;p=tt-rss.git diff --git a/classes/pref/users.php b/classes/pref/users.php index bd2fff73..a9c3689f 100644 --- a/classes/pref/users.php +++ b/classes/pref/users.php @@ -21,7 +21,7 @@ class Pref_Users extends Handler_Protected { $uid = sprintf("%d", $_REQUEST["id"]); - $result = db_query($this->link, "SELECT login, + $result = db_query( "SELECT login, ".SUBSTRING_FOR_DATE."(last_login,1,16) AS last_login, access_level, (SELECT COUNT(int_id) FROM ttrss_user_entries @@ -41,10 +41,10 @@ class Pref_Users extends Handler_Protected { print ""; - $last_login = make_local_datetime($this->link, + $last_login = make_local_datetime( db_fetch_result($result, 0, "last_login"), true); - $created = make_local_datetime($this->link, + $created = make_local_datetime( db_fetch_result($result, 0, "created"), true); $access_level = db_fetch_result($result, 0, "access_level"); @@ -53,7 +53,7 @@ class Pref_Users extends Handler_Protected { print ""; print ""; - $result = db_query($this->link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds + $result = db_query( "SELECT COUNT(id) as num_feeds FROM ttrss_feeds WHERE owner_uid = '$uid'"); $num_feeds = db_fetch_result($result, 0, "num_feeds"); @@ -64,7 +64,7 @@ class Pref_Users extends Handler_Protected { print "

".__('Subscribed feeds')."

"; - $result = db_query($this->link, "SELECT id,title,site_url FROM ttrss_feeds + $result = db_query( "SELECT id,title,site_url FROM ttrss_feeds WHERE owner_uid = '$uid' ORDER BY title"); print "
".__('Registered')."$created
".__('Last logged in')."$last_login