summaryrefslogtreecommitdiff
path: root/www/gpg.php
blob: 4e05a88e2ccc759fffe65d987b7fc2c5106344b1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
<? /*
    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
*/ ?>
<?
	require_once("../includes/loggedin.php");
	require_once("../includes/lib/general.php");
	require_once('../includes/notary.inc.php');

        $id = 0; if(array_key_exists('id',$_REQUEST)) $id=intval($_REQUEST['id']);
	$oldid = $_REQUEST['oldid'] = array_key_exists('oldid',$_REQUEST) ? intval($_REQUEST['oldid']) : 0;

	if($_SESSION['profile']['points'] < 50)
	{
		header("location: /account.php");
		exit;
	}

	loadem("account");



	$CSR=""; if(array_key_exists('CSR',$_REQUEST)) $CSR=stripslashes($_REQUEST['CSR']);


	if($oldid == "0")
	{
		if(array_key_exists('process',$_REQUEST) && $_REQUEST['process'] != "" && $CSR == "")
		{
			$_SESSION['_config']['errmsg'] = _("You failed to paste a valid GPG/PGP key.");
			$id = $oldid;
			$oldid=0;
		}
	}

	$keyid="";

if(0)
{
  if($_SESSION["profile"]["id"] != 5897)
  {
    showheader(_("Welcome to CAcert.org"));
    echo "The OpenPGP signing system is currently shutdown due to a maintenance. We hope to get it fixed within the next few hours. We are very sorry for the inconvenience.";

    exit(0);
  }
}

