X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fpayment%2Fmoney%2Fpaypal.inc.php;h=d5c2d9f2004e008f6ec1e820682180825c8b1c56;hb=0073747ac81cc9cff9e43847eb008f0e815255f0;hp=231c86d42a58f7c6828ef5092045adda72c241ce;hpb=e46cf8c46341b447cc3701c8afcc9baec3da11e5;p=platal.git

diff --git a/modules/payment/money/paypal.inc.php b/modules/payment/money/paypal.inc.php
index 231c86d..d5c2d9f 100644
--- a/modules/payment/money/paypal.inc.php
+++ b/modules/payment/money/paypal.inc.php
@@ -1,6 +1,6 @@
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2009 Polytechnique.org                              *
+ *  Copyright (C) 2003-2010 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -69,20 +69,17 @@ class PayPal
             'email'      => S::user()->bestEmail()
         );
 
-        // XXX: waiting for port of adresses.
-        $res = XDB::query(
-                "SELECT  a.text, l.name AS city, a.postalCode AS zip, a.countryiId AS country,
-                         IF(t1.display_tel != '', t1.display_tel, t2.display_tel) AS night_phone_b
-                   FROM  auth_user_quick   AS q
-              LEFT JOIN  profile_addresses AS a  ON (q.user_id = a.pid AND FIND_IN_SET('current', a.flags))
-              LEFT JOIN  profile_phones    AS t1 ON (t1.uid = a.uid AND t1.link_type = 'address'
-                                                     AND t1.link_id = a.adrid)
-              LEFT JOIN  profile_phones    AS t2 ON (t2.uid = a.uid AND t2.link_type = 'user'
-                                                     AND t2.link_id = 0)
-              LEFT JOIN  geoloc_localities AS l  ON (l.id = a.localityId)
-                  WHERE  q.user_id = {?}
-                  LIMIT  1",
-                S::v('uid'));
+        $res = XDB::query("SELECT  pa.text, gl.name AS city, pa.postalCode AS zip, pa.countryiId AS country,
+                                   IF(pp1.display_tel != '', pp1.display_tel, pp2.display_tel) AS night_phone_b
+                             FROM  profile_addresses AS pa
+                        LEFT JOIN  profile_phones    AS pp1 ON (pp1.pid = pa.pid AND pp1.link_type = 'address'
+                                                                AND pp1.link_id = pa.adrid)
+                        LEFT JOIN  profile_phones    AS pp2 ON (pp2.pid = pa.pid AND pp2.link_type = 'user'
+                                                                AND pp2.link_id = 0)
+                        LEFT JOIN  geoloc_localities AS gl  ON (gl.id = pa.localityId)
+                            WHERE  pa.pid = {?} AND FIND_IN_SET('current', pa.flags)
+                            LIMIT  1",
+                          S::i('pid'));
         $this->infos['client'] = array_map('replace_accent', array_merge($info_client, $res->fetchOneAssoc()));
         list($this->infos['client']['address1'], $this->infos['client']['address2']) =
             explode("\n", Geocoder::getFirstLines($this->infos['client']['text'],