X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fmarketing.inc.php;h=db2c1bca91c5d74e2264bfad97d6abf6e41fc679;hb=0fcbe8d082a7b97c668edd5954038e01ad41484f;hp=74f731270eb234f756301f580d096cd36003b9ca;hpb=20d90835b01594bd258497eab4afa286a30dd53e;p=platal.git

diff --git a/include/marketing.inc.php b/include/marketing.inc.php
index 74f7312..db2c1bc 100644
--- a/include/marketing.inc.php
+++ b/include/marketing.inc.php
@@ -24,8 +24,7 @@ require_once("xorg.misc.inc.php");
 // {{{ function mark_from_mail
 
 function mark_from_mail($uid, $email) {
-    global $globals;
-    $res = $globals->xdb->query(
+    $res = XDB::query(
         "SELECT u.nom, u.prenom, a.alias
            FROM register_marketing  AS r
      INNER JOIN auth_user_md5       AS u ON (r.sender = u.user_id)
@@ -34,7 +33,6 @@ function mark_from_mail($uid, $email) {
         $uid, $email);
     $sender = $res->fetchOneAssoc();
     return "\"".$sender['prenom']." ".$sender['nom']."\" <".$sender['alias']."@polytechnique.org>";
-    
 }
 
 // }}}
@@ -45,10 +43,10 @@ function mark_text_mail($uid, $email)
     global $globals;
     $title = "Annuaire en ligne des Polytechniciens";
 
-    $res = $globals->xdb->query("SELECT COUNT(*) FROM auth_user_md5 WHERE perms IN ('admin', 'user') and deces = 0");
+    $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE perms IN ('admin', 'user') and deces = 0");
     $num_users = $res->fetchOneCell();
 
-    $res = $globals->xdb->query("SELECT flags, nom, prenom, promo FROM auth_user_md5 WHERE user_id = {?}", $uid);
+    $res = XDB::query("SELECT flags, nom, prenom, promo FROM auth_user_md5 WHERE user_id = {?}", $uid);
     $u = $res->fetchOneAssoc();
 
     $mailorg = make_forlife($u['prenom'],$u['nom'],$u['promo']);
@@ -81,10 +79,9 @@ function mark_text_mail($uid, $email)
 function mark_send_mail($uid, $email, $perso, $to='', $title='', $text='') 
 {
     require_once("diogenes/diogenes.hermes.inc.php");
-    global $globals;
 
     $hash = rand_url_id(12);
-    $globals->xdb->execute('UPDATE register_marketing SET nb=nb+1,hash={?},last=NOW() WHERE uid={?} AND email={?}', $hash, $uid, $email);
+    XDB::execute('UPDATE register_marketing SET nb=nb+1,hash={?},last=NOW() WHERE uid={?} AND email={?}', $hash, $uid, $email);
  
     if ($to == '')
         list($to, $title, $text) = mark_text_mail($uid, $email);
@@ -114,11 +111,11 @@ function relance($uid, $nbx = -1)
     global $globals;
 
     if ($nbx < 0) {
-        $res = $globals->xdb->query("SELECT COUNT(*) FROM auth_user_md5 WHERE deces=0");
+        $res = XDB::query("SELECT COUNT(*) FROM auth_user_md5 WHERE deces=0");
         $nbx = $res->fetchOneCell();
     }
 
-    $res = $globals->xdb->query(
+    $res = XDB::query(
             "SELECT  r.date, u.promo, u.nom, u.prenom, r.email, r.bestalias
                FROM  register_pending AS r
          INNER JOIN  auth_user_md5    AS u ON u.user_id = r.uid
@@ -144,7 +141,7 @@ function relance($uid, $nbx = -1)
     $mymail->assign('lemail',     $email);
     $mymail->assign('subj',       $alias.'@'.$globals->mail->domain);
     $mymail->send();
-    $globals->xdb->execute('UPDATE register_pending SET hash={?}, password={?}, relance=NOW() WHERE uid={?}', $hash, $pass_encrypted, $uid);
+    XDB::execute('UPDATE register_pending SET hash={?}, password={?}, relance=NOW() WHERE uid={?}', $hash, $pass_encrypted, $uid);
 
     return "$prenom $nom ($promo)";
 }