summaryrefslogtreecommitdiff
path: root/cacert/scripts
diff options
context:
space:
mode:
authorMarkus Warg <mw@it-sls.de>2010-03-11 15:20:31 +0100
committerMarkus Warg <mw@it-sls.de>2010-03-11 15:20:31 +0100
commit725d28c39fafd8719a43525930d7861141e9a53e (patch)
treea7440e9368aba13a64c771a45a9e159408b8f81e /cacert/scripts
parentdf92c83b625715f223070d5d9c9e3f5b814560ec (diff)
downloadcacert-devel-725d28c39fafd8719a43525930d7861141e9a53e.tar.gz
cacert-devel-725d28c39fafd8719a43525930d7861141e9a53e.tar.xz
cacert-devel-725d28c39fafd8719a43525930d7861141e9a53e.zip
source code taken from cacert-20100204.tar.bz2 part 2
Diffstat (limited to 'cacert/scripts')
-rw-r--r--cacert/scripts/ate-de11-email.txt37
-rw-r--r--cacert/scripts/ate-de11-mail.php.txt92
-rw-r--r--cacert/scripts/ate-goteborg-s16-email.txt58
-rw-r--r--cacert/scripts/ate-goteborg-s16-mail.php.txt110
-rw-r--r--cacert/scripts/blit-de15-email.txt23
-rw-r--r--cacert/scripts/blit-de15-mail.php.txt105
-rw-r--r--cacert/scripts/cleanthem.pl24
-rwxr-xr-xcacert/scripts/consistence.php105
-rw-r--r--cacert/scripts/findnull.pl14
-rw-r--r--cacert/scripts/lisa-us13-email.txt12
-rw-r--r--cacert/scripts/lisa-us13-mail.php.txt96
-rw-r--r--cacert/scripts/mission-hills-ca-us17-email.txt17
-rw-r--r--cacert/scripts/mission-hills-ca-us17-mail.php.txt115
-rw-r--r--cacert/scripts/osd-copenhagen-dk18-email.txt35
-rw-r--r--cacert/scripts/osd-copenhagen-dk18-mail.php.txt120
-rw-r--r--cacert/scripts/ost-de14-email.txt22
-rw-r--r--cacert/scripts/ost-de14-mail.php.txt100
-rw-r--r--cacert/scripts/scale8x-los-angeles-ca-us19-email.txt36
-rw-r--r--cacert/scripts/scale8x-los-angeles-ca-us19-mail.php.txt125
-rw-r--r--cacert/scripts/sfd-de12-email.txt24
-rw-r--r--cacert/scripts/sfd-de12-mail.php.txt94
21 files changed, 1364 insertions, 0 deletions
diff --git a/cacert/scripts/ate-de11-email.txt b/cacert/scripts/ate-de11-email.txt
new file mode 100644
index 0000000..21ac13a
--- /dev/null
+++ b/cacert/scripts/ate-de11-email.txt
@@ -0,0 +1,37 @@
+CAcert Assurer Training Event Berlin-Brandenburg
+::::::::::::::::::::::::::::::::::::::::::::::::
+
+Es hat sich viel getan im letzten Jahr. Eine ganze Reihe von bisher eher
+"muendlich ueberlieferten" Regeln wurden in Policies gegossen. Neue
+Prozeduren (z.B. die Assurer Challenge) und Verpflichtungen (z.B. in dem
+CAcert Community Agreement) wurden beschlossen. Die Assurer Training Events
+wollen nun versuchen, die ganzen Informationen "unter's Volk" zu bringen:
+
+- Wovor schuetzt die CCA jedes CAcert-Community-Mitglied und somit auch
+ dich?
+- Kannst du die 5 Statements der "Purpose of Assurance" aufzaehlen?
+- Kannst du auf Anhieb 10 Sicherheitsmerkmale des deutschen Personal-
+ ausweises aufzaehlen?
+
+Antworten auf diese und weitere Fragen erhaelst du bei den Assurer
+Training Events (ATEs).
+
+Der Termin fuer Berlin steht nun fest.
+
+Berlin-Wilmerdorf,
+Donnerstag 09. Juli 2009 in der Zeit von 19:00 bis 21:00 Uhr
+Restaurant Prometheus
+Schlangenbader Strasse
+12345 Berlin-Wilmerdorf
+[http://wiki.cacert.org/wiki/Events/20090709ATE-Berlin]
+
+Anmeldungen erfolgen bitte ausschliesslich ueber folgende Seite:
+[http://cacert-berlin.mixxt.de/networks/events/show_event.7105]
+
+Die Teilnahme an der Veranstaltung ist kostenlos, Spenden werden aber
+gerne gesehen.
+
+Details zum Veranstaltungsort und Anfahrthinweise findet Ihr im Wiki und
+bei mixxt.de, siehe die Links oben.
+
+Kontakt: events@cacert.org
diff --git a/cacert/scripts/ate-de11-mail.php.txt b/cacert/scripts/ate-de11-mail.php.txt
new file mode 100644
index 0000000..7021e5f
--- /dev/null
+++ b/cacert/scripts/ate-de11-mail.php.txt
@@ -0,0 +1,92 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2008 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("ate-de11-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 200;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+
+ $locid = 228950; // Berlin
+
+
+ $city = "Berlin 9. Juli 2009";
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] ATE-$city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] ATE-$city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] ATE-$city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] ATE-$city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>
diff --git a/cacert/scripts/ate-goteborg-s16-email.txt b/cacert/scripts/ate-goteborg-s16-email.txt
new file mode 100644
index 0000000..e1153f7
--- /dev/null
+++ b/cacert/scripts/ate-goteborg-s16-email.txt
@@ -0,0 +1,58 @@
+CAcert Assurer Training Event Goteborg
+::::::::::::::::::::::::::::::::::::::::::::::::::
+
+Much has happened during the past year. A list of up till now mostly
+"orally transmitted" rules have been cast in policies. New procedures
+(e.g. the Assurer Challenge) and obligations (e.g. in the CAcert
+Community Agreement) have been decided. The Assurer Training Events
+try to bring all this informations to "the people":
+
+- To what, does the CCA protect every CAcert-Community-Member and as
+ such also you?
+- Can you recount the 5 statements of the "Purpose of Assurance"?
+- Can you at least recount 10 security marks of the Swedish passport
+ /Identity card?
+
+Answers to these and following questions are given at the Assurer
+Training Events (ATEs).
+Participation in the events is free, Contributions are however
+appreciated.
+
+
+The ATE-Goteborg takes place on:
+- Wednesday, Dec 16th from 20:00 till 22:00
+- at
+- [http://www.gothiatowers.com/]
+- Massans gata 24
+- 402 26 Goteborg, Sweden
+
+The Event-Team is already excited about your participation.
+
+Registration ATE-Goteborg
+[http://wiki.cacert.org/Events/20091216ATE-Goteborg]
+
+Remark from Leif-Joran:
+I have a backup room at my department just a couple of
+hundred meters from Gothia Towers. L307, Lennart Torstenssons-gatan 8
+
+Remarks from Ted:
+As I understand it, it will probably be harder to find a room inside the
+hotel than to find the hotel itself, it boasts to be the biggest hotel
+in Skandinavia...
+
+My mobile phone number is +49 151 52634367. I'm there on a probably
+quite busy business trip, so it may be that I have to cancel the whole
+thing on short notice.
+I propose that you try to contact me by phone before leaving home, so I
+can confirm that I will be there.
+
+Also I don't have much time to prepare, so please don't expect something
+like a professional presentation from me. I hope it will be a nice
+little meeting, we will assure each others, you'll ask questions you
+always wanted to ask about CACert and I'll tell you about all the things
+that have recently changed at CAcert, at least the important ones. And
+maybe I'll try to trick you into making a false assurance, just to show
+you where problems are expected. :-)
+
+
+contact: events@cacert.org
diff --git a/cacert/scripts/ate-goteborg-s16-mail.php.txt b/cacert/scripts/ate-goteborg-s16-mail.php.txt
new file mode 100644
index 0000000..6e4a7c0
--- /dev/null
+++ b/cacert/scripts/ate-goteborg-s16-mail.php.txt
@@ -0,0 +1,110 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("ate-goteborg-s16-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 50;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+// $locid = 1260319; // Muenchen
+// $city = "Muenchen - 20. Nov 2009";
+
+// BLIT2009, Brandenburger Linux-Infotag, 21.11.2009
+// $locid = 1486658; // Potsdam
+// $eventname = "Brandenburger Linux-Infotag (BLIT2009)";
+// $city = "Potsdam - 21. Nov 2009";
+
+// ATE-Goteborg, 16.12.2009
+ $locid = 664715; // Goteborg, Vastra Gotaland, Sweden
+ $eventname = "ATE-Goteborg";
+ $city = "Goteborg - Dec 16th 2009";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>
diff --git a/cacert/scripts/blit-de15-email.txt b/cacert/scripts/blit-de15-email.txt
new file mode 100644
index 0000000..28044ee
--- /dev/null
+++ b/cacert/scripts/blit-de15-email.txt
@@ -0,0 +1,23 @@
+Hallo CAcerties,
+
+kommenden Samstag, 21. November sind wir mit einem Stand und einem Vortrag auf
+dem Brandenburger Linux-Infotag vertreten.
+Bisher haben sich nur zwei CAcert-Repraesentanten auf unserer Wiki Seite
+als Helfer eingetragen.
+Sollte jemand aus Potsdam, Berlin oder sonstwo (also du) Lust und Zeit haben,
+dabei zu sein, tragt euch bitte ein!
+
+Warum wir das nicht alleine schaffen?
+Warum wir gerade dich brauchen?
+Deine Hilfe?
+Wenn wir dort Lehrer, Professoren, wissenschaftliche Mitarbeiter,
+Klassensprecher, Fachschaftler, irgend jemand von CAcert ueberzeugen
+koennen, dann wollen wir 100 Punkte vergeben koennen, dass neue
+Keimzellen entstehen. Und dazu muessen wir mindestens zu dritt sein.
+
+Du bist Assurer?
+Prima! Dann freuen wir uns darauf, dich am Samstag zu sehen!
+
+Wiki Organisationsseite: [http://wiki.cacert.org/events/blit2009]
+
+Kontakt: events@cacert.org
diff --git a/cacert/scripts/blit-de15-mail.php.txt b/cacert/scripts/blit-de15-mail.php.txt
new file mode 100644
index 0000000..87666ea
--- /dev/null
+++ b/cacert/scripts/blit-de15-mail.php.txt
@@ -0,0 +1,105 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("blit-de15-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 50;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+// $locid = 1260319; // Muenchen
+// $city = "Muenchen - 20. Nov 2009";
+
+// BLIT2009, Brandenburger Linux-Infotag, 21.11.2009
+ $locid = 1486658; // Potsdam
+ $eventname = "Brandenburger Linux-Infotag (BLIT2009)";
+ $city = "Potsdam - 21. Nov 2009";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>
diff --git a/cacert/scripts/cleanthem.pl b/cacert/scripts/cleanthem.pl
new file mode 100644
index 0000000..18d68b0
--- /dev/null
+++ b/cacert/scripts/cleanthem.pl
@@ -0,0 +1,24 @@
+#!/usr/bin/perl -w
+
+my %mysqltables=("gpg"=>"gpg","client"=>"emailcerts","server"=>"domaincerts","orgclient"=>"orgemailcerts","orgserver"=>"orgdomaincerts");
+
+sub mysql_query($)
+{
+ $dbh->do($_[0]);
+}
+
+my $aktiv=1;
+
+foreach my $dir (("../csr","../crt"))
+{
+ my $dirhandle;
+ opendir($dirhandle,"../csr");
+ while($_=readdir($dirhandle))
+ {
+ if(! -s "$dir/$_" and -f "$dir/$_" and !-d "$dir/$_")
+ {
+ print "Loesche $dir/$_\n";
+ unlink "$dir/$_";
+ }
+ }
+}
diff --git a/cacert/scripts/consistence.php b/cacert/scripts/consistence.php
new file mode 100755
index 0000000..8d6b39b
--- /dev/null
+++ b/cacert/scripts/consistence.php
@@ -0,0 +1,105 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2008 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+
+if(0)
+{
+ $query = "select locations.id from locations, regions where locations.regid=regions.id and locations.ccid!=regions.ccid;";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ $query = "update users set `assurer`='1' where `id`='${row['uid']}'";
+ echo "inconsistence in location ".$row['locations.id']."\n";
+ //mysql_query($query);
+ }
+}
+
+if(0)
+{
+ $query = "select id from locations where regid<1 or ccid<1;";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ //$query = "update users set `assurer`='1' where `id`='${row['uid']}'";
+ echo "inconsistence in location ".$row['id']."\n";
+ //mysql_query($query);
+ }
+}
+if(1)
+{
+ $query = "select users.id, locations.regid from users inner join locations on users.locid=locations.id where users.regid!=locations.regid or users.ccid!=locations.ccid;";
+ $res = mysql_query($query);
+ echo mysql_error();
+ while($row = mysql_fetch_assoc($res))
+ {
+ echo "inconsistence in user #".$row['id']."\n";
+ $query = "update users set regid=".$row['regid']." where `id`=".$row['id'].";";
+
+ echo "query: $query\n";
+ if($row['regid']=="1182") mysql_query($query);
+ }
+}
+
+exit();
+
+ mysql_query("update `locations` set `acount`=0");
+ $query = "SELECT `users`.`locid` AS `locid`, count(*) AS `total` FROM `users`
+ WHERE users.assurer='1' AND `users`.`locid` != 0 and users.listme=1
+ GROUP BY `users`.`locid`";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ $query = "update `locations` set `acount`='${row['total']}' where `id`='${row['locid']}'";
+ echo $query."\n";
+ mysql_query($query);
+ }
+
+
+ mysql_query("update `regions` set `acount`=0");
+ $query = "SELECT `users`.`regid` AS `regid`, count(*) AS `total` FROM `users`
+ WHERE users.assurer='1' AND `users`.`regid` != 0 and users.listme=1
+ GROUP BY `users`.`regid`";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ $query = "update `regions` set `acount`='${row['total']}' where `id`='${row['regid']}'";
+ echo $query."\n";
+ mysql_query($query);
+ }
+
+
+
+
+ mysql_query("update `countries` set `acount`=0");
+ $query = "SELECT `users`.`ccid` AS `ccid`, count(*) AS `total` FROM `users`
+ WHERE users.assurer='1' AND `users`.`ccid` != 0 and users.listme=1
+ GROUP BY `users`.`ccid`";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ $query = "update `countries` set `acount`='${row['total']}' where `id`='${row['ccid']}'";
+ echo $query."\n";
+ mysql_query($query);
+ }
+
+
+
+
+?>
diff --git a/cacert/scripts/findnull.pl b/cacert/scripts/findnull.pl
new file mode 100644
index 0000000..02df02f
--- /dev/null
+++ b/cacert/scripts/findnull.pl
@@ -0,0 +1,14 @@
+#!/usr/bin/perl -w
+
+foreach (<../crt/*>)
+{
+ my $res=`openssl x509 -in $_ -text -noout -inform der`;
+ if($res=~m/\\x00/)
+ {
+ print "Alert: $_ is affected!\n";
+ }
+ else
+ {
+ #print "$_ not affected\n";
+ }
+}
diff --git a/cacert/scripts/lisa-us13-email.txt b/cacert/scripts/lisa-us13-email.txt
new file mode 100644
index 0000000..9222af3
--- /dev/null
+++ b/cacert/scripts/lisa-us13-email.txt
@@ -0,0 +1,12 @@
+LISA'09: CACert BoF session, Tues, Need a few assurers to help
+get things rolling.
+
+Greeting,
+
+I will be leading GPG Key signing and CACert.org BoF sessions next Tuesday evening at the LISA 2009 conference in Baltimore, MD. At LISA'04 in Atlanta, I led a GPG key signing BoF and I attended a CACert BoF. I became an assurer at that conference. I helped 35 people gain assurance points at the 2004 conference. I hope we can add a good number of new assurers at this years conference.
+
+In order to do that, I need some help from a few qualified assurers. With as few as three already qualified assurers, we can bring several new people into the community. More assurers means we can split the work and move through everything quicker and easier. So far, I have just myself, so I really NEED some help. If you will be available, please contact me.
+
+Ken Schumacher
+
+Event Listing: http://wiki.cacert.org/events/LISA2009
diff --git a/cacert/scripts/lisa-us13-mail.php.txt b/cacert/scripts/lisa-us13-mail.php.txt
new file mode 100644
index 0000000..cddde83
--- /dev/null
+++ b/cacert/scripts/lisa-us13-mail.php.txt
@@ -0,0 +1,96 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("lisa-us13-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 250;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+ $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+ $city = "Baltimore, MD - Nov. 3rd 2009";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] LISA2009 - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] LISA2009 - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] LISA2009 - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] LISA2009 - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>
diff --git a/cacert/scripts/mission-hills-ca-us17-email.txt b/cacert/scripts/mission-hills-ca-us17-email.txt
new file mode 100644
index 0000000..9389c07
--- /dev/null
+++ b/cacert/scripts/mission-hills-ca-us17-email.txt
@@ -0,0 +1,17 @@
+Hello,
+This email is to let you know there will be a number of assurers gathering in
+your area. Please bring several (4-6) printed CAP forms and your photo ID's.
+
+Friday Jan 15th, 6:30PM,
+Presidente Mexican Restaurant
+11451 Sepulveda Boulevard
+Mission Hills, CA 91345-1117
+
+If you can make it, remember it will be your opertunity to gain assurances
+for yourself and boost the number of points you can assure to.
+
+Please RVSP thank you.
+
+Regards,
+Greg Stark
+gstark@electrorent.com
diff --git a/cacert/scripts/mission-hills-ca-us17-mail.php.txt b/cacert/scripts/mission-hills-ca-us17-mail.php.txt
new file mode 100644
index 0000000..c52d87c
--- /dev/null
+++ b/cacert/scripts/mission-hills-ca-us17-mail.php.txt
@@ -0,0 +1,115 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("mission-hills-ca-us17-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 50;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+// $locid = 1260319; // Muenchen
+// $city = "Muenchen - 20. Nov 2009";
+
+// BLIT2009, Brandenburger Linux-Infotag, 21.11.2009
+// $locid = 1486658; // Potsdam
+// $eventname = "Brandenburger Linux-Infotag (BLIT2009)";
+// $city = "Potsdam - 21. Nov 2009";
+
+// ATE-Goteborg, 16.12.2009
+// $locid = 664715; // Goteborg, Vastra Gotaland, Sweden
+// $eventname = "ATE-Goteborg";
+// $city = "Goteborg - Dec 16th 2009";
+
+// Assurance Event Mission Hills CA, 15.01.2010
+ $locid = 2094781; // Mission Hills (Los Angeles), California, United States
+ $eventname = "Assurance Event";
+ $city = "Mission Hills CA - Jan 15th 2010";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.\n";
+?>
diff --git a/cacert/scripts/osd-copenhagen-dk18-email.txt b/cacert/scripts/osd-copenhagen-dk18-email.txt
new file mode 100644
index 0000000..5301472
--- /dev/null
+++ b/cacert/scripts/osd-copenhagen-dk18-email.txt
@@ -0,0 +1,35 @@
+Open Source Days 2010 - Copenhagen, DK - March 5th and 6th 2010
+:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
+
+Dear Assurers,
+
+CAcert is trying to get a booth at the
+Open Source Days 2010 conference at Copenhagen DK
+March 5th and 6th 2010
+http://www.opensourcedays.org/2010
+
+The call for participation deadline is Jan 20th 2010
+
+As we have another event at the same time (Cebit 2010), we are in need
+of assistance from additional local assurers who can make this thing happen.
+
+We are looking for assurers who are available to organize
+CAcert's participation at Open Source Days 2010.
+
+As organizer for this event you get all assistance you'll need
+from the events team leader.
+
+If you are interested in helping please respond
+to this email so we can trigger the the call for participation
+before the deadline.
+
+Thanks for your assistance in advance.
+
+
+--
+mit freundlichen Gruessen / best regards
+Ulrich Schroeter - CAcert Event Organisation Officer, CAcert Case Manager, CAcert Arbitrator
+
+CAcert.org - Free Certificates
+E-Mail: Events@CAcert.org & Ulrich@CAcert.org
+
diff --git a/cacert/scripts/osd-copenhagen-dk18-mail.php.txt b/cacert/scripts/osd-copenhagen-dk18-mail.php.txt
new file mode 100644
index 0000000..e99d96c
--- /dev/null
+++ b/cacert/scripts/osd-copenhagen-dk18-mail.php.txt
@@ -0,0 +1,120 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("osd-copenhagen-dk18-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 50;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+// $locid = 1260319; // Muenchen
+// $city = "Muenchen - 20. Nov 2009";
+
+// BLIT2009, Brandenburger Linux-Infotag, 21.11.2009
+// $locid = 1486658; // Potsdam
+// $eventname = "Brandenburger Linux-Infotag (BLIT2009)";
+// $city = "Potsdam - 21. Nov 2009";
+
+// ATE-Goteborg, 16.12.2009
+// $locid = 664715; // Goteborg, Vastra Gotaland, Sweden
+// $eventname = "ATE-Goteborg";
+// $city = "Goteborg - Dec 16th 2009";
+
+// Assurance Event Mission Hills CA, 15.01.2010
+// $locid = 2094781; // Mission Hills (Los Angeles), California, United States
+// $eventname = "Assurance Event";
+// $city = "Mission Hills CA - Jan 15th 2010";
+
+// Assurance Event OSD Copenhagen DK, 5.03.2010
+ $locid = 423655; // Copenhagen, Kobenhavn*, Denmark
+ $eventname = "Assurance Event OpenSource-Days 2010";
+ $city = "Copenhagen DK - March 5th/6th 2010";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.\n";
+?>
diff --git a/cacert/scripts/ost-de14-email.txt b/cacert/scripts/ost-de14-email.txt
new file mode 100644
index 0000000..30862ff
--- /dev/null
+++ b/cacert/scripts/ost-de14-email.txt
@@ -0,0 +1,22 @@
+Sicherheit im Zeitalter der IT und des Internets - aufwendig und teuer?
+Das muss nicht sein!
+CAcert zeigt Dir, wie Du einfach und preiswert E-Mails signierst und
+Internet-Verbindungen verschluesselst.
+
+Die so genannten Zertifikate von CAcert lassen sich in Programmen
+wie Thunderbird und vielen anderen E-Mail-Programmen oder in
+ausgewachsenen Office-Programmen wie z.B. OpenOffice.org benutzen.
+Zur Verschluesselung von Internet-Verbindungen koennen die Zertifikate
+in Webservern und als Login-Moeglichkeit bei entsprechenden Gegenstellen
+in Webbrowsern eingesetzt werden.
+
+Auch Du kannst mitmachen, dazu brauchst Du nur Deinen Personalausweis
+und idealerweise einen Fuehrerschein oder Reisepass mitzubringen.
+
+Freitag, den 20. November, ab 17 Uhr im Caf Netzwerk
+http://www.cafe-netzwerk.de/ in Muenchen
+
+CAcert Vorstellung im Rahmen der Open-Source Treffen
+http://www.opensourcetreffen.de/
+
+Kontakt: events@cacert.org
diff --git a/cacert/scripts/ost-de14-mail.php.txt b/cacert/scripts/ost-de14-mail.php.txt
new file mode 100644
index 0000000..af98ed8
--- /dev/null
+++ b/cacert/scripts/ost-de14-mail.php.txt
@@ -0,0 +1,100 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("ost-de14-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 50;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+ $locid = 1260319; // Muenchen
+ $city = "Muenchen - 20. Nov 2009";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] Open-Source Treffen - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] Open-Source Treffen - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] Open-Source Treffen - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] Open-Source Treffen - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>
diff --git a/cacert/scripts/scale8x-los-angeles-ca-us19-email.txt b/cacert/scripts/scale8x-los-angeles-ca-us19-email.txt
new file mode 100644
index 0000000..dcc1d89
--- /dev/null
+++ b/cacert/scripts/scale8x-los-angeles-ca-us19-email.txt
@@ -0,0 +1,36 @@
+SCALE, the premier open source conference in Los Angeles is open
+for the 8th year.
+It will be held at
+
+5400 West Century Blvd,
+Los Angeles, 90045.
+
+It will be held this coming
+* February 19-21
+at the Los Angeles Airport Westin Hotel.
+
+More details can be found at the website,
+https://www.socallinuxexpo.org/scale8x/
+
+
+Any assurers that are available are welcome to cover any of the slots below.
+If you signup for a slot, please ensure you can stay for the entire time.
+
+
+Sat 09:30 - 14:00
+Sat 14:00 - 18:00
+
+
+Sun 09:30 - 13:00
+Sun 13:00 - 16:00
+
+
+https://wiki.cacert.org/events/SCaLE8x
+has the details on our organization.
+
+
+Thanks,
+Steve
+Event Organiser
+
+contact: events@cacert.org
diff --git a/cacert/scripts/scale8x-los-angeles-ca-us19-mail.php.txt b/cacert/scripts/scale8x-los-angeles-ca-us19-mail.php.txt
new file mode 100644
index 0000000..a6fb524
--- /dev/null
+++ b/cacert/scripts/scale8x-los-angeles-ca-us19-mail.php.txt
@@ -0,0 +1,125 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2009 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("scale8x-los-angeles-ca-us19-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 100;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+// $locid = 715191; // Hamburg
+
+// LISA2009 Baltimore, 1.11.2009
+// $locid = 2138880; // Baltimore (Baltimore (city)), Maryland, United States
+// $city = "Baltimore, MD - Nov. 3rd 2009";
+
+// OpenSourceTreffen-Muenchen, 20.11.2009
+// $locid = 1260319; // Muenchen
+// $city = "Muenchen - 20. Nov 2009";
+
+// BLIT2009, Brandenburger Linux-Infotag, 21.11.2009
+// $locid = 1486658; // Potsdam
+// $eventname = "Brandenburger Linux-Infotag (BLIT2009)";
+// $city = "Potsdam - 21. Nov 2009";
+
+// ATE-Goteborg, 16.12.2009
+// $locid = 664715; // Goteborg, Vastra Gotaland, Sweden
+// $eventname = "ATE-Goteborg";
+// $city = "Goteborg - Dec 16th 2009";
+
+// Assurance Event Mission Hills CA, 15.01.2010
+// $locid = 2094781; // Mission Hills (Los Angeles), California, United States
+// $eventname = "Assurance Event";
+// $city = "Mission Hills CA - Jan 15th 2010";
+
+// Assurance Event OSD Copenhagen DK, 5.03.2010
+ $locid = 423655; // Copenhagen, Kobenhavn*, Denmark
+ $eventname = "Assurance Event OpenSource-Days 2010";
+ $city = "Copenhagen DK - March 5th/6th 2010";
+
+// SCALE 8x Los Angeles, CA, Feb 19-21 2010
+ $locid = 2093625; // Los Angeles, California, United States
+ $eventname = "SCALE 8x 2010";
+ $city = "Los Angeles, CA - February 19-21 2010";
+
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] $eventname - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.\n";
+?>
diff --git a/cacert/scripts/sfd-de12-email.txt b/cacert/scripts/sfd-de12-email.txt
new file mode 100644
index 0000000..7211e63
--- /dev/null
+++ b/cacert/scripts/sfd-de12-email.txt
@@ -0,0 +1,24 @@
+Software Freedom Day am 19. September in Hamburg
+::::::::::::::::::::::::::::::::::::::::::::::::
+
+Hallo CAcert'ler aus dem Raum Hamburg,
+
+sicherlich habt Ihr vom "Software Freedom Day (SFD)" am 19. September im
+Buergerhaus in Hamburg-Barmbeck gehoert!?
+Der SFD ist einer der groessten Veranstaltungen zu diesem Thema ueberhaupt.
+Auch wir, CAcert ist dabei. Wir wuerden uns freuen wenn wir Dich an
+unserem Stand begruessen duerfen um uns ueber die eine oder andere
+CAcert-Sache zu unterhalten.
+Aber auch die anderen Dinge sind fr Dich auf dem SFD bestimmt
+interessant! Komme doch einfach am Samstag, den 19. September mal vorbei!
+Wir freuen uns auf Deinen Besuch!
+
+Der Link zur Veranstaltung: [http://www.lug-balista.de/sfd.html]
+
+Wir koennten auch noch einige Hilfe am Stand gebrauchen.
+Die Koordination findet ueber unsere Wiki Seite
+[http://wiki.cacert.org/wiki/events/SoftwareFreedomDayHamburg090919]
+statt. Wenn du mithelfen moechtest trage dich dort bitte als Assurer ein.
+Vielen Dank.
+
+Kontakt: events@cacert.org
diff --git a/cacert/scripts/sfd-de12-mail.php.txt b/cacert/scripts/sfd-de12-mail.php.txt
new file mode 100644
index 0000000..791d111
--- /dev/null
+++ b/cacert/scripts/sfd-de12-mail.php.txt
@@ -0,0 +1,94 @@
+#!/usr/bin/php -q
+<? /*
+ LibreSSL - CAcert web application
+ Copyright (C) 2004-2008 CAcert Inc.
+
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; version 2 of the License.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License
+ along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+*/
+ include_once("../includes/mysql.php");
+
+ $lines = "";
+ $fp = fopen("sfd-de12-email.txt", "r");
+ while(!feof($fp))
+ {
+ $line = trim(fgets($fp, 4096));
+ $lines .= wordwrap($line, 75, "\n")."\n";
+ }
+ fclose($fp);
+
+
+// $locid = intval($_REQUEST['location']);
+// $maxdist = intval($_REQUEST['maxdist']);
+ $maxdist = 70;
+
+
+// location location.ID
+// verified: 29.4.09 u.schroeter
+// $locid = 7902857; // Paris
+// $locid = 238568; // Bielefeld
+// $locid = 715191; // Hamburg
+// $locid = 1102495; // London
+// $locid = 520340; // Duesseldorf
+// $locid = 1260319; // Muenchen
+// $locid = 606058; // Frankfurt
+// $locid = 1775784; // Stuttgart
+// $locid = 228950; // Berlin
+// $locid = 606058; // Frankfurt
+// $locid = 599389; // Flensburg
+// $locid = 61065; // Amsterdam, Eemnes
+// $locid = 228950; // Berlin
+
+// Software Freedom Day 19. Sept 2009
+ $locid = 715191; // Hamburg
+
+
+ $city = "Hamburg 19. Sep 2009";
+
+ $query = "select * from `locations` where `id`='$locid'";
+ $loc = mysql_fetch_assoc(mysql_query($query));
+
+ $query = "SELECT ROUND(6378.137 * ACOS(0.9999999*((SIN(PI() * $loc[lat] / 180) * SIN(PI() * `locations`.`lat` / 180)) +
+ (COS(PI() * $loc[lat] / 180 ) * COS(PI() * `locations`.`lat` / 180) *
+ COS(PI() * `locations`.`long` / 180 - PI() * $loc[long] / 180)))), -1) AS `distance`, sum(`points`) as pts, `users`.*
+ FROM `locations`
+ inner join `users` on `users`.`locid` = `locations`.`id`
+ inner join `alerts` on `users`.`id`=`alerts`.`memid`
+ inner join `notary` on `users`.`id`=`notary`.`to`
+ WHERE (`alerts`.`general`=1 OR `alerts`.`country`=1 OR `alerts`.`regional`=1 OR `alerts`.`radius`=1)
+ GROUP BY `users`.`id`
+ HAVING `distance` <= '$maxdist'
+ ORDER BY `distance` ";
+ echo $query;
+
+ // comment next line when starting to send mail not only to me
+ // $query = "select * from `users` where `email` like 'cacerttest%'";
+
+ $res = mysql_query($query);
+ $xrows = mysql_num_rows($res);
+
+ while($row = mysql_fetch_assoc($res))
+ {
+ // uncomment next line to send mails ...
+ sendmail($row['email'], "[CAcert.org] Software Freedom Day - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ }
+ // 1x cc to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] Software Freedom Day - $city", $lines, "events@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+ // 1x mailing report to events.cacert.org
+ sendmail("events@cacert.org", "[CAcert.org] Software Freedom Day - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ // 1x mailing report to Arbitrator of case http://wiki.cacert.org/wiki/Arbitrations/a20090525.1
+ sendmail("p.dunkel@cacert.org", "[CAcert.org] Software Freedom Day - $city Report", "invitation sent to $xrows recipients.", "support@cacert.org", "", "", "CAcert Events Organisation", "returns@cacert.org", 1);
+
+ echo "invitation sent to $xrows recipients.";
+?>