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(Session::getInt('id'), Session::get('password'));
- $client->kill($alias, $really_del);
- }
+
+ $mmlist = new MMList(S::v('id'), S::v('password'));
+ $mmlist->kill($alias, $really_del);
}
// }}}
return $res->fetchOneCell();
default:
- if (has_perms()) {
+ if (S::has_perms()) {
$aliases = $res->fetchColumn();
$page->trig("Il y a $i utilisateurs avec cette adresse mail : ".join(', ', $aliases));
} else {
}
// }}}
+// {{{ 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;
function get_user_details_pro($uid, $view = 'private')
{
- global $globals;
$sql = "SELECT e.entreprise, s.label as secteur , ss.label as sous_secteur , f.fonction_fr as fonction,
e.poste, e.adr1, e.adr2, e.adr3, e.postcode, e.city, e.entrid,
gp.pays AS countrytxt, gr.name AS region, e.tel, e.fax, e.mobile, e.entrid,
// }}}
function get_user_details_adr($uid, $view = 'private') {
- global $globals;
$sql = "SELECT a.adrid, a.adr1,a.adr2,a.adr3,a.postcode,a.city,
gp.pays AS countrytxt,a.region, a.regiontxt,
FIND_IN_SET('active', a.statut) AS active, a.adrid,
function &get_user_details($login, $from_uid = '', $view = 'private')
{
- global $globals;
$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,
q.profile_nick AS nickname, q.profile_from_ax, q.profile_mobile AS mobile, q.profile_web AS web, q.profile_freetext AS freetext,
// }}}
// {{{ function add_user_address()
function add_user_address($uid, $adrid, $adr) {
- global $globals;
XDB::execute(
"INSERT INTO adresses (`uid`, `adrid`, `adr1`, `adr2`, `adr3`, `postcode`, `city`, `country`, `datemaj`, `pub`) (
SELECT u.user_id, {?}, {?}, {?}, {?}, {?}, {?}, gp.a2, NOW(), {?}
// }}}
// {{{ function update_user_address()
function update_user_address($uid, $adrid, $adr) {
- global $globals;
// update address
XDB::execute(
"UPDATE adresses AS a LEFT JOIN geoloc_pays AS gp ON (gp.pays = {?})
// }}}
// {{{ function remove_user_address()
function remove_user_address($uid, $adrid) {
- global $globals;
XDB::execute("DELETE FROM adresses WHERE adrid = {?} AND uid = {?}", $adrid, $uid);
XDB::execute("DELETE FROM tels WHERE adrid = {?} AND uid = {?}", $adrid, $uid);
}
// }}}
// {{{ function add_user_tel()
function add_user_tel($uid, $adrid, $telid, $tel) {
- global $globals;
XDB::execute(
"INSERT INTO tels SET uid = {?}, adrid = {?}, telid = {?}, tel = {?}, tel_type = {?}, tel_pub = {?}",
$uid, $adrid, $telid, $tel['tel'], $tel['tel_type'], $tel['tel_pub']);
// }}}
// {{{ function update_user_tel()
function update_user_tel($uid, $adrid, $telid, $tel) {
- global $globals;
XDB::execute(
"UPDATE tels SET tel = {?}, tel_type = {?}, tel_pub = {?}
WHERE telid = {?} AND adrid = {?} AND uid = {?}",
// }}}
// {{{ function remove_user_tel()
function remove_user_tel($uid, $adrid, $telid) {
- global $globals;
- XDB::execute("DELETE FROM tels WHERE telid = {?} AND adrid = {?} AND uid = {?}", $telid, $adrid, $uid);
+ XDB::execute("DELETE FROM tels WHERE telid = {?} AND adrid = {?} AND uid = {?}",
+ $telid, $adrid, $uid);
}
// }}}
// {{{ function add_user_pro()
function add_user_pro($uid, $entrid, $pro) {
- global $globals;
XDB::execute(
"INSERT INTO entreprises (`uid`, `entrid`, `entreprise`, `poste`, `secteur`, `ss_secteur`, `fonction`,
`adr1`, `adr2`, `adr3`, `postcode`, `city`, `country`, `region`, `tel`, `fax`, `mobile`, `email`, `web`, `pub`, `adr_pub`, `tel_pub`, `email_pub`)
// }}}
// {{{ function update_user_pro()
function update_user_pro($uid, $entrid, $pro) {
- global $globals;
$join = "";
$set = "";
$args_join = array();
$query = "UPDATE entreprises AS e ".$join." SET ".substr($set,1)." WHERE e.uid = {?} AND e.entrid = {?}";
$args_where = array($uid, $entrid);
$args = array_merge(array($query), $args_join, $args_set, $args_where);
- $globals->db->query(XDB::_prepare($args));
+ call_user_func_array(array('XDB', 'execute'), $args);
}
// }}}
// {{{ function remove_user_pro()
function remove_user_pro($uid, $entrid) {
- global $globals;
XDB::execute("DELETE FROM entreprises WHERE entrid = {?} AND uid = {?}", $entrid, $uid);
}
// }}}
// {{{ function set_user_details()
function set_user_details_addresses($uid, $adrs) {
- global $globals;
$res = XDB::query("SELECT adrid FROM adresses WHERE uid = {?} AND adrid >= 1 ORDER BY adrid", $uid);
$adrids = $res->fetchColumn();
foreach ($adrs as $adr) {
function set_user_details_pro($uid, $pros)
{
- global $globals;
$res = XDB::query("SELECT entrid FROM entreprises WHERE uid = {?} ORDER BY entrid", $uid);
$entrids = $res->fetchColumn();
foreach ($pros as $pro) {
// }}}
// {{{ function set_user_details()
function set_user_details($uid, $details) {
- global $globals;
if (isset($details['nom_usage'])) {
XDB::execute("UPDATE auth_user_md5 SET nom_usage = {?} WHERE user_id = {?}", strtoupper($details['nom_usage']), $uid);
}
// {{{ function _user_reindex
function _user_reindex($uid, $keys, $muls) {
- global $globals;
foreach ($keys as $i => $key) {
if ($key == '') {
continue;
// {{{ function user_reindex
function user_reindex($uid) {
- global $globals;
XDB::execute("DELETE FROM search_name WHERE uid={?}", $uid);
$res = XDB::query("SELECT prenom, nom, nom_usage, profile_nick FROM auth_user_md5 INNER JOIN auth_user_quick USING(user_id) WHERE auth_user_md5.user_id = {?}", $uid);
_user_reindex($uid, $res->fetchOneRow(), array(1,1,1,0.2));
}
// }}}
+
+function set_new_usage($uid, $usage, $alias=false) {
+ XDB::execute("UPDATE auth_user_md5 set nom_usage={?} WHERE user_id={?}",$usage ,$uid);
+ XDB::execute("DELETE FROM aliases WHERE FIND_IN_SET('usage',flags) AND id={?}", $uid);
+ if ($alias && $usage) {
+ XDB::execute("UPDATE aliases SET flags=flags & 255-1 WHERE id={?}", $uid);
+ XDB::execute("INSERT INTO aliases VALUES({?}, 'alias', 'usage,bestalias', {?}, null)",
+ $alias, $uid);
+ }
+ $r = XDB::query("SELECT alias FROM aliases WHERE FIND_IN_SET('bestalias', flags) AND id = {?}", $uid);
+ if ($r->fetchOneCell() == "") {
+ XDB::execute("UPDATE aliases SET flags = 1 | flags WHERE id = {?} LIMIT 1", $uid);
+ }
+ require_once 'user.func.inc.php';
+ user_reindex($uid);
+}
+
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker:
?>