/**
  * Returns a list of all available content languages.
  * 
  * @return	array
  */
 public static function getAvailableContentLanguages()
 {
     $availableLanguages = array();
     foreach (Language::getAvailableContentLanguages(PACKAGE_ID) as $language) {
         $availableLanguages[$language['languageID']] = WCF::getLanguage()->get('wcf.global.language.' . $language['languageCode']);
     }
     // sort languages
     StringUtil::sort($availableLanguages);
     return $availableLanguages;
 }
 /**
  * @see EventListener::execute()
  */
 public function execute($eventObj, $className, $eventName)
 {
     if (TEAM_SHOW_MODERATED_BOARDS) {
         if ($eventName == 'readData') {
             $eventObj->activeFields[] = 'moderatedBoards';
         } else {
             if ($eventName == 'assignVariables') {
                 require_once WBB_DIR . 'lib/data/board/Board.class.php';
                 // get user ids
                 $userIDArray = array_keys($eventObj->members);
                 if (count($userIDArray)) {
                     // get user to groups
                     $userToGroups = array();
                     $groupIDArray = array();
                     $sql = "SELECT\tuserID, groupID\n\t\t\t\t\t\tFROM\twcf" . WCF_N . "_user_to_groups\n\t\t\t\t\t\tWHERE\tuserID IN (" . implode(',', $userIDArray) . ")";
                     $result = WCF::getDB()->sendQuery($sql);
                     while ($row = WCF::getDB()->fetchArray($result)) {
                         if (!isset($userToGroups[$row['userID']])) {
                             $userToGroups[$row['userID']] = array();
                         }
                         $userToGroups[$row['userID']][] = $row['groupID'];
                         $groupIDArray[$row['groupID']] = $row['groupID'];
                     }
                     // get user to boards
                     $userToBoards = array();
                     $sql = "SELECT\tuserID, boardID\n\t\t\t\t\t\tFROM\twbb" . WBB_N . "_board_moderator\n\t\t\t\t\t\tWHERE\tuserID IN (" . implode(',', $userIDArray) . ")";
                     $result = WCF::getDB()->sendQuery($sql);
                     while ($row = WCF::getDB()->fetchArray($result)) {
                         if (!isset($userToBoards[$row['userID']])) {
                             $userToBoards[$row['userID']] = array();
                         }
                         $userToBoards[$row['userID']][] = $row['boardID'];
                     }
                     // get group to boards
                     $groupToBoards = array();
                     if (count($groupIDArray)) {
                         $sql = "SELECT\tgroupID, boardID\n\t\t\t\t\t\t\tFROM\twbb" . WBB_N . "_board_moderator\n\t\t\t\t\t\t\tWHERE\tgroupID IN (" . implode(',', $groupIDArray) . ")";
                         $result = WCF::getDB()->sendQuery($sql);
                         while ($row = WCF::getDB()->fetchArray($result)) {
                             if (!isset($groupToBoards[$row['groupID']])) {
                                 $groupToBoards[$row['groupID']] = array();
                             }
                             $groupToBoards[$row['groupID']][] = $row['boardID'];
                         }
                     }
                     foreach ($eventObj->members as $key => $memberData) {
                         // get board ids
                         $boardIDArray = array();
                         if (isset($userToBoards[$key])) {
                             $boardIDArray = $userToBoards[$key];
                         }
                         if (isset($userToGroups[$key])) {
                             foreach ($userToGroups[$key] as $groupID) {
                                 if (isset($groupToBoards[$groupID])) {
                                     $boardIDArray = array_merge($boardIDArray, $groupToBoards[$groupID]);
                                 }
                             }
                         }
                         // get boards and check permissions
                         array_unique($boardIDArray);
                         $boards = array();
                         foreach ($boardIDArray as $boardID) {
                             $board = Board::getBoard($boardID);
                             if ($board->getPermission('canViewBoard')) {
                                 $boards[$board->boardID] = WCF::getLanguage()->get(StringUtil::encodeHTML($board->title));
                             }
                         }
                         if (count($boards)) {
                             // sort boards
                             StringUtil::sort($boards);
                             // generate output
                             $output = '';
                             foreach ($boards as $boardID => $title) {
                                 if (!empty($output)) {
                                     $output .= ', ';
                                 }
                                 $output .= '<a href="index.php?page=Board&amp;boardID=' . $boardID . SID_ARG_2ND . '">' . $title . '</a>';
                             }
                             $eventObj->members[$key]['moderatedBoards'] = $output;
                         }
                     }
                 }
             }
         }
     }
 }
