diff --git a/application/modules/default/controllers/UserController.php b/application/modules/default/controllers/UserController.php
index d6e0fd98b..12a1da5d1 100644
--- a/application/modules/default/controllers/UserController.php
+++ b/application/modules/default/controllers/UserController.php
@@ -1,639 +1,700 @@
 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 class UserController extends Local_Controller_Action_DomainSwitch
 {
 
     protected $_memberId;
     protected $_userName;
     /** @var  Zend_Db_Table_Row */
     protected $_memberSettings;
 
     public function init()
     {
         parent::init();
 
         if ($this->hasParam('user_name')) {
             $this->_userName = $this->getParam('user_name');
             $this->_userName = urldecode($this->_userName);
 
             $modelMember = new Default_Model_Member();
             $this->_memberId = $modelMember->fetchActiveUserByUsername($this->_userName);
         } else {
             $this->_memberId = (int)$this->getParam('member_id');
         }
     }
 
     public function indexAction()
     {
 
         $this->_helper->viewRenderer('aboutme');
         $this->aboutmeAction();
     }
 
     public function aboutmeAction()
     {
         $tableMember = new Default_Model_Member();
         $tableProject = new Default_Model_Project();
-
+        $earnModel = new Default_Model_StatDownload();
+        $helperUserRole = new Backend_View_Helper_UserRole();
         $pageLimit = 500;
         $projectpage = (int)$this->getParam('projectpage', 1);
 
         $this->view->authMember = $this->_authMember;
         //$this->view->member = $tableMember->find($this->_memberId)->current();
         $this->view->member = $tableMember->fetchMemberData($this->_memberId);
         if (null == $this->view->member) {
             $this->redirect("/");
         }
         if ($this->view->member->is_deleted == 1 or $this->view->member->is_active == 0) {
             $this->redirect("/");
         }
 
         $this->view->mainProject = $this->view->member->findDependentRowset($tableProject, 'MainProject')->current();
+
+        $this->view->userProjectCategories = $tableProject->getUserCreatingCategorys($this->_memberId);
+        $this->view->aboutmeUserInfo = $this->getAboutmeUserInfo($this->_memberId,$this->view->member->username);
+        
+
+        $userRoleName = $helperUserRole->userRole();
+        if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
+            $amount = $earnModel->getMonthEarn($this->_memberId,201812);
+            if($amount && $amount['amount'])
+            {
+                $this->view->earnInfo = ' Last month I earned $'.$amount['amount'].'.';
+            }else
+            {
+                $this->view->earnInfo=' Last month I earned 0.';
+            }
+        }else{
+            $this->view->earnInfo='test';
+        }
+        
+
         // TODOs
 
         // $this->view->supportedProjects = $tableMember->fetchSupportedProjects($this->_memberId);
 
         //Categories
         /*
         $catArray = array();
         foreach ($this->view->supportedProjects as $pro) {
             $catArray[$pro->catTitle] = array();
         }
 
         $helperProductUrl = new Default_View_Helper_BuildProductUrl();
         foreach ($this->view->supportedProjects as $pro) {
             $projArr = array();
             $projArr['name'] = $pro->title;
             $projArr['image'] = $pro->image_small;
             $projArr['url'] = $helperProductUrl->buildProductUrl($pro->project_id);
             $projArr['sumAmount'] = $pro->sumAmount;
             array_push($catArray[$pro->catTitle], $projArr);
         }
         $this->view->supportingTeaser = $catArray;
 
         $this->view->followedProducts = $tableMember->fetchFollowedProjects($this->_memberId, null);
         $this->view->hits = $tableMember->fetchProjectsSupported($this->_memberId);
         */
         // ajax load more products
         if ($this->getParam('projectpage', null)) {
             $total_records = $tableProject->countAllProjectsForMemberCatFilter($this->_memberId, true, null);
             $this->view->pageLimit = $pageLimit;
             $this->view->projectpage = $projectpage;
             $this->view->total_records = $total_records;
             //$this->view->userProducts = $tableProject->fetchAllProjectsForMember($this->_memberId, $pageLimit, ($projectpage - 1) * $pageLimit,true);
             $this->view->userProducts =
                 $tableProject->getUserActiveProjects($this->_memberId, $pageLimit, ($projectpage - 1) * $pageLimit);
 
             $this->_helper->layout->disableLayout();
             $this->_helper->viewRenderer('partials/aboutmeProducts');
 
             //$this->forward('showmoreproductsajax', 'user', null, $this->getAllParams());
             return;
         } else {
 
             $total_records = $tableProject->countAllProjectsForMemberCatFilter($this->_memberId, true, null);
             $this->view->pageLimit = $pageLimit;
             $this->view->projectpage = $projectpage;
             $this->view->total_records = $total_records;
             //$this->view->userProducts = $tableProject->fetchAllProjectsForMember($this->_memberId, $pageLimit, ($projectpage - 1) * $pageLimit,true);
             $this->view->userProducts =
                 $tableProject->getUserActiveProjects($this->_memberId, $pageLimit, ($projectpage - 1) * $pageLimit);
 
             $this->view->userFeaturedProducts = $tableProject->fetchAllFeaturedProjectsForMember($this->_memberId);
 
             $paginationComments = $tableMember->fetchComments($this->_memberId);
             if ($paginationComments) {
                 $offset = (int)$this->getParam('page');
                 $paginationComments->setItemCountPerPage(50);
                 $paginationComments->setCurrentPageNumber($offset);
                 $this->view->comments = $paginationComments;
             }
 
             // favs    Currently no paging...
             $this->view->paramLikePageId = (int)$this->getParam('likepage');
             $model = new Default_Model_DbTable_ProjectFollower();
             $offset = $this->view->paramLikePageId;
             $list = $model->fetchLikesForMember($this->_memberId);
             $list->setItemCountPerPage(1000);
             $list->setCurrentPageNumber($offset);
             $this->view->likes = $list;
 
             // plings   Currently no paging...
             $plingmodel = new Default_Model_ProjectPlings();
             $offset = null;
             $plist = $plingmodel->fetchPlingsForMember($this->_memberId);
             $plist->setItemCountPerPage(1000);
             $plist->setCurrentPageNumber($offset);
             $this->view->plings = $plist;
 
             // plings   Currently no paging...
             $plingmodel = new Default_Model_ProjectPlings();
             $offset = null;
             $pslist = $plingmodel->fetchPlingsForSupporter($this->_memberId);
             $pslist->setItemCountPerPage(1000);
             $pslist->setCurrentPageNumber($offset);
             $this->view->supportersplings = $pslist;
 
             // rated
             $ratemodel = new Default_Model_DbTable_ProjectRating();
             $this->view->rated = $ratemodel->getRatedForMember($this->_memberId);
 
             $stat = array();
             $stat['cntProducts'] = $total_records;
             if ($this->view->userFeaturedProducts) {
                 $cnt = 0;
                 foreach ($this->view->userFeaturedProducts as $tmp) {
                     $cnt++;
                 }
                 $stat['cntFProducts'] = $cnt;
             } else {
                 $stat['cntFProducts'] = 0;
             }
 
             $stat['cntComments'] = $paginationComments->getTotalItemCount();
             $tblFollower = new Default_Model_DbTable_ProjectFollower();
             $stat['cntLikesHeGave'] = $tblFollower->countLikesHeGave($this->_memberId);
             $stat['cntLikesHeGot'] = $tblFollower->countLikesHeGot($this->_memberId);
 
             $tblPling = new Default_Model_DbTable_ProjectPlings();
             $stat['cntPlingsHeGave'] = $tblPling->countPlingsHeGave($this->_memberId);
             $stat['cntPlingsHeGot'] = $tblPling->countPlingsHeGot($this->_memberId);
 
             $donationinfo = $tableMember->fetchSupporterDonationInfo($this->_memberId);
             if ($donationinfo) {
                 $stat['donationIssupporter'] = $donationinfo['issupporter'];
                 $stat['donationMax'] = $donationinfo['active_time_max'];
                 $stat['donationMin'] = $donationinfo['active_time_min'];
                 $stat['donationCnt'] = $donationinfo['cnt'];
             }
             //  $cntmb = $tableMember->fetchCntSupporters($this->_memberId);
             // $stat['cntSupporters'] = $cntmb;
             $stat['userLastActiveTime'] = $tableMember->fetchLastActiveTime($this->_memberId);
 
-            $helperUserRole = new Backend_View_Helper_UserRole();
+            
             $userRoleName = $helperUserRole->userRole();
             if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
                 $stat['cntDuplicateSourceurl'] = $tableProject->getCountProjectsDuplicateSourceurl($this->_memberId);
             }
 
             $this->view->stat = $stat;
         }
     }
 
