private static function ListMergeIssues(Profile $profile) { if (Platal::globals()->merge->state != 'done') { return null; } $flags = XDB::fetchOneCell('SELECT issues FROM profile_merge_issues WHERE pid = {?}', $profile->id()); if (!$flags) { return null; } return new PlFlagSet($flags); }
protected function modify(Profile $profile) { $q = $this->dao->prepare('UPDATE ' . $this->table() . ' SET GENDER = :gender, LASTNAME = :lastname, FIRSTNAME = :firstname, DESCRIPTION = :description, PHONE = :phone, MOBILE_PHONE = :mobilePhone, OFFICE_PHONE = :officePhone, WEBSITE = :website, AVATAR = :avatar, USER_ID = :userId, MAIN_ADDRESS_ID = :mainAddressId, ALTERNATE_CURRENCIES_USED = :alternateCurrenciesUsed WHERE ID = :id'); $q->bindValue(':gender', $profile->getGender()); $q->bindValue(':lastname', $profile->getLastname()); $q->bindValue(':firstname', $profile->getFirstname()); $q->bindValue(':description', $profile->getDescription()); $q->bindValue(':phone', $profile->getPhone()); $q->bindValue(':mobilePhone', $profile->getMobilePhone()); $q->bindValue(':officePhone', $profile->getOfficePhone()); $q->bindValue(':website', $profile->getWebsite()); $q->bindValue(':avatar', $profile->getAvatar()); $q->bindValue(':userId', $profile->getUserId(), PDO::PARAM_INT); $q->bindValue(':mainAddressId', $profile->getMainAddressId(), PDO::PARAM_INT); $q->bindValue(':alternateCurrenciesUsed', $profile->getAlternateCurrenciesUsed()); $q->bindValue(':id', $profile->id(), PDO::PARAM_INT); $q->execute(); }
public function delRegistered(PlPage $page, Profile $profile) { XDB::execute('DELETE FROM contacts WHERE uid = {?} AND contact = {?}', S::i('uid'), $profile->id()); if (XDB::affectedRows() > 0) { S::user()->invalidWatchCache(); Platal::session()->updateNbNotifs(); $page->trigSuccess("Contact retiré !"); } }
/** Check that the profile match the given rule. */ public function checkProfile(Profile $profile) { $this->requireProfiles(); $this->buildQuery(); $count = (int) XDB::rawFetchOneCell('SELECT COUNT(*) ' . $this->query . XDB::format(' AND p.pid = {?}', $profile->id())); return $count == 1; }
public function isWatchedUser(Profile $profile) { return in_array($profile->id(), $this->watchUsers()); }
function update_display_names(Profile $profile, array $public_names, array $private_names = null) { if (is_null($private_names)) { $private_names = XDB::fetchAllAssoc('SELECT type, name FROM profile_private_names WHERE pid = {?} ORDER BY type, id', $profile->id()); } $display_names = build_display_names($public_names, $private_names, $profile->isFemale()); XDB::execute('UPDATE profile_display SET public_name = {?}, private_name = {?}, directory_name = {?}, short_name = {?}, sort_name = {?} WHERE pid = {?}', $display_names['public_name'], $display_names['private_name'], $display_names['directory_name'], $display_names['short_name'], $display_names['sort_name'], $profile->id()); Profile::rebuildSearchTokens($profile->id(), false); if ($profile->owner()) { update_account_from_profile($profile->owner()->id()); } }
public static function register(Profile $profile, $field) { XDB::execute('INSERT INTO watch_profile (pid, ts, field) VALUES ({?}, NOW(), {?}) ON DUPLICATE KEY UPDATE ts = NOW()', $profile->id(), $field); }