PATCH: Add aditional user info into the admin page

[Pedro Algarvio, aka, s0undt3ch]

Here's a patch that adds aditional info to the admin page of the account manager plugin:

acct_mgr/admin.py

@@ -9 +9 @@
 #
 # Author: Matthew Good <trac@matt-good.net>
 
+from datetime import date
+
 from trac.core import *
 from trac.perm import PermissionSystem
 from trac.util import sorted
@@ -43 +45 @@
                 for account in sel:
                     self.account_manager.delete_user(account)
 
-        req.hdf['accounts'] = sorted(self.account_manager.get_users())
+        accounts = sorted(self.account_manager.get_users())
+        db = self.env.get_db_cnx()
+        cursor = db.cursor()
+        hdf_accounts = []
+        for account in accounts:
+            QUERY = "SELECT name,value FROM session_attribute WHERE sid=%s AND authenticated=%s"
+            cursor.execute(QUERY, (account,1))
+            attrs = cursor.fetchall()
+            acc_dict = dict(attrs)
+            acc_dict['username'] = account
+            QUERY = "SELECT last_visit FROM session WHERE sid=%s AND authenticated=%s"
+            cursor.execute(QUERY, (account,1))
+            acc_dict['last_visit'] = date.fromtimestamp(cursor.fetchone()[0])
+            hdf_accounts.append(acc_dict)
+
+
+        decorated = [(dict_['username'], dict_) for dict_ in hdf_accounts]
+        decorated.sort()
+        sorted_accounts = [dict_ for (key, dict_) in decorated]
+        req.hdf['accounts'] = sorted_accounts
 
         return 'admin_accounts.cs', None
-
+

acct_mgr/templates/admin_accounts.cs

@@ -32 +32 @@
 <form method="post">
  <table class="listing" id="accountlist">
   <thead>
-   <tr><th class="sel">&nbsp;</th><th>Account</th></tr>
+   <tr><th class="sel">&nbsp;</th><th>Account</th><th>Name</th><th>Email</th><th>Last Login</th></tr>
   </thead><tbody><?cs
   each:account = accounts ?>
    <tr>
-    <td><input type="checkbox" name="sel" value="<?cs var:account ?>" /></td>
-    <td><?cs var:account ?></td>
+    <td><input type="checkbox" name="sel" value="<?cs var:account.username ?>" /></td>
+    <td><?cs var:account.username ?></td>
+    <td><?cs var:account.name ?></td>
+    <td><?cs var:account.email ?></td>
+    <td><?cs var:account.last_visit ?></td>
    </tr><?cs
   /each ?></tbody>
  </table>