3 * @file mod/profiles.php
7 use Friendica\BaseModule;
8 use Friendica\Content\ContactSelector;
9 use Friendica\Content\Feature;
10 use Friendica\Content\Nav;
11 use Friendica\Core\Addon;
12 use Friendica\Core\Config;
13 use Friendica\Core\L10n;
14 use Friendica\Core\PConfig;
15 use Friendica\Core\Renderer;
16 use Friendica\Core\System;
17 use Friendica\Core\Worker;
18 use Friendica\Database\DBA;
19 use Friendica\Model\Contact;
20 use Friendica\Model\GContact;
21 use Friendica\Model\Profile;
22 use Friendica\Module\Login;
23 use Friendica\Network\Probe;
24 use Friendica\Util\DateTimeFormat;
25 use Friendica\Util\Temporal;
27 function profiles_init(App $a) {
29 Nav::setSelected('profiles');
35 if (($a->argc > 2) && ($a->argv[1] === "drop") && intval($a->argv[2])) {
36 $r = q("SELECT * FROM `profile` WHERE `id` = %d AND `uid` = %d AND `is-default` = 0 LIMIT 1",
40 if (! DBA::isResult($r)) {
41 notice(L10n::t('Profile not found.') . EOL);
42 $a->internalRedirect('profiles');
46 BaseModule::checkFormSecurityTokenRedirectOnError('/profiles', 'profile_drop', 't');
48 // move every contact using this profile as their default to the user default
50 $r = q("UPDATE `contact` SET `profile-id` = (SELECT `profile`.`id` AS `profile-id` FROM `profile` WHERE `profile`.`is-default` = 1 AND `profile`.`uid` = %d LIMIT 1) WHERE `profile-id` = %d AND `uid` = %d ",
55 $r = q("DELETE FROM `profile` WHERE `id` = %d AND `uid` = %d",
59 if (DBA::isResult($r)) {
60 info(L10n::t('Profile deleted.').EOL);
63 $a->internalRedirect('profiles');
67 if (($a->argc > 1) && ($a->argv[1] === 'new')) {
69 BaseModule::checkFormSecurityTokenRedirectOnError('/profiles', 'profile_new', 't');
71 $r0 = q("SELECT `id` FROM `profile` WHERE `uid` = %d",
72 intval(local_user()));
74 $num_profiles = (DBA::isResult($r0) ? count($r0) : 0);
76 $name = L10n::t('Profile-') . ($num_profiles + 1);
78 $r1 = q("SELECT `name`, `photo`, `thumb` FROM `profile` WHERE `uid` = %d AND `is-default` = 1 LIMIT 1",
79 intval(local_user()));
81 $r2 = q("INSERT INTO `profile` (`uid` , `profile-name` , `name`, `photo`, `thumb`)
82 VALUES ( %d, '%s', '%s', '%s', '%s' )",
85 DBA::escape($r1[0]['name']),
86 DBA::escape($r1[0]['photo']),
87 DBA::escape($r1[0]['thumb'])
90 $r3 = q("SELECT `id` FROM `profile` WHERE `uid` = %d AND `profile-name` = '%s' LIMIT 1",
95 info(L10n::t('New profile created.') . EOL);
96 if (DBA::isResult($r3) && count($r3) == 1) {
97 $a->internalRedirect('profiles/' . $r3[0]['id']);
100 $a->internalRedirect('profiles');
103 if (($a->argc > 2) && ($a->argv[1] === 'clone')) {
105 BaseModule::checkFormSecurityTokenRedirectOnError('/profiles', 'profile_clone', 't');
107 $r0 = q("SELECT `id` FROM `profile` WHERE `uid` = %d",
108 intval(local_user()));
110 $num_profiles = (DBA::isResult($r0) ? count($r0) : 0);
112 $name = L10n::t('Profile-') . ($num_profiles + 1);
113 $r1 = q("SELECT * FROM `profile` WHERE `uid` = %d AND `id` = %d LIMIT 1",
114 intval(local_user()),
117 if(! DBA::isResult($r1)) {
118 notice(L10n::t('Profile unavailable to clone.') . EOL);
123 $r1[0]['is-default'] = 0;
124 $r1[0]['publish'] = 0;
125 $r1[0]['net-publish'] = 0;
126 $r1[0]['profile-name'] = DBA::escape($name);
128 DBA::insert('profile', $r1[0]);
130 $r3 = q("SELECT `id` FROM `profile` WHERE `uid` = %d AND `profile-name` = '%s' LIMIT 1",
131 intval(local_user()),
134 info(L10n::t('New profile created.') . EOL);
135 if ((DBA::isResult($r3)) && (count($r3) == 1)) {
136 $a->internalRedirect('profiles/'.$r3[0]['id']);
139 $a->internalRedirect('profiles');
141 return; // NOTREACHED
145 if (($a->argc > 1) && (intval($a->argv[1]))) {
146 $r = q("SELECT id FROM `profile` WHERE `id` = %d AND `uid` = %d LIMIT 1",
150 if (! DBA::isResult($r)) {
151 notice(L10n::t('Profile not found.') . EOL);
156 Profile::load($a, $a->user['nickname'], $r[0]['id']);
160 function profile_clean_keywords($keywords)
162 $keywords = str_replace(",", " ", $keywords);
163 $keywords = explode(" ", $keywords);
166 foreach ($keywords as $keyword) {
167 $keyword = trim(strtolower($keyword));
168 $keyword = trim($keyword, "#");
169 if ($keyword != "") {
170 $cleaned[] = $keyword;
174 $keywords = implode(", ", $cleaned);
179 function profiles_post(App $a) {
181 if (! local_user()) {
182 notice(L10n::t('Permission denied.') . EOL);
186 $namechanged = false;
188 Addon::callHooks('profile_post', $_POST);
190 if (($a->argc > 1) && ($a->argv[1] !== "new") && intval($a->argv[1])) {
191 $orig = q("SELECT * FROM `profile` WHERE `id` = %d AND `uid` = %d LIMIT 1",
195 if (! DBA::isResult($orig)) {
196 notice(L10n::t('Profile not found.') . EOL);
200 BaseModule::checkFormSecurityTokenRedirectOnError('/profiles', 'profile_edit');
202 $is_default = (($orig[0]['is-default']) ? 1 : 0);
204 $profile_name = notags(trim($_POST['profile_name']));
205 if (! strlen($profile_name)) {
206 notice(L10n::t('Profile Name is required.') . EOL);
210 $dob = $_POST['dob'] ? escape_tags(trim($_POST['dob'])) : '0000-00-00';
212 $y = substr($dob, 0, 4);
213 if ((! ctype_digit($y)) || ($y < 1900)) {
216 $ignore_year = false;
218 if (!in_array($dob, ['0000-00-00', '0001-01-01'])) {
219 if (strpos($dob, '0000-') === 0 || strpos($dob, '0001-') === 0) {
221 $dob = substr($dob, 5);
225 $dob = '0000-' . DateTimeFormat::utc('1900-' . $dob, 'm-d');
227 $dob = DateTimeFormat::utc($dob, 'Y-m-d');
231 $name = notags(trim($_POST['name']));
233 if (! strlen($name)) {
237 if ($orig[0]['name'] != $name) {
241 $pdesc = notags(trim($_POST['pdesc']));
242 $gender = notags(trim($_POST['gender']));
243 $address = notags(trim($_POST['address']));
244 $locality = notags(trim($_POST['locality']));
245 $region = notags(trim($_POST['region']));
246 $postal_code = notags(trim($_POST['postal_code']));
247 $country_name = notags(trim($_POST['country_name']));
248 $pub_keywords = profile_clean_keywords(notags(trim($_POST['pub_keywords'])));
249 $prv_keywords = profile_clean_keywords(notags(trim($_POST['prv_keywords'])));
250 $marital = notags(trim($_POST['marital']));
251 $howlong = notags(trim($_POST['howlong']));
253 $with = ((x($_POST,'with')) ? notags(trim($_POST['with'])) : '');
255 if (! strlen($howlong)) {
256 $howlong = DBA::NULL_DATETIME;
258 $howlong = DateTimeFormat::convert($howlong, 'UTC', date_default_timezone_get());
260 // linkify the relationship target if applicable
262 $withchanged = false;
265 if ($with != strip_tags($orig[0]['with'])) {
269 if (strpos($lookup, '@') === 0) {
270 $lookup = substr($lookup, 1);
272 $lookup = str_replace('_',' ', $lookup);
273 if (strpos($lookup, '@') || (strpos($lookup, 'http://'))) {
275 $links = @Probe::lrdd($lookup);
277 foreach ($links as $link) {
278 if ($link['@attributes']['rel'] === 'http://webfinger.net/rel/profile-page') {
279 $prf = $link['@attributes']['href'];
286 $r = q("SELECT * FROM `contact` WHERE `name` = '%s' AND `uid` = %d LIMIT 1",
287 DBA::escape($newname),
290 if (! DBA::isResult($r)) {
291 $r = q("SELECT * FROM `contact` WHERE `nick` = '%s' AND `uid` = %d LIMIT 1",
292 DBA::escape($lookup),
296 if (DBA::isResult($r)) {
298 $newname = $r[0]['name'];
303 $with = str_replace($lookup, '<a href="' . $prf . '">' . $newname . '</a>', $with);
304 if (strpos($with, '@') === 0) {
305 $with = substr($with, 1);
309 $with = $orig[0]['with'];
313 /// @TODO Not flexible enough for later expansion, let's have more OOP here
314 $sexual = notags(trim($_POST['sexual']));
315 $xmpp = notags(trim($_POST['xmpp']));
316 $homepage = notags(trim($_POST['homepage']));
317 if ((strpos($homepage, 'http') !== 0) && (strlen($homepage))) {
318 // neither http nor https in URL, add them
319 $homepage = 'http://'.$homepage;
321 $hometown = notags(trim($_POST['hometown']));
322 $politic = notags(trim($_POST['politic']));
323 $religion = notags(trim($_POST['religion']));
325 $likes = escape_tags(trim($_POST['likes']));
326 $dislikes = escape_tags(trim($_POST['dislikes']));
328 $about = escape_tags(trim($_POST['about']));
329 $interest = escape_tags(trim($_POST['interest']));
330 $contact = escape_tags(trim($_POST['contact']));
331 $music = escape_tags(trim($_POST['music']));
332 $book = escape_tags(trim($_POST['book']));
333 $tv = escape_tags(trim($_POST['tv']));
334 $film = escape_tags(trim($_POST['film']));
335 $romance = escape_tags(trim($_POST['romance']));
336 $work = escape_tags(trim($_POST['work']));
337 $education = escape_tags(trim($_POST['education']));
339 $hide_friends = (($_POST['hide-friends'] == 1) ? 1: 0);
341 PConfig::set(local_user(), 'system', 'detailled_profile', (($_POST['detailled_profile'] == 1) ? 1: 0));
346 if ($marital != $orig[0]['marital']) {
347 $changes[] = '[color=#ff0000]♥[/color] ' . L10n::t('Marital Status');
351 $changes[] = '[color=#ff0000]♥[/color] ' . L10n::t('Romantic Partner');
352 $value = strip_tags($with);
354 if ($likes != $orig[0]['likes']) {
355 $changes[] = L10n::t('Likes');
358 if ($dislikes != $orig[0]['dislikes']) {
359 $changes[] = L10n::t('Dislikes');
362 if ($work != $orig[0]['work']) {
363 $changes[] = L10n::t('Work/Employment');
365 if ($religion != $orig[0]['religion']) {
366 $changes[] = L10n::t('Religion');
369 if ($politic != $orig[0]['politic']) {
370 $changes[] = L10n::t('Political Views');
373 if ($gender != $orig[0]['gender']) {
374 $changes[] = L10n::t('Gender');
377 if ($sexual != $orig[0]['sexual']) {
378 $changes[] = L10n::t('Sexual Preference');
381 if ($xmpp != $orig[0]['xmpp']) {
382 $changes[] = L10n::t('XMPP');
385 if ($homepage != $orig[0]['homepage']) {
386 $changes[] = L10n::t('Homepage');
389 if ($interest != $orig[0]['interest']) {
390 $changes[] = L10n::t('Interests');
393 if ($address != $orig[0]['address']) {
394 $changes[] = L10n::t('Address');
395 // New address not sent in notifications, potential privacy issues
396 // in case this leaks to unintended recipients. Yes, it's in the public
397 // profile but that doesn't mean we have to broadcast it to everybody.
399 if ($locality != $orig[0]['locality'] || $region != $orig[0]['region']
400 || $country_name != $orig[0]['country-name']) {
401 $changes[] = L10n::t('Location');
402 $comma1 = ((($locality) && ($region || $country_name)) ? ', ' : ' ');
403 $comma2 = (($region && $country_name) ? ', ' : '');
404 $value = $locality . $comma1 . $region . $comma2 . $country_name;
408 $r = q("UPDATE `profile`
409 SET `profile-name` = '%s',
417 `postal-code` = '%s',
418 `country-name` = '%s',
428 `pub_keywords` = '%s',
429 `prv_keywords` = '%s',
443 WHERE `id` = %d AND `uid` = %d",
444 DBA::escape($profile_name),
447 DBA::escape($gender),
449 DBA::escape($address),
450 DBA::escape($locality),
451 DBA::escape($region),
452 DBA::escape($postal_code),
453 DBA::escape($country_name),
454 DBA::escape($marital),
456 DBA::escape($howlong),
457 DBA::escape($sexual),
459 DBA::escape($homepage),
460 DBA::escape($hometown),
461 DBA::escape($politic),
462 DBA::escape($religion),
463 DBA::escape($pub_keywords),
464 DBA::escape($prv_keywords),
466 DBA::escape($dislikes),
468 DBA::escape($interest),
469 DBA::escape($contact),
474 DBA::escape($romance),
476 DBA::escape($education),
477 intval($hide_friends),
482 /// @TODO decide to use DBA::isResult() here and check $r
484 info(L10n::t('Profile updated.') . EOL);
489 $r = q("UPDATE `user` set `username` = '%s' where `uid` = %d",
495 Contact::updateSelfFromUserID(local_user());
497 // Update global directory in background
498 $url = $_SESSION['my_url'];
499 if ($url && strlen(Config::get('system', 'directory'))) {
500 Worker::add(PRIORITY_LOW, "Directory", $url);
503 Worker::add(PRIORITY_LOW, 'ProfileUpdate', local_user());
505 // Update the global contact for the user
506 GContact::updateForUser(local_user());
511 function profiles_content(App $a) {
513 if (! local_user()) {
514 notice(L10n::t('Permission denied.') . EOL);
515 return Login::form();
520 if (($a->argc > 1) && (intval($a->argv[1]))) {
521 $r = q("SELECT * FROM `profile` WHERE `id` = %d AND `uid` = %d LIMIT 1",
525 if (! DBA::isResult($r)) {
526 notice(L10n::t('Profile not found.') . EOL);
530 $a->page['htmlhead'] .= Renderer::replaceMacros(get_markup_template('profed_head.tpl'), [
531 '$baseurl' => System::baseUrl(true),
534 $opt_tpl = get_markup_template("profile-hide-friends.tpl");
535 $hide_friends = Renderer::replaceMacros($opt_tpl,[
537 'hide-friends', //Name
538 L10n::t('Hide contacts and friends:'), //Label
539 !!$r[0]['hide-friends'], //Value
541 [L10n::t('No'), L10n::t('Yes')] //Off - On strings
543 '$desc' => L10n::t('Hide your contact/friend list from viewers of this profile?'),
544 '$yes_str' => L10n::t('Yes'),
545 '$no_str' => L10n::t('No'),
546 '$yes_selected' => (($r[0]['hide-friends']) ? " checked=\"checked\" " : ""),
547 '$no_selected' => (($r[0]['hide-friends'] == 0) ? " checked=\"checked\" " : "")
550 $personal_account = !(in_array($a->user["page-flags"],
551 [Contact::PAGE_COMMUNITY, Contact::PAGE_PRVGROUP]));
553 $detailled_profile = (PConfig::get(local_user(), 'system', 'detailled_profile') AND $personal_account);
555 $is_default = (($r[0]['is-default']) ? 1 : 0);
556 $tpl = get_markup_template("profile_edit.tpl");
557 $o .= Renderer::replaceMacros($tpl, [
558 '$personal_account' => $personal_account,
559 '$detailled_profile' => $detailled_profile,
562 'detailled_profile', //Name
563 L10n::t('Show more profile fields:'), //Label
564 $detailled_profile, //Value
566 [L10n::t('No'), L10n::t('Yes')] //Off - On strings
569 '$multi_profiles' => Feature::isEnabled(local_user(), 'multi_profiles'),
570 '$form_security_token' => BaseModule::getFormSecurityToken("profile_edit"),
571 '$form_security_token_photo' => BaseModule::getFormSecurityToken("profile_photo"),
572 '$profile_clone_link' => ((Feature::isEnabled(local_user(), 'multi_profiles')) ? 'profiles/clone/' . $r[0]['id'] . '?t=' . BaseModule::getFormSecurityToken("profile_clone") : ""),
573 '$profile_drop_link' => 'profiles/drop/' . $r[0]['id'] . '?t=' . BaseModule::getFormSecurityToken("profile_drop"),
575 '$profile_action' => L10n::t('Profile Actions'),
576 '$banner' => L10n::t('Edit Profile Details'),
577 '$submit' => L10n::t('Submit'),
578 '$profpic' => L10n::t('Change Profile Photo'),
579 '$profpiclink' => '/photos/' . $a->user['nickname'],
580 '$viewprof' => L10n::t('View this profile'),
581 '$viewallprof' => L10n::t('View all profiles'),
582 '$editvis' => L10n::t('Edit visibility'),
583 '$cr_prof' => L10n::t('Create a new profile using these settings'),
584 '$cl_prof' => L10n::t('Clone this profile'),
585 '$del_prof' => L10n::t('Delete this profile'),
587 '$lbl_basic_section' => L10n::t('Basic information'),
588 '$lbl_picture_section' => L10n::t('Profile picture'),
589 '$lbl_location_section' => L10n::t('Location'),
590 '$lbl_preferences_section' => L10n::t('Preferences'),
591 '$lbl_status_section' => L10n::t('Status information'),
592 '$lbl_about_section' => L10n::t('Additional information'),
593 '$lbl_interests_section' => L10n::t('Interests'),
594 '$lbl_personal_section' => L10n::t('Personal'),
595 '$lbl_relation_section' => L10n::t('Relation'),
596 '$lbl_miscellaneous_section' => L10n::t('Miscellaneous'),
598 '$lbl_profile_photo' => L10n::t('Upload Profile Photo'),
599 '$lbl_gender' => L10n::t('Your Gender:'),
600 '$lbl_marital' => L10n::t('<span class="heart">♥</span> Marital Status:'),
601 '$lbl_sexual' => L10n::t('Sexual Preference:'),
602 '$lbl_ex2' => L10n::t('Example: fishing photography software'),
604 '$disabled' => (($is_default) ? 'onclick="return false;" style="color: #BBBBFF;"' : ''),
605 '$baseurl' => System::baseUrl(true),
606 '$profile_id' => $r[0]['id'],
607 '$profile_name' => ['profile_name', L10n::t('Profile Name:'), $r[0]['profile-name'], L10n::t('Required'), '*'],
608 '$is_default' => $is_default,
609 '$default' => (($is_default) ? '<p id="profile-edit-default-desc">' . L10n::t('This is your <strong>public</strong> profile.<br />It <strong>may</strong> be visible to anybody using the internet.') . '</p>' : ""),
610 '$name' => ['name', L10n::t('Your Full Name:'), $r[0]['name']],
611 '$pdesc' => ['pdesc', L10n::t('Title/Description:'), $r[0]['pdesc']],
612 '$dob' => Temporal::getDateofBirthField($r[0]['dob']),
613 '$hide_friends' => $hide_friends,
614 '$address' => ['address', L10n::t('Street Address:'), $r[0]['address']],
615 '$locality' => ['locality', L10n::t('Locality/City:'), $r[0]['locality']],
616 '$region' => ['region', L10n::t('Region/State:'), $r[0]['region']],
617 '$postal_code' => ['postal_code', L10n::t('Postal/Zip Code:'), $r[0]['postal-code']],
618 '$country_name' => ['country_name', L10n::t('Country:'), $r[0]['country-name']],
619 '$age' => ((intval($r[0]['dob'])) ? '(' . L10n::t('Age: ') . Temporal::getAgeByTimezone($r[0]['dob'],$a->user['timezone'],$a->user['timezone']) . ')' : ''),
620 '$gender' => ContactSelector::gender($r[0]['gender']),
621 '$marital' => ['selector' => ContactSelector::maritalStatus($r[0]['marital']), 'value' => $r[0]['marital']],
622 '$with' => ['with', L10n::t("Who: \x28if applicable\x29"), strip_tags($r[0]['with']), L10n::t('Examples: cathy123, Cathy Williams, cathy@example.com')],
623 '$howlong' => ['howlong', L10n::t('Since [date]:'), ($r[0]['howlong'] <= DBA::NULL_DATETIME ? '' : DateTimeFormat::local($r[0]['howlong']))],
624 '$sexual' => ['selector' => ContactSelector::sexualPreference($r[0]['sexual']), 'value' => $r[0]['sexual']],
625 '$about' => ['about', L10n::t('Tell us about yourself...'), $r[0]['about']],
626 '$xmpp' => ['xmpp', L10n::t("XMPP \x28Jabber\x29 address:"), $r[0]['xmpp'], L10n::t("The XMPP address will be propagated to your contacts so that they can follow you.")],
627 '$homepage' => ['homepage', L10n::t('Homepage URL:'), $r[0]['homepage']],
628 '$hometown' => ['hometown', L10n::t('Hometown:'), $r[0]['hometown']],
629 '$politic' => ['politic', L10n::t('Political Views:'), $r[0]['politic']],
630 '$religion' => ['religion', L10n::t('Religious Views:'), $r[0]['religion']],
631 '$pub_keywords' => ['pub_keywords', L10n::t('Public Keywords:'), $r[0]['pub_keywords'], L10n::t("\x28Used for suggesting potential friends, can be seen by others\x29")],
632 '$prv_keywords' => ['prv_keywords', L10n::t('Private Keywords:'), $r[0]['prv_keywords'], L10n::t("\x28Used for searching profiles, never shown to others\x29")],
633 '$likes' => ['likes', L10n::t('Likes:'), $r[0]['likes']],
634 '$dislikes' => ['dislikes', L10n::t('Dislikes:'), $r[0]['dislikes']],
635 '$music' => ['music', L10n::t('Musical interests'), $r[0]['music']],
636 '$book' => ['book', L10n::t('Books, literature'), $r[0]['book']],
637 '$tv' => ['tv', L10n::t('Television'), $r[0]['tv']],
638 '$film' => ['film', L10n::t('Film/dance/culture/entertainment'), $r[0]['film']],
639 '$interest' => ['interest', L10n::t('Hobbies/Interests'), $r[0]['interest']],
640 '$romance' => ['romance', L10n::t('Love/romance'), $r[0]['romance']],
641 '$work' => ['work', L10n::t('Work/employment'), $r[0]['work']],
642 '$education' => ['education', L10n::t('School/education'), $r[0]['education']],
643 '$contact' => ['contact', L10n::t('Contact information and Social Networks'), $r[0]['contact']],
646 $arr = ['profile' => $r[0], 'entry' => $o];
647 Addon::callHooks('profile_edit', $arr);
651 // If we don't support multi profiles, don't display this list.
652 if (!Feature::isEnabled(local_user(), 'multi_profiles')) {
653 $r = q("SELECT * FROM `profile` WHERE `uid` = %d AND `is-default`=1",
656 if (DBA::isResult($r)) {
657 //Go to the default profile.
658 $a->internalRedirect('profiles/' . $r[0]['id']);
662 $r = q("SELECT * FROM `profile` WHERE `uid` = %d",
665 if (DBA::isResult($r)) {
667 $tpl = get_markup_template('profile_entry.tpl');
670 foreach ($r as $rr) {
671 $profiles .= Renderer::replaceMacros($tpl, [
672 '$photo' => $a->removeBaseURL($rr['thumb']),
674 '$alt' => L10n::t('Profile Image'),
675 '$profile_name' => $rr['profile-name'],
676 '$visible' => (($rr['is-default']) ? '<strong>' . L10n::t('visible to everybody') . '</strong>'
677 : '<a href="'.'profperm/'.$rr['id'].'" />' . L10n::t('Edit visibility') . '</a>')
681 $tpl_header = get_markup_template('profile_listing_header.tpl');
682 $o .= Renderer::replaceMacros($tpl_header,[
683 '$header' => L10n::t('Edit/Manage Profiles'),
684 '$chg_photo' => L10n::t('Change profile photo'),
685 '$cr_new' => L10n::t('Create New Profile'),
686 '$cr_new_link' => 'profiles/new?t=' . BaseModule::getFormSecurityToken("profile_new"),
687 '$profiles' => $profiles