+    public function getAboutmeUserInfo($member_id,$username)
+    {
+        $tableProject = new Default_Model_Project();
+        $userProjectCategories = $tableProject->getUserCreatingCategorys($member_id);
+        $cnt = sizeof($userProjectCategories ); 
+        $userinfo='';
+        if($cnt>0)
+        {
+            $userinfo = "Hi, I am ".$username." and I'm creating ";
+            if($cnt==1)
+            {
+                $userinfo = $userinfo.' '.$userProjectCategories[0]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[0]['cnt'].'].';
+            }else if($cnt==2)
+            {
+                $userinfo = $userinfo.' '.$userProjectCategories[0]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[0]['cnt'].']';
+                $userinfo = $userinfo.' and '.$userProjectCategories[1]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[1]['cnt'].'].';
+            }else if($cnt==3)
+            {
+                $userinfo = $userinfo.' '.$userProjectCategories[0]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[0]['cnt'].']';
+                $userinfo = $userinfo.' , '.$userProjectCategories[1]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[1]['cnt'].']';
+                $userinfo = $userinfo.' and '.$userProjectCategories[2]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[2]['cnt'].'].';
+            }else if($cnt>3)
+            {
+                $userinfo = $userinfo.' '.$userProjectCategories[0]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[0]['cnt'].']';
+                $userinfo = $userinfo.' , '.$userProjectCategories[1]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[1]['cnt'].']';
+                $userinfo = $userinfo.' , '.$userProjectCategories[2]['category1'];
+                $userinfo = $userinfo.'['.$userProjectCategories[2]['cnt'].']';
+                $userinfo = $userinfo.' and more.';
+            }                                                
+        }
+        return $userinfo;
+    }
     public function avatarAction()
     {
         $this->_helper->layout->disableLayout();
 
         $size = (int)$this->getParam("size", 200);
         $width = (int)$this->getParam("width", ($size / 2));
         $this->view->size = (int)$size / 2;
 
         $emailHash = $this->getParam("emailhash", null);
 
         if ($emailHash) {
             $memberTable = new Default_Model_Member();
             $member = $memberTable->findMemberForMailHash($emailHash);
 
             if ($member) {
 
                 $helperImage = new Default_View_Helper_Image();
                 $imgUrl = $helperImage->Image($member['profile_image_url'], array('width' => $width, 'height' => $width));
                 $this->view->avatar = $imgUrl;
 
                 $this->redirect($imgUrl);
 
                 return;
             }
         }
 
         $this->view->avatar = "";
         $helperImage = new Default_View_Helper_Image();
         $imgUrl = $helperImage->Image("default-profile.png", array('width' => $width, 'height' => $width));
         $this->redirect($imgUrl);
     }
 
     public function aboutAction()
     {
         $modelMember = new Default_Model_Member();
         $this->view->member = $modelMember->fetchMember($this->_memberId)->toArray();
         $this->view->currentPageOffset = (int)$this->getParam('page');
     }
 
     public function showmoreproductsajaxAction()
     {
         $this->_helper->layout->disableLayout();
         $tableProject = new Default_Model_Project();
         $pageLimit = 21;
         $page = (int)$this->getParam('page', 1);
         $total_records = $tableProject->countAllProjectsForMemberCatFilter($this->_memberId, true, null);
         $this->view->pageLimit = $pageLimit;
         $this->view->page = $page;
         $this->view->total_records = $total_records;
         $this->view->userProducts =
             $tableProject->fetchAllProjectsForMember($this->_memberId, $pageLimit, ($page - 1) * $pageLimit, true);
         $this->_helper->viewRenderer('/partials/aboutmeProducts');
     }
 
     public function userdataajaxAction()
     {
         $this->_helper->layout()->disableLayout();
         $this->_helper->viewRenderer->setNoRender(true);
         $resultArray = array();
 
         header('Access-Control-Allow-Origin: *');
 
         $this->getResponse()->setHeader('Access-Control-Allow-Origin', '*')->setHeader('Access-Control-Allow-Credentials', 'true')
              ->setHeader('Access-Control-Allow-Methods', 'POST, GET, OPTIONS')
              ->setHeader('Access-Control-Allow-Headers', 'origin, content-type, accept')
         ;
 
         $userid = $this->getParam('id');
 
         $modelMember = new Default_Model_Member();
         $user = $modelMember->find($userid)->current();
 
         if (Zend_Auth::getInstance()->hasIdentity()) {
 
             $auth = Zend_Auth::getInstance();
             $user = $auth->getStorage()->read();
 
             $resultArray['member_id'] = $user->member_id;
             $resultArray['username'] = $user->username;
             $resultArray['mail'] = $user->mail;
             $resultArray['avatar'] = $user->profile_image_url;
         } else if (null != $userid && null != $user) {
 
             $resultArray['member_id'] = $user['member_id'];
             $resultArray['username'] = $user['username'];
             $resultArray['mail'] = $user['mail'];
             $resultArray['avatar'] = $user['profile_image_url'];
         } else {
             $resultArray['member_id'] = null;
             $resultArray['username'] = null;
             $resultArray['mail'] = null;
             $resultArray['avatar'] = null;
         }
 
         $resultAll = array();
         $resultAll['status'] = "success";
         $resultAll['data'] = $resultArray;
 
         $this->_helper->json($resultAll);
     }
 
     public function followsAction()
     {
         $this->redirect($this->_helper->url('follows', 'member', null, $this->getAllParams()));
     }
 
     public function followAction()
     {
         $this->_helper->layout->disableLayout();
 
         $this->view->authMember = $this->_authMember;
         $this->view->member_id = $this->_memberId;
 
         if ($this->_memberId == $this->_authMember->member_id) {
             return;
         }
 
         $memberFollowTable = new Default_Model_DbTable_MemberFollower();
 
         $newVals = array('member_id' => $this->_memberId, 'follower_id' => (int)$this->_authMember->member_id);
         $where = $memberFollowTable->select()->where('member_id = ?', $this->_memberId)
                                    ->where('follower_id = ?', $this->_authMember->member_id, 'INTEGER')
         ;
         $result = $memberFollowTable->fetchRow($where);
         if (null === $result) {
             $memberFollowTable->createRow($newVals)->save();
         }
     }
 
     public function unfollowAction()
     {
         $this->_helper->layout->disableLayout();
         $this->_helper->viewRenderer('follow');
 
         $memberFollowTable = new Default_Model_DbTable_MemberFollower();
 
         $memberFollowTable->delete('member_id=' . $this->_memberId . ' AND follower_id=' . $this->_authMember->member_id);
 
         $this->view->authMember = $this->_authMember;
         $this->view->member_id = $this->_memberId;
     }
 
     public function newsAction()
     {
         $this->productsAction();
         $this->render('products');
     }
 
     public function productsAction()
     {
         $pageLimit = 25;
         $page = (int)$this->getParam('page', 1);
 
         //create ppload download hash: secret + collection_id + expire-timestamp
         $salt = PPLOAD_DOWNLOAD_SECRET;
         $timestamp = time() + 3600; // one hour valid
         $hash = md5($salt . $timestamp); // order isn't important at all... just do the same when verifying
 
         $this->view->download_hash = $hash;
         $this->view->download_timestamp = $timestamp;
 
         $this->view->member_id = null;
         if (null != $this->_authMember && null != $this->_authMember->member_id) {
             $this->view->member_id = $this->_authMember->member_id;
         }
 
         $modelProject = new Default_Model_Project();
         $userProjects = $modelProject->fetchAllProjectsForMember($this->_authMember->member_id, $pageLimit, ($page - 1) * $pageLimit);
 
         $paginator = Local_Paginator::factory($userProjects);
         $paginator->setItemCountPerPage($pageLimit);
         $paginator->setCurrentPageNumber($page);
         $paginator->setTotalItemCount($modelProject->countAllProjectsForMember($this->_authMember->member_id));
 
         $this->view->products = $paginator;
         $modelMember = new Default_Model_Member();
         $this->view->member = $modelMember->fetchMemberData($this->_authMember->member_id);
     }
 
     public function activitiesAction()
     {
         $modelInfo = new Default_Model_Info();
         $this->view->member = $this->_authMember;
         $this->view->comments = $modelInfo->getLastCommentsForUsersProjects($this->_authMember->member_id);
         $this->view->votes = $modelInfo->getLastVotesForUsersProjects($this->_authMember->member_id);
         $this->view->donations = $modelInfo->getLastDonationsForUsersProjects($this->_authMember->member_id);
     }
 
     public function settingsAction()
     {
         $this->_helper->layout()->setLayout('settings');
     }
 
     public function reportAction()
     {
         $this->_helper->layout->disableLayout();
 
         $this->_helper->viewRenderer('product/add');
 
         $this->forward('report', 'product', null, $this->getAllParams());
     }
 
     public function paymentsAction()
     {
         $this->view->headScript()->setFile('');
         $this->view->headLink()->setStylesheet('');
 
         $member_id = $this->_authMember->member_id;
         $this->view->member = $this->_authMember;
 
         $tableMember = new Default_Model_Member();
         $this->view->hits = $tableMember->fetchPlingedProjects($member_id);
     }
 
     public function incomeAction()
     {
         $this->view->member = $this->_authMember;
         $tableMember = new Default_Model_Member();
         $modelPlings = new Default_Model_Pling();
         $this->view->donations = $modelPlings->fetchRecentDonationsForUser($this->_authMember->member_id);
     }
 
     public function tooltipAction()
     {
         $this->_helper->layout->disableLayout();
         $info = new Default_Model_Info();
         $data = $info->getTooptipForMember($this->_memberId);
         $this->_helper->json(array('status' => 'ok', 'data' => $data));
     }
 
     public function shareAction()
     {
         $this->_helper->layout->disableLayout();
 
         $modelProduct = new Default_Model_Member();
         $memberInfo = $modelProduct->fetchMemberData($this->_memberId);
         $form = new Default_Form_ProjectShare();
         $form->setAction('/member/' . $this->_memberId . '/share/');
 
         //        $helperBaseUrl = new Default_View_Helper_BaseUrl();
         //        $helperServerUrl = new Zend_View_Helper_ServerUrl();
         $helpMemberUrl = new Default_View_Helper_BuildMemberUrl();
         $this->view->permaLink = $helpMemberUrl->buildMemberUrl($memberInfo->username);
         //        $this->view->permaLink = $helperServerUrl->serverUrl() . $helperBaseUrl->baseUrl() . '/member/' . $this->_memberId . '/';
         if ($this->_request->isGet()) {
             $this->view->form = $form;
             $this->renderScript('product/share.phtml');
 
             return;
         }
 
         if (false === $form->isValid($_POST)) { // form not valid
             $this->view->form = $form;
             $dummy = $this->view->render('product/share.phtml');
             $this->_helper->json(array('status' => 'ok', 'message' => $dummy));
 
             return;
         }
 
         $values = $form->getValues();
 
         if (empty($memberInfo->firstname) and empty($memberInfo->lastname)) {
             $username = $memberInfo->username;
         } else {
             $username = $memberInfo->firstname . ' ' . $memberInfo->lastname;
         }
 
         $shareMail = new Default_Plugin_SendMail('tpl_social_mail_user');
         $shareMail->setTemplateVar('sender', $values['sender_mail']);
         $shareMail->setTemplateVar('username', $username);
         $shareMail->setTemplateVar('permalink', $this->view->permaLink);
         $shareMail->setTemplateVar('permalinktext', '<a href="' . $this->view->permaLink . '">View user\'s page</a>');
         $shareMail->setReceiverMail($values['mail']);
         $shareMail->send();
 
         $this->_helper->json(array('status' => 'ok', 'redirect' => $this->view->permaLink));
     }
 
     public function plingsAction()
     {
         $tableMember = new Default_Model_Member();
         $this->view->view_member = $tableMember->fetchMemberData($this->_memberId);
 
         $paypalValidStatusTable = new Default_Model_DbTable_PaypalValidStatus();
         $paypalValidStatus = $paypalValidStatusTable->find($this->view->view_member->paypal_valid_status)->current();
         $this->view->paypal_valid_status = $paypalValidStatus;
 
         //backdoor for admins
         $helperUserRole = new Backend_View_Helper_UserRole();
         $userRoleName = $helperUserRole->userRole();
         if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
             $this->view->member = $this->view->view_member;
         } else {
             $this->view->member = $this->_authMember;
         }
     }
 
     public function downloadhistoryAction()
     {
 
 
         $tableMember = new Default_Model_Member();
         $this->view->view_member = $tableMember->fetchMemberData($this->_memberId);
 
         //backdore for admins
         $helperUserRole = new Backend_View_Helper_UserRole();
         $userRoleName = $helperUserRole->userRole();
         if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
             $this->view->member = $this->view->view_member;
         } else {
             $this->view->member = $this->_authMember;
         }
 
         if ($this->view->member) {
             $this->view->paramPageId = (int)$this->getParam('page');
 
             //TODO do really sql paging instead of Zend_Paginator
             $dhistory = new Default_Model_DbTable_MemberDownloadHistory();
             $offset = $this->view->paramPageId;
             $list = $dhistory->getDownloadhistory($this->view->member->member_id);
             $list->setItemCountPerPage(250);
             $list->setCurrentPageNumber($offset);
             $this->view->downloadhistory = $list;
         } else {
             $this->view->downloadhistory = array();
         }
     }
 
     public function likesAction()
     {
 
         $tableMember = new Default_Model_Member();
         $this->view->view_member = $tableMember->fetchMemberData($this->_memberId);
 
         //backdore for admins
         $helperUserRole = new Backend_View_Helper_UserRole();
         $userRoleName = $helperUserRole->userRole();
         if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
             $this->view->member = $this->view->view_member;
         } else {
             $this->view->member = $this->_authMember;
         }
 
         if ($this->view->member) {
             $this->view->paramPageId = (int)$this->getParam('page');
             $model = new Default_Model_DbTable_ProjectFollower();
             $offset = $this->view->paramPageId;
             $list = $model->fetchLikesForMember($this->view->member->member_id);
             $list->setItemCountPerPage(250);
             $list->setCurrentPageNumber($offset);
             $this->view->likes = $list;
         } else {
             $this->view->likes = array();
         }
     }
 
     public function payoutAction()
     {
 
         $tableMember = new Default_Model_Member();
         $this->view->view_member = $tableMember->fetchMemberData($this->_memberId);
 
         //backdore for admins
         $helperUserRole = new Backend_View_Helper_UserRole();
         $userRoleName = $helperUserRole->userRole();
         if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) {
             $this->view->member = $this->view->view_member;
         } else {
             $this->view->member = $this->_authMember;
         }
     }
 
     /**
      * @return Default_Form_Settings
      * @throws Zend_Form_Exception
      */
     private function formPassword()
     {
         $form = new Default_Form_Settings();
         $form->setMethod("POST")->setAttrib("id", "settingsPasswordForm")->setAction('/member/' . $this->_memberId . '/changepass');
 
         $passOld = $form->createElement('password', 'passwordOld')->setLabel('Enter old Password:')->setRequired(true)
                         ->removeDecorator('HtmlTag')->addValidator(new Local_Validate_OldPasswordConfirm())->setDecorators(array(
                 'ViewHelper',
                 'Label',
                 'Errors',
                 array(
                     'ViewScript',
                     array(
                         'viewScript' => 'settings/viewscripts/flatui_input.phtml',
                         'placement'  => false
                     )
                 )
             ))
         ;
 
         $pass1 = $form->createElement('password', 'password1')->setLabel('Enter new Password:')->setRequired(true)
                       ->addValidator(new Zend_Validate_NotEmpty(Zend_Validate_NotEmpty::STRING))->removeDecorator('HtmlTag')
                       ->setDecorators(array(
                           'ViewHelper',
                           'Label',
                           'Errors',
                           array(
                               'ViewScript',
                               array(
                                   'viewScript' => 'settings/viewscripts/flatui_input.phtml',
                                   'placement'  => false
                               )
                           )
                       ))
         ;
 
         $pass2 = $form->createElement('password', 'password2')->setLabel('Re-enter new Password:')->setRequired(true)
                       ->addValidator(new Zend_Validate_NotEmpty(Zend_Validate_NotEmpty::STRING))->removeDecorator('HtmlTag')
                       ->setDecorators(array(
                           'ViewHelper',
                           'Label',
                           'Errors',
                           array(
                               'ViewScript',
                               array(
                                   'viewScript' => 'settings/viewscripts/flatui_input.phtml',
                                   'placement'  => false
                               )
                           )
                       ))
         ;
 
         $passValid = new Local_Validate_PasswordConfirm($pass2->getValue());
         $pass1->addValidator($passValid);
 
         $form->addElement($passOld)->addElement($pass1)->addElement($pass2);
 
         return $form;
     }
 
 }
