<TITLE>Member administration</TITLE>
<BODY BGcolor=BLACK TEXT=WHITE ALINK=WHITE VLINK=WHITE LINK=WHITE>

<CENTER>
<FONT SIZE=5>Member Administration:</FONT><BR>
(report generation)<BR>
<P></P>

<TABLE WIDTH=500>
<TR><TD><CENTER>
Please, select report that you would like to view
</CENTER></TD></TR>
</TABLE>

<!
$sock=msqlConnect();
if ($sock<0) {
   echo("<CENTER><TABLE WIDTH=500 BORDER=2 BGCOLOR=\"$color4\">\n");
   echo("<TR><TD>\n<BR><CENTER>$ERRMSG</CENTER><BR>\n</TD></TR>\n</TABLE>\n");
   exit(0);
   }

if (msqlSelectDB($sock, "MEMBERS")<0) {
   echo("<CENTER><TABLE WIDTH=400 BORDER=2 BGCOLOR=\"$color4\">\n");
   echo("<TR><TD>\n<BR><CENTER>$ERRMSG</CENTER><BR>\n</TD></TR>\n</TABLE>\n");
   exit(0);
   }

$i=0;
while($i<4) {
$z=$i + 1;
if (msqlQuery($sock, "SELECT id_print FROM print WHERE card='$z' AND printed='0'")<0) {
   echo("<CENTER><TABLE WIDTH=500 BORDER=2 BGCOLOR=\"$color4\">\n");
   echo("<TR><TD>\n<BR><CENTER>$ERRMSG</CENTER><BR>\n</TD></TR>\n</TABLE>\n");
   exit(0);
   }
$fd=msqlStoreResult();
$data=msqlFetchRow($fd);
$rows=msqlNumRows($fd);

$n=0; $pup="";
while(#$data>0 && $n<20) {
   $n=$n + 1;
   $pup=$pup + "&p=" + $data[0];
   $data=msqlFetchRow($fd);
   }
msqlFreeResult($fp);
$p[$i]="p=0" + $pup;

if (msqlQuery($sock, "SELECT id_print FROM print WHERE card='$z' AND printed='1'")<0) {
   echo("<CENTER><TABLE WIDTH=500 BORDER=2 BGCOLOR=\"$color4\">\n");
   echo("<TR><TD>\n<BR><CENTER>$ERRMSG</CENTER><BR>\n</TD></TR>\n</TABLE>\n");
   exit(0);
   }
$fd=msqlStoreResult();
$data=msqlFetchRow($fd);
$rows=msqlNumRows($fd);

$n=0; $pup="";
while(#$data>0 && $n<20) {
   $n=$n + 1;
   $pup=$pup + "&p=" + $data[0];
   $data=msqlFetchRow($fd);
   }
msqlFreeResult($fp);
$q[$i]="p=0" + $pup;

$i=$i + 1;
}

echo("<TABLE><TR><TD BGCOLOR=NAVY>\n");
echo("<TABLE><TR><TD BGCOLOR=BLUE>\n");

$card[0]="Visa";
$card_prg[0]="visa";
$card[1]="Master Card";
$card_prg[1]="master";
$card[2]="American Express";
$card_prg[2]="amex";
$card[3]="Diners";
$card_prg[3]="diners";

echo("<TABLE BGCOLOR=NAVY>\n");

echo("<TR><TD COLSPAN=4 BGCOLOR=BLACK><IMG SRC=\"none.gif\" WIDTH=1 HEIGHT=3></TD></TR>\n");

$i=0; $ima=0;
while($i<4) {

      echo("<TR><TD><CENTER>$card[$i]\n");
      echo("</CENTER></TD>\n");
   if ($p[$i]!="p=0") {
      echo("<TD><A HREF=\"$card_prg[$i].msql?$p[$i]\">\n");
      echo("FAX no.1</A></TD>\n");
      echo("<TD><A HREF=\"re$card_prg[$i].msql?$p[$i]\">\n");
      echo("ReAuthorize</A></TD>\n");
      }
    else {
      echo("<TD>FAX no.1</TD>\n");
      echo("<TD>ReAuthorize</TD>\n");
      }
   if ($q[$i]!="p=0") {
      echo("<TD><A HREF=\"$card_prg[$i].msql?$q[$i]\">\n");
      echo("FAX no.2</A></TD>\n");
      }
    else {
      echo("<TD>FAX no.2</TD>\n");
      }
      echo("<TR>\n");
      $ima=1;
      echo("<TR><TD COLSPAN=4 BGCOLOR=BLACK><IMG SRC=\"none.gif\" WIDTH=1 HEIGHT=3></TD></TR>\n");
   $i=$i + 1;
   }

if ($ima==0) {
      echo("<TR><TD><CENTER>\n");
      echo("Sorry, no authorised user <==> NO REPORTS ;)\n");
      echo("</CENTER></TD></TR>\n");
   }

echo("</TABLE>\n</TD></TR></TABLE>\n</TD></TR></TABLE>\n");

>

</BODY>
