summaryrefslogtreecommitdiff
path: root/scripts/send_policy_cca_correct_20150221_1.php
diff options
context:
space:
mode:
authorBernhard Fröhlich <bernhard@cacert.org>2018-10-29 20:07:10 +0100
committerBernhard Fröhlich <bernhard@cacert.org>2018-10-29 20:07:10 +0100
commitf8210d43aa91c16ca565f771fd23deb9b02af41d (patch)
tree337846293df774b27d7ced35df2c5ea7598d9465 /scripts/send_policy_cca_correct_20150221_1.php
parent000b17a9a909737930d59dee82c40e7eab2fa337 (diff)
downloadcacert-devel-f8210d43aa91c16ca565f771fd23deb9b02af41d.tar.gz
cacert-devel-f8210d43aa91c16ca565f771fd23deb9b02af41d.tar.xz
cacert-devel-f8210d43aa91c16ca565f771fd23deb9b02af41d.zip
source code taken from cacert-20180906.tar.bz2
Diffstat (limited to 'scripts/send_policy_cca_correct_20150221_1.php')
-rw-r--r--scripts/send_policy_cca_correct_20150221_1.php113
1 files changed, 113 insertions, 0 deletions
diff --git a/scripts/send_policy_cca_correct_20150221_1.php b/scripts/send_policy_cca_correct_20150221_1.php
new file mode 100644
index 0000000..797771a
--- /dev/null
+++ b/scripts/send_policy_cca_correct_20150221_1.php
@@ -0,0 +1,113 @@
+#!/usr/bin/php -q
+<?php
+/*
+ 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");
+
+// read texts
+
+$lines_EN = <<<EOF
+
+We have to inform you that there was an incorrect version of the CAcert Community Agreement (CCA) on the main website of CAcert for a couple of days.
+
+The CCA provides the general terms and conditions for all CAcert members. We may only issue certificates and sign PGP keys to those who have accepted these terms and conditions.
+
+Unfortunately, you are among those who have accepted the CCA while the incorrect version was online.
+
+The correct version of the CCA can be found at:
+http://www.cacert.org/policy/CAcertCommunityAgreement.html
+
+If you agree to this version, you do not need to do anything.
+
+If you do not accept this version, please send an email to support@cacert.org no later than 2015-03-08 to request termination of your CAcert membership. Terminating your membership will cause the revocation of all your certificates, the disabling of your login to the CAcert web interface and the anonymisation of your personal data.
+
+Most of the differences will probably not affect you. but they can be seen at:
+http://svn.cacert.org/CAcert/Policies/CAcertCommunityAgreement_20140708.html
+
+Major changes are:
+ * The CCA was changed to clearly be a general terms and conditions what makes it easier to join and exit as CAcert member. For CAcert it was obvious to do the change, because all CAcert members sign the same conditions without the possibility to strike or add personal clauses.
+ * More ways to accept the CCA were added.
+ * Termination of membership was clarified some more. Some other options beside the ruling of an Arbitrator were cautiously added.
+ * You have a new obligation to answer in arbitration cases. This seems to be obvious, but you never signed it before. In the past this was derived from some points within our Dispute Resolution Policy (DRP).
+ * Sharing of accounts and credentials was banned more clearly. Also the obligation to only use a certificate in the appropriate contexts was added. It was already part of the Certification Practice Statement (CPS).
+ * Some kinds of contributions as personal data are now excepted from the non-exclusive non-restrictive non-revocable transfer of licence to CAcert.
+ * Official communication with CAcert was simplified.
+ * Some deprecated references were removed.
+
+Sincerely,
+Eva Stöwe
+CAcert Policy Officer
+EOF;
+
+$lines_EN = wordwrap($lines_EN, 75, "\n");
+$lines_EN = mb_convert_encoding($lines_EN, "HTML-ENTITIES", "UTF-8");
+
+
+// read last used id
+$lastid = 0;
+if (file_exists("send_policy_cca_correct_20150221_1_lastid.txt"))
+{
+ $fp = fopen("send_policy_cca_correct_20150221_1_lastid.txt", "r");
+ $lastid = trim(fgets($fp, 4096));
+ fclose($fp);
+}
+
+echo "ID now: $lastid\n";
+
+
+$count = 0;
+
+$query = "
+
+ SELECT
+ users.id,
+ users.fname,
+ users.lname,
+ users.email,
+ COUNT(*) AS agreement_count
+ FROM user_agreements
+ LEFT JOIN users ON users.id = user_agreements.memid
+ WHERE user_agreements.date >= '2015-01-08 14:29:00'
+ AND user_agreements.date <= '2015-01-15 10:48:00'
+ AND user_agreements.document = 'CCA'
+ AND users.id NOT IN (
+ SELECT user_agreements.memid
+ FROM user_agreements
+ WHERE user_agreements.date < '2015-01-08 14:29:00'
+ AND user_agreements.document = 'CCA')
+ GROUP BY users.id";
+
+$res = mysql_query($query);
+
+while($row = mysql_fetch_assoc($res))
+{
+ $mailtxt = "Dear ${row["fname"]} ${row["lname"]},\n".$lines_EN."\n\n";
+
+ sendmail($row['email'], "[CAcert.org] CAcert Community Agreement (CCA)", $mailtxt, "support@cacert.org", "", "", "CAcert", "returns@cacert.org", "");
+
+ $fp = fopen("send_policy_cca_correct_20150221_1_lastid.txt", "w");
+ fputs($fp, $row["id"]."\n");
+ fclose($fp);
+
+ $count++;
+ echo "Sent ${count}th mail. User ID: ${row["id"]}\n";
+
+ if(0 == $count % 5) {
+ sleep (1);
+ }
+}