\ No newline at end of file
diff --git a/application/modules/default/models/Project.php b/application/modules/default/models/Project.php
index ff17af7e0..63d25b3ce 100644
--- a/application/modules/default/models/Project.php
+++ b/application/modules/default/models/Project.php
@@ -1,1665 +1,1739 @@
 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 class Default_Model_Project extends Default_Model_DbTable_Project
 {
 
     const FILTER_NAME_PROJECT_ID_NOT_IN = 'project_id_not_in';
     const FILTER_NAME_RANKING = 'ranking';
     const FILTER_NAME_CATEGORY = 'category';
     const FILTER_NAME_PACKAGETYPE = 'package_type';
     const FILTER_NAME_ORIGINAL = 'original';
     const FILTER_NAME_MEMBER = 'member';
     const FILTER_NAME_ORDER = 'order';
     const FILTER_NAME_LOCATION = 'location';
 
     const ITEM_TYPE_DUMMY = 0;
     const ITEM_TYPE_PRODUCT = 1;
     const ITEM_TYPE_UPDATE = 2;
 
     const TAG_LICENCE_GID = 7;
     const TAG_TYPE_ID = 1;
 
     /**
      * @param int $status
      * @param int $id
      *
      * @throws Exception
      */
     public function setStatus($status, $id)
     {
         if (false === in_array($status, $this->_allowedStatusTypes)) {
             throw new Exception('Wrong value for project status.');
         }
         $updateValues = array(
             'status'     => $status,
             'changed_at' => new Zend_Db_Expr('Now()')
         );
 
         if (self::PROJECT_DELETED == $status) {
             $updateValues['deleted_at'] = new Zend_Db_Expr('NOW()');
         }
 
         $this->update($updateValues, $this->_db->quoteInto('project_id=?', $id, 'INTEGER'));
     }
 
     /**
      * @param int $member_id
      * @param int $id
      */
     public function setClaimedByMember($member_id, $id)
     {
         $updateValues = array(
             'claimed_by_member' => $member_id,
             'changed_at'        => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, $this->_db->quoteInto('project_id=?', $id, 'INTEGER'));
     }
 
     /**
      * @param int $id
      */
     public function resetClaimedByMember($id)
     {
         $updateValues = array(
             'claimed_by_member' => new Zend_Db_Expr('NULL'),
             'changed_at'        => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, $this->_db->quoteInto('project_id=?', $id, 'INTEGER'));
     }
 
     /**
      * @param int $id
      */
     public function transferClaimToMember($id)
     {
         $updateValues = array(
             'member_id'         => new Zend_Db_Expr('claimed_by_member'),
             'claimable'         => new Zend_Db_Expr('NULL'),
             'claimed_by_member' => new Zend_Db_Expr('NULL')
         );
 
         $this->update($updateValues, $this->_db->quoteInto('project_id=? and claimable = 1', $id, 'INTEGER'));
     }
 
     /**
      * @param int $project_id
      * @param     $member_id
      *
      * @throws Zend_Db_Statement_Exception
      * @throws Zend_Exception
      */
     public function setInActive($project_id, $member_id)
     {
         $project_id = (int)$project_id;
         $updateValues = array(
             'status'     => self::PROJECT_INACTIVE,
             'deleted_at' => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, 'status > 40 AND project_id=' . $project_id);
 
         $this->setInActiveForUpdates($project_id);
         $this->setDeletedForComments($member_id,$project_id);
     }
 
     /**
      * @param int $id
      */
     protected function setInActiveForUpdates($id)
     {
         $id = (int)$id;
         $updateValues = array(
             'status'     => self::PROJECT_INACTIVE,
             'changed_at' => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, 'status > 40 AND pid=' . $id);
     }
 
     /**
      * @param int $member_id
      * @param int $id
      *
      * @throws Zend_Db_Statement_Exception
      * @throws Zend_Exception
      */
     private function setDeletedForComments($member_id, $id)
     {
         $modelComments = new Default_Model_ProjectComments();
         $modelComments->setAllCommentsForProjectDeleted($member_id, $id);
     }
 
     /**
      * @param int $id
      *
      * @return mixed
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchActiveBySourcePk($id)
     {
         $q = $this->select()->where('status = ?', self::PROJECT_ACTIVE)->where('source_pk = ?', (int)$id)
                   ->where('source_type = "project"')
         ;
 
         return $q->query()->fetch();
     }
 
     /**
      * @param int  $member_id
      * @param bool $onlyActiveProjects
      *
      * @return mixed
      */
     public function countAllProjectsForMember($member_id, $onlyActiveProjects = false)
     {
         $q = $this->select()->from($this, array('countAll' => new Zend_Db_Expr('count(*)')))->setIntegrityCheck(false)
                   ->where('project.status >= ?', ($onlyActiveProjects ? self::PROJECT_ACTIVE : self::PROJECT_INACTIVE))
                   ->where('project.member_id = ?', $member_id, 'INTEGER')->where('project.type_id = ?', self::PROJECT_TYPE_STANDARD)
         ;
         $resultSet = $q->query()->fetchAll();
 
         return $resultSet[0]['countAll'];
     }
 
     /**
      * @param int  $member_id
      * @param bool $onlyActiveProjects
      * @param      $catids
      *
      * @return mixed
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     public function countAllProjectsForMemberCatFilter($member_id, $onlyActiveProjects = false, $catids = null)
     {
         $q = $this->select()->from($this, array('countAll' => new Zend_Db_Expr('count(*)')))->setIntegrityCheck(false)
                   ->where('project.status >= ?', ($onlyActiveProjects ? self::PROJECT_ACTIVE : self::PROJECT_INACTIVE))
                   ->where('project.member_id = ?', $member_id, 'INTEGER')->where('project.type_id = ?', self::PROJECT_TYPE_STANDARD)
         ;
         if (isset($catids)) {
             $q->where('project_category_id in (' . $this->_getCatIds($catids) . ')');
         }
         $resultSet = $q->query()->fetchAll();
 
         return $resultSet[0]['countAll'];
     }
 
     /**
      * @param $catids
      *
      * @return string
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     protected function _getCatIds($catids)
     {
         $sqlwhereCat = "";
         $sqlwhereSubCat = "";
 
         $idCategory = explode(',', $catids);
         if (false === is_array($idCategory)) {
             $idCategory = array($idCategory);
         }
 
         $sqlwhereCat .= implode(',', $idCategory);
 
         $modelCategory = new Default_Model_DbTable_ProjectCategory();
         $subCategories = $modelCategory->fetchChildElements($idCategory);
 
         if (count($subCategories) > 0) {
             foreach ($subCategories as $element) {
                 $sqlwhereSubCat .= "{$element['project_category_id']},";
             }
         }
 
         return $sqlwhereSubCat . $sqlwhereCat;
     }
 
     /**
      * By default it will show all projects for a member included the unpublished elements.
      *
      * @param int      $member_id
      * @param int|null $limit
      * @param int|null $offset
      * @param bool     $onlyActiveProjects
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchAllProjectsForMember($member_id, $limit = null, $offset = null, $onlyActiveProjects = false)
     {
         $q = $this->select()->from($this, array(
             '*',
             'project_validated'  => 'project.validated',
             'project_uuid'       => 'project.uuid',
             'project_status'     => 'project.status',
             'project_created_at' => 'project.created_at',
             'project_changed_at' => 'project.changed_at',
             'member_type'        => 'member.type',
             'project_member_id'  => 'member_id',
             'laplace_score'      => new Zend_Db_Expr('laplace_score(count_likes,count_dislikes)'),
             'catTitle'           => new Zend_Db_Expr('(SELECT title FROM project_category WHERE project_category_id = project.project_category_id)')
         ))->setIntegrityCheck(false)->join('member', 'project.member_id = member.member_id', array('username'))
                   ->where('project.status >= ?', ($onlyActiveProjects ? self::PROJECT_ACTIVE : self::PROJECT_INACTIVE))
                   ->where('project.member_id = ?', $member_id, 'INTEGER')->where('project.type_id = ?', self::PROJECT_TYPE_STANDARD)
                   ->order('project_changed_at DESC')
         ;
         if (isset($limit)) {
             $q->limit($limit, $offset);
         }
 
         return $this->generateRowSet($q->query()->fetchAll());
     }
 
 
     /**
      * @param array $data
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     protected function generateRowSet($data)
     {
         $classRowSet = $this->getRowsetClass();
 
         return new $classRowSet(array(
             'table'    => $this,
             'rowClass' => $this->getRowClass(),
             'stored'   => true,
             'data'     => $data
         ));
     }
 
     /**
      * By default it will show all projects for a member included the unpublished elements.
      *
      * @param int      $member_id
      * @param int|null $limit
      * @param int|null $offset
      * @param bool     $onlyActiveProjects
      *
      * @param null     $catids
      *
      * @return Zend_Db_Table_Rowset_Abstract
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchAllProjectsForMemberCatFilter(
         $member_id,
         $limit = null,
         $offset = null,
         $onlyActiveProjects = false,
         $catids = null
     ) {
         $q = $this->select()->from($this, array(
             '*',
             'project_validated'  => 'project.validated',
             'project_uuid'       => 'project.uuid',
             'project_status'     => 'project.status',
             'project_created_at' => 'project.created_at',
             'project_changed_at' => 'project.changed_at',
             'member_type'        => 'member.type',
             'project_member_id'  => 'member_id',
             'laplace_score'      => new Zend_Db_Expr('laplace_score(count_likes,count_dislikes)'),
             'catTitle'           => new Zend_Db_Expr('(SELECT title FROM project_category WHERE project_category_id = project.project_category_id)')
         ))->setIntegrityCheck(false)->join('member', 'project.member_id = member.member_id', array('username'))
                   ->where('project.status >= ?', ($onlyActiveProjects ? self::PROJECT_ACTIVE : self::PROJECT_INACTIVE))
                   ->where('project.member_id = ?', $member_id, 'INTEGER')->where('project.type_id = ?', self::PROJECT_TYPE_STANDARD)
                   ->order('project_changed_at DESC')
         ;
 
         if (isset($catids)) {
             $q->where('project_category_id in (' . $this->_getCatIds($catids) . ')');
         }
 
         if (isset($limit)) {
             $q->limit($limit, $offset);
         }
 
         return $this->generateRowSet($q->query()->fetchAll());
     }
 
     /**
      * @param $collection_id
      *
      * @return null|Zend_Db_Table_Row_Abstract
      */
     public function fetchProductForCollectionId($collection_id)
     {
         $sql = '
                 SELECT
                   `p`.*
                 FROM `project` AS `p`
                 WHERE 
                   `p`.`ppload_collection_id` = :collectionId
                   AND `p`.`status` >= :projectStatus AND `p`.`type_id` = :typeId
         ';
         $result = $this->_db->fetchRow($sql, array(
             'collectionId'  => $collection_id,
             'projectStatus' => self::PROJECT_INACTIVE,
             'typeId'        => self::PROJECT_TYPE_STANDARD
         ));
 
         if ($result) {
             return $this->generateRowClass($result);
         } else {
             return null;
         }
     }
 
     /**
      * @param int $project_id
      *
      * @return null|Zend_Db_Table_Row_Abstract
      */
     public function fetchProductInfo($project_id)
     {
         $sql = '
                 SELECT
                   `p`.*,
                   `p`.`validated` AS `project_validated`,
                   `p`.`uuid` AS `project_uuid`,
                   `p`.`status` AS `project_status`,
                   `p`.`created_at` AS `project_created_at`,
                   `p`.`changed_at` AS `project_changed_at`,
                   `p`.`member_id` AS `project_member_id`,
                   `p`.`source_pk` AS `project_source_pk`,
                   `p`.`version` AS `project_version`,
                   `pc`.`title` AS `cat_title`,
                   `m`.`username`,
                   `m`.`avatar`,
                   `m`.`profile_image_url`,
                   `m`.`roleId`,
                   `m`.`mail`,
                   `m`.`paypal_mail`,
                   `m`.`dwolla_id`,
                   laplace_score(`p`.`count_likes`,`p`.`count_dislikes`) AS `laplace_score`,
                  `view_reported_projects`.`amount_reports` AS `amount_reports`,
                 (SELECT `tag`.`tag_fullname` FROM `tag_object`, `tag` WHERE `tag_object`.`tag_id`=`tag`.`tag_id` AND `tag_object_id` = `p`.`project_id` AND `tag_object`.`is_deleted`=0 AND `tag_group_id` = :tag_licence_gid AND `tag_type_id` = :tag_type_id  ORDER BY `tag_object`.`tag_created` DESC LIMIT 1)
                                 AS `project_license_title`
                 FROM `project` AS `p`
                   JOIN `member` AS `m` ON `p`.`member_id` = `m`.`member_id` AND `m`.`is_active` = 1 AND `m`.`is_deleted` = 0
                   JOIN `project_category` AS `pc` ON `p`.`project_category_id` = `pc`.`project_category_id`
                   LEFT JOIN `view_reported_projects` ON ((`view_reported_projects`.`project_id` = `p`.`project_id`))                  
                 WHERE 
                   `p`.`project_id` = :projectId
                   AND `p`.`status` >= :projectStatus AND `p`.`type_id` = :typeId
         ';
         $result = $this->_db->fetchRow($sql, array(
             'projectId'       => $project_id,
             'projectStatus'   => self::PROJECT_INACTIVE,
             'typeId'          => self::PROJECT_TYPE_STANDARD,
             'tag_licence_gid' => self::TAG_LICENCE_GID,
             'tag_type_id'     => self::TAG_TYPE_ID
 
         ));
 
         if ($result) {
             return $this->generateRowClass($result);
         } else {
             return null;
         }
     }
 
     /**
      * @param int $project_id
      *
      * @return null|Zend_Db_Table_Row_Abstract
      */
     public function fetchProductInfo_($project_id)
     {
         $sql = '
                 SELECT
                   `p`.*,
                   `p`.`validated` AS `project_validated`,
                   `p`.`uuid` AS `project_uuid`,
                   `p`.`status` AS `project_status`,
                   `p`.`created_at` AS `project_created_at`,
                   `p`.`changed_at` AS `project_changed_at`,
                   `p`.`member_id` AS `project_member_id`,
                   `p`.`source_pk` AS `project_source_pk`,
                   `p`.`version` AS `project_version`,
                   `pc`.`title` AS `cat_title`,
                   `m`.`username`,
                   `m`.`avatar`,
                   `m`.`profile_image_url`,
                   `m`.`roleId`,
                   `m`.`mail`,
                   `m`.`paypal_mail`,
                   `m`.`dwolla_id`,
                   laplace_score(`p`.`count_likes`,`p`.`count_dislikes`) AS `laplace_score`,
                  `view_reported_projects`.`amount_reports` AS `amount_reports`,
                 `project_license`.`title` AS `project_license_title`
                 FROM `project` AS `p`
                   JOIN `member` AS `m` ON `p`.`member_id` = `m`.`member_id` AND `m`.`is_active` = 1 AND `m`.`is_deleted` = 0
                   JOIN `project_category` AS `pc` ON `p`.`project_category_id` = `pc`.`project_category_id`
                   LEFT JOIN `view_reported_projects` ON ((`view_reported_projects`.`project_id` = `p`.`project_id`))
                   LEFT JOIN `project_license` ON ((`project_license`.`project_license_id` = `p`.`project_license_id`))
                 WHERE 
                   `p`.`project_id` = :projectId
                   AND `p`.`status` >= :projectStatus AND `p`.`type_id` = :typeId
         ';
         $result = $this->_db->fetchRow($sql, array(
             'projectId'     => $project_id,
             'projectStatus' => self::PROJECT_INACTIVE,
             'typeId'        => self::PROJECT_TYPE_STANDARD
         ));
 
         if ($result) {
             return $this->generateRowClass($result);
         } else {
             return null;
         }
     }
 
     /**
      * @param $project_id
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchProjectUpdates($project_id)
     {
         $projectSel = $this->select()->setIntegrityCheck(false)->from($this->_name)
                            ->join('member', 'project.member_id = member.member_id', array('*'))
                            ->where('project.pid=?', $project_id, 'INTEGER')->where('project.status>?', self::PROJECT_INACTIVE)
                            ->where('project.type_id=?', self::PROJECT_TYPE_UPDATE)->order('RAND()')
         ;
 
         return $this->fetchAll($projectSel);
     }
 
     /**
      * @param $project_id
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchAllProjectUpdates($project_id)
     {
         $projectSel = $this->select()->setIntegrityCheck(false)->from($this->_name)->where('project.pid=?', $project_id, 'INTEGER')
                            ->where('project.status>?', self::PROJECT_INACTIVE)->where('project.type_id=?', self::PROJECT_TYPE_UPDATE)
         ;
 
         return $this->fetchAll($projectSel);
     }
 
     /**
      * @param     $project
      * @param int $count
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchSimilarProjects($project, $count = 10)
     {
         $count = (int)$count;
         $sql = "
                 SELECT *
                 FROM `stat_projects` AS `p`
                 WHERE `p`.`project_category_id` = :cat_id AND `project_id` <> :project_id
                 ORDER BY `p`.`changed_at` DESC
                 LIMIT {$count}
         ";
 
         $result = $this->_db->fetchAll($sql, array(
                 'cat_id'     => $project->project_category_id,
                 'project_id' => $project->project_id
             ));
 
         return $this->generateRowSet($result);
     }
 
     /**
      * @param Zend_Db_Table_Row $project
      * @param int               $count
      *
      * @return Zend_Db_Table_Rowset_Abstract
      * @throws Zend_Exception
      */
     public function fetchMoreProjects($project, $count = 6)
     {
         $q = $this->select()->from('stat_projects', array(
             'project_id',
             'image_small',
             'title',
             'catTitle' => 'cat_title'
         ))->setIntegrityCheck(false)
           ->where('status = ?', self::PROJECT_ACTIVE)
           ->where('member_id = ?', $project->member_id, 'INTEGER')
           ->where('project_id != ?', $project->project_id, 'INTEGER')
           ->where('type_id = ?', self::PROJECT_TYPE_STANDARD)
           ->where('amount_reports is null')
           ->where('project_category_id = ?', $project->project_category_id, 'INTEGER')
           ->limit($count)
           ->order('project_created_at DESC')
         ;
 
         $storeConfig = Zend_Registry::isRegistered('store_config') ? Zend_Registry::get('store_config') : null;
         $storePackageTypeIds = null;
         if ($storeConfig) {
             $storePackageTypeIds = $storeConfig->package_type;
         }
 
         if ($storePackageTypeIds) {
             $q = $this->generatePackageTypeFilter($q, array(self::FILTER_NAME_PACKAGETYPE => $storePackageTypeIds));
         }
 
         $result = $this->fetchAll($q);
 
         return $result;
     }
 
 
     /**
      * @param Zend_Db_Select $statement
      * @param array          $filterArrayValue
      *
      * @return Zend_Db_Select
      */
     protected function generatePackageTypeFilter(Zend_Db_Select $statement, $filterArrayValue)
     {
         if (false == isset($filterArrayValue[self::FILTER_NAME_PACKAGETYPE])) {
             return $statement;
         }
 
         $filter = $filterArrayValue[self::FILTER_NAME_PACKAGETYPE];
 
         if (is_array($filter)) {
             $statement->join(array(
                 'package_type' => new Zend_Db_Expr('(SELECT DISTINCT project_id FROM project_package_type WHERE package_type_id in ('
                     . $filter . '))')
             ), 'project.project_id = package_type.project_id', array());
         } else {
             $statement->where('find_in_set(?, package_types)', $filter);
         }
 
         return $statement;
     }
 
     /**
      * @param     $project
      * @param int $count
      *
      * @return Zend_Db_Table_Rowset_Abstract
      * @throws Zend_Db_Statement_Exception
      * @throws Zend_Exception
      * @todo improve processing speed
      */
     public function fetchMoreProjectsOfOtherUsr($project, $count = 8)
     {
         $sql = "
                 SELECT count(1) AS `count`
                 FROM `stat_projects`
                 WHERE `status` = :current_status
                   AND `member_id` <> :current_member_id
                   AND `project_category_id` = :category_id
                   AND `type_id` = :project_type
         ";
 
         $result = $this->_db->query($sql, array(
             'current_status'    => self::PROJECT_ACTIVE,
             'current_member_id' => $project->member_id,
             'category_id'       => $project->project_category_id,
             'project_type'      => self::PROJECT_TYPE_STANDARD
         ))->fetch()
         ;
 
         if ($result['count'] > $count) {
             $offset = rand(0, $result['count'] - $count);
         } else {
             $offset = 0;
         }
 
         $q = $this->select()->from('stat_projects', array(
             'project_id',
             'image_small',
             'title',
             'catTitle' => 'cat_title'
         ))->setIntegrityCheck(false)->where('status = ?', self::PROJECT_ACTIVE)
                   ->where('member_id != ?', $project->member_id, 'INTEGER')->where('type_id = ?', 1)
                   ->where('amount_reports is null')
                   ->where('project_category_id = ?', $project->project_category_id, 'INTEGER')->limit($count, $offset)
                   ->order('project_created_at DESC')
         ;
 
         $storeConfig = Zend_Registry::isRegistered('store_config') ? Zend_Registry::get('store_config') : null;
         $storePackageTypeIds = null;
         if ($storeConfig) {
             $storePackageTypeIds = $storeConfig->package_type;
         }
 
         if ($storePackageTypeIds) {
             $q = $this->generatePackageTypeFilter($q, array(self::FILTER_NAME_PACKAGETYPE => $storePackageTypeIds));
         }
 
         Zend_Registry::get('logger')->debug(__METHOD__ . ' - ' . $q->__toString());
 
         $result = $this->fetchAll($q);
 
         return $result;
     }
 
     /**
      * @param int $project_id
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchProjectSupporter($project_id)
     {
         $plingTable = new Default_Model_DbTable_Plings();
 
         return $plingTable->getSupporterForProjectId($project_id);
     }
 
     /**
      * @param int $project_id
      *
      * @return Zend_Db_Table_Rowset_Abstract
      */
     public function fetchProjectSupporterWithPlings($project_id)
     {
         $plingTable = new Default_Model_DbTable_Plings();
 
         return $plingTable->getSupporterWithPlingsForProjectId($project_id);
     }
 
     /**
      * @param $projectId
      * @param $sources
      */
     public function updateGalleryPictures($projectId, $sources)
     {
         $galleryPictureTable = new Default_Model_DbTable_ProjectGalleryPicture();
         $galleryPictureTable->clean($projectId);
         $galleryPictureTable->insertAll($projectId, $sources);
     }
 
     /**
      * @param $projectId
      *
      * @return array
      */
     public function getGalleryPictureSources($projectId)
     {
         $galleryPictureTable = new Default_Model_DbTable_ProjectGalleryPicture();
         $stmt = $galleryPictureTable->select()->where('project_id = ?', $projectId)->order(array('sequence'));
 
         $pics = array();
         foreach ($galleryPictureTable->fetchAll($stmt) as $pictureRow) {
             $pics[] = $pictureRow['picture_src'];
         }
 
         return $pics;
     }
 
     /**
      * @param int $project_id
      *
      * @return array
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchProjectViews($project_id)
     {
         $sql = "
                 SELECT
                     `project_id`,
                     `count_views`,
                     `count_visitor`,
                     `last_view`
                 FROM
                     `stat_page_views_mv`
                 WHERE `project_id` = ?
                 ";
         $database = Zend_Db_Table::getDefaultAdapter();
         $sql = $database->quoteInto($sql, $project_id, 'INTEGER', 1);
         $resultSet = $database->query($sql)->fetchAll();
 
         if (count($resultSet) > 0) {
             $result = $resultSet[0]['count_views'];
         } else {
             $result = 0;
         }
 
         return $result;
     }
 
     /**
      * @param int $member_id
      *
      * @return int
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchOverallPageViewsByMember($member_id)
     {
         $sql = "
                 SELECT sum(`stat`.`amount`) AS `page_views`
                 FROM `project`
                 JOIN (SELECT `project_id`, count(`project_id`) AS `amount` FROM `stat_page_views` GROUP BY `project_id`) AS `stat` ON `stat`.`project_id` = `project`.`project_id`
                 WHERE `project`.`member_id` = :member_id AND `project`.`status` = :project_status
                 GROUP BY `member_id`
               ";
 
         $result = $this->_db->query($sql, array('member_id' => $member_id, 'project_status' => self::PROJECT_ACTIVE));
         if ($result->rowCount() > 0) {
             $row = $result->fetch();
 
             return $row['page_views'];
         } else {
             return 0;
         }
     }
 
     /**
      * @return array
      * @throws Zend_Db_Statement_Exception
      */
     public function getStatsForNewProjects()
     {
         $sql = "
                 SELECT
                     DATE_FORMAT(`time`, '%M %D') AS `projectdate`,
                     count(1) AS `daycount`
                 FROM
                     `activity_log`
                 WHERE
                     `activity_type_id` = 0
                 GROUP BY DATE_FORMAT(`time`, '%Y%M%D')
                 ORDER BY `time` DESC
                 LIMIT 14
                 ;";
         $database = Zend_Db_Table::getDefaultAdapter();
         $resultSet = $database->query($sql)->fetchAll();
 
         return $resultSet;
     }
 
     /**
      * @param int     $idCategory
      * @param int|null $limit
      *
      * @return Zend_Db_Table_Rowset_Abstract
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchProductsByCategory($idCategory, $limit = null)
     {
         $select =
             $this->select()->setIntegrityCheck(false)->from($this->_name)->where('project.project_category_id in (?)', $idCategory)
                  ->where('project.status = ?', self::PROJECT_ACTIVE)->where('project.type_id = ?', self::PROJECT_TYPE_STANDARD)
                  ->joinLeft(array(
                      'pling_amount' => new Zend_Db_Expr('(SELECT
                 project_id as plinged_project_id, SUM(amount) AS sumAmount, count(1) as countPlings
             FROM
                 plings
             where status_id >= 2
             group by project_id
             order by sumAmount DESC)')
                  ), 'pling_amount.plinged_project_id = project.project_id')
                  ->joinLeft('project_category', 'project_category.project_category_id = project.project_category_id',
                      array('cat_title' => 'title'))->order('pling_amount.sumAmount DESC')
         ;
         if (false === is_null($limit)) {
             $select->limit($limit);
         }
 
         $modelCategory = new Default_Model_DbTable_ProjectCategory();
         $subCategories = $modelCategory->fetchChildElements($idCategory);
 
         if (count($subCategories) > 0) {
             $sqlwhere = '';
             foreach ($subCategories as $element) {
                 $sqlwhere .= "{$element['project_category_id']},";
             }
             $sqlwhere = substr($sqlwhere, 0, -1);
             if (!empty($sqlwhere)) {
                 $sqlwhere = explode(',', $sqlwhere);
             }
 
             $select->orWhere('project.project_category_id in (?)', $sqlwhere);
         }
 
         return $this->fetchAll($select);
     }
 
     /**
      * @param int|array $idCategory id of a category or an array of id's
      * @param bool      $withSubCat if was set true it will also count products in sub categories
      * @param null      $store_id
      *
      * @return int count of products in given category
      * @throws Zend_Exception
      * @deprecated
      */
     public function countProductsInCategory($idCategory = null, $withSubCat = true, $store_id = null)
     {
         if (empty($idCategory)) {
             throw new Zend_Exception('idCategory param was not set');
         }
 
         if (false == is_array($idCategory)) {
             $idCategory = array($idCategory);
         }
 
         if (isset($store_id)) {
             $configurations = Zend_Registry::get('application_store_config_id_list');
             $store_config = isset($configurations[$store_id]) ? $configurations[$store_id] : null;
         } else {
             $store_config = Zend_Registry::isRegistered('store_config') ? Zend_Registry::get('store_config') : null;
         }
         $storePackageTypeIds = (false === empty($store_config->package_type)) ? $store_config->package_type : null;
 
         $cacheName = __FUNCTION__ . '_' . md5(serialize($idCategory) . $withSubCat . serialize($storePackageTypeIds));
         /** @var Zend_Cache_Core $cache */
         $cache = Zend_Registry::get('cache');
 
         if (false !== ($resultSet = $cache->load($cacheName))) {
             return (int)$resultSet[0]['count_active_projects'];
         }
 
         $select = $this->select()->setIntegrityCheck(false)->from('stat_projects', array('count_active_projects' => 'COUNT(1)'))
                        ->where('status = ? ', self::PROJECT_ACTIVE)->where('type_id = ?', self::PROJECT_TYPE_STANDARD)
         ;
 
         $select = $this->generatePackageTypeFilter($select, array(self::FILTER_NAME_PACKAGETYPE => $storePackageTypeIds));
 
         if ($withSubCat) {
             $modelCategory = new Default_Model_DbTable_ProjectCategory();
             $subCategories = $modelCategory->fetchChildIds($idCategory);
             $inCategories = implode(',', array_unique(array_merge($idCategory, $subCategories)));
         } else {
             $inCategories = implode(',', $idCategory);
         }
 
         $select->where('project_category_id in (' . $inCategories . ')');
         $resultSet = $this->fetchAll($select)->toArray();
 
         $cache->save($resultSet, $cacheName, array(), 60);
 
         return (int)$resultSet[0]['count_active_projects'];
     }
 
     /**
      * @param int|array $idCategory
      *
      * @return int
      * @throws Zend_Exception
      */
     public function countActiveMembersForCategory($idCategory)
     {
 
         $cacheName = __FUNCTION__ . md5(serialize($idCategory));
         $cache = Zend_Registry::get('cache');
 
         $result = $cache->load($cacheName);
 
         if ($result) {
             return (int)$result['count_active_members'];
         }
 
         $sqlwhereCat = "";
         $sqlwhereSubCat = "";
 
         if (false === is_array($idCategory)) {
             $idCategory = array($idCategory);
         }
         $sqlwhereCat .= implode(',', $idCategory);
 
         $modelCategory = new Default_Model_DbTable_ProjectCategory();
         $subCategories = $modelCategory->fetchChildElements($idCategory);
 
         if (count($subCategories) > 0) {
             foreach ($subCategories as $element) {
                 $sqlwhereSubCat .= "{$element['project_category_id']},";
             }
         }
 
         $selectWhere = 'AND p.project_category_id in (' . $sqlwhereSubCat . $sqlwhereCat . ')';
 
         $sql = "SELECT count(1) AS `count_active_members` FROM (                    
                     SELECT count(1) AS `count_active_projects` FROM `project` `p`
                     WHERE `p`.`status` = 100
                     AND `p`.`type_id` = 1
                     {$selectWhere} GROUP BY p.member_id
                 ) AS `A`;";
 
         $result = $this->_db->fetchRow($sql);
         $cache->save($result, $cacheName);
 
         return (int)$result['count_active_members'];
     }
 
     /**
      * @param int $project_id
      *
      * @return bool
      */
     public function isProjectFeatured($project_id)
     {
         $sql_object =
             "SELECT `project_id` FROM `project` WHERE `project_id`= :project_id AND  `status` = 100 AND `type_id` = 1 AND `featured` = 1";
         $r = $this->getAdapter()->fetchRow($sql_object, array('project_id' => $project_id));
         if ($r) {
             return true;
         } else {
             return false;
         }
     }
 
     /**
      * @return mixed
      */
     public function fetchTotalProjectsCount()
     {
         $sql =
             "SELECT count(1) AS `total_project_count` FROM `project` WHERE `project`.`status` = :status AND `project`.`type_id` = :ptype";
 
         $result = $this->_db->fetchRow($sql, array('status' => self::PROJECT_ACTIVE, 'ptype' => self::PROJECT_TYPE_STANDARD));
 
         return $result['total_project_count'];
     }
 
     /**
      * @param $member_id
      *
      * @throws Zend_Db_Statement_Exception
      * @throws Zend_Exception
      */
     public function setAllProjectsForMemberDeleted($member_id)
     {
         $sql =
             "SELECT `project_id` FROM `project` WHERE `member_id` = :memberId AND `type_id` = :typeId AND `status` > :project_status";
         $projectForDelete = $this->_db->fetchAll($sql, array(
             'memberId'       => $member_id,
             'typeId'         => self::PROJECT_TYPE_STANDARD,
             'project_status' => self::PROJECT_DELETED
         ));
         foreach ($projectForDelete as $item) {
             $this->setDeleted($member_id, $item['project_id']);
         }
 
         // set personal page deleted
         $sql = "SELECT project_id FROM project WHERE member_id = :memberId AND type_id = :typeId";
         $projectForDelete = $this->_db->fetchAll($sql, array(
             'memberId' => $member_id,
             'typeId'   => self::PROJECT_TYPE_PERSONAL
         ));
         foreach ($projectForDelete as $item) {
             $this->setDeleted($member_id, $item['project_id']);
         }
         /*
         $sql = "UPDATE project SET `status` = :statusCode, deleted_at = NOW() WHERE member_id = :memberId AND type_id = :typeId";
         $this->_db->query($sql, array(
             'statusCode' => self::PROJECT_DELETED,
             'memberId'   => $member_id,
             'typeId'     => self::PROJECT_TYPE_PERSONAL
         ))->execute();
         */
     }
 
     /**
      * @param int $member_id
      * @param int $id
      *
      * @throws Zend_Db_Statement_Exception
      * @throws Zend_Exception
      */
     public function setDeleted($member_id, $id)
     {
         $id = (int)$id;
         $updateValues = array(
             'status'     => self::PROJECT_DELETED,
             'deleted_at' => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, 'status > 30 AND project_id=' . $id);
 
         $memberLog = new Default_Model_MemberDeactivationLog();
         $memberLog->logProjectAsDeleted($member_id, $id);
 
         $this->setDeletedForUpdates($member_id, $id);
         $this->setDeletedForComments($member_id, $id);
         $this->setDeletedInMaterializedView($id);
     }
 
     /**
      * @param     $member_id
      * @param int $id
      */
     protected function setDeletedForUpdates($member_id, $id)
     {
         $id = (int)$id;
         $updateValues = array(
             'status'     => self::PROJECT_DELETED,
             'deleted_at' => new Zend_Db_Expr('Now()')
         );
 
         $this->update($updateValues, 'status > 30 AND pid=' . $id);
     }
 
     /**
      * @param $id
      *
      * @throws Zend_Db_Statement_Exception
      */
     private function setDeletedInMaterializedView($id)
     {
         $sql = "UPDATE `stat_projects` SET `status` = :new_status WHERE `project_id` = :project_id";
 
         $result = $this->_db->query($sql, array('new_status' => self::PROJECT_DELETED, 'project_id' => $id))->execute();
     }
 
     /**
      * @param int $member_id
      *
      * @throws Zend_Exception
      */
     public function setAllProjectsForMemberActivated($member_id)
     {
         $sql = "SELECT `p`.`project_id` FROM `project` `p`
                 JOIN `member_deactivation_log` `l` ON `l`.`object_type_id` = 3 AND `l`.`object_id` = `p`.`project_id` AND `l`.`deactivation_id` = `p`.`member_id`
                 WHERE `p`.`member_id` = :memberId";
         $projectForDelete = $this->_db->fetchAll($sql, array(
             'memberId' => $member_id
         ));
         foreach ($projectForDelete as $item) {
             $this->setActive($member_id, $item['project_id']);
         }
     }
 
     /**
      * @param int $member_id
      * @param int $id
      *
      * @throws Zend_Exception
      */
     public function setActive($member_id, $id)
     {
         $updateValues = array(
             'status'     => self::PROJECT_ACTIVE,
             'deleted_at' => null
         );
 
         $this->update($updateValues, $this->_db->quoteInto('project_id=?', $id, 'INTEGER'));
 
         $memberLog = new Default_Model_MemberDeactivationLog();
         $memberLog->removeLogProjectAsDeleted($member_id, $id);
 
         $this->setActiveForUpdates($member_id, $id);
         $this->setActiveForComments($member_id, $id);
     }
 
     /**
      * @param int $id
      */
     protected function setActiveForUpdates($member_id, $id)
     {
         $updateValues = array(
             'status'     => self::PROJECT_ACTIVE,
             'deleted_at' => null
         );
 
         $this->update($updateValues, $this->_db->quoteInto('pid=?', $id, 'INTEGER'));
     }
 
     /**
      * @param int $member_id
      * @param int $project_id
      */
     private function setActiveForComments($member_id, $project_id)
     {
         $modelComments = new Default_Model_ProjectComments();
         $modelComments->setAllCommentsForProjectActivated($member_id, $project_id);
     }
 
     /**
      * @param array    $inputFilterParams
      * @param int|null $limit
      * @param int|null $offset
      *
      * @return array
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Select_Exception
      * @throws Zend_Exception
      */
     public function fetchProjectsByFilter($inputFilterParams, $limit = null, $offset = null)
     {
         $cacheName = __FUNCTION__ . '_' . md5(serialize($inputFilterParams) . (string)$limit . (string)$offset);
         /** @var Zend_Cache_Core $cache */
         $cache = Zend_Registry::get('cache');
 
         if (false === ($returnValue = $cache->load($cacheName))) {
             $statement = $this->generateStatement($inputFilterParams, $limit, $offset);
             /** @var Zend_Db_Table_Rowset $fetchedElements */
             $fetchedElements = $this->fetchAll($statement);
 
             $statement->reset('limitcount')->reset('limitoffset');
             $statement->reset('columns')->columns(array('count' => new Zend_Db_Expr('count(*)')));
             $countElements = $this->fetchRow($statement);
             $returnValue = array('elements' => $fetchedElements, 'total_count' => $countElements->count);
 
             $cache->save($returnValue, $cacheName, array(), 120);
         }
 
         return $returnValue;
     }
 
     /**
      * @param array    $inputFilterParams
      * @param int|null $limit
      * @param int|null $offset
      *
      * @return Zend_Db_Select
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     protected function generateStatement($inputFilterParams, $limit = null, $offset = null)
     {
         $statement = $this->generateBaseStatement();
         $statement = $this->generateCategoryFilter($statement, $inputFilterParams);
         $statement = $this->generateOrderFilter($statement, $inputFilterParams);
         $statement = $this->generatePackageTypeFilter($statement, $inputFilterParams);
         $statement = $this->generateOriginalFilter($statement, $inputFilterParams);
         $statement = $this->generateReportedSpamFilter($statement);
 
         $statement->limit($limit, $offset);
 
         return $statement;
     }
 
     /**
      * @return Zend_Db_Select
      */
     protected function generateBaseStatement()
     {
         $statement = $this->select()->setIntegrityCheck(false);
         //$statement->from(array('project' => $this->_name), array(
         $statement->from(array('project' => 'stat_projects'), array(
             '*'
         ));
         $statement->where('project.status = ?', self::PROJECT_ACTIVE)->where('project.type_id=?', self::PROJECT_TYPE_STANDARD);
 
         return $statement;
     }
 
     /**
      * @param Zend_Db_Select $statement
      * @param array          $filterArrayValue
      *
      * @return Zend_Db_Select
      * @throws Zend_Cache_Exception
      * @throws Zend_Db_Statement_Exception
      */
     protected function generateCategoryFilter(Zend_Db_Select $statement, $filterArrayValue)
     {
         if (false == isset($filterArrayValue[self::FILTER_NAME_CATEGORY])) {
             return $statement;
         }
 
         $filter = $filterArrayValue[self::FILTER_NAME_CATEGORY];
 
         if (false === is_array($filter)) {
             $filter = array($filter);
         }
 
         // fetch child elements for each category
         $modelProjectCategories = new Default_Model_DbTable_ProjectCategory();
         $childElements = $modelProjectCategories->fetchChildIds($filter);
         $allCategories = array_unique(array_merge($filter, $childElements));
         $stringCategories = implode(',', $allCategories);
 
         $statement->where("(
         		project.project_category_id IN ({$stringCategories})
         		)");
 
         return $statement;
     }
 
     /**
      * @param Zend_Db_Select $statement
      * @param array          $filterArrayValue
      *
      * @return Zend_Db_Select
      */
     protected function generateOrderFilter(Zend_Db_Select $statement, $filterArrayValue)
     {
         if (!isset($filterArrayValue[self::FILTER_NAME_ORDER])) {
             $filterValue = '';
         } else {
             $filterValue = $filterArrayValue[self::FILTER_NAME_ORDER];
         }
         switch ($filterValue) {
             case 'latest':
                 $statement->order('project.changed_at DESC');
                 break;
 
             case 'top':
                 //$statement->order(array('amount_received DESC', 'count_plings DESC', 'latest_pling DESC', 'project.created_at DESC'));
                 //$statement->order(array(new Zend_Db_Expr('(round(((count_likes + 6) / ((count_likes + count_dislikes) + 12)),2) * 100) DESC'),'amount_received DESC', 'count_plings DESC', 'latest_pling DESC', 'project.created_at DESC'));
                 $statement->order(array(
                     new Zend_Db_Expr('(round(((count_likes + 6) / ((count_likes + count_dislikes) + 12)),2) * 100) DESC'),
                     'project.created_at DESC'
                 ));
 
                 break;
 
             case 'download':
                 $statement->order('project.count_downloads_hive DESC');
                 break;
             case 'downloadQuarter':
                 $statement->order('project.count_downloads_quarter DESC');
                 break;
 
             case 'hot':
                 //$statement->order(array('amount_received DESC', 'count_plings DESC', 'latest_pling DESC', 'project.created_at DESC'));
                 $statement->order(array(
                     new Zend_Db_Expr('(round(((count_likes + 6) / ((count_likes + count_dislikes) + 12)),2) * 100) DESC'),
                     'amount_received DESC',
                     'count_plings DESC',
                     'latest_pling DESC',
                     'project.created_at DESC'
                 ));
                 $statement->where(' project.created_at >= (NOW()- INTERVAL 14 DAY)');
                 break;
 
             case 'alpha':
             default:
                 $statement->order('project.title');
         }
 
         return $statement;
     }
 
     /**
      * @param Zend_Db_Select $statement
      * @param array          $filterArrayValue
      *
      * @return Zend_Db_Select
      */
     protected function generateOriginalFilter(Zend_Db_Select $statement, $filterArrayValue)
     {
         if (false == isset($filterArrayValue[self::FILTER_NAME_ORIGINAL])) {
             return $statement;
         }
 
         $filter = $filterArrayValue[self::FILTER_NAME_ORIGINAL];
 
         if (is_array($filter)) {
             // todo maybe for other tags filter
         } else {
             $statement->where('find_in_set(?, tags)', $filter);
         }
 
         return $statement;
     }
 
     /**
      * @param Zend_Db_Select $statement
      *
      * @return Zend_Db_Select
      */
     protected function generateReportedSpamFilter(Zend_Db_Select $statement)
     {
         return $statement->where('(amount_reports is null)');
     }
 
     /**
      * @param int    $member_id
      * @param array  $values
      * @param string $username
      *
      * @return Zend_Db_Table_Row_Abstract
      * @throws Exception
      * @throws Zend_Db_Table_Exception
      */
     public function createProject($member_id, $values, $username)
     {
         $values = (array)$values;
         if (empty($member_id)) {
             throw new Zend_Db_Table_Exception('member_id is not set');
         }
         if (empty($username)) {
             throw new Zend_Db_Table_Exception('username is not set');
         }
         // check important values for a new project
         $values['uuid'] = (!array_key_exists('uuid', $values)) ? Local_Tools_UUID::generateUUID() : $values['uuid'];
         $values['member_id'] = (!array_key_exists('member_id', $values)) ? $member_id : $values['member_id'];
         $values['status'] = (!array_key_exists('status', $values)) ? self::PROJECT_INACTIVE : $values['status'];
         $values['type_id'] = (!array_key_exists('type_id', $values)) ? self::ITEM_TYPE_PRODUCT : $values['type_id'];
         $values['created_at'] = (!array_key_exists('created_at', $values)) ? new Zend_Db_Expr('NOW()') : $values['created_at'];
         $values['start_date'] = (!array_key_exists('start_date', $values)) ? new Zend_Db_Expr('NULL') : $values['start_date'];
         $values['creator_id'] = (!array_key_exists('creator_id', $values)) ? $member_id : $values['creator_id'];
 
         if ($username == 'pling editor') {
             $values['claimable'] = (!array_key_exists('claimable', $values)) ? self::PROJECT_CLAIMABLE : $values['claimable'];
         }
 
         $savedRow = $this->save($values);
 
         return $savedRow;
     }
 
     /**
      * @param int   $project_id
      * @param array $values
      *
      * @return Zend_Db_Table_Row_Abstract
      * @throws Exception
      * @throws Zend_Db_Table_Exception
      */
     public function updateProject($project_id, $values)
     {
         $values = (array)$values;
         $projectData = $this->find($project_id)->current();
         if (empty($projectData)) {
             throw new Zend_Db_Table_Exception('project_id not found');
         }
 
         $projectData->setFromArray($values)->save();
 
         return $projectData;
     }
 
     /**
      * @param int $member_id
      *
      * @return array|mixed
      */
     public function fetchMainProject($member_id)
     {
         $sql = "SELECT * FROM {$this->_name} WHERE type_id = :type AND member_id = :member";
 
         //        $this->_db->getProfiler()->setEnabled(true);
         $result = $this->_db->fetchRow($sql, array('type' => self::PROJECT_TYPE_PERSONAL, 'member' => (int)$member_id));
         //        $dummy = $this->_db->getProfiler()->getLastQueryProfile()->getQuery();
         //        $this->_db->getProfiler()->setEnabled(true);
 
         if (count($result) > 0) {
             return $result;
         } else {
             return array();
         }
     }
 
     /**
      * @param $project_id
      *
      * @return Zend_Db_Table_Row_Abstract
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchProductDataFromMV($project_id)
     {
         $sql = "SELECT * FROM `stat_projects` WHERE `project_id` = :project_id";
         $resultSet = $this->_db->query($sql, array('project_id' => $project_id))->fetch();
         if (false === $resultSet) {
             return $this->generateRowClass(array());
         }
 
         return $this->generateRowClass($resultSet);
     }
 
 
     /**
      * @return array
      */
     public function fetchGhnsExcludedProjects()
     {
         $sql = "
         	SELECT `p`.`project_id`, `p`.`title`, `l`.`member_id` AS `exclude_member_id`, `l`.`time` AS `exclude_time`, `m`.`username` AS `exclude_member_name` FROM `project` `p`
                 JOIN `activity_log` `l` ON `l`.`project_id` = `p`.`project_id` AND `l`.`activity_type_id` = 314
                 INNER JOIN `member` `m` ON `m`.`member_id` = `l`.`member_id`
                 WHERE `p`.`ghns_excluded` = 1
 
         ";
 
         $list = $this->_db->fetchAll($sql);
 
         return $list;
     }
 
