]> git.wh0rd.org - tt-rss.git/blobdiff - modules/pref-users.php
js: misc fixes, code cleanup
[tt-rss.git] / modules / pref-users.php
index d8f882f18d99f4d72593515f03fdb20539a760ba..bed5d45ed8ecb7fba16360172f4ecbd3aa9e7579 100644 (file)
                        return;
                }
 
-               $subop = $_GET["subop"];
+               $subop = $_REQUEST["subop"];
+
+               if ($subop == "user-details") {
+
+                       $uid = sprintf("%d", $_REQUEST["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 "<table width='100%'>";
+
+                       $last_login = make_local_datetime($link,
+                               db_fetch_result($result, 0, "last_login"), true);
+
+                       $created = make_local_datetime($link,
+                               db_fetch_result($result, 0, "created"), true);
+
+                       $access_level = db_fetch_result($result, 0, "access_level");
+                       $stored_articles = db_fetch_result($result, 0, "stored_articles");
+
+                       print "<tr><td>".__('Registered')."</td><td>$created</td></tr>";
+                       print "<tr><td>".__('Last logged in')."</td><td>$last_login</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>";
+       
+                       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&nbsp;<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\">&nbsp;...</li>";
+                       }
+                       
+                       print "</ul>";
+
+                       print "<div align='center'>
+                               <button onclick=\"closeInfoBox()\">".__("Close this window").
+                               "</button></div>";
+
+                       print "</div>";
+
+                       return;
+               }
 
                if ($subop == "edit") {
 
-                       $id = db_escape_string($_GET["id"]);
+                       $id = db_escape_string($_REQUEST["id"]);
 
-                       print "<div id=\"infoBoxTitle\">".__('User editor')."</div>";
+                       print "<div id=\"infoBoxTitle\">".__('User Editor')."</div>";
                        
                        print "<div class=\"infoBoxContents\">";
 
                        $access_level = db_fetch_result($result, 0, "access_level");
                        $email = db_fetch_result($result, 0, "email");
 
-                       print "<table width='100%'>";
-                       print "<tr><td>".__('Login:')."</td><td>
-                               <input class=\"iedit\" onkeypress=\"return filterCR(event)\"
-                               name=\"login\" value=\"$login\"></td></tr>";
+                       $sel_disabled = ($id == $_SESSION["uid"]) ? "disabled" : "";
 
-                       print "<tr><td>".__('Change password:')."</td><td>
-                               <input class=\"iedit\" onkeypress=\"return filterCR(event)\"
-                               name=\"password\"></td></tr>";
+                       print "<div class=\"dlgSec\">".__("User")."</div>";
+                       print "<div class=\"dlgSecCont\">";
 
-                       print "<tr><td>".__('E-mail:')."</td><td>
-                               <input class=\"iedit\" name=\"email\" onkeypress=\"return filterCR(event)\"
-                               value=\"$email\"></td></tr>";
+                       if ($sel_disabled) {
+                               print "<input type=\"hidden\" name=\"login\" value=\"$login\">";
+                               print "<input size=\"30\" style=\"font-size : 16px\" 
+                                       onkeypress=\"return filterCR(event, userEditSave)\" $sel_disabled
+                                       value=\"$login\">";
+                       } else {
+                               print "<input size=\"30\" style=\"font-size : 16px\" 
+                                       onkeypress=\"return filterCR(event, userEditSave)\" $sel_disabled
+                                       name=\"login\" value=\"$login\">";
+                       }
 
-                       $sel_disabled = ($id == $_SESSION["uid"]) ? "disabled" : "";
-                               
-                       print "<tr><td>".__('Access level:')."</td><td>";
-                       print_select_hash("access_level", $access_level, $access_level_names, 
-                               $sel_disabled);
-                       print "</td></tr>";
+                       print "</div>";
+
+                       print "<div class=\"dlgSec\">".__("Authentication")."</div>";
+                       print "<div class=\"dlgSecCont\">";
+
+                       print __('Access level: ') . " ";
+
+                       if (!$sel_disabled) {
+                               print_select_hash("access_level", $access_level, $access_level_names, 
+                                       $sel_disabled);
+                       } else {
+                               print_select_hash("", $access_level, $access_level_names, 
+                                       $sel_disabled);
+                               print "<input type=\"hidden\" name=\"access_level\" value=\"$access_level\">";
+                       }
+
+                       print "<br/>";
+
+                       print __('Change password to') .
+                               " <input size=\"20\" onkeypress=\"return filterCR(event, userEditSave)\"
+                               name=\"password\">";
+
+                       print "</div>";
+
+                       print "<div class=\"dlgSec\">".__("Options")."</div>";
+                       print "<div class=\"dlgSecCont\">";
+
+                       print __('E-mail: ').
+                               " <input size=\"30\" name=\"email\" onkeypress=\"return filterCR(event, userEditSave)\"
+                               value=\"$email\">";
+
+                       print "</div>";
 
                        print "</table>";
 
                        print "</form>";
-                       
-                       print "<div align='right'>
-                               <input class=\"button\"
-                                       type=\"submit\" onclick=\"return userEditSave()\" 
-                                       value=\"".__('Save')."\">
-                               <input class=\"button\"
-                                       type=\"submit\" onclick=\"return userEditCancel()\" 
-                                       value=\"".__('Cancel')."\"></div>";
+
+                       print "<div class=\"dlgButtons\">
+                               <button onclick=\"return userEditSave()\">".
+                                       __('Save')."</button>
+                               <button onclick=\"return userEditCancel()\">".
+                                       __('Cancel')."</button></div>";
 
                        print "</div>";
 
 
                if ($subop == "editSave") {
        
-                       if (!WEB_DEMO_MODE && $_SESSION["access_level"] >= 10) {
+                       if ($_SESSION["access_level"] >= 10) {
 
-                               $login = db_escape_string(trim($_GET["login"]));
-                               $uid = db_escape_string($_GET["id"]);
-                               $access_level = (int) $_GET["access_level"];
-                               $email = db_escape_string(trim($_GET["email"]));
-                               $password = db_escape_string(trim($_GET["password"]));
+                               $login = db_escape_string(trim($_REQUEST["login"]));
+                               $uid = db_escape_string($_REQUEST["id"]);
+                               $access_level = (int) $_REQUEST["access_level"];
+                               $email = db_escape_string(trim($_REQUEST["email"]));
+                               $password = db_escape_string(trim($_REQUEST["password"]));
 
                                if ($password) {
                                        $pwd_hash = encrypt_password($password, $login);
                        }
                } else if ($subop == "remove") {
 
-                       if (!WEB_DEMO_MODE && $_SESSION["access_level"] >= 10) {
+                       if ($_SESSION["access_level"] >= 10) {
 
-                               $ids = split(",", db_escape_string($_GET["ids"]));
+                               $ids = split(",", db_escape_string($_REQUEST["ids"]));
 
                                foreach ($ids as $id) {
-                                       db_query($link, "BEGIN");
-                                       db_query($link, "DELETE FROM ttrss_feeds WHERE owner_uid = '$id' AND owner_uid != " . $_SESSION["uid"]);
-                                       db_query($link, "DELETE FROM ttrss_users WHERE id = '$id' AND id != " . $_SESSION["uid"]);
-                                       db_query($link, "COMMIT");
-                                       
+                                       if ($id != $_SESSION["uid"] && $id != 1) {
+                                               db_query($link, "DELETE FROM ttrss_tags WHERE owner_uid = '$id'");
+                                               db_query($link, "DELETE FROM ttrss_feeds WHERE owner_uid = '$id'");
+                                               db_query($link, "DELETE FROM ttrss_users WHERE id = '$id'");
+                                       }
                                }
                        }
                } else if ($subop == "add") {
                
-                       if (!WEB_DEMO_MODE && $_SESSION["access_level"] >= 10) {
+                       if ($_SESSION["access_level"] >= 10) {
 
-                               $login = db_escape_string(trim($_GET["login"]));
+                               $login = db_escape_string(trim($_REQUEST["login"]));
                                $tmp_user_pwd = make_password(8);
                                $pwd_hash = encrypt_password($tmp_user_pwd, $login);
 
                        } 
                } else if ($subop == "resetPass") {
 
-                       if (!WEB_DEMO_MODE && $_SESSION["access_level"] >= 10) {
+                       if ($_SESSION["access_level"] >= 10) {
 
-                               $uid = db_escape_string($_GET["id"]);
+                               $uid = db_escape_string($_REQUEST["id"]);
 
                                $result = db_query($link, "SELECT login,email 
                                        FROM ttrss_users WHERE id = '$uid'");
                                print_notice(T_sprintf("Changed password of user <b>%s</b>
                                         to <b>%s</b>", $login, $tmp_user_pwd));
 
-                               if (MAIL_RESET_PASS && $email) {
+                               if ($email) {
                                        print_notice(T_sprintf("Notifying <b>%s</b>.", $email));
 
-                                       require_once "MiniTemplator.class.php";
+                                       require_once "lib/MiniTemplator.class.php";
 
                                        $tpl = new MiniTemplator;
 
 
                                        $mail = new PHPMailer();
 
-                                       $mail->PluginDir = "phpmailer/";
-                                       $mail->SetLanguage("en", "phpmailer/language/");
+                                       $mail->PluginDir = "lib/phpmailer/";
+                                       $mail->SetLanguage("en", "lib/phpmailer/language/");
 
                                        $mail->CharSet = "UTF-8";
 
                                        if (DIGEST_SMTP_HOST) {
                                                $mail->Host = DIGEST_SMTP_HOST;
                                                $mail->Mailer = "smtp";
+                                               $mail->SMTPAuth = DIGEST_SMTP_LOGIN != '';
                                                $mail->Username = DIGEST_SMTP_LOGIN;
                                                $mail->Password = DIGEST_SMTP_PASSWORD;
                                        }
 
                                        $mail->IsHTML(false);
-                                       $mail->Subject = __("Password change notification");
+                                       $mail->Subject = __("[tt-rss] Password change notification");
                                        $mail->Body = $message;
 
                                        $rc = $mail->Send();
 
                set_pref($link, "_PREFS_ACTIVE_TAB", "userConfig");
 
-               $user_search = db_escape_string($_GET["search"]);
+               $user_search = db_escape_string($_REQUEST["search"]);
 
-               if (array_key_exists("search", $_GET)) {
+               if (array_key_exists("search", $_REQUEST)) {
                        $_SESSION["prefs_user_search"] = $user_search;
                } else {
                        $user_search = $_SESSION["prefs_user_search"];
                }
 
-               print "<div class=\"feedEditSearch\">
+               print "<div style='float : right'>
                        <input id=\"user_search\" size=\"20\" type=\"search\"
                                onfocus=\"javascript:disableHotkeys();\" 
                                onblur=\"javascript:enableHotkeys();\"
                                onchange=\"javascript:updateUsersList()\" value=\"$user_search\">
-                       <input type=\"submit\" class=\"button\" 
-                               onclick=\"javascript:updateUsersList()\" value=\"".__('Search')."\">
+                       <button onclick=\"javascript:updateUsersList()\">".
+                               __('Search')."</button>
                        </div>";
 
-               $sort = db_escape_string($_GET["sort"]);
+               $sort = db_escape_string($_REQUEST["sort"]);
 
                if (!$sort || $sort == "undefined") {
                        $sort = "login";
                }
 
-               print "<div class=\"prefGenericAddBox\">
-                       <input id=\"uadd_box\"                  
-                               onkeyup=\"toggleSubmitNotEmpty(this, 'user_add_btn')\"
-                               onchange=\"toggleSubmitNotEmpty(this, 'user_add_btn')\"
-                               size=\"40\">&nbsp;";
-                       
-               print "<input type=\"submit\" class=\"button\" 
-                       id=\"user_add_btn\" disabled=\"true\"
-                       onclick=\"javascript:addUser()\" value=\"".__('Create user')."\"></div>";
+               print "<button onclick=\"javascript:addUser()\">".__('Create user')."</button>";
+
+               print "
+                       <button onclick=\"javascript:selectedUserDetails()\">".
+                       __('Details')."</button>
+                       <button onclick=\"javascript:editSelectedUser()\">".
+                       __('Edit')."</button>
+                       <button onclick=\"javascript:removeSelectedUsers()\">".
+                       __('Remove')."</button>
+                       <button onclick=\"javascript:resetSelectedUserPass()\">".
+                       __('Reset password')."</button>";
+
+               print "</div>";
 
                if ($user_search) {
-                       $user_search_query = "UPPER(login) LIKE UPPER('%$user_search%') AND";
+
+                       $user_search = split(" ", $user_search);
+                       $tokens = array();
+
+                       foreach ($user_search as $token) {                      
+                               $token = trim($token);
+                               array_push($tokens, "(UPPER(login) LIKE UPPER('%$token%'))");
+                       }
+
+                       $user_search_query = "(" . join($tokens, " AND ") . ") AND ";
+
                } else {
                        $user_search_query = "";
                }
 
                print "<tr><td class=\"selectPrompt\" colspan=\"8\">
                                ".__('Select:')." 
-                                       <a href=\"javascript:selectPrefRows('user', true)\">".__('All')."</a>,
-                                       <a href=\"javascript:selectPrefRows('user', false)\">".__('None')."</a>
+                                       <a href=\"#\" onclick=\"selectTableRows('prefUserList', 'all')\">".__('All')."</a>,
+                                       <a href=\"#\" onclick=\"selectTableRows('prefUserList', 'none')\">".__('None')."</a>
                                </td</tr>";
 
                print "<tr class=\"title\">
                                        <td align='center' width=\"5%\">&nbsp;</td>
-                                       <td width=''><a href=\"javascript:updateUsersList('login')\">".__('Login')."</a></td>
-                                       <td width='20%'><a href=\"javascript:updateUsersList('access_level')\">".__('Access Level')."</a></td>
-                                       <td width='20%'><a href=\"javascript:updateUsersList('created')\">".__('Registered')."</a></td>
-                                       <td width='20%'><a href=\"javascript:updateUsersList('last_login')\">".__('Last login')."</a></td></tr>";
+                                       <td width=''><a href=\"#\" onclick=\"updateUsersList('login')\">".__('Login')."</a></td>
+                                       <td width='20%'><a href=\"#\" onclick=\"updateUsersList('access_level')\">".__('Access Level')."</a></td>
+                                       <td width='20%'><a href=\"#\" onclick=\"updateUsersList('created')\">".__('Registered')."</a></td>
+                                       <td width='20%'><a href=\"#\" onclick=\"updateUsersList('last_login')\">".__('Last login')."</a></td></tr>";
                
                $lnum = 0;
                
                        $class = ($lnum % 2) ? "even" : "odd";
 
                        $uid = $line["id"];
-                       $edit_uid = $_GET["id"];
+                       $edit_uid = $_REQUEST["id"];
 
                        if ($subop == "edit" && $uid != $edit_uid) {
                                $class .= "Grayed";
 
                        $line["login"] = htmlspecialchars($line["login"]);
 
-#                      $line["last_login"] = date(get_pref($link, 'SHORT_DATE_FORMAT'),
-#                              strtotime($line["last_login"]));
-
-                       if (get_pref($link, 'HEADLINES_SMART_DATE')) {
-                               $line["last_login"] = smart_date_time(strtotime($line["last_login"]));
-                               $line["created"] = smart_date_time(strtotime($line["created"]));
-                       } else {
-                               $line["last_login"] = date(get_pref($link, 'SHORT_DATE_FORMAT'),
-                                       strtotime($line["last_login"]));
-                               $line["created"] = date(get_pref($link, 'SHORT_DATE_FORMAT'),
-                                       strtotime($line["created"]));
-                       }                               
+                       $line["created"] = make_local_datetime($link, $line["created"], false);
+                       $line["last_login"] = make_local_datetime($link, $line["last_login"], false);
 
-                       print "<td align='center'><input onclick='toggleSelectPrefRow(this, \"user\");' 
+                       print "<td align='center'><input onclick='toggleSelectRow(this);' 
                                type=\"checkbox\" id=\"UMCHK-$uid\"></td>";
 
-                       $onclick = "onclick='editUser($uid)' title='".__('Click to edit')."'";
+                       $onclick = "onclick='editUser($uid, event)' title='".__('Click to edit')."'";
 
                        print "<td $onclick>" . $line["login"] . "</td>";               
 
 
                print "</table>";
 
-               print "<p id='userOpToolbar'>";
-
-               print "                         
-                       <input type=\"submit\" class=\"button\" disabled=\"true\"
-                               onclick=\"javascript:selectedUserDetails()\" value=\"".__('User details')."\">
-                       <input type=\"submit\" class=\"button\" disabled=\"true\"
-                               onclick=\"javascript:editSelectedUser()\" value=\"".__('Edit')."\">
-                       <input type=\"submit\" class=\"button\" disabled=\"true\"
-                               onclick=\"javascript:removeSelectedUsers()\" value=\"".__('Remove')."\">
-                       <input type=\"submit\" class=\"button\" disabled=\"true\"
-                               onclick=\"javascript:resetSelectedUserPass()\" value=\"".__('Reset password')."\">";
-
                } else {
                        print "<p>";
                        if (!$user_search) {
-                               print __('No users defined.');
+                               print_warning(__('No users defined.'));
                        } else {
-                               print __('No matching users found.');
+                               print_warning(__('No matching users found.'));
                        }
                        print "</p>";