X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Fuser.func.inc.php;h=5b40532d604b3ed48a71a02657c2adbbcb055d67;hb=493b6abebf3d6c35691f66fd1bfdc063efaab576;hp=42ac9321d13219ce7d9ea6ee093de15cbfeca81c;hpb=74c55fd634f1398c62a3621f395dfbe2916381fc;p=platal.git diff --git a/include/user.func.inc.php b/include/user.func.inc.php index 42ac932..5b40532 100644 --- a/include/user.func.inc.php +++ b/include/user.func.inc.php @@ -1,6 +1,6 @@ fetchOneCell(); + $tables_to_clear = array('uid' => array('competences_ins', 'entreprises', 'langues_ins', 'mentor_pays', + 'mentor_secteurs', 'mentor', 'perte_pass', 'watch_sub'), + 'user_id' => array('requests', 'user_changes')); + if ($really_del) { - XDB::execute("DELETE FROM emails WHERE uid={?}", $uid); - XDB::execute("DELETE FROM newsletter_ins WHERE user_id={?}", $uid); + array_push($tables_to_clear['uid'], 'emails', 'groupex.membres', 'contacts', 'adresses', 'tels', + 'photo', 'perte_pass', 'langues_ins', 'forums.abos', 'forums.profils'); + array_push($tables_to_clear['user_id'], 'newsletter_ins', 'auth_user_quick', 'binets_ins'); + $tables_to_clear['id'] = array('aliases'); + $tables_to_clear['contact'] = array('contacts'); + $tables_to_clear['guid'] = array('groupesx_ins'); + XDB::execute("UPDATE auth_user_md5 + SET date_ins = 0, promo_sortie = 0, nom_usage = '', password = '', perms = 'pending', + nationalite = '', cv = '', section = 0, date = 0, smtppass = '' + WHERE user_id = {?}", $uid); + XDB::execute("DELETE virtual.* FROM virtual INNER JOIN virtual_redirect AS r USING(vid) WHERE redirect = {?}", + $alias.'@'.$globals->mail->domain); + XDB::execute("DELETE virtual.* FROM virtual INNER JOIN virtual_redirect AS r USING(vid) WHERE redirect = {?}", + $alias.'@'.$globals->mail->domain2); + } else { + XDB::execute("UPDATE auth_user_md5 SET password='',smtppass='' WHERE user_id={?}", $uid); + XDB::execute("UPDATE auth_user_quick SET watch_flags='' WHERE user_id={?}", $uid); } XDB::execute("DELETE FROM virtual_redirect WHERE redirect = {?}", $alias.'@'.$globals->mail->domain); XDB::execute("DELETE FROM virtual_redirect WHERE redirect = {?}", $alias.'@'.$globals->mail->domain2); - XDB::execute("UPDATE auth_user_md5 SET password='',smtppass='' WHERE user_id={?}", $uid); - XDB::execute("UPDATE auth_user_quick SET watch_flags='' WHERE user_id={?}", $uid); - - XDB::execute("DELETE FROM competences_ins WHERE uid={?}", $uid); - XDB::execute("DELETE FROM entreprises WHERE uid={?}", $uid); - XDB::execute("DELETE FROM langues_ins WHERE uid={?}", $uid); - XDB::execute("DELETE FROM mentor_pays WHERE uid={?}", $uid); - XDB::execute("DELETE FROM mentor_secteur WHERE uid={?}", $uid); - XDB::execute("DELETE FROM mentor WHERE uid={?}", $uid); - XDB::execute("DELETE FROM perte_pass WHERE uid={?}", $uid); - XDB::execute("DELETE FROM requests WHERE user_id={?}", $uid); - XDB::execute("DELETE FROM user_changes WHERE user_id={?}", $uid); - XDB::execute("DELETE FROM watch_sub WHERE uid={?}", $uid); - - include_once('lists.inc.php'); - if (function_exists(lists_xmlrpc)) { - $client =& lists_xmlrpc(S::v('id'), S::v('password')); - $client->kill($alias, $really_del); + foreach ($tables_to_clear as $key=>&$tables) { + foreach ($tables as $table) { + XDB::execute("DELETE FROM $table WHERE $key={?}", $uid); + } } + + $mmlist = new MMList(S::v('uid'), S::v('password')); + $mmlist->kill($alias, $really_del); } // }}} @@ -71,7 +79,7 @@ function user_clear_all_subs($user_id, $really_del=true) function get_user_login($data, $get_forlife = false) { global $globals, $page; - if (preg_match(',^[0-9]*$,', $data)) { + if (is_numeric($data)) { $res = XDB::query("SELECT alias FROM aliases WHERE type='a_vie' AND id={?}", $data); if ($res->numRows()) { return $res->fetchOneCell(); @@ -91,22 +99,32 @@ function get_user_login($data, $get_forlife = false) { if ($fqdn == $globals->mail->domain || $fqdn == $globals->mail->domain2) { $res = XDB::query("SELECT a.alias - FROM aliases AS a - INNER JOIN aliases AS b ON (a.id = b.id AND b.type IN ('alias', 'a_vie') AND b.alias={?}) - WHERE a.type = 'a_vie'", $mbox); + FROM aliases AS a + INNER JOIN aliases AS b ON (a.id = b.id AND b.type IN ('alias', 'a_vie') AND b.alias={?}) + WHERE a.type = 'a_vie'", $mbox); if ($res->numRows()) { return $get_forlife ? $res->fetchOneCell() : $mbox; - } else { - $page->trig("il n'y a pas d'utilisateur avec ce login"); - return false; } + if (preg_match('/^(.*)\.([0-9]{4})$/', $mbox, $matches)) { + $res = XDB::query("SELECT a.alias + FROM aliases AS a + INNER JOIN aliases AS b ON (a.id = b.id AND b.type IN ('alias', 'a_vie') AND b.alias={?}) + INNER JOIN auth_user_md5 AS u ON (a.id = u.user_id AND promo = {?}) + WHERE a.type = 'a_vie'", $matches[1], $matches[2]); + if ($res->numRows() == 1) { + return $res->fetchOneCell(); + } + } + $page->trig("il n'y a pas d'utilisateur avec ce login"); + return false; + } elseif ($fqdn == $globals->mail->alias_dom || $fqdn == $globals->mail->alias_dom2) { $res = XDB::query("SELECT redirect - FROM virtual_redirect - INNER JOIN virtual USING(vid) - WHERE alias={?}", $mbox.'@'.$globals->mail->alias_dom); + FROM virtual_redirect + INNER JOIN virtual USING(vid) + WHERE alias={?}", $mbox.'@'.$globals->mail->alias_dom); if ($redir = $res->fetchOneCell()) { list($alias) = explode('@', $redir); } else { @@ -150,6 +168,29 @@ function get_user_forlife($data) { } // }}} +// {{{ function get_users_forlife_list() + +function get_users_forlife_list($members, $strict = false) +{ + if (strlen(trim($members)) == 0) { + return null; + } + $members = explode(' ', $members); + if ($members) { + $list = array(); + foreach ($members as $i => $alias) { + if (($login = get_user_forlife($alias)) !== false) { + $list[$i] = $login; + } else if(!$strict) { + $list[$i] = $alias; + } + } + return $list; + } + return null; +} + +// }}} // {{{ function has_user_right() function has_user_right($pub, $view = 'private') { if ($pub == $view) return true; @@ -243,6 +284,8 @@ function get_user_details_pro($uid, $view = 'private') } // }}} +// {{{ function get_user_details_adr() + function get_user_details_adr($uid, $view = 'private') { $sql = "SELECT a.adrid, a.adr1,a.adr2,a.adr3,a.postcode,a.city, gp.pays AS countrytxt,a.region, a.regiontxt, @@ -283,12 +326,14 @@ function get_user_details_adr($uid, $view = 'private') { } return $all_adr; } + +// }}} // {{{ function get_user_details() function &get_user_details($login, $from_uid = '', $view = 'private') { $reqsql = "SELECT u.user_id, u.promo, u.promo_sortie, u.prenom, u.nom, u.nom_usage, u.date, u.cv, - u.perms IN ('admin','user') AS inscrit, FIND_IN_SET('femme', u.flags) AS sexe, u.deces != 0 AS dcd, u.deces, + u.perms IN ('admin','user','disabled') AS inscrit, FIND_IN_SET('femme', u.flags) AS sexe, u.deces != 0 AS dcd, u.deces, q.profile_nick AS nickname, q.profile_from_ax, q.profile_mobile AS mobile, q.profile_web AS web, q.profile_freetext AS freetext, q.profile_mobile_pub AS mobile_pub, q.profile_web_pub AS web_pub, q.profile_freetext_pub AS freetext_pub, q.profile_medals_pub AS medals_pub, @@ -297,8 +342,8 @@ function &get_user_details($login, $from_uid = '', $view = 'private') c.uid IS NOT NULL AS is_contact, s.text AS section, p.x, p.y, p.pub AS photo_pub, u.matricule_ax, - m.expertise != '' AS is_referent - + m.expertise != '' AS is_referent, + COUNT(e.email) > 0 AS actif FROM auth_user_md5 AS u INNER JOIN auth_user_quick AS q USING(user_id) INNER JOIN aliases AS a ON (u.user_id=a.id AND a.type='a_vie') @@ -308,7 +353,9 @@ function &get_user_details($login, $from_uid = '', $view = 'private') INNER JOIN sections AS s ON (s.id = u.section) LEFT JOIN photo AS p ON (p.uid = u.user_id) LEFT JOIN mentor AS m ON (m.uid = u.user_id) - WHERE a.alias = {?}"; + LEFT JOIN emails AS e ON (e.uid = u.user_id AND e.flags='active') + WHERE a.alias = {?} + GROUP BY u.user_id"; $res = XDB::query($reqsql, $from_uid, $login); $user = $res->fetchOneAssoc(); $uid = $user['user_id']; @@ -354,21 +401,23 @@ function &get_user_details($login, $from_uid = '', $view = 'private') $user['binets_join'] = join(', ', $user['binets']); $res = XDB::iterRow("SELECT text, url - FROM groupesx_ins - LEFT JOIN groupesx_def ON groupesx_ins.gid = groupesx_def.id - WHERE guid = {?}", $uid); + FROM groupesx_ins + LEFT JOIN groupesx_def ON groupesx_ins.gid = groupesx_def.id + WHERE guid = {?}", $uid); $user['gpxs'] = Array(); + $user['gpxs_name'] = Array(); while (list($gxt, $gxu) = $res->next()) { $user['gpxs'][] = $gxu ? "$gxt" : $gxt; + $user['gpxs_name'][] = $gxt; } $user['gpxs_join'] = join(', ', $user['gpxs']); } $res = XDB::iterRow("SELECT applis_def.text, applis_def.url, applis_ins.type - FROM applis_ins - INNER JOIN applis_def ON applis_def.id = applis_ins.aid - WHERE uid={?} - ORDER BY ordre", $uid); + FROM applis_ins + INNER JOIN applis_def ON applis_def.id = applis_ins.aid + WHERE uid={?} + ORDER BY ordre", $uid); $user['applis_fmt'] = Array(); $user['formation'] = Array(); @@ -381,10 +430,10 @@ function &get_user_details($login, $from_uid = '', $view = 'private') if (has_user_right($user['medals_pub'], $view)) { $res = XDB::iterator("SELECT m.id, m.text AS medal, m.type, m.img, s.gid, g.text AS grade - FROM profile_medals_sub AS s - INNER JOIN profile_medals AS m ON ( s.mid = m.id ) - LEFT JOIN profile_medals_grades AS g ON ( s.mid = g.mid AND s.gid = g.gid ) - WHERE s.uid = {?}", $uid); + FROM profile_medals_sub AS s + INNER JOIN profile_medals AS m ON ( s.mid = m.id ) + LEFT JOIN profile_medals_grades AS g ON ( s.mid = g.mid AND s.gid = g.gid ) + WHERE s.uid = {?}", $uid); $user['medals'] = Array(); while ($tmp = $res->next()) { $user['medals'][] = $tmp; @@ -660,6 +709,7 @@ function user_reindex($uid) { } // }}} +// {{{ function set_new_usage() function set_new_usage($uid, $usage, $alias=false) { XDB::execute("UPDATE auth_user_md5 set nom_usage={?} WHERE user_id={?}",$usage ,$uid); @@ -677,5 +727,30 @@ function set_new_usage($uid, $usage, $alias=false) { user_reindex($uid); } -// vim:set et sw=4 sts=4 sws=4 foldmethod=marker: +// }}} +// {{{ function get_X_mat +function get_X_mat($ourmat) +{ + if (!preg_match('/^[0-9]{8}$/', $ourmat)) { + // le matricule de notre base doit comporter 8 chiffres + return 0; + } + + $year = intval(substr($ourmat, 0, 4)); + $rang = intval(substr($ourmat, 5, 3)); + if ($year < 1996) { + return; + } elseif ($year < 2000) { + $year = intval(substr(1900 - $year, 1, 3)); + return sprintf('%02u0%03u', $year, $rang); + } else { + $year = intval(substr(1900 - $year, 1, 3)); + return sprintf('%03u%03u', $year, $rang); + } +} + +// }}} + + +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>