diff options
author | Andrew Dolgov <[email protected]> | 2008-09-18 05:53:36 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-09-18 05:53:36 +0100 |
commit | 5a437c88d78ab42fa17ba29176be58e46561b4c6 (patch) | |
tree | 76e5c2b8895f77e4f3f5b6133be3f339de786865 | |
parent | f6d9a4f233f319added70e0d9bd26e80ceef7e31 (diff) |
move user details to pref-users; code cleanup
-rw-r--r-- | backend.php | 120 | ||||
-rw-r--r-- | modules/popup-dialog.php | 1 | ||||
-rw-r--r-- | modules/pref-users.php | 107 | ||||
-rw-r--r-- | prefs.js | 2 |
4 files changed, 108 insertions, 122 deletions
diff --git a/backend.php b/backend.php index d5f9741a2..fa116458c 100644 --- a/backend.php +++ b/backend.php @@ -417,126 +417,6 @@ </rpc-reply>"; break; // globalUpdateFeeds - case "user-details": - - if (WEB_DEMO_MODE || $_SESSION["access_level"] < 10) { - return; - } - - /* - print "<html><head> - <title>Tiny Tiny RSS : User Details</title> - <link rel=\"stylesheet\" href=\"tt-rss.css\" type=\"text/css\"> - <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"> - </head><body>"; - */ - - $uid = sprintf("%d", $_GET["id"]); - - print "<div id=\"infoBoxTitle\">User details</div>"; - - print "<div class='infoBoxContents'>"; - - $result = db_query($link, "SELECT login, - ".SUBSTRING_FOR_DATE."(last_login,1,16) AS last_login, - access_level, - (SELECT COUNT(int_id) FROM ttrss_user_entries - WHERE owner_uid = id) AS stored_articles, - ".SUBSTRING_FOR_DATE."(created,1,16) AS created - FROM ttrss_users - WHERE id = '$uid'"); - - if (db_num_rows($result) == 0) { - print "<h1>User not found</h1>"; - return; - } - - // print "<h1>User Details</h1>"; - - $login = db_fetch_result($result, 0, "login"); - - // print "<h1>$login</h1>"; - - print "<table width='100%'>"; - - $last_login = date(get_pref($link, 'LONG_DATE_FORMAT'), - strtotime(db_fetch_result($result, 0, "last_login"))); - - $created = date(get_pref($link, 'LONG_DATE_FORMAT'), - strtotime(db_fetch_result($result, 0, "created"))); - - $access_level = db_fetch_result($result, 0, "access_level"); - $stored_articles = db_fetch_result($result, 0, "stored_articles"); - - // print "<tr><td>Username</td><td>$login</td></tr>"; - // print "<tr><td>Access level</td><td>$access_level</td></tr>"; - print "<tr><td>".__('Registered')."</td><td>$created</td></tr>"; - print "<tr><td>".__('Last logged in')."</td><td>$last_login</td></tr>"; - print "<tr><td>".__('Stored articles')."</td><td>$stored_articles</td></tr>"; - - $result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds - WHERE owner_uid = '$uid'"); - - $num_feeds = db_fetch_result($result, 0, "num_feeds"); - - print "<tr><td>".__('Subscribed feeds count')."</td><td>$num_feeds</td></tr>"; - - /* - $result = db_query($link, "SELECT - SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size - FROM ttrss_user_entries,ttrss_entries - WHERE owner_uid = '$uid' AND ref_id = id"); - - $db_size = round(db_fetch_result($result, 0, "db_size") / 1024); - - print "<tr><td>Approx. used DB size</td><td>$db_size KBytes</td></tr>"; - */ - - print "</table>"; - - print "<h1>".__('Subscribed feeds')."</h1>"; - - $result = db_query($link, "SELECT id,title,site_url FROM ttrss_feeds - WHERE owner_uid = '$uid' ORDER BY title"); - - print "<ul class=\"userFeedList\">"; - - $row_class = "odd"; - - while ($line = db_fetch_assoc($result)) { - - $icon_file = ICONS_URL."/".$line["id"].".ico"; - - if (file_exists($icon_file) && filesize($icon_file) > 0) { - $feed_icon = "<img class=\"tinyFeedIcon\" src=\"$icon_file\">"; - } else { - $feed_icon = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\">"; - } - - print "<li class=\"$row_class\">$feed_icon <a href=\"".$line["site_url"]."\">".$line["title"]."</a></li>"; - - $row_class = toggleEvenOdd($row_class); - - } - - if (db_num_rows($result) < $num_feeds) { - // FIXME - add link to show ALL subscribed feeds here somewhere - print "<li><img - class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\"> ...</li>"; - } - - print "</ul>"; - - print "</div>"; - - print "<div align='center'> - <input type='submit' class='button' - onclick=\"closeInfoBox()\" value=\"Close this window\"></div>"; - - // print "</body></html>"; - - break; // user-details - case "pref-feed-browser": module_pref_feed_browser($link); break; // pref-feed-browser diff --git a/modules/popup-dialog.php b/modules/popup-dialog.php index e54e74584..f86dd3db0 100644 --- a/modules/popup-dialog.php +++ b/modules/popup-dialog.php @@ -452,7 +452,6 @@ } print "</ul>"; - print "</div>"; print "<div align='center'>"; diff --git a/modules/pref-users.php b/modules/pref-users.php index 7d6c369fc..061927033 100644 --- a/modules/pref-users.php +++ b/modules/pref-users.php @@ -10,6 +10,113 @@ $subop = $_GET["subop"]; + if ($subop == "user-details") { + + $uid = sprintf("%d", $_GET["id"]); + + print "<div id=\"infoBoxTitle\">User details</div>"; + + print "<div class='infoBoxContents'>"; + + $result = db_query($link, "SELECT login, + ".SUBSTRING_FOR_DATE."(last_login,1,16) AS last_login, + access_level, + (SELECT COUNT(int_id) FROM ttrss_user_entries + WHERE owner_uid = id) AS stored_articles, + ".SUBSTRING_FOR_DATE."(created,1,16) AS created + FROM ttrss_users + WHERE id = '$uid'"); + + if (db_num_rows($result) == 0) { + print "<h1>User not found</h1>"; + return; + } + + // print "<h1>User Details</h1>"; + + $login = db_fetch_result($result, 0, "login"); + + // print "<h1>$login</h1>"; + + print "<table width='100%'>"; + + $last_login = date(get_pref($link, 'LONG_DATE_FORMAT'), + strtotime(db_fetch_result($result, 0, "last_login"))); + + $created = date(get_pref($link, 'LONG_DATE_FORMAT'), + strtotime(db_fetch_result($result, 0, "created"))); + + $access_level = db_fetch_result($result, 0, "access_level"); + $stored_articles = db_fetch_result($result, 0, "stored_articles"); + + // print "<tr><td>Username</td><td>$login</td></tr>"; + // print "<tr><td>Access level</td><td>$access_level</td></tr>"; + print "<tr><td>".__('Registered')."</td><td>$created</td></tr>"; + print "<tr><td>".__('Last logged in')."</td><td>$last_login</td></tr>"; + print "<tr><td>".__('Stored articles')."</td><td>$stored_articles</td></tr>"; + + $result = db_query($link, "SELECT COUNT(id) as num_feeds FROM ttrss_feeds + WHERE owner_uid = '$uid'"); + + $num_feeds = db_fetch_result($result, 0, "num_feeds"); + + print "<tr><td>".__('Subscribed feeds count')."</td><td>$num_feeds</td></tr>"; + + /* + $result = db_query($link, "SELECT + SUM(LENGTH(content)+LENGTH(title)+LENGTH(link)+LENGTH(guid)) AS db_size + FROM ttrss_user_entries,ttrss_entries + WHERE owner_uid = '$uid' AND ref_id = id"); + + $db_size = round(db_fetch_result($result, 0, "db_size") / 1024); + + print "<tr><td>Approx. used DB size</td><td>$db_size KBytes</td></tr>"; + */ + + print "</table>"; + + print "<h1>".__('Subscribed feeds')."</h1>"; + + $result = db_query($link, "SELECT id,title,site_url FROM ttrss_feeds + WHERE owner_uid = '$uid' ORDER BY title"); + + print "<ul class=\"userFeedList\">"; + + $row_class = "odd"; + + while ($line = db_fetch_assoc($result)) { + + $icon_file = ICONS_URL."/".$line["id"].".ico"; + + if (file_exists($icon_file) && filesize($icon_file) > 0) { + $feed_icon = "<img class=\"tinyFeedIcon\" src=\"$icon_file\">"; + } else { + $feed_icon = "<img class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\">"; + } + + print "<li class=\"$row_class\">$feed_icon <a href=\"".$line["site_url"]."\">".$line["title"]."</a></li>"; + + $row_class = toggleEvenOdd($row_class); + + } + + if (db_num_rows($result) < $num_feeds) { + // FIXME - add link to show ALL subscribed feeds here somewhere + print "<li><img + class=\"tinyFeedIcon\" src=\"images/blank_icon.gif\"> ...</li>"; + } + + print "</ul>"; + + print "<div align='center'> + <input type='submit' class='button' + onclick=\"closeInfoBox()\" value=\"Close this window\"></div>"; + + print "</div>"; + + return; + } + if ($subop == "edit") { $id = db_escape_string($_GET["id"]); @@ -1113,7 +1113,7 @@ function selectedUserDetails() { var id = rows[0]; - xmlhttp.open("GET", "backend.php?op=user-details&id=" + id, true); + xmlhttp.open("GET", "backend.php?op=pref-users&subop=user-details&id=" + id, true); xmlhttp.onreadystatechange=infobox_callback; xmlhttp.send(null); |