Example #1
0
 public function modify_posting($event)
 {
     if ($event['mode'] == 'post' && !$event['forum_id']) {
         $forum_ary = array();
         $forum_read_ary = $this->auth->acl_getf('f_read');
         foreach ($forum_read_ary as $forum_id => $allowed) {
             if ($allowed['f_read'] && $this->auth->acl_get('f_post', $forum_id)) {
                 if (!$this->exclude_forum($forum_id, $this->config['newtopic_forum'])) {
                     continue;
                 }
                 $forum_ary[] = (int) $forum_id;
             }
         }
         if (sizeof($forum_ary)) {
             // Fetching topics of public forums
             $sql = 'SELECT forum_id, forum_name, forum_type FROM ' . FORUMS_TABLE . "\n\t\t\t\t\tWHERE " . $this->db->sql_in_set('forum_id', $forum_ary) . "\n\t\t\t\t\t\tAND forum_type != " . FORUM_LINK;
             $result = $this->db->sql_query($sql);
             $forumrow = $this->db->sql_fetchrowset($result);
             $this->db->sql_freeresult($result);
             $s_forum_options = '<select id="f" name="f" onchange="this.form.submit();">';
             foreach ($forumrow as $row) {
                 $s_forum_options .= '<option value="' . $row['forum_id'] . '"' . ($row['forum_id'] == $forum_id ? ' selected="selected"' : '') . '' . ($row['forum_type'] == FORUM_CAT ? ' disabled="disabled" class="disabled-option"' : '') . '>' . ($row['forum_type'] != FORUM_CAT ? '&nbsp;&nbsp;' : '') . $row['forum_name'] . '</option>';
                 $forum_id = $row['forum_type'] == FORUM_POST ? $row['forum_id'] : '';
             }
             $s_forum_options .= '</select>';
             $this->template->assign_vars(array('S_FORUM_OPTIONS' => $s_forum_options, 'S_FORUM_OPT_TRUE' => $forum_id ? true : false));
             $event['forum_id'] = $forum_id;
         }
     }
 }
Example #2
0
 public function viewtopic_modify_post_data($event)
 {
     $user_ids = array();
     $rowset = $event['rowset'];
     $post_list = $event['post_list'];
     // Получаем список пользователей
     for ($i = 0, $end = sizeof($post_list); $i < $end; ++$i) {
         if (!isset($rowset[$post_list[$i]])) {
             continue;
         }
         $row = $rowset[$post_list[$i]];
         $poster_id = $row['user_id'];
         // Исключаем гостей, скрытые/игнорируемые сообщения и повтор.
         if ($poster_id != ANONYMOUS && !$row['foe'] && !$row['hide_post'] && !in_array($poster_id, $user_ids)) {
             $user_ids[] = $poster_id;
             $this->medals_count[$poster_id] = 0;
             $this->nominated_medals[$poster_id] = false;
         }
         unset($rowset[$post_list[$i]]);
     }
     // Medals count and nominated
     if (sizeof($user_ids)) {
         $sql = "SELECT user_id, nominated\n\t\t\t\tFROM " . $this->tb_medals_awarded . "\n\t\t\t\tWHERE " . $this->db->sql_in_set('user_id', $user_ids);
         $m_result = $this->db->sql_query($sql);
         $has_perms = $this->user->data['user_type'] == USER_FOUNDER || $this->auth->acl_get('u_award_medals');
         while ($m_row = $this->db->sql_fetchrow($m_result)) {
             if ($has_perms && $m_row['nominated']) {
                 $this->nominated_medals[$m_row['user_id']] = true;
             } else {
                 if (!$m_row['nominated']) {
                     $this->medals_count[$m_row['user_id']]++;
                 }
             }
         }
         $this->db->sql_freeresult($m_result);
     }
 }
