Source code taken from cacert-20131016.tar.bz2
[cacert-devel.git] / scripts / nearest.php
1 #!/usr/bin/php -q
2 <? /*
3 LibreSSL - CAcert web application
4 Copyright (C) 2004-2008 CAcert Inc.
5
6 This program is free software; you can redistribute it and/or modify
7 it under the terms of the GNU General Public License as published by
8 the Free Software Foundation; version 2 of the License.
9
10 This program is distributed in the hope that it will be useful,
11 but WITHOUT ANY WARRANTY; without even the implied warranty of
12 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 GNU General Public License for more details.
14
15 You should have received a copy of the GNU General Public License
16 along with this program; if not, write to the Free Software
17 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
18 */
19
20 // Searches for all assurers in a certain region
21
22 include_once("../includes/mysql.php");
23
24 $query = "select * from `users` where `locid`=33572 OR `regid`=870";
25 $res = mysql_query($query);
26 while($row = mysql_fetch_assoc($res))
27 {
28 $ass = mysql_num_rows(mysql_query("select * from `notary` where `from`='".$row['id']."' and `from`!=`to`"));
29 $dres = mysql_query("select sum(`points`) as `tp` from `notary` where `to`='".$row['id']."'");
30 $drow = mysql_fetch_assoc($dres);
31 if($drow['tp'] < 100)
32 echo $row['fname']." ".$row['lname']." <".$row['email']."> (memid: ".$row['id']." assurances: $ass tp: ".$drow['tp'].")\n";
33 }
34 ?>