version 0.1.2

[fms.git] / admin / introductionstatus.php

diff --git a/admin/introductionstatus.php b/admin/introductionstatus.php
index b4b5492..c346ef6 100644 (file)
--- a/admin/introductionstatus.php
+++ b/admin/introductionstatus.php
@@ -8,7 +8,7 @@ function content()
        global $dblocation;\r
        \r
        $db=new PDO('sqlite:'.$dblocation);\r
-       $st=$db->prepare("SELECT tblLocalIdentity.Name, COUNT(Inserted) FROM tblLocalIdentity LEFT JOIN tblIdentityIntroductionInserts ON tblLocalIdentity.LocalIdentityID=tblIdentityIntroductionInserts.LocalIdentityID WHERE (Inserted='true' OR Inserted IS NULL) GROUP BY tblLocalIdentity.LocalIdentityID;");\r
+       $st=$db->prepare("SELECT tblLocalIdentity.Name, COUNT(Inserted), tblLocalIdentity.PublicKey FROM tblLocalIdentity LEFT JOIN tblIdentityIntroductionInserts ON tblLocalIdentity.LocalIdentityID=tblIdentityIntroductionInserts.LocalIdentityID WHERE (Inserted='true' OR Inserted IS NULL) GROUP BY tblLocalIdentity.LocalIdentityID;");\r
        $st->execute();\r
        \r
        ?>\r
@@ -23,7 +23,7 @@ function content()
                {\r
                        ?>\r
                <tr>\r
-                       <td>\r
+                       <td title="<?php print $record[2]; ?>">\r
                                <?php print $record[0]; ?>\r
                        </td>\r
                        <td>\r