+    public function getUserCreatingCategorys($member_id)
+    {
+        $sql = " select category1
+                   ,count(1) as cnt
+                   from
+                   (
+                      select 
+                       p.project_id,
+                       c.ancestor_path,
+                       c.title,                       
+                       SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_path, '|', 2),'|',-1) as category1
+                       
+                      from project p
+                      join stat_cat_tree c on p.project_category_id = c.project_category_id
+                      where p.status = 100
+                      and p.member_id = :member_id
+                      and p.type_id = 1
+                  )t group by category1
+                  order by cnt desc
+                  ";
+        $result = $this->_db->fetchAll($sql, array('member_id' => $member_id));
+        
+
+        return $result;       
+    }
 
     /**
      * @return array
      */
     public function getUserActiveProjects($member_id, $limit = null, $offset = null)
     {
         // for member me page
         $sql = "
                         SELECT
+                        SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_path, '|', 2),'|',-1) as cat1,
+                            SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_path, '|', 3),'|',-1) as cat2,
+                            SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_path, '|', 4),'|',-1) as cat3,
+                            SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_id_path, ',', 2),',',-1) as catid1,
+                            SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_id_path, ',', 3),',',-1) as catid2,
+                            SUBSTRING_INDEX(SUBSTRING_INDEX(ancestor_id_path, ',', 4),',',-1) as catid3,
                         `p`.`project_id`,
                         `p`.`title`,
                         `p`.`created_at`  AS `project_created_at`,
                         `p`.`changed_at` AS `project_changed_at`,
                         `p`.`count_likes`,
                         `p`.`count_dislikes`,
                         `p`.`laplace_score`,
                         `p`.`member_id`,
                         `p`.`cat_title` AS `catTitle`,
