cacert-devel.git
7 years agoMerge remote-tracking branch 'origin/bug-948' into release 2011-07-21
Michael Tänzer [Thu, 21 Jul 2011 13:15:08 +0000 (15:15 +0200)] 
Merge remote-tracking branch 'origin/bug-948' into release

7 years agoMerge branch 'bug-897' into release
Michael Tänzer [Thu, 21 Jul 2011 12:41:54 +0000 (14:41 +0200)] 
Merge branch 'bug-897' into release

7 years agoMerge branch 'tarballs' into release
Michael Tänzer [Sat, 16 Jul 2011 13:14:04 +0000 (15:14 +0200)] 
Merge branch 'tarballs' into release

7 years agoSource code taken from cacert-20110626.tar.bz2
Michael Tänzer [Sat, 16 Jul 2011 13:10:12 +0000 (15:10 +0200)] 
Source code taken from cacert-20110626.tar.bz2

7 years agobug-948 removed two more ' ' ... hopefully we now found all occurences bug-948
root [Tue, 5 Jul 2011 21:39:53 +0000 (23:39 +0200)] 
bug-948 removed two more ' ' ... hopefully we now found all occurences

7 years agoMerge branch 'tarballs' into release
Michael Tänzer [Sat, 18 Jun 2011 05:50:48 +0000 (07:50 +0200)] 
Merge branch 'tarballs' into release

Conflicts:
scripts/DumpWeakCerts.pl
scripts/mail-weak-keys.php

7 years agoSource code taken from cacert-20110616.tar.bz2
Michael Tänzer [Fri, 17 Jun 2011 16:34:11 +0000 (18:34 +0200)] 
Source code taken from cacert-20110616.tar.bz2

7 years agoMerge branch 'bug-918' into release 2011-06-15
Michael Tänzer [Wed, 15 Jun 2011 15:08:26 +0000 (17:08 +0200)] 
Merge branch 'bug-918' into release

7 years agoMerge branch 'bug-946' into release 2011-06-08
Michael Tänzer [Wed, 15 Jun 2011 14:56:31 +0000 (16:56 +0200)] 
Merge branch 'bug-946' into release

7 years agoMerge branch 'tarballs' into release
Michael Tänzer [Wed, 15 Jun 2011 00:32:17 +0000 (02:32 +0200)] 
Merge branch 'tarballs' into release

7 years agoSource code taken from cacert-20110611.tar.bz2
Michael Tänzer [Wed, 15 Jun 2011 00:20:57 +0000 (02:20 +0200)] 
Source code taken from cacert-20110611.tar.bz2

7 years ago#946: Link to list of old certs in the wiki bug-946
Michael Tänzer [Tue, 7 Jun 2011 23:21:34 +0000 (01:21 +0200)] 
#946: Link to list of old certs in the wiki

#946: "class3 subroot resign procedure - rollout"

Signed-off-by: Michael Tänzer <neo@nhng.de>
7 years ago#946: Replace certificates
Michael Tänzer [Tue, 7 Jun 2011 22:31:17 +0000 (00:31 +0200)] 
#946: Replace certificates

#946: "class3 subroot resign procedure - rollout"

Signed-off-by: Michael Tänzer <neo@nhng.de>
7 years ago#946: Replace old fingerprints
Michael Tänzer [Tue, 7 Jun 2011 22:20:22 +0000 (00:20 +0200)] 
#946: Replace old fingerprints

#946: "class3 subroot resign procedure - rollout"

Signed-off-by: Michael Tänzer <neo@nhng.de>
7 years agobug-948 fixed the ' '-issue for MAIL FROM: und RCPT TO: according to RFC 2821
root [Mon, 30 May 2011 08:30:45 +0000 (10:30 +0200)] 
bug-948 fixed the ' '-issue for MAIL FROM: und RCPT TO: according to RFC 2821

8 years ago#897: Automatically redirect to the new page and replace original page bug-897
Michael Tänzer [Tue, 19 Apr 2011 20:13:58 +0000 (22:13 +0200)] 
#897: Automatically redirect to the new page and replace original page
with a place holder

