Source code taken from cacert-20141124.tar.bz2
[cacert.git] / pages / account / 56.php
1 <? /*
2 LibreSSL - CAcert web application
3 Copyright (C) 2004-2008 CAcert Inc.
4
5 This program is free software; you can redistribute it and/or modify
6 it under the terms of the GNU General Public License as published by
7 the Free Software Foundation; version 2 of the License.
8
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
13
14 You should have received a copy of the GNU General Public License
15 along with this program; if not, write to the Free Software
16 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
17 */ ?>
18 <?=_("List of Organisation Assurers:")?>
19
20 <table align="center" valign="middle" border="0" cellspacing="0" cellpadding="0" class="wrapper">
21 <tr>
22 <td colspan="1" class="title"><?=_("Name")?></td>
23 <td colspan="1" class="title"><?=_("Email")?></td>
24 <td colspan="1" class="title"><?=_("Country")?></td>
25 </tr>
26 <?
27 $query = "select users.fname,users.lname,users.email, countries.name from users left join countries on users.ccid=countries.id where orgadmin=1;";
28 $res = mysql_query($query);
29 while($row = mysql_fetch_assoc($res))
30 {
31 ?>
32 <tr>
33 <td><?=sanitizeHTML($row['fname'])." ".sanitizeHTML($row['lname'])?></td>
34 <td><a href="mailto:<?=sanitizeHTML($row['email'])?>"><?=sanitizeHTML($row['email'])?></a></td>
35 <td><?=sanitizeHTML($row['name'])?></td>
36 </tr>
37 <?
38 }
39 ?>
40 </table>
41