File: sn_user_export.vspx

package info (click to toggle)
virtuoso-opensource 7.2.5.1%2Bdfsg1-0.3
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 285,240 kB
  • sloc: ansic: 641,220; sql: 490,413; xml: 269,570; java: 83,893; javascript: 79,900; cpp: 36,927; sh: 31,653; cs: 25,702; php: 12,690; yacc: 10,227; lex: 7,601; makefile: 7,129; jsp: 4,523; awk: 1,697; perl: 1,013; ruby: 1,003; python: 326
file content (122 lines) | stat: -rw-r--r-- 4,165 bytes parent folder | download | duplicates (2)
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
<?xml version="1.0" encoding="UTF-8"?>
<!--
 -
 -  $Id$
 -
 -  This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
 -  project.
 -
 -  Copyright (C) 1998-2018 OpenLink Software
 -
 -  This project 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; only version 2 of the License, dated June 1991.
 -
 -  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 St, Fifth Floor, Boston, MA 02110-1301 USA
 -
-->
<v:page name="blog-home-page" xmlns:vm="http://www.openlinksw.com/vspx/ods/" xmlns:v="http://www.openlinksw.com/vspx/" style="index.xsl" doctype="-//W3C//DTD XHTML 1.0 Transitional//EN"  doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <vm:page>
    <vm:header>
      <vm:title>User Profile</vm:title>
    </vm:header>
    <vm:pagewrapper>
      <vm:body>
        <vm:login redirect="index.vspx"/>
    </vm:body>
    </vm:pagewrapper>
  </vm:page>
  <?vsp
     declare visb, arr, tmp, str any;
     declare uid, ufid, own integer;
     declare ufname varchar;

     uid := self.u_id;
     ufid := cast(get_keyword ('ufid', self.vc_event.ve_params) as integer);
     ufname := cast(get_keyword ('ufname', self.vc_event.ve_params) as varchar);
     if ( ufid = uid) own := 1;
     else own := 0;
     visb := WA_USER_VISIBILITY(ufname);
     arr := WA_GET_USER_INFO(uid, ufid, visb, own);

     http_rewrite ();
     http_request_status ('HTTP/1.1 200 OK');
     http_header (sprintf ('Content-Type: text/x-vcard\r\nContent-Disposition: inline; filename="%s.vcf"\r\n', ufname));
     http ('BEGIN:VCARD\r\n');
     http ('VERSION:2.1\r\n');
     http (sprintf ('FN:%s\r\n', coalesce(arr[3],'')));
     http (sprintf ('EMAIL;PREF;INTERNET:%s\r\n', coalesce(arr[4],'')));
     http (sprintf ('N:%s;%s\r\n', coalesce(arr[1],''), coalesce(arr[2],'')));
     http (sprintf ('NICKNAME:%s\r\n', ufname));
     tmp := coalesce(arr[6],'');
     if (tmp is not null and __tag (tmp) = 211)
       http (sprintf ('BDAY:%s\r\n', date_iso8601 (tmp)));

     str := ';';
     tmp := coalesce(arr[15][0],'');
       str := str || '' || tmp;
     tmp := coalesce(arr[15][1],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[16][0],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[16][1],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[15][2],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[16][2],'');
       str := str || ';' || tmp;


     http (sprintf ('ADR;TYPE=HOME:%s\r\n', str));

     tmp := coalesce(arr[18][0],'');
     if (isstring(tmp))
     http (sprintf ('TEL;TYPE=HOME;VOICE:%s\r\n', tmp));

     str := ';;';
     tmp := coalesce(arr[22][0],'');
       str := str || '' || tmp;
     tmp := coalesce(arr[22][1],'');
       str := str || ' ' || tmp;
     tmp := coalesce(arr[23][0],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[23][1],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[22][2],'');
       str := str || ';' || tmp;
     tmp := coalesce(arr[23][2],'');
       str := str || ';' || tmp;


     http (sprintf ('ADR;TYPE=WORK:%s\r\n', str));

     tmp := coalesce(arr[25][0],'');
     if (isstring(tmp))
     http (sprintf ('TEL;TYPE=WORK;VOICE:%s\r\n', tmp));

     tmp := coalesce(arr[25][1],'');
     if (isstring(tmp))
     http (sprintf ('TEL;TYPE=CELL;VOICE:%s\r\n', tmp));

     tmp := coalesce(arr[17],'');
     if (tmp is not null)
     http (sprintf ('TZ:%s\r\n', tmp));

     tmp := coalesce(arr[7],'');
     if (tmp is not null)
       http (sprintf ('URL:%s\r\n', tmp));

     tmp := coalesce(arr[20],'');
     if (tmp is not null)
       http (sprintf ('ORG:%s\r\n', tmp));
     http ('END:VCARD\r\n');
     return;
  ?>
</v:page>