+                        `p`.`project_category_id`,    
                         `p`.`image_small`,
                         (SELECT count(1) FROM `project_plings` `l` WHERE `p`.`project_id` = `l`.`project_id` AND `l`.`is_deleted` = 0 AND `l`.`is_active` = 1 ) `countplings`
                         FROM `stat_projects` `p`
+                        join stat_cat_tree c on p.project_category_id = c.project_category_id
                         WHERE `p`.`status` =100
                         AND `p`.`member_id` = :member_id        
-                        ORDER BY `p`.`changed_at` DESC
+                        ORDER BY cat1, cat2, cat3,`p`.`changed_at` DESC
         ";
 
         if (isset($limit)) {
             $sql = $sql . ' limit ' . $limit;
         }
 
         if (isset($offset)) {
             $sql = $sql . ' offset ' . $offset;
         }
 
         $result = $this->_db->fetchAll($sql, array('member_id' => $member_id));
         if ($result) {
             return $this->generateRowClass($result);
         } else {
             return null;
         }
     }
 
+    // /**
+    //  * @return array
+    //  */
+    // public function getUserActiveProjects($member_id, $limit = null, $offset = null)
+    // {
+    //     // for member me page
+    //     $sql = "
+    //                     SELECT
+    //                     `p`.`project_id`,
+    //                     `p`.`title`,
+    //                     `p`.`created_at`  AS `project_created_at`,
+    //                     `p`.`changed_at` AS `project_changed_at`,
+    //                     `p`.`count_likes`,
+    //                     `p`.`count_dislikes`,
+    //                     `p`.`laplace_score`,
+    //                     `p`.`member_id`,
+    //                     `p`.`cat_title` AS `catTitle`,
+    //                     `p`.`image_small`,
+    //                     (SELECT count(1) FROM `project_plings` `l` WHERE `p`.`project_id` = `l`.`project_id` AND `l`.`is_deleted` = 0 AND `l`.`is_active` = 1 ) `countplings`
+    //                     FROM `stat_projects` `p`
+    //                     WHERE `p`.`status` =100
+    //                     AND `p`.`member_id` = :member_id        
+    //                     ORDER BY `p`.`changed_at` DESC
+    //     ";
+
+    //     if (isset($limit)) {
+    //         $sql = $sql . ' limit ' . $limit;
+    //     }
+
+    //     if (isset($offset)) {
+    //         $sql = $sql . ' offset ' . $offset;
+    //     }
+
+    //     $result = $this->_db->fetchAll($sql, array('member_id' => $member_id));
+    //     if ($result) {
+    //         return $this->generateRowClass($result);
+    //     } else {
+    //         return null;
+    //     }
+    // }
+
     /**
      * @param int      $member_id
      * @param int|null $limit
      * @param int|null $offset
      *
      * @return null|Zend_Db_Table_Row_Abstract
      */
     public function fetchAllFeaturedProjectsForMember($member_id, $limit = null, $offset = null)
     {
         // for member me page
         $sql = "
                           SELECT
                           `p`.`project_id`,
                           `p`.`title`,
                           `p`.`created_at`  AS `project_created_at`,
                           `p`.`changed_at` AS `project_changed_at`,
                           `p`.`count_likes`,
                           `p`.`count_dislikes`,
                           `p`.`laplace_score`,
                           `p`.`member_id`,
                           `p`.`cat_title` AS `catTitle`,
                           `p`.`image_small`,
                           (SELECT count(1) FROM `project_plings` `l` WHERE `p`.`project_id` = `l`.`project_id` AND `l`.`is_deleted` = 0 AND `l`.`is_active` = 1 ) `countplings`
                           FROM `stat_projects` `p`
                           WHERE `p`.`status` =100
                           AND `featured` = 1
                           AND `p`.`member_id` = :member_id        
                           ORDER BY `p`.`changed_at` DESC
           ";
 
         if (isset($limit)) {
             $sql = $sql . ' limit ' . $limit;
         }
 
         if (isset($offset)) {
             $sql = $sql . ' offset ' . $offset;
         }
 
         $result = $this->_db->fetchAll($sql, array('member_id' => $member_id));
         if ($result) {
             return $this->generateRowClass($result);
         } else {
             return null;
         }
     }
 
     /**
      * @param string   $orderby
      * @param int|null $limit
      * @param int|null $offset
      *
      * @return array
      */
     public function fetchDuplicatedSourceProjects($orderby = 'source_url asc', $limit = null, $offset = null)
     {
         $sql = "
             SELECT 
             `source_url`
             ,count(1) AS `cnt`,
             GROUP_CONCAT(`p`.`project_id` ORDER BY `p`.`created_at`) `pids`
             FROM `stat_projects_source_url` `p` 
             GROUP BY `source_url`
             HAVING count(1)>1         
        ";
         if (isset($orderby)) {
             $sql = $sql . '  order by ' . $orderby;
         }
 
         if (isset($limit)) {
             $sql .= ' limit ' . (int)$limit;
         }
 
         if (isset($offset)) {
             $sql .= ' offset ' . (int)$offset;
         }
         $result = $this->_db->fetchAll($sql);
 
         return $result;
     }
 
     /**
      * @return mixed
      */
     public function getTotalCountDuplicates()
     {
 
         $sql = "
           SELECT count(1) AS `cnt` FROM
           (
                       SELECT 
                        `source_url`
                        ,count(1) AS `cnt`,
                        GROUP_CONCAT(`p`.`project_id` ORDER BY `p`.`created_at`) `pids`
                        FROM `stat_projects_source_url` `p` 
                        GROUP BY `p`.`source_url`
                        HAVING count(1)>1 
           ) `a`  
       ";
         $result = $this->_db->fetchAll($sql);
 
         return $result[0]['cnt'];;
     }
 
     /**
      * @param string $source_url
      *
      * @return mixed
      */
     public function getCountSourceUrl($source_url)
     {
         $last = substr($source_url, -1);
         if ($last == '/') {
             $source_url = substr($source_url, 0, -1);
         }
         $sql = "
             SELECT count(1) AS `cnt` FROM 
             `stat_projects_source_url` `p`  
             WHERE `p`.`source_url`= :source_url        
       ";
         $result = $this->_db->fetchAll($sql, array('source_url' => $source_url));
 
         return $result[0]['cnt'];
     }
 
     /**
      * @param int $member_id
      *
      * @return mixed
      */
     public function getCountProjectsDuplicateSourceurl($member_id)
     {
 
         $sql = "
            SELECT count(1) AS `cnt`
            FROM
            (
               SELECT DISTINCT `p`.`source_url`
               ,(SELECT count(1) FROM `stat_projects_source_url` `pp` WHERE `pp`.`source_url`=`p`.`source_url`) `cnt` 
               FROM `stat_projects_source_url` `p` 
               WHERE `p`.`member_id` = :member_id 
            ) `t` WHERE `t`.`cnt`>1
       ";
         $result = $this->_db->fetchAll($sql, array('member_id' => $member_id));
 
         return $result[0]['cnt'];
     }
 
     /**
      * @param $ids
      *
      * @return Zend_Db_Table_Row_Abstract
      * @throws Zend_Db_Statement_Exception
      */
     public function fetchProjects($ids)
     {
         $sql = "SELECT * FROM stat_projects WHERE project_id in (" . $ids . ")";
         $resultSet = $this->_db->fetchAll($sql);
 
         return $this->generateRowSet($resultSet);
     }
 
     /**
      * @param $project_id
      * @return true/false
      * @throws Zend_Db_Statement_Exception
      */
     public function validateDeleteProjectFromSpam($project_id)
     {
       //produkt ist ueber 6 monate alt oder produkt hat ueber 5 kommentare oder produkt hat minimum 1 pling 
       // darf nicht gelöscht werden      
       $sql ='select count_comments
             ,created_at
             , (created_at+ INTERVAL 6 MONTH < NOW()) is_old
             ,(select count(1) from project_plings f where f.project_id = p.project_id and f.is_deleted = 0) plings
             FROM project p where project_id =:project_id';
       $result = $this->_db->fetchRow($sql, array(
                             'project_id'     => $project_id,          
             ));
 
       if($result['count_comments'] >5 || $result['is_old'] ==1 || $result['plings']>0)
       {
         return false;
       }      
       return true;
     }
 
 }
