From 937e3c82dba6ab139ec02f38ee978be0761dcc44 Mon Sep 17 00:00:00 2001
From: x2003bruneau <x2003bruneau@839d8a87-29fc-0310-9880-83ba4fa771e5>
Date: Fri, 18 Aug 2006 12:25:34 +0000
Subject: [PATCH] Add photo in vcard... (I think this is useful)

git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@820 839d8a87-29fc-0310-9880-83ba4fa771e5
---
 modules/profile.php | 9 +++++++++
 templates/vcard.tpl | 3 +++
 2 files changed, 12 insertions(+)

diff --git a/modules/profile.php b/modules/profile.php
index 6e8479f..4b30004 100644
--- a/modules/profile.php
+++ b/modules/profile.php
@@ -689,6 +689,15 @@ class ProfileModule extends PLModule
 
         $user['virtualalias'] = $res->fetchOneCell();
 
+        // get photo
+        $res = XDB::query(
+                "SELECT attach
+                   FROM photo   AS p
+             INNER JOIN aliases AS a ON (a.id = p.uid AND a.type = 'a_vie')
+                  WHERE a.alias = {?}", $login);
+        if ($res->numRows()) {
+            $user['photo'] = $res->fetchOneCell();
+        }
         $page->assign_by_ref('vcard', $user);
 
         header("Pragma: ");
diff --git a/templates/vcard.tpl b/templates/vcard.tpl
index 930367a..34afc0c 100644
--- a/templates/vcard.tpl
+++ b/templates/vcard.tpl
@@ -71,6 +71,9 @@ NOTE;ENCODING=QUOTED-PRINTABLE:{"(X`$vcard.promo`)"|qp_enc}
 {else}
 NOTE;ENCODING=QUOTED-PRINTABLE:{"(X`$vcard.promo`)\n`$vcard.libre`"|qp_enc}
 {/if}
+{if $vcard.photo}
+PHOTO;BASE64:{$vcard.photo|base64_encode}
+{/if}
 SORT-STRING;ENCODING=QUOTED-PRINTABLE:{$vcard.nom|qp_enc}
 REV:{$vcard.date|date_format:"%Y%m%dT000000Z"}
 END:VCARD
-- 
2.1.4