source code taken from cacert-20100914.tar.bz2

2 files changed, 274 insertions, 0 deletions

diff --git a/scripts/22de-ate-aachen-email.txt b/scripts/22de-ate-aachen-email.txt
new file mode 100644
index 0000000..a93ba8d
--- /dev/null
+++ b/scripts/22de-ate-aachen-email.txt
@@ -0,0 +1,133 @@
+CAcert Assurer Training Event Aachen [Deutsch]

+::::::::::::::::::::::::::::::::::::::::::::::::::

+

+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 versuchen, die ganzen Informationen unter’s Volk zu bringen:

+

+- Was hast du auf dem CAP Formular hinzuzufuegen, wenn du Minderjaehrige ueberpruefst ?

+- Was sind die 2 wesentlichen Punkte der CCA die du einem Assuree vermitteln koennen sollst ?

+- Unter welchen Umstaenden koennen z.Bsp. niederlaendische Rufnamen akzeptiert werden? 

+

+Antworten auf diese und weitere Fragen erhaelst du bei den Assurer Training Events (ATEs).

+

+Die kommende Veranstaltung in deiner Naehe findet statt am:

+

+Montag den 04. Oktber 2010

+in den Seminarraeumen (Madrid and Lissabon)

+

+Jugendherberge Aachen

+- Euregionales Jugendgaestehaus -

+Maria-Theresia-Allee 260

+52074 Aachen

+

+Es finden 2 Veranstaltungen statt. Eine am Nachmittag, eine am Abend:

+Unverbindliche Anmeldung und Registrierung:

+

+Nachmittag 14:00 - 17:00 (I)

+Rueckantwort mit 'Ich moechte am ATE-Aachen am Nachmittag teilnehmen'

+

+oder

+

+Abend: 19:00 - 22:00 (II)

+Rueckantwort mit 'Ich moechte am ATE-Aachen am Abend teilnehmen'

+

+Zur Durchfuehrung der jeweiligen Veranstaltung ist eine Mindestteilnehmerzahl von 6 Personen erforderlich.

+

+Das Veranstaltungs-Team freut sich schon auf Eure Teilnahme.

+

+Details zum Veranstaltungsort und Anfahrthinweise findet Ihr im

