z929669

We are running 4.7.3.

Staff are excluded from the Reputation system but included in the Achievements system.

We aren't interested in the Badges component, so I'm using CSS to convert all badge counts to 'n/a', since '0' is incorrect.

The same is true for Reputation counts for staff (using CSS to change staff counts from '0' to 'n/a').

1. It would be great if there were more granularity to opt out of Badges apart from Ranks in the ACP > Achievements.
2. It would be great to default to 'n/a rather than '0' (or hide) by member for any opt-out counts related to those member groups.

3 hours ago, Jim M said:

Sorry, we would not provide a way to resolve this via the database but we can help you resolve any issues that are impacting you from doing this via the ACP.

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

No worries. This was resolved by rebuilding Achievements as you described

This is the solution (not your response above), so if you don't want to mark this post as a solution, you will need to repost it for posterity.

6 minutes ago, Jim M said:

I've combined your two topics here. Please see my previous reply above and, as mentioned, we'll need a specific example to look into this.

The specific example is provided in my last post. Here's a link to the data (be aware that staff don't participate in the rep system, so staff cards are missing from Most rep/Most content sections).

Nothing has been manually inflated, so the Leaderbboard > Top members > Most posts is significantly inflated for staff and deflated for members.

____________

EDIT: Use cases are TechAngel85 and z929669 (staff) and sheson and Neovalen (members)

2 hours ago, Jim M said:

If you have any UI, suggestions you're welcome to provide those in our Feature Suggestion forum. In short though, version 4 is radically different and technologically more sound with data than version 3 was so you should not have to do these recount tools or clear tools unless there is a specific need. If you are encountering an issue or have a question, it may be better for us to investigate what is happening here.

Since you pointed me to the rebuild function in this post, some of this is resolved for me. I do have a specific need related to this though. New topic posted for that.

I'm seeing inconsistent post counts among different sections of the leaderboard, and all are somewhat inconsistent with this data on hovercards and profiles for most members (particularly those having been in the community for a long time, like staff).

On leaderboard > "Top members", "Most reputation" and "Most content" appear to be consistent but different from "Most posts" (in some cases very different). Specifically, staff seem to have more post counts in "Most posts" than in the other sections, while the opposite tends to be the case for regular members.

Profiles, hovercards, and leaderboard "Most reputation" and "Most content" seem to be consistent, so the problem area seems to be "Most posts" on leaderboards. The data appear to be coming from a different source or using a different query.

I was hoping to find a recount/rebuild function to correct this in the ACP, but none of them seem to work (Achievements recount and Members > Member Profile > Posts > Recount > Recount for all members).

Thanks in advance

______________

EDIT: Thanks for merging this from the other topic. I forgot I had posted this one.

1 hour ago, Jim M said:

You will want to setup your Achievement rules, ranks, etc... then use the rebuild button in ACP -> Members -> Achievements -> Settings. 

Many thanks! ... I missed that rather prominent green button (probably because it's styled like the + Create buttons elsewhere in the ACP).

It worked

1 minute ago, Gary said:

Hi @z929669,

Thanks for highlighting this for us. I have forwarded this on to be looked at.

Thanks Gary!

Unless I'm missing something, it appears that the new Achievements system does not use/apply past data to current evals for members. It seems to start completely over from time of new implementation.

If so, this is very disappointing, because it should be completely avoidable using code and DB functionality. The data are there, so why not use it (or convert the relevant data on upgrade)?

Members with hundreds or thousands of points and posts with correct (new) rules in place are not getting Ranks with respect to past data.

Perhaps a proper recount/rebuild is needed? (though such admin tools are scantly available these days).

First of: Sorry to daisy-chain so many topics, but I am trying to keep them all distinct in hopes of addressing distinctly and others finding solutions/info more simply. After searching these forums for each of these topics or related, I gave up due to tangential relevance (or possibly terrible topic names and body strings)

________________________

It's very strange that the only way to recount/rebuild rep/post counts is via any member page by clicking "Recount for all members" only when recounting for that member. First, it's rare to recount for one member, and so admins just don't click it, since it's n/a to what we want to accomplish (recount/rebuild all data). We finally found it by complete accident and are all of us bewildered. It seems like purposeful obfuscation.

Why make it so tedious and difficult to find? The 3.x software had a much better system admin page with lots of useful tools DB. Why oh why remove these essential features and force us to more likely break the DB by working with it directly?

We are seeing inconsistent post counts on Leaderboards, Hovercards, and Member pages. These appear to be sourced from different DB tables/cols, or the storage may be bugged.

Specifically, the same member can show different 'POSTS' counts in the same Leaderboard among "Most Rep", "Most content", and "Most posts". And they can also be different on hovercards and profiles.

We have recounted posts/rep and rebuilt Leaderboards.

These appear throughout the ACP on inline settings (4.7.3) and signify a likely implementation bug. I have noticed it in 4.4.10 as well and assumed that it would be fixed by the update:

We are only using Ranks/points with Rules and not the badges piece.

Please assist with a way to remove Rule-Awarded Badges from the DB in a safe way, since I am unable to do this from the ACP for some reason. It's stuck on a few admin profiles and will cause questions.

OOtB Rules have been deleted and replaced with only points-aw2arding Rules.

Thanks

On 7/8/2022 at 2:45 AM, opentype said:

/snip

So far, from the 27,436 active clients you are the ONLY ONE who mentioned a clear need to make drastic changes to the core CSS files. So it is questionable to suggest that “many” will turn away, when you have no foundation whatsoever to say that. You are likely just claiming it to give your position more weight. 

I will mention it then. The IPS CSS has so many redundancies it isn't even funny. This change didn't impact me, since I do use custom.css, but in maintaining that implementation since IPB 2.x, it's been clear that the CSS is very hacky with many different people having worked on it in silos over the years. This is demonstrated by the frequent use of !important in the CSS definitions to override the otherwise ridiculously convoluted selectors that even the devs don't want to touch.

Now with talk of improving the CSS implementation, it's almost a certainty that my customizations will be broken in the future ... these past few 'upgrades' have come with many major downsides (e.g., the Topic Feed uselessness ... don't even get me started).