Example #3
0
    /**
     * Returns the users array
     */
    private function view_state()
    {
        switch ($this->config['wwh_sort_by']) {
            case 0:
            case 1:
                $sql_order_by = 'username_clean';
                break;
            case 4:
            case 5:
                $sql_order_by = 'user_id';
                break;
            case 2:
            case 3:
            default:
                $sql_order_by = 'wwh_lastpage';
                break;
        }
        $sql_ordering = $this->config['wwh_sort_by'] % 2 == 0 ? 'ASC' : 'DESC';
        // Let's try another method, to deny duplicate appearance of usernames.
        $user_id_ary = array();
        $sql = 'SELECT user_id, username, username_clean, user_colour, user_type, viewonline, wwh_lastpage, user_ip
			FROM  ' . WWH_TABLE . "\n\t\t\tORDER BY {$sql_order_by} {$sql_ordering}";
        $result = $this->db->sql_query($sql);
        $statrow = array();
        while ($row = $this->db->sql_fetchrow($result)) {
            if (!in_array($row['user_id'], $user_id_ary)) {
                if ($row['viewonline'] || $row['user_type'] == USER_IGNORE) {
                    if ($row['user_id'] != ANONYMOUS && ($this->config['wwh_disp_bots'] || $row['user_type'] != USER_IGNORE)) {
                        $user_id_ary[] = $row['user_id'];
                    }
                } else {
                    if ($this->config['wwh_disp_hidden'] && $this->auth->acl_get('u_viewonline')) {
                        $user_id_ary[] = $row['user_id'];
                    }
                }
                $statrow[] = $row;
            }
        }
        $this->db->sql_freeresult($result);
        return $statrow;
    }