+Wiki [https://wiki.cacert.org/Events/2010_10_04-ATE-Aachen]

+Blog [https://blog.cacert.org/2010/08/482.html]

+and [https://blog.cacert.org/2010/09/484.html]

+

+Kontakt: events@cacert.org

+

+

+

+CAcert Assurer Training Event Aachen [Dutch]

+::::::::::::::::::::::::::::::::::::::::::::::::::

+  

+Er is veel gebeurd de afgelopen 3 jaar. De oude manier van mondeling doorgegeven procedures is nu verdwenen, en onze regels zijn uitgebracht in formeel beleid. Nieuwe procedures (bijvoorbeeld de Assurer Challenge) en verplichtingen (bv in de CAcert Community Agreement) zijn goedgekeurd. De Assurer Training evenementen brengen dit alles naar u, de Gemeenschap:

+

+- Wat heb je toe te voegen aan het CAP formulier bij het waarmerken van jongere leden die nog geen 18+ zijn?

+- Wat zijn de 2 essentiële thema's van de CCA als u die presenteert aan iemand?

+- Wanneer kun je een Nederlandse "roepnaam" accepteren?

+

+Antwoorden op deze, en vele andere vragen worden gegeven op Assurer Training Evenementen (ATE).

+

+ATE-Aken vindt plaats op: maandag 04 october 2010

+In de hoorzalen (Madrid en Lissabon) van

+

+Jugendherberge Aken

+- Euregionales Jugendgaestehaus -

+Maria-Theresia-Allee 260

+52074 Aachen

+

+Er zullen 2 bijeenkomsten plaatsvinden. Een 's middags, de ander 's avonds.

+U kunt uw aanmelding/registratie ten alle tijden wijzigen.

+

+'s middags 14:00--17:00 (I)

+Reactie met "Ik wil graag 's middags deelnemen aan ATE-Aken (!)." gericht aan events@cacert.org.

+

+of

+

+'s avonds 19:00--22:00 (II)

+Reactie met "Ik wil graag 's avonds deelnemen aan ATE-Aken (II)." gericht aan events@cacert.org.

+

+(Om een bijeenkomst door te laten gaan hebben wij graag 6 of meer deelnemers.)

+

+Het Event-Team kijkt er naar uit om van u te horen.

+

+Details over locatie en vervoer vindt u onder

+Wiki [https://wiki.cacert.org/Events/2010_10_04-ATE-Aachen]

+Blog [https://blog.cacert.org/2010/08/482.html]

+en [https://blog.cacert.org/2010/09/484.html]

+

+Voor andere vragen of opmerkingen kunt u ook terecht bij events@cacert.org

+

+

+

+CAcert Assurer Training Event Aachen [English]

+::::::::::::::::::::::::::::::::::::::::::::::::::

+

+Much has happened during the past 3 years. The old way of 

+orally-transmitted procedures has now gone, and our rules have been cast 

+into formal policies. New procedures (e.g. the Assurer Challenge) and 

+obligations (e.g. in the CAcert Community Agreement) have been approved. 

+The Assurer Training Events bring all this to you, the Community:

+

+- What you have to add onto the CAP form if you assure U18 people ?

+- What are the 2 essential topics regarding CCA you have to present an Assuree ?

+- When you can accept i.e. a Dutch "roepnaam" ?

+

+Answers to these and many other questions are given at the Assurer 

+Training Events (ATEs).

+

+ATE-Aachen takes place on:

+Monday, Oct 4th, 2010

+Lecture Rooms (Madrid and Lissabon)

+

+Jugendherberge Aachen

+- Euregionales Jugendgaestehaus -

+Maria-Theresia-Allee 260

+52074 Aachen

+

+We have scheduled two events: one in the afternoon, one in the evening:

+

+Afternoon 14:00-17:00 (I):

+For Registration please reply: 'I will attend ATE-Aachen in the afternoon'

+

+or

+

+Evening 19:00-22:00 (II):

+For Registration please reply: 'I will attend ATE-Aachen in the evening'

+

+For each of the events to take place, we will need at least 6 attendees.

+

+The Event-Team is looking forward to hearing from you.

+

+Details on Location and Transportation you will find under

+Wiki [https://wiki.cacert.org/Events/2010_10_04-ATE-Aachen]

+Blog [https://blog.cacert.org/2010/08/482.html]

+and [https://blog.cacert.org/2010/09/484.html]

+

+Contact: events@cacert.org

diff --git a/scripts/22de-ate-aachen-mail.php.txt b/scripts/22de-ate-aachen-mail.php.txt
new file mode 100644
index 0000000..fa60d74
--- /dev/null
+++ b/scripts/22de-ate-aachen-mail.php.txt
@@ -0,0 +1,141 @@
+#!/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("22de-ate-aachen-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 in [Km]
+  $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  
+
+//  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;       // Copenhagen, Kobenhavn*, Denmark 
+//       $eventname = "SCALE 8x 2010";
+//       $city = "Los Angeles, CA - February 19-21 2010";
+
+// ATE Sydney, AU, Mar 24 2010 
+//       $locid = 2257312;       // Sydney, New South Wales, Australia
+//       $eventname = "ATE-Sydney";
+//       $city = "March 24, 2010";
+
+// ATE Essen, DE, Sept 28 2010 
+//       $locid = 572764;       //  Essen, Nordrhein-Westfalen, Germany 
+//       $eventname = "ATE-Essen";
+//       $city = "September 28, 2010";
+
+// ATE Aachen, DE, Oct 4th 2010 
+       $locid = 78;       //  Aachen, Nordrhein-Westfalen, Germany 
+       $eventname = "ATE-Aachen";
+       $city = "October 4th, 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";
+?>