function normalizeName($name) {
    // Based on http://stackoverflow.com/questions/11176752/converting-named-html-entities-to-numeric-html-entities
    static $HTML401NamedToNumeric = array(
        //HTML 4.01 standard
        '&nbsp;'     => '&#160;',  # no-break space = non-breaking space, U+00A0 ISOnum
        '&iexcl;'    => '&#161;',  # inverted exclamation mark, U+00A1 ISOnum
        '&cent;'     => '&#162;',  # cent sign, U+00A2 ISOnum
        '&pound;'    => '&#163;',  # pound sign, U+00A3 ISOnum
        '&curren;'   => '&#164;',  # currency sign, U+00A4 ISOnum
        '&yen;'      => '&#165;',  # yen sign = yuan sign, U+00A5 ISOnum
        '&brvbar;'   => '&#166;',  # broken bar = broken vertical bar, U+00A6 ISOnum
        '&sect;'     => '&#167;',  # section sign, U+00A7 ISOnum
        '&uml;'      => '&#168;',  # diaeresis = spacing diaeresis, U+00A8 ISOdia
        '&copy;'     => '&#169;',  # copyright sign, U+00A9 ISOnum
        '&ordf;'     => '&#170;',  # feminine ordinal indicator, U+00AA ISOnum
        '&laquo;'    => '&#171;',  # left-pointing double angle quotation mark = left pointing guillemet, U+00AB ISOnum
        '&not;'      => '&#172;',  # not sign, U+00AC ISOnum
        '&shy;'      => '&#173;',  # soft hyphen = discretionary hyphen, U+00AD ISOnum
        '&reg;'      => '&#174;',  # registered sign = registered trade mark sign, U+00AE ISOnum
        '&macr;'     => '&#175;',  # macron = spacing macron = overline = APL overbar, U+00AF ISOdia
        '&deg;'      => '&#176;',  # degree sign, U+00B0 ISOnum
        '&plusmn;'   => '&#177;',  # plus-minus sign = plus-or-minus sign, U+00B1 ISOnum
        '&sup2;'     => '&#178;',  # superscript two = superscript digit two = squared, U+00B2 ISOnum
        '&sup3;'     => '&#179;',  # superscript three = superscript digit three = cubed, U+00B3 ISOnum
        '&acute;'    => '&#180;',  # acute accent = spacing acute, U+00B4 ISOdia
        '&micro;'    => '&#181;',  # micro sign, U+00B5 ISOnum
        '&para;'     => '&#182;',  # pilcrow sign = paragraph sign, U+00B6 ISOnum
        '&middot;'   => '&#183;',  # middle dot = Georgian comma = Greek middle dot, U+00B7 ISOnum
        '&cedil;'    => '&#184;',  # cedilla = spacing cedilla, U+00B8 ISOdia
        '&sup1;'     => '&#185;',  # superscript one = superscript digit one, U+00B9 ISOnum
        '&ordm;'     => '&#186;',  # masculine ordinal indicator, U+00BA ISOnum
        '&raquo;'    => '&#187;',  # right-pointing double angle quotation mark = right pointing guillemet, U+00BB ISOnum
        '&frac14;'   => '&#188;',  # vulgar fraction one quarter = fraction one quarter, U+00BC ISOnum
        '&frac12;'   => '&#189;',  # vulgar fraction one half = fraction one half, U+00BD ISOnum
        '&frac34;'   => '&#190;',  # vulgar fraction three quarters = fraction three quarters, U+00BE ISOnum
        '&iquest;'   => '&#191;',  # inverted question mark = turned question mark, U+00BF ISOnum
        '&Agrave;'   => '&#192;',  # latin capital letter A with grave = latin capital letter A grave, U+00C0 ISOlat1
        '&Aacute;'   => '&#193;',  # latin capital letter A with acute, U+00C1 ISOlat1
        '&Acirc;'    => '&#194;',  # latin capital letter A with circumflex, U+00C2 ISOlat1
        '&Atilde;'   => '&#195;',  # latin capital letter A with tilde, U+00C3 ISOlat1
        '&Auml;'     => '&#196;',  # latin capital letter A with diaeresis, U+00C4 ISOlat1
        '&Aring;'    => '&#197;',  # latin capital letter A with ring above = latin capital letter A ring, U+00C5 ISOlat1
        '&AElig;'    => '&#198;',  # latin capital letter AE = latin capital ligature AE, U+00C6 ISOlat1
        '&Ccedil;'   => '&#199;',  # latin capital letter C with cedilla, U+00C7 ISOlat1
        '&Egrave;'   => '&#200;',  # latin capital letter E with grave, U+00C8 ISOlat1
        '&Eacute;'   => '&#201;',  # latin capital letter E with acute, U+00C9 ISOlat1
        '&Ecirc;'    => '&#202;',  # latin capital letter E with circumflex, U+00CA ISOlat1
        '&Euml;'     => '&#203;',  # latin capital letter E with diaeresis, U+00CB ISOlat1
        '&Igrave;'   => '&#204;',  # latin capital letter I with grave, U+00CC ISOlat1
        '&Iacute;'   => '&#205;',  # latin capital letter I with acute, U+00CD ISOlat1
        '&Icirc;'    => '&#206;',  # latin capital letter I with circumflex, U+00CE ISOlat1
        '&Iuml;'     => '&#207;',  # latin capital letter I with diaeresis, U+00CF ISOlat1
        '&ETH;'      => '&#208;',  # latin capital letter ETH, U+00D0 ISOlat1
        '&Ntilde;'   => '&#209;',  # latin capital letter N with tilde, U+00D1 ISOlat1
        '&Ograve;'   => '&#210;',  # latin capital letter O with grave, U+00D2 ISOlat1
        '&Oacute;'   => '&#211;',  # latin capital letter O with acute, U+00D3 ISOlat1
        '&Ocirc;'    => '&#212;',  # latin capital letter O with circumflex, U+00D4 ISOlat1
        '&Otilde;'   => '&#213;',  # latin capital letter O with tilde, U+00D5 ISOlat1
        '&Ouml;'     => '&#214;',  # latin capital letter O with diaeresis, U+00D6 ISOlat1
        '&times;'    => '&#215;',  # multiplication sign, U+00D7 ISOnum
        '&Oslash;'   => '&#216;',  # latin capital letter O with stroke = latin capital letter O slash, U+00D8 ISOlat1
        '&Ugrave;'   => '&#217;',  # latin capital letter U with grave, U+00D9 ISOlat1
        '&Uacute;'   => '&#218;',  # latin capital letter U with acute, U+00DA ISOlat1
        '&Ucirc;'    => '&#219;',  # latin capital letter U with circumflex, U+00DB ISOlat1
        '&Uuml;'     => '&#220;',  # latin capital letter U with diaeresis, U+00DC ISOlat1
        '&Yacute;'   => '&#221;',  # latin capital letter Y with acute, U+00DD ISOlat1
        '&THORN;'    => '&#222;',  # latin capital letter THORN, U+00DE ISOlat1
        '&szlig;'    => '&#223;',  # latin small letter sharp s = ess-zed, U+00DF ISOlat1
        '&agrave;'   => '&#224;',  # latin small letter a with grave = latin small letter a grave, U+00E0 ISOlat1
        '&aacute;'   => '&#225;',  # latin small letter a with acute, U+00E1 ISOlat1
        '&acirc;'    => '&#226;',  # latin small letter a with circumflex, U+00E2 ISOlat1
        '&atilde;'   => '&#227;',  # latin small letter a with tilde, U+00E3 ISOlat1
        '&auml;'     => '&#228;',  # latin small letter a with diaeresis, U+00E4 ISOlat1
        '&aring;'    => '&#229;',  # latin small letter a with ring above = latin small letter a ring, U+00E5 ISOlat1
        '&aelig;'    => '&#230;',  # latin small letter ae = latin small ligature ae, U+00E6 ISOlat1
        '&ccedil;'   => '&#231;',  # latin small letter c with cedilla, U+00E7 ISOlat1
        '&egrave;'   => '&#232;',  # latin small letter e with grave, U+00E8 ISOlat1
        '&eacute;'   => '&#233;',  # latin small letter e with acute, U+00E9 ISOlat1
        '&ecirc;'    => '&#234;',  # latin small letter e with circumflex, U+00EA ISOlat1
        '&euml;'     => '&#235;',  # latin small letter e with diaeresis, U+00EB ISOlat1
        '&igrave;'   => '&#236;',  # latin small letter i with grave, U+00EC ISOlat1
        '&iacute;'   => '&#237;',  # latin small letter i with acute, U+00ED ISOlat1
        '&icirc;'    => '&#238;',  # latin small letter i with circumflex, U+00EE ISOlat1
        '&iuml;'     => '&#239;',  # latin small letter i with diaeresis, U+00EF ISOlat1
        '&eth;'      => '&#240;',  # latin small letter eth, U+00F0 ISOlat1
        '&ntilde;'   => '&#241;',  # latin small letter n with tilde, U+00F1 ISOlat1
        '&ograve;'   => '&#242;',  # latin small letter o with grave, U+00F2 ISOlat1
        '&oacute;'   => '&#243;',  # latin small letter o with acute, U+00F3 ISOlat1
        '&ocirc;'    => '&#244;',  # latin small letter o with circumflex, U+00F4 ISOlat1
        '&otilde;'   => '&#245;',  # latin small letter o with tilde, U+00F5 ISOlat1
        '&ouml;'     => '&#246;',  # latin small letter o with diaeresis, U+00F6 ISOlat1
        '&divide;'   => '&#247;',  # division sign, U+00F7 ISOnum
        '&oslash;'   => '&#248;',  # latin small letter o with stroke, = latin small letter o slash, U+00F8 ISOlat1
        '&ugrave;'   => '&#249;',  # latin small letter u with grave, U+00F9 ISOlat1
        '&uacute;'   => '&#250;',  # latin small letter u with acute, U+00FA ISOlat1
        '&ucirc;'    => '&#251;',  # latin small letter u with circumflex, U+00FB ISOlat1
        '&uuml;'     => '&#252;',  # latin small letter u with diaeresis, U+00FC ISOlat1
        '&yacute;'   => '&#253;',  # latin small letter y with acute, U+00FD ISOlat1
        '&thorn;'    => '&#254;',  # latin small letter thorn, U+00FE ISOlat1
        '&yuml;'     => '&#255;',  # latin small letter y with diaeresis, U+00FF ISOlat1
        '&fnof;'     => '&#402;',  # latin small f with hook = function = florin, U+0192 ISOtech
        '&Alpha;'    => '&#913;',  # greek capital letter alpha, U+0391
        '&Beta;'     => '&#914;',  # greek capital letter beta, U+0392
        '&Gamma;'    => '&#915;',  # greek capital letter gamma, U+0393 ISOgrk3
        '&Delta;'    => '&#916;',  # greek capital letter delta, U+0394 ISOgrk3
        '&Epsilon;'  => '&#917;',  # greek capital letter epsilon, U+0395
        '&Zeta;'     => '&#918;',  # greek capital letter zeta, U+0396
        '&Eta;'      => '&#919;',  # greek capital letter eta, U+0397
        '&Theta;'    => '&#920;',  # greek capital letter theta, U+0398 ISOgrk3
        '&Iota;'     => '&#921;',  # greek capital letter iota, U+0399
        '&Kappa;'    => '&#922;',  # greek capital letter kappa, U+039A
        '&Lambda;'   => '&#923;',  # greek capital letter lambda, U+039B ISOgrk3
        '&Mu;'       => '&#924;',  # greek capital letter mu, U+039C
        '&Nu;'       => '&#925;',  # greek capital letter nu, U+039D
        '&Xi;'       => '&#926;',  # greek capital letter xi, U+039E ISOgrk3
        '&Omicron;'  => '&#927;',  # greek capital letter omicron, U+039F
        '&Pi;'       => '&#928;',  # greek capital letter pi, U+03A0 ISOgrk3
        '&Rho;'      => '&#929;',  # greek capital letter rho, U+03A1
        '&Sigma;'    => '&#931;',  # greek capital letter sigma, U+03A3 ISOgrk3
        '&Tau;'      => '&#932;',  # greek capital letter tau, U+03A4
        '&Upsilon;'  => '&#933;',  # greek capital letter upsilon, U+03A5 ISOgrk3
        '&Phi;'      => '&#934;',  # greek capital letter phi, U+03A6 ISOgrk3
        '&Chi;'      => '&#935;',  # greek capital letter chi, U+03A7
        '&Psi;'      => '&#936;',  # greek capital letter psi, U+03A8 ISOgrk3
        '&Omega;'    => '&#937;',  # greek capital letter omega, U+03A9 ISOgrk3
        '&alpha;'    => '&#945;',  # greek small letter alpha, U+03B1 ISOgrk3
        '&beta;'     => '&#946;',  # greek small letter beta, U+03B2 ISOgrk3
        '&gamma;'    => '&#947;',  # greek small letter gamma, U+03B3 ISOgrk3
        '&delta;'    => '&#948;',  # greek small letter delta, U+03B4 ISOgrk3
        '&epsilon;'  => '&#949;',  # greek small letter epsilon, U+03B5 ISOgrk3
        '&zeta;'     => '&#950;',  # greek small letter zeta, U+03B6 ISOgrk3
        '&eta;'      => '&#951;',  # greek small letter eta, U+03B7 ISOgrk3
        '&theta;'    => '&#952;',  # greek small letter theta, U+03B8 ISOgrk3
        '&iota;'     => '&#953;',  # greek small letter iota, U+03B9 ISOgrk3
        '&kappa;'    => '&#954;',  # greek small letter kappa, U+03BA ISOgrk3
        '&lambda;'   => '&#955;',  # greek small letter lambda, U+03BB ISOgrk3
        '&mu;'       => '&#956;',  # greek small letter mu, U+03BC ISOgrk3
        '&nu;'       => '&#957;',  # greek small letter nu, U+03BD ISOgrk3
        '&xi;'       => '&#958;',  # greek small letter xi, U+03BE ISOgrk3
        '&omicron;'  => '&#959;',  # greek small letter omicron, U+03BF NEW
        '&pi;'       => '&#960;',  # greek small letter pi, U+03C0 ISOgrk3
        '&rho;'      => '&#961;',  # greek small letter rho, U+03C1 ISOgrk3
        '&sigmaf;'   => '&#962;',  # greek small letter final sigma, U+03C2 ISOgrk3
        '&sigma;'    => '&#963;',  # greek small letter sigma, U+03C3 ISOgrk3
        '&tau;'      => '&#964;',  # greek small letter tau, U+03C4 ISOgrk3
        '&upsilon;'  => '&#965;',  # greek small letter upsilon, U+03C5 ISOgrk3
        '&phi;'      => '&#966;',  # greek small letter phi, U+03C6 ISOgrk3
        '&chi;'      => '&#967;',  # greek small letter chi, U+03C7 ISOgrk3
        '&psi;'      => '&#968;',  # greek small letter psi, U+03C8 ISOgrk3
        '&omega;'    => '&#969;',  # greek small letter omega, U+03C9 ISOgrk3
        '&thetasym;' => '&#977;',  # greek small letter theta symbol, U+03D1 NEW
        '&upsih;'    => '&#978;',  # greek upsilon with hook symbol, U+03D2 NEW
        '&piv;'      => '&#982;',  # greek pi symbol, U+03D6 ISOgrk3
        '&bull;'     => '&#8226;', # bullet = black small circle, U+2022 ISOpub
        '&hellip;'   => '&#8230;', # horizontal ellipsis = three dot leader, U+2026 ISOpub
        '&prime;'    => '&#8242;', # prime = minutes = feet, U+2032 ISOtech
        '&Prime;'    => '&#8243;', # double prime = seconds = inches, U+2033 ISOtech
        '&oline;'    => '&#8254;', # overline = spacing overscore, U+203E NEW
        '&frasl;'    => '&#8260;', # fraction slash, U+2044 NEW
        '&weierp;'   => '&#8472;', # script capital P = power set = Weierstrass p, U+2118 ISOamso
        '&image;'    => '&#8465;', # blackletter capital I = imaginary part, U+2111 ISOamso
        '&real;'     => '&#8476;', # blackletter capital R = real part symbol, U+211C ISOamso
        '&trade;'    => '&#8482;', # trade mark sign, U+2122 ISOnum
        '&alefsym;'  => '&#8501;', # alef symbol = first transfinite cardinal, U+2135 NEW
        '&larr;'     => '&#8592;', # leftwards arrow, U+2190 ISOnum
        '&uarr;'     => '&#8593;', # upwards arrow, U+2191 ISOnum
        '&rarr;'     => '&#8594;', # rightwards arrow, U+2192 ISOnum
        '&darr;'     => '&#8595;', # downwards arrow, U+2193 ISOnum
        '&harr;'     => '&#8596;', # left right arrow, U+2194 ISOamsa
        '&crarr;'    => '&#8629;', # downwards arrow with corner leftwards = carriage return, U+21B5 NEW
        '&lArr;'     => '&#8656;', # leftwards double arrow, U+21D0 ISOtech
        '&uArr;'     => '&#8657;', # upwards double arrow, U+21D1 ISOamsa
        '&rArr;'     => '&#8658;', # rightwards double arrow, U+21D2 ISOtech
        '&dArr;'     => '&#8659;', # downwards double arrow, U+21D3 ISOamsa
        '&hArr;'     => '&#8660;', # left right double arrow, U+21D4 ISOamsa
        '&forall;'   => '&#8704;', # for all, U+2200 ISOtech
        '&part;'     => '&#8706;', # partial differential, U+2202 ISOtech
        '&exist;'    => '&#8707;', # there exists, U+2203 ISOtech
        '&empty;'    => '&#8709;', # empty set = null set = diameter, U+2205 ISOamso
        '&nabla;'    => '&#8711;', # nabla = backward difference, U+2207 ISOtech
        '&isin;'     => '&#8712;', # element of, U+2208 ISOtech
        '&notin;'    => '&#8713;', # not an element of, U+2209 ISOtech
        '&ni;'       => '&#8715;', # contains as member, U+220B ISOtech
        '&prod;'     => '&#8719;', # n-ary product = product sign, U+220F ISOamsb
        '&sum;'      => '&#8721;', # n-ary sumation, U+2211 ISOamsb
        '&minus;'    => '&#8722;', # minus sign, U+2212 ISOtech
        '&lowast;'   => '&#8727;', # asterisk operator, U+2217 ISOtech
        '&radic;'    => '&#8730;', # square root = radical sign, U+221A ISOtech
        '&prop;'     => '&#8733;', # proportional to, U+221D ISOtech
        '&infin;'    => '&#8734;', # infinity, U+221E ISOtech
        '&ang;'      => '&#8736;', # angle, U+2220 ISOamso
        '&and;'      => '&#8743;', # logical and = wedge, U+2227 ISOtech
        '&or;'       => '&#8744;', # logical or = vee, U+2228 ISOtech
        '&cap;'      => '&#8745;', # intersection = cap, U+2229 ISOtech
        '&cup;'      => '&#8746;', # union = cup, U+222A ISOtech
        '&int;'      => '&#8747;', # integral, U+222B ISOtech
        '&there4;'   => '&#8756;', # therefore, U+2234 ISOtech
        '&sim;'      => '&#8764;', # tilde operator = varies with = similar to, U+223C ISOtech
        '&cong;'     => '&#8773;', # approximately equal to, U+2245 ISOtech
        '&asymp;'    => '&#8776;', # almost equal to = asymptotic to, U+2248 ISOamsr
        '&ne;'       => '&#8800;', # not equal to, U+2260 ISOtech
        '&equiv;'    => '&#8801;', # identical to, U+2261 ISOtech
        '&le;'       => '&#8804;', # less-than or equal to, U+2264 ISOtech
        '&ge;'       => '&#8805;', # greater-than or equal to, U+2265 ISOtech
        '&sub;'      => '&#8834;', # subset of, U+2282 ISOtech
        '&sup;'      => '&#8835;', # superset of, U+2283 ISOtech
        '&nsub;'     => '&#8836;', # not a subset of, U+2284 ISOamsn
        '&sube;'     => '&#8838;', # subset of or equal to, U+2286 ISOtech
        '&supe;'     => '&#8839;', # superset of or equal to, U+2287 ISOtech
        '&oplus;'    => '&#8853;', # circled plus = direct sum, U+2295 ISOamsb
        '&otimes;'   => '&#8855;', # circled times = vector product, U+2297 ISOamsb
        '&perp;'     => '&#8869;', # up tack = orthogonal to = perpendicular, U+22A5 ISOtech
        '&sdot;'     => '&#8901;', # dot operator, U+22C5 ISOamsb
        '&lceil;'    => '&#8968;', # left ceiling = apl upstile, U+2308 ISOamsc
        '&rceil;'    => '&#8969;', # right ceiling, U+2309 ISOamsc
        '&lfloor;'   => '&#8970;', # left floor = apl downstile, U+230A ISOamsc
        '&rfloor;'   => '&#8971;', # right floor, U+230B ISOamsc
        '&lang;'     => '&#9001;', # left-pointing angle bracket = bra, U+2329 ISOtech
        '&rang;'     => '&#9002;', # right-pointing angle bracket = ket, U+232A ISOtech
        '&loz;'      => '&#9674;', # lozenge, U+25CA ISOpub
        '&spades;'   => '&#9824;', # black spade suit, U+2660 ISOpub
        '&clubs;'    => '&#9827;', # black club suit = shamrock, U+2663 ISOpub
        '&hearts;'   => '&#9829;', # black heart suit = valentine, U+2665 ISOpub
        '&diams;'    => '&#9830;', # black diamond suit, U+2666 ISOpub
        '&quot;'     => '&#34;',   # quotation mark = APL quote, U+0022 ISOnum
        '&amp;'      => '&#38;',   # ampersand, U+0026 ISOnum
        '&lt;'       => '&#60;',   # less-than sign, U+003C ISOnum
        '&gt;'       => '&#62;',   # greater-than sign, U+003E ISOnum
        '&OElig;'    => '&#338;',  # latin capital ligature OE, U+0152 ISOlat2
        '&oelig;'    => '&#339;',  # latin small ligature oe, U+0153 ISOlat2
        '&Scaron;'   => '&#352;',  # latin capital letter S with caron, U+0160 ISOlat2
        '&scaron;'   => '&#353;',  # latin small letter s with caron, U+0161 ISOlat2
        '&Yuml;'     => '&#376;',  # latin capital letter Y with diaeresis, U+0178 ISOlat2
        '&circ;'     => '&#710;',  # modifier letter circumflex accent, U+02C6 ISOpub
        '&tilde;'    => '&#732;',  # small tilde, U+02DC ISOdia
        '&ensp;'     => '&#8194;', # en space, U+2002 ISOpub
        '&emsp;'     => '&#8195;', # em space, U+2003 ISOpub
        '&thinsp;'   => '&#8201;', # thin space, U+2009 ISOpub
        '&zwnj;'     => '&#8204;', # zero width non-joiner, U+200C NEW RFC 2070
        '&zwj;'      => '&#8205;', # zero width joiner, U+200D NEW RFC 2070
        '&lrm;'      => '&#8206;', # left-to-right mark, U+200E NEW RFC 2070
        '&rlm;'      => '&#8207;', # right-to-left mark, U+200F NEW RFC 2070
        '&ndash;'    => '&#8211;', # en dash, U+2013 ISOpub
        '&mdash;'    => '&#8212;', # em dash, U+2014 ISOpub
        '&lsquo;'    => '&#8216;', # left single quotation mark, U+2018 ISOnum
        '&rsquo;'    => '&#8217;', # right single quotation mark, U+2019 ISOnum
        '&sbquo;'    => '&#8218;', # single low-9 quotation mark, U+201A NEW
        '&ldquo;'    => '&#8220;', # left double quotation mark, U+201C ISOnum
        '&rdquo;'    => '&#8221;', # right double quotation mark, U+201D ISOnum
        '&bdquo;'    => '&#8222;', # double low-9 quotation mark, U+201E NEW
        '&dagger;'   => '&#8224;', # dagger, U+2020 ISOpub
        '&Dagger;'   => '&#8225;', # double dagger, U+2021 ISOpub
        '&permil;'   => '&#8240;', # per mille sign, U+2030 ISOtech
        '&lsaquo;'   => '&#8249;', # single left-pointing angle quotation mark, U+2039 ISO proposed
        '&rsaquo;'   => '&#8250;', # single right-pointing angle quotation mark, U+203A ISO proposed
        '&euro;'     => '&#8364;', # euro sign, U+20AC NEW

        //XHTML standerd:
        '&apos;'     => '&#39;',   # apostrophe = APL quote, U+0027 ISOnum
    );

    //Enhanced version of SanitizeHTML which is charset-aware for UTF-8 + ISO-8859-1
    $charset = mb_detect_encoding($name, "auto, ISO-8859-1, UTF-8", true);
    if(false === $charset || !in_array($charset, array('UTF-8', 'ISO-8859-1', 'ISO-8859-15', 'cp1251', 'cp1252', 'KOI8-R', 'BIG5', 'GB2312', 'BIG5-HKSCS', 'Shift_JIS', 'EUC-JP')) ) {
        $charset = 'ISO-8859-1';
    }
    $name = htmlentities($name, ENT_QUOTES, $charset, false);

    //Normalize HTML entities
    $name = strtr($name, $HTML401NamedToNumeric);

    return $name;
}