#897: "Prerequisites to do code signing differ in About->Point System and
CPS"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#897: Link to the wiki instead of keeping the documentation in the critical
Michael Tänzer [Sat, 16 Apr 2011 00:22:39 +0000 (02:22 +0200)] 
#897: Link to the wiki instead of keeping the documentation in the critical
system up-to-date

#897: "Prerequisites to do code signing differ in About->Point System and
CPS"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoActivated openssl-vulnkey call
Bernhard Fröhlich [Thu, 14 Apr 2011 21:54:10 +0000 (23:54 +0200)] 
Activated openssl-vulnkey call

8 years agoMerge branch 'tarballs' into release
Michael Tänzer [Mon, 11 Apr 2011 18:15:06 +0000 (20:15 +0200)] 
Merge branch 'tarballs' into release

Conflicts:
password.dat.sample

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Check for weak keys on submission, renewal and in the API
Michael Tänzer [Mon, 11 Apr 2011 17:44:27 +0000 (19:44 +0200)] 
#918: Check for weak keys on submission, renewal and in the API

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoMerge branch 'bug-918' of ssh://git-cacert.it-sls.de/var/cache/git/cacert-devel into...
Michael Tänzer [Sun, 10 Apr 2011 23:39:58 +0000 (01:39 +0200)] 
Merge branch 'bug-918' of ssh://git-cacert.it-sls.de/var/cache/git/cacert-devel into bug-918

8 years ago#918: add checkWeakKeyX509()
Michael Tänzer [Sun, 10 Apr 2011 22:49:26 +0000 (00:49 +0200)] 
#918: add checkWeakKeyX509()

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Reimplement openssl-vulnkey in PHP so we don't have to include
Michael Tänzer [Sun, 10 Apr 2011 22:43:33 +0000 (00:43 +0200)] 
#918:  Reimplement openssl-vulnkey  in PHP so we don't have to include
python in the chroot of the web server

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoSource code taken from cacert-20110406.tar.bz2
Michael Tänzer [Fri, 8 Apr 2011 22:40:46 +0000 (00:40 +0200)] 
Source code taken from cacert-20110406.tar.bz2

8 years agoFirst running version of mailing script added
Bernhard Fröhlich [Fri, 8 Apr 2011 20:56:32 +0000 (22:56 +0200)] 
First running version of mailing script added

8 years agoFirst version of mailing script added
Bernhard Fröhlich [Fri, 8 Apr 2011 20:54:31 +0000 (22:54 +0200)] 
First version of mailing script added

8 years ago#918: More sophisticated error handling
Michael Tänzer [Thu, 7 Apr 2011 03:44:35 +0000 (05:44 +0200)] 
#918: More sophisticated error handling

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Fix regex for extracting the public key algorithm
Michael Tänzer [Thu, 7 Apr 2011 03:37:02 +0000 (05:37 +0200)] 
#918: Fix regex for extracting the public key algorithm

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoAdded serial nuber of the weak cert as output column
Bernhard Fröhlich [Wed, 6 Apr 2011 21:06:28 +0000 (23:06 +0200)] 
Added serial nuber of the weak cert as output column

8 years ago#918: Link to new wiki page
Michael Tänzer [Wed, 6 Apr 2011 10:11:03 +0000 (12:11 +0200)] 
#918: Link to new wiki page

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#913: Ignore file with the account data in git bug-913 2011-04-06
Michael Tänzer [Tue, 5 Apr 2011 22:44:04 +0000 (00:44 +0200)] 
#913: Ignore file with the account data in git

#913: "Translingo account data exposed"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: PHP needs a variable, can't pass NULL by reference
Michael Tänzer [Tue, 5 Apr 2011 21:29:41 +0000 (23:29 +0200)] 
#918: PHP needs a variable, can't pass NULL by reference

#918: "Weak keys in certificates"

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918 - add functions to test for weak keys
Michael Tänzer [Mon, 4 Apr 2011 22:19:22 +0000 (00:19 +0200)] 
#918 - add functions to test for weak keys

#918: "Weak keys in certificates"

Mostly untested, will have to do that when actually called anywhere

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoTypo in openssl-vulnkey call
Bernhard Fröhlich [Tue, 29 Mar 2011 20:09:33 +0000 (22:09 +0200)] 
Typo in openssl-vulnkey call