\ No newline at end of file
diff --git a/application/modules/default/models/StatDownload.php b/application/modules/default/models/StatDownload.php
index 1654e7a6c..e10de3d12 100644
--- a/application/modules/default/models/StatDownload.php
+++ b/application/modules/default/models/StatDownload.php
@@ -1,70 +1,86 @@
 <?php
 
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  *
  *    Created: 16.12.2016
  **/
 class Default_Model_StatDownload
 {
 
     public function getUserDownloads($member_id)
     {
         $sql = "
                 SELECT 
                     `member_dl_plings`.*,
                     CASE WHEN (SELECT count(1) AS `sum_plings` FROM `project_plings` `pp` WHERE `pp`.`project_id` = `member_dl_plings`.`project_id` AND `pp`.`is_deleted` = 0 AND `is_active` = 1 GROUP BY `pp`.`project_id`) > 0 THEN (SELECT count(1) AS `sum_plings` FROM `project_plings` `pp` WHERE `pp`.`project_id` = `member_dl_plings`.`project_id` AND `pp`.`is_deleted` = 0 AND `is_active` = 1 GROUP BY `pp`.`project_id`) + 1 ELSE 1 END AS `num_plings_now`,
                     `project`.`title`,
                     `project`.`image_small`,
                     `project_category`.`title` AS `cat_title`,
                     laplace_score(`project`.`count_likes`, `project`.`count_dislikes`)/100 AS `laplace_score`,
                     `member_payout`.`amount`,
                     `member_payout`.`status`,
                     `member_payout`.`payment_transaction_id`,
                     CASE WHEN `tag_object`.`tag_item_id` IS NULL THEN 1 ELSE 0 END AS `is_license_missing_now`,
                     CASE WHEN ((`project_category`.`source_required` = 1 AND `project`.`source_url` IS NOT NULL AND LENGTH(`project`.`source_url`) > 0) OR  (`project_category`.`source_required` = 0)) THEN 0 ELSE 1 END AS `is_source_missing_now`,
                     `project`.`pling_excluded` AS `is_pling_excluded_now`
                 FROM
                     `member_dl_plings`
                 STRAIGHT_JOIN
                     `project` ON `project`.`project_id` = `member_dl_plings`.`project_id`
                 STRAIGHT_JOIN 
                     `project_category` ON `project_category`.`project_category_id` = `member_dl_plings`.`project_category_id`
                 LEFT JOIN
                     `member_payout` ON `member_payout`.`member_id` = `member_dl_plings`.`member_id`
                         AND `member_payout`.`yearmonth` = `member_dl_plings`.`yearmonth`
                 LEFT JOIN `tag_object` ON `tag_object`.`tag_type_id` = 1 AND `tag_object`.`tag_group_id` = 7 AND `tag_object`.`is_deleted` = 0 AND `tag_object`.`tag_object_id` = `project`.`project_id`
                 WHERE
                     `member_dl_plings`.`member_id` = :member_id
                     
                 ORDER BY `member_dl_plings`.`yearmonth` DESC, `project_category`.`title`, `project`.`title`
             ";
         $result = Zend_Db_Table::getDefaultAdapter()->query($sql, array('member_id' => $member_id));
 
         if ($result->rowCount() > 0) {
             return $result->fetchAll();
         } else {
             return array();
 
         }
     }
 
+    public function getMonthEarn($member_id,$yyyymm)
+    {
+        $sql = " select sum(probably_payout_amount) amount
+               from member_dl_plings 
+               where member_id=:member_id
+               and yearmonth=:yyyymm 
+               and is_pling_excluded = 0 
+               and is_license_missing = 0";
+ 
+        $resultSet = Zend_Db_Table::getDefaultAdapter()->fetchAll($sql, array('member_id' => $member_id,'yyyymm' =>$yyyymm));
+        return array_pop($resultSet);    
+       
+        
+        
+    }
+
 
 }