function expandVariants($name) {
    static $replacements = array(
        '&#168;'     => array(''),  # diaeresis = spacing diaeresis, U+00A8 ISOdia
        '&#173;'     => array('-'),  # soft hyphen = discretionary hyphen, U+00AD ISOnum
        '&#175;'     => array(''),  # macron = spacing macron = overline = APL overbar, U+00AF ISOdia
        '&#180;'     => array(''),  # acute accent = spacing acute, U+00B4 ISOdia
        '&#184;'     => array(''),  # cedilla = spacing cedilla, U+00B8 ISOdia
        '&#192;'     => array('A'),  # latin capital letter A with grave = latin capital letter A grave, U+00C0 ISOlat1
        '&#193;'     => array('A'),  # latin capital letter A with acute, U+00C1 ISOlat1
        '&#194;'     => array('A'),  # latin capital letter A with circumflex, U+00C2 ISOlat1
        '&#195;'     => array('A'),  # latin capital letter A with tilde, U+00C3 ISOlat1
        '&#196;'     => array('Ae', 'A'),  # latin capital letter A with diaeresis, U+00C4 ISOlat1
        '&#197;'     => array('A'),  # latin capital letter A with ring above = latin capital letter A ring, U+00C5 ISOlat1
        '&#198;'     => array('AE'),  # latin capital letter AE = latin capital ligature AE, U+00C6 ISOlat1
        '&#199;'     => array('C'),  # latin capital letter C with cedilla, U+00C7 ISOlat1
        '&#200;'     => array('E'),  # latin capital letter E with grave, U+00C8 ISOlat1
        '&#201;'     => array('E'),  # latin capital letter E with acute, U+00C9 ISOlat1
        '&#202;'     => array('E'),  # latin capital letter E with circumflex, U+00CA ISOlat1
        '&#203;'     => array('Ee', 'E'),  # latin capital letter E with diaeresis, U+00CB ISOlat1
        '&#204;'     => array('I'),  # latin capital letter I with grave, U+00CC ISOlat1
        '&#205;'     => array('I'),  # latin capital letter I with acute, U+00CD ISOlat1
        '&#206;'     => array('I'),  # latin capital letter I with circumflex, U+00CE ISOlat1
        '&#207;'     => array('Ie', 'I'),  # latin capital letter I with diaeresis, U+00CF ISOlat1
        '&#208;'     => array('Dj', 'Gj', 'Th'),  # latin capital letter ETH, U+00D0 ISOlat1
        '&#209;'     => array('N'),  # latin capital letter N with tilde, U+00D1 ISOlat1
        '&#210;'     => array('O'),  # latin capital letter O with grave, U+00D2 ISOlat1
        '&#211;'     => array('O'),  # latin capital letter O with acute, U+00D3 ISOlat1
        '&#212;'     => array('O'),  # latin capital letter O with circumflex, U+00D4 ISOlat1
        '&#213;'     => array('O'),  # latin capital letter O with tilde, U+00D5 ISOlat1
        '&#214;'     => array('Oe', 'O'),  # latin capital letter O with diaeresis, U+00D6 ISOlat1
        '&#216;'     => array('O'),  # latin capital letter O with stroke = latin capital letter O slash, U+00D8 ISOlat1
        '&#217;'     => array('U'),  # latin capital letter U with grave, U+00D9 ISOlat1
        '&#218;'     => array('U'),  # latin capital letter U with acute, U+00DA ISOlat1
        '&#219;'     => array('U'),  # latin capital letter U with circumflex, U+00DB ISOlat1
        '&#220;'     => array('Ue', 'U'),  # latin capital letter U with diaeresis, U+00DC ISOlat1
        '&#221;'     => array('Y'),  # latin capital letter Y with acute, U+00DD ISOlat1
        '&#222;'     => array('Th'),  # latin capital letter THORN, U+00DE ISOlat1
        '&#223;'     => array('ss', 'sz'),  # latin small letter sharp s = ess-zed, U+00DF ISOlat1
        '&#224;'     => array('a'),  # latin small letter a with grave = latin small letter a grave, U+00E0 ISOlat1
        '&#225;'     => array('a'),  # latin small letter a with acute, U+00E1 ISOlat1
        '&#226;'     => array('a'),  # latin small letter a with circumflex, U+00E2 ISOlat1
        '&#227;'     => array('a'),  # latin small letter a with tilde, U+00E3 ISOlat1
        '&#228;'     => array('ae', 'a'),  # latin small letter a with diaeresis, U+00E4 ISOlat1
        '&#229;'     => array('a'),  # latin small letter a with ring above = latin small letter a ring, U+00E5 ISOlat1
        '&#230;'     => array('ae'),  # latin small letter ae = latin small ligature ae, U+00E6 ISOlat1
        '&#231;'     => array('c'),  # latin small letter c with cedilla, U+00E7 ISOlat1
        '&#232;'     => array('e'),  # latin small letter e with grave, U+00E8 ISOlat1
        '&#233;'     => array('e'),  # latin small letter e with acute, U+00E9 ISOlat1
        '&#234;'     => array('e'),  # latin small letter e with circumflex, U+00EA ISOlat1
        '&#235;'     => array('ee', 'e'),  # latin small letter e with diaeresis, U+00EB ISOlat1
        '&#236;'     => array('i'),  # latin small letter i with grave, U+00EC ISOlat1
        '&#237;'     => array('i'),  # latin small letter i with acute, U+00ED ISOlat1
        '&#238;'     => array('i'),  # latin small letter i with circumflex, U+00EE ISOlat1
        '&#239;'     => array('ie', 'i'),  # latin small letter i with diaeresis, U+00EF ISOlat1
        '&#240;'     => array('dj', 'gj', 'th'),  # latin small letter eth, U+00F0 ISOlat1
        '&#241;'     => array('n'),  # latin small letter n with tilde, U+00F1 ISOlat1
        '&#242;'     => array('o'),  # latin small letter o with grave, U+00F2 ISOlat1
        '&#243;'     => array('o'),  # latin small letter o with acute, U+00F3 ISOlat1
        '&#244;'     => array('o'),  # latin small letter o with circumflex, U+00F4 ISOlat1
        '&#245;'     => array('o'),  # latin small letter o with tilde, U+00F5 ISOlat1
        '&#246;'     => array('oe', 'o'),  # latin small letter o with diaeresis, U+00F6 ISOlat1
        '&#248;'     => array('o'),  # latin small letter o with stroke, = latin small letter o slash, U+00F8 ISOlat1
        '&#249;'     => array('u'),  # latin small letter u with grave, U+00F9 ISOlat1
        '&#250;'     => array('u'),  # latin small letter u with acute, U+00FA ISOlat1
        '&#251;'     => array('u'),  # latin small letter u with circumflex, U+00FB ISOlat1
        '&#252;'     => array('ue', 'u'),  # latin small letter u with diaeresis, U+00FC ISOlat1
        '&#253;'     => array('y'),  # latin small letter y with acute, U+00FD ISOlat1
        '&#254;'     => array('th'),  # latin small letter thorn, U+00FE ISOlat1
        '&#255;'     => array('y', 'ij', 'ii', 'ei'),  # latin small letter y with diaeresis, U+00FF ISOlat1
        '&#402;'     => array('f'),  # latin small f with hook = function = florin, U+0192 ISOtech
        '&#338;'     => array('OE'),  # latin capital ligature OE, U+0152 ISOlat2
        '&#339;'     => array('oe'),  # latin small ligature oe, U+0153 ISOlat2
        '&#352;'     => array('s'),  # latin capital letter S with caron, U+0160 ISOlat2
        '&#353;'     => array('s'),  # latin small letter s with caron, U+0161 ISOlat2
        '&#376;'     => array('Y', 'Ij', 'Ii', 'Ei'),  # latin capital letter Y with diaeresis, U+0178 ISOlat2
        '&#710;'     => array(''),  # modifier letter circumflex accent, U+02C6 ISOpub
    );

    $variants = array($name);

    foreach($replacements as $rk => $rv) {
        $vnew = array();
        foreach($variants as $variant) {
            foreach($rv as $rv1) {
                $vnew[] = str_replace($rk, $rv1, $variant);
            }
        }
        $variants = $vnew;
        $variants = array_unique($variants);
    }

    $variants = array_filter($variants, function($a) { return false === strstr($a, "&"); } );

    return $variants;
}

