From 56637adcd1aeb66a8568f9ff97468036f3a99041 Mon Sep 17 00:00:00 2001 From: Pascal Corpet Date: Fri, 4 Apr 2008 00:31:56 +0200 Subject: [PATCH] fix small error, forgot to create display_name field --- modules/fusionax.php | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/modules/fusionax.php b/modules/fusionax.php index 543f66c..9ff2da0 100644 --- a/modules/fusionax.php +++ b/modules/fusionax.php @@ -345,20 +345,23 @@ class FusionAxModule extends PLModule{ $page->assign('deceasedErrors',$deceasedErrorsSql->fetchOneCell()); $page->assign('deceasedMissingInXorg',XDB::iterator( 'SELECT - d.user_id,d.id_ancien,d.nom,d.prenom,d.promo,d.deces_ax + d.user_id,d.id_ancien,d.nom,d.prenom,d.promo,d.deces_ax, + CONCAT(d.prenom, " ", d.nom) AS display_name FROM fusionax_deceased AS d WHERE d.deces_xorg = "0000-00-00" LIMIT 10')); $page->assign('deceasedMissingInAX',XDB::iterator( 'SELECT - d.user_id,d.id_ancien,d.nom,d.prenom,d.promo,d.deces_xorg + d.user_id,d.id_ancien,d.nom,d.prenom,d.promo,d.deces_xorg, + CONCAT(d.prenom, " ", d.nom) AS display_name FROM fusionax_deceased AD d WHERE d.deces_ax = "0000-00-00" LIMIT 10')); $page->assign('deceasedDifferent',XDB::iterator( 'SELECT d.user_id,d.id_ancien,d.nom,d.prenom,d.promo, - d.deces_ax,d.deces_xorg + d.deces_ax,d.deces_xorg, + CONCAT(d.prenom, " ", d.nom) AS display_name FROM fusionax_deceased AS d WHERE d.deces_xorg != "0000-00-00" AND d.deces_ax != "0000-00-00" LIMIT 10')); -- 2.1.4