Ejemplo n.º 3
0
 protected function getSortedByNames()
 {
     $names = $this->lastOnlineByName = array();
     foreach ($this->lastOnline as $key => $row) {
         $names[$key] = $row['plainname'];
     }
     StringUtil::sort($names);
     foreach ($names as $key => $row) {
         $this->lastOnlineByName[] = $this->lastOnline[$key];
     }
 }
 /**
  * @see Page::readData()
  */
 public function readData()
 {
     parent::readData();
     // boards
     $this->boardOptions = Board::getBoardSelect(array(), true, true);
     // language
     $this->languages = Language::getAvailableContentLanguages();
     foreach ($this->languages as $languageID => $language) {
         $this->languages[$languageID] = WCF::getLanguage()->get('wcf.global.language.' . $language['languageCode']);
     }
     StringUtil::sort($this->languages);
 }
Ejemplo n.º 5
0
 /**
  * Shows the page for choosing the installed languages.
  */
 protected function selectLanguages()
 {
     $errorField = $errorType = '';
     $allLanguages = $this->getAllLanguages();
     $illegalLanguages = array();
     // build visible language list
     $languages = array();
     foreach ($allLanguages as $languageCode) {
         $languages[$languageCode] = self::getLanguage()->get('wcf.global.language.' . $languageCode) . ' (' . $languageCode . ')';
     }
     // skip step in developer mode
     // select all available languages automatically
     if (self::$developerMode) {
         self::$selectedLanguages = array();
         foreach ($allLanguages as $languageCode) {
             if (Language::isSupported($languageCode)) {
                 self::$selectedLanguages[] = $languageCode;
             }
         }
         self::getTPL()->assign('selectedLanguages', self::$selectedLanguages);
         $this->gotoNextStep('configureDB');
         exit;
     }
     // sort languages
     StringUtil::sort($languages);
     // start error handling
     if (isset($_POST['send'])) {
         try {
             // no languages selected
             if (count(self::$selectedLanguages) == 0) {
                 throw new UserInputException('selectedLanguages');
             }
             // illegal selection
             // language is not available in the active charset
             foreach (self::$selectedLanguages as $language) {
                 if (!Language::isSupported($language)) {
                     $illegalLanguages[] = $language;
                 }
             }
             if (count($illegalLanguages) > 0) {
                 throw new UserInputException('selectedLanguages', 'notAvailable');
             }
             // no errors
             // go to next step
             $this->gotoNextStep('configureDB');
             exit;
         } catch (UserInputException $e) {
             $errorField = $e->getField();
             $errorType = $e->getType();
         }
     } else {
         self::$selectedLanguages[] = self::$selectedLanguageCode;
         WCF::getTPL()->assign('selectedLanguages', self::$selectedLanguages);
     }
     WCF::getTPL()->assign(array('illegalLanguages' => $illegalLanguages, 'errorField' => $errorField, 'errorType' => $errorType, 'charsets' => Language::$supportedCharsets, 'languages' => $languages, 'disableMultiByte' => !extension_loaded('mbstring'), 'nextStep' => 'selectLanguages'));
     WCF::getTPL()->display('stepSelectLanguages');
 }