\ No newline at end of file
diff --git a/application/modules/default/views/scripts/user/aboutme.phtml b/application/modules/default/views/scripts/user/aboutme.phtml
index 1dd56de9a..042ccb62e 100644
--- a/application/modules/default/views/scripts/user/aboutme.phtml
+++ b/application/modules/default/views/scripts/user/aboutme.phtml
@@ -1,596 +1,604 @@
 <?php
 /**
  *  ocs-webserver
  *
  *  Copyright 2016 by pling GmbH.
  *
  *    This file is part of ocs-webserver.
  *
  *    This program is free software: you can redistribute it and/or modify
  *    it under the terms of the GNU Affero General Public License as
  *    published by the Free Software Foundation, either version 3 of the
  *    License, or (at your option) any later version.
  *
  *    This program is distributed in the hope that it will be useful,
  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  *    GNU Affero General Public License for more details.
  *
  *    You should have received a copy of the GNU Affero General Public License
  *    along with this program.  If not, see <http://www.gnu.org/licenses/>.
  **/
 
 $helperBuildMemberUrl = new Default_View_Helper_BuildMemberUrl();
 $helperImage = new Default_View_Helper_Image();
 $helpTruncate = new Default_View_Helper_Truncate();
 $this->headTitle($this->member->username . ' - ' . $_SERVER['HTTP_HOST'], 'SET');
 $this->doctype(Zend_View_Helper_Doctype::XHTML1_RDFA);
 $desc=  isset($this->mainProject->description) ? nl2br(strip_tags($this->mainProject->description)): $this->member->username;
 $this->headMeta()->setName('description',
     $helpTruncate->truncate($desc, 200, '...', false, true));
 $this->headMeta()->setName('title',
     $this->member->username . ' - ' . $_SERVER['HTTP_HOST']);
 
 $this->headMeta()->appendProperty('og:url', $helperBuildMemberUrl->buildMemberUrl($this->member->username));
 $this->headMeta()->appendProperty('og:type', 'website');
 $this->headMeta()->appendProperty('og:title', $this->member->username);
 $this->headMeta()->appendProperty('og:description',
     $helpTruncate->truncate($desc, 200, '...', false, true));
 $this->headMeta()->appendProperty('og:image',
     $helperImage->Image($this->member->profile_image_url,array('width' => 110, 'height' => 110, 'crop' => 2)));
 
 
 $helperFetchMainCategories = new Default_View_Helper_FetchMainCategories();
 $helperRatingWidget = new Default_View_Helper_PrintRatingWidget();
 $categories = $helperFetchMainCategories->fetchMainCategories();
 $helperAddDefaultScheme = new Default_View_Helper_AddDefaultScheme();
 $helperBuildProductUrl = new Default_View_Helper_BuildProductUrl();
 $helperTruncate = new Default_View_Helper_Truncate();
 $helperImage = new Default_View_Helper_Image();
 $helperPrintDate = new Default_View_Helper_PrintDate();
 $textCountryCity = $this->member->city;
 $textCountryCity .= $this->member->country ? ', ' . $this->member->country : '';
 $helperMemberScore = new Default_View_Helper_FetchMemberScore();
 $isSupporter = $this->stat['donationIssupporter'];
 
 $url_gitlab = Zend_Registry::get('config')->settings->client->default->url_gitlab;
 $url_forum = Zend_Registry::get('config')->settings->client->default->url_forum;
 
 $memberProfile = $helperImage->Image($this->member->profile_image_url,array('width' => 110, 'height' => 110, 'crop' => 2));
 
 ?>
 <style type="text/css">
 /* ADD THIS TO CSS */
 div#preloaded-images {
    position: absolute;
    overflow: hidden;
    left: -9999px; 
    top: -9999px;
    height: 1px;
    width: 1px;
 }
 </style>
 <!-- ADD THIS TO XHTML -->
 <div id="preloaded-images">
    <img src="<?php echo $memberProfile?>" width="1" height="1" alt="Image 01" />
 </div>
 
     <main class="about-me-page">
 
         <section class="head-wrap">
 
             <!-- HEADER -->
 
             <section class="wrapper">
                 
  
                 <!-- banner -->
 
                 <section class="header">
 
                     <!-- about me summary -->
                     <div class="col-lg-4 col-md-4 col-sm-4 col-xs-12 summary" style=" padding-top:65px" >
                         <article class="well" style="width: 100%;">
                             <div class="about-title">
                                 <figure class="relative inline profile-image-container">
                                     <?php if( $isSupporter) { ?><span class="supporter-badge">S</span>                                                  
                                     <?php }?>                                                                        
                                     <img src="<?php echo $memberProfile ; ?>"
                                          alt="profile-image"
                                          width="110"
                                          height="110">
 
                                      <?php if( $this->member->roleId==Default_Model_DbTable_Member::ROLE_ID_MODERATOR) { ?>
                                             <div class="mod-badge">MODERATOR</div>                                                  
                                     <?php }?>
                                 </figure>
                                 
                                 <h1><span class="lightblue"><?php echo $this->member->username; ?></span>    
                                </h1>
                                 <?php if($this->member->firstname ) :?>
                                 <span class="glyphicon glyphicon-user"></span>
                                 <span class="text"><?php echo $this->member->firstname; ?>&nbsp;<?php echo $this->member->lastname; ?> </span>
                                 <?php endif; ?>
 
                                <?php if($textCountryCity):?>
                                 <span class="glyphicon glyphicon-map-marker"></span>
                                 <span class="text"><?php echo $textCountryCity ?></span>
                                <?php endif; ?>
 
                            
                             </div>
                             <div class="about-footer">                                                            
                              
                                
 
                             <div class="col-container" >
+                                <div class="details">
+
+                                    <?php 
+                                        echo $this->aboutmeUserInfo. ' '. $this->earnInfo;                                                                              
+                                    ?>
+                                    
+                                </div>
                             <div class="details stat" >