Example #4
0
 public function medal_row($user_id)
 {
     $s_nominate = false;
     if ($this->auth->acl_get('u_nominate_medals') && $user_id != $this->user->data['user_id']) {
         $s_nominate = true;
     }
     $is_mod = $this->user->data['user_type'] == USER_FOUNDER || $this->auth->acl_get('u_award_medals') ? true : false;
     $uid = $bitfield = '';
     // will be modified by generate_text_for_storage
     $allow_bbcode = $allow_smilies = true;
     $allow_urls = false;
     $m_flags = '3';
     // 1 is bbcode, 2 is smiles, 4 is urls (add together to turn on more than one)
     //
     // Category
     //
     $sql = "SELECT id, name\n\t\t\tFROM " . $this->tb_medals_cats . "\n\t\t\tORDER BY order_id";
     if (!($result = $this->db->sql_query($sql))) {
         message_die(GENERAL_ERROR, 'Could not query medal categories list', '', __LINE__, __FILE__, $sql);
     }
     $category_rows = array();
     while ($row = $this->db->sql_fetchrow($result)) {
         $category_rows[] = $row;
     }
     $this->db->sql_freeresult($result);
     $sql = "SELECT m.medal_id, m.user_id\n\t\t\tFROM " . $this->tb_medals_awarded . " m\n\t\t\tWHERE m.user_id = {$user_id}\n\t\t\t\tAND m.nominated = 0";
     if ($result = $this->db->sql_query($sql)) {
         $medal_list = $this->db->sql_fetchrowset($result);
         $medal_count = count($medal_list);
         if ($medal_count) {
             $this->template->assign_block_vars('switch_display_medal', array());
             $this->template->assign_block_vars('switch_display_medal.medal', array('MEDAL_BUTTON' => '<input type="button" class="button2" onclick="hdr_toggle(\'toggle_medal\',\'medal_open_close\')" value="' . $this->user->lang['MEDALS_VIEW_BUTTON'] . '"/>'));
         }
     }
     $u_nominate = '';
     if ($s_nominate) {
         $u_nominate = $this->helper->route('bb3mobi_medals_controller', array('m' => 'nominate', 'u' => $user_id));
     }
     $u_can_award = '';
     if ($this->auth->acl_get('a_user') || $is_mod) {
         $u_can_award = $this->helper->route('bb3mobi_medals_controller', array('m' => 'award', 'u' => $user_id));
     }
     $this->template->assign_vars(array('USER_ID' => $user_id, 'U_NOMINATE' => $u_nominate, 'U_CAN_AWARD_MEDALS' => $u_can_award, 'L_USER_MEDAL' => $this->user->lang['MEDALS'], 'USER_MEDAL_COUNT' => $medal_count, 'L_MEDAL_INFORMATION' => $this->user->lang['MEDAL_INFORMATION'], 'L_MEDAL_NAME' => $this->user->lang['MEDAL'], 'L_MEDAL_DETAIL' => $this->user->lang['MEDAL_DETAIL']));
     for ($i = 0; $i < count($category_rows); $i++) {
         $cat_id = $category_rows[$i]['id'];
         $sql = "SELECT m.id, m.name, m.description, m.image, m.device, m.dynamic, m.parent,\n\t\t\t\t\t\tma.nominated_reason, ma.time, ma.awarder_id, ma.awarder_un, ma.awarder_color, ma.bbuid, ma.bitfield,\n\t\t\t\t\t\tc.id as cat_id, c.name as cat_name\n\t\t\t\t\tFROM " . $this->tb_medal . " m, " . $this->tb_medals_awarded . " ma, " . $this->tb_medals_cats . " c\n\t\t\t\t\tWHERE ma.user_id = {$user_id}\n\t\t\t\t\t\tAND m.parent = c.id\n\t\t\t\t\t\tAND m.id = ma.medal_id\n\t\t\t\t\t\tAND ma.nominated = 0\n\t\t\t\t\tORDER BY c.order_id, m.order_id, ma.time";
         if ($result = $this->db->sql_query($sql)) {
             $row = array();
             $rowset = array();
             $medal_time = $this->user->lang['AWARD_TIME'] . ':&nbsp;';
             $medal_reason = $this->user->lang['MEDAL_AWARD_REASON'] . ':&nbsp;';
             while ($row = $this->db->sql_fetchrow($result)) {
                 if (empty($rowset[$row['name']])) {
                     $rowset[$row['name']]['cat_id'] = $row['cat_id'];
                     $rowset[$row['name']]['cat_name'] = $row['cat_name'];
                     if (isset($rowset[$row['name']]['description'])) {
                         $rowset[$row['name']]['description'] .= $row['description'];
                     } else {
                         $rowset[$row['name']]['description'] = $row['description'];
                     }
                     $rowset[$row['name']]['image'] = $this->phpbb_root_path . 'images/medals/' . $row['image'];
                     $rowset[$row['name']]['device'] = $this->phpbb_root_path . 'images/medals/devices/' . $row['device'];
                     $rowset[$row['name']]['dynamic'] = $row['dynamic'];
                 }
                 $row['nominated_reason'] = $row['nominated_reason'] ? $row['nominated_reason'] : $lang['Medal_no_reason'];
                 $awarder_name = "";
                 if ($row['awarder_id']) {
                     $awarder_name = "<br />" . $this->user->lang['AWARDED_BY'] . ": " . get_username_string('full', $row['awarder_id'], $row['awarder_un'], $row['awarder_color'], $row['awarder_un']);
                 }
                 //generate_text_for_storage($row['nominated_reason'], $uid, $bitfield, $m_flags, $allow_bbcode, $allow_urls, $allow_smilies);
                 $reason = generate_text_for_display($row['nominated_reason'], $row['bbuid'], $row['bitfield'], $m_flags);
                 if (isset($rowset[$row['name']]['medal_issue'])) {
                     $rowset[$row['name']]['medal_issue'] .= $medal_time . $this->user->format_date($row['time']) . $awarder_name . '</td></tr><tr><td>' . $medal_reason . '<div class="content">' . $reason . '</div><hr />';
                 } else {
                     $rowset[$row['name']]['medal_issue'] = $medal_time . $this->user->format_date($row['time']) . $awarder_name . '</td></tr><tr><td>' . $medal_reason . '<div class="content">' . $reason . '</div><hr />';
                 }
                 if (isset($rowset[$row['name']]['medal_count'])) {
                     $rowset[$row['name']]['medal_count'] += '1';
                 } else {
                     $rowset[$row['name']]['medal_count'] = '1';
                 }
             }
             $medal_width = $this->config['medal_small_img_width'] ? ' width="' . $this->config['medal_small_img_width'] . '"' : '';
             $medal_height = $this->config['medal_small_img_ht'] ? ' height="' . $this->config['medal_small_img_ht'] . '"' : '';
             $medal_name = array();
             $data = array();
             //
             // Should we display this category/medal set?
             //
             $display_medal = 0;
             $numberofmedals = 0;
             $after_first_cat = 0;
             $newcat = 1;
             while (list($medal_name, $data) = @each($rowset)) {
                 if ($cat_id == $data['cat_id']) {
                     $display_medal = 1;
                 }
                 $display_across = $this->config['medal_profile_across'] ? $this->config['medal_profile_across'] : 5;
                 if ($numberofmedals == $display_across) {
                     $break = '<br />';
                     $numberofmedals = 0;
                 } else {
                     $break = '';
                 }
                 if (!empty($newcat) && !empty($after_first_cat)) {
                     $break = '<hr />&nbsp;';
                     $numberofmedals = 0;
                 }
                 $numberofmedals++;
                 if (!empty($display_medal)) {
                     if ($data['medal_count'] > 1) {
                         if ($data['dynamic']) {
                             $img_medals = $this->helper->route('bb3mobi_medals_controller', array('m' => 'mi', 'med' => $data['image'], 'd' => $data['device'] . '-' . ($data['medal_count'] - 1) . '.gif'));
                             $image = '<img src="' . $img_medals . '" alt="' . $medal_name . '" title="' . $medal_name . '" />';
                             $small_image = $break . '<img src="' . $img_medals . '" alt="' . $medal_name . '" title="' . $medal_name . '"' . $medal_width . $medal_height . ' />';
                         } else {
                             $cluster = '-' . $data['medal_count'];
                             $device_image = substr_replace($data['image'], $cluster, -4) . substr($data['image'], -4);
                             if (file_exists($device_image)) {
                                 $data['image'] = $device_image;
                             }
                             $image = '<img src="' . $data['image'] . '" alt="' . $medal_name . '" title="' . $medal_name . '" />';
                             $small_image = $break . '<img src="' . $data['image'] . '" alt="' . $medal_name . '" title="' . $medal_name . '"' . $medal_width . $medal_height . ' />';
                         }
                     } else {
                         $image = '<img src="' . $data['image'] . '" alt="' . $medal_name . '" title="' . $medal_name . '" />';
                         $small_image = $break . '<img src="' . $data['image'] . '" alt="' . $medal_name . '" title="' . $medal_name . '"' . $medal_width . $medal_height . ' />';
                     }
                     $this->template->assign_block_vars('switch_display_medal.details', array('ISMEDAL_CAT' => $newcat, 'MEDAL_CAT' => $data['cat_name'], 'MEDAL_NAME' => $medal_name, 'MEDAL_DESCRIPTION' => $data['description'], 'MEDAL_IMAGE' => $image, 'MEDAL_IMAGE_SMALL' => $small_image, 'MEDAL_ISSUE' => $data['medal_issue'], 'MEDAL_COUNT' => $this->user->lang['MEDAL_AMOUNT'] . ': ' . $data['medal_count']));
                     $display_medal = 0;
                     $newcat = 0;
                 } else {
                     // New category lets put an hr between
                     $newcat = 1;
                     $after_first_cat = 1;
                 }
             }
         }
     }
 }
