X-Git-Url: https://git.pterodactylus.net/?p=fms.git;a=blobdiff_plain;f=admin%2Fintroductionstatus.php;h=c346ef601ef3df63ea7250ad3ae518b1f2ba4473;hp=b4b5492201175a33c388df89cf239f261a2ae8de;hb=964f55fd550fc711c0320ce6a24ad713040695d0;hpb=868c533e84b3c81b6604b45b84efa32073aa20b4 diff --git a/admin/introductionstatus.php b/admin/introductionstatus.php index b4b5492..c346ef6 100644 --- a/admin/introductionstatus.php +++ b/admin/introductionstatus.php @@ -8,7 +8,7 @@ function content() global $dblocation; $db=new PDO('sqlite:'.$dblocation); - $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;"); + $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;"); $st->execute(); ?> @@ -23,7 +23,7 @@ function content() { ?> - +