+
                                 <h3>Statistics</h3>
                                 <div  class="statContent" >
                                     <div class="row ">
                                        <span class="cnt"><?=$this->stat['cntProducts']?> </span> Products
                                     </div>
                                     <div class="row">
                                        <span class="cnt"><?=$this->stat['cntComments']?> </span> Comments
                                     </div>
 
                                    
                                     <div class="row">
                                        Plinged <span class="cnt"> <?=$this->stat['cntPlingsHeGave']?> </span>Products
                                     </div>
                                     <div class="row">
                                        Got <span class="cnt"> <?=$this->stat['cntPlingsHeGot']?> </span><img  src="/images/system/pling-btn-active.png" style="width:20px; height:20px" />
                                     </div>
                                
 
                                     <div class="row">
                                        Likes <span class="cnt"> <?=$this->stat['cntLikesHeGave']?> </span>Products
                                     </div>
                                     <div class="row">
                                        Got <span class="cnt"> <?=$this->stat['cntLikesHeGot']?> </span>Likes <i class="fa fa-heart" style="color:#8e44ad" aria-hidden="true"></i>
 
                                     </div>
                                    
                                   <?php 
                                       if($this->stat['donationMax'] !=null && !$isSupporter){ // inactive supporter
                                   ?>
                                    <div class="row">
                                      <span class="cnt">Inactive supporter since: <?=$helperPrintDate->printDate(date('Y-m-d H:i:s', strtotime($this->stat['donationMax'] . ' +1 year')))?></span> 
                                   </div>
                                   <?php } ?>
 
                                     <?php 
                                         if($isSupporter){
                                     ?>                                     
                                      <div class="row">                                     
                                        <span>Supporter since: <?=$helperPrintDate->printDate($this->stat['donationMin'])?> </span> 
                                     </div>
                                       <div class="row">                                     
                                        <span>Supporter until: <?=$helperPrintDate->printDate(date('Y-m-d H:i:s', strtotime($this->stat['donationMax'] . ' +1 year')))?> </span> 
                                     </div>                                     
                                     <?php } ?>
                                      <div class="row">                                     
                                        <span class="">Last time active : <?=$helperPrintDate->printDate($this->stat['userLastActiveTime'])?> </span> 
                                     </div>
                                      <div class="row">                                                                            
                                         <span class="text">Joined : <?=$helperPrintDate->printDate($this->member->created_at);?></span>                                       
                                     </div>
                                     
                                    
                                 </div>
                             </div>
                         </div>
 
                              
                             </div>
                             <?php
                             $helperUserRole = new Backend_View_Helper_UserRole();
                             $userRoleName = $helperUserRole->userRole();
                             ?>
 
                             <?php if (Default_Model_DbTable_MemberRole::ROLE_NAME_ADMIN == $userRoleName) : ?>
                                 <div class="pull-right">
                                 <span class="page-views">
                                 <a id="linktohive" target="_blank" href="http://cp1.hive01.com/usermanager/search.php?username=<?= $this->member->username ?>">link to hive</a>
                                 <a id="delete-this" href="/backend/user/delete?member_id=<?= $this->member->member_id ?>">delete user</a>
                                 </span>
                                 <br>
                                 <span class="page-views" style="color: red;">
                                     <input type="checkbox" id="pling-excluded-checkbox" <?php echo $this->member->pling_excluded == 1 ? ' checked=\'checked\' ' : ''; ?> />  user-pling-excluded
                                 </span>
                                 <script>
                                     $('#delete-this').on('click', function (event) {
 
                                         event.stopPropagation();
                                         var target = $(this).attr('href');
 
                                         $.ajax({
                                             url: target,
                                             success: function (results) {
                                                 alert('User deleted successfully');
                                             },
                                             error: function() {
                                                 alert('Service is temporarily unavailable.');
                                             }
                                         });
 
                                         return false;
                                     });
                                     
                                     
                                     $('#pling-excluded-checkbox').on('click', function (event) {
                                         event.stopPropagation();
                                         var status = 0;
                                         if (this.checked) {
                                             status = 1;
                                         } else {
                                             status = 0;
                                         }
 
                                         var target = "/backend/member/doexclude?member_id=<?= $this->member->member_id ?>&pling_excluded=" + status;
                                         $.ajax({
                                             url: target,
                                             success: function (results) {
                                                 if (status == 0) {
                                                     alert('Member was successfully included for plinging');
                                                     $('#pling-excluded-checkbox').prop("checked", false);
 
                                                 } else {
                                                     alert('Member was successfully excluded for plinging');
                                                     $('#pling-excluded-checkbox').prop("checked", true);
 
                                                 }
 
                                             },
                                             error: function () {
                                                 alert('Service is temporarily unavailable.');
                                             }
                                         });
 
                                         return false;
                                     });
                                 </script>
                                 </div>
                             <?php endif; ?>
                         </article>
                     </div>
                     <!-- /about me summary -->
 
                 </section>
 
                 <!-- /banner -->
 
             </section>
 
             <!-- /HEADER -->
 
         </section>
 
         <section class="body-wrap">
 
             <section class="wrapper">
                
 
                 <!-- PAGE BODY -->
 
                 <section class="product-page about-me full-width">
 
                     <!-- page content -->
 
                     <div class="col-md-8 col-lg-8 col-sm-8 col-xs-12 about-me-details">
 
                         <!-- tabs nav -->
                         <div class="pling-nav-tabs">
                         <ul class="nav nav-tabs" role="tablist">
                             <li role="presentation" class="active">
                                 <a href="#user-aboutme" data-toggle="tab" role="tab"  aria-controls="user-aboutme" >
                                     Products<?=($this->stat['cntProducts']>0?' ('.$this->stat['cntProducts'].') ':'')?>
                                 </a>
                             </li>
                             <?php if($this->stat['cntFProducts']>0){ ?>
                             <li role="presentation">
                                 <a href="#user-featuredproducts" data-toggle="tab" role="tab"  aria-controls="user-featuredproducts" >
                                     Featured<?=' ('.$this->stat['cntFProducts'].') '?>
                                 </a>
                             </li>
                             <?php }?>
                              
                             <li>
                                 <a href="#user-comments" data-toggle="tab" role="tab"  aria-controls="user-comments">
                                     Comments (<?=$this->comments->getTotalItemCount()?>)
                                 </a>
                             </li>
                             <?php if(count($this->rated)>0){ ?>
                             <li>
                                 <a href="#user-rated" data-toggle="tab" role="tab"  aria-controls="user-rated">
                                     Rated (<?=count($this->rated)?>)
                                 </a>
                             </li>
                             <?php } ?>
                              <?php if($this->likes->getTotalItemCount()>0){ ?>
                             <li>
                                 <a href="#user-favs" data-toggle="tab" role="tab"  aria-controls="user-favs">
                                     Favs (<?=$this->likes->getTotalItemCount()?>)
                                 </a>
                             </li>
                           <?php } ?>
 
                           <?php if( $this->plings->getTotalItemCount()>0){ ?>
                             <li>
                                 <a href="#user-plings" data-toggle="tab" role="tab"  aria-controls="user-plings">
                                     Plinged (<?=$this->plings->getTotalItemCount()?>)
                                 </a>
                             </li>
                           <?php } ?>
 
                           <?php if( $this->supportersplings->getTotalItemCount()>0){ ?>
                             <li>
                                 <a href="#supporters-plings" data-toggle="tab" role="tab"  aria-controls="supporters-plings">
                                     Supporters (<?=$this->supportersplings->getTotalItemCount()?>)
                                 </a>
                             </li>
                           <?php } ?>
                           
                         </ul>
                         </div>
                         <!-- /tabs nav -->
 
                         <!-- tab panels -->
 
                         <div class="tab-content">
 
                             <div role="tabpanel" class="tab-pane active" id="user-aboutme">
                                 <?php if ($this->userProducts) { ?>                                
                                      <div class="my-products-list" id="my-products-list">                                                                       
                                         <?php echo $this->render('user/partials/aboutme-products.phtml'); ?>                                       
                                     </div>
                                 <?php } ?>
                             </div>
 
                             <?php if($this->stat['cntFProducts']>0){ ?>
                                 <div role="tabpanel" class="tab-pane " id="user-featuredproducts">
                                     <?php 
                                            $this->userProducts = $this->userFeaturedProducts;
                                            $this->projectpage = 1;
                                            $this->total_records=0;
                                         if ($this->userProducts) { ?>                                
                                          <div class="my-products-list" id="my-products-list">                                                                       
                                             <?php echo $this->render('user/partials/aboutme-products.phtml'); ?>                                       
                                         </div>
                                     <?php } ?>
                                 </div>
                              <?php } ?>
    
                             <div  role="tabpanel" class="tab-pane " id="user-comments">                                    
                                   <?php echo $this->render('user/partials/loopMyComments.phtml'); ?>
                             </div>
 
                              <?php if($this->likes->getTotalItemCount()>0){ ?>
                             <div  role="tabpanel" class="tab-pane " id="user-favs">       
                                     <div class="my-fav-list">                                                                   
                                   <?php echo $this->render('user/partials/aboutme-likes.phtml'); ?>
                                   </div>
                             </div> 
                             <?php } ?>  
 
                             <?php if( $this->plings->getTotalItemCount()>0){ ?>
                             <div  role="tabpanel" class="tab-pane " id="user-plings">       
                                     <div class="my-fav-list">                                                                   
                                   <?php echo $this->render('user/partials/aboutme-plings.phtml'); ?>
                                   </div>
                             </div> 
                             <?php } ?>  
 
                             <?php if($this->supportersplings->getTotalItemCount()>0){ ?>
                             <div  role="tabpanel" class="tab-pane " id="supporters-plings">       
                                     <div class="my-fav-list">                                                                   
                                         <?php echo $this->render('user/partials/aboutme-supporters.phtml'); ?>       
                                   </div>
                             </div> 
                             <?php } ?>  
 
 
                              <?php if(count($this->rated)>0){ ?>
                             <div  role="tabpanel" class="tab-pane " id="user-rated">    
                                 <div class="my-fav-list">                               
                                   <?php echo $this->render('user/partials/loopRated.phtml'); ?>
                                   </div>                               
                             </div>                         
                             <?php } ?>
 
                         </div>
 
                         <!-- /tab panels -->
 
                     </div>
 
                     <!-- /page content -->
 
                     <!-- side bar -->
 
 
                     <aside class="col-md-4 col-lg-4 col-sm-4 col-xs-12">
                         <?php if(Zend_Auth::getInstance()->hasIdentity() AND Zend_Auth::getInstance()->getIdentity()->roleName == 'admin') { ?>
                         <?php 
                             $scoreArray= $helperMemberScore->fetchScore($this->member->member_id);
                         ?>
                         <div class="col-container">
                             <div class="well details about">
                                 <div>
                                     <span>Score: <?php echo $scoreArray['score']; ?> <div class="inline" style="margin-left:.2em;" data-placement="top" data-toggle="popover" title="Member Score" data-trigger="hover" data-html="true" data-content="The score is calculated from the following values:<br> <ul><li>Products: <?php echo $scoreArray['count_product'];?> * <?php echo $scoreArray['factor_prod'];?></li><li>Plings: <?php echo $scoreArray['count_pling'];?> * <?php echo $scoreArray['factor_pling'];?></li><li>Likes: <?php echo $scoreArray['count_like'];?> * <?php echo $scoreArray['factor_like'];?></li><li>Comments: <?php echo $scoreArray['count_comment'];?> * <?php echo $scoreArray['factor_comment'];?></li><li>Years of membership: <?php echo $scoreArray['count_years_membership'];?> * <?php echo $scoreArray['factor_year'];?></li><li>Spam-Reports: <?php echo $scoreArray['count_report_product_spam'];?> * <?php echo $scoreArray['factor_report_prod_spam'];?></li><li>Misuse-Reports: <?php echo $scoreArray['count_report_product_fraud'];?> * <?php echo $scoreArray['factor_report_prod_fraud'];?></li></ul>"><span class="glyphicon glyphicon-question-sign" aria-hidden="true"></span></div> </span>
                                 </div>
 
                                 <?php
                                 
                                     if($this->stat['cntDuplicateSourceurl']>0)
                                     {
                                         echo '<span>Duplicates: '.$this->stat['cntDuplicateSourceurl'].'</span>';
                                     }
                                     
                                     echo '<br/><span>Email adress: '.$this->member->mail.' </span>';
                                     echo '<br/><span>Paypal adress: '.$this->member->paypal_mail.' </span>';
                                                                        
                                 ?>
                             </div>
                         </div>
                         <?php } ?>
                         <div class="col-container">
                             <div class="well details about">
                                 <h3>About me</h3>
 
                                 <div>
                                     <?php echo isset($this->mainProject->description) ? nl2br(strip_tags($this->mainProject->description)): ''; ?>
                                 </div>
                             </div>
                         </div>
                       
                         <div class="col-container">
                             <div class="well details">
                                 <h3>Connected Acounts</h3>
 
                                 <div class="box-content">
 
                                     <div class="info-div">
                                         <div class="label">
                                             <img src="/images_sys/gitlab.png" class="accounts_icon">
                                         </div>
                                         <div class="text">
                                     
                                             <a href="<?= $url_gitlab ?>/<?php echo $this->member->username;?>">
                                             <span style="font-size: 16px; font-weight: normal;">
                                                 <?php 
                                                 $cntGitp = 0;
                                                 if(!empty($this->member->gitlab_user_id)) {
                                                 $gitlab = new Default_Model_Ocs_Gitlab();
                                                 $gitProjects = $gitlab->getUserProjects($this->member->gitlab_user_id);
                                                 $cntGitp = count($gitProjects);               
                                                 }
                                                 $gittext = $this->member->username . ' on git-opendesktop';
                                                 if($cntGitp>0){
                                                     $gittext = $gittext.' ('.$cntGitp.')';
                                                 }
                                                 echo $gittext;
                                                 ?> 
                                             </span>
                                             </a>
                                         </div>
                                     </div>
 
                                     <?php if (isset($this->member->link_github) && $this->member->link_github != ''): ?>
                                         <div class="github">
                                             <div class="label">                                               
                                                 <img src="/theme/flatui/img/email5.png" class="accounts_icon">
                                             </div>
                                             <div class="text">
                                                 <a href="<?php echo 'https://github.com/'.$this->member->link_github; ?>" target="_blank"><?php echo $this->member->link_github; ?></a>
                                             </diV>
                                         </div>
                                     <?php endif; ?>
 
                                      <?php if (false === empty($this->member->link_website)): ?>
                                         <div class="info-div">
                                             <div class="label">
                                                     <span class="glyphicon glyphicon-globe" style="color:#000"></span>
                                             </div>
                                             <div class="text">
                                            <a
                                                     href="<?php echo $helperAddDefaultScheme->addDefaultScheme($this->member->link_website); ?>"
                                                     target="_NEW"
                                                     title="<?php echo $helperAddDefaultScheme->addDefaultScheme($this->member->link_website); ?>"
                                                 ><?php echo $this->member->link_website; ?></a>
                                                 </div>
                                         </div>
                                     <?php endif; ?>
 
                                     <?php if (isset($this->member->link_facebook) && $this->member->link_facebook != ''):
                                         $helpFaceBookUrl = new Default_View_Helper_FacebookLink();
                                         $facebookLink = $helpFaceBookUrl->facebookLink($this->member->link_facebook);
                                         ?>
                                         <div class="facebook">
                                             <div class="label">
                                                 
                                                  <img src="/theme/flatui/img/email2.png" class="accounts_icon">
                                             </div>
                                             <div class="text">
                                                 <a href="<?php echo $facebookLink; ?>"><?php echo $helperTruncate->truncate($this->member->link_facebook,
                                                         50); ?></a>
                                             </div>
                                         </div>
                                     <?php endif; ?>
                                     <?php if (isset($this->member->link_twitter) && $this->member->link_twitter != ''):
                                         $helpTwitterLink = new Default_View_Helper_TwitterLink();
                                         $twitterLink = $helpTwitterLink->twitterLink($this->member->link_twitter);
                                         ?>
                                         <div class="twitter">
                                             <div class="label">
                                                
                                                 <img src="/theme/flatui/img/email3.png" class="accounts_icon">
                                             </div>
                                             <div class="text">
                                                 <a href="<?php echo $twitterLink; ?>"
                                                    target="_NEW"><?php echo $helperTruncate->truncate($this->member->link_twitter, 50); ?></a>
                                             </div>
                                         </div>
                                     <?php endif; ?>
                                     <?php if (isset($this->member->link_google) && $this->member->link_google != ''): 
                                     $helpTwitterLink = new Default_View_Helper_GoogleplusLink();
                                     $googleplusLink = $helpTwitterLink->googleplusLink($this->member->link_google);
                                     ?>
                                         <div class="google">
                                             <div class="label">
                                                
                                                 <img src="/theme/flatui/img/email4.png" class="accounts_icon">
                                             </div>
                                             <div class="text">
                                                 <a href="<?php echo $googleplusLink ?>"><?php echo $helperTruncate->truncate($this->member->link_google,
                                                         50); ?></a>
                                             </diV>
                                         </div>
                                     <?php endif; ?>
 
                                     
 
                                         <div class="email">
                                             <div class="label">
                                                
                                                 <img src="/theme/flatui/img/email.png" class="accounts_icon">
                                             </div>
                                             <div class="text">
                                                 <a href="<?= $url_forum ?>/u/<?=$this->member->username?>">Send Message</a>
                                             </diV>
                                         </div>
 
                                     
                                 </div>
                             </div>
                         </div>
                       
                          
                     </aside>
 
                     <!-- side bar -->
 
                 </section>
 
                 <!-- /PAGE BODY -->
 
             </section>
 
         </section>
 
           <div class="tooltip_templates" style="display: none">
             <span id="tooltip_content">
                 <i class="fa fa-spinner"></i>
             </span>
         </div>
     </main>
 <?php $this->inlineScript()->appendScript(
     '    $(document).ready(function(){
             InitActiveHashTab.setup();
             AboutMeMyProjectsPaging.setup();
             AboutMeMyProjectsPagingButton.setup();        
             TooltipUser.setup("tooltipuser","right");   
             $(\'[data-toggle="popover"]\').popover();
         });
     ');
 
diff --git a/application/modules/default/views/scripts/user/partials/aboutme-products.phtml b/application/modules/default/views/scripts/user/partials/aboutme-products.phtml
index 86fa88f0f..5ffa2d9d1 100644
--- a/application/modules/default/views/scripts/user/partials/aboutme-products.phtml
+++ b/application/modules/default/views/scripts/user/partials/aboutme-products.phtml
@@ -1,68 +1,92 @@
+
+<style type="text/css">
+    div.catgroupseperator
+    {
+        display: block;
+        width: 100%;
+        height: 20px;
+        background-color: red;
+    }
+
+</style>
 <?php
     $helperBuildProductUrl = new Default_View_Helper_BuildProductUrl();
     $helperImage = new Default_View_Helper_Image();
     $helperPrintDate = new Default_View_Helper_PrintDate();
     if($this->userProducts == null || count($this->userProducts)==0) return;
-    foreach ($this->userProducts as $product): ?>
+    $ix_last=0;
+    $ix_next=0;
+    $cat_last='';
+    $cat_next='';
+    foreach ($this->userProducts as $product): 
+
+            $catid= $product['project_category_id'];
+            if($catid!=$cat_last)
+            {
+               echo '<div class="catgroupseperator">'.$product['cat1'].'>>>>>>>>>'.$product['cat2'].'</div>';
+            }
+        ?>
         <div class="product mini-card col-lg-2 col-md-2 col-sm-3 col-xs-2">
             <div class="u-wrap">
                 <a href="<?= $helperBuildProductUrl->buildProductUrl($product['project_id'], '', null, true); ?>">
                     <figure>
                         <img src="<?php echo $helperImage->Image($product['image_small'], array('width' => 280, 'height' => 171)); ?>"
                              class="explore-product-image" width="101" height="81" />
                     </figure>
                     <div class="u-content">
                         <h3><?php echo $product['title']; ?></h3>
                         <span class="productCategory"> <?php echo $product['catTitle']; ?> </span>
 
                         <span class="productCategory" style="width: 100%; float: left;">
                             <?= $helperPrintDate->printDate($product['project_changed_at']) ?>
                         </span>
                     </div>
                 </a>
                 
                 <?php
                 if($product['countplings'] >0)
                 {
                 ?>
                 <div class="countplings"> <span class="num"><?=$product['countplings']?></span> <img src="/images/system/pling-btn-active.png"/> </div>
                 <?php 
                 }
                 ?>
                 
                 <?php
                 $this->widgetRating = new stdClass();
                 $this->widgetRating->project_id = $product['project_id'];
                 $this->widgetRating->laplace_score = $product['laplace_score'];
                 $this->widgetRating->count_likes = $product['count_likes'];
                 $this->widgetRating->count_dislikes = $product['count_dislikes'];
                 echo $this->render('partials/widgetRating.phtml'); ?>
             </div>
         </div>
- <?php endforeach; ?>
+ <?php 
+ $cat_last = $product['project_category_id'];
+endforeach; ?>
 
   <?php
         $total_pages = ceil($this->total_records / $this->pageLimit);                                                                                
         
         if($this->projectpage<$total_pages){
             echo '<button id="btnshowmoreproducts" data-page='.($this->projectpage+1).'>Show More</button>';
         }
         ?>
 
 
 <style type="text/css">
         .countplings 
         {
             position: absolute;
             bottom: 10px;
             left: 8px;
             font-size: 11px;
 
         }
         .countplings img
         {
             width: 20px;
             height: 20px;
         }
 
 </style>
\ No newline at end of file