showaccounts.php

<?
require("constants.php");
$sData = file_get_contents("https://mitglieder.piratenpartei.at/adm_api/adm1.php");
$sDataR = explode("\n",trim($sData," \n"));
$sData = $sDataR[1];
$sha1sum = $sDataR[0];
if (strlen($datakey1) == 0 || strlen($datakey2) == 0)
  die('Kein Passwort!');

$oo_nums = array("AT130" => 2, "AT221" => 11);

$decrypted = rtrim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, md5($datakey2), base64_decode($sData), MCRYPT_MODE_CBC, md5(md5($datakey2))), "\0");
if (sha1($decrypted) != $sha1sum)
  die("Checksum mismatch!");
$lines = explode("\n",$decrypted);
foreach ($lines as $line)
{
  if (strlen($line) < 5) { continue; }
  $values = explode("\t",$line);
  $idc = stripslashes($values[1]);
  if (strlen($values[1]) < 5) { echo "FATAL: idc not valid:\n"; print_r($values); continue; }
  $mail_original = stripslashes(trim($values[2]));
  $mail = filter_var($mail_original, FILTER_SANITIZE_EMAIL);
  if (!filter_var($mail, FILTER_VALIDATE_EMAIL)/* || $mail == "mitglied@piratenpartei.at"*/) { echo "FATAL: email address invalid: '$mail':\n"; print_r($values); continue; }
  $lo = $values[3];
  $oo = explode(",",$values[4]);
  if (count($oo) == 0 || strlen($oo[0]) != 5)
    $oo[0] = 'ATXXX';
  if (count($oo) == 1 || strlen($oo[1]) != 5)
    $oo[1] = 'ATXXX';
  $akk = ($values[5] != null);
  $paid = ($values[6] != null);
  if (!$akk || !$paid)
    continue;
  switch ($lo)
  {
    case 38: $lo_num = 6; break;
    case 40: $lo_num = 10; break;
    case 39: $lo_num = 4; break;
    case 41: $lo_num = 5; break;
    case 42: $lo_num = 7; break;
    case 43: $lo_num = 3; break;
    case 44: $lo_num = 8; break;
    case 45: $lo_num = 9; break;
    case 37: $lo_num = 2; break;
    default: $lo_num = 0; break;
  }
  $oo_num1 = isset($oo_nums[$oo[0]]) ? $oo_nums[$oo[0]] : 0;
  $oo_num2 = isset($oo_nums[$oo[1]]) ? $oo_nums[$oo[1]] : 0;
  echo "insert: identification=$idc, email=$mail, unit=$lo_num, unit=$oo_num1, unit=$oo_num2, akk=$akk, paid=$paid\n";
}

?>