function compareName($requested, $acceptable) {
    if(empty($acceptable) || empty($requested)) {
        return false;
    }

    $requested = normalizeName($requested);
    $acceptable = normalizeName($acceptable);

    if(0 === strcasecmp($requested, $acceptable)) {
        return true;
    }

    $variants = expandVariants($acceptable);
    foreach($variants as $acceptable_variant) {
        if(0 === strcasecmp($requested, $acceptable_variant)) {
            return true;
        }
    }

    return false;
}

function verifyName($name)
{
	if($name == "") return 0;

	$q = mysql_query("SELECT HEX(CONVERT(users.fname USING utf8)) as fname, HEX(CONVERT(users.mname USING utf8)) as mname, HEX(CONVERT(users.lname USING utf8)) as lname, HEX(CONVERT(users.suffix USING UTF8)) as suffix FROM users WHERE id='" . intval($_SESSION["profile"]["id"]) . "'");
	if( false === ($row = mysql_fetch_assoc($q)) ) {
		return 0;
	}

	$row['fname'] = hex2bin($row['fname']);
	$row['mname'] = hex2bin($row['mname']);
	$row['lname'] = hex2bin($row['lname']);
	$row['suffix'] = hex2bin($row['suffix']);

	if(compareName($name, $row['fname']." ".$row['lname'])) return 1; // John Doe
	if(compareName($name, $row['fname']." ".$row['mname']." ".$row['lname'])) return 1; // John Joseph Doe
	if(compareName($name, $row['fname']." ".$row['mname'][0]." ".$row['lname'])) return 1; // John J Doe
	if(compareName($name, $row['fname']." ".$row['mname'][0].". ".$row['lname'])) return 1; // John J. Doe

	if(compareName($name, $row['fname']." ".$row['lname']." ".$row['suffix'])) return 1; // John Doe Jr.
	if(compareName($name, $row['fname']." ".$row['mname']." ".$row['lname']." ".$row['suffix'])) return 1; //John Joseph Doe Jr.
	if(compareName($name, $row['fname']." ".$row['mname'][0]." ".$row['lname']." ".$row['suffix'])) return 1; //John J Doe Jr.
	if(compareName($name, $row['fname']." ".$row['mname'][0].". ".$row['lname']." ".$row['suffix'])) return 1; //John J. Doe Jr.

	return 0;
}

