Fix profile wrong DISTINCT + ORDER BY

[friendica.git] / mod / manage.php

diff --git a/mod/manage.php b/mod/manage.php
index 4bc7a3baba9113860c1b2bf43a8e91deef8cd2ab..e85561acfb350fc3d64f462efe8d4d929ae50556 100644 (file)
--- a/mod/manage.php
+++ b/mod/manage.php
@@ -1,10 +1,13 @@
 <?php
 
+require_once("include/text.php");
 
-function manage_post(&$a) {
 
-       if(! local_user())
+function manage_post(App $a) {
+
+       if (! local_user()) {
                return;
+       }
 
        $uid = local_user();
        $orig_record = $a->user;
@@ -13,40 +16,40 @@ function manage_post(&$a) {
                $r = q("select * from user where uid = %d limit 1",
                        intval($_SESSION['submanage'])
                );
-               if(count($r)) {
+               if (dbm::is_result($r)) {
                        $uid = intval($r[0]['uid']);
                        $orig_record = $r[0];
                }
        }
 
-       $r = q("select * from manage where uid = %d",
+       $r = q("SELECT * FROM `manage` WHERE `uid` = %d",
                intval($uid)
        );
 
        $submanage = $r;
 
        $identity = ((x($_POST['identity'])) ? intval($_POST['identity']) : 0);
-       if(! $identity)
+       if (! $identity) {
                return;
+       }
 
        $limited_id = 0;
        $original_id = $uid;
 
-       if(count($submanage)) {
-               foreach($submanage as $m) {
-                       if($identity == $m['mid']) {
+       if (dbm::is_result($submanage)) {
+               foreach ($submanage as $m) {
+                       if ($identity == $m['mid']) {
                                $limited_id = $m['mid'];
                                break;
                        }
                }
        }
 
-       if($limited_id) {
+       if ($limited_id) {
                $r = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
                        intval($limited_id)
                );
-       }
-       else {
+       } else {
                $r = q("SELECT * FROM `user` WHERE `uid` = %d AND `email` = '%s' AND `password` = '%s' LIMIT 1",
                        intval($identity),
                        dbesc($orig_record['email']),
@@ -54,8 +57,9 @@ function manage_post(&$a) {
                );
        }
 
-       if(! count($r))
+       if (! dbm::is_result($r)) {
                return;
+       }
 
        unset($_SESSION['authenticated']);
        unset($_SESSION['uid']);
@@ -66,49 +70,90 @@ function manage_post(&$a) {
        unset($_SESSION['mobile-theme']);
        unset($_SESSION['page_flags']);
        unset($_SESSION['return_url']);
-       if(x($_SESSION,'submanage'))
+       if (x($_SESSION, 'submanage')) {
                unset($_SESSION['submanage']);
+       }
+       if (x($_SESSION, 'sysmsg')) {
+               unset($_SESSION['sysmsg']);
+       }
+       if (x($_SESSION, 'sysmsg_info')) {
+               unset($_SESSION['sysmsg_info']);
+       }
 
        require_once('include/security.php');
-       authenticate_success($r[0],true,true);
+       authenticate_success($r[0], true, true);
 
-       if($limited_id)
+       if ($limited_id) {
                $_SESSION['submanage'] = $original_id;
+       }
+
+       $ret = array();
+       call_hooks('home_init',$ret);
 
-       goaway($a->get_baseurl(true) . '/profile/' . $a->user['nickname']);
+       goaway( App::get_baseurl() . "/profile/" . $a->user['nickname'] );
        // NOTREACHED
 }
 
 
 
-function manage_content(&$a) {
+function manage_content(App $a) {
 
-       if(! local_user()) {
+       if (! local_user()) {
                notice( t('Permission denied.') . EOL);
                return;
        }
 
-       $o = '<h3>' . t('Manage Identities and/or Pages') . '</h3>';
+       if ($_GET['identity']) {
+               $_POST['identity'] = $_GET['identity'];
+               manage_post($a);
+               return;
+       }
 
-       
-       $o .= '<div id="identity-manage-desc">' . t('Toggle between different identities or community/group pages which share your account details or which you have been granted "manage" permissions') . '</div>';
+       $identities = $a->identities;
 
-       $o .= '<div id="identity-manage-choose">' . t('Select an identity to manage: ') . '</div>';
+       //getting additinal information for each identity
+       foreach ($identities as $key=>$id) {
+               $thumb = q("SELECT `thumb` FROM `contact` WHERE `uid` = '%s' AND `self` = 1",
+                       dbesc($id['uid'])
+               );
 
-       $o .= '<div id="identity-selector-wrapper">' . "\r\n";
-       $o .= '<form action="manage" method="post" >' . "\r\n";
-       $o .= '<select name="identity" size="4" onchange="this.form.submit();" >' . "\r\n";
+               $identities[$key]['thumb'] = $thumb[0]['thumb'];
 
-       foreach($a->identities as $rr) {
-               $selected = (($rr['nickname'] === $a->user['nickname']) ? ' selected="selected" ' : '');
-               $o .= '<option ' . $selected . 'value="' . $rr['uid'] . '">' . $rr['username'] . ' (' . $rr['nickname'] . ')</option>' . "\r\n";
-       }
+               $identities[$key]['selected'] = ($id['nickname'] === $a->user['nickname']);
+
+               $notifications = 0;
+
+               $r = q("SELECT DISTINCT(`parent`) FROM `notify` WHERE `uid` = %d AND NOT `seen` AND NOT (`type` IN (%d, %d))",
+                       intval($id['uid']), intval(NOTIFY_INTRO), intval(NOTIFY_MAIL));
+
+               if (dbm::is_result($r)) {
+                       $notifications = sizeof($r);
+               }
+
+               $r = q("SELECT DISTINCT(`convid`) FROM `mail` WHERE `uid` = %d AND NOT `seen`",
+                       intval($id['uid']));
 
-       $o .= '</select>' . "\r\n";
-       $o .= '<div id="identity-select-break"></div>' . "\r\n";
+               if (dbm::is_result($r)) {
+                       $notifications = $notifications + sizeof($r);
+               }
+
+               $r = q("SELECT COUNT(*) AS `introductions` FROM `intro` WHERE NOT `blocked` AND NOT `ignore` AND `uid` = %d",
+                       intval($id['uid']));
+
+               if (dbm::is_result($r)) {
+                       $notifications = $notifications + $r[0]["introductions"];
+               }
+
+               $identities[$key]['notifications'] = $notifications;
+       }
 
-//     $o .= '<input id="identity-submit" type="submit" name="submit" value="' . t('Submit') . '" />';
-       $o .= '</div></form>' . "\r\n";
+       $o = replace_macros(get_markup_template('manage.tpl'), array(
+               '$title' => t('Manage Identities and/or Pages'),
+               '$desc' => t('Toggle between different identities or community/group pages which share your account details or which you have been granted "manage" permissions'),
+               '$choose' => t('Select an identity to manage: '),
+               '$identities' => $identities,
+               '$submit' => t('Submit'),
+       ));
 
        return $o;