summaryrefslogtreecommitdiff
path: root/scripts/addpoints.php
diff options
context:
space:
mode:
authorMarkus Warg <mw@it-sls.de>2010-03-29 09:54:06 +0200
committerMarkus Warg <mw@it-sls.de>2010-03-29 09:54:06 +0200
commit9dceece06fbdc98add6f76f0b1aec05891a394c4 (patch)
treef7227c28ca5f79f30c2ec81ba1a09a4fe3972436 /scripts/addpoints.php
parent5b68967def224a00f54eb54946ff17301bbd3cdb (diff)
downloadcacert-devel-9dceece06fbdc98add6f76f0b1aec05891a394c4.tar.gz
cacert-devel-9dceece06fbdc98add6f76f0b1aec05891a394c4.tar.xz
cacert-devel-9dceece06fbdc98add6f76f0b1aec05891a394c4.zip
remove cacert/ prefix
Diffstat (limited to 'scripts/addpoints.php')
-rwxr-xr-xscripts/addpoints.php54
1 files changed, 54 insertions, 0 deletions
diff --git a/scripts/addpoints.php b/scripts/addpoints.php
new file mode 100755
index 0000000..a518ceb
--- /dev/null
+++ b/scripts/addpoints.php
@@ -0,0 +1,54 @@
+#!/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
+*/
+
+// This script seems to add points for assurances that didn't received their points automatically before.
+
+ include_once("../includes/mysql.php");
+
+ $query = "select * from `notary` group by `from`";
+ $res = mysql_query($query);
+ while($row = mysql_fetch_assoc($res))
+ {
+ $query = "select *,sum(`points`) as `points` from `users`, `notary` where `users`.`id`=`notary`.`to` and `users`.`id`='".$row['from']."' group by `notary`.`to`";
+ $drow = mysql_fetch_assoc(mysql_query($query));
+ if($drow['points'] < 100 || $drow['points'] >= 150)
+ continue;
+ $query = "select * from `notary` where `from`='".$drow['id']."' and `to`='".$drow['id']."'";
+ $num = mysql_num_rows(mysql_query($query));
+ $query = "select * from `notary` where `from`='".$drow['id']."' and `to`!='".$drow['id']."'";
+ $newnum = mysql_num_rows(mysql_query($query));
+ if($num < $newnum)
+ {
+ echo $drow['fname']." ".$drow['lname']." <".$drow['email']."> (memid: ".$drow['id']." points: ".$drow['points']." - num: $num newnum: $newnum)\n";
+ for($i = $newnum; $i > $num; $i--)
+ {
+ $newpoints = 2;
+ if($drow['points'] + 1>= 150)
+ break;
+ if($drow['points'] + 2 > 150)
+ $newpoints = 1;
+ $query = "insert into `notary` set `from`='".$drow['id']."', `to`='".$drow['id']."',
+ `points`='$newpoints', `method`='Administrative Increase', `date`=NOW()";
+ mysql_query($query);
+ $drow['points'] += $newpoints;
+ fix_assurer_flag($drow['id'])
+ }
+ }
+ }
+?>