Merge pull request #18930 from MegaphoneJon/financial-156
[civicrm-core.git] / CRM / Utils / System / Drupal6.php
1 <?php
2 /*
3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
5 | |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
10 */
11
12 /**
13 *
14 * @package CRM
15 * @copyright CiviCRM LLC https://civicrm.org/licensing
16 */
17
18 /**
19 * Drupal specific stuff goes here.
20 */
21 class CRM_Utils_System_Drupal6 extends CRM_Utils_System_DrupalBase {
22
23 /**
24 * Theme output.
25 *
26 * If we are using a theming system, invoke theme, else just print the content.
27 *
28 * @param string $content
29 * The content that will be themed.
30 * @param bool $print
31 * Are we displaying to the screen or bypassing theming?.
32 * @param bool $maintenance
33 * For maintenance mode.
34 *
35 * @return null|string
36 * prints content on stdout
37 */
38 public function theme(&$content, $print = FALSE, $maintenance = FALSE) {
39 // TODO: Simplify; this was copied verbatim from CiviCRM 3.4's multi-UF theming function, but that's more complex than necessary
40 if (function_exists('theme') && !$print) {
41 if ($maintenance) {
42 drupal_set_breadcrumb('');
43 drupal_maintenance_theme();
44 }
45
46 // Arg 3 for D6 theme() is "show_blocks". Previously, we passed
47 // through a badly named variable ("$args") which was almost always
48 // TRUE (except on fatal error screen). However, this feature is
49 // non-functional on D6 default themes, was purposefully removed from
50 // D7, has no analog in other our other CMS's, and clutters the code.
51 // Hard-wiring to TRUE should be OK.
52 $out = theme('page', $content, TRUE);
53 }
54 else {
55 $out = $content;
56 }
57
58 print $out;
59 return NULL;
60 }
61
62 /**
63 * Create user.
64 *
65 * @inheritDoc
66 */
67 public function createUser(&$params, $mail) {
68 $form_state = [];
69 $form_state['values'] = [
70 'name' => $params['cms_name'],
71 'mail' => $params[$mail],
72 'op' => 'Create new account',
73 ];
74
75 $admin = user_access('administer users');
76 if (!variable_get('user_email_verification', TRUE) || $admin) {
77 $form_state['values']['pass']['pass1'] = $params['cms_pass'];
78 $form_state['values']['pass']['pass2'] = $params['cms_pass'];
79 }
80
81 $config = CRM_Core_Config::singleton();
82
83 // we also need to redirect b
84 $config->inCiviCRM = TRUE;
85
86 $form = drupal_retrieve_form('user_register', $form_state);
87 $form['#post'] = $form_state['values'];
88 drupal_prepare_form('user_register', $form, $form_state);
89
90 // remove the captcha element from the form prior to processing
91 unset($form['captcha']);
92
93 drupal_process_form('user_register', $form, $form_state);
94
95 $config->inCiviCRM = FALSE;
96
97 if (form_get_errors() || !isset($form_state['user'])) {
98 return FALSE;
99 }
100 return $form_state['user']->uid;
101 }
102
103 /**
104 * @inheritDoc
105 */
106 public function updateCMSName($ufID, $ufName) {
107 // CRM-5555
108 if (function_exists('user_load')) {
109 $user = user_load(['uid' => $ufID]);
110 if ($user->mail != $ufName) {
111 user_save($user, ['mail' => $ufName]);
112 $user = user_load(['uid' => $ufID]);
113 }
114 }
115 }
116
117 /**
118 * Check if username and email exists in the drupal db.
119 *
120 * @param array $params
121 * Array of name and mail values.
122 * @param array $errors
123 * Array of errors.
124 * @param string $emailName
125 * Field label for the 'email'.
126 */
127 public function checkUserNameEmailExists(&$params, &$errors, $emailName = 'email') {
128 $config = CRM_Core_Config::singleton();
129
130 $dao = new CRM_Core_DAO();
131 $name = $dao->escape(CRM_Utils_Array::value('name', $params));
132 $email = $dao->escape(CRM_Utils_Array::value('mail', $params));
133 _user_edit_validate(NULL, $params);
134 $errors = form_get_errors();
135 if ($errors) {
136 if (!empty($errors['name'])) {
137 $errors['cms_name'] = $errors['name'];
138 }
139 if (!empty($errors['mail'])) {
140 $errors[$emailName] = $errors['mail'];
141 }
142 // also unset drupal messages to avoid twice display of errors
143 unset($_SESSION['messages']);
144 }
145
146 // Do the name check manually.
147 $nameError = user_validate_name($params['name']);
148 if ($nameError) {
149 $errors['cms_name'] = $nameError;
150 }
151
152 // LOWER in query below roughly translates to 'hurt my database without deriving any benefit' See CRM-19811.
153 $sql = "
154 SELECT name, mail
155 FROM {users}
156 WHERE (LOWER(name) = LOWER('$name')) OR (LOWER(mail) = LOWER('$email'))
157 ";
158
159 $result = db_query($sql);
160 $row = db_fetch_array($result);
161 if (!$row) {
162 return;
163 }
164
165 $user = NULL;
166
167 if (!empty($row)) {
168 $dbName = $row['name'] ?? NULL;
169 $dbEmail = $row['mail'] ?? NULL;
170 if (strtolower($dbName) == strtolower($name)) {
171 $errors['cms_name'] = ts('The username %1 is already taken. Please select another username.',
172 [1 => $name]
173 );
174 }
175 if (strtolower($dbEmail) == strtolower($email)) {
176 if (empty($email)) {
177 $errors[$emailName] = ts('You cannot create an email account for a contact with no email',
178 [1 => $email]
179 );
180 }
181 else {
182 $errors[$emailName] = ts('This email %1 already has an account associated with it. Please select another email.',
183 [1 => $email]
184 );
185 }
186 }
187 }
188 }
189
190 /**
191 * @inheritDoc
192 */
193 public function setTitle($title, $pageTitle = NULL) {
194 if (!$pageTitle) {
195 $pageTitle = $title;
196 }
197 if (arg(0) == 'civicrm') {
198 //set drupal title
199 drupal_set_title($pageTitle);
200 }
201 }
202
203 /**
204 * @inheritDoc
205 */
206 public function appendBreadCrumb($breadCrumbs) {
207 $breadCrumb = drupal_get_breadcrumb();
208
209 if (is_array($breadCrumbs)) {
210 foreach ($breadCrumbs as $crumbs) {
211 if (stripos($crumbs['url'], 'id%%')) {
212 $args = ['cid', 'mid'];
213 foreach ($args as $a) {
214 $val = CRM_Utils_Request::retrieve($a, 'Positive', CRM_Core_DAO::$_nullObject,
215 FALSE, NULL, $_GET
216 );
217 if ($val) {
218 $crumbs['url'] = str_ireplace("%%{$a}%%", $val, $crumbs['url']);
219 }
220 }
221 }
222 $breadCrumb[] = "<a href=\"{$crumbs['url']}\">{$crumbs['title']}</a>";
223 }
224 }
225 drupal_set_breadcrumb($breadCrumb);
226 }
227
228 /**
229 * @inheritDoc
230 */
231 public function resetBreadCrumb() {
232 $bc = [];
233 drupal_set_breadcrumb($bc);
234 }
235
236 /**
237 * Append a string to the head of the html file.
238 *
239 * @param string $head
240 * The new string to be appended.
241 */
242 public function addHTMLHead($head) {
243 drupal_set_html_head($head);
244 }
245
246 /**
247 * Add a css file.
248 *
249 * @param $url : string, absolute path to file
250 * @param string $region
251 * location within the document: 'html-header', 'page-header', 'page-footer'.
252 *
253 * Note: This function is not to be called directly
254 * @see CRM_Core_Region::render()
255 *
256 * @return bool
257 * TRUE if we support this operation in this CMS, FALSE otherwise
258 */
259 public function addStyleUrl($url, $region) {
260 if ($region != 'html-header' || !$this->formatResourceUrl($url)) {
261 return FALSE;
262 }
263 drupal_add_css($url);
264 return TRUE;
265 }
266
267 /**
268 * @inheritDoc
269 */
270 public function mapConfigToSSL() {
271 global $base_url;
272 $base_url = str_replace('http://', 'https://', $base_url);
273 }
274
275 /**
276 * Get the name of the table that stores the user details.
277 *
278 * @return string
279 */
280 protected function getUsersTableName() {
281 $userFrameworkUsersTableName = Civi::settings()->get('userFrameworkUsersTableName');
282 if (empty($userFrameworkUsersTableName)) {
283 $userFrameworkUsersTableName = 'users';
284 }
285 return $userFrameworkUsersTableName;
286 }
287
288 /**
289 * @inheritDoc
290 */
291 public function authenticate($name, $password, $loadCMSBootstrap = FALSE, $realPath = NULL) {
292 //@todo this 'PEAR-y' stuff is only required when bookstrap is not being loaded which is rare
293 // if ever now.
294 // probably if bootstrap is loaded this call
295 // CRM_Utils_System::loadBootStrap($bootStrapParams, TRUE, TRUE, $realPath); would be
296 // sufficient to do what this fn does. It does exist as opposed to return which might need some hanky-panky to make
297 // safe in the unknown situation where authenticate might be called & it is important that
298 // false is returned
299 require_once 'DB.php';
300
301 $config = CRM_Core_Config::singleton();
302
303 $ufDSN = CRM_Utils_SQL::autoSwitchDSN($config->userFrameworkDSN);
304 $dbDrupal = DB::connect($ufDSN);
305 if (DB::isError($dbDrupal)) {
306 throw new CRM_Core_Exception("Cannot connect to drupal db via $ufDSN, " . $dbDrupal->getMessage());
307 }
308
309 $strtolower = function_exists('mb_strtolower') ? 'mb_strtolower' : 'strtolower';
310 $dbpassword = md5($password);
311 $name = $dbDrupal->escapeSimple($strtolower($name));
312 $userFrameworkUsersTableName = $this->getUsersTableName();
313 $sql = 'SELECT u.* FROM ' . $userFrameworkUsersTableName . " u WHERE LOWER(u.name) = '$name' AND u.pass = '$dbpassword' AND u.status = 1";
314 $query = $dbDrupal->query($sql);
315
316 $user = NULL;
317 // need to change this to make sure we matched only one row
318 while ($row = $query->fetchRow(DB_FETCHMODE_ASSOC)) {
319 CRM_Core_BAO_UFMatch::synchronizeUFMatch($user, $row['uid'], $row['mail'], 'Drupal');
320 $contactID = CRM_Core_BAO_UFMatch::getContactId($row['uid']);
321 if (!$contactID) {
322 return FALSE;
323 }
324 else {
325 //success
326 if ($loadCMSBootstrap) {
327 $bootStrapParams = [];
328 if ($name && $password) {
329 $bootStrapParams = [
330 'name' => $name,
331 'pass' => $password,
332 ];
333 }
334 CRM_Utils_System::loadBootStrap($bootStrapParams, TRUE, TRUE, $realPath);
335 }
336 return [$contactID, $row['uid'], mt_rand()];
337 }
338 }
339 return FALSE;
340 }
341
342 /**
343 * @inheritDoc
344 */
345 public function loadUser($username) {
346 global $user;
347 $user = user_load(['name' => $username]);
348 if (empty($user->uid)) {
349 return FALSE;
350 }
351
352 $uid = $user->uid;
353 $contact_id = CRM_Core_BAO_UFMatch::getContactId($uid);
354
355 // lets store contact id and user id in session
356 $session = CRM_Core_Session::singleton();
357 $session->set('ufID', $uid);
358 $session->set('userID', $contact_id);
359 return TRUE;
360 }
361
362 /**
363 * Perform any post login activities required by the UF -
364 * e.g. for drupal : records a watchdog message about the new session,
365 * saves the login timestamp, calls hook_user op 'login' and generates a new session.
366 *
367 * @param array $params
368 *
369 * FIXME: Document values accepted/required by $params
370 */
371 public function userLoginFinalize($params = []) {
372 user_authenticate_finalize($params);
373 }
374
375 /**
376 * Determine the native ID of the CMS user.
377 *
378 * @param string $username
379 * @return int|null
380 */
381 public function getUfId($username) {
382 $user = user_load(['name' => $username]);
383 if (empty($user->uid)) {
384 return NULL;
385 }
386 return $user->uid;
387 }
388
389 /**
390 * @inheritDoc
391 */
392 public function logout() {
393 module_load_include('inc', 'user', 'user.pages');
394 return user_logout();
395 }
396
397 /**
398 * Load drupal bootstrap.
399 *
400 * @param array $params
401 * Either uid, or name & pass.
402 * @param bool $loadUser
403 * Boolean Require CMS user load.
404 * @param bool $throwError
405 * If true, print error on failure and exit.
406 * @param bool|string $realPath path to script
407 *
408 * @return bool
409 */
410 public function loadBootStrap($params = [], $loadUser = TRUE, $throwError = TRUE, $realPath = NULL) {
411 //take the cms root path.
412 $cmsPath = $this->cmsRootPath($realPath);
413
414 if (!file_exists("$cmsPath/includes/bootstrap.inc")) {
415 if ($throwError) {
416 echo '<br />Sorry, could not locate bootstrap.inc\n';
417 exit();
418 }
419 return FALSE;
420 }
421 // load drupal bootstrap
422 chdir($cmsPath);
423 define('DRUPAL_ROOT', $cmsPath);
424
425 // For drupal multi-site CRM-11313
426 if ($realPath && strpos($realPath, 'sites/all/modules/') === FALSE) {
427 preg_match('@sites/([^/]*)/modules@s', $realPath, $matches);
428 if (!empty($matches[1])) {
429 $_SERVER['HTTP_HOST'] = $matches[1];
430 }
431 }
432 require_once 'includes/bootstrap.inc';
433 // @ to suppress notices eg 'DRUPALFOO already defined'.
434 @drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
435
436 // explicitly setting error reporting, since we cannot handle drupal related notices
437 error_reporting(1);
438 if (!function_exists('module_exists') || !module_exists('civicrm')) {
439 if ($throwError) {
440 echo '<br />Sorry, could not load drupal bootstrap.';
441 exit();
442 }
443 return FALSE;
444 }
445
446 // seems like we've bootstrapped drupal
447 $config = CRM_Core_Config::singleton();
448
449 // lets also fix the clean url setting
450 // CRM-6948
451 $config->cleanURL = (int) variable_get('clean_url', '0');
452
453 // we need to call the config hook again, since we now know
454 // all the modules that are listening on it, does not apply
455 // to J! and WP as yet
456 // CRM-8655
457 CRM_Utils_Hook::config($config);
458
459 if (!$loadUser) {
460 return TRUE;
461 }
462 global $user;
463 // If $uid is passed in, authentication has been done already.
464 $uid = $params['uid'] ?? NULL;
465 if (!$uid) {
466 //load user, we need to check drupal permissions.
467 $name = CRM_Utils_Array::value('name', $params, FALSE) ? $params['name'] : trim(CRM_Utils_Array::value('name', $_REQUEST));
468 $pass = CRM_Utils_Array::value('pass', $params, FALSE) ? $params['pass'] : trim(CRM_Utils_Array::value('pass', $_REQUEST));
469
470 if ($name) {
471 $user = user_authenticate(['name' => $name, 'pass' => $pass]);
472 if (!$user->uid) {
473 if ($throwError) {
474 echo '<br />Sorry, unrecognized username or password.';
475 exit();
476 }
477 return FALSE;
478 }
479 else {
480 return TRUE;
481 }
482 }
483 }
484
485 if ($uid) {
486 $account = user_load($uid);
487 if ($account && $account->uid) {
488 $user = $account;
489 return TRUE;
490 }
491 }
492
493 if ($throwError) {
494 echo '<br />Sorry, can not load CMS user account.';
495 exit();
496 }
497
498 // CRM-6948: When using loadBootStrap, it's implicit that CiviCRM has already loaded its settings
499 // which means that define(CIVICRM_CLEANURL) was correctly set.
500 // So we correct it
501 $config = CRM_Core_Config::singleton();
502 $config->cleanURL = (int) variable_get('clean_url', '0');
503
504 // CRM-8655: Drupal wasn't available during bootstrap, so hook_civicrm_config never executes
505 CRM_Utils_Hook::config($config);
506
507 return FALSE;
508 }
509
510 /**
511 * Get CMS root path.
512 *
513 * @param string $scriptFilename
514 *
515 * @return null|string
516 */
517 public function cmsRootPath($scriptFilename = NULL) {
518 $cmsRoot = $valid = NULL;
519
520 if (!is_null($scriptFilename)) {
521 $path = $scriptFilename;
522 }
523 else {
524 $path = $_SERVER['SCRIPT_FILENAME'];
525 }
526
527 if (function_exists('drush_get_context')) {
528 // drush anyway takes care of multisite install etc
529 return drush_get_context('DRUSH_DRUPAL_ROOT');
530 }
531
532 global $civicrm_paths;
533 if (!empty($civicrm_paths['cms.root']['path'])) {
534 return $civicrm_paths['cms.root']['path'];
535 }
536
537 // CRM-7582
538 $pathVars = explode('/',
539 str_replace('//', '/',
540 str_replace('\\', '/', $path)
541 )
542 );
543
544 //lets store first var,
545 //need to get back for windows.
546 $firstVar = array_shift($pathVars);
547
548 //lets remove sript name to reduce one iteration.
549 array_pop($pathVars);
550
551 //CRM-7429 --do check for upper most 'includes' dir,
552 //which would effectually work for multisite installation.
553 do {
554 $cmsRoot = $firstVar . '/' . implode('/', $pathVars);
555 $cmsIncludePath = "$cmsRoot/includes";
556 // Stop if we found bootstrap.
557 if (file_exists("$cmsIncludePath/bootstrap.inc")) {
558 $valid = TRUE;
559 break;
560 }
561 //remove one directory level.
562 array_pop($pathVars);
563 } while (count($pathVars));
564
565 return ($valid) ? $cmsRoot : NULL;
566 }
567
568 /**
569 * @inheritDoc
570 */
571 public function isUserLoggedIn() {
572 $isloggedIn = FALSE;
573 if (function_exists('user_is_logged_in')) {
574 $isloggedIn = user_is_logged_in();
575 }
576
577 return $isloggedIn;
578 }
579
580 /**
581 * @inheritDoc
582 */
583 public function getLoggedInUfID() {
584 $ufID = NULL;
585 if (function_exists('user_is_logged_in') &&
586 user_is_logged_in() &&
587 function_exists('user_uid_optional_to_arg')
588 ) {
589 $ufID = user_uid_optional_to_arg([]);
590 }
591
592 return $ufID;
593 }
594
595 /**
596 * @inheritDoc
597 */
598 public function languageNegotiationURL($url, $addLanguagePart = TRUE, $removeLanguagePart = FALSE) {
599 if (empty($url)) {
600 return $url;
601 }
602
603 //up to d6 only, already we have code in place for d7
604 $config = CRM_Core_Config::singleton();
605 if (function_exists('variable_get') &&
606 module_exists('locale')
607 ) {
608 global $language;
609
610 //get the mode.
611 $mode = variable_get('language_negotiation', LANGUAGE_NEGOTIATION_NONE);
612
613 //url prefix / path.
614 if (isset($language->prefix) &&
615 $language->prefix &&
616 in_array($mode, [
617 LANGUAGE_NEGOTIATION_PATH,
618 LANGUAGE_NEGOTIATION_PATH_DEFAULT,
619 ])
620 ) {
621
622 if ($addLanguagePart) {
623 $url .= $language->prefix . '/';
624 }
625 if ($removeLanguagePart) {
626 $url = str_replace("/{$language->prefix}/", '/', $url);
627 }
628 }
629 if (isset($language->domain) &&
630 $language->domain &&
631 $mode == LANGUAGE_NEGOTIATION_DOMAIN
632 ) {
633
634 if ($addLanguagePart) {
635 $url = CRM_Utils_File::addTrailingSlash($language->domain, '/');
636 }
637 if ($removeLanguagePart && defined('CIVICRM_UF_BASEURL')) {
638 $url = str_replace('\\', '/', $url);
639 $parseUrl = parse_url($url);
640
641 //kinda hackish but not sure how to do it right
642 //hope http_build_url() will help at some point.
643 if (is_array($parseUrl) && !empty($parseUrl)) {
644 $urlParts = explode('/', $url);
645 $hostKey = array_search($parseUrl['host'], $urlParts);
646 $ufUrlParts = parse_url(CIVICRM_UF_BASEURL);
647 $urlParts[$hostKey] = $ufUrlParts['host'];
648 $url = implode('/', $urlParts);
649 }
650 }
651 }
652 }
653
654 return $url;
655 }
656
657 /**
658 * Find any users/roles/security-principals with the given permission
659 * and replace it with one or more permissions.
660 *
661 * @param string $oldPerm
662 * @param array $newPerms
663 * Array, strings.
664 */
665 public function replacePermission($oldPerm, $newPerms) {
666 $roles = user_roles(FALSE, $oldPerm);
667 foreach ($roles as $rid => $roleName) {
668 $permList = db_result(db_query('SELECT perm FROM {permission} WHERE rid = %d', $rid));
669 $perms = drupal_map_assoc(explode(', ', $permList));
670 unset($perms[$oldPerm]);
671 $perms = $perms + drupal_map_assoc($newPerms);
672 $permList = implode(', ', $perms);
673 db_query('UPDATE {permission} SET perm = "%s" WHERE rid = %d', $permList, $rid);
674 /* @codingStandardsIgnoreStart
675 if ( ! empty( $roles ) ) {
676 $rids = implode(',', array_keys($roles));
677 db_query( 'UPDATE {permission} SET perm = CONCAT( perm, \', edit all events\') WHERE rid IN (' . implode(',', array_keys($roles)) . ')' );
678 db_query( "UPDATE {permission} SET perm = REPLACE( perm, '%s', '%s' ) WHERE rid IN ($rids)",
679 $oldPerm, implode(', ', $newPerms) );
680 @codingStandardsIgnoreEnd */
681 }
682 }
683
684 /**
685 * @inheritDoc
686 */
687 public function getModules() {
688 $result = [];
689 $q = db_query('SELECT name, status FROM {system} WHERE type = \'module\' AND schema_version <> -1');
690 while ($row = db_fetch_object($q)) {
691 $result[] = new CRM_Core_Module('drupal.' . $row->name, $row->status == 1);
692 }
693 return $result;
694 }
695
696 /**
697 * @inheritDoc
698 */
699 public function getLoginURL($destination = '') {
700 $config = CRM_Core_Config::singleton();
701 $loginURL = $config->userFrameworkBaseURL;
702 $loginURL .= 'user';
703 if (!empty($destination)) {
704 // append destination so user is returned to form they came from after login
705 $loginURL .= '?destination=' . urlencode($destination);
706 }
707 return $loginURL;
708 }
709
710 /**
711 * Wrapper for og_membership creation.
712 *
713 * @param int $ogID
714 * Organic Group ID.
715 * @param int $drupalID
716 * Drupal User ID.
717 */
718 public function og_membership_create($ogID, $drupalID) {
719 og_save_subscription($ogID, $drupalID, ['is_active' => 1]);
720 }
721
722 /**
723 * Wrapper for og_membership deletion.
724 *
725 * @param int $ogID
726 * Organic Group ID.
727 * @param int $drupalID
728 * Drupal User ID.
729 */
730 public function og_membership_delete($ogID, $drupalID) {
731 og_delete_subscription($ogID, $drupalID);
732 }
733
734 /**
735 * @inheritDoc
736 */
737 public function getTimeZoneString() {
738 global $user;
739 // Note that 0 is a valid timezone (GMT) so we use strlen not empty to check.
740 if (variable_get('configurable_timezones', 1) && $user->uid && isset($user->timezone) && strlen($user->timezone)) {
741 $timezone = $user->timezone;
742 }
743 else {
744 $timezone = variable_get('date_default_timezone', NULL);
745 }
746
747 // Retrieved timezone will be represented as GMT offset in seconds but, according
748 // to the doc for the overridden method, ought to be returned as a region string
749 // (e.g., America/Havana).
750 if (strlen($timezone)) {
751 $timezone = timezone_name_from_abbr("", (int) $timezone);
752 }
753
754 if (!$timezone) {
755 $timezone = parent::getTimeZoneString();
756 }
757
758 return $timezone;
759 }
760
761 /**
762 * @inheritDoc
763 */
764 public function setHttpHeader($name, $value) {
765 drupal_set_header("$name: $value");
766 }
767
768 /**
769 * @inheritDoc
770 */
771 public function synchronizeUsers() {
772 $config = CRM_Core_Config::singleton();
773 if (PHP_SAPI != 'cli') {
774 set_time_limit(300);
775 }
776 $rows = [];
777 $id = 'uid';
778 $mail = 'mail';
779 $name = 'name';
780
781 $result = db_query("SELECT uid, mail, name FROM {users} where mail != ''");
782
783 while ($row = db_fetch_array($result)) {
784 $rows[] = $row;
785 }
786
787 $user = new StdClass();
788 $uf = $config->userFramework;
789 $contactCount = 0;
790 $contactCreated = 0;
791 $contactMatching = 0;
792 foreach ($rows as $row) {
793 $user->$id = $row[$id];
794 $user->$mail = $row[$mail];
795 $user->$name = $row[$name];
796 $contactCount++;
797 if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($user, $row[$id], $row[$mail], $uf, 1, 'Individual', TRUE)) {
798 $contactCreated++;
799 }
800 else {
801 $contactMatching++;
802 }
803 }
804
805 return [
806 'contactCount' => $contactCount,
807 'contactMatching' => $contactMatching,
808 'contactCreated' => $contactCreated,
809 ];
810 }
811
812 }