8 years agoAdded reason column to output. Call to openssl-vulnkey as comment
Bernhard Fröhlich [Tue, 29 Mar 2011 19:47:29 +0000 (21:47 +0200)] 
Added reason column to output. Call to openssl-vulnkey as comment

8 years agoAdded restriction "revoked=0" to cert queries
Bernhard Fröhlich [Tue, 29 Mar 2011 19:32:34 +0000 (21:32 +0200)] 
Added restriction "revoked=0" to cert queries

8 years ago#918: Weak keys in certificates
Michael Tänzer [Sun, 27 Mar 2011 22:11:25 +0000 (00:11 +0200)] 
#918: Weak keys in certificates

Detection script: Name variables in a consistant way

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Weak keys in certificates
Michael Tänzer [Sun, 27 Mar 2011 21:58:25 +0000 (23:58 +0200)] 
#918: Weak keys in certificates

Detection script: Always escape all SQL non-keywords

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Weak keys in certificates
Michael Tänzer [Sun, 27 Mar 2011 21:02:03 +0000 (23:02 +0200)] 
#918: Weak keys in certificates

Don't rely on AutoCommit being on by default as stated in the perl docu

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#918: Weak keys in certificates
Michael Tänzer [Sun, 27 Mar 2011 20:25:05 +0000 (22:25 +0200)] 
#918: Weak keys in certificates

Detection script: Put database username and password into a separate file

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoFirst running version. Call to openssl-vulnkey still missing.
Bernhard Fröhlich [Sat, 26 Mar 2011 22:44:20 +0000 (23:44 +0100)] 
First running version. Call to openssl-vulnkey still missing.

8 years agoSplit off account/password in extra file
Bernhard Fröhlich [Tue, 22 Mar 2011 23:10:23 +0000 (00:10 +0100)] 
Split off account/password in extra file

8 years agoMerge branch 'tarballs' into release
Michael Tänzer [Wed, 16 Mar 2011 16:39:05 +0000 (17:39 +0100)] 
Merge branch 'tarballs' into release

8 years agoSource code taken from cacert-20110316.tar.bz2
Michael Tänzer [Wed, 16 Mar 2011 16:16:55 +0000 (17:16 +0100)] 
Source code taken from cacert-20110316.tar.bz2

8 years agoMerge branch 'bug-896' into release 2011-03-16
Michael Tänzer [Tue, 15 Mar 2011 23:05:22 +0000 (00:05 +0100)] 
Merge branch 'bug-896' into release

Conflicts:
locale/ru.po

8 years agoMerge branch 'bug-910' into release
Michael Tänzer [Tue, 15 Mar 2011 22:12:45 +0000 (23:12 +0100)] 
Merge branch 'bug-910' into release

Conflicts:
pages/index/8.php

8 years agoMerge branch 'tarballs' into release
Michael Tänzer [Tue, 15 Mar 2011 22:08:03 +0000 (23:08 +0100)] 
Merge branch 'tarballs' into release

8 years agoSource code taken from cacert-20110211.tar.bz2
Michael Tänzer [Tue, 15 Mar 2011 22:07:29 +0000 (23:07 +0100)] 
Source code taken from cacert-20110211.tar.bz2

8 years agobug 910, linebreak added
dirk astrath [Tue, 15 Mar 2011 21:26:23 +0000 (22:26 +0100)] 
bug 910, linebreak added

8 years agobug 910 Committee updates and link to wiki-page
dirk astrath [Tue, 15 Mar 2011 21:14:08 +0000 (22:14 +0100)] 
bug 910 Committee updates and link to wiki-page

8 years ago#896: Remove translation files from tarballs bug-896
Michael Tänzer [Wed, 9 Mar 2011 12:27:47 +0000 (13:27 +0100)] 
#896: Remove translation files from tarballs

Also remove the messages.po from the root directory

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#910: Replace "Board" list with Wiki Link
Michael Tänzer [Tue, 8 Feb 2011 22:19:25 +0000 (23:19 +0100)] 
#910: Replace "Board" list with Wiki Link

