From 5b68967def224a00f54eb54946ff17301bbd3cdb Mon Sep 17 00:00:00 2001
From: Markus Warg <mw@it-sls.de>
Date: Tue, 16 Mar 2010 20:03:30 +0100
Subject: uid=0(root) gid=0(root) groups=0(root) ate-sydney-au20-email.txt NONE
 1.1 ate-sydney-au20-mail.php.txt NONE 1.1 Fri Mar 12 23:01:13 CET 2010 Update
 of /var/lib/cvs/cacert/scripts In directory hlin:/home/cacert/www/scripts

Added Files:
	ate-sydney-au20-email.txt ate-sydney-au20-mail.php.txt
Log Message:
Add script plus message for ATE event in Sydney:
	ATE Sydney March 24, 2010

===================================================================
RCS file: /var/lib/cvs/cacert/scripts/ate-sydney-au20-email.txt,v  -->  standard output
revision 1.1
CAcert Assurer Training Event Sdney
::::::::::::::::::::::::::::::::::::::::::::::::::

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:

- How does the CCA protect you and every CAcert Community Member?
- Can you recall the 5 parts of the Assurance Statement?
- Can you tick off the security features of the Australian passport?
- What do you when something goes drastically wrong?

Answers to these and many other questions are given at the Assurer
Training Events (ATEs).

ATE-Sydney takes place on:
- Wednesday, March 24th from 6:00pm till 9:30pm
- Sydney University School of IT, Building J12
   Ground Floor Lecture Room, room 123.
- directions: [http://www.cs.usyd.edu.au/about/directions.shtml]

The Event-Team is looking forward to hearing from you.  Participation in
ATEs is free, contributions are however appreciated.

Registration for ATE-Sydney: please reply 'I will attend: Sydney'
contact: events@cacert.org

web: [http://wiki.cacert.org/events/20100324Sydney]
===================================================================
RCS file: /var/lib/cvs/cacert/scripts/ate-sydney-au20-mail.php.txt,v  -->  standard output
revision 1.1
<? /*
    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-sydney-au20-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

//  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";

	$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";

?>
---
 cacert/scripts/ate-sydney-au20-email.txt | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 cacert/scripts/ate-sydney-au20-email.txt

(limited to 'cacert/scripts/ate-sydney-au20-email.txt')

diff --git a/cacert/scripts/ate-sydney-au20-email.txt b/cacert/scripts/ate-sydney-au20-email.txt
new file mode 100644
index 0000000..6979191
--- /dev/null
+++ b/cacert/scripts/ate-sydney-au20-email.txt
@@ -0,0 +1,30 @@
+CAcert Assurer Training Event Sdney
+::::::::::::::::::::::::::::::::::::::::::::::::::
+
+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:
+
+- How does the CCA protect you and every CAcert Community Member?
+- Can you recall the 5 parts of the Assurance Statement?
+- Can you tick off the security features of the Australian passport?
+- What do you when something goes drastically wrong?
+
+Answers to these and many other questions are given at the Assurer 
+Training Events (ATEs).
+
+ATE-Sydney takes place on:
+- Wednesday, March 24th from 6:00pm till 9:30pm
+- Sydney University School of IT, Building J12
+   Ground Floor Lecture Room, room 123.
+- directions: [http://www.cs.usyd.edu.au/about/directions.shtml]
+
+The Event-Team is looking forward to hearing from you.  Participation in 
+ATEs is free, contributions are however appreciated.
+
+Registration for ATE-Sydney: please reply 'I will attend: Sydney'
+contact: events@cacert.org
+
+web: [http://wiki.cacert.org/events/20100324Sydney]
-- 
cgit v1.2.1