function verifyEmail($email)
{
	if($email == "") return 0;
	if(mysql_num_rows(mysql_query("select * from `email` where `memid`='".$_SESSION['profile']['id']."' and `email`='".mysql_real_escape_string($email)."' and `deleted`=0 and `hash`=''")) > 0) return 1;
	return 0;
}



	$ToBeDeleted=array();
	$state=0;
	if($oldid == "0" && $CSR != "")
	{
		if(!array_key_exists('CCA',$_REQUEST))
		{
			showheader(_("My CAcert.org Account!"));
			echo _("You did not accept the CAcert Community Agreement (CCA), hit the back button and try again.");
			showfooter();
			exit;
		}

		$err = runCommand('mktemp --directory /tmp/cacert_gpg.XXXXXXXXXX',
				"",
				$tmpdir);
		if (!$tmpdir)
		{
			$err = true;
		}

		if (!$err)
		{
			$err = runCommand("gpg --with-colons --homedir $tmpdir 2>&1",
					clean_gpgcsr($CSR),
					$gpg);

			shell_exec("rm -r $tmpdir");
		}

		if ($err)
		{
			showheader(_("Welcome to CAcert.org"));

			echo "<p style='color:#ff0000'>"._("There was an error parsing your key.")."</p>";
			unset($_REQUEST['process']);
			$id = $oldid;
			unset($oldid);
			exit();
		}

		$lines = "";
		$gpgarr = explode("\n", trim($gpg));
		foreach($gpgarr as $line)
		{
			#echo "Line[]: $line <br/>\n";
			if(substr($line, 0, 3) == "pub" || substr($line, 0, 3) == "uid")
			{
				if($lines != "")
					$lines .= "\n";
				$lines .= $line;
			}
		}
		$gpg = $lines;
		$expires = 0;
		$nerr=0; $nok=0;
		$multiple = 0;

		$resulttable=_("The following UIDs were found in your key:")."<br/><table border='1'><tr><td>#</td><td>"._("Name")."</td><td>"._("Email")."</td><td>Result</td>";
		$i=0;
		$lastvalidemail="";
                $npubs=0;
		foreach(explode("\n", $gpg) as $line)
		{
			$bits = explode(":", $line);
			$resulttable.="<tr><td>".++$i."</td>";
			$name = $comment = "";
			if($bits[0] == "pub")
			{
				$npubs++;
			}
			if($npubs>1)
			{
				showheader(_("Welcome to CAcert.org"));
				echo "<font color='#ff0000'>"._("Please upload only one key at a time.")."</font>";
				unset($_REQUEST['process']);
				$id = $oldid;
				unset($oldid);
				exit();
			}
			if($bits[0] == "pub" && (!$keyid || !$when))
			{
				$keyid = $bits[4];
				$when = $bits[5];
				if($bits[6] != "")
					$expires = 1;
			}
			$name="";
			$comm="";
			$mail="";
			$uidformatwrong=0;

			if(sizeof($bits)<10) $uidformatwrong=1;

			if(preg_match("/\@.*\@/",$bits[9]))
			{
				showheader(_("Welcome to CAcert.org"));

				echo "<font color='#ff0000'>"._("Multiple Email Adresses per UID are not allowed.")."</font>";
				unset($_REQUEST['process']);
				$id = $oldid;
				unset($oldid);
				exit();
			}

			// Name (Comment) <Email>
			if(preg_match("/^([^\(\)\[@<>]+) \(([^\(\)@<>]*)\) <([\w=\/%.-]*\@[\w.-]*|[\w.-]*\![\w=\/%.-]*)>/",$bits[9],$matches))
			{
			  $name=trim(gpg_hex2bin($matches[1]));
			  $nocomment=0;
			  $comm=trim(gpg_hex2bin($matches[2]));
			  $mail=trim(gpg_hex2bin($matches[3]));
			}
			// Name <EMail>
			elseif(preg_match("/^([^\(\)\[@<>]+) <([\w=\/%.-]*\@[\w.-]*|[\w.-]*\![\w=\/%.-]*)>/",$bits[9],$matches))
			{
			  $name=trim(gpg_hex2bin($matches[1]));
			  $nocomment=1;
			  $comm="";
			  $mail=trim(gpg_hex2bin($matches[2]));
			}
			// Unrecognized format
			else
			{
				$nocomment=1;
				$uidformatwrong=1;
			}
			$nameok=verifyName($name);
			$emailok=verifyEmail($mail);


			if($comm != "")
				$comment[] = $comm;

			$resulttable.="<td bgcolor='#".($nameok?"c0ffc0":"ffc0c0")."'>".sanitizeHTML($name)."</td>";
                        $resulttable.="<td bgcolor='#".($emailok?"c0ffc0":"ffc0c0")."'>".sanitizeHTML($mail)."</td>";

			$uidok=0;
			if($bits[1]=="r")
			{
				$rmessage=_("Error: UID is revoked");
			}
			elseif($uidformatwrong==1)
			{
				$rmessage=_("The format of the UID was not recognized. Please use 'Name (comment) &lt;email@domain>'");
			}
			elseif($mail=="" and $name=="")
			{
				$rmessage=_("Error: Both Name and Email address are empty");
			}
			elseif($emailok and $nameok)
			{
				$uidok=1;
				$rmessage=_("Name and Email OK.");
			}
			elseif(!$emailok and !$nameok)
			{
				$rmessage=_("Name and Email both cannot be matched with your account.");
			}
			elseif($emailok and $name=="")
			{
				$uidok=1;
				$rmessage=_("The email is OK. The name is empty.");
			}
			elseif($nameok and $mail=="")
			{
				$uidok=1;
				$rmessage=_("The name is OK. The email is empty.");
			}
			elseif(!$emailok)
			{
				$rmessage=_("The email address has not been registered and verified in your account. Please add the email address to your account first.");
			}
			elseif(!$nameok)
			{
				$rmessage=_("The name in the UID does not match the name in your account. Please verify the name.");
			}

			else
			{
				$rmessage=_("Error");
			}
			if($uidok)
			{
				$nok++;
				$resulttable.="<td>$rmessage</td>";
				$lastvalidemail=$mail;
			}
			else
			{
				$nerr++;
				//$ToBeDeleted[]=$i;
				//echo "Adding UID $i\n";
				$resulttable.="<td bgcolor='#ffc0c0'>$rmessage</td>";
			}
			$resulttable.="</tr>\n";

			if($emailok) $multiple++;
		}
		$resulttable.="</table>";

		if($nok==0)
		{
			showheader(_("Welcome to CAcert.org"));
			echo $resulttable;

			echo "<font color='#ff0000'>"._("No valid UIDs found on your key")."</font>";
			unset($_REQUEST['process']);
			$id = $oldid;
			unset($oldid);
			exit();
		}
		elseif($nerr)
		{
			$resulttable.=_("The unverified UIDs have been removed, the verified UIDs have been signed.");
		}


 	}


	if($oldid == "0" && $CSR != "")
	{
		write_user_agreement(intval($_SESSION['profile']['id']), "CCA", "certificate creation", "", 1);

		//set variable for comment
		if(trim($_REQUEST['description']) == ""){
			$description= "";
		}else{
			$description= trim(mysql_real_escape_string(stripslashes($_REQUEST['description'])));
		}

		$query = "insert into `gpg` set `memid`='".intval($_SESSION['profile']['id'])."',
						`email`='".mysql_real_escape_string($lastvalidemail)."',
						`level`='1',
						`expires`='".mysql_real_escape_string($expires)."',
						`multiple`='".mysql_real_escape_string($multiple)."',
						`keyid`='".mysql_real_escape_string($keyid)."',
						`description`='".mysql_real_escape_string($description)."'";
		mysql_query($query);
		$insert_id = mysql_insert_id();


		$cwd = '/tmp/gpgspace'.$insert_id;
		mkdir($cwd,0755);

		$fp = fopen("$cwd/gpg.csr", "w");
		fputs($fp, clean_gpgcsr($CSR));
		fclose($fp);


		system("gpg --homedir $cwd --import $cwd/gpg.csr");


		$cmd_keyid = escapeshellarg($keyid);
		$gpg = trim(shell_exec("gpg --homedir $cwd --with-colons --fixed-list-mode --list-keys $cmd_keyid 2>&1"));
		$lines = "";
		$gpgarr = explode("\n", $gpg);
		foreach($gpgarr as $line)
		{
			//echo "Line[]: $line <br/>\n";
			if(substr($line, 0, 4) == "uid:")
			{
				$name = $comment = "";
				$bits = explode(":", $line);

				$pos = strpos($bits[9], "(") - 1;
				$nocomment = 0;
				if($pos < 0)
				{
					$nocomment = 1;
					$pos = strpos($bits[9], "<") - 1;
				}
				if($pos < 0)
				{
					$pos = strlen($bits[9]);
				}

				$name = trim(gpg_hex2bin(trim(substr($bits[9], 0, $pos))));
				$nameok=verifyName($name);
				if($nocomment == 0)
				{
					$pos += 2;
					$pos2 = strpos($bits[9], ")");
					$comm = trim(gpg_hex2bin(trim(substr($bits[9], $pos, $pos2 - $pos))));
					if($comm != "")
						$comment[] = $comm;
					$pos = $pos2 + 3;
				} else {
					$pos = strpos($bits[9], "<") + 1;
				}

				$mail="";
				if (preg_match("/<([\w.-]*\@[\w.-]*)>/", $bits[9],$match)) {
					//echo "Found: ".$match[1];
					$mail = trim(gpg_hex2bin($match[1]));
				}
				else
				{
					//echo "Not found!\n";
				}

				$emailok=verifyEmail($mail);

				$uidid=$bits[7];

			if($bits[1]=="r")
			{
				$ToBeDeleted[]=$uidid;
			}
			elseif($mail=="" and $name=="")
			{
				//echo "$uidid will be deleted\n";
				$ToBeDeleted[]=$uidid;
			}
			elseif($emailok and $nameok)
			{
			}
			elseif($emailok and $name=="")
			{
			}
			elseif($nameok and $mail=="")
			{
			}
			elseif(!$emailok and !$nameok)
			{
				//echo "$uidid will be deleted\n";
				$ToBeDeleted[]=$uidid;
			}
			elseif(!$emailok)
			{
				//echo "$uidid will be deleted\n";
				$ToBeDeleted[]=$uidid;
			}
			elseif(!$nameok)
			{
				//echo "$uidid will be deleted\n";
				$ToBeDeleted[]=$uidid;
			}

			}
		}

		if(count($ToBeDeleted)>0)
		{
			$descriptorspec = array(
				0 => array("pipe", "r"),  // stdin is a pipe that the child will read from
				1 => array("pipe", "w"),  // stdout is a pipe that the child will write to
				2 => array("pipe", "w") // stderr is a file to write to
			);

			$stderr = fopen('php://stderr', 'w');

			//echo "Keyid: $keyid\n";

			$cmd_keyid = escapeshellarg($keyid);
			$process = proc_open("/usr/bin/gpg --homedir $cwd --no-tty --command-fd 0 --status-fd 1 --logger-fd 2 --edit-key $cmd_keyid", $descriptorspec, $pipes);

			//echo "Process: $process\n";
			//fputs($stderr,"Process: $process\n");

			if (is_resource($process)) {
			//echo("it is a resource\n");
			// $pipes now looks like this:
			// 0 => writeable handle connected to child stdin
			// 1 => readable handle connected to child stdout
			// Any error output will be appended to /tmp/error-output.txt
				while (!feof($pipes[1]))
				{
					$buffer = fgets($pipes[1], 4096);
					//echo $buffer;

			if($buffer == "[GNUPG:] GET_BOOL keyedit.sign_all.okay\n")
			{
				fputs($pipes[0],"yes\n");
			}
			elseif($buffer == "[GNUPG:] GOT_IT\n")
			{
			}
			elseif(ereg("^\[GNUPG:\] GET_BOOL keyedit\.remove\.uid\.okay\s*",$buffer))
			{
				fputs($pipes[0],"yes\n");
			}
			elseif(ereg("^\[GNUPG:\] GET_LINE keyedit\.prompt\s*",$buffer))
			{
				if(count($ToBeDeleted)>0)
				{
					$delthisuid=array_pop($ToBeDeleted);
					//echo "Deleting an UID $delthisuid\n";
					fputs($pipes[0],"uid ".$delthisuid."\n");
				}
				else
				{
					//echo "Saving\n";
					fputs($pipes[0],$state?"save\n":"deluid\n");
					$state++;
				}
			}
			elseif($buffer == "[GNUPG:] GOOD_PASSPHRASE\n")
			{
			}
			elseif(ereg("^\[GNUPG:\] KEYEXPIRED ",$buffer))
			{
				echo "Key expired!\n";
				exit;
			}
			elseif($buffer == "")
			{
				//echo "Empty!\n";
			}
			else
			{
				echo "ERROR: UNKNOWN $buffer\n";
			}


			}
			//echo "Fertig\n";
			fclose($pipes[0]);

			//echo stream_get_contents($pipes[1]);
			fclose($pipes[1]);

			// It is important that you close any pipes before calling
			// proc_close in order to avoid a deadlock
			$return_value = proc_close($process);

			//echo "command returned $return_value\n";
		}
		else
		{
			echo "Keine ressource!\n";
		}


		}


		$csrname=generatecertpath("csr","gpg",$insert_id);
		$cmd_keyid = escapeshellarg($keyid);
		$do=shell_exec("gpg --homedir $cwd --batch --export-options export-minimal --export $cmd_keyid >$csrname");

		mysql_query("update `gpg` set `csr`='$csrname' where `id`='$insert_id'");
		waitForResult('gpg', $insert_id);

		showheader(_("Welcome to CAcert.org"));
		echo $resulttable;
		$query = "select * from `gpg` where `id`='$insert_id' and `crt`!=''";
		$res = mysql_query($query);
		if(mysql_num_rows($res) <= 0)
		{
			echo _("Your certificate request has failed to be processed correctly, please try submitting it again.")."<br>\n";
			echo _("If this is a re-occuring problem, please send a copy of the key you are trying to signed to support@cacert.org. Thank you.");
		} else {
			echo "<pre>";
			readfile(generatecertpath("crt","gpg",$insert_id));
			echo "</pre>";
		}

		showfooter();
		exit;
	}

	if($oldid == 2 && array_key_exists('change',$_REQUEST) && $_REQUEST['change'] != "")
	{
		showheader(_("My CAcert.org Account!"));
		foreach($_REQUEST as $id => $val)
		{
			if(substr($id,0,14)=="check_comment_")
			{
				$cid = intval(substr($id,14));
				$comment=trim(mysql_real_escape_string(stripslashes($_REQUEST['comment_'.$cid])));
				mysql_query("update `gpg` set `description`='$comment' where `id`='$cid' and `memid`='".$_SESSION['profile']['id']."'");
			}
		}
		echo(_("Certificate settings have been changed.")."<br/>\n");
		showfooter();
		exit;
	}

	$id = intval($id);

	showheader(_("Welcome to CAcert.org"));
	includeit($id, "gpg");
	showfooter();
?>