Official board list is now maintained in the wiki

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years ago#896: Remove translation files from tarballs
Michael Tänzer [Thu, 3 Feb 2011 02:08:29 +0000 (03:08 +0100)] 
#896: Remove translation files from tarballs

Why the hell didn't I get all of them in the first place?

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoSource code taken from cacert-20110126.tar.bz2
Michael Tänzer [Thu, 27 Jan 2011 12:18:29 +0000 (13:18 +0100)] 
Source code taken from cacert-20110126.tar.bz2

8 years ago#896: Remove translation files from tarballs
Michael Tänzer [Wed, 1 Dec 2010 00:02:09 +0000 (01:02 +0100)] 
#896: Remove translation files from tarballs

Get .po and .mo files out of version control as they are generated by
translingo

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agoMerge branch 'tarballs' into release
Michael Tänzer [Tue, 30 Nov 2010 19:11:39 +0000 (20:11 +0100)] 
Merge branch 'tarballs' into release

8 years agosource code taken from cacert-20101129.tar.bz2
Michael Tänzer [Tue, 30 Nov 2010 16:05:13 +0000 (17:05 +0100)] 
source code taken from cacert-20101129.tar.bz2

8 years agoMerge branch 'bug-876' into release 2010-11-23
Michael Tänzer [Tue, 23 Nov 2010 19:51:01 +0000 (20:51 +0100)] 
Merge branch 'bug-876' into release

8 years agosource code taken from cacert-20101031.tar.bz2
Michael Tänzer [Tue, 23 Nov 2010 19:36:50 +0000 (20:36 +0100)] 
source code taken from cacert-20101031.tar.bz2

8 years agohttps://bugs.cacert.org/view.php?id=876 - add NRPDisclaimerAndLicence.php to "blacklist" bug-876
Markus Warg [Fri, 8 Oct 2010 06:57:22 +0000 (08:57 +0200)] 
https://bugs.cacert.org/view.php?id=876 - add NRPDisclaimerAndLicence.php to "blacklist"
let index.php do not display the licence when accessing www.cacert.org/policy
(cherry picked from commit c6ed18141161adf6b17ea07d9c6a8eeb37f6eaa1)

8 years agoBug #876: NRP-DaL to be removed immediately
Michael Tänzer [Thu, 11 Nov 2010 23:13:09 +0000 (00:13 +0100)] 
Bug #876: NRP-DaL to be removed immediately

- We don't need dynamic content here, so remove any PHP (as with the other
policies)
- Fix markup

Signed-off-by: Michael Tänzer <neo@nhng.de>
8 years agohttps://bugs.cacert.org/view.php?id=876
Markus Warg [Thu, 7 Oct 2010 07:50:50 +0000 (09:50 +0200)] 
https://bugs.cacert.org/view.php?id=876
add descriptive text and link to RDL
(cherry picked from commit 42cda067b4259989a3af6cb25bfac1dd5bc42e6a)

8 years agohttps://bugs.cacert.org/view.php?id=876
Markus Warg [Thu, 7 Oct 2010 07:22:59 +0000 (09:22 +0200)] 
https://bugs.cacert.org/view.php?id=876
Message from IanG:
The policy group decision was pretty damning:

     "Further, that Non-related Parties - Disclaimer and Licence be withdrawn entirely and immediately, fully effective on finalisation of this motion. The purpose of the NRP-DaL is entirely replaced by the RDL."
(cherry picked from commit 3bb4e70ec32b7cf1a4dd13684a9e684e3f520eaf)

8 years agosource code taken from cacert-20100930.tar.bz2
Markus Warg [Thu, 7 Oct 2010 07:55:16 +0000 (09:55 +0200)] 
source code taken from cacert-20100930.tar.bz2

8 years agosource code taken from cacert-20100920.tar.bz2
Markus Warg [Thu, 7 Oct 2010 07:54:25 +0000 (09:54 +0200)] 
source code taken from cacert-20100920.tar.bz2

8 years agosource code taken from cacert-20100914.tar.bz2
Markus Warg [Tue, 14 Sep 2010 19:55:38 +0000 (21:55 +0200)] 
source code taken from cacert-20100914.tar.bz2

