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'])
+			}
+		}
+	}
+?>