/** * If table key (id) is NULL : inserts new rows * otherwise updates existing row in the database tables * * Can be overridden or overloaded by the child classes * * @param boolean $updateNulls TRUE: null object variables are also updated, FALSE: not. * @return boolean TRUE if successful otherwise FALSE */ function store($updateNulls = false) { global $_CB_framework, $_CB_database, $ueConfig; $this->id = (int) $this->id; if (checkJversion() == 2) { $this->gids = is_array($this->gids) ? $this->gids : array($this->gid); $this->gid = (int) $_CB_framework->acl->getBackwardsCompatibleGid($this->gids); } else { $this->gid = (int) $this->gid; $this->gids = array($this->gid); } $isNew = $this->id == 0; $oldUsername = null; $oldGid = null; $oldGids = array(); $oldBlock = null; if (!$isNew) { // get actual username to update sessions in case: $sql = 'SELECT ' . $_CB_database->NameQuote($this->_cmsUserTableUsername) . (checkJversion() < 2 ? ', ' . $_CB_database->NameQuote($this->_cmsUserTableGid) : null) . ', ' . $_CB_database->NameQuote('block') . ' FROM ' . $_CB_database->NameQuote($this->_cmsUserTable) . ' WHERE ' . $_CB_database->NameQuote($this->_cmsUserTableKey) . ' = ' . (int) $this->user_id; $_CB_database->setQuery($sql); $oldEntry = null; if ($_CB_database->loadObject($oldEntry)) { $oldUsername = $oldEntry->username; if (checkJversion() == 2) { $gids = array_values((array) JFactory::getAcl()->getGroupsByUser($this->id, false)); foreach ($gids as $k => $v) { $gids[$k] = (string) $v; } $oldGids = $gids; $oldGid = (int) $_CB_framework->acl->getBackwardsCompatibleGid($oldGids); } else { $oldGid = (int) $oldEntry->gid; $oldGids = array($oldEntry->gid); } $oldBlock = $oldEntry->block; } } // insure usertype is in sync with gid: /* * This could be a better method: if ( checkJversion() == 1 ) { $gdataArray = $_CB_framework->acl->get_group_data( (int) $this->gid, 'ARO' ); if ( $gdataArray ) { $this->usertype = $gdataArray[3]; } else { user_error( sprintf( 'comprofilerUser::store: gacl:get_group_data: for user_id %d, name of group_id %d not found in acl groups table.', $this->id, $this->gid ), E_USER_WARNING ); $this->usertype = 'Registered'; } } else { $this->usertype = $_CB_framework->acl->get_group_name( (int) $gid, 'ARO' ); } */ if (checkJversion() == 2) { $this->usertype = null; } else { if (checkJversion() == 1) { $query = 'SELECT name' . "\n FROM #__core_acl_aro_groups" . "\n WHERE id = " . (int) $this->gid; } else { $query = 'SELECT name' . "\n FROM #__core_acl_aro_groups" . "\n WHERE group_id = " . (int) $this->gid; } $_CB_database->setQuery($query); $this->usertype = $_CB_database->loadResult(); } if (!$isNew && $this->confirmed == 0 && $this->cbactivation == '' && $ueConfig['reg_confirmation'] != 0) { $this->_setActivationCode(); } // creates CMS and CB objects: $this->_mapUsers(); // remove the previous email set in bindSafely() and needed for checkSafely(): unset($this->_original_email); // stores first into CMS to get id of user if new: if (is_callable(array($this->_cmsUser, 'store'))) { $result = $this->_cmsUser->store($updateNulls); if (!$result) { $this->_error = $this->_cmsUser->getError(); } } else { if (checkJversion() == 2) { $this->_cmsUser->groups = $this->gids; } $result = $this->_cmsUser->save(); // Joomla 1.5 native if (!$result) { $this->_error = $this->_cmsUser->getError(); if (class_exists('JText')) { $this->_error = JText::_($this->_error); } } } if ($result) { // synchronize id and user_id: if ($isNew) { if ($this->_cmsUser->id == 0) { // this is only for mambo 4.5.0 backwards compatibility. 4.5.2.3 $row->store() updates id on insert $sql = 'SELECT ' . $_CB_database->NameQuote($this->_cmsUserTableKey) . ' FROM ' . $_CB_database->NameQuote($this->_cmsUserTable) . ' WHERE ' . $_CB_database->NameQuote($this->_cmsUserTableUsername) . ' = ' . $_CB_database->Quote($this->username); $_CB_database->setQuery($sql); $this->_cmsUser->id = (int) $_CB_database->loadResult(); } $this->id = $this->_cmsUser->id; $this->_comprofilerUser->id = $this->_cmsUser->id; if ($this->confirmed == 0 && $this->cbactivation == '' && $ueConfig['reg_confirmation'] != 0) { $this->_setActivationCode(); } } // stores CB user into comprofiler: if new, inserts, otherwise updates: if ($this->user_id == 0) { $this->user_id = $this->_cmsUser->id; $this->_comprofilerUser->user_id = $this->user_id; $result = $this->_comprofilerUser->storeNew($updateNulls); } else { $result = $this->_comprofilerUser->store($updateNulls); } if (!$result) { $this->_error = $this->_comprofilerUser->getError(); } } if ($result) { // update the ACL: if (checkJversion() == 2) { $query = 'SELECT m.id AS aro_id, a.group_id FROM #__user_usergroup_map AS a' . "\n INNER JOIN #__usergroups AS m ON m.id= a.group_id" . "\n WHERE a.user_id = " . (int) $this->id; } elseif (checkJversion() == 1) { $query = 'SELECT a.id AS aro_id, m.group_id FROM #__core_acl_aro AS a' . "\n INNER JOIN #__core_acl_groups_aro_map AS m ON m.aro_id = a.id" . "\n WHERE a.value = " . $_CB_database->Quote((int) $this->id); } else { $query = 'SELECT a.aro_id, m.group_id FROM #__core_acl_aro AS a' . "\n INNER JOIN #__core_acl_groups_aro_map AS m ON m.aro_id = a.aro_id" . "\n WHERE a.value = " . $_CB_database->Quote((int) $this->id); } $_CB_database->setQuery($query); $aro_group = null; $result = $_CB_database->loadObject($aro_group); if ($result && $aro_group->group_id != $this->gid) { if (checkJversion() == 2) { // $query = 'UPDATE #__user_usergroup_map' // . "\n SET group_id = " . (int) $this->gid // . "\n WHERE user_id = " . (int) $this->id // . ( $oldGid ? "\n AND group_id = " . (int) $oldGid : null ) // ; // $_CB_database->setQuery( $query ); // $result = $_CB_database->query(); } else { $query = 'UPDATE #__core_acl_groups_aro_map' . "\n SET group_id = " . (int) $this->gid . "\n WHERE aro_id = " . (int) $aro_group->aro_id; $_CB_database->setQuery($query); $result = $_CB_database->query(); } } if ($result && !$isNew && ($oldUsername != $this->username || $aro_group->group_id != $this->gid || $oldGid != $this->gid || self::_ArraysEquivalent($oldGids, $this->gids) || $oldBlock == 0 && $this->block == 1)) { // Update current sessions state if there is a change in gid or in username: if ($this->block == 0) { $sessionGid = 1; if ($_CB_framework->acl->is_group_child_of($this->usertype, 'Registered', 'ARO') || $_CB_framework->acl->is_group_child_of($this->usertype, 'Public Backend', 'ARO')) { // Authors, Editors, Publishers and Super Administrators are part of the Special Group: $sessionGid = 2; } $query = 'UPDATE #__session ' . "\n SET username = "******"\n WHERE userid = " . (int) $this->id; //TBD: here maybe jaclplus fields update if JACLplus installed.... $_CB_database->setQuery($query); $result = $_CB_database->query(); if (checkJversion() >= 2) { // This is needed for instant adding of groups to logged-in user (fixing bug #3581): $session = JFactory::getSession(); $jUser = $session->get('user'); if ($jUser->id == $this->id) { JAccess::clearStatics(); $session->set('user', new JUser((int) $this->id)); } } } else { // logout user now that user login has been blocked: if ($_CB_framework->myId() == $this->id) { $_CB_framework->logout(); } $_CB_database->setQuery("DELETE FROM #__session WHERE userid = " . (int) $this->id); //TBD: check if this is enough for J 1.5 $result = $_CB_database->query(); } } if (!$result) { $this->_error = $_CB_database->stderr(); return false; } } return $result; }