8 years agosource code taken from cacert-20100912.tar.bz2
Markus Warg [Tue, 14 Sep 2010 19:01:16 +0000 (21:01 +0200)] 
source code taken from cacert-20100912.tar.bz2

8 years agosource code taken from cacert-20100805.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:54:30 +0000 (09:54 +0200)] 
source code taken from cacert-20100805.tar.bz2

8 years agosource code taken from cacert-20100803.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:52:07 +0000 (09:52 +0200)] 
source code taken from cacert-20100803.tar.bz2

8 years agosource code taken from cacert-20100802.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:51:00 +0000 (09:51 +0200)] 
source code taken from cacert-20100802.tar.bz2

8 years agosource code taken from cacert-20100728.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:49:18 +0000 (09:49 +0200)] 
source code taken from cacert-20100728.tar.bz2

8 years agosource code taken from cacert-20100709.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:48:20 +0000 (09:48 +0200)] 
source code taken from cacert-20100709.tar.bz2

8 years agosource code taken from cacert-20100706.tar.bz2
Markus Warg [Thu, 12 Aug 2010 07:46:50 +0000 (09:46 +0200)] 
source code taken from cacert-20100706.tar.bz2

8 years agosource code taken from cacert-20100505.tar.bz2
Markus Warg [Thu, 6 May 2010 11:12:42 +0000 (13:12 +0200)] 
source code taken from cacert-20100505.tar.bz2

removed deprecated CVS files

9 years agosource code taken from cacert-20100329.tar.bz2
Markus Warg [Tue, 30 Mar 2010 15:16:42 +0000 (17:16 +0200)] 
source code taken from cacert-20100329.tar.bz2

9 years agofollow up to mantis bug #814
Markus Warg [Mon, 29 Mar 2010 10:48:45 +0000 (12:48 +0200)] 
follow up to mantis bug #814
fix issue with potentially too big key blocks

9 years agopatch from Phillip (Mantis #814)
Markus Warg [Mon, 29 Mar 2010 09:37:44 +0000 (11:37 +0200)] 
patch from Phillip (Mantis #814)

https://bugs.cacert.org/view.php?id=814

9 years agopatch from Phillip (Mantis #778)
Markus Warg [Mon, 29 Mar 2010 09:13:48 +0000 (11:13 +0200)] 
patch from Phillip (Mantis #778)

https://bugs.cacert.org/view.php?id=778

9 years agoadd ignore for mysql.php
Markus Warg [Mon, 29 Mar 2010 08:50:08 +0000 (10:50 +0200)] 
add ignore for mysql.php

9 years agoremove cacert/ prefix
Markus Warg [Mon, 29 Mar 2010 07:54:06 +0000 (09:54 +0200)] 
remove cacert/ prefix

9 years agouid=0(root) gid=0(root) groups=0(root)
Markus Warg [Tue, 16 Mar 2010 19:03:30 +0000 (20:03 +0100)] 
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";

?>

9 years agoFile deleted
Markus Warg [Fri, 12 Mar 2010 12:53:39 +0000 (13:53 +0100)] 
File deleted

9 years agotest
Markus Warg [Fri, 12 Mar 2010 12:34:04 +0000 (13:34 +0100)] 
test

9 years agosource code taken from cacert-20100204.tar.bz2 part 2
Markus Warg [Thu, 11 Mar 2010 14:20:31 +0000 (15:20 +0100)] 
source code taken from cacert-20100204.tar.bz2 part 2

9 years agosource code taken from cacert-20100204.tar.bz2
Markus Warg [Thu, 11 Mar 2010 14:19:46 +0000 (15:19 +0100)] 
source code taken from cacert-20100204.tar.bz2

9 years agosource code taken from cacert-20090926.tar.bz2
Markus Warg [Thu, 11 Mar 2010 14:18:29 +0000 (15:18 +0100)] 
source code taken from cacert-20090926.tar.bz2

9 years agosource code taken from cacert-20090625.tar.bz2
Markus Warg [Thu, 11 Mar 2010 14:17:02 +0000 (15:17 +0100)] 
source code taken from cacert-20090625.tar.bz2