projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
aliases.id => aliases.uid
[platal.git]
/
bin
/
cron
/
rapports_inscription.php
diff --git
a/bin/cron/rapports_inscription.php
b/bin/cron/rapports_inscription.php
index
b7e9167
..
4059445
100755
(executable)
--- a/
bin/cron/rapports_inscription.php
+++ b/
bin/cron/rapports_inscription.php
@@
-8,7
+8,7
@@
$MESSAGE = '';
$res = XDB::iterRow(
"SELECT a.alias, u.promo, email
FROM auth_user_md5 AS u
$res = XDB::iterRow(
"SELECT a.alias, u.promo, email
FROM auth_user_md5 AS u
- LEFT JOIN aliases AS a ON( u.user_id=a.id AND a.type='a_vie' )
+ LEFT JOIN aliases AS a ON( u.user_id=a.
u
id AND a.type='a_vie' )
LEFT JOIN emails AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
WHERE u.date_ins > {?}
GROUP BY alias
LEFT JOIN emails AS e ON( e.uid = u.user_id AND NOT FIND_IN_SET('filter',e.flags) )
WHERE u.date_ins > {?}
GROUP BY alias