Ejemplo n.º 6
0
 /**
  * @see Page::readData()
  */
 public function readData()
 {
     parent::readData();
     // get profile options
     require_once WCF_DIR . 'lib/data/user/option/UserOptions.class.php';
     $userOptions = new UserOptions();
     $this->categories = $userOptions->getOptionTree('profile', $this->frame->getUser());
     // move contact information and about me
     foreach ($this->categories as $category => $categoryData) {
         if ($category == 'profile.contact' || $category == 'profile.messenger') {
             foreach ($categoryData['options'] as $key => $option) {
                 if (isset($option['outputData'])) {
                     $this->contactInformation[] = $option['outputData'];
                 } else {
                     if (!empty($option['optionValue']) && (empty($option['outputClass']) || !$userOptions->getOutputObject($option['outputClass']) instanceof UserOptionOutputContactInformation)) {
                         $this->contactInformation[] = array('icon' => '', 'title' => WCF::getLanguage()->get('wcf.user.option.' . $option['optionName']), 'value' => $option['optionValue'], 'url' => '');
                     }
                 }
             }
             unset($this->categories[$category]);
         }
     }
     // add vcard link
     $this->contactInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('vCardM.png'), 'title' => WCF::getLanguage()->get('wcf.user.profile.downloadVCard'), 'value' => StringUtil::encodeHTML($this->frame->getUser()->username), 'url' => 'index.php?page=VCard&amp;userID=' . $this->frame->getUserID() . SID_ARG_2ND);
     // add general informations
     // registration date
     $this->generalInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('registerM.png'), 'title' => WCF::getLanguage()->get('wcf.user.registrationDate'), 'value' => DateUtil::formatTime(null, $this->frame->getUser()->registrationDate));
     // languages
     require_once WCF_DIR . 'lib/acp/form/UserOptionListForm.class.php';
     $languages = array();
     $availableLanguages = UserOptionListForm::getAvailableContentLanguages();
     if (!$this->frame->getUser()->languageIDs) {
         $this->languages = $availableLanguages;
     } else {
         $languageIDs = explode(',', $this->frame->getUser()->languageIDs);
         foreach ($languageIDs as $languageID) {
             if (isset($availableLanguages[$languageID])) {
                 $languages[$languageID] = $availableLanguages[$languageID];
             }
         }
         // sort languages
         StringUtil::sort($languages);
     }
     if (count($languages)) {
         $this->generalInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('languageM.png'), 'title' => WCF::getLanguage()->get('wcf.user.profile.languages'), 'value' => implode(', ', $languages));
     }
     // last activity
     if (!$this->frame->getUser()->isOnline() && (!$this->frame->getUser()->invisible || WCF::getUser()->getPermission('admin.general.canViewInvisible')) && $this->frame->getUser()->lastActivityTime != 0) {
         $this->generalInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('offlineM.png'), 'title' => WCF::getLanguage()->get('wcf.user.lastActivity'), 'value' => DateUtil::formatTime(null, $this->frame->getUser()->lastActivityTime, true));
     }
     // profile visits
     WCF::getTPL()->assign('user', $this->frame->getUser());
     $this->generalInformation[] = array('icon' => StyleManager::getStyle()->getIconPath('visitsM.png'), 'title' => WCF::getLanguage()->get('wcf.user.profile.hits'), 'value' => StringUtil::formatNumeric($this->frame->getUser()->profileHits) . ($this->frame->getUser()->getProfileAge() > 1 ? ' ' . WCF::getLanguage()->getDynamicVariable('wcf.user.profile.hitsPerDay') : ''));
     // get profile visitors
     $sql = "SELECT\t\tavatar.*, user_table.*, visitor.*\n\t\t\tFROM\t\twcf" . WCF_N . "_user_profile_visitor visitor\n\t\t\tLEFT JOIN \twcf" . WCF_N . "_user user_table\n\t\t\tON \t\t(user_table.userID = visitor.userID)\n\t\t\tLEFT JOIN \twcf" . WCF_N . "_avatar avatar\n\t\t\tON \t\t(avatar.avatarID = user_table.avatarID)\n\t\t\tWHERE\t\townerID = " . $this->frame->getUserID() . "\n\t\t\t\t\tAND user_table.userID IS NOT NULL\n\t\t\tORDER BY\ttime DESC";
     $result = WCF::getDB()->sendQuery($sql, 5);
     while ($row = WCF::getDB()->fetchArray($result)) {
         $this->profileVisitors[] = new UserProfile(null, $row);
     }
     // friends
     if (MODULE_MEMBERS_LIST == 1 && $this->frame->getUser()->shareWhitelist) {
         $sql = "SELECT\t\tavatar.*, user_table.*\n\t\t\t\tFROM\t\twcf" . WCF_N . "_user_whitelist friends\n\t\t\t\tLEFT JOIN \twcf" . WCF_N . "_user user_table\n\t\t\t\tON \t\t(user_table.userID = friends.whiteUserID)\n\t\t\t\tLEFT JOIN \twcf" . WCF_N . "_avatar avatar\n\t\t\t\tON \t\t(avatar.avatarID = user_table.avatarID)\n\t\t\t\tWHERE\t\tfriends.userID = " . $this->frame->getUserID() . "\n\t\t\t\t\t\tAND confirmed = 1\n\t\t\t\t\t\tAND user_table.userID IS NOT NULL\n\t\t\t\tORDER BY\tfriends.time DESC";
         $result = WCF::getDB()->sendQuery($sql, 5);
         while ($row = WCF::getDB()->fetchArray($result)) {
             $this->friends[] = new UserProfile(null, $row);
         }
     }
 }
Ejemplo n.º 7
0
 /**
  * Returns a sorted list of all installed languages.
  * 
  * @return	array
  */
 public static function getLanguages()
 {
     $languages = array();
     foreach (self::$cache['languages'] as $languageID => $language) {
         $languages[$languageID] = WCF::getLanguage()->getDynamicVariable('wcf.global.language.' . $language['languageCode']);
     }
     StringUtil::sort($languages);
     return $languages;
 }