/** * get admins email * * @return array * * @author Dimitri Lameri <*****@*****.**> */ private function _getAdminsMail() { $ArAdmins = array(); $DB = new DBHandler(); $StSQL = ' SELECT US.StEmail AS StEmail FROM ' . DBPREFIX . 'User US LEFT JOIN ' . DBPREFIX . 'Supporter S ON (US.IDUser = S.IDUser) LEFT JOIN ' . DBPREFIX . 'Unit UN ON (UN.IDUnit = S.IDUnit) WHERE UN.BoMailError = true'; $DB->execSQL($StSQL); $Admins = $DB->getResult('string'); foreach ((array) $Admins as $Admin) { $ArAdmins[] = $Admin['StEmail']; } return $ArAdmins; }
/** * get user data, handling importation, after being included * * @param int $IDUser */ public function getUserData($IDUser) { global $UserFields; $UserDB = new DBHandler(true); $StFields = implode(', ', $UserFields); if (ISEXTERNAL == 0) { $StSQL = "\nSELECT\n {$StFields}\nFROM\n " . DBPREFIX . "User\nWHERE\n IDUser = '******'"; $UserDB->execSQL($StSQL); $ArUser = $UserDB->getResult("string"); } else { $StSQL = "\nSELECT\n IDExternalUser\nFROM\n " . DBPREFIX . "User\nWHERE\n IDUser = '******'"; $UserDB->execSQL($StSQL); $ArExternalUser = $UserDB->getResult("string"); $IDExternalUser = $ArExternalUser[0]['IDExternalUser']; $StSQL = "\nSELECT\n {$StFields}\nFROM\n " . USERDBTABLE . "\nWHERE\n {$UserFields['IDExternalUser']} = '{$IDExternalUser}'"; $UserDB->execSQL($StSQL); $ArUser = $UserDB->getResult("string"); } if (count($ArUser) <= 0) { throw new ErrorHandler(EXC_USER_WRONGUSER); } return $ArUser[0]; }