Such is the way of SAAS software: optimize the software for the devs and the non-technical customers whilst alienating the technical/power customers ... dumbing down the world.

12 minutes ago, z929669 said:

Just adding my two cents with a bit of context:

The cache was an issue. It was annoying. BUT, it was still very nice that I could use the Topic Feed widget to get a glimpse of the latest topic posts and actually link to the post rather than the OP. They didn't reflect 'read' status for a few minutes, but I can remember what I have clicked only seconds ago. The point is that it's helpful for them to reflect and link to unread posts with cache update time if my point check times are > my cache update times ... which they are. I check my forums once an hour or two on weekdays and a couple times a day on weekends.

The 'buggy' issue --which wasn't a bug at all (just n/a implementation)-- was only a small one. Linking to the topic OP ('upgrade' behavior)  obviates all convenience of the Topic Feed widget. It's redundant and useless real-estate wasted.

I will stop enabling this widget if IPS doesn't appreciate its value and refuses to implement a solution that re-applies this functionality. Using a third-party plugin to handle expected behavior is detrimental to potentially all customers at update time.

EDIT: I should also note that this functionality is just as nice for the user as it is for an administrator. It has less value to those that compulsively use and re-use the Topic Feed info, but it still has value to all.

On 8/11/2021 at 8:46 AM, Daniel F said:

It didn't because of the cache.
Let's say the first visitor after the widget cache was truncated has all topics shown as unread.Since he's the first visitor his output will be cached and returned to literally any visitor having the same theme, language and groups and even if these members have no unread topics, the widget would show them as unread!

 

Just adding my two cents with a bit of context:

The cache was an issue. It was annoying. BUT, it was still very nice that I could use the Topic Feed widget to get a glimpse of the latest topic posts and actually link to the post rather than the OP. They didn't reflect 'read' status for a few minutes, but I can remember what I have clicked only seconds ago. The point is that it's helpful for them to reflect and link to unread posts with cache update time if my point check times are > my cache update times ... which they are. I check my forums once an hour or two on weekdays and a couple times a day on weekends.

The 'buggy' issue --which wasn't a bug at all (just n/a implementation)-- was only a small one. Linking to the topic OP ('upgrade' behavior)  obviates all convenience of the Topic Feed widget. It's redundant and useless real-estate wasted.

I will stop enabling this widget if IPS doesn't appreciate its value and refuses to implement a solution that re-applies this functionality. Using a third-party plugin to handle expected behavior is detrimental to potentially all customers at update time.

Just upgraded system (we only use Forums) to v 4.7.3 from 4.4.10.

The Topic Feed provides a list of topics with recent posts in the right margin of the forum top level.

In previous version, Topic Feed titles were bolded to indicate unread posts in the topic (just like in forum topic lists) and the bolded links directed user to the first unread post on the topic. After the update, these topic links are not bolded and point the user to the topic OP.

This isn't useful and obviates the usefulness of the Topic Feed widget/block. Is there something I'm missing here? Perhaps a new ACP setting? The Topic Feed Block Manager settings do not have anything related to this behavior.

On 9/16/2022 at 3:30 PM, z929669 said:

@Makoto

We finally upgraded from IPS 4.4.10 to current and RT from 1.8.1 to current, but the copy settings functions still don't work. This is pretty important to us and one reason why we wanted to upgrade IPS:

Can anyone else reproduce this issue? My query remains unanswered. Thanks

Thanks for the info. Bummer, but will do

May I have the IP address ranges that IPS services will use during upgrade? I want to redirect all IPs but my own and IPS upgrade to a maintenance page while I perform the upgrade.

A couple years ago, I had used the following. I'd appreciate confirmation or update:

### IPS support
#allow 67.227.215.137;
#allow 50.28.55.154;
#allow 50.28.75.104;

Thanks in advance.

@Makoto

We finally upgraded from IPS 4.4.10 to current and RT from 1.8.1 to current, but the copy settings functions still don't work. This is pretty important to us and one reason why we wanted to upgrade IPS:

EDIT: Fixed by replacing NULL values for tag_text with 'null' string in core_tags, so the question is why the tags were nullified.

Need help with the following error. I have a NULL tag(s) somehow I suspect and want to know how I can get around it. This one prevents me from displaying my forum base page (due to widget error):

TypeError: Argument 1 passed to IPS\radtags\Tag\_TagFactory::getTag() must be of the type string, null given, called in /srv/sites/_forum/applications/radtags/widgets/tagCloud.php on line 80 (0)
#0 /srv/sites/_forum/applications/radtags/widgets/tagCloud.php(80): IPS\radtags\Tag\_TagFactory->getTag()
#1 /srv/sites/_forum/system/Widget/Widget.php(103): IPS\radtags\widgets\_tagCloud->init()
#2 /srv/sites/_forum/system/Widget/StaticCache.php(41): IPS\_Widget->__construct()
#3 /srv/sites/_forum/system/Widget/Widget.php(296): IPS\Widget\_StaticCache->__construct()
#4 /srv/sites/_forum/system/Dispatcher/Front.php(561): IPS\_Widget::load()
#5 /srv/sites/_forum/system/Dispatcher/Dispatcher.php(154): IPS\Dispatcher\_Front->finish()
#6 /srv/sites/_forum/index.php(13): IPS\_Dispatcher->run()
#7 {main}

Relevant code for first one:
 

    public function init()
    {
        parent::init();
        \IPS\Output::i()->cssFiles = \array_merge( \IPS\Output::i()->cssFiles, \IPS\Theme::i()->css( 'jqcloud.css', 'radtags', 'global' ) );
        \IPS\Output::i()->jsFiles[] = (string) \IPS\Theme::i()->resource( 'js/jqcloud.min.js', 'radtags', 'interface' );

        $tagCount        = $this->configuration['radtags_tagCloud_count']       ?? 25;
        $appFilter       = $this->configuration['radtags_tagCloud_appFilter']   ?? NULL;
        $includePrefixes = $this->configuration['radtags_tagCloud_prefixes']    ?? TRUE;
        $colorful        = $this->configuration['radtags_tagCloud_colorful']    ?? FALSE;
        $filtered        = \iterator_to_array(
            \IPS\Db::i()->select(
                \IPS\radtags\Tag::$databasePrefix . 'name', \IPS\radtags\Tag::$databaseTable,
                [ \IPS\radtags\Tag::$databasePrefix . 'ignores_widgets' ]
            )
        );

        $tags = \IPS\radtags\Application::popularTags( $tagCount, $includePrefixes, $appFilter, (array)$filtered );
        $json = [];
        foreach ( $tags as $tag )
        {
            $config = [
                'text'      => $tag['tag_text'],
                'weight'    => $tag['count'],
                'link'      => (string) \IPS\Http\Url::internal( 'app=core&module=search&controller=search&tags=' . $tag['tag_text'], 'front', 'tags' ),
            ];

            if ( $colorful )
            {
                try
                {
                    $tag = \IPS\radtags\Tag\TagFactory::i()->getTag( $tag['tag_text'] );
                    if ( $tag->color )
                    {
                        $config['html'] = ['style' => "color: {$tag->color}"];
                    }
                }
                catch ( \OutOfRangeException $e ) {}
            }

            $json[] = $config;
        }

        \IPS\Output::i()->jsVars['radtags_tagCloud'] = $json;
        \IPS\Output::i()->jsVars['radtags_tagCloud_delay'] = $this->configuration['radtags_tagCloud_delay'] ?? 50;
    }

This one prevents me from sorting tags in the ACP:

TypeError: Argument 2 passed to IPS\radtags\Table\_Tags::parseRow() must be of the type string, null given, called in /srv/sites/_forum/applications/radtags/sources/Table/Tags.php on line 174 (0)
#0 /srv/sites/_forum/applications/radtags/sources/Table/Tags.php(174): IPS\radtags\Table\_Tags->parseRow()
#1 /srv/sites/_forum/system/Helpers/Table/Table.php(489): IPS\radtags\Table\_Tags->getRows()
#2 /srv/sites/_forum/applications/radtags/modules/admin/tags/listing.php(56): IPS\Helpers\Table\_Table->__toString()
#3 /srv/sites/_forum/system/Dispatcher/Controller.php(96): IPS\radtags\modules\admin\tags\_listing->manage()
#4 /srv/sites/_forum/applications/radtags/modules/admin/tags/listing.php(37): IPS\Dispatcher\_Controller->execute()
#5 /srv/sites/_forum/system/Dispatcher/Dispatcher.php(152): IPS\radtags\modules\admin\tags\_listing->execute()
#6 /srv/sites/_forum/admin/index.php(14): IPS\_Dispatcher->run()
#7 {main}

Relevant code for second one:
 

        /* Run query */
        $rows = [];
        $select = \IPS\Db::i()->select(
            ( \count( $this->selects ) ) ? $this->table . '.*, ' . implode( ', ', $this->selects ) : '*',
            $this->table,
            $where,
            $orderBy,
            array( ( $this->limit * ( $this->page - 1 ) ), $this->limit ),
            'tag_text'
        );

        if ( $this->keyField !== NULL )
        {
            $select->setKeyField( $this->keyField );
        }

        foreach ( $select as $rowId => $row )
        {
            /* Add in any 'custom' fields */
            $_row = $row;
            if ( $this->include !== NULL )
            {
                $row = array();
                foreach ( $this->include as $key )
                {
                    $row[ $key ] = isset( $_row[ $key ] ) ? $_row[ $key ] : NULL;
                }
            }

            /* Loop the data */
            foreach ( $row as $key => $value )
            {
                $value = $this->parseRow( $key, $value, $_row );

                /* Are we including this one? */
                if( ( $this->include !== NULL and !\in_array( $key, $this->include ) ) or ( $this->exclude !== NULL and \in_array( $key, $this->exclude ) ) )
                {
                    unset( $row[ $key ] );
                    continue;
                }

                /* Add to array */
                $row[ $key ] = $value;
            }

            $row['_buttons'] = $this->addRowButtons( $row );
            unset( $row['tag_id'] );

            $rows[ $rowId ] = $row;
        }

I only see acp_skin col, and it's NULL for every record in members table

Doh! missed it on page two of the col list ... thank you!

EDIT: If anyone else comes across this, here is a query (NULL means the member hasn't chosen a theme and are therefore using the default):
 

SELECT
name
,set_id
,set_name
FROM `core_members` m
inner join `core_themes` t on t.set_id=m.skin

and ...
 

SELECT count(*)
FROM `core_members` m
inner join `core_themes` t on t.set_id=m.skin
where set_id = 1

There doesn't seem to be a tool that provides usage statistics for themes. I have three themes and want to determine how frequently each is used by my members in order to validate continued support of each theme.

Does anyone know where this info might be in the database so that I can query for it? It MUST be in the DB either explicitly or implicitly, but it's not obvious.

Thanks!

EDIT: I don't think theme is 'remembered' solely using session/cookie data, because my last chosen theme is persistent across browsers, so it should be in the DB somewhere.

On 2/2/2021 at 4:23 PM, Makoto said:

Hey @z929669,

Sorry for missing your message. I do indeed have a 4.4 compatible release, though it doesn't receive feature updates anymore.

I can either provide you with this version that you can install manually or I can have a refund processed for you if you prefer.

Hey @Makoto,

Thanks for providing the 4.4-compliant version for me. Will you still be able to fix the "copy settings" functionality in the ACP for this app? We have hundreds of forums requiring various combinations of styled tags and prefixes. Without this function, it would take hundreds of hours adding it all, and it would no doubt be inconsistent. I'm dead in the water without this functionality.

Also, there seems to be no permissions for restricting use of prefixes independent of tags and neither can be restricted to use by specific groups ... unless I'm missing something?

44 minutes ago, Makoto said:

Hey @z929669,

Sorry for missing your message. I do indeed have a 4.4 compatible release, though it doesn't receive feature updates anymore.

I can either provide you with this version that you can install manually or I can have a refund processed for you if you prefer.

I would absolutely LOVE the 4.4 version please. No refund necessary if that's the case! I will upgrade to 4.5 eventually, but 4.4 will be just fine if Radical Tags for that version has all of the most meaningful features. Can you PM me a link?