Example #5
0
    /**
     * Fetching the user-list and putting the stuff into the template.
     */
    public function display()
    {
        $this->user->add_lang_ext('bb3mobi/washere', 'lang_wwh');
        if (!self::prune()) {
            // Error while purging the list, database is missing :-O
            $this->user->add_lang_ext('bb3mobi/washere', 'info_acp_wwh');
            return;
        }
        self::$count_guests = self::$count_bot = self::$count_reg = self::$count_hidden = self::$count_total = 0;
        $wwh_username_colour = $wwh_username = $wwh_username_full = $users_list = '';
        switch ($this->config['wwh_sort_by']) {
            case self::SORT_USERNAME_ASC:
            case self::SORT_USERNAME_DESC:
                $sql_order_by = 'username_clean';
                break;
            case self::SORT_USERID_ASC:
            case self::SORT_USERID_DESC:
                $sql_order_by = 'user_id';
                break;
            case self::SORT_LASTPAGE_ASC:
            case self::SORT_LASTPAGE_DESC:
            default:
                $sql_order_by = 'wwh_lastpage';
                break;
        }
        $sql_ordering = $this->config['wwh_sort_by'] % 2 == self::SORT_ASC ? 'ASC' : 'DESC';
        // Let's try another method, to deny duplicate appearance of usernames.
        $user_id_ary = array();
        $sql = 'SELECT user_id, username, username_clean, user_colour, user_type, viewonline, wwh_lastpage, user_ip
			FROM  ' . WWH_TABLE . "\n\t\t\tORDER BY {$sql_order_by} {$sql_ordering}";
        $result = $this->db->sql_query($sql);
        while ($row = $this->db->sql_fetchrow($result)) {
            if (!in_array($row['user_id'], $user_id_ary)) {
                $wwh_username_full = get_username_string($row['user_type'] == USER_IGNORE ? 'no_profile' : 'full', $row['user_id'], $row['username'], $row['user_colour']);
                $hover_time = $this->config['wwh_disp_time'] == '2' ? $this->user->lang['WHO_WAS_HERE_LATEST1'] . '&nbsp;' . $this->user->format_date($row['wwh_lastpage'], $this->config['wwh_disp_time_format']) . $this->user->lang['WHO_WAS_HERE_LATEST2'] : '';
                $hover_ip = $this->auth->acl_get('a_') && $this->config['wwh_disp_ip'] ? $this->user->lang['IP'] . ':&nbsp;' . $row['user_ip'] : '';
                $hover_info = $hover_time || $hover_ip ? ' title="' . $hover_time . ($hover_time && $hover_ip ? ' | ' : '') . $hover_ip . '"' : '';
                $disp_time = $this->config['wwh_disp_time'] == '1' ? '&nbsp;(' . $this->user->lang['WHO_WAS_HERE_LATEST1'] . '&nbsp;' . $this->user->format_date($row['wwh_lastpage'], $this->config['wwh_disp_time_format']) . $this->user->lang['WHO_WAS_HERE_LATEST2'] . ($hover_ip ? ' | ' . $hover_ip : '') . ')' : '';
                if ($row['viewonline'] || $row['user_type'] == USER_IGNORE) {
                    if ($row['user_id'] != ANONYMOUS && ($this->config['wwh_disp_bots'] || $row['user_type'] != USER_IGNORE)) {
                        $users_list .= $this->user->lang['COMMA_SEPARATOR'] . '<span' . $hover_info . '>' . $wwh_username_full . '</span>' . $disp_time;
                        $user_id_ary[] = $row['user_id'];
                    }
                } else {
                    if ($this->config['wwh_disp_hidden'] && $this->auth->acl_get('u_viewonline')) {
                        $users_list .= $this->user->lang['COMMA_SEPARATOR'] . '<em' . $hover_info . '>' . $wwh_username_full . '</em>' . $disp_time;
                        $user_id_ary[] = $row['user_id'];
                    }
                }
                // At the end let's count them =)
                if ($row['user_id'] == ANONYMOUS) {
                    self::$count_guests++;
                } else {
                    if ($row['user_type'] == USER_IGNORE) {
                        self::$count_bot++;
                        self::$ids_bot[] = (int) $row['user_id'];
                    } else {
                        if ($row['viewonline'] == 1) {
                            self::$count_reg++;
                            self::$ids_reg[] = (int) $row['user_id'];
                        } else {
                            self::$count_hidden++;
                            self::$ids_hidden[] = (int) $row['user_id'];
                        }
                    }
                }
                self::$count_total++;
            }
        }
        $users_list = utf8_substr($users_list, utf8_strlen($this->user->lang['COMMA_SEPARATOR']));
        if ($users_list == '') {
            // User list is empty.
            $users_list = $this->user->lang['NO_ONLINE_USERS'];
        }
        if (!$this->config['wwh_disp_bots']) {
            self::$count_total -= self::$count_bot;
        }
        if (!$this->config['wwh_disp_guests']) {
            self::$count_total -= self::$count_guests;
        }
        if (!$this->config['wwh_disp_hidden']) {
            self::$count_total -= self::$count_hidden;
        }
        // Need to update the record?
        if ($this->config['wwh_record_ips'] < self::$count_total) {
            $this->config->set('wwh_record_ips', self::$count_total, true);
            $this->config->set('wwh_record_time', time(), true);
        }
        // Disabled, see comment on the method itself.
        //self::log();
        $this->template->assign_vars(array('WHO_WAS_HERE_LIST' => $this->user->lang['USERS'] . ': ' . $users_list, 'WHO_WAS_HERE_TOTAL' => self::get_total_users_string($this->config['wwh_disp_hidden'], $this->config['wwh_disp_bots'], $this->config['wwh_disp_guests']), 'WHO_WAS_HERE_EXP' => self::get_explanation_string($this->config['wwh_version']), 'WHO_WAS_HERE_RECORD' => self::get_record_string($this->config['wwh_record'], $this->config['wwh_version'])));
    }